EHS ROOM SET CONTACT DETAIL Table
View exposing contact detail records associated with Environment, Health, and Safety room sets and related compliance responsibilities.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
CONTACT_DATA_SOURCE |
Contact data source associated with the record. |
VARCHAR2 |
12 |
CONTACT_OFFICE_LOCATION |
Contact office location associated with the record. |
VARCHAR2 |
30 |
CONTACT_PERSON_KEY |
Surrogate key identifying the contact person. |
VARCHAR2 |
8 |
CONTACT_PHONE_NUMBER |
Contact phone number associated with the record. |
VARCHAR2 |
20 |
CONTACT_PHONE_SORT |
Contact phone sort associated with the record. |
NUMBER |
5 |
CONTACT_PHONE_TYPE |
Contact phone type associated with the record. |
VARCHAR2 |
6 |
CONTACT_PHONE_TYPE_CODE |
Contact phone type code associated with the record. |
VARCHAR2 |
1 |
CONTACT_SUPPRESS_FLAG |
Contact suppress flag associated with the record. |
VARCHAR2 |
1 |
EHS_ROOM_KEY |
Surrogate key identifying the ehs room. |
VARCHAR2 |
16 |
EHS_ROOM_SET_KEY |
Surrogate key identifying the ehs room set. |
NUMBER |
12 |
RECORD_COUNTER |
Record counter associated with the record. |
NUMBER |
1 |
ROOM_SET_CONTACT_SORT |
Room set contact sort associated with the record. |
NUMBER |
5 |
SHOW_PHONE_ON_GREENCARD |
Show phone on greencard associated with the record. |
VARCHAR2 |
1 |
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |