BUDGET EMPLOYEE DIRECTORY Table
View exposing employee directory attributes used for budgeting and planning, including institutional identifiers, names, titles, departmental affiliation, and directory contact information.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
DEPARTMENT_NAME |
Organizational department name associated with the employee. |
VARCHAR2 |
75 |
DEPARTMENT_NUMBER |
Organizational department number associated with the employee. |
VARCHAR2 |
6 |
DIRECTORY_TITLE |
Title displayed in the institutional directory for the employee. |
VARCHAR2 |
50 |
EMAIL_ADDRESS |
Institutional email address associated with the employee. |
VARCHAR2 |
100 |
EMPLOYEE_TYPE |
Classification describing the employee category (e.g., faculty, staff, or other workforce types). |
VARCHAR2 |
40 |
FIRST_NAME |
First name of the employee as recorded in institutional directory data. |
VARCHAR2 |
40 |
FULL_NAME |
Full formatted name of the employee used for display and reporting. |
VARCHAR2 |
100 |
KRB_NAME |
Kerberos username used for authentication within MIT systems. |
VARCHAR2 |
8 |
KRB_NAME_UPPERCASE |
Kerberos username stored in uppercase format for system compatibility. |
VARCHAR2 |
8 |
LAST_NAME |
Last name of the employee as recorded in institutional directory data. |
VARCHAR2 |
40 |
MIDDLE_NAME |
Middle name or middle initial of the employee when available. |
VARCHAR2 |
40 |
MIT_ID |
MIT institutional identifier for the individual. Used to join and integrate person-related data across enterprise systems. |
VARCHAR2 |
9 |
OFFICE_LOCATION |
Office location or room assignment associated with the employee. |
VARCHAR2 |
40 |
OFFICE_PHONE |
Office telephone number listed in the institutional directory. |
VARCHAR2 |
15 |
PRIMARY_TITLE |
Primary job title associated with the employee?s appointment. |
VARCHAR2 |
50 |