Description This process extracts data from the RPRLAPP, RPRLCRT, RPRLADB and ROBINST tables to create electronic loan application records in the CommonLine record format. You can import this file of records with school-based software systems; or you can send it directly to your service provider. Since the CommonLine specifications do not stipulate a specific file name for this data file, the assigned file name is ELAPxxOP.DAT. The RPRELAX.LIS file contains the report control information.
Electronic loan application records will be selected for this extract process if:
• the loan is not canceled,
• the loan status is R (ready to send)
• the batch ID is null
• the loan ID is not null, and
• if population selection is used, the student is also included in the population.
After you run the RPRELAP Process to create the electronic loan application records, be sure to manually review and update the records as needed before the records are sent. Most data is automatically created by the RPRELAP process. However, some critical data may be missing or may need to be changed from the default values.
In order to transmit a loan application, you must change the Application Status code on the Electronic Loan Application Form (RPAELAP) to R for Ready to Send. To retransmit a record that was rejected and needs to be corrected, you should remove the Batch ID and change the Application Status from S to R.
The output file will have the following records:
• one header record
• one detail record for each loan application
• one trailer record
Banner will not create unique Supplemental Detail Records or Alternative Loan Detail Records. Use the Batch Control Form (RPIBATC) to display CommonLine Electronic Loan Application batches.
Parameters Name Required? Description Values
Aid Year Code Yes Enter a valid and active aid year. This parameter is validated against the Financial Aid Institution Table (ROBINST).
Aid Year Inquiry Form (ROIAIDY)
Fund Code Yes The fund code must be associated with Federal Fund ID of STFD or PLUS, or represent an Alternative Loan. The system accepts a single fund code or a multiple number of fund codes for this report parameter. Use the Insert Record function to add more than one fund code. This parameter is validated against the Fund Base Data Table (RFRBASE).
Fund Base Data Form (RFRBASE)
File Identifier No The File Identifier parameter determines whether you are using live or test data for this process.
P Production (live data) - default T Test (test data)
School Name Yes The name of the organization creating the data.
Recipient Name Yes The name of the organization that will receive this data.
5 Reports and Processes
Financial Aid Release 7.2 April 2005
5-26 Electronic Loan Handbook Confidential
Recipient ID Yes The unique identification number assigned to the organization receiving this file. For guarantors, this is the 3-digit number as listed in the CommonLine Reference Manual. For all others, this is the assigned 6-character number.
Media Type No Select media type. D Diskette
P PC (default) M Mainframe
T Tape
Application Code No Application code of the population selection. Select valid values from the Application Inquiry Form (GLIAPPL). If you enter a value for this parameter, you must also enter a value for the Selection ID and Creator ID of Selection ID parameters.
Application Inquiry Form (GLIAPPL)
Report Selection Query ID
No Selection ID of the population selection. Select valid values from the Population Selection Inquiry Form (GLISLCT). If you enter a value for this parameter, you must also enter a value for the Application Code and Creator ID of Selection ID parameters.
Parameters (cont.) Name Required? Description Values
Creator ID of Selection ID
No The Banner ID of the person that created the population selection. Select valid values from the User Identification Control Form (GUAIDEN). If you enter a value for this parameter, you must also enter a value for the Selection ID and Application Code parameters.
Combine Sub/Unsub Stafford
No Combine Subsidized/Unsubsidized Stafford in one application record. Default is N.
Y - Yes
N - No (default)
Version Number No Create a CommonLine Release 4 or a CommonLine Release 5 file.
4
5 (Default)
EL School Code No The six-digit main campus code for the school.
When this parameter is utilized, only those loan applications with the corresponding EL School code and Branch ID in the Loan ID will be extracted.
EL Branch ID No The two-digit branch Campus ID associated with the main Campus code.When this parameter is utilized, only those loan applications with the corresponding EL School code and Branch ID in the Loan ID will be extracted.
Parameters (cont.) Name Required? Description Values
5 Reports and Processes
Financial Aid Release 7.2 April 2005
5-28 Electronic Loan Handbook Confidential
Electronic Loan Application Extract Sample
14-MAY-2002 03:15:32 PM Development 1 Aid Year: 0203 Electronic Loan Applications RPRELAX ---Student ID Name | FUND | RESULT/COMMENT
--- --- | --- | ---511000017 Brennan, DION L | SSUB | Selected for combined batching
214-MAY-2002 03:15:32 PM Development 2 Aid Year: 0203 Electronic Loan Applications RPRELAX ---Student ID Name | FUND | RESULT/COMMENT
--- --- | --- | ---511000016 Charlise, NICOLE I | SUEPL | Selected for standard batching 511000016 Charlise, NICOLE I | SUESUB | Selected for standard batching 511000017 Johnson, DION L | SUEALT | Selected for standard batching 511000019 Morgan, STACEY L | SUEALT | *ERROR* No Exp Grad Dt 511000019 Morgan, STACEY L | SUEALT | *ERROR* No Citizenship 511000019 Morgan, STACEY L | SUEALT | *ERROR* No Enroll Stat 511000019 Morgan, STACEY L | SUEALT | *ERROR* No Alt Loan SB Ind 511000019 Morgan, STACEY L | SUEALT | *ERROR* No Alt Borr Loan Debt 511000019 Morgan, STACEY L | SUEALT | *ERROR* No Citizenship 511000019 Morgan, STACEY L | SUEALT | *ERROR* No Credit in Diff Name 511000019 Morgan, STACEY L | SUEALT | Selected for standard batching
14-MAY-2002 03:15:32 PM Development 3
5 Reports and Processes
Financial Aid Release 7.2 April 2005
5-30 Electronic Loan Handbook Confidential