Swap to the Plan Sponsor

Importing participant data is done from within the Plan Sponsor. Because you have the Plan Document Open, you must "swap" over to the Plan Sponsor.

A user may not have both the Plan Sponsor and any of its Plan Documents open with edit access at the same time. This is because there are some shared data elements between the two (Reported Amounts for example). Therefore, if you try to open both a document and sponsor at the same time, the second tab that you open will be opened read-only.

The easiest way to swap over to the Plan Sponsor is to double-click on the Sponsor's name in Item Explorer. This will prompt you about swapping and then open the Plan Sponsor.

Adding a new Import Definition

To import the initial participant data into DB Precision, you will first need to create an Import Definition. To do this, right-click Import Definitions on the Sponsor tab. Then give the newly created definition a name (the standard name for the initial import is "InitialImport_yyyy" where yyyy is the year of the conversion).

Specifying the Import File Layout

To specify the layout for this Import Definition, double-click on single row found immediately below the name of the newly created Import Definition. This will open the Import Row Screen.

  • Social Security Number Location: specify the column number where SSN is located. This should generally be kept equal to the default (column 1).
  • Wizard Button: use the Sponsor Import Wizard to quickly specify additional columns. Using the wizard, you will be able to choose the order in which items should be imported.

    For Reported Amounts, select the Reported Amount once. You will later be prompted which years you are importing (from and to).

    When pressing OK on the wizard screen, you will see the items that you chose listed in order in the Row Items list. To view the details of a specific item, double-click that item.

  • Changing Row Item Type: to change the type or detail of a selected Row Item, change Item Type and Item Detail (listed below the Row Items). Be careful when changing the Item Type and Item Detail that you have first selected the item in the Row Items list. It is easy to accidentally change these for the wrong item.
Prior Next
PensionSoft Corporation | 860.540.3690 | support@pensionsoft.com