Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse PENSION ACTION TYPE Table


View exposing pension action type reference values used to classify pension processing events.


Field Name

Description

Data Type

Length

PENSION_ACTION

Pension action associated with the record.

VARCHAR2

30

PENSION_ACTION_CODE

Code identifying pension action.

VARCHAR2

2

PENSION_ACTION_REASON

Pension action reason associated with the record.

VARCHAR2

30

PENSION_ACTION_REASON_CODE

Code identifying pension action reason.

VARCHAR2

2

PENSION_ACTION_TYPE_KEY

Surrogate key identifying the pension action type.

VARCHAR2

4

WAREHOUSE_LOAD_DATE

Date the record was loaded into the data warehouse.

DATE