Student Programs
This category captures student associations and data related to programs and includes the following data views and resources:
Student Programs
This data view represents a detailed list of Student Program associations successfully published to the ODS. This association represents the program(s) that a student participates in or is served by. Records are published if the following criteria are met: The student's unique identification code (UIC) is populated in PowerSchool, the student was published in the preceding student demographic interchange and the student must not be excluded from state reporting. . The published view layout provides the School Name, Student Number, Student Name, WISER ID, Grade Level, Program Type, Program Name, Entry Date, End Date, Last Publish Date, Publishing ID, and Resource ID.
studentProgramAssociation
This association represents the program(s) that a student participates in or is served by.
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 student's unique identification code (UIC) is populated in PowerSchool.
Resource Output
- The StudentProgramAssociation resource is dependent on the prior publishing of the following resources: Student 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 | [Table]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 | [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 Student 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 |
| endDate | The month, day, and year on which the Student exited the Program or stopped receiving services. | Date | O | |
Student Special Ed Programs
This data view represents a detailed list of Student Special Education Program associations successfully published to the ODS. This represents the special education program(s) that a student participates in or is served by. Records are published if the following criteria are met: The student's unique identification code (UIC) is populated in PowerSchool, the student was published in the preceding student demographic interchange, the student must not be excluded from state reporting, and 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.The published view layout provides the School Name, Student Number, Student Name, WISER ID, Grade Level, Program Name, Entry Date, End Date, Special Education Setting, Last Publish Date, Publishing ID, and Resource ID.
studentSpecialEducationProgramAssociations
This association represents the special education program(s) that a student participates in or receives services from. The association is an extension of the StudentProgramAssociation particular for special education programs.
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 student's unique identification code (UIC) is populated in PowerSchool.
- 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: Student, 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 | [Table]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: | R |
programReference A reference to the related Program resource. | R | |||
/educationOrganizationId | The Education Organization associated with the Program. | Integer | Derived from: | R |
/type | The type of program. | Type | [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 Student 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 | 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. Otherwise: [Students]EntryDate, if populated. Otherwise: [Terms]FirstDay | R |
| endDate | The month, day, and year on which the student exited the program or stopped receiving services | Date | [S_IN_STU_X]Date_Of_Termination Where [S_IN_STU_X]Date_Of_Termination 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_IN_STU_X]Date_Of_Termination is less than [Students]EntryDate Or [S_IN_STU_X]Date_Of_Termination is less than [Terms]FirstDay And [S_IN_STU_X]Reason_Termination has a value of 1, 3, 4, 5, 6, 7, or 7 | O |
| ideaEligibility | Indicator of the eligibility of the student to receive special education services according to the Individuals with Disabilities Education Act (IDEA). | Boolean | O | |
| specialEducationSettingDescriptor | String | O | ||
studentProgramAssociationService Indicates the services being provided to the student by the program. | O | |||
/serviceDescriptor | String | R | ||