Financial Aid Reports: A to Z

Used to print the complete content of a selected equation.

Reporting Tool: Crystal or Oracle BI Publisher

select Set Up SACR, then select Common Definitions, then select Equation Engine, then select Print Equations

EQTN_PRT_RUN_CNTL

Used to review to whom each financial aid item type was awarded as well as whether the award has been disbursed to the student.

Reporting Tool: Crystal or Oracle BI Publisher

select Financial Aid, then select Fund Management, then select FA801 Award Data by Item Type

RUNCTL_FA_RPT_801

Used to review the number of students and the total amount awarded for each financial aid item type in a particular packaging plan during a Mass Packaging run.

Reporting Tool: Crystal

select Financial Aid, then select Awards, then select Mass Packaging Summary Report

RUNCTL_FA_RPT_821

Used to review the award package for each student awarded during a Mass Packaging run. The students are organized by packaging plan.

Reporting Tool: Crystal

select Financial Aid, then select Awards, then select Mass Packaging, then select Mass Packaging Detail Report

RUNCTL_FA_RPT_822

Review the PNote Transmission Status for 1999/2000 PNotes and MPNs − can also be used to review institutional PNotes if they are defined as a loan document. Use after Loan Origination and Pnotes have been created.

Reporting Tool: Crystal

select Financial Aid, then select Loans, then select View Loan Status Reports, then select Loan PNote Summary

RUNCTL_FA_LN_RPT

Review and monitor originated loans accepted by the LOC.

Reporting Tool: Crystal or Oracle BI Publisher

select Financial Aid, then select Loans, then select Direct Lending Reconciliation, then select Accepted Originations Report

RUN_CNTL_FA853_RPT

Review and monitor loans placed on hold. Loans are placed on hold by the system when rejected origination acknowledgement, origination change acknowledgement, and disbursement acknowledgement files are received. You can also place loans on hold manually. Use after every import function.

Reporting Tool: Crystal

select Financial Aid, then select Loans, then select Direct Lending Reconciliation, then select Loans on Hold Report

RUN_CNTL_FA854_RPT

Review and monitor loans placed on hold. Loans are placed on hold by the system when rejected origination acknowledgement, origination change acknowledgement, and disbursement acknowledgement files are received. You can also place loans on hold manually. Use after every import function.

Reporting Tool: Oracle BI Publisher

select Financial Aid, then select Loans, then select Direct Lending Reconciliation, then select Loans on Hold Report

RUN_CNTL_FA854_RPT

Provides a list of decision statuses for PLUS loans, allowing you to advise the parent whether they qualify, need a cosigner, etc. Use after you receive the PLUS origination acknowledgement file.

Reporting Tool: Crystal or Oracle BI Publisher

select Financial Aid, then select Loans, then select Direct Lending Reconciliation, then select PLUS Credit Decision

RUN_CNTL_FA855_RPT

Review and monitor origination and origination change acknowledgements rejected by the LOC. This report assists you in identifying the reject reason(s). Use after the origination acknowledgement file is imported.

Reporting Tool: Crystal

select Financial Aid, then select Loans, then select Direct Lending Reconciliation, then select Rejected Originations Report

RUN_CNTL_FA856_RPT

Review and monitor origination and origination change acknowledgements rejected by the LOC. This report assists you in identifying the reject reason(s). Use after the origination acknowledgement file is imported.

Reporting Tool: Oracle BI Publisher

select Financial Aid, then select Loans, then select Direct Lending Reconciliation, then select Rejected Originations Report

RUN_CNTL_FA856_RPT

Review and monitor originations submitted to the LOC. The report is a cumulative list of originations. This allows you to track transmitted origination files and identify transmitted origination files that may have outstanding acknowledgments.

Reporting Tool: Crystal or Oracle BI Publisher

select Financial Aid, then select Loans, then select Direct Lending Reconciliation, then select Origination Export Report

