HR ABSENCE BALANCE Table
Stores employee absence balance measures by balance type and balance period, including beginning, deducted, and ending balances in hours and days, and related eligibility and change tracking.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
ABSENCE_BALANCE_BEGIN_DATE |
Start date of the absence balance period. |
DATE |
|
ABSENCE_BALANCE_END_DATE |
End date of the absence balance period. |
DATE |
|
BEGINNING_BALANCE_DAYS |
Beginning absence balance in days for the balance period. |
NUMBER |
12,7 |
BEGINNING_BALANCE_HOURS |
Beginning absence balance in hours for the balance period. |
NUMBER |
10,5 |
DEDUCTED_DAYS |
Absence days deducted during the balance period. |
NUMBER |
12,7 |
DEDUCTED_HOURS |
Absence hours deducted during the balance period. |
NUMBER |
10,5 |
ENDING_BALANCE_DAYS |
Ending absence balance in days for the balance period. |
NUMBER |
13,7 |
ENDING_BALANCE_HOURS |
Ending absence balance in hours for the balance period. |
NUMBER |
11,5 |
HR_ABSENCE_BALANCE_KEY |
Surrogate key identifying the absence balance record. |
VARCHAR2 |
16 |
HR_ABSENCE_BALANCE_TYPE_KEY |
Surrogate key identifying the absence balance type. |
VARCHAR2 |
5 |
IS_EXEMPT_VACATION_ELIGIBLE |
Indicator identifying whether the person is eligible for exempt vacation accrual (Y/N). |
VARCHAR2 |
1 |
LAST_CHANGED_BY |
User identifier indicating who last changed the record in the source system. |
VARCHAR2 |
12 |
LAST_CHANGED_ON |
Date the absence balance 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 |
MONTHLY_VACATION_ACCRUAL_RATE |
Monthly vacation accrual rate used for balance calculations (as defined by source). |
NUMBER |
6,4 |
PERSONNEL_KEY |
Surrogate key identifying the personnel record associated with the absence balance. |
VARCHAR2 |
8 |
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |