Student Programs
This category represents the programs a student participates in or is served by, and includes the following data views and resources:
Student Programs
This view captures details about each program in which a student participates or receives services from as published in the StudentProgramAssociation resource within the Student Program category. The layout includes the School Name, PS Student Number, Student Name, Grade Level, Program Name, Entry Date, Exit Date, State Student Number, Last Publish Date, and Publishing ID.
studentProgramAssociations
This association represents the program(s) that a student participates in or is served by that are not reported in specific Student Program Associations (e.g. StudentSpecialEducationProgramAssociation). Program associations reported in this resource include:
- Limited English Proficiency
- Section 23a (Dropout Recovery)
Primary PowerSchool Source Data
- [S_MI_STU_GC_X]
- [Students]
- [ReEnrollments]
Selection Criteria
Records are published if the following criteria are met:
- The student was previously published in the Student Parent category.
- StudentUniqueId must be populated in PowerSchool.
- The student must not be excluded from state reporting.
- The school must not be excluded from state reporting.
- The student must be identified as Limited English Proficiency or claimed under Section 23a
- The ProgramReference must refer to a Program record previously published in the Program resource in the Education Organization category.
- The BeginDate for the program association falls within the year for the Term selected in the PowerSchool UI.
Resource Output
- A single record is published for each student and each enrollment period in each of the program associations included in the resource.
- For Section 23a, a separate record is published for each month claimed.
- The StudentProgramAssociation resource is dependent on the prior publishing of the following resources: Student.
- 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 | Data Type | Stored in [Table]Field | Req'd |
---|---|---|---|---|
educationOrganizationId | The Education Organization associated with the program; reported as the SchoolId. | Integer | [Students]SchoolId | R |
programReference | R | |||
/educationOrganizationId | The Education Organization associated with the program; reported as the LEAId. | Integer | LEAId | R |
/type | ProgramType - The type of program. | Type | Limited English Proficiency: | R |
/name | The formal name of the program of instruction, training, services, or benefits available through federal, state, or local agencies. | String | Limited English Proficiency: | 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 | Limited English Proficiency: | R |
endDate | The month, day, and year on which the student exited the program or stopped receiving services. | Date | LEP only
EndDate is not published for Section 23a.
| O |
reasonExited | ReasonExitedDescriptor - The reason the child left the program within a school or district. | Descriptor | LEP only | |
servicesDescriptor | Indicates the service being provided to the student by the program. | Descriptor | LEP only |
Student Special Ed Programs
This view captures student Special Education Program participation as published in the StudentSpecialEducationProgram Association resource within the Student Program category. The layout includes the School Name, PS Student Number, Student Name, Grade Level, Program Name, Begin Date, End Date, State Student Number, Last Publish Date, and Publishing 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 particularly for Special Education programs.
Primary PowerSchool Source Data
- [S_MI_STU_GC_X]
- [Students]
- [ReEnrollments]
Selection Criteria
Records are published if the following criteria are met:
- StudentUniqueId must be populated in PowerSchool.
- The student must not be excluded from state reporting.
- The school must not be excluded from state reporting.
- The student must be identified as a Special Education student
- The ProgramReference must refer to a Program record previously published in the Program resource in the Education Organization category.
- The BeginDate for the program association falls within the year for the Term selected in the PowerSchool UI.
Resource Output
- A separate record is published for each enrollment period the student was in Special Education.
- The StudentSpecialEducationProgramAssociation resource is dependent on the prior publishing of the following resources: Student and StudentSchoolAssocation.
- 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 | Data Type | Stored in [Table]Field | Req'd |
---|---|---|---|---|
educationOrganizationId | The education organization where the student is participating in or receiving the program services; reported as the SchoolId. | Integer | [Students]SchoolId | R |
programReference/programIdentity | R | |||
/type | ProgramType - The type of program. | Type | 'Special Education' | R |
/name | The formal name of the program of instruction, training, services, or benefits available through federal, state, or local agencies. | String | 'Special Education' | R |
/educationOrganizationId | The Education Organization associated with the Program; reported as the LEAId. | Integer | LEAId | 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 most current date from [S_MI_STU_GC_X]seIEPDate | R |
endDate | The month, day, and year on which the student exited the program or stopped receiving services. | Date | The earliest date from [S_MI_STU_GC_X]ExitDate Historical | O |
reasonExitedDescriptor | The reason the child left the program within a school or district. | Descriptor | [S_MI_STU_GC_X]ExitCode | O |
specialEducationSettingDescriptor | The major instructional setting (more than 50 percent of a student's special education program). | Descriptor | [S_MI_STU_GC_X]sePriSetting | O |
specialEducationHoursPerWeek | The number of hours per week for special education instruction and therapy. | Number | Calculated from: [S_MI_STU_GC_X]seHours x [S_MI_STU_GC_X]seMinutes / 60.0 | O |
schoolHoursPerWeek | Indicates the total number of hours of instructional time per week for the school that the student attends. | Number | [S_MI_STU_GC_X]seFTEHoursPerWeek | O |
iepDate | The effective date of the most recent IEP. | Date | [S_MI_STU_GC_X]seIEPDate | O |
multiplyDisabled | Indicates whether the student receiving special education and related services has been designated as multiply disabled by the admission, review, and dismissal committee as aligned with Federal requirements. | Boolean | Derived from: | O |
eligibilityEvaluation | O | |||
/dateOfParentalConsent | The date on which the entity received the signed Parental Consent to Evaluate form. It is the beginning of the timeline for completion of the initial IEP. | Date | [S_MI_STU_GC_X]seConsentDate | O |
/daysBeyondTimeline | The number of calendar days that the evaluation and completion of the initial IEP went beyond the 30 school-day timeline or agreed-upon written extension. | Integer | [S_MI_STU_GC_X]seInitialDays | O |
/initialIEPCompletionDate | The completion of an individualized education program (IEP) is the date on the notice of the offer of a free appropriate public education (FAPE). | Date | [S_MI_STU_GC_X]seFAPEDate | O |
/partCTransitionTimelinessDescriptor | The timeliness of the IEP by the student's third birthday for all students referred by Part C as potentially eligible for Part B. | Descriptor | [S_MI_STU_GC_X]seInitialTimePC | O |
/resultOfInitialIEPDescritor | The outcome of the initial IEP determining if the student is eligible or ineligible for special education programs and services. | Descriptor | [S_MI_STU_GC_X]seInitialResult | O |
/timelinessOfInitialIEPDescriptor | The timeliness status for the evaluation of eligibility. | Descriptor | [S_MI_STU_GC_X]seInitialTimely | O |
Service (0-many) | O | |||
/serviceDescriptor | Indicates the service being provided to the student by the program. | Descriptor | [S_MI_STU_GC_X]seService1 | |
ServiceProvider (0-many) | O | |||
/serviceProvider | The staff providing Special Education services to the student. | Integer | [S_MI_STU_GC_X]seTeacher | O |
Student Title I Part A Programs
This view captures information about student Title I program participation as published in the StudentTitleIPartAProgram Association resource within the Student Program category. The layout includes the School Name, PS Student Number, Student Name, Grade Level, Program Name, Title I Part A Participation Type, Entry Date, State Student Number, Last Publish Date, and Publishing ID.
studentTitleITASProgramAssociation
This association 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 particularly for Title I Part A programs.
Primary PowerSchool Source Data
- [S_MI_STU_GC_X]
- [Students]
- [ReEnrollments]
Selection Criteria
Records are published if the following criteria are met:
- StudentUniqueId must be populated in PowerSchool.
- The student must not be excluded from state reporting.
- The school must not be excluded from state reporting.
- The student is identified as receiving Title I services
- The ProgramReference must refer to a Program record previously published in the Program resource in the Education Organization category.
- The BeginDate for the program association falls within the year for the Term selected in the PowerSchool UI.
- The source data for the required TitleIPartAParticipant field is populated for the student.
Resource Output
- A separate record is published for each student and enrollment period, for each Title I instructional service received by the student
- Support services are included as part of each instructional service record
- If only support services are received, these are included on a record where instructional service = 'Other'
- The studentTitleITASProgramAssociation resource is dependent on the prior publishing of the following resources: Student and StudentSchoolAssociation.
- 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 | Data Type | Stored in [Table]Field | Req'd |
---|---|---|---|---|
educationOrganizationId | The education organization where the student is participating in or receiving the program services; reported as the SchoolId. | Integer | [Students]SchoolId | R |
programReference/programIdentity | R | |||
/type | ProgramType - The type of program. | Type | 'Title I Part A' | R |
/name | The formal name of the program of instruction, training, services, or benefits available through federal, state, or local agencies. | String | If [S_MI_STU_GC_X]FlagTitle1 = 1 and
| R |
/educationOrganizationId | The Education Organization associated with the Program; reported as the LEAId. | Integer | LEAId | R |
studentUniqueId | The student associated with the program. | Integer | [Students]State_StudentNumber | R |
beginDate | The month, day, and year on which the student first received services. | Date | [Students]EntryDate | R |
endDate | The month, day, and year on which the student exited the program or stopped receiving services. | Date | [Students]ExitDate | O |
titleIPartAParticipantType | An indication of the type of Title I program, if any, in which the student is participating and served: Public Targeted Assistance Program, Public Schoolwide Program, Private school student participating, Local Neglected Program. | Type | 'Public Targeted Assistance Program' | O |
service (0-many) | O | |||
/serviceDescriptor | Indicates the service being provided to the student by the program. | Descriptor | If
| O |
Student Early Learning Programs
This view captures information about student early learning program participation as published in the StudentEarlyLearningProgramAssociation resource within the Student Program category. The layout includes the School Name, PS Student Number, Student Name, Grade Level, Program Name, Program Type, Begin Date, End Date, State Student Number, Last Publish Date, and Publishing ID.
studentEarlyLearningProgramAssociations
This association includes two programs: Early On (ages 0-3) and Early Childhood (ages 3-5)
Primary PowerSchool Source Data
- [S_MI_STU_GC_X]
- [Students]
- [ReEnrollments]
Selection Criteria
Records are published if the following criteria are met:
- StudentUniqueId must be populated in PowerSchool.
- The student must not be excluded from state reporting.
- The school must not be excluded from state reporting.
- The student is identified as an Early Learning student (Early On or Early Childhood)
- The ProgramReference must refer to a Program record previously published in the Program resource in the Education Organization category.
- The BeginDate for the program association falls within the enrollment period.
Resource Output
- A separate record is published for each enrollment period the student was in Early On and for each program type in Early Childhood.
- The StudentEarlyLearningProgramAssociation resource is dependent on the prior publishing of the following resources: Student and StudentSchoolAssociation.
- 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 | Data Type | Stored in [Table]Field | Req'd |
---|---|---|---|---|
educationOrganizationId | The education organization where the student is participating in or receiving the program services; reported as the SchoolId. | Integer | [Students]SchoolId | R |
programReference/programIdentity | R | |||
/type | ProgramType - The type of program. | Type | Early On (Age 0-3)
| R |
/name | The formal name of the program of instruction, training, services, or benefits available through federal, state, or local agencies. | String | Early On (Age 0-3)
| R |
/educationOrganizationId | The Education Organization associated with the Program; reported as the LEAId. | Integer | LEAId | 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 | Early On (Age 0-3) | R |
endDate | The month, day, and year on which the Student exited the Program or stopped receiving services. | Date | Early On (Age 0-3) | O |
reasonExitedDescriptor | The reason the student exited a program. | Descriptor | Early Childhood only | O |
deliveryScheduleDescriptor | The weekly schedule that is followed by the student for the reported program or service. | Descriptor | Early Childhood only | O |
deliveryMethodDescriptor | The primary location where the student attends the reported program or receives services. | Descriptor | Early Childhood only | O |
individualizedFamilyServicePlan (Early On) | O | |||
/currentIFSPDate | The date of the students' most recent individualized family service plan (IFSP). | Date | [S_MI_STU_GC_X]eoIFSPDate | O |
/initialIFSPDate | The date of the students' first individualized family service plan (IFSP). | Date | [S_MI_STU_GC_X]eoInitialIFSPDate | O |
/ifspTimelinessDescriptor | The selected timeliness descriptor for the individualized family service plan (IFSP). | Descriptor | [S_MI_STU_GC_X]eoInitialTimely | |
/initialIEPCompletionDate | The completion of an initial individualized education program (IEP) is the date on the notice of the offer of a free appropriate public education (FAPE). | Date | [S_MI_STU_GC_X]seFAPEDate | O |
/referralDate | The date the student was referred by the referral agency. | Date | [S_MI_STU_GC_X]eoInitialReferDate | O |
/referralAgencyDescriptor | The type of agency that notified the responsible agency that student may potentially be eligible for Part C services. | Descriptor | [S_MI_STU_GC_X]eoInitialReferral | O |
/resultOfInitialIFSPDescriptor | The outcome of the initial IEP determining if the student is eligible or ineligible for special education programs and services. | Descriptor | [S_MI_STU_GC_X]eoInitialResult | O |
/timelinessDescriptor | The description of the time appropriateness. | Descriptor | [S_MI_STU_GC_X]eoInitialTimely | O |
/transitionConferenceTimelinessDescriptor | The description of the time appropriateness for the transition conference. | Descriptor | [S_MI_STU_GC_X]eoTransIFSP | O |
earlyLearningProgramServices (Early On) | O | |||
/serviceDesciptor | The services provided by an education organization to populations of students associated with a program. | Descriptor | [S_MI_STU_GC_X]eoService1 | O |
/primaryIndicator | Indication if the service is the primary program service. | Boolean | If [S_MI_STU_GC_X]eoService1 = 1 then 'true' | O |
/serviceCoordAgencyDescriptor | The type of agency that is providing service coordination for the student. | Descriptor | [S_MI_STU_GC_X]eoAgency | O |
/settingDescriptor | The environment where the student receives services or attends a reported program. | Descriptor | [S_MI_STU_GC_X]eoSetting | O |
/timelyStartOfServiceDescriptor | The service start status for the services a student receives. | Descriptor | [S_MI_STU_GC_X]eoTimely | O |
earlyChildhoodProgram | ||||
/ecComment | Enter comments about the Early Childhood program. | String | [S_MI_STU_GC_X]ecComment1,ecComment2,ecComment3,ecComment4,ecComment5 | |
/ecPrograms | ||||
/ecProgramDescriptor | The type of Early Childhood program | Descriptor | [S_MI_STU_GC_X]ecProgram1,ecProgram2,ecProgram3,ecProgram4,ecProgram5 | |
/beginDate | Start date of the the Early Childhood program. | Date | [S_MI_STU_GC_X]ecStartDate1,ecStartDate2,ecStartDate3,ecStartDate4,ecStartDate5 | |
/additionalEligibilityFactor | ||||
/additionalEligibilityFactorDescriptor | The additional eligibility factors for the Early Childhood program. | Descriptor | [S_MI_STU_GC_X]ECADDELIGIBILITYFACTOR1,ECADDELIGIBILITYFACTOR2,ECADDELIGIBILITYFACTOR3,ECADDELIGIBILITYFACTOR4,ECADDELIGIBILITYFACTOR5 | |
/qualifyingFactors | ||||
/qualifyingFactorDescriptor | The factors that qualified the child for the Early Childhood program | Descriptor | [S_MI_STU_GC_X]ECQUALIFYINGFACTOR1, ECQUALIFYINGFACTOR2, ECQUALIFYINGFACTOR3, ECQUALIFYINGFACTOR4, ECQUALIFYINGFACTOR5 |
Student Adult Education Programs
This view captures information about student adult education program participation as published in the StudentAdultEducationProgramAssociation resource within the Student Program category. The layout includes the School Name, PS Student Number, Student Name, Grade Level, Program, Entry Date, Exit Date, Reason Exited, Priority for Services, Last Qualifying Move Date, Ed-Fi Unique ID, Last Publish Date, and Publishing ID.
studentAdultEducationProgramAssociations
This association represents the Adult Education program(s) that an adult student participates in or receives services from. The association is an extension of the StudentProgramAssociation particularly for Adult Education programs.
Primary PowerSchool Source Data
- [S_MI_STU_GC_X]
- [Students]
- [ReEnrollments]
Selection Criteria
Records are published if the following criteria are met:
- StudentUniqueId must be populated in PowerSchool.
- The student must not be excluded from state reporting.
- The school must not be excluded from state reporting.
- The student is identified as an Adult Education student
- The ProgramReference must refer to a Program record previously published in the Program resource in the Education Organization category.
- The BeginDate for the program association falls within the year for the Term selected in the PowerSchool UI.
Resource Output
- A single record is published for each student and each program and reporting period included in the resource.
- The StudentTitleIPartAProgramAssociation resource is dependent on the prior publishing of the following resources: Student and StudentSchoolAssociation.
- 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 | Data Type | Stored in [Table]Field | Req'd |
---|---|---|---|---|
educationOrganizationId | The education organization where the student is participating in or receiving the program services; reported as the SchoolId. | Integer | [Students]SchoolId | R |
programReference/programIdentity | R | |||
/type | ProgramType - The type of program. | Type | 'Adult/Continuing Education' | R |
/name | The formal name of the program of instruction, training, services, or benefits available through federal, state, or local agencies. | String | If [S_MI_STU_GC_X]flagAdultEd = 1 and
| R |
/educationOrganizationId | The Education Organization associated with the Program; reported as the LEAId. | Integer | LEAId | 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 most recent date of the reporting period. | R |
adultEdCountPeriodDescriptor | The adult education reporting period during which the student participated. | Descriptor | Derived from: | O |
adultEdCountPeriodYear | The year of the adult education reporting period during which the student participated. | Integer | Derived from: | O |
enrollmentPercent | The full-time equivalency (FTE) that the participant spends in the program reported. | Number | [S_MI_STU_GC_X]aeFTEJul1, aeFTEJul2, aeFTEJul3, aeFTEJul4, aeFTESep1, aeFTESep2, aeFTESep3. aeFTESep4, aeFTEFeb1, aeFTEFeb2, aeFTEFeb3, aeFTEFeb4, aeFTEApr1, aeFTEApr2, aeFTEApr3, or aeFTEApr4 | O |
eligibilityExceptionDescriptor | The program eligibility of the participants. | Descriptor | [S_MI_STU_GC_X]aeExcepJul1, aeExcepJul2, aeExcepJul3, aeExcepJul4, aeExcepSep1, aeExcepSep2, aeExcepSep3. aeExcepSep4, aeExcepFeb1, aeExcepFeb2, aeExcepFeb3, aeExcepFeb4, aeExcepApr1, aeExcepApr2, aeExcepApr3, or aeExcepApr4 | O |