EHST DETAIL Table
View exposing Environment, Health, and Safety training and compliance detail records associated with MIT personnel, hazards, and work activities.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
EHST_CERTIFICATION_KEY |
Surrogate key identifying the ehst certification. |
NUMBER |
12 |
EHST_CERT_STATUS_KEY |
Surrogate key identifying the ehst cert status. |
VARCHAR2 |
10 |
EHST_CERT_TRIGGER_KEY |
Surrogate key identifying the ehst cert trigger. |
VARCHAR2 |
21 |
EHST_DLC_KEY |
Surrogate key identifying the ehst dlc. |
NUMBER |
12 |
EHST_PI_MIT_ID |
Business identifier for the ehst pi mit. |
VARCHAR2 |
9 |
EHST_UNCOMPL_UNIT_EFFECTV_DATE |
Date associated with ehst uncompl unit effectv. |
DATE |
|
EHST_UNIT_COMPLETION_DATE |
Date associated with ehst unit completion. |
DATE |
|
EHST_UNIT_EXPIRATION_DATE |
Date associated with ehst unit expiration. |
DATE |
|
EHST_UNIT_KEY |
Surrogate key identifying the ehst unit. |
VARCHAR2 |
16 |
EHST_UNIT_STATUS_KEY |
Surrogate key identifying the ehst unit status. |
VARCHAR2 |
50 |
INSTRUCTOR_KERB_NAME |
Instructor kerb name associated with the record. |
VARCHAR2 |
8 |
INSTRUCTOR_MIT_ID |
Business identifier for the instructor mit. |
VARCHAR2 |
9 |
INSTRUCTOR_NAME |
Instructor name associated with the record. |
VARCHAR2 |
60 |
IS_PRIMARY_DLC |
Indicator identifying whether primary dlc (Y/N). |
VARCHAR2 |
1 |
IS_PRIMARY_SUPERVISOR |
Indicator identifying whether primary supervisor (Y/N). |
VARCHAR2 |
1 |
MIT_ID |
MIT ID number of the person. Use this field to join with other tables containing data about people at MIT. |
VARCHAR2 |
9 |
PERSON_CERT_EFFECTIVE_DATE |
Date associated with person cert effective. |
DATE |
|
PERSON_CERT_EXPIRATION_DATE |
Date associated with person cert expiration. |
DATE |
|
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |