FRAM Race/Ethnicity Report (Virginia)

Classic View: VA State Reporting > FRAM Race/Ethnicity Report

Search Terms: FRAM Race/Ethnicity Report

The FRAM Race/Ethnicity Report counts the racial and ethnic information of students who have applied for meal benefits as of October 1st. This report includes information on the number of students approved for free meals, reduced meals, and denied benefits. Direct Certifications are not included in this report. This data is used to complete the Virginia DOE Racial/Ethnic report for the National School Lunch Program Meal Applications verification form.

Screenshot of the FRAM Race Ethnicity Report extract editor.FRAM Race/Ethnicity Editor

Report Logic

To report, students must have a FRAM Application Reference number in which the Application Expiration Date is not before October 1st of the reporting year. The FRAM Race/Ethnicity Report counts race data from a student's most recent Identity record.

In order for a record to report that has a FRAM Eligibity Detail End Date NOT prior to October 1st the following must be true:

  • The FRAM Eligibility must be Free or Reduced
  • The Source must be Non-Direct. 

FRAM records do not report if the Source is Direct.

The totals in the report should exceed the number of FRAM applications due to multiple checks in the racial and ethnic identity section of the meal application, Census, or multiple students reported on a household application.

Report Editor Fields

FieldDescription
Effective DateThe date for which information in the report is valid.
Format

The format in which the report will generate. The following options are available:

  • Comma Separated (CSV)
  • HTML
Select Calendar(s)

The calendars from which student and FRAM information will be pulled.

Generate Extract

The report appears in a separate window in the designated format.

Submit to BatchThis process allows larger reports to generate in the background, without disrupting the use of Campus. For more information about submitting a report to the batch queue, see the Batch Queue article.

Generating the FRAM Race/Ethnicity Report 

  1. Enter the Effective Date in mmddyy format or select a date using the calendar icon.
  2. Select the Format in which the report should be generated. 
  3. Select the Calendar(s) for which to generate the report.
  4. When finished, select Generate Extract or the Submit to Batch button. The report will display in the selected format.

A student's FRAM Eligibility, Source, and Certified Type information is located at FRAM > Eligibility > Eligibility Detail Editor. 

FRAM Race/Ethnicity Report Layout

Element Name

Approved Free

Approved ReducedDenied

Campus Database

Campus Interface

American Indian or Alaskan Native

Counts one for each student whose record contains all of the following:

  • Race/Ethnicity is American Indian or Alaskan Native.
  • FRAM Eligibility status is Free.
  • FRAM Source is Non-Direct.

Counts one for each student whose record contains all of the following:

  • Race/Ethnicity is American Indian or Alaskan Native.
  • FRAM Eligibility status is Reduced.
  • FRAM Source is Non-Direct.

Counts one for each student whose record contains all of the following:

  • Race/Ethnicity is American Indian or Alaskan Native.
  • FRAM Certified Type is Denied.
Identity.raceEthnicityCensus > People > Identities > Race Ethnicity > American Indian or Alaska Native
Asian

Counts one for each student whose record contains all of the following:

  • Race/Ethnicity is Asian.
  • FRAM Eligibility status is Free.
  • FRAM Source is Non-Direct.

Counts one for each student whose record contains all of the following:

  • Race/Ethnicity is Asian.
  • FRAM Eligibility status is Reduced.
  • FRAM Source is Non-Direct.

Counts one for each student whose record contains all of the following:

  • Race/Ethnicity is Asian.
  • FRAM Certified Type is Denied.
Identity.raceEthnicityCensus > People > Identities > Race Ethnicity > Asian
Black or African American

Counts one for each student whose record contains all of the following:

  • Race/Ethnicity is Black or African American.
  • FRAM Eligibility status is Free.
  • FRAM Source is Non-Direct.

Counts one for each student whose record contains all of the following:

  • Race/Ethnicity is Black or African American.
  • FRAM Eligibility status is Reduced.
  • FRAM Source is Non-Direct.

Counts one for each student whose record contains all of the following:

  • Race/Ethnicity is Black or African American.
  • FRAM Certified Type is Denied.
Identity.raceEthnicityCensus > People > Identities > Race Ethnicity > Black or African American
Hispanic or Latino

Counts one for each student whose record contains all of the following:

  • Race/Ethnicity is Hispanic/Latino.
  • FRAM Eligibility status is Free.
  • FRAM Source is Non-Direct.

Counts one for each student whose record contains all of the following:

  • Race/Ethnicity is Hispanic/Latino.
  • FRAM Eligibility status is Reduced.
  • FRAM Source is Non-Direct.

Counts one for each student whose record contains all of the following:

  • Race/Ethnicity is Hispanic/Latino.
  • FRAM Certified Type is Denied.
Identity.hispanicEthnicityCensus > People > Identities > Race Ethnicity > Is the individual Hispanic/Latino? > Y: Yes
Native Hawaiian or Other Pacific Islander

Counts one for each student whose record contains all of the following:

  • Race/Ethnicity is Native Hawaiian or Other Pacific Islander.
  • FRAM Eligibility status is Free.
  • FRAM Source is Non-Direct.

Counts one for each student whose record contains all of the following:

  • Race/Ethnicity is Native Hawaiian or Other Pacific Islander.
  • FRAM Eligibility status is Reduced.
  • FRAM Source is Non-Direct.

Counts one for each student whose record contains all of the following:

  • Race/Ethnicity is Native Hawaiian or Other Pacific Islander.
  • FRAM Certified Type is Denied.
Identity.raceEthnicityCensus > People > Identities > Race Ethnicity > Native Hawaiian or Other Pacific Islander
Not Hispanic or Latino

Counts one for each student whose record contains all of the following:

  • Race/Ethnicity is not Hispanic/Latino.
  • FRAM Eligibility status is Free.
  • FRAM Source is Non-Direct.

Counts one for each student whose record contains all of the following:

  • Race/Ethnicity is not Hispanic/Latino.
  • FRAM Eligibility status is Reduced.
  • FRAM Source is Non-Direct.

Counts one for each student whose record contains all of the following:

  • Race/Ethnicity is not Hispanic/Latino.
  • FRAM Certified Type is Denied.
Identity.hispanicEthnicityCensus > People > Identities > Race Ethnicity > Is the individual Hispanic/Latino? > N: No
White

Counts one for each student whose record contains all of the following:

  • Race/Ethnicity is White.
  • FRAM Eligibility status is Free.
  • FRAM Source is Non-Direct.

Counts one for each student whose record contains all of the following:

  • Race/Ethnicity is White.
  • FRAM Eligibility status is Reduced.
  • FRAM Source is Non-Direct.

Counts one for each student whose record contains all of the following:

  • Race/Ethnicity is White.
  • FRAM Certified Type is Denied.
Identity.raceEthnicityCensus > People > Identities > Race Ethnicity > White
TotalReports the calculated sum of the seven above Race/Ethnic Identity fields in the Approved Free column.Reports the calculated sum of the seven above Race/Ethnic Identity fields in the Approved Reduced column.Reports the calculated sum of the seven above Race/Ethnic Identity fields in the Denied column.N/AN/A