normalized__eligibility

At a glance

Schema	dax_normalized_layer
Table	normalized__eligibility
Layer	Normalized Layer
Object type	table
Columns	52
Grain	eligibility_id
Tags	normalized_input, normalized_layer

Columns

Column	Type	Key	Terminology	Constraints	Description
eligibility_id	—	PK	—	—	—
person_id	—		—	—	—
member_id	—		—	—	—
subscriber_id	—		—	—	—
subscriber_relation	—		—	—	—
enrollment_start_date	—		—	—	—
enrollment_end_date	—		—	—	—
payer	—		—	—	—
payer_type	—		Payer type	—	—
plan	—		—	—	—
first_name	—		—	—	—
middle_name	—		—	—	—
last_name	—		—	—	—
name_suffix	—		—	—	—
social_security_number	—		—	—	—
address	—		—	—	—
city	—		—	—	—
state	—		—	—	—
zip_code	—		—	—	—
phone	—		—	—	—
email	—		—	—	—
ethnicity	—		—	—	—
sex	—		Sex	—	—
race	—		Race	—	—
birth_date	—		—	—	—
death_date	—		—	—	—
death_flag	integer		—	—	—
original_reason_entitlement_code	—		Medicare orec	—	—
dual_status_code	—		Medicare dual eligibility	—	—
medicare_status_code	—		Medicare status	—	—
enrollment_status	—		—	—	—
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	—		—	—	—
group_name	—		—	—	—
fips_state_code	—		—	—	—
normalized_state_name	—		—	—	—
fips_state_abbreviation	—		—	—	—
file_date	—		—	—	—
file_name	—		—	—	—
ingest_datetime	—		—	—	—
dax_last_run	—		—	—	—
data_source	—		—	—	—

Querying

select *
from dax_normalized_layer.normalized__eligibility
limit 100;