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 |