EHST CERT STATUS Table
EHS Training certification status
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
EHST_CERT_STATUS_KEY |
Internal key to join with EHST_CERT_STATUS view. |
VARCHAR2 |
10 |
IS_CERT_COMPLETED |
'Y' indicates that the requirements for the Certification Type have been completed by the person. 'N' indicates that some or all of therequirements have not yet been completed. |
VARCHAR2 |
1 |
IS_CERT_IN_EFFECT |
In instances where a person's DLC, self-reported activities, or other factors indicate a need for two or more overlapping Certification Types, it may be the case that one Certification Type takes precedence over another. In this case, the "lower-priority" Certification Type will have IS_CERT_IN_EFFECT set to 'N'. |
VARCHAR2 |
1 |
WAREHOUSE_LOAD_DATE |
The date the record was loaded into the Data Warehouse from the source system. |
DATE |
8 |