...
| Parameter | External Table | Location | Field Name | Description | Example |
|---|---|---|---|---|---|
| balance_owed | external_person | Main-DetailsFinancialAid MAP-FinancialAid | Balance | Student's balance currently owed to the college. Format is XXXXX.XX. | $0.00 |
| financial_aid_gpa | external_student_financial_aid | Main-DetailsMain-FinancialAid Map- FinancialAid | FA GPA | The GPA calculated for financial aid eligibility | 1.82 |
| FAFSA_date | external_student_financial_aid | Main-DetailsFinancialAid MAP-FinancialAid | FAFSA | The date the FAFSA was accepted | 08/24/2013 |
| file_status | external_student_financial_aid_file | Main- DetailsFinancialAid MAP-FinancialAid | FA File | The appropriate status for the file code. Acceptable values are COMPLETE, INCOMPLETE and PENDING | COMPLETE |
| financialremaining_aidloan_remainingamount | external_student_financial_aid | Main-DetailsFinancialAid MainMAP-FinancialAid | FA Amount Remaining | The remaining amount of financial aid loans available to the student | $1300$809.00 |
| terms_left | external_student_financial_aid | Main-DetailsFinancialAid MAP-FinancialAid | FA Remaining Terms | The number of remaining eligible terms to receive financial aid | 3.00 |
| institutional_loan_amount | external_student_financial_aid | Main-FinancialAid MAP-FinancialAid | Institutional Loan Amount | The remaining amount of financial aid available to the student | $1,300.00 |
| original_loan amount | external_student_financial_aid | Main-DetailsFinancialAid MAP-FinancialAid | Loan Amount | The original amount of loans available to the student | $6,600.00 |
| sap_status_code | external_student_financial_aid | Main-DetailsFinancialAid MAP-FinancialAid | SAP Code | The SAP status code as determined by the institution. This value must match a configuration item for SAP status code in SSP administration | SAP-SAT |
| sap_status_code | external_student_financial_aid | Main-Details FinancialAid MAP-FinancialAid | SAP | The SAP status code as determined by the institution. This value must match a configuration item for SAP status code in SSP administration | SAP Satisfactory |
| term_code | external_student_financial_aid_award_term | Main-FinancialAid MAP-FinancialAid | FA Awarded | Specifies what term financial aid was offered to the student. Equivalent to external_term.code value. | FA12 |
| accepted | external_student_financial_aid_award_term | Main-FinancialAid MAP-FinancialAid | FA Awarded | Indicates the acceptance status of financial aid for the term. Acceptable values are Y or N | Y |
| financial_file_code | external_student_financial_aid_file | Main-FinancialAid | File Code | The file name as determined by the institution. Each required | |
| financial_file_code | external_student_financial_aid_file | Main-FinancialAid | File Name | The file name as determined by the institution. Each required | |
| <File Description> | |||||
| file_status | external_student_financial_aid_file | Main-FinancialAid Map_FinancialAid | File Status | The appropriate status for the file code. Acceptable values are COMPLETE, INCOMPLETE and PENDING | PENDING |
...