Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse PERSONNEL ACTION TYPE Table


View exposing personnel action type reference values used to classify workforce events and appointment transactions.


Field Name

Description

Data Type

Length

PERSONNEL_ACTION_REASON_CODE

Code identifying personnel action reason.

VARCHAR2

2

PERSONNEL_ACTION_TYPE

Personnel action type associated with the record.

VARCHAR2

30

PERSONNEL_ACTION_TYPE_CODE

Code identifying personnel action type.

VARCHAR2

2

PERSONNEL_ACTION_TYPE_KEY

Surrogate key identifying the personnel action type.

VARCHAR2

4

WAREHOUSE_LOAD_DATE

Date the record was loaded into the data warehouse.

DATE