File Selection Guide for Medi-Cal Beneficiary Count Tables
This matrix provides a quick guide for determining which file on the MCSS website has the information you need. To go directly to the site for downloading a particular file, click on the file name at the top of each column.
MCSS is looking for comments/suggestions on the new File Selection Guide. If you would like to help out please e-mail your ideas to mcssweb@dhs.ca.gov. Thank you.
|
|
Ages |
Age/
Demographics |
Beneficiary Counts, Historical |
Counts w/ Family Categories
|
Managed Care Plan
|
Profiles by County
|
Share of Cost |
Medi-Medi*
|
Other Children*
|
Zip Codes Tables
|
|
Size, compressed, in megabytes |
<1 |
<1 |
<2 |
<2 |
2 |
<1 |
2 |
2 |
<1 |
2 |
|
Size uncompressed, in megabytes |
2 |
5 |
7 |
10 |
10 |
<1 |
13 |
12 |
3 |
13 |
|
Frequency of updates (Monthly/Quarterly |
Q |
Q |
M |
M |
M |
Q |
M |
M |
M |
Q |
|
For historical files, first month of data |
1/98 |
|
1/02 |
1/04 |
1/04 |
|
1/04 |
1/03 |
1/03 |
|
|
Microsoft Excel Pivot Table format |
X |
X |
X |
X |
X |
|
X |
X |
X |
X |
|
Variables included: |
|
|
|
|
|
|
|
|
|
|
|
County |
X |
X |
X |
X |
X |
X |
X |
X |
X |
X |
|
Aid Code |
|
X |
X |
X |
X |
|
X |
X |
X |
|
|
Aid Category, Primary |
|
X |
X |
X |
|
X |
|
|
|
X |
|
Aid Category, Secondary |
|
X |
X |
X |
|
|
|
|
|
X |
|
Aid Category, Special Family |
|
|
|
X |
|
|
|
|
|
|
|
Age |
X |
X |
|
X |
|
X |
|
X |
X |
X |
|
Ethnicity |
|
X |
|
|
|
X |
|
|
|
X |
|
Gender |
X |
X |
|
|
|
X |
|
|
|
X |
|
Language |
|
X |
|
|
|
X |
|
|
|
X |
|
Managed Care, Yes/No |
X |
X |
|
X |
|
X |
|
|
|
X |
|
Managed Care, by Health Care Plan No. |
|
|
|
|
X |
|
|
X |
X |
X |
|
Managed Care Plan Type |
|
|
|
|
X |
X |
|
|
|
X |
|
Medicare |
|
X |
|
|
|
X |
|
X |
|
X |
|
Share of Cost |
|
|
|
|
|
|
X |
|
|
|
|
Special Aid Code |
|
|
|
|
|
|
|
X |
X |
|
|
Special Aid Code County |
|
|
|
|
|
|
|
X |
X |
|
|
Other Health Coverage |
|
|
|
|
|
|
|
X |
X |
|
For a 56K modem connection, it takes about 5 minutes to download a 1 meg file.
* Special Aid Codes files. The Medi-Medi file includes 80, 8A, 8C, and 8D (Medicare related). The Other Children file includes 7X, 7Y, 8X, and 8Y (Healthy Families & CHDP).
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 page for more information.
Please send comments and suggestions regarding the Medical Care Statistics Section Website to: Medical Care Statistics Section
MCSS Home