EHST UNIT STATUS Table
View exposing reference values describing organizational unit status within Environment, Health, and Safety compliance processes.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
EHST_UNIT_STATUS_KEY |
Surrogate key identifying the ehst unit status. |
VARCHAR2 |
50 |
IS_UNIT_COMPLETED |
Indicator identifying whether unit completed (Y/N). |
VARCHAR2 |
1 |
IS_UNIT_EXPIRED |
Indicator identifying whether unit expired (Y/N). |
VARCHAR2 |
1 |
IS_UNIT_MOST_RECENT |
Indicator identifying whether unit most recent (Y/N). |
VARCHAR2 |
1 |
IS_UNIT_REFRESHER |
Indicator identifying whether unit refresher (Y/N). |
VARCHAR2 |
3 |
UNIT_INFO_SOURCE |
Unit info source associated with the record. |
VARCHAR2 |
100 |
UNIT_INFO_SOURCE_CODE |
Code identifying unit info source. |
VARCHAR2 |
20 |
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |