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_claims_preprocessing
Table	member_month
Layer	Claims Preprocessing
Object type	table
Columns	8
Grain	member_month_id
Tags	claims_preprocessing, member_month

Columns

Column	Type	Key	Constraints	Description
member_month_id	varchar	PK	not null, unique	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	timestamp		—	Timestamp of the warehouse build that produced this row.
data_source	varchar		not null	Label for the contributing system.

Querying

select *
from dax_claims_preprocessing.member_month
limit 100;