EHS ROOM REPRESENTATIVE Table
XXX
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
EHSS_RM_RELATION_END_DATE |
XXX |
DATE |
|
EHSS_RM_RELATION_START_DATE |
XXX |
DATE |
|
EHSS_ROOM_RELATIONSHIP |
XXX |
VARCHAR2 |
25 |
EHSS_ROOM_RELATIONSHIP_CODE |
XXX |
VARCHAR2 |
4 |
EHSS_ROOM_SET_OBJECT_TYPE |
XXX |
VARCHAR2 |
25 |
EHSS_ROOM_SET_TYPE |
XXX |
VARCHAR2 |
25 |
LAST_UPDATE_DATE |
Date the description was created or last altered. |
DATE |
|
LAST_UPDATE_USER |
Last person that changed this record. |
VARCHAR2 |
12 |
PERSONNEL_KEY |
Key field used to join to the PERSONNEL table. This field should only be used for joining data, NOT for reporting. |
VARCHAR2 |
8 |
ROOM_SET_ID |
XXX |
VARCHAR2 |
45 |
WAREHOUSE_LOAD_DATE |
The date the record was loaded into the Data Warehouse from the source system. |
DATE |