HRBAIRS Data Dictionary - JOB_EARNS_DIST.PS_EMP_APPT_EFF_SEQ

Data Dictionary Home
JOB_EARNS_DIST.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 JOB_EARNS_DIST table, this indicates the Effective Sequence number of the Job row of which the Job Earnings Distribution row is a child.

General Definition (Non View specific).

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