Course Sequence Code Verification Report

On this page:

Introduction

The Course Sequence Code Verification Report assists districts in verifying that correct Course Sequence codes are assigned in Courses and Sections. The report first examines the course type as defined in the TEA C022 Service ID table to determine if the course is eligible for high school credit or is an elementary/middle school non-credit course. The course type and scheduling term assigned to each section at the schools are compared to the assigned Course Sequence code in order to identify invalid combinations of Course Sequence and scheduling term, which may cause the Course Sequence code to be output incorrectly in the TSDS and PEIMS Interchanges.

Selection Criteria

Record Selection is based on the following conditions in Courses/Sections:

Exclude from PEIMS/TSDS is not set to "Yes."
Service ID (Alternate Course Number) does not begin with SA, SE, SR, SS, 8, or 9 or is not NULL.
The explanation Code is not set to "L" (local course).

Notes:

Non-high school credit classes offered by elementary and middle schools and taught in a term other than the Year Term no longer require the entry of a Course Sequence Code in courses or sections. A Course Sequence Code of A will now be defaulted based on the TEA C022 Service ID table. Districts can leave all non-high school credit courses set to "Use Default Course Setup."
Semester-length high school credit classes (Course Sequence 0, 1, or 2) with sections scheduled in the Year Term are now supported as valid scenarios for Texas state reporting. In the self-paced class scenario, students may begin a section at any time and exit the section at any time. A "Verify" warning message is displayed for semester-length high school credit classes scheduled in the year term.

Report Input

For help with report navigation and generation, see Generate Reports.

Each of the available run options and data fields for the report are described below.

Field

Description

Select Schools

At the District Level:

Select All Schools to run the extract for all schools that are not excluded from state reporting.
Selecting Multiple Schools allows you to use the Ctrl or SHIFT key on your keyboard to click each school you want to run the extract.

At the School Level:

Select All Schools to run the extract for all schools not excluded from state reporting.
Select Current School Only to run the extract just for the current school.

School Year

Select the school year for which you want to filter Courses and Sections.

Output Type

Select the output type.

CSV
PDF

Report Output

Data Element	Description	[Table]FieldName
Error Message	Course Sequence Code error based on scheduled section.	N/A
School ID	The school ID.	[Schools]Alternate_School_Number [Schools]School_Number
School Name	The name of the school.	[Schools]Name
Alternate Course Number	The Alternate Course Number (Service ID).	[S_TX_SEC_X]Alt_Course_Number [CoursesCoreFields]Alt_Course_Number
Course Number	The Course Number.	[Courses]Course_Number
Course Name	The course name.	[Courses]Course_Name
Section Number	The Section Number.	[Sections]Section_Number
Term	The selected term.	[Terms]Abbreviations
Course Seq (Course)	The course sequence.	[S_TX_CRS_X]Course_Sequence
Course Seq (Section override)	The course sequence override.	[S_TX_SEC_X]E0948_Course_Seq_Override