Eligibility Import Wizard

PATH: FRAM > Eligibility Import Wizard

Use the Eligibility Import Wizard to upload and import data files containing student meal service and socioeconomic eligibilities. The Eligibility Import Wizard includes steps for mapping values from the data file to the Campus database for state-reporting and food service purposes. Campus transfers imported student eligibility data to the Eligibility tool.

Import files may contain Direct Certification Types.

If more than one type of eligibility value exists in the import file, the values must be mapped to existing values in the database.

The wizard allows the values within the data file to be imported "as is" (keep original values), OR allows the user to select a value to be mass-assigned to all students through the import.

A complete import and its associated mapping may be saved and re-used.

Although an Eligibility Import Mapping may be re-used, you cannot change the file from a Direct Certification file to a 3rd Party Eligibility file and vice versa.

See the FRAM Eligibility Standards and Guidelines for important information. The FRAM Eligibility Standards and Guidelines article is meant to help you establish eligibility determinations as well as provide you with the details necessary for understanding what happens to a child's eligibility status when you import an eligibility file using the Eligibility Import Wizard.

Eligibility Import Wizard

This article includes the following topics:

See Also


Recommendation

To import a direct certification file, use the steps found in the Importing a Direct Certification File article.

To import an eligibility file from a 3rd party system, use the steps found in the Importing a 3rd Party Eligibility File article.

Although an Eligibility Import Mapping may be re-used, you cannot change the file from a Direct Certification file to a 3rd Party Eligibility file and vice versa.


Import File Requirements

The Eligibility Import Wizard has the following requirements of all import files:

Campus does not recommend mapping the same column in an import file to multiple Campus fields.

The following items can be mapped on the import file or set as the same value for all students on the file:

Additional Requirements for State Level Use

District ID. The District ID of the district assignment for the current user is required and is used to identify the district for which the import can be performed. A user cannot import data for students enrolled in other districts.

The fields that display depend on the type of file being imported. Each type of file (.csv, fixed-width, tab delimited, etc.) displays different mapping criteria. Only a mapping for the student identifier type selected is created. If Last Name, First Name, Date of Birth fields are selected, a mapping is created for each of those fields.

3rd Party Eligibility File Requirements

The following items must be included when importing a 3rd Party Eligibility file:



State-Level Imports

The following items apply to state-level users only.

To complete an import, you must be logged in as as a user with access rights to the district and NOT as a state-wide user.

The Eligibility Import Wizard available to state-level users has the following, additional requirements/restrictions:

Feedback