A clean employee census is vital to performing annual plan administration. The earlier a problem is caught, the less time it costs later. Census data validation reviews census data as it is entered or imported, identifies and classifies any issues present, and allows the TPA or Plan Sponsor to correct or explain each issue directly from the census grid. This article outlines how to use census validation and how census issues are identified and resolved in both PensionPro and PlanSponsorLink.
Article Contents
- Overview of Census Data Validation
- Enabling Census Data Validation for PSL
- Census Import Stops
- Identifying & Resolving Census Issues
- Exporting a Census with Issues
- Submitting the Census on PSL
Overview of Census Data Validation
Census data validation offers a thorough, line-by-line check of any census data that's added to a Project or Plan Cycle. In other words, whenever any of the follow actions take place:
- An employee line is added to Data Collection in PensionPro/PlanSponsorLink
- A census file is imported to Data Collection in PensionPro/PlanSponsorLink
- A census is imported from a payroll file
- A census is copied or rolled over from past census data
Census validation is always on in PensionPro. It can be optionally be enabled for PlanSponsorLink users.
How is data validation different from census scrubbing?
Census data validation is a more thorough feature that implements a greater number of checks, performs those checks on more actions, and provides greater visual clarity when identifying census issues. If census validation is enabled, PensionPro will enable and lock census scrubbing.
Enabling Census Data Validation for PSL
Requires Security Rights: Maintenance
Census Data Validation can be enabled for PlanSponsorLink users in PSL Preferences:
- Navigate to Maintenance > Preferences > PlanSponsorLink Subdomains. The corresponding grid opens in a new tab.
- Double-click a subdomain to open it. Select the Annual Data Collection view.
- Set the Enable Census Data Validation on PSL preference to Yes.
Firms that wish to use census validation on multiple subdomains must enable this setting for each
Census Import Stops
PensionPro and PlanSponsorLink begin to perform data validation when a census is imported into Data Collection. However, certain issues—such as duplicate SSNs or a discrepancy with a date of birth—will prevent the import from completing successfully, in which case no data will be added.
When this happens, the Import Error window will be displayed, listing the issues that prevented import. These must be corrected before the import is attempted again.
Identifying & Resolving Census Issues
When census data validation is enabled, any issues found with a census (which don't otherwise prevent import) are displayed on the Employees view of a Data Collection Project/Plan Cycle, and on the Employees step of Annual Data Collection in PSL.
The census grid lists the type of issue present for any impacted rows, and highlights the problem cell(s) for easy identification. General issues which affect the entire census can be viewed by selecting the link in the information banner above the grid.
Viewing and resolving an issue specific to one cell typically involves selecting the cell and following the prompts provided. Refer to the below sections for instructions on resolving the different types of issues identified by census validation. The steps are the same for both PensionPro and PlanSponsorLink.
Resolving Errors & Warnings
An error is an issue that should be corrected; PSL users must resolve errors before they can submit the Data Collection. A warning may or may not be an issue, depending on the circumstance; these can be corrected, or a note can be added for explanation.
To resolve an error or warning:
- Select the highlighted cell in the grid. The Resolve Error/Warning window displays.
- Address the issue:
- For an Error, enter the corrected value.
- For a Warning, either correct the value, or keep it and enter a note explaining why it is correct. Selecting Confirm this value is correct completes the note automatically.
- Select Save. The cell turns green, and the row's Type changes to Resolved once all of its issues are addressed.
Resolving a Missing Participant
A missing participant issue can identify an employee that was accidentally left off this year's census, or it might indicate an individual who left the company before the plan year began.
To resolve a missing participant:
- Select the Missing Participant row. The Resolve Warning window displays.
- Choose one of the following:
- Select Add to this year's census. The Add Employee window opens; enter the employee's details, then Save.
- Select Confirm this participant is not part of this year's census or enter a note manually.
- Select Save.
Resolving a Potential Duplicate
Census validation identifies rows with the same first and last name but different SSNs. This could be one employee entered twice with an SSN typo, or two different people who share a name.
To resolve a potential duplicate:
- Select the flagged SSN. The Resolve Warning window displays, comparing both employees side by side.
- Choose an option to decide which row to delete, or confirm that the employees are different people.
- Select Confirm the choice above is correct or enter a note manually, if needed.
- Select Save.
Exporting a Census with Issues
A census containing errors can optionally be exported from PensionPro to an Excel workbook for correction. To do so:
- At the top of the census grid, select More
> Export. The Select Export window displays.
- For the Export Template, choose Current Layout.
- For the File Type, choose .xlsx.
- Complete any other fields as desired and select Export.
Workbooks downloaded in this way have the following additions:
- A Message column is added as the first column of the Employees worksheet, noting rows that have errors and/or warnings.
- Flagged cells are highlighted, with the message and any notes in the cell comment.
- Missing Participants are added as new rows and labelled for review.
- An Employee Census Issues worksheet lists every issue for review.
- A Warning Message Notes worksheet lists each warning with a Note column. This is used to enter notes for unresolved warnings.
Submitting the Census on PSL
When Enable Census Data Validation on PSL is enabled, the Plan Sponsor will be unable to complete Data Collection until all census issues are resolved:
- The Employees step cannot be completed if any errors are present.
- If warnings are present and Require Response to Employee-Specific Census Warnings is enabled in PSL Subdomain Preferences, the Employees step cannot be completed until every warning has a note.
- The Approval step also shows any remaining errors and warnings. The Plan Sponsor is unable to sign and submit until all issues are corrected.