WIXLIB

SunGard Higher Education Northeast UsersConference 20061Parent Plus Loan RefundingPresented by: Dave BrunnerSungard Higher EducationSeptember 20, 2007Rules of Etiquette Please silence your mobile devices cell phones/PDAs If you must leave the session early, please do so asdiscreetly as possible Please avoid side conversations during the sessionThank you for your cooperation!2Goal of the Session Provide information to allow you to use thefunctionality of refunding parent PLUS loan to theparent borrower (once fees have been paid)31

SunGard Higher Education Northeast UsersConference 2006Agenda Provide an overview of the enhancement.Review the right Patches per product (AR / Finance)Review changes to Banner Financial AidReview changes to Banner Accounts ReceivableDiscuss the importance of Application of PaymentsSummary4Enhancement Overview Prior to the enhancement: A refund generated & calculated via the automaticrefunding process (TSRRFND) was always refundedto the student. Manual intervention was required if schools wantedto refund excess to parent borrower.5Enhancement Overview With the enhancement: IF a refund is created from a Parent PLUS loan credit AND the loan DOES NOT INDICATE ‘Parent PLUS toStudent’ (RPALAPP/RPAELAP/RPALORG forms) Refund is processed as automatic check payable toparent PLUS borrower (rather than student).NOTE: Refunds are based on the balance for eachparent PLUS loan that has not been applied tocharges on the student’s account.62

SunGard Higher Education Northeast UsersConference 2006Enhancement Overview Parent PLUS Loan Refunding Uses existing FA parent information to pass to PeopleSoftFinancials for refund in parent borrowers name. Separate refund code for parent Plus refunds. Refunding can be “manual” or “automatic” (TSRRFND). Parent becomes a “One Time Vendor” in PeopleSoftFinancials. Invoice and check created in the parent’s name. No manual Intervention is required by AP to ensure checksare payable to the parent.78Minimum Banner Release Versions&Required enhancement patches for Banner ARBanner Release Levels Required Minimum Banner release levels needed for patch: Accounts Receivable 7.3 (May 2006) Financial Aid 7.5.1 (June 2006) -- see notes below:Note: Financial Aid 7.5.1 adds columns to the RFRASPC tablethat are used to distinguish Parent PLUS from GraduatePLUS Loan funds and is required in order to compile the ARobjects.Note: Financial Aid 7.6 (August 2006) includes the 7.5.1release, but because this release enables recording Parentaddress information on the Loan Application Form(RPALAPP), there is a functional requirement to install thisversion for schools that process manual parent PLUSapplications.93

SunGard Higher Education Northeast UsersConference 2006Patches that provided the enhancement Banner Accounts Receivable Patch p1-sl813 tas70300. posted 9/6/06. Patch p1-165mui tas70300.trz posted 11/21/06.Note: Banner Finance also had patches for theenhancement, but N/A for GA BOR schoolssince using PeopleSoft Financials1011Changes to Financial AidFINANCIAL AID FLAG The ‘Parent PLUS to Student flag on the loan app forms(RPALAPP, RPAELAP, RPALORG) is now be used bythe Automated Refund Process if Parent Loan Refunddetail code is defined on TSADETC. If this functionality is to be implemented, then allexisting PLUS loan applications must be updated toshow Refund to Student unless it is known that theParent is to receive the refund.124

SunGard Higher Education Northeast UsersConference 2006FINANCIAL AID FLAG Parent data must be entered on the Parent page of theloan app as this data is currently not uploaded by theany Banner FA processes. Application of Payments will continue to use the parentPLUS loan payment to apply to student charges first(regardless of Parent PLUS to Student flag). If the Parent Address Information is missing on the loanapp, the TSRRFND report will indicate (when run inFLAG mode).1314Changes to Accounts ReceivableACCOUNTS RECEIVABLE TSADETC - a unique detail code must be usedexclusively for parent PLUS refund with the ‘RefundCode’ ‘P’ (parent PLUS). TSRRFND (Student Refund process) does not needthe parent PLUS refund code to be entered in theREFUND Parameter Use the regular refund detail code. The process will find the parent PLUS refund codeand use it for any PLUS loan detail code with a creditthat has no ‘Parent PLUS to Student’ flag set155

