PENSION BENEFITS RECIPIENT Table
View exposing pension benefit recipient records including identifiers, recipient types, and related attributes.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
AGE |
Age associated with the record. |
NUMBER |
10 |
DATE_OF_BIRTH |
Date of birth associated with the person. |
DATE |
|
DEPENDENT_DOCS_REQUIRED_FLAG |
Indicator identifying whether dependent docs required (Y/N). |
VARCHAR2 |
1 |
FAMILY_RELATIONSHIP |
Family relationship associated with the record. |
VARCHAR2 |
40 |
FIRST_NAME |
First name associated with the person. |
VARCHAR2 |
40 |
FULL_NAME |
Full name associated with the person. |
VARCHAR2 |
100 |
GENDER |
Gender associated with the record. |
VARCHAR2 |
20 |
GENDER_CODE |
Code identifying gender. |
VARCHAR2 |
1 |
IS_DISABLED_DEPENDENT |
Indicator identifying whether disabled dependent (Y/N). |
VARCHAR2 |
1 |
LAST_NAME |
Last name associated with the person. |
VARCHAR2 |
40 |
LAST_UPDATE_DATE |
Date associated with last update. |
DATE |
|
LAST_UPDATE_USER |
Last update user associated with the record. |
VARCHAR2 |
12 |
MIDDLE_NAME |
Middle name associated with the person. |
VARCHAR2 |
10 |
PENSION_BENEFITS_RECIPIENT_KEY |
Surrogate key identifying the pension benefits recipient. |
VARCHAR2 |
14 |
RECORD_COUNTER |
Record counter associated with the record. |
NUMBER |
|
SOCIAL_SECURITY_NUMBER |
Social security number associated with the record. |
VARCHAR2 |
15 |
SUFFIX |
Suffix associated with the record. |
VARCHAR2 |
15 |
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |