Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse HR ABSENCE BALANCE TYPE Table


Stores absence balance type reference data, including type codes, names, and indicators for whether a type maintains a balance.


Field Name

Description

Data Type

Length

ABSENCE_BALANCE_TYPE

Name/description of the absence balance type.

VARCHAR2

25

ABSENCE_BALANCE_TYPE_CODE

Code identifying the absence balance type.

VARCHAR2

2

HR_ABSENCE_BALANCE_TYPE_KEY

Surrogate key identifying the absence balance type.

VARCHAR2

5

IS_TYPE_WITH_BALANCE

Indicator identifying whether this absence type maintains a running balance (Y/N).

VARCHAR2

1

WAREHOUSE_LOAD_DATE

Date the record was loaded into the data warehouse.

DATE