TEAL CCMR Verifer- Accepted Data File Layout
This file is an Excel format (.XLS) or (.XLSX)
The 2023 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
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 districts uploaded verifier file in OnDataSuite. Districts are encouraged to make a copy of this file prior to uploading the LISTING file.
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.
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 2022 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 2020-21
Compare your CCMR EWS to 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 2022 TEAL CCMR Verifier file against the CCMR EWS report you will need to associate the year to the previous year. This years file (2022) is associated to the 2020-2021 year and the current dropdown selector has been set to 2020-2021. 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.
Note: 05/31/22
Do not attempt to load last years 2021 TEAL released CCMR Verifier file into this years 2020-2021. TEA added 5 extra fields into this years file and it will not load.
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
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.