EHS ROOM SET CONTACT DETAIL Table
EHS room_set->contact_person->room detail information
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
CONTACT_DATA_SOURCE |
The source of data for the phone number of the contact person. 'User' means the phone number or office address was reported by the EHS coordinator or other administrator. 'Warehouse' means the data was fed to the EHS system from HR or the Student Information Systems via the Warehouse. |
VARCHAR2 |
12 |
CONTACT_OFFICE_LOCATION |
An office building-rom number for the contact person. |
VARCHAR2 |
30 |
CONTACT_PERSON_KEY |
Internal key for the contact person. Use this field to join with ehs_contact_person and detail tables. |
VARCHAR2 |
8 |
CONTACT_PHONE_NUMBER |
A phone number for the contact person. |
VARCHAR2 |
20 |
CONTACT_PHONE_SORT |
The sort order of the phone number within phone numbers for this contact person. |
NUMBER |
22 |
CONTACT_PHONE_TYPE |
A short description of the phone type of the contact person. |
VARCHAR2 |
6 |
CONTACT_PHONE_TYPE_CODE |
The code for the phone type of the contact person, e.g., 'O' for office, 'H' for home, etc.. |
VARCHAR2 |
1 |
CONTACT_SUPPRESS_FLAG |
If 'Y', then the phone number is suppressed and should be hidden from all people except a few specially authorized EHS administrators or emergency response people. If 'N', then the phone number is available to a larger set of EHS administrators. This field controls who sees the phone number via the web interface or in the Warehouse. See the show_phone_on_greencard field to see whether the phone number is shown on the green card for this Room Set. |
VARCHAR2 |
1 |
EHS_ROOM_KEY |
The internal key for a room within a building. Use this key for joining ehs_room, ehs_room_set, ehs_room_set_detail and ehs_room_set_contact_detail tables. |
VARCHAR2 |
16 |
EHS_ROOM_SET_KEY |
Internal key for a room set. Join to ehs_room, ehs_room_set_detail and ehs_room_set_contact_detail tables. A room is a set of rooms with a supervisor, an EHS representative, some contact people, and some hazard types. |
NUMBER |
12 |
RECORD_COUNTER |
Used to count records within a group on a report. Always contains a value of 1. |
NUMBER |
1 |
ROOM_SET_CONTACT_SORT |
The sort order for contact people within a room set. |
NUMBER |
22 |
SHOW_PHONE_ON_GREENCARD |
If 'Y', the phone number is shown on the green card for this Room Set. If 'N', it is not shown on the green card. |
VARCHAR2 |
1 |
WAREHOUSE_LOAD_DATE |
The date the record was loaded into the Data Warehouse from the source system. |
DATE |
8 |