RUN_CNTL_FA857_RPT

Review and monitor transmitted changes made to previously originated loans. Use after sending out Origination Change files.

Reporting Tool: Crystal or Oracle BI Publisher

select Financial Aid, then select Loans, then select Direct Lending Reconciliation, then select Origination Changes Report

RUN_CNTL_FA858_RPT

Review and monitor changes made to loan records that are waiting for acknowledgements from transmitted origination data (Loan Action Status = T—Transmitted) previously submitted to the LOC. Run this in between importing and exporting Origination and Change files.

Reporting Tool: Crystal

select Financial Aid, then select Loans, then select Direct Lending Reconciliation, then select Origination Change Report

RUN_CNTL_FA859_RPT

Review and monitor validation rejects. This report is designed to assist you in resolving potential errors prior to outbounding Origination records. Use after you run the validation process.

Reporting Tool: Crystal

select Financial Aid, then select Loans, then select Direct Lending Reconciliation, then select Validation Errors Report

RUN_CNTL_FA860_RPT

Review and monitor validation rejects. This report is designed to assist you in resolving potential errors prior to outbounding Origination records. Use after you run the validation process.

Reporting Tool: Oracle BI Publisher

select Financial Aid, then select Loans, then select Direct Lending Reconciliation, then select Validation Errors Report

RUN_CNTL_FA860_RPT

Review and monitor disbursements rejected by the LOC. The report assists you in resolving errors reported on the Disbursement Acknowledgement file. Use after the disbursement acknowledgement has been imported.

Reporting Tool: Crystal or Oracle BI Publisher

select Financial Aid, then select Loans, then select Direct Lending Reconciliation, then select Disbursement Errors Report

RUN_CNTL_FA866_RPT

Review and monitor disbursement status and booked status for loans. Use weekly.

Reporting Tool: Crystal or Oracle BI Publisher

select Financial Aid, then select Loans, then select Direct Lending Reconciliation, then select Disbursement Status Report

RUN_CNTL_FA867_RPT

Review and monitor Disbursement Booked and Unbooked status. Designed for use with Reconciliation Processing. Use weekly.

Reporting Tool: Crystal or Oracle BI Publisher

select Financial Aid, then select Loans, then select Direct Lending Reconciliation, then select Disbursement Booking Report

RUN_CNTL_FA868_RPT

Review and monitor Federal Pell Grant Fund allocations.

Reporting Tool: Crystal or Oracle BI Publisher

select Financial Aid, then select Pell Payment, then select Cash Management Reports, then select Print Grant ESOA

RUN_CNTL_PG_ESOA

Generate a list of students who are in an origination year-to-date file sent by RFMS.

Reporting Tool: Crystal or Oracle BI Publisher

select Financial Aid, then select Pell Payment, then select Year To Date Reports, then select YTD Originations

RUN_CNTL_PGOYTD_AL

Generate a list of students who have been disbursed as of the year to date.

Reporting Tool: Crystal or Oracle BI Publisher

select Financial Aid, then select Pell Payment, then select Year To Date Reports, then select YTD Disbursements

RUN_CNTL_PGDYTD_AL

Review and monitor POP (potential overaward payment) and Blocked Institution situation by specific batches. Use after the MRR inbound file is imported.

Reporting Tool: Crystal or Oracle BI Publisher

select Financial Aid, then select Pell Payment, then select Multiple Reporting, then select MRR by Batch

RUN_CNTL_FA_875_RPT

Review and monitor POP (potential overaward payment) and Blocked Institution situation. Use after the MRR inbound file is imported.

Reporting Tool: Crystal or Oracle BI Publisher

select Financial Aid, then select Pell Payment, then select Multiple Reporting, then select MRR Report

RUN_CNTL_PG_MRR

Review and monitor POP (potential overaward payment) and Blocked Institution situation by specific Status codes. Use after the MRR inbound file is imported.

