MIT APPOINTMENT ALL Table
View exposing MIT appointment detail including person, appointment type, position, job, department, DLC, employment percentage, and current-appointment indicators.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
APPOINTMENT_TYPE |
Appointment type associated with the record. |
VARCHAR2 |
30 |
APPT_BEGIN_DATE |
Date associated with appt begin. |
DATE |
|
APPT_END_DATE |
Date associated with appt end. |
DATE |
|
DLC_NAME |
Dlc name associated with the record. |
VARCHAR2 |
70 |
HR_DEPARTMENT_NAME |
Hr department name associated with the record. |
VARCHAR2 |
100 |
IS_CURRENT_APPOINTMENT |
Indicator identifying whether current appointment (Y/N). |
VARCHAR2 |
1 |
IS_CYBORG_APPOINTMENT |
Indicator identifying whether cyborg appointment (Y/N). |
VARCHAR2 |
1 |
JOB_TITLE |
Job title associated with the record. |
VARCHAR2 |
50 |
MIT_ID |
MIT ID number of the person. Use this field to join with other tables containing data about people at MIT. |
VARCHAR2 |
9 |
ORIGINAL_EMPLOYMENT_PERCENT |
Original employment percent associated with the record. |
NUMBER |
17,8 |
POSITION_ID |
Business identifier for the position. |
VARCHAR2 |
15 |
POSITION_TITLE |
Position title associated with the record. |
VARCHAR2 |
50 |
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |