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 the template format is as attached - FAFSA - Sample.csv
-
Date format has to be in dd-mmm-yy 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. |