TEAL CCMR Verifier – Accepted Data File Layout (Released in late May or early June)
The Verifier File will be an Excel document with multiple tabs. The first tab should contain a glossary and then each separate tab will contain each individual reported campus
The LISTING file is a Comma Separated Value format (.CSV) (Released August) This file is the FINAL file TEA will provide to the districts for the year.
Important note about uploading newly released verifier files into your file center
Each year, when TEA releases the verifier file, they do not provide vendors with an annual data file format in advance. Because we do not have prior knowledge of the newly released file structure, it may take a few days before you can upload this file into your OnDataSuite file center. Once the file structure has been confirmed and we are ready to take in your file, we will update the year dropdown selector and you will be able to upload this file.
NOTE: The TEA verifier file can now be loaded under the TEAL CCMR Verifier location. Please load your file using the 2022-2023 drop-down selector. After loading your file you may review its contents using the CCMR Verifier report located under the CCMR – College, Career & Military Ready folder
TEA provides a final VERIFIER file as the LISTING file a few weeks after the verifier file has been removed from your TEAL site. If you load this listing file, it will overwrite your district’s uploaded verifier file in OnDataSuite. Districts are encouraged to make a copy of this file prior to uploading the LISTING file.
Districts may now load their CCMR LISTING File into the CCMR VERIFIER file center location using the steps outlined below. Please make sure you are loading the DISTRICT.CSV
STEP 1. Go to your TEAL Account and select 2023 Final College, Career, and Military Readiness CCMR Student LISTING
STEP 2. Select the DISTRICT CSV Download option. DO NOT SELECT THE CAMPUS EXCEL
STEP 3. Load the Listing file into the Verifier file center location under the PRIOR year. In this case 2022-23 – It is loaded this way because the file represents your 2022 year grads but the file was provided to you in 2023. This may change on the next cycle due to client feedback.
Compare your CCMR EWS to the Verifier/Listing File once uploaded
CCMR EWS allows you to compare your TEA-released CCMR Verifier Files for past year graduates to your OnDataSuite CCMR EWS report. These files can be uploaded into OnDataSuite from the File Center TEAL category in OnDataSuite.
These files are used to compare results from your CCMR EWS report located in the accountability section of OnDataSuite.
CCMR Verifier (Past year Graduates)
To compare your 2023 TEAL CCMR Verifier file against the CCMR EWS report you will need to associate the year to the previous year. This years file (2023) is associated to the 2021-2022 year and the current dropdown selector has been set to 2021-2022. This is because the file you received in 2023 is a list of the 2022 graduates.
Important Note: This is a wipe replace file. If you load this file and then attempt to load a secondary file it will overwrite the last file loaded. Please make sure you have a copy of the current file in place prior to uploading a new file.
Once uploaded this file will allow the report to align your last year’s CCMR EWS students to the CCMR Verifier file.
Once you have uploaded your verifier file for the current year, you will be able to run your CCMR EWS report for the prior year and compare your Verifier file data
How to verify that your file loaded
To verify that your file has loaded there is a report located under the Accountability section, nested under the CCMR Folder
Tips to making sure your file loaded
1. Make sure the date available in the year selector represents the year of your file upload graduates. So in example: If you load the 2023 Verifier file and use this report, you would use the 2021-2022 dropdown because the 2023 file represents the 2022 graduates.
2. Look at the bottom of the list for the total rows of students represented in the file. The total should match the exact number of rows represented in your uploaded excel document.
How to use the verifier file to compare the TEA Verifier to your OnDataSuite CCMR EWS report
To compare your Verifier file to your CCMR EWS report go to the CCMR Early Warning System report under your Accountability Tab and click on the Show/Hide Filters button at the top of the screen.
You will want to filter to the past year, filter for only grade 12 and select the ‘compare with TEA verifier File’ option
For example, to compare this years 2022 TEA Verifier file to your last year graduated seniors, you would select 2020-2021 from the CCMR EWS filter option.