EL REQUIREMENT ORIGIN Table
View exposing requirement origin reference values used to identify the source of EHS training and compliance requirements.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
EL_QUAL_KEY |
Surrogate key identifying the el qual. |
VARCHAR2 |
50 |
EL_REQUIREMENT_SET_KEY |
Surrogate key identifying the el requirement set. |
VARCHAR2 |
10 |
EL_REQUIREMENT_TRIGGER_KEY |
Surrogate key identifying the el requirement trigger. |
VARCHAR2 |
50 |
LSO_QUALIFICATION_KEY |
Surrogate key identifying the lso qualification. |
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 |
Date associated with requirement end. |
DATE |
|
REQUIREMENT_LEVEL |
Requirement level associated with the record. |
VARCHAR2 |
20 |
REQUIREMENT_LEVEL_CODE |
Code identifying requirement level. |
VARCHAR2 |
3 |
REQUIREMENT_START_DATE |
Date associated with requirement start. |
DATE |
|
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
TIMESTAMP(6) |