Tool Search: Filter Designer

The Ad Hoc Reporting tools allow users to create custom queries and reports on various types of information stored within the Campus database. Reports may be used for data analysis and state reporting and queries may be exported out of Campus or used to create filters for standard reports. Custom filters and reports are built by adding elements from Ad Hoc Reporting tools like the Filter Designer. The following is a list of available fields that can be included in Ad Hoc reports that draw from Campus FRAM eligibility data.

The name of an Ad Hoc element is not necessarily the name listed in the user interface; therefore, the following tables briefly define and map Ad hoc elements to the appropriate interface locations/fields.

Student > FRAM > Eligibility

*Eligibility*	*Student > FRAM > Eligibility*
eligibilityID	Internal database identifier.
eligibility	Eligibility > Eligibility Detail > Eligibility Student's meal status eligibility.
personID	Internal database identifier.
endYear	Eligibility > Eligibility Detail Last school year to which eligibility applies.
type	Eligibility > Eligibility Detail > Certified Type Certified type of eligibility.
startDate	Eligibility > Eligibility Detail > Start Date Start date of the food service eligibility.
endDate	Eligibility > Eligibility Detail > End Date End date of the food service eligibility.
applicationID	Internal database identifier.
optOutMedicaid	Eligibility > Eligibility Detail > Opt Out Medicaid Indicates that parent does not want to be contacted by that specific agency.
optOutSCHIP	Eligibility > Eligibility Detail >Opt Out SCHIP Indicates that parent does not want to be contacted by that specific agency.
districtID	Internal database identifier.
eligibilityGUID	Internal database identifier.
freeMilk	Eligibility > Eligibility Detail >Free Milk Eligible Student receives free milk assistance.
notParticipate	Eligibility > Eligibility Detail > Does Not Participate Indicates that student does not participate in meal assistance.
eligType	Eligibility > Eligibility Detail >Eligibility Type The type of eligibility record.
modifiedByID	Eligibility > Eligibility Detail The ID of the last person to modify the record.
modifiedDate	Eligibility > Eligibility Detail The date on which the record was last edited.
directType	Eligibility > Eligibility Detail Identifies whether the student received a Direct Certification.
letterMethod	Eligibility > Eligibility Detail > Letter Method Indicates that the manually entered eligibility was the result of a Direct Certification AND the district received a certification letter
stateQualificationOverride	Eligibility > Eligibility Detail Type of approval based on the district selecting to override the assigned Eligibility for student on a Meal Benefits Application.
fromExtension	Eligibility > Eligibility Detail > Extended Indicates that the eligibility is the result of a family member's eligibility being extended to this student.
StateCode	Eligibility > Eligibility Detail > State Eligibility Code State eligibility code attached to the eligibility.
applicationName	Eligibility > Eligibility Detail > Application Name Name of the application.
referenceNumber	Eligibility > Eligibility Detail > Reference Number Application reference number.
eduBenefits	Eligibility > Eligibility Detail Indicates the educational benefits tied to the Educational Benefits Application.
permissionName	Eligibility > Eligibility Detail > Permission The name of the established district permission(s).
share	Eligibility > Eligibility Detail > Permission Indicates whether or not the parent/guardian allows the district permission to share their child(ren)'s free/reduced eligibility with other district staff members.

Student > FRAM > EligibilityToday

Do NOT use the EligibilityToday field from Student > FRAM > EligibilityToday with ANY Student > FRAM > Eligibility fields. If you do, students with a NULL eligibility will not be reported because they do not have an actual current eligibility and therefore do not have a record saved in the Eligibility table.

Eligibility	Student > FRAM > EligibilityToday
personID	Internal database identifier
eligibilityToday	Identifies students who do not have a current eligibility along with students who do have an eligibility. This field only reports data from the current date. The following image is an example of how you can use the eligibiityToday field to build a report that identifies all student's eligibilities.

Eligibility

Student > FRAM > EligibilityToday

personID

Internal database identifier

eligibilityToday

Identifies students who do not have a current eligibility along with students who do have an eligibility. This field only reports data from the current date.

The following image is an example of how you can use the eligibiityToday field to build a report that identifies all student's eligibilities.

Product Information > Eligibility Fields for Ad Hoc Reporting > ExampleFRAMToday.png

Eligibility Fields for Ad Hoc Reporting

Student > FRAM > Eligibility

Student > FRAM > EligibilityToday

Related Articles