EMPLOYEE LIMITED Table
View exposing a limited subset of employee records for MIT personnel, including selected workforce attributes used for reporting and analysis.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
ADJUSTED_SERVICE_DATE |
Date associated with adjusted service. |
DATE |
|
BENEFITS_ELIGIBILITY |
Benefits eligibility associated with the record. |
VARCHAR2 |
30 |
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 |
COUNTRY_OF_CITIZENSHIP |
Country of citizenship associated with the record. |
VARCHAR2 |
30 |
DATE_LAST_UPDATED |
Date last updated associated with the record. |
DATE |
|
DATE_TO_FACULTY |
Date to faculty associated with the record. |
DATE |
|
DEGREE |
Degree associated with the record. |
VARCHAR2 |
11 |
DIRECTORY_DEPARTMENT |
Directory department associated with the record. |
VARCHAR2 |
30 |
DIRECTORY_SUPPRESSION |
Directory suppression associated with the record. |
VARCHAR2 |
30 |
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 |
EMERGENCY_CONTACT_HOME_PHONE |
Emergency contact home phone associated with the record. |
VARCHAR2 |
0 |
EMERGENCY_CONTACT_NAME |
Emergency contact name associated with the record. |
VARCHAR2 |
0 |
EMERGENCY_CONTACT_WORK_PHONE |
Emergency contact work phone associated with the record. |
VARCHAR2 |
0 |
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 |
HAS_VISA |
Has visa associated with the record. |
VARCHAR2 |
5 |
HIRE_DATE |
Date associated with hire. |
DATE |
|
IS_ACTIVE_NON_RETIRED |
Indicator identifying whether active non retired (Y/N). |
VARCHAR2 |
5 |
IS_ACTIVE_RETIRED |
Indicator identifying whether active retired (Y/N). |
VARCHAR2 |
5 |
IS_CURRENT_TODAY |
Indicator identifying whether current today (Y/N). |
VARCHAR2 |
5 |
IS_DECEASED |
Indicator identifying whether deceased (Y/N). |
VARCHAR2 |
5 |
IS_DISABLED |
Indicator identifying whether disabled (Y/N). |
VARCHAR2 |
5 |
IS_LAID_OFF |
Indicator identifying whether laid off (Y/N). |
VARCHAR2 |
5 |
IS_NOT_CURRENT_TODAY |
Indicator identifying whether not current today (Y/N). |
VARCHAR2 |
5 |
IS_ON_LEAVE |
Indicator identifying whether on leave (Y/N). |
VARCHAR2 |
5 |
IS_ON_LTD |
Indicator identifying whether on ltd (Y/N). |
VARCHAR2 |
5 |
IS_ON_PAID_LEAVE |
Indicator identifying whether on paid leave (Y/N). |
VARCHAR2 |
5 |
IS_ON_UNPAID_LEAVE |
Indicator identifying whether on unpaid leave (Y/N). |
VARCHAR2 |
5 |
IS_RETIRED |
Indicator identifying whether retired (Y/N). |
VARCHAR2 |
5 |
IS_RETIRED_NON_ACTIVE |
Indicator identifying whether retired non active (Y/N). |
VARCHAR2 |
5 |
IS_TERMINATED |
Indicator identifying whether terminated (Y/N). |
VARCHAR2 |
5 |
IS_UNDEFINED |
Indicator identifying whether undefined (Y/N). |
VARCHAR2 |
5 |
IS_VETERAN |
Indicator identifying whether veteran (Y/N). |
VARCHAR2 |
5 |
LAST_NAME |
Last name associated with the record. |
VARCHAR2 |
30 |
LAST_PROMOTION_DATE |
Date associated with last promotion. |
DATE |
|
LAST_TRANSFER_DATE |
Date associated with last transfer. |
DATE |
|
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 |
SALUTATION |
Salutation 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 |
|
SOURCE |
Source associated with the record. |
VARCHAR2 |
30 |
TENURE_DATE |
Date associated with tenure. |
DATE |
|
TERMINATION_DATE |
Date associated with termination. |
DATE |
|
UNION_SENIORITY |
Union seniority associated with the record. |
DATE |
|
USER_NAME |
User name associated with the record. |
VARCHAR2 |
60 |
VETERAN_TYPE |
Veteran type associated with the record. |
VARCHAR2 |
30 |
VISA_CODE |
Code identifying visa. |
VARCHAR2 |
20 |
VISA_RENEWAL_DATE |
Date associated with visa renewal. |
DATE |
|
VISA_TYPE |
Visa type associated with the record. |
VARCHAR2 |
30 |
YEAR_35 |
Year 35 associated with the record. |
VARCHAR2 |
4 |
YEAR_GRADUATED |
Year graduated associated with the record. |
VARCHAR2 |
30 |