EHST DETAIL Table
EHS Training detail
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
EHST_CERTIFICATION_KEY |
Internal key for a Certification Type to be used when joining tables. (A Certification Type is a group of training or other requirements). |
NUMBER |
12 |
EHST_CERT_STATUS_KEY |
Internal key to join with EHST_CERT_STATUS view. |
VARCHAR2 |
10 |
EHST_CERT_TRIGGER_KEY |
Key for a person's Certification Type trigger that should be used for joining with the detail table. (A Certification Type trigger is a self-reported job function, HR job title, DLC, or other factor that indicates that a person needs to fulfill the requirements of a given Certification Type). |
VARCHAR2 |
21 |
EHST_DLC_KEY |
Internal key for a DLC to join with the detail table. |
NUMBER |
22 |
EHST_PI_MIT_ID |
The MIT ID number of a trainee's PI or supervisor. |
VARCHAR2 |
9 |
EHST_UNCOMPL_UNIT_EFFECTV_DATE |
XXX |
DATE |
8 |
EHST_UNIT_COMPLETION_DATE |
The date when a person's course or other requirement was completed. |
DATE |
8 |
EHST_UNIT_EXPIRATION_DATE |
The date when a person's course or other requirement will expire and need to be renewed. |
DATE |
8 |
EHST_UNIT_KEY |
The internal key for the unit of training or other requirement. Use this to join with the detail table. |
VARCHAR2 |
16 |
EHST_UNIT_STATUS_KEY |
Use this field to join with the detail table. This is the internal key for the trainee's status related to a particular unit (e.g., a course or other requirement). |
VARCHAR2 |
10 |
INSTRUCTOR_KERB_NAME |
For records related to courses that have been completed by the trainee, this field contains the course instructor's Kerberos username, where available. |
VARCHAR2 |
8 |
INSTRUCTOR_MIT_ID |
For records related to courses that have been completed by the trainee, this field contains the course instructor's MIT ID number, where available. |
VARCHAR2 |
9 |
INSTRUCTOR_NAME |
For records related to courses that have been completed by the trainee, this field contains the course instructor's name, where available. |
VARCHAR2 |
60 |
IS_PRIMARY_DLC |
'Y' means the that the trainee has marked the DLC in this record as his/her primary DLC. 'N' means that this is a secondary DLC, or the trainee has not indicated a primary DLC. |
VARCHAR2 |
1 |
IS_PRIMARY_SUPERVISOR |
'Y' means that the trainee has marked the PI or supervisor in this record as his/her primary PI or supervisor. 'N' means that this is a secondary PI or supervisor, or the trainee has ot indicated a primary PI or supervisor. |
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 |
The date that a person's Certification Type requirement went into effect. |
DATE |
8 |
PERSON_CERT_EXPIRATION_DATE |
The date that a person's Certification Type will expire, I.e., the earliest expiration date of a course or other requirement associated with the Certification Type that will cause the Certification Type to expire if the course or other requirement is not renewed. |
DATE |
8 |
WAREHOUSE_LOAD_DATE |
The date the record was loaded into the Data Warehouse from the source system. |
DATE |
8 |