EMPLOYEE Table
View exposing employee records for MIT personnel, including workforce attributes used for reporting and analysis.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
ACTIVITY_DATE |
Date associated with activity. |
DATE |
|
ADJUSTED_SERVICE_DATE |
Date associated with adjusted service. |
DATE |
|
AGE |
Age associated with the record. |
NUMBER |
3 |
AGE_BY_FISCAL_YEAR |
Age by fiscal year associated with the record. |
NUMBER |
3 |
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_OF_BIRTH |
Date of birth associated with the person. |
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 |
EIGHT_YEARS_OF_SERVICE |
Eight years of service associated with the record. |
VARCHAR2 |
4 |
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 |
GENDER |
Gender associated with the record. |
VARCHAR2 |
30 |
HAS_VISA |
Has visa associated with the record. |
VARCHAR2 |
5 |
HIRE_DATE |
Date associated with hire. |
DATE |
|
HOME_ADDRESS1 |
Home address1 associated with the record. |
VARCHAR2 |
0 |
HOME_ADDRESS2 |
Home address2 associated with the record. |
VARCHAR2 |
0 |
HOME_CITY |
Home city associated with the record. |
VARCHAR2 |
0 |
HOME_COUNTRY |
Home country associated with the record. |
VARCHAR2 |
0 |
HOME_PHONE |
Home phone associated with the record. |
VARCHAR2 |
0 |
HOME_STATE |
Home state associated with the record. |
VARCHAR2 |
0 |
HOME_ZIP_CODE |
Home zip code associated with the record. |
VARCHAR2 |
0 |
ID_PROVIDED |
Id provided associated with the record. |
VARCHAR2 |
30 |
ID_VERIFIED |
Id verified associated with the record. |
VARCHAR2 |
30 |
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 |
|
LAST_YEAR |
Last year associated with the record. |
VARCHAR2 |
4 |
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 |
RACE |
Race associated with the record. |
VARCHAR2 |
30 |
RETIRE_DATE_AT_65 |
Retire date at 65 associated with the record. |
DATE |
|
RETIRE_DATE_AT_70 |
Retire date at 70 associated with the record. |
DATE |
|
SALARY_REVIEW_COMMENTS |
Salary review comments 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 |
SSN |
Ssn associated with the record. |
VARCHAR2 |
0 |
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 |