Financial PMPM
The Financial PMPM data mart computes member months and stratifies population paid and allowed amounts by member months and service categories across various payers and plans.
pmpm_prep
A table that computes all the paid and allowed statistics for every patient_id and year_month combination.
Primary Keys:
- patient_id
- year_month
- payer
- plan
- data_source
| Column | Data Type | Description | Terminology |
|---|
pmpm_payer_plan
A table that computes per member per month statistics for every service category by aggregating across patients from pmpm_prep. This table is at the payer, plan grain.
Primary Keys:
- year_month
- payer
- plan
- data_source
| Column | Data Type | Description | Terminology |
|---|
pmpm_payer
A table that computes per member per month statistics for every service category by aggregating across patients from pmpm_prep. This table is at the payer grain.
Primary Keys:
- year_month
- payer
- data_source
| Column | Data Type | Description | Terminology |
|---|