Tool Search: Master Schedule
The Master Schedule Report collects data about student, course and staff information. This report collects data required to satisfy federal assurances for Indicators (b)(1), (b)(2), and (b)(3) of the State Fiscal Stabilization Fund (SFSF). In meeting the vast requirements of those indicators, this collection also provides data that was previously collected through Instructional Personnel (IPAL) and Math & Science Course Enrollment (CEDC).
It also includes enrollments for nontraditional students in designated Career and Technical Education classes.
Virginia Master Schedule Report Editor
Read - Generate the extract.
Write - N/A
Add - N/A
Delete - N/A
For more information about Tool Rights and how they function, see this Tool Rights article.
Report Logic
The Master Schedule Report collects all students scheduled into 20 or more hours of course instruction on or before the Effective Date entered in the report editor when the following requirements are also met:
- The course must be linked to a State Reported Grading Task or Standard.
- The student may or may not have a final grade in the course.
- Courses are reported regardless of whether the student has dropped the course.
- This report honors State Exclude indications.
- Students with No Show flagged are not reported.
When generating the Fall extract F-Student Record, students report when they are enrolled in the course as of the Effective Date. For courses that are complete as of the Effective Date, students report in the F record when they have a grade associated with any grading task or standard. For future courses, the student must be scheduled into a section with a teacher. Courses must have SCED data.
The Master Schedule's C, D, F, I and J records report course sections/students/teachers when the section start date is AFTER the Master Schedule report generation Effective Date when the Course Perkins Code is NOT NULL (CTE) or the Course Type is J.
The future section must have a teacher or primary teacher associated with it and students must be enrolled in the section for reporting.
Teachers that are not active teachers of the course section on the effective date do not report unless they are the last instructor on the course and have not been replaced.
A second F record is created for the student when a Course section has a Section staff or other Teacher who gives instruction to that specific student and the instructor does not work with the entire roster of the course section.
The following collections only report when a Primary teacher is selected on the Section Staff History: C) Course, F) Students, and D) Teachers.
STEM Schools report when the School Type (School Information > School Type) codes is STEM.
Provider ID
The following logic applies when determining the Local Provider ID.
- The Local Provider ID reports on the student’s record based on the section’s Primary Teacher in the Staff History of the course.
- The Primary Teacher may have any role code associated with their Section Staff History Record for the course.
- When there is a Primary Teacher for the section, they report as the Local Provider ID.
- Teachers that were an active instructor of the course as of the report's effective date are also considered for determining the Local Provider ID.
- A section staff member or other Teacher (non-Primary teacher) may report as the Local Provider ID when there is no active Primary Teacher as of the report's effective date.
- Section staff or other Teachers on the section with a Teacher Role of NULL or = O: Other (excluded from reporting) do NOT populate the Local Provider ID.
- When there is no teacher active as of the report's effective date, the Local Provider ID considers the most recently active Teacher by end date.
- When there is no Primary Teacher, but multiple section staff/other teachers report first from the most recently active teacher by End date. When the teachers have the same dates on the Section Staff history, the person with the lowest Person ID reports first.
Roster Verification
- When the teacher/section staff has a role code of 1, 4, 6, 7 then Campus checks to see whether there is a Roster Verification completed for that staff person for the course section.
- The Roster Verification must have a State Code of 01: MSC - End of Year.
- The Roster Verification must be certified.
- The Roster Verification must associate the instructor with at least one student on the roster, but not the entire roster of students (<100%).
- For each student associated with the staff person via the Roster Verification, when the instruction time is greater than zero, a second F record generates for the student with the Local Provider ID populated from the instructor indicated via the Roster Verification.
- When the teacher/section staff does not have one of the role codes (1, 4, 6, 7), a second F record does NOT generate for the student for that course section.
- When a qualifying Roster Verification does not exist, a second F record does NOT generate for the student for that course section.
Record Report Population Logic
The Master Schedule Report includes multiple different data collections. Marking the checkboxes in the extract editor determines which records are included in the report.
Record | Logic | ||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Includes a header record. When multiple calendars are selected in the same year, only one A record reports. | |||||||||||||||||||
Includes a record for each teacher in the section into which the student is scheduled. Reports only one record for each teacher, regardless of the number of sections or courses they teach, the number of Credential or employment records, or the number of calendars. License Number is not necessary for a teacher to report. A record also generates for each staff member with a District Assignment record active on or before the Effective Date that has a Type of 07 or 08. No record reports when the Assignment Code is Null or section Staff History Role is O: Other (excluded from reporting). B records do NOT report for individuals with a Provider code of 1, 2, 3, or 5 (Census > People > District Assignment > Provider Description). When Sort by Calendar is selected on the editor, a record reports for each assignment in each calendar. When Sort by Record Type is selected on the editor, only one record reports per school. | |||||||||||||||||||
A single record reports per unique Section ID. When a Course Section is marked as State Exclude, the Course Section does not report. This collection only reports when a Primary teacher is selected on the Section Staff History. When the Course is for PK students, the C - Course record and all associated records report even when the course does not have a state reported grading task or standard associated with it. PK courses report when their SCED code is 01027, 05129, 01039, 02029, 03229, 04429, 05179, 08029, and 23002. These students report on the F record. CTE Course Section
Regular Course Section
| |||||||||||||||||||
Includes a record for each teacher in the section into which the student is scheduled. Reports only one record for each Teacher with a License Number in a section and an Active Teacher Role on the Effective Date. When there is no active Teacher as of the Effective date of the report, the next qualifying teacher/ teaching team with the most recent Start Date reports. No record reports when section Staff History Role is O: Other (excluded from reporting). This collection only reports when a Primary teacher is selected on the Section Staff History. For the D record report, Teachers reported in the fall with a license are also reported on the EOY with the same local provider ID, even when they were end-dated prior to the EOY. Newly reported teachers on the EOY MSC are also included. | |||||||||||||||||||
Reports a single record for each non-licensed teacher and/or non-administrator of the section into which the student is scheduled.
Sections of a Course marked as Course Exclude do not report. To report, the course section must meet one of the following sets of criteria. CTE Courses (indicated with a Perkins Code)
Regular/Non-CTE Courses (Perkins Code on the course is NULL)
| |||||||||||||||||||
Reports students rostered into non-excluded course sections. Students enrolled on the Effective Date selected upon report generation report during the Fall Reporting Period. CTE Courses (indicated with a Perkins Code)
Regular/Non-CTE Courses (Perkins Code on the course is NULL)
Enrollments, Calendar, or Grade Levels marked as State Exclude are not included in the extract. This collection only reports when a Primary teacher is selected on the Section Staff History. Students served a VDOE licensed Private School for Students with Disabilities do not report on the F record except for the following schools; New Community (0701), St. Mary’s (1241), and The Auburn School (1251). The F Record must contain students for the section for each active teacher of the course/section on the effective date, with a teach role code of 1 or 4. Teachers reported in the fall with a license are also reported on the EOY with the same local provider ID, even when they were end-dated prior to the EOY. Newly reported teachers on the EOY MSC are also included. Students only report on the F Record when their Enrollment Serving Division-School field meets on of the following criteria:
| |||||||||||||||||||
Includes a record for each teacher in the section into which the student is scheduled when the teacher has a District Assignment active on or before the extract Effective Date with a Type of 7: Pupil Personnel Service Provider, 8: Administrator, or 10: Other Staff not connected to a section. Reports one record per teacher, per Type, per school, regardless of the number of calendars. District Assignment Code cannot be blank. Staff members that report a G record also report a B record. When Sort by Calendar is selected on the editor, a record reports for each assignment in each calendar. When Sort by Record Type is selected on the editor, only one record reports per school. | |||||||||||||||||||
| I | Includes a record for each CTE course, indicated with a Perkins Code. | ||||||||||||||||||
| J | Includes a record for each course with a Type of J. | ||||||||||||||||||
| K | Reports the Course Sections of the course where the Interdisciplinary Flag (IF) is populated. The (IF) must be populated with the connected Section ID number. The following fields report this combination of values: D + District Number-School Number-Course Number-Section Number. See below for more information about how this combination of values is obtained.
D + District Number-School Number-Course Number-Section Number Example D014-1234-123456789-123
|
Generate the Master Schedule
- Enter an Effective Date in mmddyyyy format or by clicking the calendar icon and selecting a date. The report includes students who are scheduled into a course on or before this date for at least 20 hours.
- Select the Extract Type to generate, Fall or EOY.
When you select EOY, the Prior Reporting Date field displays. Enter the same date as the Effective date of the Fall report generation. Doing this captures students who were reported in the Fall reporting period and students who entered after the Fall Effective Date of report generation.
- Indicate which Records should be included in the extract by marking the checkboxes.
- Mark to Report Protected Identities, if applicable.
- Unmark the Exclude Cross-Site Data checkbox, if applicable.
- Indicate the Format in which the extract should generate. Options are CSV, Tab Delimited and HTML.
- Select to Sort by Calendar or Record Type.
- Indicate which Calendar(s) should be included in the extract.
- Select the Generate Report button to generate the extract in the desired format.
Users have the option of submitting a 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.
Master Schedule Report Layout
Header Record
A single header record is generated for all combinations of records and for all file types.
| Element Name | Description | Logic |
|---|---|---|
| SenderID | The State District Number. | District Information > State District Number |
| CreateDate | The system date. | System Generated |
| CreateTime | The system time. | System Generated |
| The sender's email address. | Reports as Email and must be manually updated | |
| tilde | System Generated | Reports ~~ |
| DataType | The Extract Type selected on the report editor. | Reports MSC _FALL or MSC_EOY |
| tilde | System Generated | Reports ~ |
A Records Header
Element Name | Description |
|---|---|
Record Type | The type of record being generated. Reports as A. Alphanumeric, 1 character |
Data Collection Name | The system generated name for the data collection. Reports as MSC_IPAL. Alphanumeric, 8 characters |
File Submission Type | The code that describes the submission. Reports based on the Extract Type selected: 1 for Fall and 3 for End of Year. Numeric, 1 digit |
Beginning School Year | The start year of the reported calendar. Date field, 4 digits |
Division Number | The state district number. Numeric, 3 digits |
Section Type | The code describing the data included in the submission. For example, reports as ADE when records A, D and E are being generated. Alphabetic, 6 characters |
B Records IPAL
Element Name | Description | Location |
|---|---|---|
Record Type | The type of record being generated. In this case, reports as B. Alphanumeric, 1 character | Not dynamically stored |
Local Provider ID | The locally defined identification number that is unique to the individual within the division. Numeric, 20 digits | Demographics > Local Staff Number person.staffNumber |
License Prefix | The teacher's license prefix. Alphanumeric, 4 characters | District Employment > License Prefix employment.licensePrefix |
License Number | The teacher's license number. Alphanumeric, 11 characters | District Employment > License Number employment.licenseNumber |
SSN | The social security number of the individual. Reports when the Teacher/Administrator License Prefix and Teacher/Administrator License Number are blank. Numeric, 9 digits | Demographics > Soc Sec Number identity.ssn |
First Name | The legal first name of the individual. Information reports from the Demographics tool unless the Report Protected Identities checkbox is marked. When the Report Protected Identities checkbox is marked on the extract editor information reports from Identities > Protected Identity Information. When the legal name fields are blank, name information reports from the Demographics tool. Alphanumeric, 15 characters | Demographics > First Name identity.firstName Identities > Protected Identity Information > Legal First Name legal.firstName |
Middle Name | The legal middle name of the individual. Information reports from the Demographics tool unless the Report Protected Identities checkbox is marked. When the Report Protected Identities checkbox is marked on the extract editor information reports from Identities > Protected Identity Information. When the legal name fields are blank, name information reports from the Demographics tool. Alphanumeric, 15 characters | Demographics > Middle Name identity.middleName Identities > Protected Identity Information > Legal Middle Name legal.middleName |
Last Name | The legal last name of the individual. Information reports from the Demographics tool unless the Report Protected Identities checkbox is marked. When the Report Protected Identities checkbox is marked on the extract editor information reports from Identities > Protected Identity Information. When the legal name fields are blank, name information reports from the Demographics tool. Alphanumeric, 25 characters | Demographics > Last Name identity.lastName Identities > Protected Identity Information > Legal Last Name legal.lastName |
| Filler 9 | N/A | N/A |
| Ethnic Flag | Indicates whether the student is of Hispanic/Latino descent. Reports blank only when Race Ethnicity is also blank. Alphanumeric Y or N | Demographics > Race/Ethnicity > Is the individual Hispanic/Latino? Identity.hispanicEthnicity |
| Race Ethnicity | The code calculated in the state Race Ethnicity mapped field based on the race or combination of races checked. Reports blank only when Ethnic Flag is also blank. Numeric, 2 digits | Demographics > Person Information > Race/Ethnicity Identity.raceEthnicity |
| Gender | Indicates when the student is (M)ale, (F)emale, or N(Non-Binary). Alphanumeric, 1 character | Demographics > Gender Identity.gender |
FTE | The full-time employment percentage of the individual. The FTE Percent reports in the following format: x.xx. For example, when 100 is entered in the FTE Percent field, 1.00 reports. When 50 is entered in the the FTE Percent field, then .50 reports. When the FTE Percent field is blank or 0, 0.00 reports. Decimal, 4 characters | District Employment > FTE Percent employment.ftePercent |
Title I Funded | Indicates any percentage of the individual's position is funded by Title I. In the District Assignment determining the record, when there is a value other than NULL or 0 in the Title 1 Funding %, Y reports. Otherwise, N reports. Alphanumeric, 1 character Y or N | District Assignment > Title I Funding % employmentAssignment.titleIFundingPercent |
High Quality | Indicate the individual is endorsed as Highly Qualified. Reports the option selected in the HQ Development dropdown list of the District Employment record that is active on the extract Effective Date. When more than one records exist, reports from the one with the most recent Start Date. When null, reports as Y. Alphanumeric, 1 character | District Employment > HQ Development Employment. hqDevelopment |
| Filler 16 | N/A | N/A |
| Filler 17 | N/A | N/A |
| Filler 18 | N/A | N/A |
| First Year Teacher Flag | The First Year Teacher Flag identifies individuals that have less than one year full-time teaching experience in a public or an accredited non-public school. Campus finds the District Employment record that has a Start Date on or before the report Effective Date. Y reports when the Teaching Start Year date is within the calendar year and the Teaching Years Modifier field is 0 or null. N reports when any of the following is true:
Alphanumeric, 1 character Y or N | District Employment > Start Date District Employment > Teaching Start Year |
| Division Teaching Experience | The number of years the individual has completed teaching in the current school division. A value reports when the employee has a current or historical district assignment where the Teacher field is marked.
Numeric, 2 digits | District Assignment > Teacher District Employment > Teacher Start Year Date |
| Total Years' Teaching Experience Completed | The total number of years the individual has completed as a teacher in any public, private, or out of state school. A value reports when the employee has a current or historical district assignment where the Teacher field is marked.
Numeric, 2 digits | District Employment > Teaching Modifier |
| Division Administrative Experience | The number of years the individual has completed as an administrator in the current school division. A value reports when the employee has a district assignment type of 08: Administrator. When the administrator is in the first year of administration or not completed a full year in administration as of October 1 of the current school year, the number zero reports.
Numeric, 2 digits | District Assignment > Type = 08: Administrator District Employment > Administrator Start Year Date |
| Total Years' Administrative Experience Completed | The total number of years the individual has completed as an administrator in any public, private, or out of state school. A value reports when the employee has a district assignment type of 08: Administrator. When the administrator is in the first year of administration or not completed a full year, the number zero reports. Numeric, 2 digits | District Assignment > Type = 08: Administrator District Employment |
| Division Pupil Personnel Experience | The number of years the individual has completed as pupil personnel in the current school division. To report, the Staff District Assignment's Type must be 07 Pupil Personnel Service Provider. When the individual has not completed a full year as pupil personnel as of October 1 of the current school year, the number zero reports.
Numeric, 2 digits | District Assignment > Type = 07: Pupil Personnel Service Provider District Employment > Pupil Personnel Start Year Date |
| Total Years' Pupil Personnel Experience Completed | The total number of years the individual has completed as pupil personnel in any public, private, or out of state school. To report, the Staff District Assignment's Type must be 07 Pupil Personnel Service Provider. When the individual has not completed a full year as pupil personnel as of October 1 of the current school year, the number zero reports. Numeric, 2 digits | District Assignment > Type = 07 : Pupil Personnel Service Provider District Employment > Pupil Personnel Year Modifier |
| Filler 26, 27 | N/A | N/A |
C Records Courses
Element Name | Description | Location |
|---|---|---|
Record Type | The type of record being generated. In this case, reports as C. Alphanumeric, 1 character | Not dynamically stored |
Section ID | The locally defined number that identifies the section. The ID reports using the following combination: D + District Number - School Number - Course Number - Section Number. Example D014-1234-123456789-123 Alphanumeric, 30 characters | District Information > State District Number School Information > State School Number Course > Number (local number) Course Section > Section ID |
Serving Division | The state-assigned Division number that identifies the division, center or agency that provided the course. The Serving Division reports from the Serving Division-School field on the section when it is populated. When it is not populated, Campus checks the Serving Division-School on the Course. When both Course and Section are blank, Serving Division reports from the State District where the course occurs. Numeric, 3 digits | Course Sections > Serving Division-School Course Information > Serving Division-School Section.serviceDistrict District Information > State District Number District.number |
Serving School | The state-assigned School number that identifies the school, center, program or placement that provided the course. The Serving School reports from the Serving Division-School field on the section when it is populated. When it is not populated, Campus checks the Serving Division-School on the Course. When both Course and Section are blank, Serving School reports from the School Numbers where the course occurs. Numeric, 4 digits | Course Sections > Serving Division-School Course Information > Serving Division-School Section.serviceDistrict OR School Information > State School Number School.number |
| SCED Code | The SCED Code is the NCES-assigned number that represents a course by its SCED Subject Area immediately followed by its SCED Course Identifier. For example, Grade 3 Reading would be reported as 1043 when then SCED Subject Area is 01 and SCED Course Identifier is 043. Numeric, 5 digits | Course Information > NCES Data > SCED Subject Area Course.scedSubjectArea AND Course Information > NCES Data > SCED Course Identifier Course.scedCourseId |
| Filler | N/A | N/A |
| SCED Course Level | This code conveys the level of rigor of the course. Alphanumeric, 1 character | Course Information > NCES Data > SCED Course Level Course.scedCourseLevel |
SCED Sequence | The code describing how the school systems may break up increasingly difficult or more complex information. Currently, values of 1 and 1 are hard-coded. This element reports blank for CTE courses. When the SCED Sequence is 1 1, reports as blank. Alphanumeric, 3 characters | Course Information > NCES Data > SCED Sequence Course.scedSequence |
| VA Extended Description | The VA Extended Description is used to distinguish between two or more classes within the same SCED Course Code where the SCED does delineate. Alphanumeric, 5 characters | Course Information > VA Extended Description Course.VAExtDesc |
| Associated SOL Test Code | This field reports what SOL test is administered to students enrolled in this course. An assessment code reports in this field only when the Assessment > End Date is blank, on, or after the report generation's Effective Date. When the End Date is before the Effective Date, an assessment code does not report. When multiple state coded assessments are attached to the course on the Course Assessment tool, the reporting value of the two assessments are concatenated with the smaller value first. Only the following assessment combinations report. All other combinations are invalid.
Otherwise, this field reports blank. Alphanumeric, 8 characters | Course Assessment > End Date |
Filler | N/A | N/A |
Local Course Code | The locally-assigned course code. Alphanumeric, 20 characters | Course Information > Number Course.number |
Local Course Title | The locally-defined name of the course. Alphanumeric, 50 characters | Course Information > Name Course.name |
| Semester | Reports the Term field on the Section tool. When blank, reports the Term field from the Course tool. Otherwise reports as blank. Alphanumeric, 1 character | Course Sections > Term; Course > Term Section.term Course.term |
| Minutes Per Course | Calculates the total number of minutes that the section is taught. Only reports when the course has a Perkins Code. Numeric, 5 digits | Scheduling > Courses > Section > Schedule Placement and System Administration > Calendar > Calendar Days |
| MOP ID | The code that identifies a course with curriculum and delivery that is provided by an approved Multi-division Online Provider.
| Course > MOP ID Course.provider |
| Interdisciplinary Flag | Reports Y when the Section > Interdisciplinary Connected Section is populated. Reports Y for the section reporting that is populated in the Interdisciplinary Connected Section on another section. This section does not need the Interdisciplinary Connected Section populated. Otherwise, N reports. Alphanumeric Y or N | Scheduling > Courses > Course > Sections > Interdisciplinary Connected Section CustomSection.interdisciplinarySection |
| Filler | N/A | N/A |
D Records Teachers
Element Name | Description | Location |
|---|---|---|
Record Type | The type of record being generated. In this case, reports as D. Alphanumeric, 1 character | Not dynamically stored |
Section ID | The locally defined number that identifies the section. The ID reports using the following combination: D + District Number - School Number - Course Number - Section Number. Example D014-1234-123456789-123 Alphanumeric, 30 characters | District Information > State District Number School Information > State School Number Course > Number (local number) Section Information > Section ID |
Serving District | The state-assigned Division number that identifies the division, center or agency that provided the course. The Serving Division reports from the Serving Division-School field on the section when it is populated. When it is not populated, Campus checks the Serving Division-School on the Course. When both Course and Section are blank, Serving Division reports from the State District where the course occurs. Numeric, 3 digits | Section Information > Serving Division-School Course Information > Serving Division-School OR District Information > State District Number Section.serviceDistrict |
Serving School | The state-assigned School number that identifies the school, center, program or placement that provided the course. The Serving School reports from the Serving Division-School field on the section when it is populated. When it is not populated, Campus checks the Serving Division-School on the Course. When both Course and Section are blank, Serving School reports from the School Numbers where the course occurs. Numeric, 4 digits | Section Information > Serving Division-School Course Information > Serving Division-School OR School Information > State School Number Section.serviceDistrict |
License Prefix | The teacher's license prefix. Alphanumeric, 9 characters | District Employment > License Prefix employment.licensePrefix |
License Number | The teacher's license number. Alphanumeric, 11 characters | District Employment > License Number employment.licenseNumber |
Local Provider ID | The locally defined identification number that is unique to the individual within the division. Numeric, 20 digits | Demographics > Local Staff Number person.staffNumber |
Teacher Role Code | A code describing the teacher's role in the section. Numeric, 1 digit | Scheduling > Courses > Section > Role teacher.role |
Defined Class Type | The type of special education needs served in the course. When a Defined Class Type value is set, only reports for teachers who have a District Assignment.
Numeric, 4 digits | Section Information > Defined Class Type OR Course Information > Course course.spedArea |
| Filler | N/A | N/A |
E Records Other Providers
Element Name | Description | Location |
|---|---|---|
Record Type | The type of record being generated. In this case, reports as E. Alphanumeric, 1 character | Not dynamically stored |
Local Provider ID | The locally defined identification number that is unique to the individual within the division. Numeric, 20 digits | Demographics > Local Staff Number person.staffNumber |
Provider Name | The name of a specific private schools, contracting company or unlicensed individual who serves as the other provider. Alphanumeric, 50 characters | Demographics > First and Last Name identity.firstName |
Provider Description | The description of services provided. This field reports from the calendar associated district assignment. When the record does not have a Provider Description, this field reports 7. Numeric, 1 digit | Employment Assignment > Provider Description employmentAssignment.alternateType |
F Records Students
Element Name | Description | Location |
|---|---|---|
Record Type | The type of record being generated. In this case, reports as F. Alphanumeric, 1 character | Not dynamically stored |
Section ID | The locally defined number that identifies the section. The ID reports using the following combination: D + District Number - School Number - Course Number - Section Number. Example D014-1234-123456789-123 Alphanumeric, 30 characters | District Information > State District Number School Information> State School Number Course > Number (local number) Section Information > Section ID |
Local Provider ID | The locally defined identification number of the Primary Teacher that is unique to the individual within the division. The Local Staff Number for the section's teacher as of the Effective Date reports.
Teachers whose Teacher Role field is NOT NULL always report a record for the student when they are the Primary Teacher. Campus creates a second F record for the student when a Course section has a Section staff or other Teacher who gives instruction to that specific student and the instructor does not work with the entire roster of the course section.
Numeric, 20 digits | Demographics > Local Staff Number person.staffNumber |
State Testing ID | The unique identification number assigned to the student and maintained by the state. Numeric, 10 digits | Demographics > Person Identifiers > State ID person.stateID |
Local Student ID | The unique identification number assigned to the student and maintained by the division or district. Numeric, 4 digits | Demographics > Person Identifiers > Local Student Number person.studentNumber |
Final Grade | The State Score of the most recent or final grade for the student in the section. Reports as blank when there is no grade to report. Alphanumeric, 3 characters | Grades > Final Grade |
Remote Course Indicator | Indicates the course was administered via virtual means, such as an online course or a course taken via satellite between schools.
Reports a code of 1-4 selected from the Section Online Course Override dropdown. When the Section dropdown is null, the selected code from the Online Course field reports. Reports as 1 when populated with codes DL-MOP or MOP, or the Section Online Course Override is DL-MOP or MOP. Reports as blank when both are null. Numeric, 1 digit | Section Information > Online Course Override; Course Information > Online Course Course.distanceLearning |
Dual Enrollment | Indicates the course was taken as a dual enrollment course. When the Dial Enrollment checkbox on the Course Information tool is marked, OR when the Instruct Setting/Work-Based Learning field on the Section Information tool is marked as Dual Credit OR the Instructional Setting Override field on the Section Roster Batch Edit tool is marked as Dual Credit, reports Y. Otherwise, this reports as N. Alphanumeric, 1 character Y or N | Courses > Section Information > Instruct Setting/Work-Based Learning Scheduling & Courses > Courses > Section Information > Section Roster Batch Edit > Instructional Setting Override |
| Work Based Learning | The Instructional Setting of the section. Reports the code selected in the Instructional Setting field. When the Course > Type is CO: Co-op Course, 1 reports. When the Course Type is not Co: Co-op, Campus checks the Roster Batch Edit > Instructional Setting field first. When the Instructional Setting field is null, then Campus checks the Section > Instructional Setting field. When marked as Dual Credit, this reports as null. | Section Information > Instructional Setting Section Information > Roster Batch Edit > Instructional Setting and report selected code Section.instructionalSetting |
| Governor's Academy Code | Reports S when the School Type is code STEM. | N/A |
| Responsible Division | The left leading 3 digits in front of the dash from the Responsible Division/School dropdown list. This value reports when the student is enrolled in any school where the District Information Detail Type is RC. When blank, the State District Number reports. Otherwise, this field reports blank. This value is required for the F record. Alphanumeric, 3 characters | Enrollments > State Reporting > Responsible Division-School Enrollment.responsibleDivSchool |
| Credit Awarded Flag | Indicates whether credit was earned. Reports Y when the associated course has a transcript entry where Credit Earned is greater than 0. When there is no transcript entry, N reports. N also reports when a student has a passing transcript entry for a course where the Credit Type on the state-reported Grading Task used for reporting has a State Code = NC on the associated Credit Group. Alphanumeric, 1 character Y or N | N/A |
| 50% Course Enrollment Flag | Indicates the student was enrolled in the course 50% or more of the reporting term. Alphanumeric, 1 character Y or N | Calculated |
| Responsible School | Reports the responsible school number for the student. Reports the numbers after the slash from the Responsible-Division School field on the student's Enrollment record. When applicable, left-padded zeros are added to meet the 4-character requirement. When null, reports the state school number. When applicable, left-padded zeros are added to meet the 4-character requirement. Alphanumeric, 4 characters | Enrollments > Responsible Division-School District Information > State School Number |
G Records Administrators
Reports records for staff members who have a District Assignment record on or before the Effective Date of the report in the year being reported with a Type of 7: Pupil Personnel Service or 8: Administrator.
Element Name | Description | Location |
|---|---|---|
Record Type | The type of record being generated. In this case, reports as G. Alphanumeric, 1 character | Not dynamically stored |
Local Provider ID | The locally defined identification number that is unique to the individual within the division. Numeric, 20 digits | Demographics > Local Staff Number person.staffNumber |
Serving Division | The state-assigned Division number that identifies the division, center or agency that provided the course. Numeric, 3 digits | District Information > State District Number district.number |
Serving School | The state-assigned School number that identifies the school, center, program or placement that provided the course. Numeric, 4 digits | School Information > State School Number school.number |
License Prefix | The teacher's license prefix. Alphanumeric, 9 characters | District Employment > License Prefix employment.licensePrefix |
License Number | The teacher's license number. Alphanumeric, 11 characters | District Employment > License Number employment.licenseNumber |
Teacher Role Code | A code describing the administrator's role. Reports as one digit; when the value is zero-filled, reports the right-most digit. Numeric, 1 digit | District Assignment > Role teacher.role |
VA State Assignment Code | The code assigned to the course by the state. Alphanumeric, 4 characters | District Assignment > Assignment Code EmploymentAssignment.assignmentCode |
| Filler | N/A | N/A |
| Filler | N/A | N/A |
| Filler | N/A | N/A |
| First Year Administrator Flag | Identifies whether an individual has less than one year of full-time experience in their current role in a public or an accredited non-public school. Reports from the District Employment record that have a Start Date on or before the report Effective Date. When the Administrator Start Date is within the calendar year for which the report is being run, Y reports. Otherwise, N reports. Alphanumeric, 1 character | District Employment > Start Date |
| Filler | N/A | N/A |
| Filler | N/A | N/A |
I Records Connection Record
Elements | Description | Type, Format and Length | Interface Location |
|---|---|---|---|
Record Type | The type of record being generated. In this case, reports as I. Alphanumeric, 1 character | Not dynamically stored | |
Serving Division | The state-assigned Division number that identifies the division, center or agency that provided the course. The Serving Division reports from the Serving Division-School field on the section when it is populated. When it is not populated, Campus checks the Serving Division-School on the Course. When both Course and Section are blank, Serving Division reports from the State District where the course occurs. Numeric, 3 digits | Section Information > Serving Division-School Section.serviceDistrict | |
Serving School | The state-assigned School number that identifies the school, center, program or placement that provided the course. The Serving School reports from the Serving Division-School field on the section when it is populated. When it is not populated, Campus checks the Serving Division-School on the Course. When both Course and Section are blank, Serving School reports from the School Numbers where the course occurs. Numeric, 4 digits | Section Information> Serving Division-School Section.serviceDistrict | |
| Section ID | Reports the locally-defined number that identifies a particular section of a course. When coupled with the division and school, Section ID creates a unique identifier for the section. When the Connected Section field is populated for a section, the Connected Section ID reports.
When there are no matching Section IDs, reports the Connected Section ID number (Scheduling > Courses > Section). Alphanumeric, 30 characters | Section Information > Section ID Section.number | |
Connected Section ID | The locally defined number that identifies the section. The ID reports using the following combination: D + District Number - School Number - Course Number - Section Number. Example D014-1234-123456789-123 Alphanumeric, 30 characters | District Information > State District Number School Information > State School Number Course > Number (local number) Section Information > Section ID | |
J Records Co-op
Elements | Description | Interface Location |
|---|---|---|
Record Type | The type of record being generated. In this case, reports as J. Alphanumeric, 1 character | Not dynamically stored |
Serving Division | The state-assigned Division number that identifies the division, center or agency that provided the course. The Serving Division reports from the Serving Division-School field on the section when it is populated. When it is not populated, Campus checks the Serving Division-School on the Course. When both Course and Section are blank, Serving Division reports from the State District where the course occurs. Numeric, 3 digits | Section Information > Serving Division-School Course Information > Serving Division-School OR District Information > State District Number Section.serviceDistrict |
Serving School | The state-assigned School number that identifies the school, center, program or placement that provided the course. The Serving School reports from the Serving Division-School field on the section when it is populated. When it is not populated, Campus checks the Serving Division-School on the Course. When both Course and Section are blank, Serving School reports from the School Numbers where the course occurs. Numeric, 4 digits | Section Information > Serving Division-School Course Information > Serving Division-School OR School Information > State School Number Section.serviceDistrict |
Local Provider ID | Reports the locally-defined identification number that is unique within the division. Alphanumeric, 20 characters | Demographics > Local Staff Number person.staffNumber |
| Number of Students in Co-op Program | The number of Co-op students overseen by the local provider during the school year. When the course has a Type of J, reports the number of students scheduled into the course. Numeric, 2 digits | Course Information > Type: CO, calculates from Scheduling > Courses > Roster |
| Avg. # of Minutes | The average number of minutes a teacher is working with Co-op students. Numeric, 3 digits | Course Information> Type: CO, calculates from Section Information> Section Placement and Days |
K Records Interdisciplinary Connection
| Elements | Description | Campus Location |
|---|---|---|
| Record Type | The type of record being generated. In this case, reports as K. Alphanumeric, 1 character | Not dynamically stored |
| Serving Division | The state-assigned Division number that identifies the division, center or agency. Numeric, 3 digits | Section Information > Serving Division-School OR District Information > State District Number Section.serviceDistrict |
| Serving School | The state-assigned School number that identifies the school, center, program or placement. Numeric, 4 digits | Section Information > Serving Division-School OR School Information > State School Number Section.serviceDistrict |
| Section ID | Reports the locally-defined number that identifies a particular section of a course. When coupled with the division and school, Section ID creates a unique identifier for the section.
| Section Information > Section ID Section.number |
| Connected Section ID | A locally defined number that identifies a particular section of a course. When coupled with the division and school, Section ID creates a unique identifier for the section.
| Section Information > Interdisciplinary Connected Section OR Section Information > Section ID of section where Interdisciplinary Connected Section text box is populated Section.number |
| Interdisciplinary Course Title | A locally defined course title where two different SCED codes are combined to create one course. The Course Name reports when Interdisciplinary Connected Section textbox populated on the Section. The Course Name of the Section reports when the record for sections of the Local Course Number with the matching SectionID from the Interdisciplinary Connected Section textbox is reported. Alphanumeric, 50 characters | Course Information > Name Course.name |
Footer Records
Element Name | Description | Type, Format and Length |
|---|---|---|
| Total Records | The total number of records in the entire file. | Numeric |
Previous Versions
Master Schedule Report (Virginia) [.2323 - .2335]
Master Schedule Report (Virginia) [.2307 - .2319]
Master Schedule Report (Virginia) [.2243 - .2303]
Master Schedule Report (Virginia) [.2203 - .2239]
