Tool Search: SLDS
The Course Section submission reports course data for the selected calendar, enhancing Vermont's ability to efficiently and accurately manage, analyze, and use education data.
SLDS 13 Course Section Extract Editor
Report Logic
A course must have a SCED code assigned in order to report (Scheduling & Courses > Course > NCES Data > NCES Code).
All courses must be aligned with the selected calendar (searchable in Scheduling & Courses) on or prior to the entered Effective Date on the Report Editor.
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 13 Course Section. |
| 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 13 Course Section 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.
13 Course Section Extract - HTML Format
13 Course Section Extract - State Submission
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 Settings > District Information > District Detail > State District Number District.number |
| POSID | The VT AOE-assigned unique identifier for the organization representing the Place of Service where the person is performing a role. Alphanumeric, 6 characters | Census > People > District Assignment > Employment Assignments > Teacher Census > People > District Assignment > Employment Assignments > School School.number |
| 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 Information > 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 > Course Information > Number Course.number Scheduling & Courses > Course > Sections > Section Editor > Section Number Section.number Scheduling & Courses > Course > Sections > Section Editor > Flexible Pathways Section.instructionalSetting |
| COURSETERM | A code identifying the term during which the course section was offered. Alphanumeric, 6 characters | Scheduling & Courses > Course > Sections > Section Editor > Course Term CustomSection.value |
| COURSELEVEL | A code identifying the level of rigor at which the course section was offered. Alphanumeric, 1 character | Scheduling & Courses > Course > NCES Data > SCED Course Level Course.scedCourseLevel |
COURSELEVEL CHARACTERISTIC | A code identifying the intended audience that the course section aims to serve. Alphanumeric, 5 characters | Scheduling > Courses > Course > Course Information > Type Course.type |
COURSECREDITAVAIL | The amount of credits available for successful completion of the course section. By default, this element reports 0. Numeric, 5 digits (NN,NN) | Scheduling & Courses > Course > NCES Data > SCED Available Credit Course.scedAvailableCredit |
| COURSESETTING | A code identifying the primary location where the course section took place. Alphanumeric, 2 digits | Course > Course Detail > Course Setting Course.teachingMethod |
| SY | The school year for which data is being submitted. Numeric, 4 digits (YYYY) | N/A |
