member_month

One row per person per calendar month of coverage: the standard denominator of the warehouse. Enrollment spans are exploded into months here so that per-member-per-month rates, and the cost and utilization marts built on top, all divide by the same consistent count.

At a glance

Schema	dax_core
Table	member_month
Layer	Core Data Model
Object type	table
Columns	19
Grain	member_month_id
Tags	core

Columns

Column	Type	Key	Constraints	Description
member_month_id	varchar	PK	not null	Dax identifier for the person-month.
person_id	varchar		not null	The covered individual.
member_id	varchar		—	—
year_month	varchar		—	Calendar month of coverage.
payer	varchar		—	Payer providing coverage in the month.
plan	varchar		—	Benefit plan providing coverage in the month.
dax_last_run	varchar		—	Timestamp of the warehouse build that produced this row.
payer_attributed_provider	—		—	Provider the payer attributed the member to.
payer_attributed_provider_practice	—		—	—
payer_attributed_provider_organization	—		—	—
payer_attributed_provider_lob	—		—	—
custom_attributed_provider	—		—	Provider assigned by your own attribution logic.
custom_attributed_provider_practice	—		—	—
custom_attributed_provider_organization	—		—	—
custom_attributed_provider_lob	—		—	—
dax_attributed_provider	varchar		—	Provider selected by the warehouse attribution model for this member month. Prefer this when you want one consistent attribution.
dax_attributed_provider_bucket	varchar		—	—
dax_attributed_provider_specialty	varchar		—	Specialty of the attributed provider.
data_source	varchar		not null	Label for the contributing system.

Querying

select *
from dax_core.member_month
limit 100;