Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse PENSION ACTION TYPE Table


Dimension Table for Pension Action Detail, consists information about Pension Action Types and Action Reasons (Types:Initial Pension Set-up, Pension Termination, etc, Reason: Deceased, Suspension,etc)


Field Name

Description

Data Type

Length

PENSION_ACTION

XXX

VARCHAR2

30

PENSION_ACTION_CODE

XXX

VARCHAR2

2

PENSION_ACTION_REASON

XXX

VARCHAR2

30

PENSION_ACTION_REASON_CODE

XXX

VARCHAR2

2

PENSION_ACTION_TYPE_KEY

XXX

VARCHAR2

8

WAREHOUSE_LOAD_DATE

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

DATE

8