EMPLOYEE DIRECTORY FULL Table
View exposing comprehensive employee directory records including contact, organizational, and related employee attributes used for directory reporting and lookup.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
ALTERNATE_OFFICE_ADDRESS |
Alternate office address associated with the record. |
VARCHAR2 |
40 |
ALTERNATE_OFFICE_PHONE |
Alternate office phone associated with the record. |
VARCHAR2 |
15 |
ALT_OFFICE_ADDRESS_MIT_SITE |
Alt office address mit site associated with the record. |
VARCHAR2 |
14 |
DIRECTORY_FULL_NAME |
Directory full name associated with the record. |
VARCHAR2 |
85 |
DIRECTORY_ORG_UNIT_NAME |
Directory org unit name associated with the record. |
VARCHAR2 |
20 |
DIRECTORY_ORG_UNIT_NUMBER |
Directory org unit number associated with the record. |
VARCHAR2 |
6 |
DIRECTORY_TITLE |
Directory title associated with the record. |
VARCHAR2 |
50 |
EMAIL_ADDRESS |
Email address associated with the record. |
VARCHAR2 |
100 |
FIRST_NAME |
First name associated with the record. |
VARCHAR2 |
40 |
FULL_NAME |
Full name associated with the record. |
VARCHAR2 |
100 |
LAST_NAME |
Last name associated with the record. |
VARCHAR2 |
40 |
MIDDLE_NAME |
Middle name associated with the record. |
VARCHAR2 |
40 |
MIT_ID |
MIT ID number of the person. Use this field to join with other tables containing data about people at MIT. |
VARCHAR2 |
9 |
OFFICE_ADDRESS |
Office address associated with the record. |
VARCHAR2 |
40 |
OFFICE_ADDRESS_MIT_SITE |
Office address mit site associated with the record. |
VARCHAR2 |
14 |
OFFICE_ADDR_SITE |
Office addr site associated with the record. |
VARCHAR2 |
2 |
OFFICE_PHONE |
Office phone associated with the record. |
VARCHAR2 |
15 |