dax_member_month_attribution

At a glance

Schema	dax_claims_preprocessing
Table	dax_member_month_attribution
Layer	Claims Preprocessing
Object type	table
Columns	17
Grain	person_id, member_id, year_month, payer, plan, data_source
Tags	claims_preprocessing, provider_attribution, dax_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	—	—
data_source	varchar	PK	—	—
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		—	—

Querying

select *
from dax_claims_preprocessing.dax_member_month_attribution
limit 100;