Tool: Main-Financial Aid

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:

Main - Financial.jpg

Main - Financial.pdf

Main - Financial.vsd

 

ParameterExternal TableLocationField NameDescriptionExample
balance_owedexternal_personMain-FinancialAid
MAP-FinancialAid
BalanceStudent's balance currently owed to the college. Format is XXXXX.XX.$0.00
financial_aid_gpaexternal_student_financial_aid

Main-FinancialAid Map- FinancialAid

FA GPAThe GPA calculated for financial aid eligibility1.82
FAFSA_dateexternal_student_financial_aidMain-FinancialAid
MAP-FinancialAid
FAFSAThe date the FAFSA was accepted08/24/2013
file_status

external_student_financial_aid_file

Main-FinancialAid MAP-FinancialAid

FA FileThe appropriate status for the file code. Acceptable values are COMPLETE, INCOMPLETE and PENDINGCOMPLETE
remaining_loan_amount external_student_financial_aidMain-FinancialAid
MAP-FinancialAid
FA Amount RemainingThe remaining amount of loans available to the student$809.00
terms_leftexternal_student_financial_aidMain-FinancialAid
MAP-FinancialAid
FA Remaining TermsThe number of remaining eligible terms to receive financial aid3.00
institutional_loan_amountexternal_student_financial_aidMain-FinancialAid MAP-FinancialAidInstitutional Loan AmountThe remaining amount of financial aid available to the student$1,300.00
original_loan amount external_student_financial_aidMain-FinancialAid
MAP-FinancialAid
Loan AmountThe original amount of loans available to the student$6,600.00
sap_status_codeexternal_student_financial_aidMain-FinancialAid
MAP-FinancialAid
SAP CodeThe SAP status code as determined by the institution. This value must match a configuration item for SAP status code in SSP administrationSAP-SAT
sap_status_codeexternal_student_financial_aidMain-FinancialAid MAP-FinancialAidSAPThe SAP status code as determined by the institution. This value must match a configuration item for SAP status code in SSP administrationSAP Satisfactory
term_codeexternal_student_financial_aid_award_termMain-FinancialAid MAP-FinancialAidFA AwardedSpecifies what term financial aid was offered to the student. Equivalent to external_term.code value.FA12
acceptedexternal_student_financial_aid_award_termMain-FinancialAid MAP-FinancialAidFA AwardedIndicates the acceptance status of financial aid for the term. Acceptable values are Y or NY
financial_file_codeexternal_student_financial_aid_fileMain-FinancialAid

File CodeThe file name as determined by the institution. Each required 
financial_file_codeexternal_student_financial_aid_fileMain-FinancialAid

File NameThe file name as determined by the institution. Each required  
<File Description>     
file_statusexternal_student_financial_aid_file

Main-FinancialAid Map_FinancialAid

File StatusThe appropriate status for the file code. Acceptable values are COMPLETE, INCOMPLETE and PENDINGPENDING