5.3. Mapping of Data Entry Grid

To get to the mapping information for a field, select the census grid that will be used for the plan from the "Data Entry Grids" page. When you select a census grid to edit/copy, you are brought to the "Edit Data Entry Grid" page. Click "Update and Edit Mapping" to access the "Update and Edit Mapping" screen. Here, you will see most fields available in the system (under "System Field") and you will be shown any default field mapping, if any. For example, as a default most compensation fields are mapped to the "Compensation_Statutory" field.

When you run the Scrub task, the mapping is based on the mapping of the census on the Census screen. Mapping is not based on the census grids on the Other Import/Export/Report Menu.

When mapping on the “Update and Edit Mapping” screen, the only data fields available for mapping in the “Grid Field” drop-down are those fields that are listed on the “Edit Data Entry Grid” screen. For example, in the screenshot shown, the “Service_EligibilityHours” is a column that’s on the census grid. The drop-down boxes below indicate other fields that are being mapped from it, i.e. “Service_EligibilityHoursInitial”, “Service_VestingHours” and “Service_ParticipationHours” are all fields that are being mapped from “Service_EligibilityHours”. To remove this mapping, select “None” from the Grid Fields drop-down box. There is a “Custom Calculation” option, but it is not operational.