Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse 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