Financial Aid Reports: A to Z
This table lists the Financial Aid reports, sorted 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 |
|
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 |
|
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 |
|
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 |
|
RUNCTL_FA_LN_RPT |
|
FA853 DL Accepted Originations |
Reports originated loans accepted by the LOC. Reporting Tool: Oracle BI Publisher |
|
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 |
|
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 |
|
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 |
|
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 |
|
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 |
|
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 |
|
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 |
|
RUN_CNTL_FA866_RPT |
|
FA867 DL Disbursement Status |
Reports disbursement status and booked status for loans. Use weekly. Reporting Tool: Oracle BI Publisher |
|
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 |
|
RUN_CNTL_FA868_RPT |
|
FA870 Print Pell Grant ESOA |
Reports Federal Pell Grant Fund allocations. Reporting Tool: Oracle BI Publisher |
|
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 |
|
RUN_CNTL_PGOYTD_AL |
|
FA873 YTD Disbursements |
Reports students who have been disbursed as of the year to date. Reporting Tool: Oracle BI Publisher |
|
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 |
|
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 |
|
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 |
|
RUN_CNTL_FA875B_RP |
|
FA876 Pell Originations by Action Code |
Reports students’ originations by action code. Reporting Tool: Oracle BI Publisher |
|
RUN_CNTL_PG_OACTN |
|
FA877 Pell Disbursements by Action Code |
Reports students’ disbursements by action code. Reporting Tool: Oracle BI Publisher |
|
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 |
|
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 |
|
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 |
|
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 |
|
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 |
|
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 |
|
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 |
|
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 |
|
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 |
|
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 |
|
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 |
|
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 |
|
RUN_CNTL_FA907_RPT |
|
FA913 Authorization Failure Report |
Reports student disbursement records that have failed the authorization process. Reporting Tool: Oracle BI Publisher |
|
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 |
|
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 |
|
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 |
|
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 |
|
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 |
|
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 |
|
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 |
|
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 |
|
RUNCTL_FA_EXCEP_LN |
|
FADLRECN DL Reconciliation Report |
Reports differences between an imported DLSAS file and system data. Reporting Tool: SQR |
|
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 |
|
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 |
|
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 |
|
RUNCTL_MANIFEST2 |
|
FAMANFS3 DL Print Manifest Report Staf |
Generates a Stafford loan manifest. Use after MPNs have been signed and received. Reporting Tool: SQR |
|
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 |
|
RUN_CNTL_DL_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 |
|
RUN_CNTL_FATIVRTN |