APPOINTMENT LIMITED Table
View exposing a limited subset of appointment records for MIT personnel, including selected appointment attributes used for appointment reporting and workforce analysis.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
APPOINTMENT_END_DATE |
Date associated with appointment end. |
DATE |
|
APPOINTMENT_START_DATE |
Date associated with appointment start. |
DATE |
|
APPOINTMENT_TYPE |
Appointment type as provided by the source. |
VARCHAR2 |
30 |
DEPARTMENT_ID |
Business identifier for the department. |
VARCHAR2 |
6 |
DEPARTMENT_NAME |
Department name as provided by the source. |
VARCHAR2 |
50 |
DOL_JOB_GROUP |
Dol job group as provided by the source. |
VARCHAR2 |
30 |
FULL_NAME |
Full name as provided by the source. |
VARCHAR2 |
90 |
IS_ADMINISTRATIVE_STAFF |
Indicator identifying whether administrative staff (Y/N). |
VARCHAR2 |
5 |
IS_FACULTY |
Indicator identifying whether faculty (Y/N). |
VARCHAR2 |
5 |
IS_GRADUATE_STUDENT_STAFF |
Indicator identifying whether graduate student staff (Y/N). |
VARCHAR2 |
5 |
IS_MEDICAL_STAFF |
Indicator identifying whether medical staff (Y/N). |
VARCHAR2 |
5 |
IS_OTHER_ACADEMIC_GROUP |
Indicator identifying whether other academic group (Y/N). |
VARCHAR2 |
5 |
IS_SERVICE_STAFF |
Indicator identifying whether service staff (Y/N). |
VARCHAR2 |
5 |
IS_SPONSORED_RESEARCH_STAFF |
Indicator identifying whether sponsored research staff (Y/N). |
VARCHAR2 |
5 |
IS_SUPPORT_STAFF |
Indicator identifying whether support staff (Y/N). |
VARCHAR2 |
5 |
JOB_CHANGE_TYPE |
Job change type as provided by the source. |
VARCHAR2 |
20 |
JOB_CODE |
Code identifying job. |
VARCHAR2 |
6 |
JOB_TITLE |
Job title as provided by the source. |
VARCHAR2 |
50 |
LEVEL_1 |
Level 1 as provided by the source. |
VARCHAR2 |
100 |
LEVEL_2 |
Level 2 as provided by the source. |
VARCHAR2 |
100 |
LEVEL_3 |
Level 3 as provided by the source. |
VARCHAR2 |
100 |
LEVEL_4 |
Level 4 as provided by the source. |
VARCHAR2 |
100 |
LEVEL_5 |
Level 5 as provided by the source. |
VARCHAR2 |
100 |
MIT_ID |
MIT ID number of the person. Use this field to join with other tables containing data about people at MIT. |
VARCHAR2 |
9 |
PERCENT_EFFORT |
Percent effort as provided by the source. |
NUMBER |
4,1 |
PREFERRED_JOB_TITLE |
Preferred job title as provided by the source. |
VARCHAR2 |
51 |
PRIMARY_SECONDARY_INDICATOR |
Primary secondary indicator as provided by the source. |
VARCHAR2 |
30 |
RANK_TYPE |
Rank type as provided by the source. |
VARCHAR2 |
50 |
SALARY_REVIEW_CATEGORY |
Salary review category as provided by the source. |
VARCHAR2 |
30 |
TRANSACTION_END_DATE |
Date associated with transaction end. |
DATE |
|
TRANSACTION_START_DATE |
Date associated with transaction start. |
DATE |
|
UNION_JOB_CODE |
Code identifying union job. |
VARCHAR2 |
30 |
WORK_HOURS |
Work hours as provided by the source. |
NUMBER |
4,2 |