Skip Ribbon Commands
Skip to main content

Medi-Cal Member Months Pivot Tables 

The pivot workbooks linked below present -Cal member months summarized by quarter and placed into pivots tables by fiscal year.

Medi-Cal member months summarized by quarter and placed into pivots tables by fiscal year.

Medi-Cal enrollment counts by any individual month may fluctuate throughout a one-year period.  Updates to the enrollment records for a specific month may be made subsequent to that month, reflecting the addition of beneficiaries with retroactive eligibility, as well as other changes to the enrollment records as information is updated.  These changes, which typically result in increases in a particular month's final Medi-Cal enrollment or shifts between aid groups, can only be captured after an elapsed time period.  A specific month's count is considered nearly complete 6 months after the month's end and finalized 12 months after the month's end.  In order to meet the need for timely but meaningful information, this site includes information at varying levels of completeness; Preliminary, and Final.

The pivot tables report member months by quarter, and are grouped into fiscal year or quarterly workbooks based upon the level of completeness of the time period.  “Final” information is reported at the fiscal year level while “Preliminary” information is reported at the quarter level.

Final

Fiscal year pivot workbooks are created when all of the eligibility months in that fiscal year have been fully updated. Calendar year quarters where each of the eligibility months have been fully updated, but do not yet form a complete fiscal year, are reported as “Final Quarter” pivot workbooks.

Preliminary

Similar to the “Final Quarter” pivot workbooks, the “Preliminary Quarter” pivot workbooks are reported quarterly, but these quarters include one or more months which have not yet been fully updated. The “Preliminary Quarter” workbooks are updated monthly until they include only months which are fully updated and become a “Final Quarter.”

Each of the pivot table workbooks includes three tables, with member months as the measure. Classification or grouping variables differ by table and are noted below.

·         Aid Categories - Statewide: Major, detail, and trait aid categories, Medi-Cal payment model (i.e. fee-for service or managed care), Medicare status, age, gender, and race/ethnicity;

 ·         Aid Categories - County: County, major and trait aid categories, Medi-Cal payment model, and Medicare status;

 ·         Aid Code - County: County and aid code numbers with descriptive labels.

 

   Tips for Manipulating Pivot Tables (PDF) 

Medi-Cal Member Months Pivot Table - Most Recent FY Quarters 

   Medi-Cal Member Months FINAL QUARTER Pivot Table - October to December 2012 (XLS)

 Medi-Cal Member Months by FY Pivot Tables 

   Medi-Cal Member Months Pivot Table - FY 2011 - 2012 (XLS)

   Medi-Cal Member Months Pivot Table - FY 2010 - 2011 (XLS) 

   Medi-Cal Member Months Pivot Table - FY 2009 - 2010 (XLS)

   Medi-Cal Member Months Pivot Table - FY 2008 - 2009 (XLS)

   Medi-Cal Member Months Pivot Table - FY 2007 - 2008 (XLS)

   Medi-Cal Member Months Pivot Table - FY 2006 - 2007 (XLS)

   Medi-Cal Member Months Pivot Table - FY 2005 - 2006 (XLS)

   Medi-Cal Member Months Pivot Table - FY 2004 - 2005 (XLS)

NOTES 

 

  • The counts by aid code and aid code grouping may not be representative of participation in secondary or companion aid codes.  Under Medi-Cal, a beneficiary may be eligible under more than one aid code.  To avoid over reporting the total number of member months, the "primary" or most significant aid code is selected for categorization in these pivot tables.   In most cases, this also appropriately reflects the size of each aid group.  However, in cases where one person is served under a number of programs, the secondary program may be underrepresented in these pivot tables.

 

  • Definitions of Medi-Cal aid codes may be found in the Aid Codes Master Chart in the Medi-Cal Provider's Manual.

 

  • One member month is counted for each eligible person who was enrolled in the Medi-Cal program and who did not have an unmet share of cost during that month (e.g., a Certified Eligible).

 

  • Updates to the enrollment records for a specific month may be made subsequent to that month, reflecting the addition of beneficiaries with retroactive eligibility, as well as other changes to the enrollment records as information is updated.  These changes, which result in increases in a particular month's final Medi-Cal enrollment, can only be captured after an elapsed time period.  A specific month's count is considered nearly complete 6 months after the month's end and finalized 12 months after the month's end.

  

Permissions and Sourcing:

It is recommended that anything taken from this website be attributed to its original source. RASD includes suggested sources with each analytic product presented on this site.

RASD HOME

 

Last modified on: 10/12/2015 9:04 AM