Introduction
The Student Data Request (SDR) Upload File allows users to request historical scoring reports for Texas state assessments for one or more students within the Cambium TIDE (Test Information Distribution Engine) system. By default, the PowerSchool file includes a request for all state assessment results. After the request has been made and processed, historical scoring reports can be downloaded from the user's inbox within the TIDE system.
This report generates a CSV file formatted for upload to the Cambium TIDE system, enabling districts to retrieve student assessment data including STAAR 3–8, EOC, TELPAS, and alternate assessments.
Navigation on the UI
To access the Student Data Request (SDR) Report:
-
Log in to PowerSchool as an administrator
-
Navigate to Start Page > Reports > State Reports
-
Under the Assessment category, locate Student Data Request (SDR) Upload File
-
Click on the report name to open the report parameters page
Report Requirements
-
User must have appropriate administrative access to run state reports
-
The report is available at District Office (School 0) or individual school level
-
Students must be currently enrolled (exit date > current date)
-
Students must have an entry date prior to their exit date
-
Students must be in grade level 0 or higher
-
Schools marked as "Exclude from Reporting" will not appear in the school selection list
Student Selection Criteria
Students are included in the report based on the following criteria:
|
Criteria |
Description |
|---|---|
|
Enrollment Status |
Student must be currently enrolled (exit date greater than current system date) |
|
School Enrollment |
Student must be enrolled in one of the selected school(s) |
|
Grade Level |
Student must be in grade level 0 or higher |
|
Entry/Exit Date |
Student's entry date must be less than their exit date |
|
UID/DOB Requirement |
Students missing Unique ID (TSDS ID) or Date of Birth can be optionally excluded |
|
Entry Date Range |
When "Students by Entry Date Range" is selected, only students with entry dates within the specified range are included |
|
Selected Students |
When "The Selected X Students" is selected, only the pre-selected students are included |
Report Input
Field and Description
|
Field Name |
Description |
Required |
Default Value |
|---|---|---|---|
|
Select Schools |
Allows selection of one or more schools for which to generate report content. To select all schools, hold Shift key while selecting. To select multiple schools, hold COMMAND (Mac) or CONTROL (Windows) key while selecting. |
Yes |
Current School |
|
Students to Include |
Determines which students to include in the report. Options: "The Selected X Students" or "Students by Entry Date Range" |
Yes |
Students by Entry Date Range |
|
Start Date |
The beginning of the entry date range for student selection. Only visible when "Students by Entry Date Range" is selected. |
Yes (conditional) |
None |
|
End Date |
The end of the entry date range for student selection. Only visible when "Students by Entry Date Range" is selected. |
Yes (conditional) |
None |
|
Assessments |
Specifies which assessment type(s) to request in the SDR file. |
Yes |
ALL |
|
Exclude Students with Missing UID or DOB |
Determines whether to exclude students who are missing their Unique ID (TSDS ID) or Date of Birth. |
Yes |
Yes |
Assessment Options
|
Code |
Description |
|---|---|
|
ALL |
All Assessments |
|
EOC |
End of Course |
|
GR |
3–8 (Grades 3-8 STAAR) |
|
TELPAS |
Texas English Language Proficiency Assessment System |
|
EOCALT |
Alternate EOC |
|
ALT |
Alternate 3–8 |
Validations
|
Validation |
Description |
|---|---|
|
School Selection Required |
At least one school must be selected to run the report |
|
Date Range Validation |
When "Students by Entry Date Range" is selected, both Start Date and End Date are required |
|
Assessment Selection Required |
An assessment type must be selected |
|
Exclude Students Selection Required |
A value must be selected for "Exclude Students with Missing UID or DOB" |
|
UID/DOB Check |
When "Exclude Students with Missing UID or DOB" is set to "Yes", students without a valid TSDS ID or with DOB of 01/01/1900 are excluded from the output |
|
Selected Students Check |
The "Selected X Students" option is disabled if no students are currently selected (count = 0) |
Report Output
The report generates a CSV file with the following naming convention:
SDR-[CampusID]_[Timestamp].csv
Where:
-
CampusID: The 3-digit campus identifier (000 for district-level)
-
Timestamp: Current date/time in format yyyyMMddHHmm
Output Fields
|
Item # |
Data Element |
Description |
[Table]FieldName |
Field Type |
Field Length |
|---|---|---|---|---|---|
|
1 |
TSDS ID |
The Texas Student Data System unique identifier for the student |
[Students]State_StudentNumber |
VARCHAR |
4000 |
|
2 |
Enrolled Campus ID |
The 3-digit campus/school ID where the student is enrolled, left-padded with zeros |
Calculated from [Schools]School_Number via TX_STUDENT_SUBMISSION.get_reportable_school function |
VARCHAR |
20 |
|
3 |
Last Name |
The student's legal last name. Uses TX-specific extended field if available, otherwise falls back to core last name |
[S_TX_STU_X]E0705 or [Students]Last_Name |
VARCHAR |
4000 (truncated to 60) |
|
4 |
First Name |
The student's legal first name. Uses TX-specific extended field if available, otherwise falls back to core first name |
[S_TX_STU_X]E0703 or [Students]First_Name |
VARCHAR |
4000 (truncated to 60) |
|
5 |
Birthdate |
The student's date of birth in MMDDYYYY format |
[Students]DOB |
VARCHAR |
4000 |
|
6 |
Assessment |
The assessment type code for the SDR request based on user selection |
User Parameter Selection |
VARCHAR |
2000 |
Assessment Values in Output
|
Parameter Value |
Output Value |
|---|---|
|
ALL |
ALL |
|
GR |
3-8 |
|
EOC |
EOC |
|
ALT |
Alternate 3–8 |
|
EOCALT |
Alternate EOC |
|
TELPAS |
TELPAS |