TEAL CCMR Verifer- Accepted Data File Layout
This file is an CSV format (.CSV)
UPDATED 08/01/22 TEAL CCMR LISTING – Accepted Data File Layout (.CSV)
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: TEA does not publish an annual data file format that contains the list of data fields used and fields can and have changed from year to year. This means your Verifier file may be added, moved or deleted columns and data field values can also change. For questions pertaining to annual field value changes, please contact TEA for clarification.
You may now load your CCMR Student Listing File into OnDataSuite CCMR Verifier location. Please make sure to load the DISTRICT CSV file and not the campus lists. See images below for detail.
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.
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.