int_eligibility_casting
:::caution Internal model This is an intermediate/staging model used to build the query surface. It is documented for lineage and debugging. Its shape may change between releases, so avoid building reports directly on it. :::
At a glance
| Schema | dax_intermediate |
| Table | int_eligibility_casting |
| Layer | Normalized Layer |
| Object type | table |
| Columns | 49 |
| Tags | normalized_input, normalized_layer |
Columns
| Column | Type | Key | Constraints | Description |
|---|---|---|---|---|
person_id | — | — | — | |
person_id_key | — | — | — | |
member_id | — | — | — | |
subscriber_id | — | — | — | |
subscriber_relation | — | — | — | |
enrollment_start_date | — | — | — | |
enrollment_end_date | — | — | — | |
payer | — | — | — | |
payer_type | — | — | — | |
plan | — | — | — | |
first_name | — | — | — | |
middle_name | — | — | — | |
last_name | — | — | — | |
name_suffix | — | — | — | |
social_security_number | — | — | — | |
address | — | — | — | |
city | — | — | — | |
state | — | — | — | |
zip_code | — | — | — | |
phone | — | — | — | |
email | — | — | — | |
ethnicity | — | — | — | |
sex | — | — | — | |
race | — | — | — | |
birth_date | — | — | — | |
death_date | — | — | — | |
death_flag | — | — | — | |
original_reason_entitlement_code | — | — | — | |
dual_status_code | — | — | — | |
medicare_status_code | — | — | — | |
enrollment_status | — | — | — | |
hospice_flag | — | — | — | |
institutional_snp_flag | — | — | — | |
medicaid_indicator | integer | — | — | |
long_term_institutional_flag | — | — | — | |
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 | — | — | — | |
file_name | — | — | — | |
file_date | — | — | — | |
ingest_datetime | — | — | — | |
dax_last_run | — | — | — | |
data_source | — | — | — |
Querying
select *
from dax_intermediate.int_eligibility_casting
limit 100;