The 030 Class Section extract is used to upload class-specific information such as start and end times and other section characteristics to EIS. The 030 extract is considered a parent record in EIS, meaning that it must be uploaded prior to any other course and student records.
See the EIS Batch Transmission article for an overview of the EIS Batch Transmission File, logic that applies to all extracts, and generation instructions.
Report Logic
A record reports for each section in the selected calendar(s), sorted by section Schedule Placement. To report, a Section's Course must have a State Code entered.
Records are not reported for calendars or courses marked as Exclude. If a record was previously reported and then marked as exclude, a delete record will be sent to EIS for each record.
The following records are excluded from reporting and are included in the warning report:
- Sections associated with a Course that is marked as Exclude or Courses that have Type selected but no State Code.
- Sections that have a Type Override selected but no State Code.
- Sections where an Advanced Academics value is selected on both the Course and Section.
- Courses or Sections where an Advanced Academic value of SDC, DE, or DC is selected and the Post-Secondary Institution ID is not null or 00000.
- Sections marked as Dual Enrollment or Local Dual Credit where Post-Secondary Institution ID is not null or blank space.
The Record Key, which helps determine the Type of record sent (New, Edit, or Delete), is comprised of the Record ID, Record Version, District ID, School ID, School Year, Instruction Program Number, Course Code, and Local Class Number.
030 Class Section Extract Layout
Element Name | Description | Type, Format and Length | Campus Database | Campus Application |
|---|---|---|---|---|
Record ID | Identifies the extract - reports as "030" | Numeric (3) | N/A | N/A |
| Record Version | Identifies the extract version - reports as "02" | Numeric (2) | N/A | N/A |
| Record Type | Identifies the type of extract:
| Character (1) | N/A | N/A |
| Filler | N/A. Reports as 00. | N/A | N/A | N/A |
| District ID | Reports the TN Department of Education assigned District Number. | Numeric (3) | District.number | System Administration > Resources > District Information > State District Number |
| School ID | Reports the TN Department of Education assigned School Number | Numeric (4) | School.number | System Administration > Resources > School > State School Number |
| School Year | Reports the start year of the school calendar. | Date (CCYY) | SchoolYear.startYear | System Administration > Calendar > School Years > Start Year |
| Instructional Program Number | Reports the unique Instructional Program Number of the school, or as 99 if blank. | Numeric (2) | Calendar.instructional ProgramNumber | System Administration > Calendar > Calendar > Instructional Program Number |
| Course Code | Identifies the Course code assigned by the TN Department of Education. Reports the State Code of the Course. | Numeric (5) | Course.stateCode | Scheduling > Courses > Course > State Code |
| Local Course Code | Reports the local course identifier by concatenating the course Number and section Number. | Character (15) | Course.number Section.number | Scheduling > Courses > Course > Number; Courses > Section > Number |
| Filler | N/A | N/A | N/A | N/A |
| Service District ID | Identifies the district where the class is being offered. Reports the Service District ID, or the State District Number if null. | Numeric (3) | Section.serviceDistrict District.number | Scheduling > Courses > Section > Service District ID OR System Administration > Resources > District Info > State District Number |
| Service School ID | Identifies the school where the class is being offered. Reports the Service School ID, or the State School Number, if null. | Numeric (4) | Section.serviceSchool School.number | Scheduling > Courses > Section > Service School ID OR System Administration > Resources > School > State School Number |
| Class Type | Indicates the structure of the class. Reports the Type Override entered on the Section, or the Type from the Course if null. Options are T: Traditional, P: Pull-Out, or C: Self-Contained. | Character (1) | Course.type Section.class Type | Scheduling > Courses > Section > Type Override OR Scheduling > Courses > Course > Type |
| Teaching Method | Identifies the teaching method used for the class. Reports the Teaching Method Override entered on the Section, or the Teaching Method from the Course if null. Options are T: Traditional, D: Distance learning, or O: Online Class | Character (1) | Section.teachingMethod Course.teachingMethod | Scheduling > Courses > Section > Teaching Method Override OR Scheduling > Courses > Course > Teaching Method |
| Class Begin Date | Identifies the first day of the class, based on the section's Schedule Placement. Reports the Term Start Date. | Date (CCYYMMDD) | Term.startDate | System Administration > Calendar > Calendar > Term > Start Date; Scheduling > Courses > Course > Section > Schedule Placement |
| Class End Date | Identifies the last day of the class, based on the section's Schedule Placement. Reports the Term End Date. | Date (CCYYMMDD) | Term.endDate | System Administration > Calendar > Calendar > Term > End Date; Scheduling > Courses > Course > Section > Schedule Placement |
| Honors Class Indicator | Indicates if the class is designated as an Honors Class. If Advanced Academics on the section or course is H, reports as Y. Otherwise reports as N. | Character (1) | Section.honorsCode | Scheduling > Courses > Course or Section > Advanced Academics |
| Statewide Dual Credit | Indicates that the course includes an exam approved by the Consortium for Cooperative Innovative Education, with the potential for the student to earn credit at any public postsecondary institution. If Advanced Academics on the section or course is SDC, reports as Y. Otherwise reports as N. | Character (1) | Section.honorsCode | Scheduling > Courses > Course or Section > Advanced Academics |
| Local Dual Credit | Indicates that the course includes an exam with the potential for the student to earn credit at a specific postsecondary institution. If Advanced Academics on the section or course is DC, reports as Y. Otherwise reports as N. | Character (1) | Section.honorsCode | Scheduling > Courses > Course or Section > Advanced Academics |
| Dual Enrollment | Indicates a postsecondary course taught at a postsecondary institution for which the student receives both high school and postsecondary credit. If Advanced Academics on the section or course is DE, reports as Y. Otherwise reports as N. | Character (1) | Section.honorsCode | Scheduling > Courses > Course or Section > Advanced Academics |
| Postsecondary Institution ID | Identifies the postsecondary partnering with the high school to provide postsecondary credit. If Advanced Academics on the section or course is DC or DE, reports as the Post Secondary Institution ID. If Advanced Academics is SDC, reports as 00000. Otherwise reports the Post Secondary Institution ID, or as blank spaces if null. | Character (6) | Section.postSecondary InstitutionID | Scheduling > Courses > Section > Postsecondary Institution ID |
| Test Admin Window | Identifies the assessment schedule used for Pre-ID documents. Reports the Test Admin Window Override from the Section, or the Test Admin Window from the Course if null. Options are:
| Character (1) | Course.testAdminWindow Section.testAdminWindow | Scheduling > Courses > Course > Test Admin Window; Scheduling > Courses > Section > Test Admin Window Override |
| Filler | N/A | N/A | N/A | N/A |
