BENEFITS COSTSHARE TYPE Table
View exposing benefits cost-share type reference data including subscriber, associated-person, and medical-rate attributes used to classify benefits cost-sharing rules.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
ASSOCIATED_PERSON_TYPE |
Associated person type as provided by the source. |
VARCHAR2 |
50 |
ASSOCIATED_PERSON_TYPE_CODE |
Code identifying associated person type. |
VARCHAR2 |
4 |
BENEFITS_COSTSHARE_TYPE_KEY |
Surrogate key identifying the benefits costshare type. |
VARCHAR2 |
30 |
IS_CURRENT_YEAR_RECORD |
Indicator identifying whether current year record (Y/N). |
VARCHAR2 |
1 |
IS_ELIG_NON_PROFIT |
Indicator identifying whether elig non profit (Y/N). |
VARCHAR2 |
1 |
IS_GRANDFATHERED |
Indicator identifying whether grandfathered (Y/N). |
VARCHAR2 |
1 |
IS_HOME_BILLED |
Indicator identifying whether home billed (Y/N). |
VARCHAR2 |
1 |
IS_LATEST_RECORD |
Indicator identifying whether latest record (Y/N). |
VARCHAR2 |
1 |
IS_NEXT_YEAR_RECORD |
Indicator identifying whether next year record (Y/N). |
VARCHAR2 |
1 |
MEDICAL_RATE_TYPE |
Medical rate type as provided by the source. |
VARCHAR2 |
50 |
MEDICAL_RATE_TYPE_CODE |
Code identifying medical rate type. |
VARCHAR2 |
1 |
SUBSCRIBER_TYPE |
Subscriber type as provided by the source. |
VARCHAR2 |
50 |
SUBSCRIBER_TYPE_CODE |
Code identifying subscriber type. |
VARCHAR2 |
6 |
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |