How do I Verify Student TSDS IDs in CLI Engage?
CLI Engage’s Ed-Fi data includes students who meet both requirements:
They have assessment results for the selected measures.
They have a valid 10-digit TSDS ID.
Use the steps below to confirm each student has a valid TSDS ID. Update any missing or incorrect IDs before sending Ed-Fi data.
Run a Student Results Export. Run the report for CIRCLE Progress Monitoring PreK or the Texas Kindergarten Entry Assessment. Select at least one measure. The report shows student details, including the Local ID and TSDS ID.
Update missing or invalid TSDS IDs. Use the Student Bulk Upload Process to make updates. The Student template uses district, school, and student information from the Student Results Export report.
Prerequisites
Instructions:
Review the Student Results Export
Use the Student Results Export guide for step-by-step instructions:
How do I Generate a Student Results Export Report?
The report is sent to your email as a secure link to a zip file. After you download the file, open the file named Report. Sort the file by Column AA, TSDS_Student_ID. Review the student TSDS IDs. A valid student TSDS ID has 10 numbers. Update records in CLI Engage when the TSDS ID has any of these issues:
11 or more numbers
9 or fewer numbers
Letters and numbers together
A blank value
Use Column Z, Local Student ID, and the student name columns to check whether each student TSDS ID is correct.
Delete rows that already have accurate student TSDS IDs. This process is only for fixing missing or incorrect TSDS IDs.
Use Column Z, Local Student ID, and the student name columns to find the correct student TSDS ID in your local database.
Update the Student Bulk Upload (BUP) template
After you identify the student TSDS IDs that need updates, copy the needed columns from the Report file into the Student template.
The Student template is in Central Roster Management. Use the Student Bulk Upload Process guide for TSDS ID updates:
https://cliengage.atlassian.net/servicedesk/customer/portal/100/article/478445599?source=search
Do not copy the column names because some names are different in the Student template. Copy only these columns:
Columns C and D: District Name and Engage ID
Columns F and G: School Name and Engage ID
Columns T, U, and V: Student Names
Column Y: Student Engage ID
Column AA: Updated Student TSDS ID values
Save the file as TSDS_Update. Process the file in CLI Engage to update any missing or invalid student TSDS IDs. Go to Central Roster Management and then select the Student option.
If you need further assistance, please submit a Help Ticket:
https://cliengage.atlassian.net/servicedesk/customer/portal/100/group/236/create/970 or https://cliengage.atlassian.net/servicedesk/customer/portal/100/group/236/create/1003