Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse HR DEGREE Table


Reference table defining academic degree values used within HR systems. Each row represents a distinct degree code and description.


Field Name

Description

Data Type

Length

HR_DEGREE

Description or name of the academic degree.

VARCHAR2

40

HR_DEGREE_CODE

Source system code representing the academic degree.

VARCHAR2

2

HR_DEGREE_KEY

Surrogate key uniquely identifying the HR degree record.

VARCHAR2

2

WAREHOUSE_LOAD_DATE

Date the record was loaded into the data warehouse.

DATE