Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse PERSONNEL ACTION TYPE Table


Types of Personnel Actions


Field Name

Description

Data Type

Length

PERSONNEL_ACTION_REASON_CODE

XXX

VARCHAR2

2

PERSONNEL_ACTION_TYPE

XXX

VARCHAR2

30

PERSONNEL_ACTION_TYPE_CODE

XXX

VARCHAR2

2

PERSONNEL_ACTION_TYPE_KEY

Key field used to join to the PERSONNEL_ACTION_TYPE table. This field should only be used for joining data, NOT for reporting.

VARCHAR2

8

WAREHOUSE_LOAD_DATE

The date the record was loaded into the Data Warehouse from the source system.

DATE

8