HRBAIRS Data Dictionary - COMPENSATION.PS_EMP_APPT_EFF_SEQ

Data Dictionary Home
COMPENSATION.PS_EMP_APPT_EFF_SEQ

Definition:

When multiple job rows exist that are effective on a single date, this field indicates the sequence in which they were entered. The lowest, default value, zero, indicates first row entered on the effective date in question. Rows with higher sequence numbers supercede rows with lower sequence numbers on a given date. Effective sequence numbers are meaningful only in conjunction with the effective date of the row in which they occur.

In the COMPENSATION view, this indicates the effective sequence number of the Job row of which the Compensation row is a child.

General Definition (Non View specific).

Related Data Warehouse fields:
Corresponds to PS field(s):
Appears on PS pages: