EL REQUIREMENT SET Table
View exposing requirement set reference records used to group related EHS training and compliance requirements.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
EL_REQUIREMENT_SET_KEY |
Surrogate key identifying the el requirement set. |
VARCHAR2 |
10 |
LAST_UPDATE_DATE |
Date associated with last update. |
DATE |
|
LAST_UPDATE_USER |
Last update user associated with the record. |
VARCHAR2 |
12 |
REQUIREMENT_SET_ABBR |
Requirement set abbr associated with the record. |
VARCHAR2 |
12 |
REQUIREMENT_SET_END_DATE |
Date associated with requirement set end. |
DATE |
|
REQUIREMENT_SET_GROUP |
Requirement set group associated with the record. |
VARCHAR2 |
40 |
REQUIREMENT_SET_GROUP_ABBR |
Requirement set group abbr associated with the record. |
VARCHAR2 |
12 |
REQUIREMENT_SET_ID |
Business identifier for the requirement set. |
VARCHAR2 |
8 |
REQUIREMENT_SET_NAME |
Requirement set name associated with the record. |
VARCHAR2 |
60 |
REQUIREMENT_SET_START_DATE |
Date associated with requirement set start. |
DATE |
|
REQUIREMENT_SET_STATUS |
Requirement set status associated with the record. |
VARCHAR2 |
8 |
REQ_SET_STATUS_END_DATE |
Date associated with req set status end. |
DATE |
|
REQ_SET_STATUS_START_DATE |
Date associated with req set status start. |
DATE |
|
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |