HRBAIRS Data Dictionary - EMPLOYEE_DIM.APPT_END_DT

Data Dictionary Home
EMPLOYEE_DIM.APPT_END_DT

Definition:

The last date on which the job represented by the row in which this field occurs is effective. Not required in all cases; may be populated with a high value (12/31/9999).

APPT_END_DT is populated with a "real" date only when APPT_DURATION (Employment Duration) is set to certain values. For example, when Employment Duration is set to "I - Indefinite," HRMS shows a blank field for End Date, and APPT_END_DT in the data warehouse is set to 12/31/9999.

General Definition (Non View specific).

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