How do I create a CHIPER report?

Step by step instructions to Create a CHIPER Report

What are the CHIPER report field definitions?

CHIPER Report Field Definitions

Medi-Cal Eligibility

Instructions for created eligibility flatfiles

Complete instructions for creating a flatfile is found on this website under Create a Flatfile

What if my vendor won't give me the eligibility flatfile returned by DHCS without an additional fee?

The data in the flatfile belongs to your LEA, not the vendor. You should insist on receiving it without additional fees. Try to run it through the CHIPER portal to see if you can get a returned CHIPER Report. If it is not formatted correctly you will get an error message on the Portal site. If this does not work for you, you can approach your vendor to modify the file they return to you as a no-cost value added product that they offer their clients. Otherwise, you can use the instructions posted on this website to create and submit your own file to DHCS.

How do I look up the Medi-Cal status of an individual student?

View here

How can I find out what type of Medi-Cal a student has?

If you obtain an individual Eligibilty report from DHCS it will have Aid Codes. These codes are tied to a description of the benefits available to this student. DHCS posts a Master Chart that describes these services on their website, http://www.medi-cal.ca.gov/signup.asp. Search for "Aid Codes" for the most current codes and their descriptions.


What is HIPAA?

Everything you ever wanted to know about HIPAA is located here.

Not sure which version of Excel you have?

Find out here

I am using Excel for Apple to create my report. I am combining student dates of birth from a Windows based and Macintosh Excel files and the student's dates of birth are changing.

The challenge is that Microsoft and Apple calculate age from date of birth using the number of days since a base year, and they use different base years. Excel for Microsoft uses January 1, 1900 as the base year and Excel for Macintosh uses January 1, 1904 as the base year. As a result, there will be a four year discrepancy between the date of birth in one system compared to the other when switching between operating systems. This becomes very problematic if you combine students from the two different operating systems into one file.

The easiest way to verify whether the date of birth is accurate is to compare the school grade information with the age or date of birth calculation. If you find children in kindergarten who are 9 or 10 years of age, you will need to research a way to correct for the date of birth discrepancy. You may make the correction in your Excel file prior to converting it to a text file. Microsoft Support has an excellent help document to assist you in understanding and fixing this problem if it occurs in your file. Go to Microsoft Support website, http://www.support.microsoft.com and search for "Differences between the 1900 and the 1904 date system in Excel."