CommonLineCommonLineLoan ProcessingLoan Processing

CommonLineCommonLineLoan ProcessingLoan Processing

Loan processingLoan processingLoan processingLoan processing OverviewOverview

The CommonLine processThe CommonLine process Banner processingBanner processing Electronic Funds Transfer processingElectronic Funds Transfer processing

CommonLine processCommonLine process CommonLine processCommonLine process Institution transmits loan application to CompuServe mailbox Institution transmits loan application to CompuServe mailbox

of service providerof service provider Via third party software Via third party software

Guarantors, lenders pick up the mailGuarantors, lenders pick up the mail Process loan dataProcess loan data Send response information to the Institution’s CompuServe Send response information to the Institution’s CompuServe

mailboxmailbox Institution processes the response dataInstitution processes the response data

CommonLine process CommonLine process (cont)(cont)CommonLine process CommonLine process (cont)(cont)

Institution processes any change informationInstitution processes any change information Guarantors, lenders pick up change recordsGuarantors, lenders pick up change records Institution picks up change responses from the Institution picks up change responses from the

CompuServe mailboxCompuServe mailbox Disbursing agents send disbursing information to Disbursing agents send disbursing information to

the institutionthe institution

Banner ProcessingBanner Processing

Banner CommonLine Set upBanner CommonLine Set up

ROAINST - Institutional Options FormROAINST - Institutional Options Form RFRBASE - Fund Base Data FormRFRBASE - Fund Base Data Form RFRMGMT - Fund Management FormRFRMGMT - Fund Management Form RTVCINT - Certification Initials formRTVCINT - Certification Initials form RTVLNST - Loan Status Validation FormRTVLNST - Loan Status Validation Form RPAIDEN - Non-Person Identification FormRPAIDEN - Non-Person Identification Form RPRLNDA - Lender, Disbursing Agents Rules FormRPRLNDA - Lender, Disbursing Agents Rules Form RPRLPRD - Loan Period Rules FormRPRLPRD - Loan Period Rules Form RPRCLSS - Class Code Translation Rules FormRPRCLSS - Class Code Translation Rules Form RPRLOPT - Loan Options FormRPRLOPT - Loan Options Form

Banner CommonLine Set up Con’tBanner CommonLine Set up Con’t

ROAINSTROAINST - Loan Process Type (E)- Loan Process Type (E) RFRBASE - Fund Type (Loan), Federal Fund ID (STFD,PLUS)RFRBASE - Fund Type (Loan), Federal Fund ID (STFD,PLUS) RFRMGMT - Loan Process , Loan Fee Percent, Disburse (None)RFRMGMT - Loan Process , Loan Fee Percent, Disburse (None) RTVCINT - Certification InitialsRTVCINT - Certification Initials RTVLNST - Inactive, HoldRTVLNST - Inactive, Hold RPAIDEN - Creation of Lenders and GuarantorsRPAIDEN - Creation of Lenders and Guarantors RPRLNDA - Lender Base Data FormRPRLNDA - Lender Base Data Form (Linking Lenders to (Linking Lenders to

Disbursing Agents)Disbursing Agents) RPRLPRD - Creation of Loan Periods (Fall/Spring)RPRLPRD - Creation of Loan Periods (Fall/Spring) RPRCLSS - Converting Student Level and Class to Financial Aid RPRCLSS - Converting Student Level and Class to Financial Aid

Class Code (1 - Freshman, 3 - Sophomore)Class Code (1 - Freshman, 3 - Sophomore)

Packaging loansPackaging loans Packaging loansPackaging loans Loan options (RPRLOPT):Loan options (RPRLOPT):

Create loan application when loan is accepted, Create loan application when loan is accepted, NN Satisfy loan application requirement, Satisfy loan application requirement, NN Create award for loan within packaging, Create award for loan within packaging, NN Default return IDDefault return ID Default lender ID Default lender ID Default guarantor IDDefault guarantor ID

Packaging loans Packaging loans (cont)(cont) Packaging loans Packaging loans (cont)(cont)

