input_layer__provider_attribution
Provider attribution supplied by a source system, such as a payer's own panel assignment. The warehouse's own attribution is computed downstream and surfaces on dax_core.member_month.
At a glance
| Schema | dax_input_layer |
| Table | input_layer__provider_attribution |
| Layer | Input Layer |
| Object type | view |
| Columns | 16 |
| Grain | person_id, member_id, year_month, payer, plan, data_source |
| Tags | input_layer |
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 | — | — | |
file_name | varchar | — | — | |
ingest_datetime | timestamp | — | — | |
data_source | varchar | PK | — | — |
Querying
select *
from dax_input_layer.input_layer__provider_attribution
limit 100;