Census Data Validation

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.

 

Compatible Tiers
Team, Business

 

Article Contents

 

 


 

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:

 

  1. Navigate to Maintenance > Preferences > PlanSponsorLink Subdomains. The corresponding grid opens in a new tab.
  2. Double-click a subdomain to open it. Select the Annual Data Collection view.
  3. 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

 

Note: Projects/Plan Cycles that already have census data when Census Data Validation is enabled will continue to show their existing warnings and notes until the census is imported again. After the next import, Census Data Validation takes effect.

 


 

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:

 

  1. Select the highlighted cell in the grid. The Resolve Error/Warning window displays.
  2. 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.
  3. 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.

 

Note: Prior Period End employees without an SSN are not reported as missing, as they cannot reliably be matched to the current census.

 

To resolve a missing participant:

 

  1. Select the Missing Participant row. The Resolve Warning window displays.
  2. 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.
  3. 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:

 

  1. Select the flagged SSN. The Resolve Warning window displays, comparing both employees side by side.
  2. Choose an option to decide which row to delete, or confirm that the employees are different people.
  3. Select Confirm the choice above is correct or enter a note manually, if needed.
  4. Select Save.

 

Warning: Deleting a duplicate row removes theemployee and their data from the current census. This action cannot be undone.

 


 

Exporting a Census with Issues

 

A census containing errors can optionally be exported from PensionPro to an Excel workbook for correction. To do so:

 

  1. At the top of the census grid, select Moremore_options.png > Export. The Select Export window displays.
  2. For the Export Template, choose Current Layout.
  3. For the File Type, choose .xlsx.
  4. 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.

 

Note: This method can be used to quickly add notes for multiple similar warnings. However, while re-importing this workbook will import the notes, PensionPro will not consider a warning addressed until the Resolve Warning window is completed.

 


 

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.