PensionPro is excited to announce its long-anticipated update to the Projects feature. Significant changes have been made behind the scenes, allowing us to better implement the enhancements most requested by our users. To ensure a smooth rollout, firms must currently choose to "opt in" to Projects 2.0. This article serves as a guide to the changes and new functionalities that firms using Projects 2.0 will encounter.
Article Contents:
Adding Project Templates
In Projects 2.0, the options for adding new Project Templates from scratch and importing Templates from an Excel workbook have been consolidated into a single multi-step tool to make the process more consistent. This new tool also includes the ability to choose one of several sample Project Templates and alter it to meet the requirements of the Project. This makes it easier to add new Project Templates to PensionPro without using a pre-made Excel workbook template.
To start, navigate to Maintenance > Templates to open the Project Templates tab as usual. From here, use one of the following options to open the Project Template Creation tool at Step 1:
- To create a new Project Template or start from a library template, select Add
at the top-right of the grid.
- To import a Project template from an Excel workbook, use More > Project Template Import.
Step 1: Options
The Project Template Creation tool will open at this step. Depending on the method used, the I want to dropdown will already be filled with one of the following options:
- Create a Project Template: This will walk the user through adding a new Project Template from scratch, or via a built-in sample Template.
- Import a Project Template: This allows a Project Template to be imported from an Excel workbook file.
If importing a Project Template: use the File Selection box to choose the workbook file, then continue on to the Mapping step below.
If creating a new Project Template, PensionPro will then ask if a library template should be used as a starting point. Select a template if desired, or leave the field blank to build a Project Template from scratch.
The remaining fields in this step collect the settings for the Project Template. Information on these fields is detailed in the article Project Templates.
Step 2: Mapping
The Mapping step may be required when importing an Excel workbook or using a library template. This step is used if PensionPro identifies a value in the source template that doesn't match any established system values, such as List Values. The following items are evaluated:
- Data Types
- Employee Plan Roles
- Events
- Project Fields
- Task Category
- Time Codes
- Worktrays
For example: If the Project Template contains a Task assigned the 5500 Filed Event, but this item does not exist in Event Configurations, it will be noted in the Mapping step.
Any items indicated as missing in the Mapping step will need to be resolved by one of the following methods:
- The missing item can be replaced with a value that is already present in the system; or,
- The missing value can be added at this time.
To replace the missing item with an existing value, select the desired value from the dropdown. Where possible, these dropdowns will also include a Create New option, which will add the missing item as a new value automatically when the tool is executed later on. An Automatically add all missing items option is also available, which acts like Create New but on a broader scale, applying to all items of a corresponding type.
In some cases, the Project Template Creation tool is unable to add new values directly. Instead, PensionPro will provide a link to the page where the item can be created. After adding the appropriate values, use the Refresh option at the top-right to remove any items that have been satisfied from the mapping list.
Once all missing items have been added to PensionPro or replaced with an existing value, use Next to move to the next step.
Steps 3 & 4: Review and Finish
The Review step displays the details of the Project Template that will be created, as well as the resolution for any items that required mapping. Ensure that the information shown is accurate, then select Execute to apply the changes and create the Template.
Once complete, the Finish step displays a summary of the changes. The Template Created field provides a link to the new Project Template, where the Project's workflow can be edited and any other revisions can be made.
Customizing Data Collection
One of the major goals for Projects 2.0 was allowing greater flexibility when it came to using Data Collection via PlanSponsorLink. To this end, a number of options are now available to add, remove, and rearrange Data Collection steps, dictate when Data Collection is performed in the Project workflow, and make it easier to manage questionnaires.
Mixing & Matching Data Collection Steps
Previously, Annual Administration and General Web Collection Projects utilized different Data Collection steps. While this made both types of Data Collection distinct, there were occasions when neither was a perfect solution for a particular problem. Now, Data Collection steps are no longer tied to a specific Project Type; for example, Annual Administration can make use of Collection Items & Deliverables, and General Web Collection can include the Employee Census step.
Firm-level management of these steps has also been simplified. Formerly, the Web Steps category of PlanSponsorLink Preferences—which allowed the instructions for each step to be edited—split out steps for both Annual Administration and General Web Collection. Now, all steps are combined under a single view, Data Collection Steps. As steps are no longer limited to just their Project Type, editing a step's details here will update it on all Projects where that step is in use.
An additional change on the Data Collection Steps view: one of the items that can be customized for each step is the Step Label. This is the text that appears below each icon in the list of steps the Plan Sponsor can refer to at the top of the screen as they perform Data Collection.
Configuring Data Collection in Workflow
Most of the new customization functionality is found in the Workflow view of the Project Template. The below list summarizes all the changes that have been made to Data Collection Tasks:
- Data Collection can now be located anywhere in the Project. Any number of Tasks can occur before and after Data Collection begins and ends.
- A Project is still limited to one uninterrupted Data Collection.
- All Data Collection Tasks must still be contained within the same Task Grouping, although this Grouping may now include other Tasks before and after Data Collection.
- A new Data Collection Step field is available when adding/editing a Task. This determines what step will correspond with that Task.
- This field allows the selection of any Data Collection step, not just those previously associated with the chosen Project Type.
- A Project Template spreadsheet must include this column in order to be valid for import. It occupies column C of the Task level, with Time Code and all other items on row 4 shifted one column to the right. A spreadsheet Template exported from PensionPro will include this column.
- In most cases, Data Collection Tasks can be freely added, rearranged, and deleted.
- Data Collection must still begin with the Request step and end with the Approval step.
- If the Family step is used, it must come after the Principals step.
- General Web Collection Projects can have an unlimited number of Questionnaire steps. Annual Administration Projects still use the Plan and 5500 Questionnaires, although these steps are now optional.
- When adding/editing a Task, if it is designated as a Questionnaire step, a new Questionnaire field will be made available; refer to the next section for details.
Managing Questionnaires
To help make creating and maintaining questionnaire items easier across different Project Types, a new Questionnaires entry has been added to the Maintenance menu.
Instead of adding and editing Task Items for questions on a per-Project basis, they can now be managed as Questionnaire templates. Each item in a Questionnaire is added and edited similarly to Task Items in Project Templates; they can be rearranged as needed and marked as required if necessary, and they use all of the firm's existing Data Type dropdowns.
When a Task in the Project Template is tagged as a Questionnaire step in Data Collection, an additional field in the Add/Edit Task window will ask the user to select one of the available Questionnaire templates. When the Task is saved, its Task Items will be copied from those in the Questionnaire template, so they won't need to be configured by hand.
Census Enhancements
A number of enhancements relating to the employee census have been implemented, simplifying layout management and adding more data validation checks.
Census Formats
Previously, the layout of Collection Fields used by the employee census was customized for each Plan Type. However, this meant that it was impossible for two Plans of the same type to use different census layouts. Now, census formats are managed independently from Plan Type, and the format used is set on a Plan-by-Plan basis.
Navigate to Maintenance > Preferences > PensionPro and select the Census Formats view. The grid contains any existing census formats; if the firm recently converted to Projects 2.0, this will likely match the list of Plan Types (so as not to disrupt service. It is OK to edit these formats at this point).
Census formats can now be duplicated using the Copy option on the right. Editing a format now includes the option to use it as the default census format—which is applied to Plans that do not have a format selected—or to deactivate the format so it can no longer be used.
A census format cannot be archived or deleted if it is currently being used by any Plans.
Double-clicking a census format displays its current Collection Fields; the process of managing these fields has not changed.
To set a census format for a Plan, navigate to the General Plan Information view, then select Edit and set the Census Format field to the desired format.
Validating Column Totals
TPAs can implement an additional level of census data validation by asking Plan Sponsors to input expected column totals during Data Collection.
To enable this functionality for a census column:
- Navigate to Maintenance > Preferences > PensionPro and select the Census Formats view.
- Double-click to open a census format; validation will only be applied to this format.
- Locate the desired field in the grid and select Edit
on the right-hand side. The corresponding window displays.
- Select Require Total.
- If this option is not available, the field is non-numerical and cannot calculate a total.
- Customize the Total Amount Description if desired.
- This text will be used to provide additional information to the Plan Sponsor.
- Select Save.
When the Plan Sponsor is completing the Employees step of Data Collection, PlanSponsorLink will display a banner above the census grid asking the Sponsor to Set Total Amounts. The corresponding window includes all fields for which Require Total is set to Yes. The Sponsor should enter the expected column totals for each of these fields.
The Plan Sponsor can hover over the Info icon to the right of each field to see more details about the value they are being asked to enter. This tooltip displays the Total Amount Description text set in Step 5, above.
If the expected total entered by the Sponsor doesn't match the total that PlanSponsorLink calculates for that column, this may indicate that data was entered incorrectly or is missing. PlanSponsorLink will not allow the census to be submitted until the values agree.
Notes for Census Warnings
When Census Scrubbing is enabled in PlanSponsorLink Preferences, the Plan Sponsor will receive error and warning messages if some aspect of their census data is invalid or warrants additional attention. While errors require resolution before the census can be submitted, the Plan Sponsor isn't required to address warnings since the flagged data may actually be legitimate. This, however, may not be immediately apparent to the TPA.
To ensure TPAs have the information they need, firms can now enable the Require Response to Employee-Specific Census Warnings option in PlanSponsorLink Preferences. When enabled, Plan Sponsors will still receive errors and warnings like usual. However, when there is a warning specific to an employee, the Issues window will display a column for the Plan Sponsor to enter a note, giving them the opportunity to provide additional information or clarification. They will not be able to submit the census until notes have been entered for all warnings.
To view these notes in PensionPro, use the Errors option at the top-right of the census grid in the Employees Data Collection view.