HR APPT TYPE Table
Master data table identifying the type of appointment (Primary, Additional, and Dual) and sub-type(Academic, Non Academic). This view also contains flages identifyinf whether the appointment is current, future, or exempt.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
HR_APPT_SUBTYPE |
This field contains the description of the appointment subtype, Examples: Academic Appointment (MNT1), Academic Appointment--MAP (MAP1), etc.. |
VARCHAR2 |
100 |
HR_APPT_SUBTYPE_CODE |
Code to identify the appointment subtype: MNT1= Academic Appointment, MAP1 = Academic Appointment--MAP, etc.. |
VARCHAR2 |
4 |
HR_APPT_TYPE |
Contains the description of the appointment. Examples: Primary (O), Additional (A), or Dual (D). |
VARCHAR2 |
30 |
HR_APPT_TYPE_CODE |
Code identifying the appointment. Examples: O = Primary, A = Additional, or D = Dual. |
VARCHAR2 |
3 |
HR_APPT_TYPE_KEY |
XXX |
VARCHAR2 |
20 |
IS_CURRENT_APPT |
Is the appointment current? Y or N. |
VARCHAR2 |
1 |
IS_EXEMPT_APPT |
Is this an exempt position? Y or N. |
VARCHAR2 |
2 |
IS_FUTURE_APPT |
Is the appointment out in the future timeframe? |
VARCHAR2 |
1 |
IS_PAID_APPT |
Is this a paid appointment? Y or N. |
VARCHAR2 |
1 |
IS_SUPPLEMENT |
XXX |
VARCHAR2 |
1 |
SAP_APPT_TYPE |
XXX |
VARCHAR2 |
30 |
SAP_APPT_TYPE_CODE |
XXX |
VARCHAR2 |
3 |
WAREHOUSE_LOAD_DATE |
The date the record was loaded into the Data Warehouse from the source system. |
DATE |
8 |