Tool Search: SLDS
The Student Section Enrollment submission reports student enrollments in courses, and aims to enhance Vermont's ability to efficiently and accurately manage, analyze, and use education data.
Student Section Enrollment Extract Editor
Report Logic
Student who have any enrollment in the calendar that is prior to the entered Effective Date are included in the report, unless their enrollment record is marked as State Exclude.
The Course must have a SCED code assigned to it to be included (Scheduling & Courses > Course Information > NCES Data > NCES Code).
Report Editor
| Field | Description |
|---|---|
| Submission Code for File Name | Indicates the report naming convention based on the submission time frame of the report. |
| Extract Type | Indicates which extract generates. For this instance, select 14a Stu Section Enrollment. |
| Effective Date | Indicates the date from which data is pulled for the report. This field auto-populates with the current date; use the calendar icon to select a new date or enter a new date in mmddyy format. |
| Format | Determines the format for the report. Use State Submission when submitting the final data. Use HTML for data review and testing. |
| Report Legal Identities | When marked, the student or staff name and gender report from the Protected Identities Information on the Identities record. |
| Select Calendars | The calendar(s) from which data is pulled for the report. This option is only available when generating the HTML for the File Format and can assist with verifying data for individual calendars. |
Generate Report Submit to Batch | Users have the option of submitting the report request to the batch queue by clicking Submit to Batch instead of Generate Extract. This process allows larger reports to generate in the background without disrupting the use of Campus. |
Generate the Report
- Select the appropriate Submission Code for file name from the dropdown.
- Select 14a Student Section Enrollment for the Extract Type.
- Enter the desired Effective Date.
- Select the desired Format.
- If desired, mark the Report Legal Identities checkbox.
- If generating in HTML Format, select the desired Calendars from which to report data.
- Click the Generate Report button. The report displays in the selected format.
Student Section Enrollment - HTML Format
Student Section Enrollment - CSV Format
Report Layout
| Element | Logic | Location | ||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| ADMINID | The VT AOE assigned unique identifier for the Supervisory Union/District that is submitting data. Alphanumeric, 6 characters | School & District Information > District Information > District Detail > State District Number District.number | ||||||||||||
| ENRORGID | The VT AOE assigned unique identifier for an organization providing direct instructional or educational services. Alphanumeric, 6 characters | School & District Information > School Information > School Detail > State School Number School.number | ||||||||||||
| PERMNUMBER | The VT AOE assigned unique student identifier. This number is distinct for each student over time. Numeric, 10 digits | Census > People > Demographics > Person Identifiers > Student State ID Person.stateID | ||||||||||||
| LOCALCOURSEID | A unique identifier assigned by the school to each of their courses offered in a school year. Alphanumeric, 55 characters | Scheduling > Courses > Course > Course Editor > Number Course.number | ||||||||||||
| COURSESECTION | A unique identifier assigned by the school to each of their course sections offered in a given school year. The Course Section number is the Course Number and Section Number combined. It also includes an Flexible Pathways code that is selected on the Course Section editor. A Course Number of 100, a Section Number of 20, and a Flexible Pathways code of CP reports as 10020_CP. Alphanumeric, 30 characters | Scheduling & Courses > Course Information > Number Course.number Scheduling & Courses > Courses > Section Information > Section Editor > Section Number Section.number Scheduling & Courses > Courses > Course Information > Sections > Section Editor > Flexible Pathways Section.instructionalSetting | ||||||||||||
COURSEENROLLSTATUS | Identifies the student's enrollment status in each course section in which they were enrolled. The enrollment status reports according to the Grading Tasks or Standards that are marked as State Reported.
Numeric, 2 digits | Scheduling & Courses > Courses > Course Information > Section > Roster > Start Date, End Date ScoreListItem.stateScore MIN(Term.startDate) MAX(Term.endDate) | ||||||||||||
| SY | The school year for which data is being submitted. Numeric, 4 digits (YYYY) | N/A |
