Get Lea/lec Tape Match Instructions - Dhcs Ca

This guide offers a step-by-step approach to completing the LEA/LEC TAPE MATCH INSTRUCTIONS form. It is designed to support users of all experience levels in ensuring they provide accurate and complete information.

Follow the steps to successfully complete your form.

1. Press the ‘Get Form’ button to obtain the form and access it in the preferred editor.
2. Begin by downloading the necessary PGP software and create a secure password. Document this password for future reference.
3. Request a provider ID number from DHCS by completing the application process.
4. Utilize Microsoft Office Access to create a new database. Within this database, establish a new table named 'DHCS tapematch'. Ensure this table contains the required fields: SSN, last name, first name, MI, DOB, sex, provider ID, school name, and user data.
5. Obtain a student population data file from the district system, ensuring that the Medi-Cal percentage is recorded appropriately.
6. Open the data file in Microsoft Excel, making sure to execute the relevant text import wizard procedures if applicable.
7. Label the columns in the Excel file correctly and make any necessary adjustments or additions as specified.
8. Save and close the modified Excel file once it contains all required information.
9. Return to the Access database and import the Excel file you have prepared.
10. Ensure that the birthdates and Social Security numbers are formatted correctly, making any necessary updates via an update query in Access.
11. Finalize data entry by appending the relevant records to the DHCS Tapematch file in the required format.
12. Export the DHCS Tapematch table as a text file, ensuring that it remains in the correct format.
13. Encrypt the exported file and send it to DHCS via the specified email address.
14. After receiving the file back from DHCS, decrypt it and verify its contents.
15. Adjust the imported data as necessary to adhere to the specified format before saving.
16. Import the finalized Excel data back into Access to conduct the necessary Tapematch calculations.
17. Execute the required calculations, ensuring that you document the total eligible students accurately based on your original data.
18. At the end of this process, save your changes and ensure all data is properly documented.

Begin completing the necessary documents online to maintain compliance and accuracy.