HR ABSENCE DETAIL Table
Stores employee absence event details by date, including start/end times, actual hours/days, deducted hours/days, and change tracking. Each row represents an absence entry.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
ABSENCE_DATE |
Date of the absence. |
DATE |
|
ABSENCE_DAYS_DEDUCTED |
Absence days deducted from balances for the absence entry. |
NUMBER |
6,2 |
ABSENCE_END_TIME |
End time of the absence as provided by the source. |
VARCHAR2 |
8 |
ABSENCE_HOURS_DEDUCTED |
Absence hours deducted from balances for the absence entry. |
NUMBER |
7,2 |
ABSENCE_START_TIME |
Start time of the absence as provided by the source. |
VARCHAR2 |
8 |
ACTUAL_ABSENCE_DAYS |
Actual absence days recorded for the absence date/time. |
NUMBER |
6,2 |
ACTUAL_ABSENCE_HOURS |
Actual absence hours recorded for the absence date/time. |
NUMBER |
7,2 |
HR_ABSENCE_BALANCE_KEY |
Surrogate key identifying the absence balance record associated with this absence entry (if applicable). |
VARCHAR2 |
16 |
HR_ABSENCE_TYPE_KEY |
Surrogate key identifying the absence type. |
VARCHAR2 |
6 |
LAST_CHANGED_BY |
User identifier indicating who last changed the record in the source system. |
VARCHAR2 |
12 |
LAST_CHANGED_ON |
Date the absence record was last changed in the source system. |
DATE |
|
MIT_ID |
MIT ID number of the person. Use this field to join with other tables containing data about people at MIT. |
VARCHAR2 |
9 |
ORG_UNIT_ID |
Organizational unit identifier associated with the absence record. |
VARCHAR2 |
8 |
PERSONNEL_KEY |
Surrogate key identifying the personnel record associated with the absence. |
VARCHAR2 |
8 |
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |