Eligibility Fields for Ad Hoc Reporting

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.