EHST UNIT Table
View exposing organizational unit data used in Environment, Health, and Safety training and compliance reporting.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
EHST_UNIT_CODE |
Code identifying ehst unit. |
VARCHAR2 |
16 |
EHST_UNIT_EXPIRE_DAYS |
Ehst unit expire days associated with the record. |
NUMBER |
5 |
EHST_UNIT_KEY |
Surrogate key identifying the ehst unit. |
VARCHAR2 |
16 |
EHST_UNIT_LONG_NAME |
Ehst unit long name associated with the record. |
VARCHAR2 |
100 |
EHST_UNIT_OPTION_CODE |
Code identifying ehst unit option. |
VARCHAR2 |
16 |
EHST_UNIT_OPTION_LONG_NAME |
Ehst unit option long name associated with the record. |
VARCHAR2 |
100 |
EHST_UNIT_OPTION_SHORT_NAME |
Ehst unit option short name associated with the record. |
VARCHAR2 |
20 |
EHST_UNIT_OPTION_TYPE |
Ehst unit option type associated with the record. |
VARCHAR2 |
9 |
EHST_UNIT_OPTN_EXPIRE_DAYS |
Ehst unit optn expire days associated with the record. |
NUMBER |
5 |
EHST_UNIT_SHORT_NAME |
Ehst unit short name associated with the record. |
VARCHAR2 |
20 |
IS_REFRESHER_COURSE_REQUIRED |
Indicator identifying whether refresher course required (Y/N). |
VARCHAR2 |
1 |
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |