Service ID Verification Report

On this page:

Introduction

Service ID Verification Report helps you to audit and flag PowerSchool records with obsolete or invalid Service IDs per the TEA C022 Service ID Code Table.

School Year Selection: The current year and prior year are available. Choose the current school year to verify records for PEIMS and TSDS reporting this year.
The report is output to a CSV file, which can be opened and filtered in Excel.
The report compares the values in the PowerSchool Alternate Course Number fields to the valid entries in the TEA C022 Service ID table for the selected year.

Selection Criteria

For Local Service ID's beginning in "8", only the first five characters of the Service ID are considered; local courses can have any value for the last three characters.
Courses are excluded from consideration when the Exclude from PEIMS/TSDS flag is "Yes" in Courses.
Sections are excluded from consideration when Exclude from PEIMS/TSDS flag is "Yes" in Sections.
Stored Grades records are excluded when the Exclude from PEIMS/TSDS flag is "Yes" in Historical Grades.

Error Reporting

Four types of validations are included in the Error Type column of the file:

- Course Assigned - No Sections: These are records with invalid or obsolete Service IDs in Courses where the course is assigned to one or more schools in the selected year, but no scheduled sections or stored grades for these courses exist at this point. Update the Alternate Course Number in Courses to correct these records.
- Course Assigned - Sections Exist: These are records with invalid or obsolete Service IDs in Courses where Sections have been scheduled at one or more schools. Update the Alternate Course Number in Courses to correct these records.
- Invalid Override in Section: These are records where a user has entered an invalid Service ID in the Alternate Course Number override in the section record. Update the Alternate Course Number in Sections to correct these records.
- Invalid Override in Stored Grades: These are records where a user entered an invalid Service ID in the Alternate Course Number override in Stored Grades. Update the Alternate Course Number in Stored Grades to correct these records.

Report Input

Field

Additional Information

Select Schools

Choose which school(s) to include in the report by selecting one of the following options:

At the school level:

The currently selected school is the default.

At the district level:

Select a Single School – Click the school for which you want to run the extract.
Select Multiple Schools – Use the Ctrl or SHIFT key on your keyboard to click each school for which you want to run the extract.

School Year*

Select the school year.

The current year and prior year are available. Choose the current school year to verify records for PEIMS and TSDS reporting this year.

Report Output

Data Element	Description
Error Type	The category of error as described above	Error type
Alt Course Number	The Alternate Course Number value in PowerSchool	[Courses]Alt_Course_Number
Former TEA Abbrev	If a Service ID was valid last year, this is the prior TEA Abbreviated course description	[S_TX_SERVICE_ID_S]COURSE_ABBREVIATION
Former TEA Desc	If a Service ID was valid last year, this is the prior TEA course description	[S_TX_SERVICE_ID_S]SHORT_DESC
Local Crs Num	Local course number in Courses	[Courses]Course_Number
Local Crs Name	Local course name in Courses	[Courses]Course_Name
Course Units	The number of high school credits per the C022 table.	[S_TX_SERVICE_ID_S]COURSE_UNITS
CTE	Indicator of "H" for high school credit CTE courses, or "M" for middle school CTE courses	[S_TX_SERVICE_ID_S]CTE_COURSE
School	The school number attached to the section or stored grades record	[Schools]ID
School Name	The school name attached to the section or stored grades record	[Schools]Name
Section	The section number	[Sections]Section_Number
Term	The term for the section	[Sections]TermID
Local ID	The local Student Number; reported only for stored grades	[Students]Student_Number
Name	The student's name; reported only for stored grades	[Students]Name
Year	The historical year for the stored grades record	[S_TX_SERVICE_ID_S]YEARID
Store Code	The store code for the stored grades record