HRBAIRS Data Dictionary -

Data Dictionary Home
APPT_TYPE_LKUP

Provides code descriptions for values of APPT_TYPE (Appointment Type).

Contains fields:
EFF_STATUS

A code describing the effective status of the code (or other element) described by a row of Data Warehouse data. "A" if this row is active; "I" if row is inactive.

DESC_LONG

The long description of the Appointment Type code described by this row of lookup table data.

DESC_SHORT

The short-description of the Appointment Type code described by this row of lookup table data.

APPT_TYPE

The Appointment Type code described by a row of data. The single-character codes (e.g. 2, X, 3, 1) translate to Appointment Types such as Regular/Career, Faculty, Limited, and Contract. A full list of values for this field can be found on the the HCM: Appointment Types page.