DEPARTMENT EMPLOYEE DIRECTORY Table
Departmental Employee Telephone Directory for DLC Adminitrators
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
ADMIN_EMPLOYEE_TYPE |
This field contains employee type (Faculty, Support Staff, etc.) as defined by their position in their admin department. For people with only one position, this is always the same as EMPLOYEE_TYPE. |
VARCHAR2 |
40 |
ADMIN_ORG_UNIT_ID |
The SAP 8-digit object id assigned to the employee's administrative org unit. |
VARCHAR2 |
8 |
ADMIN_ORG_UNIT_NAME |
XXX |
VARCHAR2 |
20 |
ADMIN_ORG_UNIT_NUMBER |
XXX |
VARCHAR2 |
6 |
ADMIN_ORG_UNIT_TITLE |
The title of employee's administrative org unit. |
VARCHAR2 |
75 |
ALTERNATE_OFFICE_ADDRESS |
The person's secondary office address |
VARCHAR2 |
40 |
ALTERNATE_OFFICE_PHONE |
The telephone extension in the person's secondary office |
VARCHAR2 |
14 |
ALT_OFFICE_ADDRESS_MIT_SITE |
The person's alternate MIT office address |
VARCHAR2 |
14 |
DIRECTORY_DEPT_OVERRIDE |
XXX |
VARCHAR2 |
80 |
DIRECTORY_FULL_NAME |
XXX |
VARCHAR2 |
85 |
DIRECTORY_INCLUDE_INSTRUCTIONS |
Whether to include or suppress a person's information |
VARCHAR2 |
8 |
DIRECTORY_ORG_UNIT_ID |
The 8-digit number of the organizational unit to be listed in the MIT directory. |
VARCHAR2 |
8 |
DIRECTORY_ORG_UNIT_NAME |
same as Department name |
VARCHAR2 |
50 |
DIRECTORY_ORG_UNIT_NUMBER |
same as Department number |
VARCHAR2 |
12 |
DIRECTORY_TITLE |
A person's position title as listed in the MIT directory; this will be the person's "preferred" title if they specify a descriptive title that differs from their official MIT title (Primary_Title). |
VARCHAR2 |
50 |
DIRECTORY_TITLE_OVERRIDE |
XXX |
VARCHAR2 |
200 |
EMAIL_ADDRESS |
A person's complete electronic mail address including user name and node name, for example, username@school.edu. |
VARCHAR2 |
60 |
ESS_LAST_VIEW_DATE |
The date that an individual last reviewed his/her record for accuracy. |
DATE |
8 |
FAX_NUMBER |
The employee's FAX number. |
VARCHAR2 |
31 |
FIRST_AND_MIDDLE_NAME_OVERRIDE |
XXX |
VARCHAR2 |
160 |
FIRST_NAME |
The person's first name. |
VARCHAR2 |
30 |
FULL_NAME |
The full name of the person. |
VARCHAR2 |
90 |
HOME_ADDRESS_LINE_1 |
Home address, street line 1. |
VARCHAR2 |
60 |
HOME_ADDRESS_LINE_2 |
Home address, street line 2. |
VARCHAR2 |
40 |
HOME_CITY |
The person's home city. |
VARCHAR2 |
30 |
HOME_COUNTRY |
The person's home country. |
VARCHAR2 |
30 |
HOME_PHONE |
The person's home telephone number. |
VARCHAR2 |
20 |
HOME_STATE |
The person's home state. |
VARCHAR2 |
2 |
HOME_ZIP |
Zip code in home address. |
VARCHAR2 |
10 |
INCLUDE_HOME_ADDR_IN_DIRECTORY |
XXX |
VARCHAR2 |
3 |
LAST_NAME |
The person's last name. |
VARCHAR2 |
30 |
LAST_NAME_OVERRIDE |
XXX |
VARCHAR2 |
160 |
MIDDLE_NAME |
The person's middle name (where available). |
VARCHAR2 |
30 |
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 |
The person's MIT mobile (cell phone) number, if any. |
VARCHAR2 |
30 |
OFFICE_ADDRESS |
Employee's primary office address, for example, W92-101, LL-B 341 |
VARCHAR2 |
40 |
OFFICE_ADDRESS_MIT_SITE |
The person's primary office address on the main MIT campus (as opposed, e.g., to Lincoln Lab) |
VARCHAR2 |
14 |
OFFICE_PHONE |
The person's primary office telephone number at MIT. |
VARCHAR2 |
20 |
ORG_UNIT_ID |
XXX |
VARCHAR2 |
8 |
ORG_UNIT_NAME |
Same as the Department name |
VARCHAR2 |
50 |
ORG_UNIT_NUMBER |
Same as the Department number |
VARCHAR2 |
6 |
PAGER_NUMBER |
The person's MIT pager number, if any |
VARCHAR2 |
30 |
PERSONAL_URL |
The employee's personal URL. |
VARCHAR2 |
241 |
PERSONNEL_SUBAREA |
Text that further identifies the personnel area into sub groupings of Positions,e.g., Admin Staff, Support Staff. Similar to the old Rank Lists values. |
VARCHAR2 |
30 |
PRIMARY_TITLE |
A person's primary appointment title. |
VARCHAR2 |
51 |