Food Service
This view captures details about a student's food service program eligibility and participation and is published from the Student Program dashboard category. The layout includes the School Number, Program Name, Entry Date, Exit Date, State Student Number, Last Publish Date, and Publishing ID.
studentSchoolFoodServiceProgramAssociations
This association represents the food service program(s) that a student participates in.
Primary PowerSchool Source Data
[Students]
[ReEnrollments]
[S_NM_STU_X]
Selection Criteria
Records are published if the following criteria are met:
The student was previously published in the Student & Student Enrollments dashboard 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 not be a "No-Show" student.
studentSchoolFoodServiceProgramAssociations
All students will publish one of the following three record types:
F - Free
R - Reduced
Not Participating
Data Element | Description | Data Type | Stored in [Table]Field | Req'd | ||
|---|---|---|---|---|---|---|
educationOrganizationReference | ||||||
educationOrganizationId | The school associated with this student. This is an eight-digit number comprising of: 35+[LEA Number - 3 digit]+[School Number - 3 digit] | String | LEA Number - [Prefs]Value [Prefs]Name where = districtnumber School Number - [Schools]Alternate_School_Number if the value greater is than zero else the [Schools]School_Number | R | ||
programReference | ||||||
/educationOrganizationId |
| String |
| R | ||
/programName | Student School Food Service | String | Always Student School Food Service | R | ||
/programTypeDescriptor | Student School Food Service | String | Always Student School Food Service | R | ||
studentReference | ||||||
/studentUniqueId | A unique alphanumeric code assigned to a student. | String | [Students]state_studentnumber | R | ||
/beginDate | The month, day, and year on which the student first received services. | Datetime | [Students]EntryDate [ReEnrollments]EntryDate | R | ||
/endDate | The month, day, and year on which the student stopped receiving services. | Datetime | [Students]ExitDate [ReEnrollments]ExitDate | R | ||
ParticipationStatus | ||||||
/participationStatusDescriptor | The student's program participation eligibility status. Participation Status Descriptor Set | [Students]LunchStatus | R | |||
/statusBeginDate | The date the student's program participation status began. | Datetime | [Students]EntryDate [ReEnrollments]EntryDate | R | ||
/statusEndDate | The date the student's program participation status ended. | Datetime | [Students]ExitDate [ReEnrollments]ExitDate | R | ||
schoolFoodServiceProgramService | ||||||
/schoolFoodServiceProgramServiceDescriptor | Indicates the service being provided to the student by the School Food Service Program. School Food Service Program Service Descriptor Set | String | [S_NM_SCH_X]CEP_School [Students]LunchStatus | R | ||
/serviceBeginDate | First date the Student was in this option for the current school year. | Datetime | [Students]EntryDate [ReEnrollments]EntryDate | R | ||
/serviceEndDate | Last date the Student was in this option for the current school year. | Datetime | [Students]ExitDate [ReEnrollments]ExitDate | R | ||
nmped_extension | ||||||
/directCertificationStatusDescriptor | Identifies the Direct Certification Status of a student. Direct Certification Status Descriptor Set The publishing of this resource is updated so that this element (directCertificationStatusDescriptor) is always present. If a student's Economic Disadvantage Status Code value is blank, then this element is published as blank and if it has a valid value, then a valid descriptor is published. | String | [S_NM_STU_X]EconomicDisAdvCode | R | ||