HR STUDENT ACTION DETAIL Table
View exposing student employee action records including action dates, action types, appointment attributes, and related workforce transaction details used for student employment reporting.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
EMPLOYMENT_STATUS |
Column EMPLOYMENT_STATUS. |
VARCHAR2 |
40 |
EMPLOYMENT_STATUS_CODE |
Column EMPLOYMENT_STATUS_CODE. |
VARCHAR2 |
1 |
HR_PERSONNEL_ACTION_TYPE_KEY |
Column HR_PERSONNEL_ACTION_TYPE_KEY. |
VARCHAR2 |
8 |
LAST_UPDATE_DATE |
Column LAST_UPDATE_DATE. |
DATE |
|
LAST_UPDATE_USER |
Column LAST_UPDATE_USER. |
VARCHAR2 |
12 |
MIT_ID |
MIT ID number of the person. Use this field to join with other tables containing data about people at MIT. |
VARCHAR2 |
9 |
PERSONNEL_ACTION_BEGIN_DATE |
Column PERSONNEL_ACTION_BEGIN_DATE. |
DATE |
|
PERSONNEL_ACTION_END_DATE |
Column PERSONNEL_ACTION_END_DATE. |
DATE |
|
PERSONNEL_KEY |
Column PERSONNEL_KEY. |
VARCHAR2 |
8 |
RECORD_COUNTER |
Column RECORD_COUNTER. |
NUMBER |
|
SAP_STATUS |
Column SAP_STATUS. |
VARCHAR2 |
40 |
SAP_STATUS_CODE |
Column SAP_STATUS_CODE. |
VARCHAR2 |
1 |