DEPARTMENT EMPLOYEE DIRECTORY Table
View exposing department employee directory records including person identifiers, names, contact information, and organizational assignment attributes used for directory and administrative contact purposes.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
ADMIN_EMPLOYEE_TYPE |
Admin employee type as provided by the source. |
VARCHAR2 |
40 |
ADMIN_ORG_UNIT_ID |
Business identifier for the admin org unit. |
VARCHAR2 |
8 |
ADMIN_ORG_UNIT_NAME |
Admin org unit name as provided by the source. |
VARCHAR2 |
20 |
ADMIN_ORG_UNIT_NUMBER |
Admin org unit number as provided by the source. |
VARCHAR2 |
6 |
ADMIN_ORG_UNIT_TITLE |
Admin org unit title as provided by the source. |
VARCHAR2 |
75 |
ALTERNATE_OFFICE_ADDRESS |
Alternate office address as provided by the source. |
VARCHAR2 |
40 |
ALTERNATE_OFFICE_PHONE |
Phone number associated with the record. |
VARCHAR2 |
15 |
ALT_OFFICE_ADDRESS_MIT_SITE |
Alt office address mit site as provided by the source. |
VARCHAR2 |
14 |
DIRECTORY_DEPT_OVERRIDE |
Directory dept override as provided by the source. |
VARCHAR2 |
20 |
DIRECTORY_FULL_NAME |
Directory full name as provided by the source. |
VARCHAR2 |
85 |
DIRECTORY_INCLUDE_INSTRUCTIONS |
Directory include instructions as provided by the source. |
VARCHAR2 |
24 |
DIRECTORY_ORG_UNIT_ID |
Business identifier for the directory org unit. |
VARCHAR2 |
8 |
DIRECTORY_ORG_UNIT_NAME |
Directory org unit name as provided by the source. |
VARCHAR2 |
20 |
DIRECTORY_ORG_UNIT_NUMBER |
Directory org unit number as provided by the source. |
VARCHAR2 |
6 |
DIRECTORY_TITLE |
Directory title as provided by the source. |
VARCHAR2 |
50 |
DIRECTORY_TITLE_OVERRIDE |
Directory title override as provided by the source. |
VARCHAR2 |
50 |
EMAIL_ADDRESS |
Email address associated with the record. |
VARCHAR2 |
100 |
ESS_LAST_VIEW_DATE |
Date associated with ess last view. |
DATE |
|
FAX_NUMBER |
Fax number as provided by the source. |
VARCHAR2 |
20 |
FIRST_AND_MIDDLE_NAME_OVERRIDE |
First and middle name override as provided by the source. |
VARCHAR2 |
40 |
FIRST_NAME |
First name as provided by the source. |
VARCHAR2 |
40 |
FULL_NAME |
Full name as provided by the source. |
VARCHAR2 |
100 |
HOME_ADDRESS_LINE_1 |
Home address line 1 as provided by the source. |
VARCHAR2 |
60 |
HOME_ADDRESS_LINE_2 |
Home address line 2 as provided by the source. |
VARCHAR2 |
40 |
HOME_CITY |
Home city as provided by the source. |
VARCHAR2 |
40 |
HOME_COUNTRY |
Home country as provided by the source. |
VARCHAR2 |
20 |
HOME_PHONE |
Phone number associated with the record. |
VARCHAR2 |
15 |
HOME_STATE |
Home state as provided by the source. |
VARCHAR2 |
3 |
HOME_ZIP |
Home zip as provided by the source. |
VARCHAR2 |
10 |
INCLUDE_HOME_ADDR_IN_DIRECTORY |
Include home addr in directory as provided by the source. |
VARCHAR2 |
3 |
LAST_NAME |
Last name as provided by the source. |
VARCHAR2 |
40 |
LAST_NAME_OVERRIDE |
Last name override as provided by the source. |
VARCHAR2 |
40 |
MIDDLE_NAME |
Middle name as provided by the source. |
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 |
MOBILE_TELEPHONE |
Phone number associated with the record. |
VARCHAR2 |
15 |
OFFICE_ADDRESS |
Office address as provided by the source. |
VARCHAR2 |
40 |
OFFICE_ADDRESS_MIT_SITE |
Office address mit site as provided by the source. |
VARCHAR2 |
14 |
OFFICE_PHONE |
Phone number associated with the record. |
VARCHAR2 |
15 |
ORG_UNIT_ID |
Business identifier for the org unit. |
VARCHAR2 |
8 |
ORG_UNIT_NAME |
Org unit name as provided by the source. |
VARCHAR2 |
20 |
ORG_UNIT_NUMBER |
Org unit number as provided by the source. |
VARCHAR2 |
6 |
PAGER_NUMBER |
Pager number as provided by the source. |
VARCHAR2 |
20 |
PERSONAL_URL |
Personal url as provided by the source. |
VARCHAR2 |
150 |
PERSONNEL_SUBAREA |
Personnel subarea as provided by the source. |
VARCHAR2 |
40 |
PRIMARY_TITLE |
Primary title as provided by the source. |
VARCHAR2 |
50 |