Class ID/Unique Section Code Verification Report

Contents

Introduction

This report is used to verify section and manually entered stored grade records referenced in the Summer PEIMS validation edits for the Master Schedule, Staff, Student Enrollment, and Student Transcript Interchanges. The report produces a CSV file containing the class IDs and other key information.

Selection Criteria

This report has no specified selection criteria.

Report Input

For help with navigation and running the report, see Generate Reports.

Field

Description

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 Multiple Schools – Use the Ctrl or SHIFT key on your keyboard to click each school for which you want to run the extract.
All Schools (default) – The report includes all student records on the PowerSchool server that meet the selection criteria.

School Year

Choose the school year for which to run this report.

Back to top

Report Output

Each of the fields displayed in the output of the report is described below. See Understanding the Report Output Table for a definition of each column in the table.

Item #	Data Element	Description	[Table]FieldName
1	School ID	The school number.	[Schools]School_Number [Schools]Alternate_School_Number
2	School Name	The school name.	[Schools]Name
3	Course Name	The course name.	[Courses]Course_Name
4	Course Number	The course ID number.	[Courses]Course_Number [StoredGrades]Course_Number
5	Alternate Course Number	The alternate course number.	[S_TX_SGR_X]Alt_Course_Number [S_TX_SEC_X]Alt_Course_Number [CoursesCoreFields]Alt_Course_Number
6	Section Number	The section number.	[StoredGrades]SectionID [Sections]ID
7	Expression	The period that the section meets.	[Sections]Expression
8	Term	The ID number for the term in which the section was taught.	[Sections]TermID
9	Class ID (Calculated)	The calculated class ID.	Calculated
10	Class ID (Section or Stored Grades Override)	The override class ID, if populated.	[S_TX_SEC_X]E1056_ClassID_Override [S_TX_SGR_X]Class_ID_Number
11	Homeroom Section	Indicates if this is the homeroom section.	[S_TX_SEC_X]E1440_Homeroom_Section
12	Teacher Name	The name of the section instructor. Note: This field is only reported for scheduled Sections records.	[Sections]Teacher
13	Teacher Unique ID	The teacher's unique state ID number. Note: This field is only reported for scheduled Sections records.	[Users]SIF_StatePrId
14	Teacher Number	The teacher's locally assigned ID number. Note: This field is only reported for scheduled Sections records.	[Users]TeacherNumber
15	Student Name	The student's name. Note: This field is only reported for manually entered stored grades records.	[Students]LastFirst
16	Student Number	The student's locally assigned ID number. Note: This field is only reported for manually entered stored grades records.	[Students]Student_Number
17	Student Unique ID	The student's unique state ID number. Note: This field is only reported for manually entered stored grades records.	[Students]State_StudentNumber

Back to top