How do I Verify Student TSDS IDs in CLI Engage?

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.

  1. 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.

  2. 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.

TSDS ID VERIFICATION.mp4

 

Prerequisites

You must be logged in to CLI Engage
You must generate a Student Results Export
You must fill in and process the Student Template

Instructions:

  1. 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.

  1. 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

  1. 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