HR STUDENT APPOINTMENT DETAIL Table
View exposing student employee appointment details including appointment dates, position and job attributes, organizational assignments, and related student employment measures used for workforce reporting.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
APPT_BEGIN_DATE |
Column APPT_BEGIN_DATE. |
DATE |
|
APPT_END_DATE |
Column APPT_END_DATE. |
DATE |
|
APPT_SUBTYPE |
Column APPT_SUBTYPE. |
VARCHAR2 |
100 |
APPT_SUBTYPE_CODE |
Column APPT_SUBTYPE_CODE. |
VARCHAR2 |
4 |
HR_ORG_UNIT_KEY |
Column HR_ORG_UNIT_KEY. |
VARCHAR2 |
10 |
HR_POSITION_KEY |
Column HR_POSITION_KEY. |
VARCHAR2 |
10 |
IS_CURRENT_APPOINTMENT |
Column IS_CURRENT_APPOINTMENT. |
CHAR |
|
IS_EXEMPT_EMPLOYEE |
Column IS_EXEMPT_EMPLOYEE. |
VARCHAR2 |
1 |
IS_FUTURE_APPOINTMENT |
Column IS_FUTURE_APPOINTMENT. |
CHAR |
|
IS_HOURLY_PAID_STUDENT |
Column IS_HOURLY_PAID_STUDENT. |
VARCHAR2 |
1 |
LAST_UPDATE_DATE |
Column LAST_UPDATE_DATE. |
DATE |
|
LAST_UPDATE_USER |
Column LAST_UPDATE_USER. |
VARCHAR2 |
12 |
LINK_FIELD |
Column LINK_FIELD. |
VARCHAR2 |
10 |
MIT_ID |
MIT ID number of the person. Use this field to join with other tables containing data about people at MIT. |
VARCHAR2 |
9 |
PAY_BEGIN_DATE |
Column PAY_BEGIN_DATE. |
DATE |
|
PAY_END_DATE |
Column PAY_END_DATE. |
DATE |
|
PERSONNEL_KEY |
Column PERSONNEL_KEY. |
VARCHAR2 |
8 |
WAREHOUSE_LOAD_DATE |
Column WAREHOUSE_LOAD_DATE. |
DATE |