Reporting Tool: Crystal or Oracle BI Publisher

select Financial Aid, then select Pell Payment, then select Multiple Reporting, then select MRR by Status

RUN_CNTL_FA875B_RP

Review and monitor students’ originations by action code.

Reporting Tool: Crystal or Oracle BI Publisher

select Financial Aid, then select Pell Payment, then select Origination Reports, then select Originations by Action Code

RUN_CNTL_PG_OACTN

Review and monitor students’ disbursements by action code.

Reporting Tool: Crystal or Oracle BI Publisher

select Financial Aid, then select Pell Payment, then select Disbursement Reports, then select Disbursements by Action Code

RUN_CNTL_PG_DACTN

Review and monitor from your Pell population what has been originated and whether the records have been imported or exported from the application tables.

Use after you have run the origination process and after origination records have been exported, or after origination acknowledgement files have been imported.

Reporting Tool: Crystal or Oracle BI Publisher

select Financial Aid, then select Pell Payment, then select Origination Reports, then select Origination Import and Export

RUN_CNTL_FA878_RPT

Review and monitor originations and current origination status. Displays status of all origination records. You can run the report for one of seven different statuses: Accepted, Corrected, Originated, Rejected, Transmitted, Changed to Origination, and Cancelled.

Reporting Tool: Crystal or Oracle BI Publisher

select Financial Aid, then select Pell Payment, then select Origination Reports, then select Origination Status

RUN_CNTL_FA879_RPT

Determines which detail records are included in a specific batch.

Reporting Tool: Crystal

select Financial Aid, then select Pell Payment, then select Origination Reports, then select Originations by Batch

RUN_CNTL_FA880_RPT

Determines which Pell origination records are rejected by RFMS in a specific batch.

Reporting Tool: Crystal

select Financial Aid, then select Pell Payment, then select Origination Reports, then select Rejected Originations by Batch

RUN_CNTL_FA880A_RP

Review detail records included in a specific batch.

Reporting Tool: Crystal

select Financial Aid, then select Pell Payment, then select Disbursement Reports, then select Disbursements by Batch

RUN_CNTL_FA881_RPT

Review and monitor Pell Disbursement records rejected by RFMS in a specific batch.

Reporting Tool: Crystal

select Financial Aid, then select Pell Payment, then select Disbursement Reports, then select Rejected Disbursement by Batch

RUN_CNTL_FA881_RP

Review and monitor students in different transaction statuses. You can run the report by using one of five different statuses: Cancel, On Hold, Ready, Review, and Transmitted.

Depending on the status, the report can be run after origination or disbursement inbound records have been imported.

Reporting Tool: Crystal or Oracle BI Publisher

select Financial Aid, then select Pell Payment, then select Origination Reports, then select Transaction Status

RUN_CNTL_FA882_RPT

Review and monitor which student records have either had disbursement requests made or actual disbursements acknowledged. Reports consist of all disbursement status types.

Reporting Tool: Crystal or Oracle BI Publisher

select Financial Aid, then select Pell Payment, then select Disbursement Reports, then select Disbursement Records

RUN_CNTL_FA883_RPT

Review or monitor the status of disbursement records that have been imported or exported. You can run the report for one of seven different statuses.

Reporting Tool: Crystal or Oracle BI Publisher

select Financial Aid, then select Pell Payment, then select Disbursement Reports, then select Disbursements by Status

RUN_CNTL_FA884_RPT

Review and monitor your cash management activity.

Reporting Tool: Crystal

select Financial Aid, then select Pell Payment, then select Cash Management Reports, then select Cash Management

RUN_CNTL_FA885_RPT

Review and monitor student disbursement records acknowledged by COD in a specific batch.

Reporting Tool: Crystal

select Financial Aid, then select Pell Payment, then select Disbursement Reports, then select Disbursement Acknowledgment

RUN_CNTL_PG_886

