HR ABSENCE TYPE Table
Stores absence type reference data, including type codes, names, associated balance types, and employee group applicability.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
ABSENCE_BALANCE_TYPE_1 |
Balance type name/code associated with the absence type (slot 1). |
VARCHAR2 |
40 |
ABSENCE_BALANCE_TYPE_2 |
Balance type name/code associated with the absence type (slot 2). |
VARCHAR2 |
40 |
ABSENCE_BALANCE_TYPE_3 |
Balance type name/code associated with the absence type (slot 3). |
VARCHAR2 |
40 |
ABSENCE_BALANCE_TYPE_4 |
Balance type name/code associated with the absence type (slot 4). |
VARCHAR2 |
40 |
ABSENCE_TYPE |
Name/description of the absence type. |
VARCHAR2 |
25 |
ABSENCE_TYPE_CODE |
Code identifying the absence type. |
VARCHAR2 |
4 |
EMPLOYEE_GROUP |
Employee group associated with the absence type (as defined by source). |
VARCHAR2 |
40 |
HR_ABSENCE_TYPE_KEY |
Surrogate key identifying the absence type. |
VARCHAR2 |
6 |
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |