HR ABSENCE TYPE Table
A dimension table which contains the different types of absences for exempt and non-exempt employees. Eg.: Vacation, Sick, Personal Leave, Bereavement Leave, 5th Week Vacation, Sick - Family, Leave Without Pay.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
ABSENCE_BALANCE_TYPE_1 |
XXX |
VARCHAR2 |
40 |
ABSENCE_BALANCE_TYPE_2 |
XXX |
VARCHAR2 |
40 |
ABSENCE_BALANCE_TYPE_3 |
XXX |
VARCHAR2 |
40 |
ABSENCE_BALANCE_TYPE_4 |
XXX |
VARCHAR2 |
40 |
ABSENCE_TYPE |
XXX |
VARCHAR2 |
25 |
ABSENCE_TYPE_CODE |
XXX |
VARCHAR2 |
4 |
EMPLOYEE_GROUP |
Definition of EMPLOYEE_GROUP_CODE, identifying an employee grouping, e.g., Exempt, Non-Exempt, or External |
VARCHAR2 |
30 |
HR_ABSENCE_TYPE_KEY |
XXX |
VARCHAR2 |
6 |
WAREHOUSE_LOAD_DATE |
The date the record was loaded into the Data Warehouse from the source system. |
DATE |
8 |