equity_StudentSchoolFoodServiceProgramDim

Purpose

Used to look up a student's participation in food service programs.

SQL Object Name

analytics.equity_StudentSchoolFoodServiceProgramDim

Data Definition and Sources

Column

Data Type

Source

Description

StudentSchoolFoodServiceProgramKeynvarchar​StudentSchoolFoodServiceProgramAssociationThe unique key that describes the Student, school, and food service program they are using.
StudentSchoolProgramKeynvarcharStudentSchoolFoodServiceProgramAssociationThe key describing the food service program in use
StudentSchoolKeynvarcharStudentSchoolFoodServiceProgramAssociationThe key describing the student school association
ProgramNamenvarcharStudentSchoolFoodServiceProgramAssociationThe name of the food service program the student is participating in
SchoolFoodServiceProgramServiceDescriptornvarcharStudentSchoolFoodServiceProgramAssociationThe description of service the food program service
LastModifiedDatedatetimeStudentSchoolFoodServiceProgramAssociationThe last date the event was modified