HR EMPLOYEE EMERGENCY CONTACT Table
Stores employee emergency contact and related communication details used for safety, emergency response, and administrative purposes.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
CAMPUS_EMERG_CELL_PHONE |
Campus emergency mobile phone number associated with the employee. |
VARCHAR2 |
30 |
CAMPUS_EMERG_EMAIL |
Campus emergency email address associated with the employee. |
VARCHAR2 |
50 |
CAMPUS_EMERG_INTRNL_PHONE |
Campus internal emergency phone number for the employee. |
VARCHAR2 |
30 |
CAMPUS_EMERG_PAGER |
Campus emergency pager number associated with the employee. |
VARCHAR2 |
30 |
DIRECTORY_FULL_NAME |
Employee name formatted for directory or display use. |
VARCHAR2 |
85 |
EMAIL_ADDRESS |
Primary email address for the employee. |
VARCHAR2 |
100 |
EMERGENCY_ADDR_CITY |
City for the employee emergency address. |
VARCHAR2 |
40 |
EMERGENCY_ADDR_COUNTRY |
Country for the employee emergency address. |
VARCHAR2 |
20 |
EMERGENCY_ADDR_STATE |
State or province for the employee emergency address. |
VARCHAR2 |
10 |
EMERGENCY_ADDR_STREET1 |
Street address line 1 for the employee emergency address. |
VARCHAR2 |
60 |
EMERGENCY_ADDR_STREET2 |
Street address line 2 for the employee emergency address. |
VARCHAR2 |
55 |
EMERGENCY_ADDR_ZIP |
Postal code for the employee emergency address. |
VARCHAR2 |
10 |
EMERGENCY_CELL_PHONE |
Mobile phone number for the emergency contact. |
VARCHAR2 |
20 |
EMERGENCY_CONTACT_EMAIL |
Email address for the designated emergency contact. |
VARCHAR2 |
70 |
EMERGENCY_CONTACT_NAME |
Name of the individual designated as the employee emergency contact. |
VARCHAR2 |
50 |
EMERGENCY_CONTACT_RELATION |
Relationship of the emergency contact to the employee (e.g., spouse, parent). |
VARCHAR2 |
20 |
EMERGENCY_HOME_PHONE |
Home phone number for the emergency contact. |
VARCHAR2 |
30 |
EMERGENCY_WORK_PHONE |
Work phone number for the emergency contact. |
VARCHAR2 |
20 |
FIRST_NAME |
Employee first name as recorded for emergency contact purposes. |
VARCHAR2 |
40 |
FULL_NAME |
Full legal or preferred name of the employee. |
VARCHAR2 |
100 |
LAST_NAME |
Employee last name as recorded for emergency contact purposes. |
VARCHAR2 |
40 |
MIDDLE_NAME |
Employee middle name or initial, if available. |
VARCHAR2 |
40 |
MIT_ID |
MIT ID number of the employee. Use this field to join with other tables containing data about people at MIT. |
VARCHAR2 |
9 |
OFFICE_LOCATION |
Primary office or campus location associated with the employee. |
VARCHAR2 |
40 |
OFFICE_PHONE |
Office phone number for the employee. |
VARCHAR2 |
15 |