Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse EL REQUIREMENT ORIGIN Table


XXX


Field Name

Description

Data Type

Length

EL_QUAL_KEY

XXX

VARCHAR2

50

EL_REQUIREMENT_SET_KEY

XXX

VARCHAR2

10

EL_REQUIREMENT_TRIGGER_KEY

XXX

VARCHAR2

50

LSO_QUALIFICATION_KEY

XXX

VARCHAR2

10

MIT_ID

MIT ID number of the person. Use this field to join with other tables containing data about people at MIT.

VARCHAR2

9

REQUIREMENT_END_DATE

XXX

DATE

REQUIREMENT_LEVEL

XXX

VARCHAR2

20

REQUIREMENT_LEVEL_CODE

XXX

VARCHAR2

3

REQUIREMENT_START_DATE

XXX

DATE

WAREHOUSE_LOAD_DATE

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

TIMESTAMP(6)