SB3 PowerSchool SIS Texas
Breadcrumbs

Duplicate Class ID Report

The Duplicate Class ID Report creates a CSV file of duplicate class ID's to allow districts to verify if adjustments to the Class ID setup are needed. If the report returns no records, no duplicate class IDs exist.

Report Input

To generate the report:

  1. On the Start Page, click State Reports. The Reports page appears.

  2. Click Duplicate Class ID Report. The report page appears.

  3. Enter information in all of the required fields.

  4. Click Submit to generate the report.

Field

Description

School Year

Choose the school year for the student enrollment data to be included in the report.

Run Now

Select this option to run the report immediately.

Schedule

Select this option to run this report on a scheduled basis. Once this option is selected the following choices are:

  • Run OnceStart Date and Start Time to run the report.

  • RepeatSelect Daily, Weekly, Monthly or Yearly for the appropriate re-occurrence for running the report.If Daily is selected, click the Weekdays only box to limit to weekdays.If Weekly is selected, select which weekday to run the report.If Monthly is selected, select the month to run the report.If Yearly is selected, select either the date or the weekday to run the report.

  • Date Range – Select No End Date or a date that the re-occurrence should end.

Report Output [CSV]

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

Item #

Data Element

Description

[Table]FieldName

Length

1

CLASS ID

The class ID number.

[Prefs]tx_classid_part1

[Prefs]tx_classid_part2

[Prefs]tx_classid_part3

[Prefs]tx_classid_part4

[Prefs]tx_classid_part5

14

2

SCHOOL ID

The school ID number.

[Schools]School_Number

9

3

COURSE NAME

The name of the course.

[Courses]Course_Name

40

4

COURSE NUMBER

The course number.

[Courses]Course_Number

10

5

SECTION NUMBER

The section number.

[Sections]Course_Number

11

6

SECTION ID

The section ID number.

[Sections]ID

10

7

COURSE SERVICE ID

The alternate course number.

[Courses]Alt_Course_Number 

8

8

SECTION SERVICE ID

The alternate course number override

[S_TX_SEC_X]Alt_Course_Number

8

9

TEACHER

The teacher of the section.

[Sections]Teacher

10

10

NO OF STUDENTS

The number of students in the section.

[Sections]No_of_Students

10

11

CLASS ID OVERRIDE

The class ID override.

[S_TX_SEC_X]E1056_ClassID_Override

14