Assigning an Alias to the JOB Table

An important exception to the database alias key restrictions is the JOB table, which is keyed by employee ID, effective date, job number (Rcd#), and sequence number.

If an employee has multiple job records in a single job environment, a lookup alias finds the value from the first job record. All other job records are ignored, except in the case of multiple jobs processing, when the single job environment has been cleared.

Because the JOB table uses sequence number as an additional key field, you can enter multiple personnel actions on the same day, but specify an order for the actions. When you create an alias for a field on the JOB table, the system automatically uses the row with the last sequence number. This means the alias uses the final value for that date.

For example, if Fred receives a regular pay increase and a merit increase during his review, an alias to his compensation rate finds the final rate, after both increases have been applied.