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 EducationSpecial EducationSpecial Education - Choice VoucherSection 504
High Ability ProgramHomeless
HomeboundParent in MilitaryUnaccompanied YouthTitle I
Alternative EducationRefugee 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).
Note: Dual Enrollment Programs for students tagged on the Re-enrollment page are now published at the school level under this resource. This resolves the issue of districts not able to publish in a previous term post rollover.
Resource Output
The studentProgramAssociation resource is dependent on the prior publishing of the following resources: students and programs (which is part of Organization Info).
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. Note: If an override is selected on the Student Enrollment page, the education organization ID will reflect the overridden school. | Integer | Derived from: [Prefs]Name=DistrictNumber If subdistricts are configured ([Prefs]Value = '1' [CST_SubDistricts]Subdistrict_Number | R |
/programTypeDescriptor | ProgramType - The type of program. | String | [CST_PubProgram]Type | R |
/programName | The formal name of the program of instruction, training, services, or benefits available through federal, state, or local agencies. If the Educational Support Services (ACT 117) checkbox is selected as "Yes" on the current enrollment page, the programName and programTypeDescriptor are published as Educational Support Team Services and EST respectively. Note: The same behavior is applicable for previous enrollment. | 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 (Vermont Student 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.
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 | |
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 | |
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 | |
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 | |