Skip to main content
Skip table of contents

Import FAFSA Data

Introduction

The Academic and Career Plan feature is now used to store FAFSA data. This option can be used to import the student FAFSA Data.

Prerequisites

  1. Ensure District Info→ Add Master FAFSA Data is complete.

  2. Ensure the template format is as attached - FAFSA - Sample.csv

  3. Date format has to be in mm/dd/yyyy format only.

Run the Import

Navigation: District Management → Compliance → Data Import System.

  1. Select the import file for FAFSA

  2. Click Submit.

Output and Errors

View imported records and errors:

  1. For successfully imported records, data mapping is as follows for the following master data

    1. This should be created under Cluster → ACP Certification, Program → FAFSA Program, Credential → FAFSA

    2. SASID → Valid student SASIS Id

    3. Locality = Other Location, Site = School Name

    4. FAFSA Completed Status = Pass(completed)

    5. FAFSA Submission Date → Credential Date, Falls in the term year and format ( mm/dd/yyyy)

  2. Also ensure no duplicate data

  3. Error file(ErrorRecords.zip) is available in Downloads.

List of Error Messages in Credential and Program error files and their interpretations.

Error Message

Interpretation

Processing

Record inserted successfully.

-

Record inserted successfully.

Please check required fields are updated.

Blank fields values.

Ignores current record and moves to next

Invalid Entry with <field names>

Incorrect reference ID. Not present in master tables

Ignores current record and moves to next

Error while inserting other records into database.

Database issue or last field column is blank.

Stops processing.

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.