Tool: Main
Tab: Details
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-Details 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-Details Main-FinancialAid Map- FinancialAid | FA GPA | The GPA calculated for financial aid eligibility | 1.82 |
| FAFSA_date | external_student_financial_aid | Main-Details MAP-FinancialAid | FAFSA | The date the FAFSA was accepted | 08/24/2013 |
| file_status | external_student_financial_aid_file | Main-Details MAP-FinancialAid | FA File | The appropriate status for the file code. Acceptable values are COMPLETE, INCOMPLETE and PENDING | COMPLETE |
| financial_aid_remaining | external_student_financial_aid | Main-Details Main-FinancialAid | FA Amount | The remaining amount of financial aid available to the student | $1300.00 |
| terms_left | external_student_financial_aid | Main-Details 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-Details MAP-FinancialAid | Loan Amount | The original amount of loans available to the student | $6,600.00 |
| sap_status_code | external_student_financial_aid | Main-Details 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 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 |
| 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 | File Status | The appropriate status for the file code. Acceptable values are COMPLETE, INCOMPLETE and PENDING | PENDING |