Financial Aid Reports: A to Z

This table lists the Financial Aid reports, sorted alphabetically by Report ID.

Report ID and Report Name Description Navigation Run Control Page

FA753

Equation Report

Print the complete content of a selected equation.

Reporting Tool: Oracle BI Publisher

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

EQTN_PRT_RUN_CNTL

FA801

Award Data by Item Type

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

Reporting Tool: Oracle BI Publisher

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

RUNCTL_FA_RPT_801

FA822

Batch Packaging Detail

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

Reporting Tool: Oracle BI Publisher

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

RUNCTL_FA_RPT_822

FA850

Direct Loan Origination Authorization Summary

Provides a summary of Originated records which passed the Origination Validation and are ready to be sent to COD. This report should be run after running the Loan Origination and Direct Loan Outbound processes having origination and Validate check box checked on the run control page.

Reporting Tool: Oracle BI Publisher

Financial Aid, and then Loans, and then Direct Lending Reconciliation, and then Origination Auth Report

RUNCTL_FA_LN_RPT

FA853

DL Accepted Originations

Reports originated loans accepted by the LOC.

Reporting Tool: Oracle BI Publisher

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

RUN_CNTL_FA853_RPT

FA854A

DL Loans on Hold

Reports 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

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

RUN_CNTL_FA854_RPT

FA855

DL PLUS Credit Decision

Reports 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: Oracle BI Publisher

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

RUN_CNTL_FA855_RPT

FA856A

DL Rejected Originations

Reports 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

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

RUN_CNTL_FA856_RPT

FA857

DL Transmitted Originations

Reports 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: Oracle BI Publisher

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

RUN_CNTL_FA857_RPT

FA858

DL Pending Origination Changes

Reports transmitted changes made to previously originated loans. Use after sending out Origination Change files.

Reporting Tool: Oracle BI Publisher

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

RUN_CNTL_FA858_RPT

FA860A

DL Validation Errors

Reports 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

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

RUN_CNTL_FA860_RPT

FA866

DL Disbursement Errors

Reports 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: Oracle BI Publisher

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

RUN_CNTL_FA866_RPT

FA867

DL Disbursement Status

Reports disbursement status and booked status for loans. Use weekly.

Reporting Tool: Oracle BI Publisher

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

RUN_CNTL_FA867_RPT

FA868

DL Disbursement Booking Stat

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

Reporting Tool: Oracle BI Publisher

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

RUN_CNTL_FA868_RPT

FA870

Print Pell Grant ESOA

Reports Federal Pell Grant Fund allocations.

Reporting Tool: Oracle BI Publisher

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

RUN_CNTL_PG_ESOA

FA871

YTD Originations

Reports students who are in an origination year-to-date file sent by COD.

Reporting Tool: Oracle BI Publisher

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

RUN_CNTL_PGOYTD_AL

FA873

YTD Disbursements

Reports students who have been disbursed as of the year to date.

Reporting Tool: Oracle BI Publisher

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

RUN_CNTL_PGDYTD_AL

FA875

Pell MRR Report by Batch

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

Reporting Tool: Oracle BI Publisher

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

RUN_CNTL_FA_875_RPT

FA875A

Pell MRR Report

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

Reporting Tool: Oracle BI Publisher

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

RUN_CNTL_PG_MRR

FA875B

Pell MRR Report by MRR Status

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

Reporting Tool: Oracle BI Publisher

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

RUN_CNTL_FA875B_RP

FA876

Pell Originations by Action Code

Reports students’ originations by action code.

Reporting Tool: Oracle BI Publisher

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

RUN_CNTL_PG_OACTN

FA877

Pell Disbursements by Action Code

Reports students’ disbursements by action code.

Reporting Tool: Oracle BI Publisher

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

RUN_CNTL_PG_DACTN

FA878

Pell Origination Records

Reports from your Pell Grant 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: Oracle BI Publisher

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

RUN_CNTL_FA878_RPT

FA879

Pell Origination by Orig Stat

Reports 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: Oracle BI Publisher

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

RUN_CNTL_FA879_RPT

FA882

Pell Records by Trans Stat

Reports 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: Oracle BI Publisher

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

RUN_CNTL_FA882_RPT

FA883

Pell Disbursement Records

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

Reporting Tool: Oracle BI Publisher

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

RUN_CNTL_FA883_RPT

FA884

Disbursements by Dsb Stat

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

Reporting Tool: Oracle BI Publisher

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

RUN_CNTL_FA884_RPT

FA888

Pell Awds w/o Orig

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

Reporting Tool: Oracle BI Publisher

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

RUN_CNTL_FA888_RPT

FA901

CommonLine Loans on Hold

Reports 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: Oracle BI Publisher

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

RUN_CNTL_FA901_RPT

FA902

CommonLine Validation Errors

Reports 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: Oracle BI Publisher

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

RUN_CNTL_FA902_RPT

FA903

CommonLine 4 Application Response Load Errors

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: Oracle BI Publisher

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

RUN_CNTL_FA903_RPT

FA904

CommonLine 4 School Certification Requests

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: Oracle BI Publisher

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

RUN_CNTL_FA904_RPT

FA906

Award vs. Disbursement Reconciliation

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

Reporting Tool: Oracle BI Publisher

Financial Aid, and then Disbursement, and then Reconciliation Report

RUN_CNTL_FA906_RPT

FA907

CommonLine 4 EFT Reconciliation

Reports 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: Oracle BI Publisher

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

RUN_CNTL_FA907_RPT

FA913

Authorization Failure Report

Reports student disbursement records that have failed the authorization process.

Reporting Tool: Oracle BI Publisher

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

RUN_CNTL_FA913_RPT

FA920

Fund Roster

Reports 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: Oracle BI Publisher

Financial Aid, and then Fund Management, and then Fund Roster

RUN_CNTL_FA920_RPT

FA921

NSLDS FAT Load Errors

Reports 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: Oracle BI Publisher

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

RUNCTL_FA921

FA922

Overaward Report

Reports 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: Oracle BI Publisher

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

RUN_CNTL_FA922_RPT

FA927

ISIR Suspense Detail

Reports 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: Oracle BI Publisher

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

RUNCTL_FA927

FA9071

CL4 EFT Received/Paid Amount Discrepancy

Reports 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: Oracle BI Publisher

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

RUN_CNTL_FA907_RPT

FA9072

CL4 EFT Undisbursed EFT

Reports 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: Oracle BI Publisher

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

RUN_CNTL_FA907_RPT

FADLBOOK

DL Originations Booking Status

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

Reporting Tool: SQR

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

RUN_CNTL_FADLBOOK

FADLEXCP

DL Disbursement Exceptions

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

Reporting Tool: SQR

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

RUNCTL_FA_EXCEP_LN

FADLRECN

DL Reconciliation Report

Reports differences between an imported DLSAS file and system data.

Reporting Tool: SQR

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

RUNCTL_DL_RECON

FADLSAS

DL School Account Statement

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

Reporting Tool: SQR

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

RUNCTL_DLSAS

FAISRJAS

ISIR assumption/reject override

Reports 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

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

RUNCNTL_FAISRJAS

FAMANFS2

DL Print Manifest Report Plus

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

Reporting Tool: SQR

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

RUNCTL_MANIFEST2

FAMANFS3

DL Print Manifest Report Staf

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

Reporting Tool: SQR

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

RUNCTL_MANIFEST3

FAORIGRJ

DL Rejected Origination Changes

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

Reporting Tool: SQR

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

RUN_CNTL_DL_RPT

FAPELLDV

PELL Disbursement Validation Report

Reports students who have Pell Disbursement validation errors.

Reporting Tool: Oracle BI Publisher

Financial Aid, and then Pell Payment, and then PELL Validation Reports, and then PELL Disbt Validation report

SFA_PELL_OBERR_RPT

FAPELLOV

PELL Origination Validation Report

Reports students who have Pell Origination validation errors.

Reporting Tool: Oracle BI Publisher

Financial Aid, and then Pell Payment, and then PELL Validation Reports, and then PELL Orig Validation report

SFA_PELL_OBERR_RPT

FATIVRTN

Return of TIV Funds Report

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

Reporting Tool: SQR

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

RUN_CNTL_FATIVRTN