input_layer__eligibility
Enrollment spans as received from the source, before date normalization and de-duplication. Overlapping and duplicated spans are common here and are resolved in the normalized layer.
At a glance
| Schema | dax_input_layer |
| Table | input_layer__eligibility |
| Layer | Input Layer |
| Object type | view |
| Columns | 47 |
| Grain | person_id, member_id, enrollment_start_date, payer, plan, data_source |
| Tags | input_layer |
Columns
| Column | Type | Key | Constraints | Description |
|---|---|---|---|---|
person_id | varchar | PK | — | — |
member_id | varchar | PK | — | — |
subscriber_id | varchar | — | — | |
subscriber_relation | varchar | — | — | |
enrollment_start_date | date | PK | — | — |
enrollment_end_date | date | — | — | |
payer | varchar | PK | — | — |
payer_type | varchar | — | — | |
plan | varchar | PK | — | — |
first_name | varchar | — | — | |
middle_name | varchar | — | — | |
last_name | varchar | — | — | |
name_suffix | varchar | — | — | |
social_security_number | varchar | — | — | |
address | varchar | — | — | |
city | varchar | — | — | |
state | varchar | — | — | |
zip_code | varchar | — | — | |
phone | varchar | — | — | |
email | varchar | — | — | |
ethnicity | varchar | — | — | |
sex | varchar | — | — | |
race | varchar | — | — | |
birth_date | date | — | — | |
death_date | date | — | — | |
death_flag | integer | — | — | |
original_reason_entitlement_code | varchar | — | — | |
dual_status_code | varchar | — | — | |
medicare_status_code | varchar | — | — | |
enrollment_status | varchar | — | — | |
hospice_flag | integer | — | — | |
institutional_snp_flag | integer | — | — | |
medicaid_indicator | integer | — | — | |
long_term_institutional_flag | integer | — | — | |
part_d_raf_type | varchar | — | — | |
low_income_subsidy_indicator | integer | — | — | |
metal_level | varchar | — | — | |
csr_indicator | integer | — | — | |
enrollment_duration_months | integer | — | — | |
esrd_status | integer | — | — | |
transplant_duration_months | integer | — | — | |
group_id | varchar | — | — | |
group_name | varchar | — | — | |
file_name | varchar | — | — | |
file_date | date | — | — | |
ingest_datetime | timestamp | — | — | |
data_source | varchar | PK | — | — |
Querying
select *
from dax_input_layer.input_layer__eligibility
limit 100;