...
| Parameter | External Table | Location | Field Name | Description | Example | ||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| gradebalance_point_averageowed | external_student_transcriptperson | Main-DashboardFinancialAid Main-Details MAP-FinancialAid | GPA | The calculated cumulative GPA value | 1.82 | ||||||||||||
| academic_standing | external_student_transcript | Main-Dashboard | Standing (Student Indicator) | Current academic standing of the student | GOOD | ||||||||||||
| current_restrictions | external_student_transcript | Main-Dashboard Main-Details MAP-FinancialAid | Restrictions | List of any restrictions or holds on the student record | ie. Dismissed, Hold, FineBalance | Student's balance currently owed to the college. Format is XXXXX.XX. | $0.00 | ||||||||||
| financial_aid_gpa | external_student_financial_aidMain-Details | Main-FinancialAid Map- FinancialAid | FA GPA | The GPA calculated for financial aid eligibility | 1.82 | ||||||||||||
| gpa_20_a_hrs_neededFAFSA_date | external_student_financial_aid | Main-FinancialAid MAP-FinancialAid | Hours needed to earn a 2.0 GPA with all A grades | The number of earned hours at an A level required to achieve an overall 2.0 GPA | 9 | gpa_20_b_hrs_neededFAFSA | The date the FAFSA was accepted | 08/24/2013 | |||||||||
| file_status | external_student_financial_aid | MAP-FinancialAid | Hours needed to earn a 2.0 GPA with all B grades | The number of earned hours at a B level required to achieve an overall 2.0 GPA | 9 | credit_hours_earned | external_student_transcript | Main-Details _file | Main-FinancialAid MAP-FinancialAid | Hrs Earned | The total value of credit hours successfully completed or earned | 31 | credit_hours_attempted | external_student_transcript | Main-DetailsFA 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 | Hrs AttemptedFA Amount Remaining | The total value of credit hours attempted whether or not included in the hours for GPA or hours earned | 36 | credit_completion_rateremaining amount of loans available to the student | $809.00 | ||||||||||
| terms_left | external_student_transcriptMain-Dashboard_financial_aid | Main-Details MAP-FinancialAid | Comp Rate | Completion rate of hours attempted | 86% | needed_for_67ptc_completion | external_student_financial_aid | MAP-FinancialAid | Hours needed to earn a 67% completion rateFA Remaining Terms | The number of hours needed to reach a 67% completion rate required for financial aid (earned/attempted=completion rate) | 9 | ||||||
| term_code | external_registration_status_by_term | Main-Dashboard Main-Details MAP-FinancialAid | Reg | List of current and future terms for which the student is registered | FA2013 | ||||||||||||
| tuition_paid | external_registration_status_by_term | Main-Dashboard Main-Details MAP-FinancialAid | Payment | Y or N, indicates payment status of tuition for the term | FA2013=N | ||||||||||||
| balance_owed | external_person | Main-Details MAP-FinancialAid | Balance | Student's balance currently owed to the college. Format is XXXXX.XX. | $0.00 | ||||||||||||
| sap_status | externalremaining 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-Dashboard Main-DetailsFinancialAid MAP-FinancialAid | SAP | Y or N, indicates if the student has achieved Satisfactory Academic Progress | N | ||||||||||||
| F1_status | external_person | Main-Dashboard Main-Details MAP-FinancialAid | F1 | Y or N, indicates if the student has an F1 Visa on file | Y | ||||||||||||
| FAFSA_date | 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 | FAFSASAP Code | The date the FAFSA was accepted | 08/24/2013 | current_year_financial_aid_awardSAP 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-Dashboard Main-Details MAP-FinancialAid | FA Award | Y or N, indicates if the student received financial aid for the current academic year | Y | remaining_loan_amount | external_student_financial_aid | Main-Details MAP-FinancialAid | FA AmountSAP | The remaining amount of loans available to the student$809.00SAP 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 | ||||||||||||
| institutionalfinancial_loanfile_amountcode | 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_file | Main-Details MAP-FinancialAid | Loan Amount | The original amount of loans available to the student | $6,600.00 | ||||||
| terms_left | external_student_financial_aid | Main-Details MAP-FinancialAid | Remaining FA Terms | The number of remaining eligible terms to receive financial aid | 3.00 | ||||||||||||
| File Code | The file name as determined by the institution. Each required | ||||||||||||||||
| financial_file_code | external_student_financial_aid_file | Main-Details MAP-FinancialAid | SAPFile Name | The SAP status code file name as determined by the institution. This value must match a configuration item for SAP status code in SSP administrationSAP-SATEach required | |||||||||||||
| <File Description> | |||||||||||||||||
| file_status | external_student_financial_aid_file | Main- DetailsMAP- FinancialAid Map_FinancialAid | FA File Status | The appropriate status for the file code. Acceptable values are COMPLETE, INCOMPLETE and PENDINGCOMPLETE | PENDING |