HR ABSENCE BALANCE TYPE Table
A dimension table which contains the different types of absence balance quotas for exempt and non-exempt employees. There are Vacation and 5th Week Vacation quotas for exempt employees; and the quotas for non-exempt employees are: Vacation, 5th Week Vacation, Sick, and Personal.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
ABSENCE_BALANCE_TYPE |
XXX |
VARCHAR2 |
25 |
ABSENCE_BALANCE_TYPE_CODE |
XXX |
VARCHAR2 |
2 |
HR_ABSENCE_BALANCE_TYPE_KEY |
XXX |
VARCHAR2 |
5 |
IS_TYPE_WITH_BALANCE |
XXX |
VARCHAR2 |
1 |
WAREHOUSE_LOAD_DATE |
The date the record was loaded into the Data Warehouse from the source system. |
DATE |
8 |