Online Learning Extract (Minnesota)

Classic View: MN State Reporting > Online Learning Extract 

Search Term: Online Learning Extract

Online learning provides a means for students to continue, expand or enhance their education. The Online Learning Extract gathers information about students enrolled in courses which are administered online.

  Image 1: Online Learning Extract Editor
 

Report Logic

  • The course must be flagged as being an Online Learning class for students in that course to appear in the report.
    • Classic ViewGrading & Standards > Grading Tasks > Online Learning 
  • Calendars, Grades and Students marked State Exclude will no be included in the report.

Report Editor Details

Editor Field

Description

Calendars

The calendar(s) from which data is pulled from the report. Courses attached to these calendars will appear on the report.

Format

The format in which the report will generate. Options include State Format (Fixed Width), CSV, XML and HTML. CSV, XML and HTML formats are used for data review and verification, while State Format should be used when submitting reports to the state.

Report Student Legal Identities When ProvidedIndicates if Demographics fields should report from the Protected Identity Information area of the Identities tab. 
Student Ad Hoc FilterLimits student records reported to those that meet the parameters of an existing Ad hoc Filter.
Generate Extract / Submit to BatchUsers 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. For more information about submitting a report to the batch queue, see the Batch Queue article.

Generating the Extract

  1. Select the Calendar(s) to be included in the report. 
  2. Indicate the Format in which the report should generate.
  3. Indicate if Demographics fields should Report Student Legal Identities When Provided.
  4. Select a Student Ad Hoc Filter to limit report results to a pre-defined filter.
  5. Click the Generate Extract button to generate the report in the indicated format or Submit to Batch to schedule when the report will generate.


 Image 2: Online Learning Extract - State Format (Fixed Width) 

 
 Image 3: Online Learning Extract - CSV 

 
 Image 4: Online Learning Extract - XML 

 
 Image 5: Online Learning Extract - HTML 

Online Learning Extract Layout

If the Report Legal Identities When Provided is marked, Demographics fields report from Census > People > Identities > Active Identity > Protected Identity Information.

Data Element

Description and Format

Location

OLL District Number

The state-assigned identification number of the reporting district.


Numeric, 4 digits

System Administration > Resources > District Information > State District Number


District.number

OLL District Type

The code that identifies the type of school district.


Numeric, 3 digits

System Administration > Resources > District Information > Type


District.type

OLL School Number

The state-assigned identification number for the school.


Numeric, 3 digits

System Administration > Resources > School > State School Number


School.number

Student State Number

Student's unique identification number


Numeric, 13 digits

Census > People > Demographics > Person Identifiers > State ID


Student.number

Student Name

The student's legal name, reported last name, first name.


Alphanumeric, 40 characters

Census > People > Demographics > Last Name AND First Name


Identity.lastName
Identity.firstName

Birth Date

The student's date of birth


Date field, 8 characters

YYYYMMDD

Census > People > Demographics > Birth Date


Identity.birthDate

Public School

Indicates if the student is enrolled in a public school (P) or a nonpublic school (N). Always reports P.


Alphanumeric, 1 character

Student Information > General > Enrollments > State Reporting Fields > Enrolling Public School



EnrollmentMN.publicSchool

Enrolling District Number

The number of the district in which the student is enrolled.


Numeric, 4 digits

Student Information > General > Enrollments > State Reporting Fields > Enrolling District


District.number

Enrolling District Type

The type identification of the district where the student is enrolled at the time they started the OLL course.


Numeric, 2 digits

System Administration > Resources > District Information > Type



District.type

Enrolling School Number

The number of the school in which the student is enrolled.


Numeric, 3 digits

Student Information > General > Enrollments > State Reporting Fields > Enrolling School


School.number

Resident District Number

The number of the district in which the student resides.


Numeric, 4 digits

Student Information > General > Enrollments > Resident District


Enrollment.residentDistrict

Resident District Type

The type identification of the student's resident district.


Numeric, 2 digits

System Administration > Resources > District Information > Type


District.type

Grade Level

The grade level in which the student is enrolled.


Alphanumeric, 2 characters

Student Information > General > Enrollments > Grade


Enrollment.grade

Assignment Code

The STAR assignment code.



Numeric, 6 digits

Scheduling > Course > Course Editor > STAR Assignment Code


customCourse.starAssignmentCode

Course Name

The name of the course.


Alphanumeric

Scheduling > Course > Course > Name


Course.name

Course Enrollment Date

Date the student began the OLL course.



Date field, 8 characters

YYYYMMDD

Student Information > General > Schedule > Walk In Scheduler > Roster Start Date 

AND 

System Administration > Calendar > Terms > Start Date


Section.startDate

Course Completion Date

Date the student completed the OLL course.



Date field, 8 characters

YYYYMMDD

Student Information > General > Schedule > Walk In Scheduler > Roster End Date AND System Administration > Calendar > Terms > End Date


Section.endDate

Course Length

Type of credit awarded for course completion.

Valid options include:

  • Q: Quarter credit
  • T: Trimester credit
  • S: Semester credit
  • Y: Year long credit

Alphanumeric, 1 character

System Administration > Calendar > Calendar > Terms


Not dynamically stored