EHST UNIT STATUS Table
EHS Training Unit status
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
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 |
IS_UNIT_COMPLETED |
'Y' if the unit was completed, 'N' if not. |
VARCHAR2 |
1 |
IS_UNIT_EXPIRED |
'Y' if the previously taken course has expired. |
VARCHAR2 |
1 |
IS_UNIT_MOST_RECENT |
'Y' if this was the most recent completion of the unit, 'N' if it was an earler completion. |
VARCHAR2 |
1 |
IS_UNIT_REFRESHER |
XXX |
VARCHAR2 |
3 |
UNIT_INFO_SOURCE |
A description of the source of data for a completed course. |
VARCHAR2 |
100 |
UNIT_INFO_SOURCE_CODE |
A code indicating the source of the data for a completed course. |
VARCHAR2 |
20 |
WAREHOUSE_LOAD_DATE |
The date the record was loaded into the Data Warehouse from the source system. |
DATE |
8 |