030 – Class Section

Introduction

This extract includes a record for each section taught during the current school year.

For sections with students from another school (concurrent enrollments), the section is reported both for the school at which the section is taught (the concurrent school) and for the school at which the student is enrolled (the student's primary school). The school number for the primary school must be entered in the Primary School field on the Edit Section page at the concurrent school.

Extracting Data for an Individual Section

You can recreate and extract an individual section The next time the extract is created the recreated data will be included.

Navigate to the School Setup > [select course] > Edit Section page for the section.
Select the Recreate 030 - Class Section checkbox.
Navigate to Special Functions > Interfaces to other systems > Tennessee Education Information System (EIS) > Recreate Section/Staff Transactions.
Select the 030 - Class Section checkbox.
Click Submit.

Report Input

For help with navigation and extract generation, see Create Selected District/School/Staff Extract File.

Extract Output

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	Field Length	Track
1	Record ID	The identifier of this record.	Always "030"	3	N
2	Record Version	The version of this record.	Always "02"	2	N
3	Record Type	One of the following record types is reported in order to indicate how to modify the state data to match data in PowerSchool. The data in this record either needs to be added to, modified in, or deleted from the state data: N – New E – Edit D – Delete	N/A	1	N
4	Filler	N/A	N/A	2	N
5	District ID	The district number.	[Prefs]Value [Prefs]Name=districtnumber	3	N
6	School ID	The school number. If this section has students from another school, then the section is included in the file for both the school at which the section is taught (the concurrent school for those students) and at their primary school. PowerSchool determines that the section has concurrent students if a value is entered in the Primary School field on the Edit Section page.	[Schools]Alternate_School_Number - if populated Otherwise: [Sections]SchoolID [S_TN_SEC_X]OtherPrimarySchools	4	N
7	School Year	The four-digit year that the instructional program will be operated to provide instructional services to students. This is the current full year term, as defined using the special operation. See the District Setup > Years & Terms section for more information.	[Terms]FirstDay [Terms]LastDay	4	N
8	Instructional Program Number	The number used to uniquely identify the program within the school. Valid values: 01, 02, 03, 04, 05, or 06.	[S_TN_SEC_X]InstructionalProgramNbr	2	Y
9	Course Code	The SDE course code for this section. If a special number is needed for a university, vocational rehab center, see the Correlation of Course Codes document: http://www.tn.gov/education/districts/correlations.shtml. Download the Entire Course Code/Endorsement Code Document.	[Courses]alt_course_number	5	N
10	Local Class Number	The internal section id value from the section enrollment record or the course number + section number Note: Setting is defined in the district > district info setting: Extract as course.section Yes/No	[Sections]ID or Course_Number+Section_Number	15	N
11	Filler	N/A	N/A	2	N
12	Service District ID	The district ID of the district where the section is taught, if different from the current district. If offered at a private location, the value must be 999.	[Sections]WhereTaughtDistrict	3	Y
13	Service School ID	The school ID of the school where the section is taught, if different from the current school. If overridden at a university, private school, or vocational center, the value must be 0005.	[Sections]WhereTaught	4	Y
14	Class Type	The class type for this section. Valid values: T – Traditional P – Pull-Out C – Self-Contained Departmentalized Note: Self-contained classes are reported as traditional – do not confuse this with self-contained departmentalized.	[S_TN_SEC_X]ClassType	1	Y
15	Teaching Method	The teaching method for this section. Valid values: (T) Traditional (D) Distance Learning (other than on-line) (A) Asynchronous Virtual Course (S) Synchronous Virtual Course (B) Bisynchronous Virtual Course (H) Hybrid Virtual Course (O) On-Line (no longer used) Refer to the Teaching Method Codes for more information.	[S_TN_SEC_X]TeachingMethod	1	Y
16	Class Begin Date	The first day of the section. This date is the first day of the term associated with the section.	[Terms]FirstDay [Sections]TermID = [Terms]ID	8	N
17	Class End Date	The last day of the section. This date is the last day of the term associated with the section.	[Terms]LastDay [Sections]TermID = [Terms]ID	8	N
18	Honors Class Indicator	Indicates whether the section is Honors. Valid values: Y – Class is Honors N – Not a Honors Class	[S_TN_SEC_X]HonorsClassIndicator	1	Y
19	State Dual Credit	Indicates whether the section is State Dual Credit. Valid values: Y – Yes N – No	[S_TN_SEC_Honors_X]StateDualCredit	1	Y
20	Local Dual Credit	Indicates whether the section is Local Dual Credit. Valid values: Y – Yes N – No	[S_TN_SEC_Honors_X]LocalDualCredit	1	Y
21	Dual Enrollment	Indicates whether the section is Dual Enrollment. Valid values: Y – Yes N – No	[S_TN_SEC_Honors_X]DualEnrollment	1	Y
22	Post-Secondary Institution	Indicates the Post-Secondary Institution entered.	[S_TN_SEC_Honors_X]SecondaryInstuition Note: Institution is misspelled.	50	N
23	Test Admin Window	Indicates the test schedule in which tests are administered.	[S_TN_SEC_Honors_X] TestAdminWindow	1	Y
24	Filler	N/A	N/A	8	N

Back to Top