SB3 PowerSchool SIS Texas
Breadcrumbs

Class ID/Unique Section Code Verification Report

Contents

/*<![CDATA[*/ div.rbtoc1773689859336 {padding: 0px;} div.rbtoc1773689859336 ul {list-style: disc;margin-left: 0px;} div.rbtoc1773689859336 li {margin-left: 0px;padding-left: 0px;} /*]]>*/ Introduction Selection Criteria Report Input Report Output

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