HR APPT TYPE Table
Stores appointment type and subtype reference data used by HR appointment and personnel action tables, including indicators for current, future, paid, exempt, and supplemental appointments. Each row represents a distinct appointment type definition.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
HR_APPT_SUBTYPE |
Descriptive name of the HR appointment subtype. |
VARCHAR2 |
100 |
HR_APPT_SUBTYPE_CODE |
Code representing a more granular appointment subtype. |
VARCHAR2 |
4 |
HR_APPT_TYPE |
Descriptive name of the HR appointment type. |
VARCHAR2 |
30 |
HR_APPT_TYPE_CODE |
Short code representing the HR appointment type. |
VARCHAR2 |
3 |
HR_APPT_TYPE_KEY |
Surrogate key uniquely identifying the HR appointment type record. |
VARCHAR2 |
20 |
IS_CURRENT_APPT |
Indicator identifying whether the appointment type represents a current appointment (Y/N). |
VARCHAR2 |
1 |
IS_EXEMPT_APPT |
Indicator identifying whether the appointment type is exempt from overtime rules (Y/N). |
VARCHAR2 |
1 |
IS_FUTURE_APPT |
Indicator identifying whether the appointment type represents a future appointment (Y/N). |
VARCHAR2 |
1 |
IS_PAID_APPT |
Indicator identifying whether the appointment type is paid (Y/N). |
VARCHAR2 |
1 |
IS_SUPPLEMENT |
Indicator identifying whether the appointment type represents a supplemental appointment (Y/N). |
VARCHAR2 |
1 |
SAP_APPT_TYPE |
SAP appointment type description associated with the HR appointment type. |
VARCHAR2 |
30 |
SAP_APPT_TYPE_CODE |
SAP appointment type code associated with the HR appointment type. |
VARCHAR2 |
3 |
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |