Courses and Sections Verification Report

On this page:

Introduction

This report serves as a verification of all courses and sections where at least one student is scheduled in the selected year. The output includes all Texas-specific data elements and overrides at both the course and section levels. To verify all course and section values regardless of the collection, select the "ALL" option, which also includes courses and sections flagged as "Exclude from PEIMS/TSDS". To verify the course and section values for a specific PEIMS or TSDS Collection, select the corresponding Collection Code. The output includes only those courses and sections that meet the record selection criteria for the collection.

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.
Collection Code	ALL SUMR EXYR TSDS - ECDS TSDS - Class Roster Fall TSDS - Class Roster Winter
School Year	Select the school year for which you want to filter Courses and Sections.
Class Roster Fall Snapshot Date*	Enter the Class Roster Fall Snapshot Date
Class Roster Winter Snapshot Date*	Enter the Class Roster Winter Snapshot Date
BOY ECDS Assessment Start Date	Enter the BOY ECDS Assessment Start Date
BOY ECDS Assessment End Date	Enter theBOY ECDS Assessment End Date
EOY ECDS Assessment Start Date	Enter the ECDS Assessment Start Date
EOY ECDS Assessment End Date	Enter the ECDS Assessment End Date

Report Output

Data Element	Description	[Table]FieldName
Course #	The course number	[Courses]Course_Number
Course Name	The course name	[Courses]Course_Name
School #	The name of the school	[Schools]School_Number
CDC #	Alternate school number	[Schools]Alternate_School_Number
Section #	Section number	[Sections]Section_Number
Section DCID	Section ID	[Sections]DCID
Expr	Section expression	[Sections]Expression
Term	The term ID	[Sections]TermID
Teacher #	Teacher Number	[Users]TeacherNumber
Teacher UID	The teacher's unique identification number	[Users]SIF_StatePrid
Teacher Name	Teacher's name	[Users]LastFirst
# Students	The total number of students	[Sections]no_of_students
Class ID - Calc	The class ID	calculated
Class ID - Ovr	Class ID override	[S_TX_SEC_X]E1056_ClassID_Override
Alt Course # - Crs	Alternate course number	[CoursesCoreFields]Alt_Course_Number
Alt Course # - Sec	Alternate course number	[S_TX_SEC_X]Alt_Course_Number
Crs Seq - Crs	Course sequence	[S_TX_CRS_X]Course_Sequence
Crs Seq - Crs Output Values	Course sequence	[S_TX_CRS_X]Course_Sequence
Crs Seq - Sec	Course sequence override	[S_TX_SEC_X]E0948_Course_Seq_Override
Vocational Course	Vocational course	[Courses]Vocational
Voc Cont Hrs - Crs	Vocational contact hours	[S_TX_CRS_X]Vocational_Contact_Hours
Voc Cont Hrs - Sec	Vocational contact hours	[S_TX_SEC_X]Vocational_Contact_Hours
Expl Code - Crs	Explanation code combined	[S_TX_CRS_X]Explanation_Code_Combined
Expl Code - Sec	Explanation code combined	[S_TX_SEC_X]Explanation_Code_Combined
Pop Served - Crs	Population served	[S_TX_CRS_X]E0747_Population_Served
PopServed - Sec	Population served	[S_TX_SEC_X]E0747_Population_Served
Class Type - Crs	The class type	[S_TX_CRS_X]E1055_Class_Type
Class Type - Sec	The class type	[S_TX_SEC_X]E1055_Class_Type
Non-Campus Based Inst - Crs	Non-Campus Based Instruction	[S_TX_CRS_X]E1072_Non_Campus_Based_Instr
Non-Campus Based Inst - Sec	Non-Campus Based Instruction	[S_TX_SEC_X]E1072_Non_Campus_Based_Instr
Dual Credit - Crs	Dual credit	[S_TX_CRS_X]E1011_Dual_Credit
Dual Credit - Sec	Dual credit	[S_TX_SEC_X]E1011_Dual_Credit
College Credit - Crs	College credit	[S_TX_CRS_X]E1081
College Credit - Sec	College credit	[S_TX_SEC_X]E1081_College_Credit
ATC - Crs	ATC Indicator	[S_TX_CRS_X]E1058_ATC_Indicator
ATC - Sec	ATC Indicator	[S_TX_SEC_X]E1058_ATC_Indicator
HR Section - Crs	Homeroom Section	[S_TX_CRS_X]E1440_Homeroom_Section
HR Section - Sec	Homeroom Section	[S_TX_SEC_X]E1440_Homeroom_Section
Student Instruction - Sec	Student Instruction	[S_TX_SEC_X]E1558_Student_Instruction
PK Curricula - Dist	PK Curricula - District	[Prefs]E1579_PK_Curricula
PK Curricula - Schl	PK Curricula - School	[S_TX_SCH_SCHOOLS_X]E1579_PK_Curricula
PK Curricula - Crs	PK Curricula	[S_TX_CRS_X]E1579_PK_Curricula
PK Curricula - Sec	PK Curricula	[S_TX_SEC_X]E1579_PK_Curricula
HQ PK Prog - Dist	HQ PK program	[Prefs]E1580_High_Qual_PK_Prog
HQ PK Prog - Schl	HQ PK program	[S_TX_SCH_SCHOOLS_X]E1580_High_Qual_PK_Prog
HQ PK Prog - Sec	HQ PK program	[S_TX_SEC_X]E1580_High_Qual_PK_Prog
Program Eval Type - Dist	Program Evaluation Type - District	[Prefs]E1626_Program_Eval_Type
Program Eval Type - Schl	Program Evaluation Type - School	[S_TX_SCH_SCHOOLS_X]E1626_Program_Eval_Type
Program Eval Type - Sec	Program Evaluation Type	[S_TX_SEC_X]E1626_Program_Eval_Type
Exclude from PEIMS/TSDS - Crs	Exclude from PEIMS/TSDS	[S_TX_CRS_X]Exclude_From_090
Exclude from PEIMS/TSDS - Sec	Exclude from PEIMS/TSDS	[S_TX_SEC_X]Exclude_From_090
Exclude from AAR - Crs	Exclude from AAR	[S_TX_CRS_X]Exclude_From_AAR
Exclude from AAR - Sec	Exclude from AAR	[S_TX_SEC_X]Exclude_From_AAR
Exclude from TREx - Crs	Exclude from TREx	[S_TX_CRS_X]ExcludeFromTREx
Exclude from TREx - Sec	Exclude from TREx	[S_TX_SEC_X]ExcludeFromTREx