Utilization Data Files 

*The Month of Payment Reports are no longer being produced please see the Fee-For-Service Expenditure Pivot Table below.

Fee-For-Service Expenditures Summary Tables (updated annually)
(includes utilization data by Claim Type, Aid Code, Vendor Code,
Provider Type, Medicare Crossover indicator, CCS indicator, 
Managed Care indicator, and County of Beneficiary)

Some of these files were created in Microsoft Excel and utilize a Pivot Table.
Note that a Pivot Table was added to permit the user to summarize and analyze the data interactively.
For more information about the elements of a Pivot Table please go to the Microsoft website at: http://support.microsoft.com/
-or-
You can visit the MCSS General Information page and view MCSS's
Tips for Manipulating Microsoft's Excel Pivot Tables

*Please note that recent changes to the Health Insurance Portability and Accountability Act (HIPAA) have added new restrictions as to the type of entities that can receive personal medical data and the purposes for which the data can be used. Please refer to our General Information section for more information.

Note:  as our Department normally uses the term, "Medi-Cal eligible" is someone who is on Medi-Cal. If there is a share of cost (SOC) that must be paid before Medi-Cal picks up the remaining costs of care, such a person could be certified or uncertified, that is, he/she met their SOC for that month or they haven't, respectively. If "certified" and uncertified are not used when describing "eligible," "certified is normally implied. The term "beneficiary" usually means a Medi-Cal eligible who, if normally construed to mean a Medi-Cal eligible enrolled in a Medi-Cal managed care plan.

The terms "eligible," "beneficiary," and "enrollee" are used interchangeably within Medi-Cal.  Each refers to a person who meets all requirements for receiving a Medi-Cal medical service or good (e.g., drugs, DME items) and is enrolled in the Medi-Cal program by the Department.