HR PERSONNEL ACTION TYPE Table
Codes and descriptions of personnel actions and personnel action reasons. This table should be used in conjunction with HR_PERSONNEL_ACTION_DETAIL table.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
HR_ACTION_REASON |
Further definiton of action taken, correction to which field, type of increase. |
VARCHAR2 |
30 |
HR_ACTION_REASON_CODE |
Code for action's reason. |
VARCHAR2 |
2 |
HR_PERSONNEL_ACTION |
Actions taken against an appointment, salary action, leave, retirement, or promotion. |
VARCHAR2 |
30 |
HR_PERSONNEL_ACTION_CODE |
Codes for actions taken against an appointment: Cx (Change), Rx (Review), Ex (Extended Sick Leave), Lx (Leaves). |
VARCHAR2 |
2 |
HR_PERSONNEL_ACTION_TYPE_KEY |
This field is used to join HR_PERSONNEL_ACTION_DETAIL table with HR_PERSONNEL_ACTION_TYPE table. |
VARCHAR2 |
4 |
WAREHOUSE_LOAD_DATE |
The date the record was loaded into the Data Warehouse from the source system. |
DATE |
8 |