Understanding Employee Personal Information Storage

You can use the Update Personal Info to Live Tables program (R054104) to save self-service changes to live system tables. This program also saves new date effective address information if the appropriate option is set in the Address Book Constants program (use P0000). Processing options specify the types of changes that are saved:

  • Employee personal information

  • Dependent and beneficiary information

  • Employee personal information and dependent and beneficiary information

You should run this program after employees use self service to change any of their personal information. Since you might not be aware of when changes are entered, you should schedule this program to run periodically so that the system saves new information to the live tables at least once each week. You should also run this program at the conclusion of each open enrollment period. After the system updates the live tables, employees can review the new changes on self-service forms.

The Update Personal Info to Live Tables program includes a review of self-service workflow. This program verifies that required workflow approvals are complete before the system processes employee benefit changes. The final step of this programs process saves information to history tables so that employees can look up changes by transaction number.

The system references these tables for this program:

  • Employee Personal Profile Information Work (F054101W)

  • Employee Phone Number Work (F054115W)

  • Employee Emergency Contact Work (F054111W)

  • Disability Status Work Table (F085590W)

  • Veteran Status Work Table (F085605W)

  • Employee Master Information (F060116)

    Note: If the GeoCoder for Human Resource Management applications is active, the Update Personal Info to Live Tables program automatically updates employee tax area information if the changes that are made using self service include a change to the employee's city, state, county, province, or postal code. If there are multiple valid GeoCodes for the employee's new address information, the system produces an exception report and does not update the employee's GeoCode. In these instances, you must select the correct GeoCode from the exception report and manually update the employee's tax area information.