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, State Identifier, Grade Level, Program Name, Entry Date, End Date, Last Publish Date, Publishing ID, and Resource ID.
studentProgramAssociation
Primary PowerSchool Source Data
- Gen
- Students
- SpEnrollments
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 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).
Note: Click Export to export the data collection results to an Excel spreadsheet.
Data Element | Description | Data Type | Stored in Table.Field | Req’d |
|---|---|---|---|---|
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' where name = 'PSSR_SubDistrict'), then: CST_SubDistricts.Subdistrict_Number | R |
/type | ProgramType - The type of program. | String | Gen.DCID | R |
/name | The formal name of the program of instruction, training, services, or benefits available through federal, state, or local agencies. | String | Gen.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 | SpEnrollments.Enter_Date | R |
| endDate | The month, day, and year on which the Student exited the Program or stopped receiving services. | Date | When SpEnrollments.Exit_Date is greater than '1900-01-01' then: max(Calendar_Day.Date_Value) Where Calendar_Day.SchoolId = Prefs.SchoolId and Calendar_Day.InSession = 1 and Calendar_Day.Date_Value is less than spEnrollments.Exit_Date and Calendar_Day.Date_Value falls between the first day and last day of term record for school | R |
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, State Identifier, Grade Level, Program Name, Entry Date, End Date, Last Publish Date, Publishing ID, and Resource ID.
studentSpecialEducationProgramAssociations
Primary PowerSchool Source Data
- Gen
- SpEnrollments
- Students
- S_SEN_EdFi_X
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 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).
Note: Click Export to export the data collection results to an Excel spreadsheet.
Data Element | Description | Data Type | Stored in Table.Field | Req’d |
|---|---|---|---|---|
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 | Derived from: If subdistricts are configured (Prefs.Value = '1' where name = 'PSSR_SubDistrict'), then: CST_SubDistricts.Subdistrict_Number | R |
programReference A reference to the related programs resource. | R | |||
/educationOrganizationID | The Education Organization associated with the program. | Integer | Derived from: If subdistricts are configured (Prefs.Value = '1' where name = 'PSSR_SubDistrict'), then: CST_SubDistricts.Subdistrict_Number | R |
/type | The type of program. | String | Gen.DCID | R |
/name | The formal name of the program of instruction, training, services, or benefits available through federal, state, or local agencies. | String | Gen.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 | SpEnrollments.Enter_Date | R |
| endDate | The month, day, and year on which the student exited the program or stopped receiving services | Date | When SpEnrollments.Exit_Date is greater than '1900-01-01' then: max(Calendar_Day.Date_Value) Where Calendar_Day.SchoolId = Prefs.SchoolId and Calendar_Day.InSession = 1 and Calendar_Day.Date_Value is less than spEnrollments.Exit_Date and Calendar_Day.Date_Value falls between the first day and last day of term record for school | O |
| ideaEligibility | The reason the child left the program within a school or district. This element is required if the student exited the program. | Boolean | S_SEN_EdFi_X .IdeaEligibility | O |
| specialEducationSettingDescriptor | The major instructional setting (more than 50 percent of a student's special education program). | Descriptor | S_SEN_EdFi_X .SpecialEducationSetting | O |
Student Title I Part A Programs
This data view represents the Title I Part A program(s) that a student participates in or from which the student receives services. The association is an extension of the StudentProgramAssociation particular for Title I Part A programs. The published view layout provides the School Name, Student Number, Student Name, State Identifier, Grade Level, Program Name, Title I Part A Participation Type, Entry Date, End Date, Last Publish Date, Publishing ID, and Resource ID.
studentTitleIPartAProgramAssociations
Primary PowerSchool Source Data
- Gen
- Students
- SpEnrollments
- S_SEN_EdFi_X
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 must be populated in PowerSchool (Students.State_StudentNumber).
- The student has a program record for Title I Part A program where the begin date falls with the year for the Term selected in the PowerSchool UI.
Resource Output
- The studentTitleIPartAProgramAssociation 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).
Note: Click Export to export the data collection results to an Excel spreadsheet.
Data Element | Description | Data Type | Stored in Table.Field | Req’d |
|---|---|---|---|---|
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 | Derived from: Prefs.Name=DistrictNumber Prefs.Value If subdistricts are configured (Prefs.Value = '1' where name = 'PSSR_SubDistrict'), then: CST_SubDistricts.Subdistrict_Number | R |
programReference A reference to the related programs resource. | R | |||
/educationOrganizationID | The Education Organization associated with the program. | Integer | Derived from: Prefs.Name=DistrictNumber Prefs.Value If subdistricts are configured (Prefs.Value = '1' where name = 'PSSR_SubDistrict'), then: CST_SubDistricts.Subdistrict_Number | R |
/type | The type of program. | Type | Gen.DCID | R |
/name | The formal name of the program of instruction, training, services, or benefits available through federal, state, or local agencies. | String | Gen.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 | SpEnrollments.Enter_Date | R |
| endDate | The month, day, and year on which the student exited the program or stopped receiving services | Date | When SpEnrollments.Exit_Date is greater than '1900-01-01' then: max(Calendar_Day.Date_Value) Where Calendar_Day.SchoolId = Prefs.SchoolId and Calendar_Day.InSession = 1 and Calendar_Day.Date_Value is less than spEnrollments.Exit_Date and Calendar_Day.Date_Value falls between the first day and last day of term record for school | O |
| titleIPartAParticipantType | An indication of the type of Title I program, if any, in which the student is participating and by which the student is served: Public Targeted, Assistance Program, Public Schoolwide Program, Private School Students Participating, Local Neglected Program. | String | S_SEN_EdFi_X .TitleIParticipantType, if populated Otherwise: Published Value = 'Public Targeted Assistance Program'
| R |