Using The Global Employee Census Power Tool

The Global Employee Census Power Tool is the same function as the importing of a census file into an annual administration project but on a global scale. This will import census information into projects against multiple period end dates. Mapping is based on the TPA Plan ID and Project Period End Date.


Tier Availability: Essential, Premium, Business
Security Rights Required: Access Power Tools



Prior to importing census information for plans, an Annual Administration Project must be launched against the plan.


Global Employee Census Import

  1. From the Power Tools Menu, select Import > Global Employee Census. This Power Tool is equipped with a data sheet for populating.
  2. Select how to import the census information by choosing a selection from the Import By dropdown menu.
    • Users can select to import by "TPA Plan ID" or "Plan Name"
  3. Click on the Export button to export a blank data sheet with pre-filled headers.
  4. Paste the data extracted from an administration system into this worksheet file or create a data export with the same headers and formatting for import.
    • The Plan Identifier (TPA Plan ID or Plan Name), Participant First Name, Participant Last Name, and Project Period End are required fields.
    • The tab containing census information must be titled "Employees"
  5. Once completed, click on the File Browser button and then select the data file to be imported. This file must be a spreadsheet with a .xls or .xlsx extension.
  6. Click the Import button.

If the import is successful, the Success tab will indicate the number of records that have been imported.  The Failed tab will display the details of any imports that have failed to be uploaded.

If any errors are received, the user must correct them before reattempting this import process.


Fields Displayed

  • Import By: Select either TPA Plan ID or Plan Name for the import file.
  • Employee File: Select the file to import with the browser icon and it will be displayed in this box.
  • Import Button: Click this button to import in the attached employee census file.

Checklist for avoiding errors upon import:

  • If Importing by Plan Name, all records have a value in the Plan Name column.
  • If Importing by TPA Plan ID, all records have a value in the TPA Plan ID column.
  • All records have a Period End value in the Period End column.
  • All records listed have an Annual Administration Project Launched with an annual frequency and require Data Collection. Each of these projects has a Period End that matches the Period End value entered in the Period End column of the import template.
  • First Name and Last Name fields all have values.
  • If Importing by Plan Name, all plan names entered exactly match the corresponding Plan Name entered in PensionPro. Check for trailing spaces, commas, spelling, and periods.
  • If Importing by TPA Plan ID, all TPA Plan IDs entered exactly match the corresponding Plan's Plan ID entered in PensionPro. Check for trailing spaces, commas, spelling, and periods.
  • All column headers directly match the Collection Field display name in PensionPro. Check for trailing spaces, commas, spelling, and periods.
  • No additional rows are added above the column headers.


Frequently Asked Questions

  • Can I get a list of all the Collection Fields and their definitions? Yes. Simply click Power Tools > Import > Global Employee Census and click the Export button to get a full list of the Collection Fields Field Display Names and their Definitions in PensionPro. This information will appear on the Instructions tab of the blank import template.
  • I imported my census data and the values for a collection field are appearing blank after the census was imported. Why aren't these populating in PensionPro? In order for the data to import, the column headers for collection field on the import template must directly match the Field Description Display Name for the collection fields in PensionPro.  Users can confirm the Field Description display names by clicking Maintenance > Preferences and clicking the Field Descriptions tab. If the column header on the import template does not directly match that Field Description Display Name, it will not import that information.
  • I am trying to importing an Employee Census file using Global Employee Census Import. I am getting an error "Missing required value for TPA Plan Id or Period Ending" Both of these items are on the file for every record, so I can't figure out why it's not importing. Click on and highlight the first blank row at the bottom of the template. Once highlighted, hold down the Shift + End keys on the keyboard and click the Down arrow on the keyboard. This should highlight all blank rows in the template. Right-click the last row and delete those rows. Re-save the template and retry the import. Sometimes there is a space in the import template on a blank row that won't allow the import to process.



Return to Top


Feature feedback