member_month_attribution
At a glance
| Schema | dax_claims_preprocessing |
| Table | member_month_attribution |
| Layer | Claims Preprocessing |
| Object type | table |
| Columns | 25 |
| Grain | person_id, member_id, year_month, payer, plan, data_source |
| Tags | claims_preprocessing, provider_attribution |
Columns
| Column | Type | Key | Constraints | Description |
|---|---|---|---|---|
person_id | varchar | PK | — | — |
member_id | varchar | PK | — | — |
year_month | varchar | PK | — | — |
payer | varchar | PK | — | — |
plan | varchar | PK | — | — |
payer_attributed_provider | varchar | — | — | |
payer_attributed_provider_practice | varchar | — | — | |
payer_attributed_provider_organization | varchar | — | — | |
payer_attributed_provider_lob | varchar | — | — | |
custom_attributed_provider | varchar | — | — | |
custom_attributed_provider_practice | varchar | — | — | |
custom_attributed_provider_organization | varchar | — | — | |
custom_attributed_provider_lob | varchar | — | — | |
dax_attributed_provider | varchar | — | — | |
dax_attributed_provider_bucket | varchar | — | — | |
dax_attributed_provider_specialty | varchar | — | — | |
dax_attribution_assigned_step | integer | — | — | |
dax_attribution_step_description | varchar | — | — | |
dax_attribution_allowed_amount | number | — | — | |
dax_attribution_visits | integer | — | — | |
dax_attribution_lookback_start_date | date | — | — | |
dax_attribution_lookback_end_date | date | — | — | |
dax_attribution_key | varchar | — | — | |
dax_last_run | timestamp | — | — | |
data_source | varchar | PK | — | — |
Querying
select *
from dax_claims_preprocessing.member_month_attribution
limit 100;