EHS CONTACT PERSON Table
View exposing contact person records used in Environment, Health, and Safety administration and compliance coordination.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
APPOINTMENT_TYPE |
Appointment type associated with the record. |
VARCHAR2 |
30 |
CONTACT_EMAIL_ADDRESS |
Contact email address associated with the record. |
VARCHAR2 |
60 |
CONTACT_FIRST_NAME |
Contact first name associated with the record. |
VARCHAR2 |
30 |
CONTACT_FULL_NAME |
Contact full name associated with the record. |
VARCHAR2 |
100 |
CONTACT_KERBEROS_NAME |
Contact kerberos name associated with the record. |
VARCHAR2 |
8 |
CONTACT_LAST_NAME |
Contact last name associated with the record. |
VARCHAR2 |
30 |
CONTACT_MIDDLE_NAME |
Contact middle name associated with the record. |
VARCHAR2 |
30 |
CONTACT_PERSON_KEY |
Surrogate key identifying the contact person. |
VARCHAR2 |
8 |
EMPLOYEE_TITLE |
Employee title associated with the record. |
VARCHAR2 |
51 |
EMPLOYEE_UNIT_ID |
Business identifier for the employee unit. |
VARCHAR2 |
6 |
EMPLOYEE_UNIT_NAME |
Employee unit name associated with the record. |
VARCHAR2 |
50 |
MIT_ID |
MIT ID number of the person. Use this field to join with other tables containing data about people at MIT. |
VARCHAR2 |
9 |
STATUS_CODE |
Code identifying status. |
CHAR |
|
STUDENT_DEPARTMENT |
Student department associated with the record. |
VARCHAR2 |
4 |
STUDENT_YEAR |
Student year associated with the record. |
VARCHAR2 |
1 |
TYPE |
Type associated with the record. |
VARCHAR2 |
8 |
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |