EMPLOYEE BASIC Table
View exposing core employee records for MIT personnel, including basic workforce attributes used for reporting and analysis.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
ADJUSTED_SERVICE_DATE |
Date associated with adjusted service. |
DATE |
|
CHAIR_END_DATE |
Date associated with chair end. |
DATE |
|
CHAIR_START_DATE |
Date associated with chair start. |
DATE |
|
CHAIR_TITLE |
Chair title associated with the record. |
VARCHAR2 |
51 |
DATE_TO_FACULTY |
Date to faculty associated with the record. |
VARCHAR2 |
10 |
DEGREE |
Degree associated with the record. |
VARCHAR2 |
11 |
DIRECTORY_TITLE |
Directory title associated with the record. |
VARCHAR2 |
50 |
EDUCATION_LEVEL |
Education level associated with the record. |
VARCHAR2 |
30 |
EMAIL_ADDRESS |
Email address associated with the record. |
VARCHAR2 |
60 |
EMPLOYEE_STAFF_DATE |
Date associated with employee staff. |
DATE |
|
FIRST_NAME |
First name associated with the record. |
VARCHAR2 |
30 |
FULL_NAME |
Full name associated with the record. |
VARCHAR2 |
90 |
HIRE_DATE |
Date associated with hire. |
DATE |
|
IS_CURRENT_TODAY |
Indicator identifying whether current today (Y/N). |
VARCHAR2 |
5 |
IS_NOT_CURRENT_TODAY |
Indicator identifying whether not current today (Y/N). |
VARCHAR2 |
5 |
LAST_NAME |
Last name associated with the record. |
VARCHAR2 |
30 |
LENGTH_OF_SERVICE |
Length of service associated with the record. |
NUMBER |
3 |
MAJOR |
Major associated with the record. |
VARCHAR2 |
30 |
MIDDLE_NAME |
Middle name associated with the record. |
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 |
OFFICE_LOCATION |
Office location associated with the record. |
VARCHAR2 |
30 |
OFFICE_PHONE |
Office phone associated with the record. |
VARCHAR2 |
20 |
ORIGINAL_HIRE_DATE |
Date associated with original hire. |
DATE |
|
PRIMARY_TITLE |
Primary title associated with the record. |
VARCHAR2 |
51 |
PRIOR_NAME |
Prior name associated with the record. |
VARCHAR2 |
30 |
SCHOOL |
School associated with the record. |
VARCHAR2 |
50 |
SECONDARY_OFFICE_LOCATION |
Secondary office location associated with the record. |
VARCHAR2 |
30 |
SECONDARY_OFFICE_PHONE |
Secondary office phone associated with the record. |
VARCHAR2 |
20 |
SEPARATION_DATE |
Date associated with separation. |
DATE |
|
TENURE_DATE |
Date associated with tenure. |
DATE |
|
TERMINATION_DATE |
Date associated with termination. |
DATE |
|
USER_NAME |
User name associated with the record. |
VARCHAR2 |
60 |
YEAR_GRADUATED |
Year graduated associated with the record. |
VARCHAR2 |
30 |