Student Programs
This category captures student associations and data related to programs and includes the following data views and resources:
StudentPrograms
This data view represents the program(s) that a student participates in or is served by. The published view layout provides the School Name, Student Number, Student Name, STN Number, Grade Level, Program Type, Program Name, Entry Date, Last Publish Date, Publishing ID, and Resource ID.
The following Program Types are currently published for Vermont Ed-Fi:
Curricular Materials Reimbursement (Textbook)
Multilingual Learners (Language Minority)
School Food Services (Free / Reduced Price meals)
Virtual Education
Special Education
Special Education - Choice Voucher
Section 504
High Ability Program
Homeless
Homebound
Parent in Military
Unaccompanied Youth
Title I
Alternative Education
Refugee Program
studentProgramAssociation
Primary PowerSchool Source Data
[CST_PubProgram]
[Students]
[ReEnrollments]
Selection Criteria
Records are published if the following criteria are met:
The student must not be excluded from state reporting.
The student’s school of enrollment must not be excluded from state reporting.
The studentUniqueID (Vermont Student Number) must be populated in PowerSchool ([Students]State_StudentNumber).
Resource Output
The studentProgramAssociation resource is dependent on the prior publishing of the following resources: students and programs.
LEAs and Schools may upload (publish) data to the Ed-Fi ODS in real-time or on-demand (“Run Now” button).
Click Export to export the data collection results to an Excel spreadsheet.
Data Element | Description | [Table]Data Type | Stored in [Table]Field | Required |
---|---|---|---|---|
educationOrganizationReference A reference to the related educationOrganization resource. | R | |||
/educationOrganizationID | The Education Organization associated with the program. | Integer | Derived from: [Prefs]Name=DistrictNumber If subdistricts are configured ([Prefs]Value = '1' where name = 'PSSR_SubDistrict'), then: [CST_SubDistricts]Subdistrict_Number | R |
programReference A reference to the related Program resource. | R | |||
/educationOrganizationId | The Education Organization associated with the program. | Integer | Derived from: [Prefs]Name=DistrictNumber If subdistricts are configured ([Prefs]Value = '1' [CST_SubDistricts]Subdistrict_Number | R |
/type | ProgramType - The type of program. | String | [CST_PubProgram]Type | R |
/name | The formal name of the program of instruction, training, services, or benefits available through federal, state, or local agencies. | String | [CST_PubProgram]Name | R |
studentReference A reference to the related students resource. | R | |||
/studentUniqueID | The student associated with the program. | String | [Students]State_StudentNumber | R |
beginDate | The month, day, and year on which the Student first received services. | Date | [ReEnrollments]EntryDate where [ReEnrollments]EntryDate fall between the first day and last day of term record for school, and [ReEnrollments]ExitDate is empty, or [ReEnrollments]EntryDate is less than [ReEnrollments]ExitDate and the first day of the term is less than [ReEnrollments]Exit Date. Otherwise: [Students]EntryDate, if populated. Otherwise: [Terms]FirstDay | R |
Student School Food Service
This resource represents an individual for whom is listed with an Economic Indicator.
studentSchoolFoodService
Primary PowerSchool Source Data
[Students / ReEnrollments]
[S_VT_STU_X / S_VT_REN_X]
Selection Criteria
Records are published if the following criteria are met:
The studentUniqueId (MARSS Number) must be populated in PowerSchool.
The student must not be excluded from state reporting.
The student's school of enrollment must not be excluded from state reporting.
The student must have at least one school enrollment with an Entry Date that falls within the date range defined by [Terms]FirstDay and [Terms]LastDay for the year of the Term selected in the PowerSchool UI.
The enrollment exit date is greater than the entry date.
The Economic Indicator has a value of 1 or 2.
Data Element | Description | [Table]Data Type | Stored in [Table]Field | Required |
---|---|---|---|---|
educationOrganizationReference / educationOrganizationId | A reference to the related school. | String | Determined by the school that the data is being generated for. | R |
programReference / educationOrganizationId | The District in which the program is being administered. | String | Determined by the district the data is being published from. | R |
programReference / programName | Hardcoded to 'School Food Service'. | String | Hardcoded to 'School Food Service'. | R |
programReference / programTypeDescriptor | Hardcoded to 'School Food Service'. | String | Hardcoded to 'School Food Service'. | R |
studentReference / studentUniqueId | A unique number or alphanumeric code assigned to a student by a state education agency. | String | [Students]State_StudentNumber | R |
beginDate | The begin date of the student in this program. | Date-time | [Students]EntryDate | R |
endDate | The end date of the student in this program. | Date-time | Only published if the student has exited. | O |
schoolFoodServiceProgramServices / schoolFoodServiceProgramServiceDescriptor | Indicates the service being provided to the student by the School Food Service Program. Ed-Fi Descriptors Legacy Codeset Ed-Fi codeValue | String | [S_VT_STU_X]NSLELG | R |
StudentProgramAssociations (SPA)
Describes student participation in a program published by the LEA.
Primary PowerSchool Source Data
[Students]
[ReEnrollments]
Selection Criteria
Records are published if the following criteria are met:
The student must not be excluded from state reporting.
The student’s school of enrollment must not be excluded from state reporting.
The studentUniqueID (Vermont Student Number) must be populated in PowerSchool ([Students]State_StudentNumber).
Resource Output
The studentProgramAssociation resource is dependent on the prior publishing of the following resources: students and programs.
LEAs and Schools may upload (publish) data to the Ed-Fi ODS in real-time or on-demand (“Run Now” button).
Click Export to export the data collection results to an Excel spreadsheet.
Data Element | [Table]Data Type | Stored in [Table]Field | Required | ||
---|---|---|---|---|---|
StudentProgramAssociations | Describes student participation in a program published by the LEA | ||||
beginDate | The begin date of the student in this program. | Date | [Students]EntryDate | Y | |
endDate | The end date of the student in this program. | Date | Only published if the student has exited. | ||
reasonExitedDescriptor | Descriptor | ||||
servedOutsideRegularSession | Boolean | ||||
educationOrganizationReference | educationOrganizationId | A reference to the related school. | Integer |
[Prefs]Name=DistrictNumber If subdistricts are configured ([Prefs]Value = '1' [CST_SubDistricts]Subdistrict_Number | Y |
studentReference | studentUniqueId | The student associated with the program. | String 32 | [Students]State_StudentNumber | Y |
programReference | Y | ||||
| educationOrganizationId | Integer | State Organization | Y | |
programName | The State-published program name. | String 60 | Y | ||
programTypeDescriptor | The program type descriptor "Dual Enrollment" | Descriptor | Y |
High Ability Program
This data view represents the High Ability program that a student participates in or is served by. The published view layout provides the Student Number, School ID, Program Type, Program Name, Entry Date, and End Date.
If a student is enrolled in multiple schools within the date range of his or her High Ability program record, a separate Student Programs record is published for each school, with start and end dates reflecting each school’s enrollment.
StudentProgramAssociations
Primary PowerSchool Source Data
[Students]
[ReEnrollments]
[S_VT_STU_High_Ability_C]
Selection Criteria
Records are published if the following criteria are met:
The student must not be excluded from state reporting.
The student’s school of enrollment must not be excluded from state reporting.
The studentUniqueID (Vermont Student Number) must be populated in PowerSchool ([Students]State_StudentNumber).
The student has an active High Ability status for the current year.
The High Ability start date is prior to the end of the school year (June 30th) and the end date is null or after the start of the school year (July 1st)
If the student's High Ability dates include enrollments at multiple schools, separate records are published for each school using enrollment entry and exit dates.
Resource Output
The studentProgramAssociation resource is dependent on the prior publishing of the following resources: students and programs.
LEAs and Schools may upload (publish) data to the Ed-Fi ODS in real-time or on-demand (“Run Now” button).
Click Export to export the data collection results to an Excel spreadsheet.
Data Element | Description | [Table]Data Type | Stored in [Table]Field | Required |
---|---|---|---|---|
educationOrganizationReference A reference to the related educationOrganization resource. | R | |||
/studentUniqueID | The student associated with the program. | String | [Students]State_StudentNumber | R |
beginDate | The month, day, and year the Student first received High Ability services. | Date | [S_VT_STU_HIGH_ABILITY_C]StartDate [ReEnrollments]entrydate, whichever is later | R |
endDate | The month, day, and year the student exited the program or stopped receiving High Ability services. Future dates are not published. | Date | [S_VT_STU_HIGH_ABILITY_C]enddate, [ReEnrollments]exitdate, whichever is earlier | N |
/educationOrganizationID | The education organization where the student is participating in or receiving the program services. | Integer | current enrollment schoolid (normally [Students]schoolid,[ReEnrollments]schoolid, or Access school override) | R |
programReference A reference to the related Program resource. | R | |||
/educationOrganizationId | The Education Organization associated with the program. | Integer | 1088000000 | R |
/programName | The name of the High Ability program. Valid values: 1 - General Intellectual 2 - High Ability Math 3 - High Ability Language Arts 4 - High Ability Other | String | [S_VT_STU_HIGH_ABILITY_C]HighAbility | R |
/programType | High Ability | String | High Ability | R |
additional fields for display only | ||||
/schoolname | The name of the school | String | [sch]school_name | |
/studentnumber | The student associated with the program. | Integer | [Students]student_number | |
/studentname | The student's name. | String | [Students]lastfirst | |
/gradelevel | Grade level of the most recent enrollment in the selected year. | Integer | [ReEnrollments]grade_level |
Virtual Education Student Programs
This data view represents the virtual education programs that a student participates in or is served by. The published view layout provides the Student Number, Program Type, Program Name, Entry Date, and End Date.
StudentProgramAssociations
Primary PowerSchool Source Data
[Students]
Selection Criteria
Records are published if the following criteria are met:
The student must not be excluded from state reporting.
The student’s school of enrollment must not be excluded from state reporting.
The studentUniqueID (Vermont Student Number) must be populated in PowerSchool ([Students]State_StudentNumber).
'Virtual Education' or 'Virtual Due to COVID-19' publish without error for students where the 'Virtual Student' flag is set to 'Y' or 'C', respectively.
Resource Output
The studentProgramAssociation resource is dependent on the prior publishing of the following resources: students and programs.
LEAs and Schools may upload (publish) data to the Ed-Fi ODS in real time or on-demand (“Run Now” button).
Click Export to export the data collection results to an Excel spreadsheet.
Data Element | Description | [Table]Data Type | Stored in [Table]Field | Required |
---|---|---|---|---|
educationOrganizationReference A reference to the related educationOrganization resource. | R | |||
/educationOrganizationID | The Education Organization associated with the program. | Integer | Derived from: [Prefs]Name=DistrictNumber If subdistricts are configured ([Prefs]Value = '1' where name = 'PSSR_SubDistrict'), then: [CST_SubDistricts]Subdistrict_Number | R |
programReference A reference to the related Program resource. | R | |||
/educationOrganizationId | The Education Organization associated with the program. | Integer | 1088000000 | R |
/type | ProgramType - The type of program. | String | Virtual Education | R |
/name | Program Name - Virtual Education Y = Virtual Education C = Virtual Due to COVID-19 | String | [S_STU_X]VirtualStudent | R |
studentReference A reference to the related students resource. | R | |||
/studentUniqueID | The student associated with the program. | String | [Students]State_StudentNumber | R |
beginDate | The month, day, and year on which the Student first received services. | Date | Populates the most recent date from: [Students]EntryDate or the first day of the school year | R |
endDate | The month, day, and year of the first day after the date of an individual's last attendance at a campus (if known), the day on which an individual graduated, or the date on which it becomes known officially that an individual left school. | Date | The last in-session date prior to [Students]ExitDate | R |
Section 504 Programs
This data view represents Section 504 programs that a student participates in or is served by. The published view layout provides the Student Number, School ID, Program Type, Program Name, Entry Date, and End Date.
If a student is enrolled in multiple schools within the date range of his or her Section 504 record, a separate Student Programs record is published for each school, with start and end dates reflecting each school’s enrollment.
StudentProgramAssociations
Primary PowerSchool Source Data
[Students]
[ReEnrollments]
[S_VT_STU_Section504_C]
Selection Criteria
Records are published if the following criteria are met:
The student must not be excluded from state reporting.
The student’s school of enrollment must not be excluded from state reporting.
The studentUniqueID (Vermont Student Number) must be populated in PowerSchool ([Students]State_StudentNumber).
The student has an active 504 status for the current year.
Resource Output
The studentProgramAssociation resource is dependent on the prior publishing of the following resources: students and programs.
LEAs and Schools may upload (publish) data to the Ed-Fi ODS in real time or on-demand (“Run Now” button).
Click Export to export the data collection results to an Excel spreadsheet.
Data Element | Description | [Table]Data Type | Stored in [Table]Field | Required |
---|---|---|---|---|
educationOrganizationReference A reference to the related educationOrganization resource. | R | |||
/studentUniqueID | The student associated with the program. | String | [Students]State_StudentNumber | R |
beginDate | The month, day, and year the Student first received 504 services. | Date | [S_STU_X_504]startdate, [ReEnrollments]entrydate, whichever is later | R |
endDate | The month, day, and year the student exited the program or stopped receiving 504 services. Future dates are not published. | Date | [S_STU_X_504]enddate, [ReEnrollments]exitdate, whichever is earlier | N |
/educationOrganizationID | The education organization where the student is participating in or receiving the program services. | Integer | Derived from: If subdistricts are configured ([Prefs]Value = '1' where name = 'PSSR_SubDistrict'), then: | R |
programReference A reference to the related Program resource. | R | |||
/educationOrganizationId | The Education Organization associated with the program. | Integer | 1088000000 | R |
/programName | Name of the 504 program. | String | Section 504 Placement | R |
/programType | Type of 504 program. | String | Section 504 Placement | R |
additional fields for display only | ||||
/schoolname | The name of the school | String | [sch]school_name | |
/studentnumber | The student associated with the program. | Integer | [Students]student_number | |
/studentname | The student's name. | String | [Students]lastfirst | |
/gradelevel | Grade level of the most recent enrollment in the selected year. | Integer | [ReEnrollments]grade_level |
Neglected Or Delinquent Program
studentNeglectedOrDelinquentProgramAssociations
Primary PowerSchool Source Data
[Students]
[ReEnrollments]
[S_SEN_X]NeglectedProgram
Selection Criteria
Records are published if the following criteria are met:
The student must not be excluded from state reporting.
The student’s school of enrollment must not be excluded from state reporting.
The studentUniqueID (Vermont Student Number) must be populated in PowerSchool ([Students]State_StudentNumber).
Resource Output
The studentProgramAssociation resource is dependent on the prior publishing of the following resources: students and programs.
LEAs and Schools may upload (publish) data to the Ed-Fi ODS in real time or on-demand (“Run Now” button).
Click Export to export the data collection results to an Excel spreadsheet.
Data Element | Description | [Table]Data Type | Stored in [Table]Field | Required |
---|---|---|---|---|
educationOrganizationReference A reference to the related educationOrganization resource. | R | |||
/studentUniqueID | The student associated with the program. | String | [Students]State_StudentNumber | R |
beginDate | The month, day, and year the Student first received Unaccompanied Youth services. | Date | [S_SEN_X_Neglected_Program]StartDate [ReEnrollments]entrydate, whichever is later | R |
endDate | The month, day, and year the student exited the program or stopped receiving Neglected Or Delinquent Program services. Future dates are not published. | Date | [S_SEN_X_Neglected_Program]enddate, [ReEnrollments]exitdate, whichever is earlier | N |
/educationOrganizationID | The education organization where the student is participating in or receiving the program services. | Integer | Derived from: If subdistricts are configured ([Prefs]Value = '1' where name = 'PSSR_SubDistrict'), then: | R |
programReference A reference to the related Program resource. | R | |||
/educationOrganizationId | The Education Organization associated with the program. | Integer | 1088000000 | R |
/programName | Neglected Or Delinquent Program. | String | Neglected Or Delinquent Program services. | R |
/programType | Neglected Or Delinquent Program . | String | Neglected Or Delinquent Program services. | R |
additional fields for display only | ||||
/schoolname | The name of the school | String | [sch]school_name | |
/studentnumber | The student associated with the program. | Integer | [Students]student_number | |
/studentname | The student's name. | String | [Students]lastfirst | |
/gradelevel | Grade level of the most recent enrollment in the selected year. | Integer | [ReEnrollments]grade_level |
Unaccompanied Youth Program
This data view represents the Unaccompanied Youth program that a student participates in or is served by. The published view layout provides the Student Number, School ID, Program Type, Program Name, Entry Date, and End Date.
If a student is enrolled in multiple schools within the date range of his or her Unaccompanied Youth program record, a separate Student Programs record is published for each school, with start and end dates reflecting each school’s enrollment.
StudentProgramAssociations
Primary PowerSchool Source Data
[Students]
[ReEnrollments]
[S_VT_STU_UNACCOMPANIED_YOUTH_C]
Selection Criteria
Records are published if the following criteria are met:
The student must not be excluded from state reporting.
The student’s school of enrollment must not be excluded from state reporting.
The studentUniqueID (Vermont Student Number) must be populated in PowerSchool ([Students]State_StudentNumber).
The student has an active Unaccompanied Youth status for the current year.
Resource Output
The studentProgramAssociation resource is dependent on the prior publishing of the following resources: students and programs.
LEAs and Schools may upload (publish) data to the Ed-Fi ODS in real time or on-demand (“Run Now” button).
Click Export to export the data collection results to an Excel spreadsheet.
Data Element | Description | [Table]Data Type | Stored in [Table]Field | Required |
---|---|---|---|---|
educationOrganizationReference A reference to the related educationOrganization resource. | R | |||
/studentUniqueID | The student associated with the program. | String | [Students]State_StudentNumber | R |
beginDate | The month, day, and year the Student first received Unaccompanied Youth services. | Date | [S_VT_STU_UNACCOMPANIED_YOUTH_C]StartDate [ReEnrollments]entrydate, whichever is later | R |
endDate | The month, day, and year the student exited the program or stopped receiving Unaccompanied Youth services. Future dates are not published. | Date | [S_VT_STU_UNACCOMPANIED_YOUTH_C]enddate, [ReEnrollments]exitdate, whichever is earlier | N |
/educationOrganizationID | The education organization where the student is participating in or receiving the program services. | Integer | Derived from: If subdistricts are configured ([Prefs]Value = '1' where name = 'PSSR_SubDistrict'), then: | R |
programReference A reference to the related Program resource. | R | |||
/educationOrganizationId | The Education Organization associated with the program. | Integer | 1088000000 | R |
/programName | Unaccompanied Youth | String | Unaccompanied Youth | R |
/programType | Unaccompanied Youth | String | Unaccompanied Youth | R |
additional fields for display only | ||||
/schoolname | The name of the school | String | [sch]school_name | |
/studentnumber | The student associated with the program. | Integer | [Students]student_number | |
/studentname | The student's name. | String | [Students]lastfirst | |
/gradelevel | Grade level of the most recent enrollment in the selected year. | Integer | [ReEnrollments]grade_level |
Foster Care Programs
This data view represents Fost Care programs that a student participates in or is served by. The published view layout provides the Student Number, School ID, Program Type, Program Name, Entry Date, and End Date.
If a student is enrolled in multiple schools within the date range of his or her Foster Care Program record, a separate Student Programs record is published for each school, with start and end dates reflecting each school’s enrollment.
StudentProgramAssociations
Primary PowerSchool Source Data
[Students]
[ReEnrollments]
[S_VT_STU_Foster_Care_C]
Selection Criteria
Records are published if the following criteria are met:
The student must not be excluded from state reporting.
The student’s school of enrollment must not be excluded from state reporting.
The studentUniqueID (Vermont Student Number) must be populated in PowerSchool ([Students]State_StudentNumber).
The student is in foster care in the current year.
Resource Output
The studentProgramAssociation resource is dependent on the prior publishing of the following resources: students and programs.
LEAs and Schools may upload (publish) data to the Ed-Fi ODS in real time or on-demand (“Run Now” button).
Click Export to export the data collection results to an Excel spreadsheet.
Data Element | Description | [Table]Data Type | Stored in [Table]Field | Required |
---|---|---|---|---|
educationOrganizationReference A reference to the related educationOrganization resource. | R | |||
/studentUniqueID | The student associated with the program. | String | [Students]State_StudentNumber | R |
beginDate | The month, day, and year the Student first received Foster Care program services. | Date | [S_VT_STU_Foster_Care_C]startdate [ReEnrollments]entrydate, whichever is later | R |
endDate | The month, day, and year the student exited the program or stopped receiving Foster Care program services. Future dates are not published. | Date | [S_VT_STU_Foster_Care_C]enddate [ReEnrollments]exitdate, whichever is earlier | N |
/educationOrganizationID | The education organization where the student is participating in or receiving the program services. | Integer | Current enrollment schoolid (normally [Students]schoolid,[ReEnrollments]schoolid, or Access school override) | R |
programReference A reference to the related Program resource. | R | |||
/educationOrganizationId | The Education Organization associated with the program. | Integer | 1088000000 | R |
/programName | Foster Care | String | Foster Care | R |
/programType | Foster Care | String | Foster Care | R |
additional fields for display only | ||||
/schoolname | The name of the school | String | [sch]school_name | |
/studentnumber | The student associated with the program. | Integer | [Students]student_number | |
/studentname | The student's name. | String | [Students]lastfirst | |
/gradelevel | Grade level of the most recent enrollment in the selected year. | Integer | [ReEnrollments]grade_level |
Student Migrant Education Programs
This view captures information about student Migrant Education program participation as published in the StudentMigrantEducationProgram Association resource within the Student Program category. The layout includes the School Name, Student Number, Student Name, Gender, and Grade Level, along with the Program, Entry Date, Exit Date, Reason Exited, Priority for Services, Last Qualifying Move Date, Ed-Fi Unique ID, Last Publish Date, and the Publishing ID.
studentMigrantEducationProgramAssociation
This association represents the Migrant Education program(s) in which a student participates or is served. The association is an extension of the StudentProgramAssociation for Migrant Education programs.
Primary PowerSchool Source Data
[SpEnrollments]
Note: Migrant Education Program data is separate from the studentClassification Migrant flag ('I') and requires a Migrant SpEnrollments record in the selected school year. This is a change from previous releases. Since PowerSchool now fully supports the Ed-Fi studentMigrantEducationProgramAssociation resource, abbreviated Migrant Education program data is no longer published in the general studentProgamAssociation resource. Setting the studentClassification Migrant flag alone will not generate a corresponding student program record as it previously did.
Selection Criteria
Records are published if the following criteria are met:
The student was published in the Student Parent category.
StudentUniqueId must be populated in PowerSchool.
The student must not be excluded from state reporting.
The programReference must refer to a program record previously downloaded in the Program resource in the Education Organization category.
The student has a Migrant SpEnrollments program record where the beginDate for the program association falls with the year for the Term selected in the PowerSchool UI.
Resource Output
A separate studentMigrantEducationProgramAsssociation record is published for each student and migrant program that meets the selection criteria.
The studentMigrantEducationProgramAssociation resource is dependent on the prior publishing of the following resources: student.
LEAs and Schools may upload (publish) data to the ODS in real time or on-demand ("Run Now" button).
Note: Click Export to export the data collection results to an Excel spreadsheet.
Data Element | Description | Data Type | Stored in [Table]Field | Req'd |
---|---|---|---|---|
studentReference/studentIdentity | The student associated with the program. | Integer | StudentUniqueId downloaded from State | M |
programReference/programIdentity | M | |||
/programType | The type of program. | Enumerated List | 'Migrant Education' | M |
/programName | The formal name of the program of instruction, training, services, or benefits available through federal, state, or local agencies. | Varchar(60) | 'Migrant Education' | M |
/educationOrganizationReference/ | The Education Organization associated with the program; reported as the LEAId. | Integer | LEAId - Data element downloaded from State | M |
beginDate | The month, day, and year on which the student first received services. | Date | [SPEnrollments]Enter_Date | M |
endDate | The month, day, and year on which the student exited the program or stopped receiving services. | Date | [SPEnrollments]Exit_Date | O |
reasonExited | The reason the child left the program within a school or district. *This element is required if the student exited the program. | Descriptor | Default = 'Unknown Reason' | C* |
educationOrganizationReference/ | The education organization where the student is participating in or receiving the program services; reported as the LEAId. | Integer | LEAId - Data element downloaded from State | M |
servedOutsideOfRegularSession | Indicates whether the student received services during the summer session or between sessions. | Boolean | O | |
priorityForServices | Report migratory children who are classified as having priority for services because they are failing, or most at risk of failing to meet the State's challenging State academic content standards and challenging State student academic achievement standards, and their education has been interrupted during the regular school year. | Boolean | R | |
lastQualifyingMove | Date the last qualifying move occurred; used to compute MEP status. | Date | R | |
continuationOfServicesReason | The "continuation of services" provision found in Section 1304(e) of the statute provides that (1) a child who ceases to be a migratory child during a school term shall be eligible for services until the end of such term; (2) a child who is no longer a migratory child may continue to receive services for one additional school year, but only if comparable services are not available through other programs; and (3) secondary school students who were eligible for services in secondary school may continue to be served through credit accrual programs until graduation. Only students who received services at any time during their 36-month eligibility period may continue to receive services (not necessarily the same service). | Descriptor | O | |
usInitialEntry | The month, day, and year on which the student first entered the US. | Date | O | |
usMostRecentEntry | The month, day, and year of the student's most recent entry into the US. | Date | O | |
usInitialSchoolEntry | The month, day, and year on which the student first entered a US School. | Date | O |
Homeless Program
This data view represents the Homeless program that a student participates in or is served by. The published view layout provides the Student Number, School ID, Program Type, Program Name, Entry Date, and End Date.
If a student is enrolled in multiple schools within the date range of his or her Homeless Program record, a separate Student Programs record is published for each school, with start and end dates reflecting each school’s enrollment.
studentHomelessProgramAssociations
Primary PowerSchool Source Data
[Students]
[ReEnrollments]
[S_VT_STU_Homeless_C]
Selection Criteria
Records are published if the following criteria are met:
The student must not be excluded from state reporting.
The student’s school of enrollment must not be excluded from state reporting.
The studentUniqueID (Vermont Student Number) must be populated in PowerSchool ([Students]State_StudentNumber).
The student is in the Homeless program for the current year.
The Homeless start date is prior to the end of the school year (June 30th) and the end date is null or after the start of the school year (July 1st).
If the student's Homeless dates include enrollments at multiple schools, separate records are published for each school using enrollment entry and exit dates.
Resource Output
The studentProgramAssociation resource is dependent on the prior publishing of the following resources: students and programs.
LEAs and Schools may upload (publish) data to the Ed-Fi ODS in real time or on-demand (“Run Now” button).
Click Export to export the data collection results to an Excel spreadsheet.
Data Element | Description | [Table]Data Type | Stored in [Table]Field | Required |
---|---|---|---|---|
educationOrganizationReference A reference to the related educationOrganization resource. | R | |||
/studentUniqueID | The student associated with the program. | String | [Students]State_StudentNumber | R |
beginDate | The month, day, and year the Student first received Foster Care program services. | Date | [S_VT_STU_HOMELESS_C]StartDate [ReEnrollments]entrydate, whichever is later | R |
endDate | The month, day, and year the student exited the program or stopped receiving Homeless program services. Future dates are not published. | Date | [S_VT_STU_HOMELESS_C]enddate [ReEnrollments]exitdate, whichever is earlier | N |
/educationOrganizationID | The education organization where the student is participating in or receiving the program services. | Integer | current enrollment schoolid (normally [Students]schoolid,[ReEnrollments]schoolid, or Access school override) | R |
programReference A reference to the related Program resource. | R | |||
/educationOrganizationId | The Education Organization associated with the program. | Integer | 1088000000 | R |
/programName | The Homeless program type. Valid values:
| String | [S_VT_STU_HOMELESS_C]PrimaryNighttimeResidence | R |
/programType | Homeless | String | Homeless | R |
additional fields for display only | ||||
/schoolname | The name of the school. | String | [sch]school_name | |
/studentnumber | The student associated with the program. | Integer | [Students]student_number | |
/studentname | The student's name. | String | [Students]lastfirst | |
/gradelevel | Grade level of the most recent enrollment in the selected year. | Integer | [ReEnrollments]grade_level |
Homebound Program
This data view represents the Homebound program that a student participates in or is served by. The published view layout provides the Student Number, School ID, Program Type, Program Name, Entry Date, and End Date.
If a student is enrolled in multiple schools within the date range of his or her Homebound record, a separate Student Programs record is published for each school, with start and end dates reflecting each school’s enrollment.
StudentProgramAssociations
Primary PowerSchool Source Data
[Students]
[ReEnrollments]
[S_VT_STU_Homebound_C]
Selection Criteria
Records are published if the following criteria are met:
The student must not be excluded from state reporting.
The student’s school of enrollment must not be excluded from state reporting.
The studentUniqueID (Vermont Student Number) must be populated in PowerSchool ([Students]State_StudentNumber).
The student's Homebound status is active for the current year.
The Homebound startdate is prior to the end of the school year (June 30th) and the end date null or after the start of the school year (July 1st).
If student's Homebound dates include enrollments at multiple schools, separate records are published for each school using enrollment entry and exit dates.
Resource Output
The studentProgramAssociation resource is dependent on the prior publishing of the following resources: students and programs.
LEAs and Schools may upload (publish) data to the Ed-Fi ODS in real time or on-demand (“Run Now” button).
Click Export to export the data collection results to an Excel spreadsheet.
Data Element | Description | [Table]Data Type | Stored in [Table]Field | Required |
---|---|---|---|---|
educationOrganizationReference A reference to the related educationOrganization resource. | R | |||
/studentUniqueID | The student associated with the program. | String | [Students]State_StudentNumber | R |
beginDate | The month, day, and year the Student first received Homebound program services. | Date | [S_VT_STU_Homebound_C]StartDate [ReEnrollments]entrydate, whichever is later | R |
endDate | The month, day, and year the student exited the program or stopped receiving Homebound program services. Future dates are not published. | Date | [S_VT_STU_Homebound_C]enddate [ReEnrollments]exitdate, whichever is earlier | N |
/educationOrganizationID | The education organization where the student is participating in or receiving the program services. | Integer | current enrollment schoolid (normally [Students]schoolid,[ReEnrollments]schoolid, or Access school override) | R |
programReference A reference to the related Program resource. | R | |||
/educationOrganizationId | The Education Organization associated with the program. | Integer | 1088000000 | R |
/programName | Homebound/Hospitalized | String | Homebound/Hospitalized | R |
/programType | Homebound | String | Homebound | R |
additional fields for display only | ||||
/schoolname | The name of the school. | String | [sch]school_name | |
/studentnumber | The student associated with the program. | Integer | [Students]student_number | |
/studentname | The student's name. | String | [Students]lastfirst | |
/gradelevel | Grade level of the most recent enrollment in the selected year. | Integer | [ReEnrollments]grade_level |
Parent in Military Programs
This data view represents Parent In Military programs that a student participates in or is served by. The published view layout provides the Student Number, School ID, Program Type, Program Name, Entry Date, and End Date.
If a student is enrolled in multiple schools within the date range of his or her Parent in Military Programs record, a separate Student Programs record is published for each school, with start and end dates reflecting each school’s enrollment.
StudentProgramAssociations
Primary PowerSchool Source Data
[Students]
[ReEnrollments]
[S_VT_STU_Active_Duty_C]
Selection Criteria
Records are published if the following criteria are met:
The student must not be excluded from state reporting.
The student’s school of enrollment must not be excluded from state reporting.
The studentUniqueID (Vermont Student Number) must be populated in PowerSchool ([Students]State_StudentNumber).
The student has a parent in the military for the current year.
Resource Output
The studentProgramAssociation resource is dependent on the prior publishing of the following resources: students and programs.
LEAs and Schools may upload (publish) data to the Ed-Fi ODS in real time or on-demand (“Run Now” button).
Click Export to export the data collection results to an Excel spreadsheet.
Data Element | Description | [Table]Data Type | Stored in [Table]Field | Required |
---|---|---|---|---|
educationOrganizationReference A reference to the related educationOrganization resource. | R | |||
/studentUniqueID | The student associated with the program. | String | [Students]State_StudentNumber | R |
beginDate | The month, day, and year the Student first received Parent in Military program services. | Date | [S_VT_STU_Active_Duty_C ]startdate [ReEnrollments]entrydate, whichever is later | R |
endDate | The month, day, and year the student exited the program or stopped receiving Parent in Military program services. Future dates are not published. | Date | [S_VT_STU_Active_Duty_C ]enddate, [ReEnrollments]exitdate, whichever is earlier | N |
/educationOrganizationID | The education organization where the student is participating in or receiving the program services. | Integer | current enrollment schoolid (normally [Students]schoolid,[ReEnrollments]schoolid, or Access school override) | R |
programReference A reference to the related Program resource. | R | |||
/educationOrganizationId | The Education Organization associated with the program. | Integer | 1088000000 | R |
/programName | Parent in Military | String | Parent in Military | R |
/programType | Parent in Military | String | Parent in Military | R |
additional fields for display only | ||||
/schoolname | The name of the school | String | [sch]school_name | |
/studentnumber | The student associated with the program. | Integer | [Students]student_number | |
/studentname | The student's name. | String | [Students]lastfirst | |
/gradelevel | Grade level of the most recent enrollment in the selected year. | Integer | [ReEnrollments]grade_level |
Student Special Ed Programs
This data view represents the special education program(s) that a student participates in or is served by. The published view layout provides the School Name, Student Number, Student Name, STN Number, Grade Level, Program Name, Entry Date, End Date, Reason Exited, Special Education Setting, Last Publish Date, Publishing ID, and Resource ID.
studentSpecialEducationProgramAssociations
Primary PowerSchool Source Data
[Students]
[ReEnrollments]
[S_VT_STU_SE_EVALUATION_C]
Selection Criteria
Records are published if the following criteria are met:
The student must not be excluded from state reporting.
The student’s school of enrollment must not be excluded from state reporting.
The studentUniqueID (Vermont Student Number) must be populated in PowerSchool ([Students]State_StudentNumber).
The student has a program record for Special Education program where the begin date falls with the year for the Term selected in the PowerSchool UI.
Resource Output
The studentSpecialEducationProgramAssociation resource is dependent on the prior publishing of the following resources: students, studentSchoolAssociations, and programs.
LEAs and Schools may upload (publish) data to the Ed-Fi ODS in real time or on-demand (“Run Now” button).
Click Export to export the data collection results to an Excel spreadsheet.
Data Element | Description | [Table]Data Type | Stored in [Table]Field | Required |
---|---|---|---|---|
educationOrganizationReference A reference to the related educationOrganization resource. | R | |||
/educationOrganizationID | The education organization where the student is participating in or receiving the program services. | Integer | If [S_VT_STU_X]Access_School and [S_IN_REN_X]Access_School are not blank and the Primary Enrollment flag is false then it is [S_VT_STU_X]Access_Schooll, otherwise, enrolled schoolId | |
studentReference A reference to the related students resource. | R | |||
/studentUniqueID | The student associated with the program. | String | [Students]State_StudentNumber | R |
beginDate | The month, day, and year on which the student first received services. | Date | [S_VT_STU_SE_EVALUATION_C]CaseConferenceDate, if populated, or [S_VT_STU_SE_EVALUATION_C]Referral_Date with program name, 'Undefined', if populated If neither of the above values is populated, the record does not publish. Instead, it will show with a dependency due to a missing begin date, unless student is Choice Voucher | R |
endDate | The month, day, and year on which the student exited the program or stopped receiving services | Date | [S_VT_STU_SE_EVALUATION_C]DateOfTermination Where [S_VT_STU_SE_EVALUATION_C]DateOfTermination is less than the earliest date from [ReEnrollments]EntryDate where [ReEnrollments]EntryDate fall between the first day and last day of term record for school, and [ReEnrollments]ExitDate is empty, or [ReEnrollments]EntryDate is less than [ReEnrollments]ExitDate and the first day of the term is less than [ReEnrollments]Exit Date. Or [S_VT_STU_SE_EVALUATION_C]DateOfTermination is earlier than [Students]EntryDate Or [S_VT_STU_SE_EVALUATION_C]DateOfTermination is earlier than [Terms]FirstDay And [S_VT_STU_SE_EVALUATION_C]ReasonForTermination has a value of 1, 3, 4, 5, 6, or 7 | O |
programReference A reference to the related programs resource. | ||||
/educationOrganizationID | The Education Organization associated with the program. | Integer | 1088000000 | R |
/name | The name of the Special Education program. | String | [S_VT_STU_SE_EVALUATION_C]SpecialEdPlacement | R |
/type | The type of program. | Type | Special Education | R |
reasonExitedDescriptor | The reason the child left the program within a school or district. Valid values:
This element is required if the student exited the program. | Descriptor | [S_VT_STU_SE_EVALUATION_C]ReasonForTermination Where [S_VT_STU_SE_EVALUATION_C]DateOfTermination is less than the earliest date from [ReEnrollments]EntryDate where [ReEnrollments]EntryDate fall between the first day and last day of term record for school, and [ReEnrollments]ExitDate is empty, or [ReEnrollments]EntryDate is less than [ReEnrollments]ExitDate and the first day of the term is less than [ReEnrollments]Exit Date. Or [S_VT_STU_SE_EVALUATION_C]DateOfTermination is less than [Students]EntryDate Or [S_VT_STU_SE_EVALUATION_C]DateOfTermination is less than [Terms]FirstDay And [S_VT_STU_SE_EVALUATION_C]ReasonForTermination has a value of 1, 3, 4, 5, 6, 7, or 7 | O |
ideaEligibility | The selection is based on the student's eligibility for Special Education. Valid values:
| Integer | [S_VT_STU_SE_EVALUATION_C ]StudentEligibility | IN |
iepReviewDate | The initial evaluation date. | Date | [S_VT_STU_SE_EVALUATION_C]CaseConferenceDate (for now) | IN |
lastEvaluationDate | The most recent evaluation date. | Date | [S_VT_STU_SE_EVALUATION_C]CaseConferenceDate (for now) | IN |
specialEducationSettingDescriptor | If the student receives special education services from the public school district but is located in a facility that is not considered a public school or charter school, choose the application location code. | [S_VT_STU_SE_EVALUATION_C ]SpecialEducationLocation If the code is 99, this field does not publish | IN | |
IN extensions | IN | |||
/disabilities | N | |||
/disabilityDescriptor | The exceptionality area that best describes student's exceptionality. | [S_VT_STU_SE_EVALUATION_C ]ExceptionalityPrimary [S_VT_STU_SE_EVALUATION_C ]ExceptionalitySecondary | C | |
/orderOfDisability | Primary or Secondary Exceptionality. Valid values:
| C | ||
/firstStepsTransitionDate | The date the special education services started for the student transitioning from First Step. This field is blank if the Circumstances Relevant to Timeline selection is '3 – Preparation for transfer from First Steps'. | [S_VT_STU_SE_EVALUATION_C ]ServicesBeginDate | ||
/parentalConsentDate | The date the parent provided written consent for the initial evaluation, the date the student transferred from another school during an evaluation, or the date that the student was referred to the school from First Steps. | [S_VT_STU_SE_EVALUATION_C ]ReferralDate | ||
/SpecialEducationEvaluationTimelineDescriptor | The circumstance that is relevant to the evaluation timeline. | [S_VT_STU_SE_EVALUATION_C ]TimelineCircumstances | ||
/TimelineComplianceDescriptor | The reason deadline was missed or services did not begin. | [S_VT_STU_SE_EVALUATION_C ]TimelineCompliance |
Title I Programs
This data view represents Parent In Military programs that a student participates in or is served by. The published view layout provides the Student Number, School ID, Program Type, Program Name, Entry Date, and End Date.
If a student is enrolled in multiple schools within the date range of his or her Parent in Military Programs record, a separate Student Programs record is published for each school, with start and end dates reflecting each school’s enrollment.
studentTitleIPartAProgramAssociations
Primary PowerSchool Source Data
[Students]
[ReEnrollments]
[S_VT_SCH_X]
[S_VT_STU_TITLE_C]
Selection Criteria
Records are published if the following criteria are met:
The student must not be excluded from state reporting and Ed-Fi publishing.
The student’s school of enrollment must not be excluded from state reporting.
The studentUniqueID (Vermont Student Number) must be populated in PowerSchool ([Students]State_StudentNumber).
The student's Title I program is active for the current year.
The Title I start date is prior to the end of the school year (June 30th) and the end date is null or after the start of the school year (July 1st).
The student must belong to a public school.
If student's Title dates include enrollments at multiple schools, separate records are published for each school using enrollment entry and exit dates.
If the Title I record was valid during all enrollments, the published records are identical except for the beginDate and schoolId
If the Title I beginDate is after the end of enrollment, it should not be published for that enrollment
If a Title I record has an end date, it is not published for enrollments starting after the end date
Resource Output
The studentProgramAssociation resource is dependent on the prior publishing of the following resources: students and programs.
LEAs and Schools may upload (publish) data to the Ed-Fi ODS in real time or on-demand (“Run Now” button).
Click Export to export the data collection results to an Excel spreadsheet.
Data Element | Description | [Table]Data Type | Stored in [Table]Field | Required |
---|---|---|---|---|
educationOrganizationReference A reference to the related educationOrganization resource. | R | |||
/studentUniqueID | The student associated with the program. | String | [Students]State_StudentNumber | R |
beginDate | The month, day, and year the Student first received Title I program services. | Date | [S_VT_STU_TITLE_C]startdate [ReEnrollments]entrydate, whichever is later | R |
endDate | The month, day, and year the student exited the program or stopped receiving Title I program services. Future dates are not published. | Date | [S_VT_STU_TITLE_C]enddate, [ReEnrollments]exitdate, whichever is earlier | N |
/educationOrganizationID | The education organization where the student is participating in or receiving the program services. | Integer | If [S_VT_STU_X]Access_School and [S_IN_REN_X]Access_School are not blank and the Primary Enrollment flag is false then it is [S_VT_STU_X]Access_Schooll, otherwise, enrolled schoolId | R |
programReference A reference to the related Program resource. | R | |||
/educationOrganizationId | The Education Organization associated with the program. | Integer | 1088000000 | R |
/programName | Name of the Title I program. | String | If [S_VT_SCH_X]TitleISchool = 0 or blank then derived from [S_VT_STU_TITLE_C][S_VT_STU_X]ESEA_Title_I_Program: If [S_VT_SCH_X]TitleISchool= 1 then derived from xtsch.Title_I_Program: | R |
/programType | Type of Title I program. | String | If [S_VT_SCH_X]IsTitleISchool = 0 or blank then derived from [S_VT_STU_TITLE_C]ESEA_Title_I_Program: - if 6 then Title I Part D Subpart 1&2 (need to use character code for '&') - if 1 then Title I Part A - if 3 then Title I Part A and Migrant Title I Part C If [S_VT_SCH_X]IsTitleISchool = 1 then derived from [S_VT_SCH_X]Title_I_Program: - if 1 then Title I Part A - if 3 then Title I Part A and Migrant Title I Part C | R |
reasonExitedDescriptor | The reason the student left the program within a school or district. This element is required if the student exited the program. Valid values:
| String | Publish End if Year (EOY) if the system date is on or after the end of school year term and [S_VT_STU_TITLE_C]EndDate is blank or [S_VT_STU_TITLE_C]EndDate is on or after the end of school year term. Publish '99' if [S_VT_STU_TITLE_C]EndDate is earlier than the end of school year term and [S_VT_STU_TITLE_C]EndDate is before the published enrollment date at school. | C |
titleIPartAParticipantType | Eligible | Y | Only 1 descriptor defined, if student is ineligible, does not have Title I program record | R |
services | ||||
/serviceDescriptor | The Title I service, Instructional, Support, and Extended Time. Valid values:
| Include all selections from [S_VT_STU_TITLE_C]Title_I_Instruction, [S_VT_STU_TITLE_C]Title_I_Support, [S_VT_STU_TITLE_C]Title_I_Extended_Time Title_I_Instruction: [S_VT_STU_X]Title_I_Instruction_Reading [S_VT_STU_X]Title_I_Instruction_Math [S_VT_STU_X]Title_I_Instruction_Science [S_VT_STU_X]Title_I_Instruction_Vocational [S_VT_STU_X]Title_I_Instruction_Social Title_I_Support: [S_VT_STU_X]Title_I_Support_Guidance [S_VT_STU_X]Title_I_Support_Health [S_VT_STU_X]Title_I_Support_Home TITLE_I_Extended_Time: [S_VT_STU_X]Title_I_Extended_Time_PreK [S_VT_STU_X]Title_I_Extended_Time_ExDayKindergarten [S_VT_STU_X]Title_I_Extended_Time_Before [S_VT_STU_X]Title_I_Extended_Time_After [S_VT_STU_X]Title_I_Extended_Time_Saturday [S_VT_STU_X]Title_I_Extended_Time_Summer [S_VT_STU_X]Title_I_Extended_Time_JumpStart [S_VT_STU_X]Title_I_Extended_Time_YearRound [S_VT_STU_X]Title_I_Extended_Time_Other | IDOE | |
additional fields for display only | ||||
/schoolname | The name of the school | String | [sch]school_name | |
/studentnumber | The student associated with the program. | Integer | [Students]student_number | |
/studentname | The student's name. | String | [Students]lastfirst | |
/gradelevel | Grade level of the most recent enrollment in the selected year. | Integer | [ReEnrollments]grade_level |
Alternative Education Programs
This data view represents Alternative Education programs that a student participates in or is served by. The published view layout provides the Student Number, School ID, Program Type, Program Name, Entry Date, and End Date.
If a student is enrolled in multiple schools within the date range of his or her Alternative Education Programs record, a separate Student Programs record is published for each school, with start and end dates reflecting each school’s enrollment. For each Alternative Education program record within PowerSchool with Begin Dates in the current school year, only one StudentAlternativeEducationProgramAssociation record is published.
studentAlternativeEducationProgramAssociations
Primary PowerSchool Source Data
[Students]
[ReEnrollments]
[S_VT_STU_ALTERNATIVE_EDU_C]
Selection Criteria
Records are published if the following criteria are met:
The student must not be excluded from state reporting.
The student’s school of enrollment must not be excluded from state reporting.
The studentUniqueID (Vermont Student Number) must be populated in PowerSchool ([Students]State_StudentNumber).
The student's Alternative Education program is active for the current year.
The Alternative Education start date is prior to the end of the school year (June 30th) and the end date is null or after the start of the school year (July 1st).
If student's Alternative Education dates include enrollments at multiple schools, separate records are published for each school using enrollment entry and exit dates.
If the Alternative Education record was valid during all enrollments, the published records are identical except for the begin date and schoolId.
If the Alternative Education beginDate is after the end of enrollment, it should not be published for that enrollment.
If the Alternative Education record has an end date after July 1st but before the start of the school year term, the record must be published with the schoolId of the the first enrollment (a no-show enrollment).
If a student is enrolled in an Alternative Program that is not valid for their school district then a dependency message appears while publishing, "Dependency on Unmatched Program LEAOrgID".
Resource Output
The studentProgramAssociation resource is dependent on the prior publishing of the following resources: students and programs.
LEAs and Schools may upload (publish) data to the Ed-Fi ODS in real-time or on-demand (“Run Now” button).
Click Export to export the data collection results to an Excel spreadsheet.
Data Element | Description | [Table]Data Type | Stored in [Table]Field | Required |
---|---|---|---|---|
educationOrganizationReference A reference to the related educationOrganization resource. | R | |||
/studentUniqueID | The student associated with the program. | String | [Students]State_StudentNumber | R |
beginDate | The month, day, and year the Student first received Alternative Education Program services. If the program’s begin date does not fall within the date range of the student’s enrollment record but is within the date of the school year, then the published begin date defaults to the student’s entry date. | Date | [S_VT_STU_ALTERNATIVE_EDU_C]StartDate [ReEnrollments]entrydate, whichever is later | R |
endDate | The month, day, and year the student exited the program or stopped receiving Parent in Military program services.
| Date | [S_VT_STU_ALTERNATIVE_EDU_C]enddate, [ReEnrollments]exitdate, whichever is earlier | C |
/educationOrganizationID | The education organization where the student is participating in or receiving the program services. | Integer | If [S_VT_STU_X]Access_School and [S_IN_REN_X]Access_School are not blank and the Primary Enrollment flag is false then it is [S_VT_STU_X]Access_Schooll, otherwise, enrolled schoolId | R |
programReference A reference to the related Program resource. | R | |||
/educationOrganizationId | The Education Organization associated with the program. | Integer | 1088000000 | R |
/programName | Alternative Education | String | Alternative Education | R |
/programType | Alternative Education | String | Alternative Education | R |
reasonExitedDescriptor | The reason the student left the program within a school or district. Valid values:
If a student exited the school prior to the end of the school year and the exit reason is null, then the exit reason defaults to 5 - Transferred/returned to other school setting prior to completing the program. | Descriptor | S_VT_STU_ALTERNATIVE_EDU_C]Exit_reason | C |
alternativeEducationEligibilityReasonDescriptor | The reason that makes the student eligible for Alternative Education. | [S_VT_STU_ALTERNATIVE_EDU_C]Eligibility_reason | IDOE | |
programMeetingTimes | ||||
/programMeetingTimeDescriptor | When the student attends the course. Valid values:
| [S_VT_STU_ALTERNATIVE_EDU_C]Program_time | IDOE | |
additional fields for display only | ||||
/schoolname | The name of the school | String | [sch]school_name | |
/studentnumber | The student associated with the program. | Integer | [Students]student_number | |
/studentname | The student's name. | String | [Students]lastfirst | |
/gradelevel | Grade level of the most recent enrollment in the selected year. | Integer | [ReEnrollments]grade_level |
Student CTE Programs
This view captures information about student participation in career and technical education programs as published in the StudentCTEProgramAssociation resource within the Student Program category. The layout includes the School Name, Student Number, Student Name, Gender, and Grade Level, along with the Program, Entry Date, Exit Date, Career Pathway, Ed-Fi Unique ID, Last Publish Date, and the Publishing ID.
studentCTEProgramAssociations
This association represents the career and technical education (CTE) program in which a student participates. The association is an extension of the studentProgramAssociation particular for CTE programs.
Primary PowerSchool Source Data
[SpEnrollments]
[Gen]
[S_VT_STU_CATE_X]
Selection Criteria
Records are published if the following criteria are met:
The student was published in the Student category.
StudentUniqueId must be populated in PowerSchool.
The student must not be excluded from state reporting.
The programReference must refer to a program record previously downloaded in the Program resource in the Education Organization category.
The student has an SpEnrollments CTE program record where the beginDate for the program association falls with the year for the Term selected in the PowerSchool UI.
Resource Output
A separate studentCTEProgramAssociation record is published for each student and CTE program that meets the selection criteria.
The studentCTEProgramAssociation resource is dependent on the prior publishing of the following resources: student.
LEAs and Schools may upload (publish) data to the ODS in real time or on-demand ("Run Now" button).
Note: Click Export to export the data collection results to an Excel spreadsheet.
Data Element | Description | Data Type | Stored in [Table]Field | Req'd |
---|---|---|---|---|
beginDate | The month, day, and year on which the student first received services. | Integer | [S_VT_STU_CATE_X]WHENCREATED | R |
educationOrganizationReference | ||||
educationOrganizationId | The education organization associated with the school or the district. | [s_vt_stu_cate_x]cate_remoteschcode, if null then | R | |
programReference | R | |||
/educationOrganizationId | The Education Organization associated with the program; reported as the LEAId. | Integer | LEAId - Data element downloaded from State | R |
/programName | The formal name of the program of instruction, training, services, or benefits available through federal, state, or local agencies. | Varchar(60) | Career and Technical Education | R |
/programTypeDescriptor | Career Technology Education | |||
studentReference | ||||
/studentUniqueId | A unique alphanumeric code assigned to a student. | [students]state_studentnumber | ||
technicalSkillAssessmentDescriptor | Description to indicate if the student passed or failed the assessment. | Cert_Passed = "Y" then TechnicalSkillsAssessmentDescriptor = "Passed", | ||
CTEProgramService | ||||
/CTEProgramServiceDescriptor | Description of the student's CTE program. | Boolean | if S_VT_STU_CATE_X.CATE_CompleterInd is Y then CTEProgramServiceDescriptor is CN1Y. | R |
/CIPCode | Number and description of the CIP Code associated with the student's CTE program. | Integer | [S_VT_STU_CATE_X]CIPCode [S_VT_STU_CATE_X]CIPCode2 |
Student Language Instruction Program
This view captures information about student participation in career and technical education programs as published in the StudentCTEProgramAssociation resource within the Student Program category. The layout includes the School Name, Student Number, Student Name, Gender, and Grade Level, along with the Program, Entry Date, Exit Date, Career Pathway, Ed-Fi Unique ID, Last Publish Date, and the Publishing ID.
studentLanguageInstructionProgramAssociations
This association represents the career and technical education (CTE) program in which a student participates. The association is an extension of the studentProgramAssociation particular for CTE programs.
Primary PowerSchool Source Data
[SpEnrollments]
[Gen]
[S_SEN_X]
Selection Criteria
Records are published if the following criteria are met:
The student was published in the Student category.
The student's English proficiency reported in [S_VT_STU_X]Engl_Prof must not be 8* or 9.
StudentUniqueId must be populated in PowerSchool.
The student must not be excluded from state reporting.
The programReference must refer to a program record previously downloaded in the Program resource in the Education Organization category.
The student has an SpEnrollments CTE program record where the beginDate for the program association falls with the year for the Term selected in the PowerSchool UI.
Resource Output
A separate studentCTEProgramAssociation record is published for each student and CTE program that meets the selection criteria.
The studentCTEProgramAssociation resource is dependent on the prior publishing of the following resources: student.
LEAs and Schools may upload (publish) data to the ODS in real time or on-demand ("Run Now" button).
Note: Click Export to export the data collection results to an Excel spreadsheet.
Data Element | Description | Data Type | Stored in [Table]Field | Req'd |
---|---|---|---|---|
beginDate | The month, day, and year on which the student first received services. | Integer | [S_VT_STU_CATE_X]Init_TestDate | R |
educationOrganizationReference | ||||
educationOrganizationId | State-assigned value for the education organization associated with the school or the district. | [Students]schoolid [Students]enrollment_schoolid | R | |
studentReference | ||||
/studentUniqueId | A unique alphanumeric code assigned to a student. | [Students]state_studentnumber | ||
englishLanguageProficiencyAssessments | ||||
schoolYearTypeReference | ||||
/schoolYear | The school year associated with the studentAcademicRecord. | [TERMS]yearid + 1991 | R | |
proficiencyDescriptor | Concatenated [S_VT_STU_X]Engl_Prof with [S_VT_STU_X]engProfDecimal and [S_VT_STU_X]Prof8_Status | |||
Monitored | ||||
/monitoredDescriptor | [S_VT_STU_X]Engl_Prof is(M1,M2,M3,M4) | |||
languageInstructionProgramServices | ||||
languageInstructionProgramServiceDescriptor | [S_VT_STU_ESOL_ X]ELLI01 - ELLI11 | |||
englishLearnerParticipation | An indication that an English Learner student is served by an English language instruction. Valid values:
| True if [S_VT_STU_X]Engl_Prof,1,1) not in (8,9); if [S_VT_STU_X]Waiver_Ind is 1 then this overrides the participation indicator | ||
programreference | ||||
/educationOrganizationId | State-assigned value for the Education Organization associated with the program. | Integer | [Students]schoolid [Students]enrollment_schoolid | R |
/programName | The formal name of the language instruction program - ESOL | Varchar(60) | ESOL | R |
/programTypeDescriptor | English to Speakers of Other Language | English to Speakers of Other Language | R |