...
The Main Tool displays academic information about the student normally stored in the student information system (SIS).
The Details tab from the Main Tool displays information maintained in the SIS regarding the student's financial aid.
Attachments:
| Parameter | External Table | Location | Field Name | Description | Example |
|---|---|---|---|---|---|
| balance_owed | external_person | Main-FinancialAid 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-FinancialAid Map- FinancialAid | FA GPA | The GPA calculated for financial aid eligibility | 1.82 |
| FAFSA_date | external_student_financial_aid | Main-FinancialAid MAP-FinancialAid | FAFSA | The date the FAFSA was accepted | 08/24/2013 |
| file_status | external_student_financial_aid_file | Main-FinancialAid MAP-FinancialAid | FA File | The appropriate status for the file code. Acceptable values are COMPLETE, INCOMPLETE and PENDING | COMPLETE |
| remaining_loan_amount | external_student_financial_aid | Main-FinancialAid MAP-FinancialAid | FA Amount Remaining | The remaining amount of loans available to the student | $809.00 |
| terms_left | external_student_financial_aid | Main-FinancialAid 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-FinancialAid MAP-FinancialAid | Loan Amount | The original amount of loans available to the student | $6,600.00 |
| sap_status_code | external_student_financial_aid | Main-FinancialAid 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-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 |