Memo Actual AmountMemo Actual Amount Authorize LoansAuthorize Loans Loan option - returned check detail codesLoan option - returned check detail codes

Student charge/paymentStudent charge/payment Return paymentReturn payment Return refundReturn refund

Creating loan applicationsCreating loan applicationsCreating loan applicationsCreating loan applications

RPRELAP - Electronic Loan Application processRPRELAP - Electronic Loan Application process ParametersParameters

Aid yearAid year Fund code (multiple)Fund code (multiple) Default process type - Default process type -

GP, GO, PO, RP, CR, PGGP, GO, PO, RP, CR, PG Population selectionPopulation selection

Creating loan applicationsCreating loan applicationsCreating loan applicationsCreating loan applications

RPRELAP - Parameters RPRELAP - Parameters Permanent address DefaultPermanent address Default Local Address DefaultLocal Address Default Loan Status DefaultLoan Status Default EL Application Status DefaultEL Application Status Default ETF Authorization DefaultETF Authorization Default

Creating loan applicationsCreating loan applicationsCreating loan applicationsCreating loan applications

RPRELAP - ParametersRPRELAP - Parameters Lock Indicator DefaultLock Indicator Default References DefaultReferences Default Deferment Request DefaultDeferment Request Default Capitalize Interest DefaultCapitalize Interest Default Default Lender IDDefault Lender ID Default Guarantor IDDefault Guarantor ID Default Return IDDefault Return ID Default Loan PeriodDefault Loan Period

Creating electronic applicationCreating electronic applicationCreating electronic applicationCreating electronic application RPRELAP - Parameter 03RPRELAP - Parameter 03

GP - Service provider prints a prom note and mails it to the GP - Service provider prints a prom note and mails it to the borrowerborrower

PG - Print and GuaranteePG - Print and Guarantee GO - Prom note signed by the borrower and institution GO - Prom note signed by the borrower and institution

obtains the guaranteeobtains the guarantee PO - Service provider mails prom note before the loan PO - Service provider mails prom note before the loan

eligibility data is certifiedeligibility data is certified RP - Service provider to re-print a prom noteRP - Service provider to re-print a prom note CR - Borrower sends the loan application to the service CR - Borrower sends the loan application to the service

provider instead of the institutionprovider instead of the institution

Creating loan applicationCreating loan applicationCreating loan applicationCreating loan application RPRELAP continuedRPRELAP continued

RPRELAP will replace an old record with a new one RPRELAP will replace an old record with a new one upon an award changeupon an award change

RPRELAP will create a subsequent application record RPRELAP will create a subsequent application record upon an award increase for the difference between the upon an award increase for the difference between the previously processed applicationpreviously processed application

RPRELAP is the only way to create electronic RPRELAP is the only way to create electronic applicationsapplications

Creating loan application Creating loan application (con’t)(con’t)Creating loan application Creating loan application (con’t)(con’t)

Electronic applications will only be created on RPAELAP Electronic applications will only be created on RPAELAP when the Stafford, UnSub or PLUS is in the accepted statuswhen the Stafford, UnSub or PLUS is in the accepted status

Electronic applications will be created for both Sub and Electronic applications will be created for both Sub and UnSub Stafford LoansUnSub Stafford Loans

Creating Loan ApplicationsCreating Loan ApplicationsCreating Loan ApplicationsCreating Loan Applications

Batch Application Creation Batch Application Creation Job SubmissionJob Submission

On - Line Application CreationOn - Line Application Creation RPAAWRDRPAAWRD RPAAPMTRPAAPMT ROARMAN ROARMAN

Viewing electronic applicationViewing electronic applicationViewing electronic applicationViewing electronic application

RPAELAP - Electronic Loan Application FormRPAELAP - Electronic Loan Application Form Updates allowedUpdates allowed

Lock indicatorLock indicator Lender IDLender ID Guarantor IDGuarantor ID Return IDReturn ID Loan periodLoan period Application statusApplication status (N, S, I, B, D, C, R, A, G, P, M, T)(N, S, I, B, D, C, R, A, G, P, M, T) Process typeProcess type