Lists students who have origination acknowledgement records by a specific batch.

Reporting Tool: Crystal

select Financial Aid, then select Pell Payment, then select Origination Reports, then select Origination Acknowledgement

RUN_CNTL_FA887_RPT

Select all students who have Pell awards (on the Awards pages) who do NOT have Pell Origination records.

Reporting Tool: Crystal or Oracle BI Publisher

select Financial Aid, then select Pell Payment, then select Origination Reports, then select Records With No Origination

RUN_CNTL_FA888_RPT

Review and monitor applications with CommonLine reject codes. The report does not report Change Transaction errors.

Use after loading Application Response files.

Reporting Tool: Crystal

select Financial Aid, then select Loans, then select Commonline Reconciliation, then select Rejected Application Report

RUN_CNTL_FA900_RPT

Review and monitor FFELP and Alternative loans placed on hold. Holds can be placed automatically by the CommonLine Loan In, CommonLine Loan Out and manually through the CommonLine Loan Orig Trans page.

Reporting Tool: Crystal or Oracle BI Publisher

select Financial Aid, then select Loans, then select Commonline Reconciliation, then select Loans on Hold Report

RUN_CNTL_FA901_RPT

Review originated loans that have failed the loan validation process. The report selects records that have failed validation and those that failed when run in simulation mode. Use post validation.

Reporting Tool: Crystal or Oracle BI Publisher

select Financial Aid, then select Loans, then select Commonline Reconciliation, then select Validation Error Report

RUN_CNTL_FA902_RPT

Reports all CommonLine 4 application response records that erred when the CommonLine Loan In process was run. The report displays information necessary to clear the error conditions so that the record loads. Use after loading Application Response files.

Setting the Load Status to Processed removes records from the report.

Reporting Tool: Crystal or Oracle BI Publisher

select Financial Aid, then select File Management, then select CommonLine Loans, then select CL4 Load Error Report

RUN_CNTL_FA903_RPT

Reports all School Certification requests delivered on a CommonLine 4 Application Response file. The report provides the information necessary to process the loan request. You must enter enough information about the borrower and loan so that the loan can be originated by the loan system. Use after running FA903 and detecting school certification request load errors.

Setting the Load Status to Processed removes records from the report.

Reporting Tool: Crystal or Oracle BI Publisher

select Financial Aid, then select Loans, then select Commonline Reconciliation, then select CL4 Certification Request Rpt

RUN_CNTL_FA904_RPT

Reports originated and transmitted loan records where a response from the loan agency has not been received.

A similar report can also be derived from the FA850 report.

Reporting Tool: Crystal

select Financial Aid, then select Loans, then select Commonline Reconciliation, then select Pending Response Report

RUN_CNTL_FA905_RPT

Reports selected financial aid item types where the awarded accept amount does not match the disbursed amount. Run daily.

Reporting Tool: Crystal or Oracle BI Publisher

select Financial Aid, then select Disbursement, then select Reconciliation Report

RUN_CNTL_FA906_RPT

Lists EFT disbursements where the EFT amount has not yet been disbursed. Sorted by EFT batch receipt date.

Run daily to insure that loan funds are disbursed and returned in compliance with federal regulations. Used in conjunction with the CommonLine Disbursement Maintenance page.

Reporting Tool: Crystal or Oracle BI Publisher

select Financial Aid, then select Loans, then select CommonLine Reconciliation, then select CL4 EFT Discrepancy Report

RUN_CNTL_FA907_RPT

Lists all loan checks tracked on the CommonLine Disbursement Maintenance page where the check amount does not match the amount paid on the student's account. The report displays the data on the CommonLine Disbursement Maintenance page.

Run daily to ensure that loan funds are disbursed and returned in compliance with federal regulations.

Reporting Tool: Crystal

select Financial Aid, then select Loans, then select Commonline Reconciliation, then select CL Check Reconciliation Report

RUN_CNTL_FA909_RPT

