Master Schedule Collection (Legacy)
Contents
Use this extract to create the Master Schedule Collection (MSC) file. The MSC is required to satisfy federal Indicators (b)(1), (b)(2), and (b)(3) of the State Fiscal Stabilization Fund (SFSF). The MSC provides data previously collected through Instructional Personnel (IPAL) and Math and Science Course Enrollment (CEDC) and incorporates enrollments of non-traditional students in Career and Technical Education classes.
Selection Criteria
Selection criteria determine which database records are used in the report. Refer to selection criteria for analysis when the report does not return the correct records.
B Records – IPAL
The report selects records from the Teachers table based on the following criteria:
- The teacher must be assigned to a school included in the extract.
- The teacher must not be excluded from the Master Schedule Collection extract via Start Page > Staff > Edit Information.
- The teacher must be assigned a valid state license number.
- The teacher's current Staff Status must be Teacher and employment status must be Current via Start Page > Staff > Edit Information.
- The teacher must not be excluded from the B Records.
- For G records, the teacher must be assigned a role code equal to 7 – Pupil Personnel Service Provider or 8 – Administrator.
C Records – Courses
The report selects records from the Courses table based on the following criteria:
- The course must not be excluded from the Master Schedule Collection extract via Start Page > District Setup > Courses.
- C and D records will be excluded if students are not enrolled for 20 or more school days.
- C records will not be included if the Teacher is excluded from the MSC.
D Records – Teachers
The report selects records from the Sections table based on the following criteria:
- The section must be assigned to a school included in the extract.
- The Course must not be excluded from the MSC.
- The section must not be excluded from the Master Schedule Collection extract via Start Page > School Setup > Sections.
- The section must be taught in a term that falls within the report date range.
- A teacher that meets the Teacher Selection criteria must be assigned to the section.
- The teacher cannot be excluded from the MCS.
- If the Local Provider ID is populated at the section level this ID will override the teacher ID on the D records.
E Records- Other Providers
The report selects records from the section table based on the following criteria:
- The Local Provider ID [va_loc_prov_id] must be populated in sections or on the edit enrollment page for students.
- The local provider name [va_prov_name] must be populated in sections or on the edit enrollment page for students.
- The local provider description [va_prov_desc] must be populated in sections or on the edit enrollment page for students.
Note: Must create staff record at school level with matching local provider ID if you used code 4 –(Unlicensed individual teacher, pupil personnel service)
F Records – Student
The report selects records from the Students table based on the following criteria:
- The student is not excluded from state reporting (Exclude this student from State reporting is No).
- The student had an active enrollment record at the school selected for the extract that fell within the report date range.
- The student was enrolled in the course section during the report date range for 20 days or more.
- Note- The store code indicator for the MSC is located in district >Schools/School Info must be populated.
G Record- Administrator
The report selects records from the teachers table based on the following criteria:
- The licensed staff personal is not excluded from state reporting.
- The Admin Role Code [va_admin_role_code] of 7 or 8.
I Record – Connection Record
Required for CTE and optional for other connected classes. The report selects records from the Courses and Sections Table based on the following criteria
- CTE Indicator field must be checked either at the Course or Section level for records to be included.
- CTE Connected Section ID filed must be populated on the edit Sections page. The value entered is the eternal section ID of the 'parent section'
J Record – Co-op
The report selects records from the Teachers and Student tables based on the following criteria:
- A teacher must be defined as the 'CoOp Coordinator' This field is located on the Staff Information page.
- The 'Average minutes per Day Spent with CoOp Students' field located on the Staff Information page must be populated.
- Students must be defined as CoOp Students. This field is located on the State/Province – VA > CTE Tab.
- A CoOp Coordinator must be connected to the student. This field is located on the State/Province – VA > CTE Tab.
Report Input
For help with navigation and running the report, see How to Find and Generate a Report.
Field | Description |
Use | If run at the district level, choose one of the following from the pop-up menu:
If run at the school level, the report includes all records associated with the current school that meet the selection criteria. To change the current school, click School at the top of the page and choose the appropriate school from the list. |
Processing Options | Choose a time to run the report from the pop-up menu:
|
Specific Date/Time | Enter a date using the format mm/dd/yyyyor mm-dd-yyyyin order to run the report on a specific day. The incorrect format displays an alert and the date field is submitted as a blank entry. Use the pop-up menus to schedule the report to be run at a specific hour and minute. Example: 7/29/2008 @ 10 AM : 05. |
Report Start Date (MM/DD/YYYY) | Enter the start date of the report date range. |
Report End Date (MM/DD/YYYY) | Enter the end date of the report date range. |
Sender’s Email | Enter the email address of the person sending the file to the Virginia DOE. |
File Submission Type | Choose Fall or as of the End-of-Year to determine the submission type. |
Record Types to Include | Choose the components of the MSC extract to include in the extract file: AB, AC, ADE, AF, AG, A, ACDEF, or ABCDEFGIJ. |
Percent or Letter Grade (F records only) | Choose Percent or Letter from the Pop-up menu to extract either the final grade or the final grade percent. |
Report Blank Grades or ‘NG’ forstudentin 6-12 with no grade (F records only) | Option to extract ‘NG’ or leave blank the value for the final grade for those students without grades. Grades 5 and under the value of ‘NG’ is always extracted. |
Passing Minutes to add to each Section (C records only) | Select from the pop-up menu the value that will be applied to the minutes per course. For example, if Periods are 45 minutes and Passing Time is 4 minutes, choose 4, which results in a total of 49 minutes. |
School Year | The school year which is auto-populated is driven off of the term that the user is currently viewing PowerSchool. |
Report Output
Each of the fields displayed in the output of the report are described below. See Understanding the Report Output Table for a definition of each column in the table.
Data Element | Description | [Table]FieldName | Field Type | Field Length | Fall Y/N |
A Record — Header | |||||
Record Type | Constant A | Derived | A/N | 1 | Y |
Data Collection Type | A value of “MSC_IPAL” is reported. | Derived | A/N | 8 | Y |
File Submission Type | The File Submission Type selected when running the report. Valid values:
| Derived | N | 1 | Y |
Beginning School Year | Four-digit year for beginning of school i.e. 2013 for the 2013-2014 school year. | Derived | Numeric | 4 | Y |
Division Number | Leading zero(s) must be included, i.e. 005 |
| A/N | 3 |
|
Section Type | Code to describe the data included in the submission ABG (Fall Only) AC ADE AF AI AJ ACDEF ACDEFI ACDEFJ ACDEFIJ ABCDEFG (Fall Only) ABCDEFGI (Fall Only) ABCDEFGJ (Fall Only) ABCDEFGIJ (Fall Only) | Derived | Alpha numeric | 9 | Y |
B Record — IPAL | |||||
Record Type | Constant B | Derived | Alpha numeric | 1 | Y |
Local Provider ID | Locally defined identification number must be unique within the division (i.e. employee id, teacher id, tax id). Note: Do not use SSN for this ID. | [Teachers]TeacherNumber | Alpha numeric | 20 | Y |
Teacher/Administrator License Prefix | Includes the characters preceding the dash on the teacher's license.
| [Teachers]SIF_StatePrid | Alpha numeric | 4 | Y |
Teacher/Administrator License Number | Includes the numbers after the dash on the teacher's license.
| [Teachers]SIF_StatePrid | Alpha numeric | 11 | Y |
Social Security Number | Only required if the individual does not have license information. | [Teachers]SSN | Numeric | 9 | Y |
First Name | The teacher’s first name, extracted from Start Page > Staff > Edit Information. | [Teachers]First_Name | Alpha numeric | 15 | Y |
Middle Name | The teacher’s middle name, extracted from Start Page > Staff > Edit Information. | [Teachers]Middle_Name | Alpha numeric | 15 | Y |
Last Name | The teacher’s last name, extracted from Start Page > Staff > Edit Information. | [Teachers]Last_Name | Alpha numeric | 25 | Y |
Date of Birth | The teacher’s birth date in MMDDYYYY format, extracted from Start Page > Staff > Edit Information. | [Teachers]DOB | Alpha numeric | 10 | Y |
Ethnic Flag | This field contains a Y value if the teacher is identified as Hispanic/Latino, extracted from Start Page > Staff > Edit Information. | [Teachers]FedEthnicity | Alpha-numeric | 1 | Y |
Race Code | The code identifying the teacher’s race. See the Appendix for valid values. | [Teachers]VA_ERCODE | Alpha-numeric | 2 | Y |
Gender | The teacher’s gender, extracted from Start Page > Staff > Edit Information. | [Teachers]Gender | Alpha numeric | 1 | Y |
FTE |
| [Teachers]VA_FTE | Alpha-numeric | 4 | Y |
Title I Funded Position | Does this individual have a position that is funded by Title I?
| [Teachers]VA_title_i | Alpha numeric | 1 | Y |
High-Quality Professional Development | Has this teacher received high-quality professional development?
| [Teachers]VA_hq_prof_dev | Alpha numeric | 1 | Y |
Division Experience | The number of years teaching experience within the division:
| [Teachers]VA_division_exp | Numeric | 2 | Y |
Virginia Experience | The number of years teaching experience within the Commonwealth of Virginia include public and private school experience:
| [Teachers]VA_exp | Numeric | 2 | Y |
Years’ Experience | The number of years teaching experience within education, include public, private and out-of-state experiences:
| [Teachers]VA_total_exp | Numeric | 2 | Y |
Section C — Courses | |||||
Record Type | Constant C | N/A | Alpha numeric | 1 | Y |
Section Id | A locally defined number that identifies a particular section. When coupled with the division and school, Section ID creates a unique identifier for the section. | [Sections]ID | Alpha numeric | 30 | Y |
Serving Division | Three-digit state-assigned Division number that identifies the division, center or agency that provided the course (or the resources to the course) to the students:
| [Prefs]value where [Prefs]name=DistrictNumber [Prefs]VA_DistrictNumber [Students]VA_ResponsibleDistrict [Reenrollments]VA_ResponsibleDistrict | Numeric | 3 | Y |
Serving School | Four-digit state-assigned School number that identifies the school, center, program, or placement that provided the course (or the resource to the course) to the students:
| [Students]VA_ServingSchool [ReEnrollments]VA_ServingSchool or [Schools]Alternate_School_Number
| Numeric | 4 | Y |
SCED Course Number | NCES-assigned number that represents a course by its SCED Subject Area immediately followed by its SCED Course Identifier. Note: Grade 3 Reading will be reported as 1043. In this instance when then SCED Subject Area = 01 and SCED Course Identifier = 043 they should be concatenated and reported as a single number. | [Courses]VA_SCED_Subject_Area | Numeric | 5 | Y |
MOP ID | The code that indicates that the course curriculum and delivery is provided by an approved Multi-division Online Provider (MOP). | [S_VA_CRS_X]MOP_ID | Numeric | 1 | Y |
SCED Sequence | Code to describe the manner in which school systems may "break up" single courses. Must be a valid SCED Sequence | [Courses]VA_SCED_Sequence | Alpha numeric | 3 | Y |
VA Extended Description | Used to distinguish between two or more classes within the same SCED Course Code where the SCED does not delinate. Can be blank. Must have a valid code. | N/A | Alpha numeric | N/A | Y |
Associated SOL Test Code | What, if any, SOL test will be administered to students enrolled in this course. Courses that need this code are identified in the list of approved SCED Codes for Virginia. Can be blank. Must have a valid code. | N/A | Alpha numeric | N/A | Y |
Local Course code | Locally defined Can be blank Must be alphanumeric Must be less than twenty-one characters | [Courses]Course_Number | Alpha numeric | 20 | Y |
Local Course Title | Locally defined Can be blank Must be alphanumeric Must be less than fifty-one characters | [Courses]Course_Name | Alpha numeric | 50 | Y |
Semester | The calendar time during the school year that the current course is taken. Required Must be numeric Must be one character | [Sections]VA_State_Term_Id | Numeric | 1 | Y |
Minutes Per Course | The time in minutes that the course section teacher is delivering instruction to students for the duration of the course. Required for CTE courses and must be set at the course or section level in order for the "Minutes Per Course" to be extracted for the C records. Must be numeric Must be five characters or less | Calculated or use the below field to override normal calculation
[Sections]VA_TotalMinutesPerTerm | Numeric | 5 | Y |
SCED Course Level | The code that indicates the level of rigor of the course. | [S_VA_CRS_X]SCED_Course_Level | Alpha-numeric | 1 | Y |
Filler | Filler Field |
|
|
|
|
Filler | Filler Field |
|
|
|
|
Filler | Filler Field |
|
|
|
|
Filler | Filler Field |
|
|
|
|
Section D — Teachers | |||||
Record Type | Constant D | N/A | Alpha numeric | 1 | Y |
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.
| [Sections]ID Required Must match a Section ID provided in C Record No leading zeros Cannot contain tabs, spaces, commas or single or double quotation marks Must be alphanumeric Must be less than thirty-one characters Must be unique within the Serving School | Alpha numeric | 30 | Y |
Serving Division | Three-digit state-assigned Division number that identifies the division, center or agency that provided the course to the students. | [Prefs]value where [Prefs]name=DistrictNumber [Prefs]VA_DistrictNumber Must match a Serving Division provided in the C Record Must be a valid educational agency Must be alphanumeric Must be three characters | Numeric | 3 | Y |
Serving School | Four-digit state-assigned School number that identifies the school, center, program, or placement that provided the course to the students.
| [Schools]School_Number [Schools]Alt_Schoolnumber Must match a Serving School provided in the C Record Must be a valid institution within the serving division Must be alphanumeric Must be four characters | Numeric | 4 | Y |
Teacher/Administrator License Prefix | Includes the characters preceding the dash on the teacher's license. Note: Section E is required if a teacher or teaching entity does not have a valid VA License. | [Teachers]SIF_StatePrid Blank or valid license prefix Not required if a license does not exist for the Local Provider Must be alpha Must be less than five characters | Alpha numeric | 4 | Y |
Teacher/Administrator License Number | Includes the numbers after the dash on the teacher's license. Note: Section E is required if a teacher or teaching entity does not have a valid VA License. | [Teachers]SIF_StatePrid | Alpha numeric | 11 | Y |
Local Provider ID | Locally defined identification number must be unique within the division. (i.e. employee ID, teacher ID, tax ID). Do not use SSN for this ID. | [Teachers]TeacherNumber Must be unique within the reporting division Cannot contain tabs, spaces, commas or single or double quotation marks Must be alphanumeric Must be twenty characters or less | Alpha numeric | 20 | Y |
Teacher Role Code | A code to describe the teacher’s role in this section.
| [Sections]VA_teacher_role_cd Must be a valid teacher role code Must be numeric Must one character If there is more than one teacher with a Role Code of 1, 2 or 3 for a section, all must have the same students in the F Record If Teacher Role Code=1, 4, 6, or 9, F Records must be present | Numeric | 1 | Y |
Defined Class Type | Formerly Assignment Codes Only codes that define the audience or recipient of the instruction can be used here. Who is receiving instruction/services not what is being taught. Necessary element to determine if the teacher in the section is "Highly Qualified" to teach the section.
| [Sections]VA_defined_class_type Blank or valid Defined Class Type code Must be numeric Must be four characters Warning if SCED Code is 73039 and a Defined Class Type is not present | Numeric | 4 | Y |
Highly Qualified Flag | A flag to indicate if the teacher meets the federal definition of being "Highly Qualified" in this section. (Federal core subject and Special Education only)
| [Sections]VA_highly_qual_flag Must be a Y, O or N for Federal Core Subjects Can be blank for other subjects Fatal error if teacher has a Y and N for classes with same SCED code Must be alpha Must be one character | Alpha numeric | 1 | Y |
Flexibility Criteria Flag | A flag to indicate if the teacher meets the federal definition of being "Highly Qualified" in this section by means of the flexibility criteria.
| [Sections]VA_flex_criteria_flag Must be a Y or N for Federal Core Subjects If Highly Qualified Flag is a Y or O, can be Y or N If Highly Qualified Flag is a N, must be N Must be blank if Highly Qualified Flag is blank Must be alpha Must be one character | Alpha numeric | 1 | Y |
Filler | Filler field |
|
|
|
|
Filler | Filler field |
|
|
|
|
Filler | Filler field |
|
|
|
|
Section E — Other: One record for each private provider that provides education services to the student for whom the LEA is responsible. | |||||
Record Type | Constant E | N/A | Alpha numeric | 1 | Y |
Local Provider ID | Locally defined identification number must be unique within the division. (i.e. employee id, teacher id, tax id) Do not use SSN for this Id. Must be unique within the reporting division Must match Local Provider ID from D Record Must be alphanumeric Must be less than twenty-one characters Required if State License Number is blank | [Students]VA_loc_prov_id [ReEnrollments]VA_loc_prov_id [Sections]VA_loc_prov_id Required if State License Number is blank
| Alpha numeric | 20 | Y |
Provider Name | The name of the other provider Must be the name of a specific private school, contracting company or unlicensed individual Must be unique within the reporting division Must match Local Provider ID from D Record Must be alphanumeric Must be less than twenty-one characters For individuals, include first and last name For all others, include the company name | [Students]VA_prov_name [ReEnrollments]VA_prov_name [Sections]VA_prov_name Required Cannot contain tabs, commas or single or double quotation marks Must be alphanumeric Must be less than fifty-one characters | Alpha numeric | 50 | Y |
Provider Description | Description of the services provided Must be a valid provider description Must be numeric Must be one character Fatal error if 4 does not have B Records Fatal error if 1, 3, or 5 have B Records Warning if 7 does not have B Records See Appendix for valid values | [Students]VA_prov_desc [ReEnrollments]VA_prov_desc [Sections]VA_prov_desc | Numeric | 1 | Y |
Section F — Students | |||||
Record Type | A value of “F” is reported. | N/A | Alpha numeric | 1 | Y |
Section Id | The internal section ID, extracted from Start Page > School Setup > Sections > Edit Section. | [Sections]ID | Alpha numeric | 30 | Y |
Local Provider ID | The ID of the person or agency that provides instruction to this student, if applicable, extracted from Start Page > Student > Transfer Info > Edit Enrollment. | [Students]VA_loc_prov_id [ReEnrollments]VA_loc_prov_id [Section]VA_loc-prov-id | Alpha numeric | 20 | Y |
State Testing ID | The state-assigned testing ID assigned through EMIS, extracted from Start Page > Student > State/Province – VA. | [Students]State_StudentNumber | Numeric | 10 | Y |
Local Student Id | The locally assigned student number, extracted from Start Page > Student > Demographics. | [Students]Student_Number | Alpha-numeric | 12 | Y |
Final Grade | The stored/historical grade earned by the student for this section, extracted from Start Page > Student > Historical Grades > Edit Stored Grade. | [StoredGrades]Grade for the stored code from report interface | Alpha-numeric | 3 | N |
Virtual Course Identifier | Indicates if this is an online course or a course that is provided between schools via satellite. Valid values: 1 - School sponsored/ coordinated 2 - Student coordinated This field is blank for a non-virtual course. This field is extracted from Start Page > District Setup > Courses > Edit Course District Information. | [Courses]VA_Virtual_Crs_Indicator | Numeric | 1 | Y |
Dual Enrollment Flag | Indicates (Y/N) if the course is taken as a dual enrollment course, extracted from Start Page > District Setup > Courses > Edit Course District Information. | [Courses]VA_dual_enrollment | Alpha numeric | 1 | Y |
Work-Based Learning Code (CTE Courses Only) | "Work-based learning is defined as a coordinated, coherent sequence of career-development experiences, based on instructional preparation, related to students’ career interests or goals. It involves partnerships with local business/industry and other community organizations; enables students to apply classroom instruction in a real-world business or service-oriented environment; and assists teachers and program leaders in helping students understand the relevance of classroom learning to their present and future development as workers, entrepreneurs, and citizens."
| [Courses]VA_WorkedBasedLearning if not populated then [Sections]VA_WorkedBasedLearning if not populated then [CC]VA_WorkedBasedLearning | Numeric
| 1 | Y |
Governor's Academy Code
| Indicates whether or not the course taken is at a Governor's Academy.
| [Courses]VA_GovAcademy - if not populated then [Sections]VA_GovAcademy -if not populated then [CC]VA_GovAcademy – Must be blank, S or H | Alpha | 1 | Y |
Responsible Division (for regional center use only)
| Indicates the division responsible for the student.
| [Students]VA_ResponsibleDistrict | Alpha/Numeric | 3
| Y |
Filler | Filler field |
|
|
|
|
Filler | Filler field |
|
|
|
|
Filler | Filler Field |
|
|
|
|
Section G — Administrators | |||||
Record Type | A value of “G” is reported. | N/A | Alpha numeric | 1 | Y |
Local Provider ID | The locally assigned teacher number, extracted from Start page > Staff > Edit Information. | [Teachers]TeacherNumber | Alpha numeric | 20 | Y |
Serving Division | The district number, extracted from Start Page > District Setup > District Info. | [Prefs]value where [Prefs]name=districtnumber [Prefs]VA_DistrictNumber [Students]VA_ResponsibleDistrict [Reenrollments]VA_ResponsibleDistrict | Numeric | 3 | Y |
Serving School | The school number, extracted from Start Page > District Setup > Schools/School Info > Edit School. | [Schools]School_Number [Schools]Alt_SchoolNumber | Numeric | 4 | Y |
Teacher/Administrator License Prefix | The characters preceding the hyphen (-) in the teacher’s state license number, extracted from Start Page > Staff > Edit Information. This field is blank if the teacher does not have an assigned state license number. | [Teachers]SIF_StatePrid | Alpha numeric | 4 | Y |
Teacher/Administrator License Number | The characters following the hyphen (-) in the teacher’s state license number, extracted from Start Page > Staff > Edit Information. This field is blank if the teacher does not have an assigned state license number. | [Teachers]SIF_StatePrid | Alpha numeric | 11 | Y |
Teacher Role Code | The administrator’s role in this section, extracted from Start Page > School Setup > Sections > Edit Section. Valid values: 7 – Pupil Personnel Service Provider 8 – Administrator | [Sections]VA_teacher_role_cd | Numeric | 1 | Y |
VA Assignment Code | The four-digit state-assigned course code. The IB or DE prefix is not included in this value. This field is extracted from Start Page > District Setup > Courses > Edit Course District Information. | [Courses]VA_course_code | Numeric | 4 | Y |
Division Administrative Experience
| Number of Years Administrative Experience within the Division. Must be a whole number Must be numeric Must be less than three characters | [Teachers]VA_ad_division_exp Must be a whole number Must be numeric Must be less than three characters | Numeric | 2 | Y |
Virginia Administrative Experience
| Number of years of administrative experience within the Commonwealth of Virginia. Include public and private school experience Numeric, round to nearest whole number | [Teachers]VA_ad_exp Must be a whole number Must be numeric Must be less than three characters | Numeric | 2 | Y |
Years Administrative Experience
| Number of years’ administrative experience within education. Include public, private and out-of-state experiences Numeric, round to nearest whole number | [Teachers]VA_ad_total_exp Must be a whole number Must be numeric Must be less than three characters | Numeric | 2 | Y |
Filler | Filler field |
|
|
|
|
Filler | Filler field |
|
|
|
|
Filler | Filler field |
|
|
|
|
I Records: Connection Record - Required for CTE and optional for other connected classes; One record is needed for each link between two sections. | |||||
Record Type | Constant I Must be I Must be Alpha Must be one character | N/A | Alpha | 1 | Y |
Serving Division | Three-digit state-assigned Division number that identifies the division, center or agency that provided the course to the students.
| [Prefs]value where [Prefs]name=DistrictNumber [Prefs]VA_DistrictNumber [Students]VA_ResponsibleDistrict [Reenrollments]VA_ResponsibleDistrict | Alpha/Numeric | 3 | Y |
Serving School
| Four-digit state-assigned School number that identifies the school, center, program, or placement that provided the course to the students. | [Schools]School_number [Schools]Alt_Schoolnumber |
| 4 | Y |
SectionID | 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 should be the highest level taught during that section. If no sequence, use the section with the most students. | [Sections]ID |
| 30 | Y |
Connected SectionID | 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. The Connected Section should be the lowest level taught during that section. If no sequence, use the section with the least students. | [Sections]VA_I_Record_SectionID |
| 30 | Y |
J Records: Co-op One record is needed per Local Provider overseeing Co-op. | |||||
Record Type | Constant J | Must be J | Alpha | 1 | Y |
Serving Division | Three-digit state-assigned Division number that identifies the division, center or agency that provided the course to the students. Must match a Serving Division provided in the C Record. Must be a valid educational agency Must be alphanumeric Must be three characters | [Prefs]value where [Prefs]name=DistrictNumber
| Numeric | 3 | Y |
Serving School | Four-digit state-assigned School number that identifies the school, center, program, or placement that provided the course to the students. Must match a Serving School provided in the C Record. Must be a valid institution within the serving division. Must be alphanumeric Must be four characters | [Schools]School_number [Schools]Alt_Schoolnumber | Numeric | 4 | Y |
Local Provider ID
| Locally defined identification number must be unique within the division. (i.e. employee ID, teacher ID, tax ID). Do not use SSN for this Id. | [students]VA_local_Provid_Overseeing_CoOp Must be unique within the reporting division Cannot contain tabs, spaces, commas or single or double quotation marks Must be alphanumeric Must be twenty characters or less | Numeric | 20 | Y |
Number of Student in Co-op Program | Number of Co-op students overseen by the Local Provider during the school year | Calculated based on >[Students[VA_Coop Must be numeric Must be two characters or less | Numeric | 2 | Y |
Minutes of Co-op Period | Average length in Minutes of the Teacher’s Co-op Periods. | [Teachers]VA_coop_minutes Must be numeric Must be 2 characters Must be at least 45 minutes | Numeric | 2 | Y |