normalized__provider_attribution
At a glance
| Schema | dax_intermediate |
| Table | normalized__provider_attribution |
| Layer | Normalized Layer |
| Object type | table |
| Columns | 17 |
| Grain | person_id, member_id, year_month, payer, plan, data_source |
| Tags | normalized_input, normalized_layer |
Columns
| Column | Type | Key | Constraints | Description |
|---|---|---|---|---|
person_id | — | — | — | |
member_id | — | — | — | |
year_month | — | — | — | |
payer | — | — | — | |
plan | — | — | — | |
payer_attributed_provider | — | — | — | |
payer_attributed_provider_practice | — | — | — | |
payer_attributed_provider_organization | — | — | — | |
payer_attributed_provider_lob | — | — | — | |
custom_attributed_provider | — | — | — | |
custom_attributed_provider_practice | — | — | — | |
custom_attributed_provider_organization | — | — | — | |
custom_attributed_provider_lob | — | — | — | |
file_name | — | — | — | |
ingest_datetime | — | — | — | |
dax_last_run | — | — | — | |
data_source | — | — | — |
Querying
select *
from dax_intermediate.normalized__provider_attribution
limit 100;