HRBAIRS Data Dictionary - PS_EMP_APPT_EFF_SEQ

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.

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.