HR PERSONNEL ACTION DETAIL Table
View exposing detailed personnel action records including action dates, action types, related appointment and organizational attributes, and workforce event details used for employment history and transaction 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 |
WAREHOUSE_LOAD_DATE |
Column WAREHOUSE_LOAD_DATE. |
DATE |