SunGard Higher Education Northeast UsersConference 2006ACCOUNTS RECEIVABLE – TSRRFND Parameters* * * REPORT CONTROL INFORMATION * * * RPTNAME: TSRRFND VERSION: 7.3.0.1 RUN MODE: RFND AUDIT/UPDATE MODE: U TITLE IV OPTION: A MINIMUM REFUND BALANCE: -1.00 ADDRESS SELECTION DATE: 22-AUG-2007 ADDRESS TYPE HIERARCHY: 1MA 2PR DETAIL CODE: LMRF- the “regular” Refund Code CASHIER USERID: RFNDLM PROCESS TERM: 200710 ENTITY TYPE: % CATEGORY HIERARCHY: INCLUDE/EXCLUDE: SELECTION TERM: PRINT ACCOUNT DETAIL: Y EXCEPT TERMS: SELECTION ID: APPLICATION CODE: CREATOR ID: USER ID:16TSRRFND – Parameters echoed after running process* * * REPORT CONTROL INFORMATION * * * RPTNAME: TSRRFND VERSION: 7.3.0.1 RUN MODE: RFND AUDIT/UPDATE MODE: U TITLE IV OPTION: A PLUS REFUND CODE: RFPL - System Finds and enters this Line MINIMUM REFUND BALANCE: -1.00 ADDRESS SELECTION DATE: 22-AUG-2007 ADDRESS TYPE HIERARCHY: 1MA 2PR DETAIL CODE: LMRF- You enter the regular Refund Code CASHIER USERID: RFNDLM PROCESS TERM: 200710 ENTITY TYPE: % CATEGORY HIERARCHY: INCLUDE/EXCLUDE: SELECTION TERM: PRINT ACCOUNT DETAIL: Y EXCEPT TERMS: SELECTION ID: APPLICATION CODE: CREATOR ID: USER ID:17ACCOUNTS RECEIVABLE Refunds can be done using TSRRFND – Automaticwhich will TPAY the refund to the PLUS LoanPayment Refunds can also be processed manually using theTSADETL or TSAAREV forms: Enter the PLUS loan refund code You must TPAY it directly to the PLUS loan paymentCode.186

SunGard Higher Education Northeast UsersConference 2006ACCOUNTS RECEIVABLE – TSRRFND ReportRFND / Audit mode15 Accounts Receivable 7.3.0.1/FInance 7.2.0.1 Confidential TSRRFND Report Sample (1 of 2)22-AUG-2007 16:10:04 BANNER University PAGE 1 ID Name Code Refund Amount Address515001010Miller, Sam RRFPL 2,438.00 515001010Miller, Sam RLMRF 2,475.00 515001020Morry, Sally MRFPL 3,840.00PARENT : Susan M Morry16 Parker RoadWakefield, MA 01880 515001020Morry, Sally MRFPL 960.00PARENT : Stan D Morry*** WARNING ***---NO ADDRESS---PARENT : Mary M Miller28 Keli AveMansfield, CA 928221234 3a South StGreat Falls, MT 59401920Importance of Application of PaymentsImportance of Application of Payments Refunds are based on the “balance amount” for each“PLUS loan payment code” that have not been appliedto charges on the student’s account. If PLUS loan payment code has more than a zero creditbalance – new parent PLUS refund code will be used toabsorb the credit balance.PARENT GETS THE REFUND If PLUS loan payment code has zero credit balance (buthas applied to other charges and now has a zero balance)– existing refund detail code from TSRRFND process willbe used to absorb the credit balance on PLUS loanpayment code.STUDENT GETS THE REFUND217

