Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse HR DEGREE Table


Master data table containing a list of Degrees and their corresponding codes. (Example: Associate Degree 60, Post-Doctorate 10).


Field Name

Description

Data Type

Length

HR_DEGREE

Description of the degree obtained, such as Bachelor's-Art's (51), Bachelor's-Business (52), or Bachelor's-Science (5A).

VARCHAR2

40

HR_DEGREE_CODE

Code for the degree obtained. Example: 51 = Bachelor's-Art's, 52 = Bachelor's-Business, or 5A = Bachelor's-Science.

VARCHAR2

2

HR_DEGREE_KEY

XXX

VARCHAR2

2

WAREHOUSE_LOAD_DATE

The date the record was loaded into the Data Warehouse from the source system.

DATE

8