EHS ROOM REPRESENTATIVE Table
View exposing assignments of Environment, Health, and Safety room representatives associated with rooms and compliance responsibilities.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
EHSS_RM_RELATION_END_DATE |
Date associated with ehss rm relation end. |
DATE |
|
EHSS_RM_RELATION_START_DATE |
Date associated with ehss rm relation start. |
DATE |
|
EHSS_ROOM_RELATIONSHIP |
Ehss room relationship associated with the record. |
VARCHAR2 |
25 |
EHSS_ROOM_RELATIONSHIP_CODE |
Code identifying ehss room relationship. |
VARCHAR2 |
4 |
EHSS_ROOM_SET_OBJECT_TYPE |
Ehss room set object type associated with the record. |
VARCHAR2 |
25 |
EHSS_ROOM_SET_TYPE |
Ehss room set type associated with the record. |
VARCHAR2 |
25 |
LAST_UPDATE_DATE |
Date associated with last update. |
DATE |
|
LAST_UPDATE_USER |
Last update user associated with the record. |
VARCHAR2 |
12 |
PERSONNEL_KEY |
Surrogate key identifying the personnel. |
VARCHAR2 |
8 |
ROOM_SET_ID |
Business identifier for the room set. |
VARCHAR2 |
45 |
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |