We have MMCOR 2019 Year End and 2020 Q2 DataSets processed and ready to go. The following 2 Tables were created using these DataSets. Email us at nyshcdata@gmail.com if you have questions or are interested in purchasing.


Table below uses our MMCOR DataSet(s) (2016-2020Q2 appended) to highlight some dramatic changes in Statewide PMPM Spend by Service (% Change measure added at the user level). Our DataSets cover ALL Plans and ALL Regions for the specified period(s) to provide more detail and granularity.

*Data taken from Appended MMCOR DataSet, Measures Added. TANF/SN Adults > Statewide > All Plans

% Change PMPM Spend YOY by Service (PMPY)

Table below is a recreation of MMCOR Table 4C – Net Worth Reconciliation for 2019 Annual aggregating for ALL Pans. Owners of the DataSet could filter further at the Plan Level.
*Region level data is not available for Revenue & Expense Category for Tables 4A, 4B and 4C)

MMCOR Table 4C Net Worth Reconciliation (All Plans)


__________________________________________________



Below, we have 4 tables that display Revenue & Expense Data by Medicaid Premium Group from Tables 7-1 through 7-4 of the MMCOR Report. All Plans and Regions from 2014 through 2016 are available. Feel free to export any table you create if you want to see how you can use the data in your own analysis (you must “Show All Entries” before you export).

At the bottom of the page are tables and charts highlighting the trend in Inpatient Medical and Total Allowable Admin Expense across 3 Metrics (Enrollment, Cost and Utilization) from 2015 through 2017 Q3. The Data is for an actual Region with the Plan names changed.

 

MMCOR Table 7-1 TANF SN/Kids

Instructions – You must pick a Period(s) and/or a Region first in order for the Plan and Line Item filters to populate correctly. You can see how many entries your filter is producing (“Showing x of x entries…”) at the bottom left below the table and choose how many to display (“Show x entries”) at the top right above the table.

 

 

MMCOR Table 7-2 TANF SN/Adults

Instructions – You must pick a Period(s) and/or a Region first in order for the Plan and Line Item filters to populate correctly. You can see how many entries your filter is producing (“Showing x of x entries…”) at the bottom left below the table and choose how many to display (“Show x entries”) at the top right above the table.

 

 

MMCOR Table 7-3 SSI

Instructions – You must pick a Period(s) and/or a Region first in order for the Plan and Line Item filters to populate correctly. You can see how many entries your filter is producing (“Showing x of x entries…”) at the bottom left below the table and choose how many to display (“Show x entries”) at the top right above the table.

 

 

MMCOR Table 7-4 Nursing Home

Instructions – You must pick a Period(s) and/or a Region first in order for the Plan and Line Item filters to populate correctly. You can see how many entries your filter is producing (“Showing x of x entries…”) at the bottom left below the table and choose how many to display (“Show x entries”) at the top right above the table.

 

Inpatient Medical

Instructions – Select 1 “Medicaid Premium Group” and 1 “Metric” to update the chart

(Click on a Plan(s) to remove from the chart and/or left-click and drag your mouse to narrow the upper and lower limit)

Total Allowable Administrative Expense

Instructions – Select 1 “Medicaid Premium Group” and 1 “Metric” to update the chart

(Click on a Plan(s) to remove from the chart and/or left-click and drag your mouse to narrow the upper and lower limit)