Cross-Reference Tables Setup for Supplemental Data
To save time and reduce typing errors, you can set up the system to automatically transfer a terminated employee's supplemental data to the applicant database. An example of a terminated employee whose supplemental database you might transfer is a seasonal employee that you terminate at the end of the season and intend to rehire next season.
Transferring supplemental data in this manner makes it easy to maintain consistent data throughout the processes of hiring applicants and terminating employees.
When you set up the cross-reference table, observe these guidelines:
The format (code or narrative) of each data type that you want to transfer must be the same in both databases.
For code format data types, the source data type and target data type codes must be the same.
The user-defined code tables that are associated with code format data types must be the same in both databases.
For example, if you have a data type, Prior Employment, in the applicant database that is associated with table 07/G, you can cross-reference it with the data type Prior Employment in the employee database, provided that the data type also uses table 07/G. When you transfer supplemental data for a terminated employee, you can choose to save a copy of the data in the employee database, or delete the information from the employee database and store it only in the applicant database.