Provides a list of student disbursement records that have failed the authorization process.

Reporting Tool: Crystal or Oracle BI Publisher

select Financial Aid, then select Disbursement, then select Authorization Failure Report

RUN_CNTL_FA913_RPT

Provides a summary of all ISIR batches that have been loaded with statistics on the load status of the ISIRs in each batch.

Reporting Tool: Crystal

select Financial Aid, then select File Management, then select ISIR Import, then select ISIR Load Summary Report

RUNCTL_FA914

Used to review total offered, accepted, authorized, and disbursed amounts for the financial aid item types you specify. A list of students and their offered, accepted, authorized, and disbursed amounts is provided for each financial aid item type.

Reporting Tool: Crystal or Oracle BI Publisher

select Financial Aid, then select Fund Management, then select Fund Roster

RUN_CNTL_FA920_RPT

Provides a report of NSLDS Transfer Alert file records that were unable to load into the database. Users must resolve the error and rerun the NSLDS Load process to resolve the error.

Reporting Tool: Crystal or Oracle BI Publisher

select Financial Aid, then select File Management, then select NSLDS, then select NSLDS FAT Load Error Report

RUNCTL_FA921

Used to review a list of students who have been overawarded. Displays the amount of the overaward and information about the student's COA, EFC, need, and total over awarded amount.

Reporting Tool: Crystal or Oracle BI Publisher

select Financial Aid, then select Awards, then select Generate Overaward Report

RUN_CNTL_FA922_RPT

Review records reconciled with COD.

Reporting Tool: Crystal

select Financial Aid, then select Pell Payment, then select Cash Management Reports, then select Reconciliation Report

RUN_CNTL_FA_923_RPT

Provides a report that displays the NSLDS change flags for loaded NSLDS records that have not yet been reviewed by the staff. This report matches what is displayed in the NSLDS Change Review page.

Reporting Tool: Crystal

select Financial Aid, then select File Management, then select NSLDS, then select NSLDS Alert File Report

RUNCTL_FA924

Provides a summary of all ISIR batches that have been loaded with statistics on the load status of the ISIRs in each batch.

Reporting Tool: Crystal or Oracle BI Publisher

select Financial Aid, then select File Management, then select ISIR Import, then select ISIR Load Summary Report

RUNCTL_FA914

Identifies why a system generated ISIR record was created. Run prior to loading system generated ISIR files. You may want to suspend all system generated files before running this report because suspending the file causes the student's ID to be determined and printed on the report.

Reporting Tool: Crystal

select Financial Aid, then select File Management, then select ISIR Import, then select System Generated ISIR Report

SFA_RUNCTL_FA928

Provides a detailed report of all ISIRs that suspended or are set to error by the ISIR Load program. Data on the report derives from the ISIR Suspense Management page. Run after the FAPSAR00 process is run.

Reporting Tool: Crystal or Oracle BI Publisher

select Financial Aid, then select File Management, then select ISIR Import, then select ISIR Suspense Detail Report

RUNCTL_FA927

Lists EFT disbursements where the EFT amount received does not equal the amount paid.

Run daily to insure that loan funds are disbursed and returned in compliance with federal regulations. Used in conjunction with the CommonLine Disbursement Maintenance page.

Reporting Tool: Crystal or Oracle BI Publisher

select Financial Aid, then select Loans, then select CommonLine Reconciliation, then select CL4 EFT Discrepancy Report

RUN_CNTL_FA907_RPT

Lists EFT disbursements where the EFT amount received is > 0 and the paid amount = 0.

Run daily to insure that loan funds are disbursed and returned in compliance with federal regulations. Used in conjunction with the CommonLine Disbursement Maintenance page.

Reporting Tool: Crystal or Oracle BI Publisher

select Financial Aid, then select Loans, then select CommonLine Reconciliation, then select CL4 EFT Discrepancy Report

RUN_CNTL_FA907_RPT

Returns all loans for a specified booking status, aid year, and institution. Use after you inbound the disbursement file or whenever necessary.

Reporting Tool: SQR

select Financial Aid, then select Loans, then select Direct Lending Reconciliation, then select Booking Status Report

RUN_CNTL_FADLBOOK

Identifies mismatched statuses between origination, disbursements, and the DLSAS booking status. Use after the DLSAS file has been imported and processed.

Reporting Tool: SQR

select Financial Aid, then select Loans, then select Direct Lending Reconciliation, then select Report Disbursement Exception Summary

RUNCTL_FA_EXCEP_LN

Identifies differences between an imported DLSAS file and system data.

Reporting Tool: SQR

select Financial Aid, then select Loans, then select DL School Account Summary, then select Generate Reconciliation Report

RUNCTL_DL_RECON

Review Cash Summary Section, Cash Detail Section and the Loan Detail Section of the DSAS file received from the LOC. Use after the DSAS file has been imported to the EDI Manager staging tables.

Reporting Tool: SQR

select Financial Aid, then select Loans, then select DL School Account Summary, then select Generate DLSAS Report

RUNCTL_DLSAS

Creates a report that lists students who have assumptions and/or rejects that have no respective overrides made to them or who have overrides made but no assumptions or rejects. Use this list to identify which students need to have assumption overrides applied manually. This report is not aid-year specific.

Reporting Tool: SQR

select Financial Aid, then select File Management, then select ISIR Import, then select CPS Reject/Assumption Report

RUNCNTL_FAISRJAS

Generates a PLUS loan manifest. Use after PLUS notes have been signed and received.

Reporting Tool: SQR

select Financial Aid, then select Loans, then select Direct Lending Management, then select Print Manifest Report Plus

RUNCTL_MANIFEST2

Generates a Stafford loan manifest. Use after MPNs have been signed and received.

Reporting Tool: SQR

select Financial Aid, then select Loans, then select Direct Lending Management, then select Print Manifest Report Stafford

RUNCTL_MANIFEST3

Review the origination change files the COD rejected. Run before you inbound the Origination Change Acknowledgement file.

Reporting Tool: SQR

select Financial Aid, then select Loans, then select Direct Lending Management, then select Rejected Origination Changes

RUN_CNTL_DL_RPT

View worksheet calculations, return of funds by school and student, institutional charges, number of days since the withdrawal date, and career totals.

Reporting Tool: SQR

select Financial Aid, then select Return of Title IV Funds, then select Return of TIV Aid Report

RUN_CNTL_FATIVRTN

Used to review internally maintained aggregate data and the NSLDS reported total pushed into the aggregate aid table.

Reporting Tool: Crystal

select Financial Aid, then select Awards, then select Aggregates, then select Review Lifetime Aggregate, then select Lifetime Aggregate Report

SFA_RUN_AGGR_RPT

Used to list all inbound transactions that have not loaded into the application tables due to an error during the CRC Inbound process.

Reporting Tool: Crystal

select Financial Aid, then select File Management, then select CommonLine Loans, then select CRC Load Error Report

SFA_CRC_903_RPT

Used to list all processed records in selected disbursement roster (EFT) or disbursement forecast files.

Reporting Tool: Crystal

select Financial Aid, then select Loans, then select CommonLine Reconciliation, then select CRC EFT Reconciliation Report

SFA_CRC_EFT_RPT

Used to view undisbursed roster transactions.

Reporting Tool: Crystal

select Financial Aid, then select Loans, then select CommonLine Reconciliation CRC EFT Discrepancy Reports

SFA_CRC_EFT_PD_RPT

Used to view CRC paid amounts not equal to EFT amount.

Reporting Tool: Crystal

select Financial Aid, then select Loans, then select CommonLine Reconciliation CRC EFT Discrepancy Reports

SFA_CRC_EFT_PD_RPT