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
Ensure District Info→ Add Master FAFSA Data is complete.
Ensure the template format is as attached - FAFSA - Sample.csv
Date format has to be in mm/dd/yyyy format only.
Run the Import
Navigation: District Management → Compliance → Data Import System.
Select the import file for FAFSA
Click Submit.
Output and Errors
View imported records and errors:
For successfully imported records, data mapping is as follows for the following master data
This should be created under Cluster → ACP Certification, Program → FAFSA Program, Credential → FAFSA
SASID → Valid student SASIS Id
Locality = Other Location, Site = School Name
FAFSA Completed Status = Pass(completed)
FAFSA Submission Date → Credential Date, Falls in the term year and format ( mm/dd/yyyy)
Also ensure no duplicate data
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. |