Viewing electronic applicationViewing electronic applicationViewing electronic applicationViewing electronic application

RPAELAP - continuedRPAELAP - continuedRecord typeRecord typeEFT authorizationEFT authorizationReferencesReferencesPlus to studentPlus to studentRequestedRequestedDate createdDate createdProm note Prom note Submission, approval (system maintained)Submission, approval (system maintained)

Viewing electronic applicationViewing electronic applicationViewing electronic applicationViewing electronic application

RPAELAP - continuedRPAELAP - continued Certification dataCertification data Student and parent dataStudent and parent data

Plus loan - Parent information must be entered before Plus loan - Parent information must be entered before the extract process can run (only has to be entered the extract process can run (only has to be entered once)once)

Parent data can be viewed on RPILPAR - Parents Loan Parent data can be viewed on RPILPAR - Parents Loan Inquiry FormInquiry Form

Viewing electronic applicationViewing electronic applicationViewing electronic applicationViewing electronic application

Parent Loan Data - RPILPARParent Loan Data - RPILPAR Stored in permanent tablesStored in permanent tables Linked to the student Linked to the student

Sending electronic recordsSending electronic recordsSending electronic recordsSending electronic records

RPRELAX - Electronic Loan Application RPRELAX - Electronic Loan Application extract - extract - ParametersParameters Aid yearAid year Fund code (multiple)Fund code (multiple) File identifier (P, T)File identifier (P, T) School nameSchool name Combined Sub and UnSubCombined Sub and UnSub

Sending electronic recordsSending electronic recordsSending electronic recordsSending electronic records

RPRELAX - ParametersRPRELAX - Parameters Recipient nameRecipient name Recipient IDRecipient ID Media type (D,Media type (D, M,M, P,P, T)T) Population selections (optional)Population selections (optional) Version Number (4)Version Number (4)

Sending electronic recordsSending electronic recordsSending electronic recordsSending electronic records RPRELAX - continuedRPRELAX - continued

File name - File name - ELAPXXIN_CCYYMMDDHHMISS.DATELAPXXIN_CCYYMMDDHHMISS.DAT

Report file name - Report file name - RPRELAX_ccyymmddhhmiss.lisRPRELAX_ccyymmddhhmiss.lis

Electronic records created if:Electronic records created if: Loan not canceledLoan not canceled Application Status - Application Status - RR Batch ID is nullBatch ID is null Loan ID is not nullLoan ID is not null

Sending electronic recordsSending electronic recordsSending electronic recordsSending electronic records

Electronic Extract file Electronic Extract file One header recordOne header record One detailed record for each loan applicationOne detailed record for each loan application One trailer recordOne trailer record Can be sent directly to the service providerCan be sent directly to the service provider

Loan response dataLoan response dataLoan response dataLoan response data

RPRELRU - Electronic Loan Response UploadRPRELRU - Electronic Loan Response Upload File name File name Data load directory of BannerData load directory of Banner COBOL processCOBOL process ParameterParameter - - Update loan statusUpdate loan status

Loan response dataLoan response dataLoan response dataLoan response data

Composition of data fileComposition of data file Header recordHeader record Detail recordDetail record

Borrower SSN or PLUS student SSNBorrower SSN or PLUS student SSN Date of birthDate of birth Loan typeLoan type Unique identifierUnique identifier

Loan response dataLoan response dataLoan response dataLoan response data

Updates application statusUpdates application status(A, I, G, B, P, D, M, C, T)(A, I, G, B, P, D, M, C, T)

Loan sequence numberLoan sequence number Guarantee dateGuarantee date Guarantee amountGuarantee amount Loan StatusLoan Status

Loan response dataLoan response dataLoan response dataLoan response data

Loan Response Data reportLoan Response Data report Name, SSNName, SSN Guarantee Status codeGuarantee Status code Certification Amount Adjustment codeCertification Amount Adjustment code Requested Amount Adjustment codeRequested Amount Adjustment code Error messagesError messages

