BENEFITS RECIPIENT Table
View exposing benefits recipient reference data including dependent and beneficiary names, relationship, birth date, gender, student and disability indicators, and related audit attributes.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
AGE |
Age as provided by the source. |
NUMBER |
4 |
BENEFITS_RECIPIENT_KEY |
Surrogate key identifying the benefits recipient. |
VARCHAR2 |
14 |
DATE_OF_BIRTH |
Date of birth associated with the person or recipient. |
DATE |
|
DEPENDENT_DOCS_REQUIRED_FLAG |
Dependent docs required flag as provided by the source. |
VARCHAR2 |
1 |
FAMILY_RELATIONSHIP |
Family relationship as provided by the source. |
VARCHAR2 |
40 |
FIRST_NAME |
First name as provided by the source. |
VARCHAR2 |
40 |
FULL_NAME |
Full name as provided by the source. |
VARCHAR2 |
80 |
GENDER |
Gender as provided by the source. |
VARCHAR2 |
20 |
GENDER_CODE |
Code identifying gender. |
VARCHAR2 |
1 |
HEALTH_INSURANCE_CLAIM_NUMBER |
Health insurance claim number as provided by the source. |
VARCHAR2 |
20 |
INITIAL_PCP_ID |
Business identifier for the initial pcp. |
VARCHAR2 |
20 |
INITIAL_PCP_NAME |
Initial pcp name as provided by the source. |
VARCHAR2 |
40 |
IS_DISABLED_DEPENDENT |
Indicator identifying whether disabled dependent (Y/N). |
VARCHAR2 |
1 |
IS_STUDENT |
Indicator identifying whether student (Y/N). |
VARCHAR2 |
1 |
LAST_NAME |
Last name as provided by the source. |
VARCHAR2 |
40 |
LAST_UPDATE_DATE |
Date associated with last update. |
DATE |
|
LAST_UPDATE_USER |
Last update user as provided by the source. |
VARCHAR2 |
12 |
MIDDLE_NAME |
Middle name as provided by the source. |
VARCHAR2 |
40 |
RECORD_COUNTER |
Record counter as provided by the source. |
NUMBER |
|
SOCIAL_SECURITY_NUMBER |
Social Security Number associated with the person or recipient. |
VARCHAR2 |
15 |
SUFFIX |
Suffix as provided by the source. |
VARCHAR2 |
15 |
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |