Classic View: Ad hoc Reporting > 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	FRAM > Eligibility Student's meal status eligibility.
personID	Internal database identifier.
endYear	FRAM > Eligibility Last school year to which eligibility applies.
type	FRAM > Eligibility Certified type of eligibility.
startDate	FRAM > Eligibility Start date of the food service eligibility.
endDate	FRAM > Eligibility End date of the food service eligibility.
applicationID	Internal database identifier.
optOutMedicaid	FRAM > Eligibility Indicates that parent does not want to be contacted by that specific agency.
optOutSCHIP	FRAM > Eligibility Indicates that parent does not want to be contacted by that specific agency.
districtID	Internal database identifier.
eligibilityGUID	Internal database identifier.
freeMilk	FRAM > Eligibility Student receives free milk assistance.
notParticipate	FRAM > Eligibility Indicates that student does not participate in meal assistance.
eligType	FRAM > Eligibility The type of eligibility record.
modifiedByID	FRAM > Eligibility The ID of the last person to modify the record.
modifiedDate	FRAM > Eligibility The date on which the record was last edited.
directType	FRAM > Eligibility Identifies whether the student received a Direct Certification.
letterMethod	FRAM > Eligibility Iindicates that the manually entered eligibility was the result of a Direct Certification AND the district received a certification letter
stateQualificationOverride	FRAM > Eligibility Type of approval based on the district selecting to override the assigned Eligibility for student on a Meal Benefits Application.
fromExtension	FRAM > Eligibility Indicates that the eligibility is the result of a family member's eligibility being extended to this student.
StateCode	FRAM > Eligibility State eligibility code attached to the eligibility.
applicationName	FRAM > Eligibility Name of the application.
referenceNumber	FRAM > Eligibility Application reference number.
eduBenefits	FRAM > Eligibility Indicates the educational benefits tied to the Educational Benefits Application.
permissionName	FRAM > Eligibility The name of the established district permission(s).
share	FRAM > Eligibility 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	Census > People > Demographics 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 eligibiities.

Eligibility

Student > FRAM > EligibilityToday

personID

Census > People > Demographics

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 eligibiities.

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

Eligibility Fields for Ad Hoc Reporting

Student > FRAM > Eligibility

Student > FRAM > EligibilityToday

Related Articles