Control report will display the control information - Control report will display the control information - Recipient name, ID, ED branch ID, Record countRecipient name, ID, ED branch ID, Record count

EFT roster processingEFT roster processingEFT roster processingEFT roster processing

RPREFTL - Loan roster data to holding areaRPREFTL - Loan roster data to holding area File name - 123xxx.datFile name - 123xxx.dat

(xxx = Roster Sequence number)(xxx = Roster Sequence number) Parameter’s - Data file nameParameter’s - Data file name Inserts records in the Electronic Payment Receipt table - Inserts records in the Electronic Payment Receipt table -

RPREPMTRPREPMT

EFT roster processingEFT roster processingEFT roster processingEFT roster processing

RPAEPMT - Electronic Payment Receipt FormRPAEPMT - Electronic Payment Receipt Form Set Receipt flag to Set Receipt flag to YY upon receipt of the funds upon receipt of the funds

II - Individual check - Individual check M M - Master check- Master check EE - Electronic roster - Electronic roster NN - Net adjustment - Net adjustment

Electronic Loan Disbursement Electronic Loan Disbursement FormFormElectronic Loan Disbursement Electronic Loan Disbursement FormForm

RPAELDB - Electronic Loan Disbursement FormRPAELDB - Electronic Loan Disbursement Form Review records before posting to the disbursement Review records before posting to the disbursement

tablestables Delete pending electronic disbursement Delete pending electronic disbursement YY

Only Updateable fieldOnly Updateable field Multiple records can exist (STFD/PLUS)Multiple records can exist (STFD/PLUS) Query, SOAIDEN/RPILPARQuery, SOAIDEN/RPILPAR

Posting EFT disbursementsPosting EFT disbursementsPosting EFT disbursementsPosting EFT disbursements

RPREFTP - EFT Posting processRPREFTP - EFT Posting process Distribution method - optional, if not entered all methods Distribution method - optional, if not entered all methods

are processed (E,N,M,I)are processed (E,N,M,I) Reference ID - optional, if not entered all received batches Reference ID - optional, if not entered all received batches

are processedare processed RPREFTP - Matches the unique loan ID from the roster to the RPREFTP - Matches the unique loan ID from the roster to the

RPRLAPP table to determine the student PIDM and loan RPRLAPP table to determine the student PIDM and loan application numberapplication number

Changes to disbursementsChanges to disbursementsChanges to disbursementsChanges to disbursements

The Posting process RPREFTP automatically sets the The Posting process RPREFTP automatically sets the feed indicator to feed indicator to YY

Master and individual checks must be manually set to Master and individual checks must be manually set to feedfeed

RPRLADB_EFT_IND - RPEDISBRPRLADB_EFT_IND - RPEDISB Validates that the EFT indicator is set to Validates that the EFT indicator is set to YY

Changes to disbursementsChanges to disbursementsChanges to disbursementsChanges to disbursements

RPALDSB Loan Disbursement FormRPALDSB Loan Disbursement Form RPALDSB window 1 - Loan summaryRPALDSB window 1 - Loan summary RPALDSB window 2 - Disbursement detailRPALDSB window 2 - Disbursement detail

Reference IDReference ID Returned lenderReturned lender Estimated amountEstimated amount CommentComment EFT indicatorEFT indicator Disbursement bypassDisbursement bypass

Exception ReportsException ReportsException ReportsException Reports

RPRLNEX - Student not fully fundedRPRLNEX - Student not fully funded Term CodeTerm Code Fund CodeFund Code Tolerance AmountTolerance Amount Population SelectionPopulation Selection

Exception ReportsException ReportsException ReportsException Reports

RPRLNAG - Aging Report of Non- Disbursed LoansRPRLNAG - Aging Report of Non- Disbursed Loans Aid YearAid Year Term CodeTerm Code Fund CodeFund Code Reference IDReference ID Sort OrderSort Order