SunGard Higher Education Northeast UsersConference 2006Importance of Application of Payments(EXAMPLE 1)Before TSRRFND and Application of Balance2000 1,000 Note: if the check paid off TUIT 1st then the PLUS pays offbalance.22Importance of Application of Payments(EXAMPLE 1) How much is the refund and who gets it? ANSWER - 800 and Parent gets it.Reason – PLUS loan payment code has the Credit Balanceso new Parent PLUS loan refund code (RFNP) is used byTSRRFND.23Importance of Application of Payments(EXAMPLE 0Balance0000Don’t focus on the PLUS amount of 1,000In this case, the PLUS loan has to pay off the Balance ofthe TUIT balance, then it will insert the PLUS loan refundcode even though you never entered RFNP as aparameter on TSRRFND. It will bypass RFND and usethe PLUS loan refund code. Refund is 800.248

SunGard Higher Education Northeast UsersConference 2006Importance of Application of Payments(Example 2) Importance of TGRAPPL Parameter #5RPTNAME: TGRAPPL VERSION: 7.2ID NUMBER: 01APPLY REFUND TO ANY PRIORITY? (Y,N): YAPPLY NEGATIVE CHARGE TO ANY PRIORITY? (Y,N): YAPPLY TO CONT/EXPT CROSSREF OR DETAIL CODE PRIORITY? (C,D): DAPPLY TO TITLE IV FIRST? (Y/N): YIF this is ‘Y’ see note.APPLY AID TO FUTURE TERMS? (Y/N): YAPPLY NON-AID CREDITS TO FUTURE TERMS? (Y/N): Y NOORDERING BY TERM (4)PRINT APPLICATION PENDING ROSTER? (Y/N): NSELECTION ID:APPLICATION CODE:CREATOR ID:USER ID:RECORD COUNT: 1NOTE – If PLUS is TIV, then it may pay off Tuition First leaving Other Credits with balanceswhich may get refunded to Student25Importance of Application of Payments – Example 2.Same student – but – TGRAPPL Parm #5 1,000 800 1,000 Parameter #5 asks do you want to apply TIV 1st? Example shows all transactions 2 and 3 on the same day. If PLUS is marked TIV on TSADETC but if you say ‘Y’es to thisparameter, PLUS will pay off TUIT first. Then the PLUSpayment code has a 0.00 balance, so TSRRFND will use theREGULAR Refund Code which means the STUDENT gets therefund check payable to them for 800.26Importance of Application of Payments – Example 2.Same student – but All Payments received and appliedat the same time and TGRAPPL Parm #5 YCodeTUITCHEKPLUSRFND Charge1,000Payment8001,000800Balance0.00 800 0.00800Parameter #5 Asks do you want to apply TIV 1st?PLUS is TIV but if you say ‘Y’es to this parameter, PLUS will pay offTUIT first. Then the PLUS payment code has a 0.00 balance, soTSRRFND will use the REGULAR Refund Code which means theSTUDENT gets refund for 800 payable to them279

SunGard Higher Education Northeast UsersConference 2006Importance of Application of Payments – Example 2.Same student – but All Payments received and appliedat the same time and TGRAPPL Parm #5 Balance2000.00 1,000 800 Parameter #5 Asks do you want to apply TIV 1st?If you mark PLUS as NOT TIV, then if other TIV pays off TUITfirst then the PLUS payment code has a 800 Credit balance, soTSRRFND will use the REGULAR Refund Code which Meansthe PARENT gets the refund for 800 payable to them.28Importance of Application of Payments - Summary Watch the TGRAPPL Parameters – Apply TIV First Watch the use of TSRRFND Parameters – Refund TIV First Consider changing the TSADETC for Plus Loan Refund to Nullfor TIV just before refunding using TSRRFND Consider Unapplying TGRUNAP Using Pop Selection for allStudents getting PLUS loans per the semester just BEFORErunning TSRRFND. Run TGRAPPL Application of paymentsfor same Population Selection. Run TSRRFND for PLUSloans. If you currently use 999 and 000 Priorities, consider changingall Payments to 900 and PLUS Payment to 000 which will makeit “last” code to pay.2930Summary of the Banner piece .10

SunGard Higher Education Northeast UsersConference 2006SummaryProcessing Prerequisites31Summary32Summary3311

SunGard Higher Education Northeast UsersConference 200634Supporting Documentation fromSunGard Higher EducationDocumentation35DocumentationFor additional information on Parent PLUS loans, referto the following documentation: Banner Financial Aid Release Guide 7.5.1 Banner Financial Aid Release Guide 7.6 Banner Financial Aid User Guide3612

SunGard Higher Education Northeast UsersConference 200637PeopleSoft Financials processingThank You&Enjoy the rest of the conference!Dave Brunner, Principal Process ConsultantSunGard Higher EducationDave.Brunner@SunGardHE.comSunGard, the SunGard logo, Banner, Campus Pipeline, Luminis, PowerCAMPUS, Matrix, and Plus are trademarks orregistered trademarks of SunGard Data Systems Inc. or its subsidiaries in the U.S. and other countries. Third-partynames and marks referenced herein are trademarks or registered trademarks of their respective owners. 2007 SunGard. All rights reserved.3813

SunGard Higher Education Northeast Users Conference 2006 8 22 Importance of Application of Payments (EXAMPLE 1) Before TSRRFND and Application of Payments Code Charge Payment Balance TUIT 1,000 200 CHEK 800 0 PLUS 1,000 1,000 Note: if the check paid off TUIT 1st then the PLUS pays