Appendix: Financial Aid Reports

This appendix provides an overview of Financial Aid reports and enables you to view a summary table of all reports.

Note. For samples of these reports, see the Portable Document Format (PDF) files published on CD-ROM with your documentation.

See Also

PeopleSoft PeopleTools PeopleBook: Process Scheduler

Click to jump to top of pageClick to jump to parent topicFinancial Aid Reports: A to Z

This table lists the Financial Aid reports, sorted alphanumerically by report ID.

Report ID and Report Name

Description

Navigation

Run Control Page

SFA_AGGR

Lifetime Aggregates

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

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

SFA_RUN_AGGR_RPT

FA801

Award Data by Item Type

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

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

RUNCTL_FA_RPT

FA821

Batch Packaging Summary

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.

Financial Aid, Mass Packaging, Mass Packaging Summary Report

RUNCTL_FA_RPT_821

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.

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

RUNCTL_FA_RPT_822

FA852

Loan Status Reports—Loan PNote Summary

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.

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

RUNCTL_FA_LN_RPT

Accepted Originations

DL Accepted Originations

Review and monitor originated loans accepted by the LOC.

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

RUN_CNTL_FA853_RPT

FA854

DL Loans on Hold

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.

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

RUN_CNTL_FA854_RPT

FA855

DL PLUS Credit Decision

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.

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

RUN_CNTL_FA855_RPT

FA856

DL Rejected Originations

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

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

RUN_CNTL_FA856_RPT

FA857

DL Transmitted Originations

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.

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

RUN_CNTL_FA857_RPT

FA858

DL Pending Origination Changes

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

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

RUN_CNTL_FA858_RPT

FA859

DL Transmitted Change Pending

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.

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

RUN_CNTL_FA859_RPT

FA860

DL Validation Errors

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.

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

RUN_CNTL_FA860_RPT

FA861

DL Inbound Orig Ackn Errors

Review and monitor inbound student record(s) not loaded into the system because the inbound student record contained IDs that do not match existing ID's in current database. This report allows you to identify and correct conflicts. Use after Inbound files are loaded into the system.

Note. This report only exists for Origination. Reports for other Direct Lending processes may be available in the future.

Financial Aid, Loans, Direct Lending Reconciliation, Inbound Errors Report

RUN_CNTL_FA861_RPT

FA866

DL Disbursement Errors

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.

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

RUN_CNTL_FA866_RPT

FA867

DL Disbursement Status

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

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

RUN_CNTL_FA867_RPT

FA868

DL Disbursement Booking Stat

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

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

RUN_CNTL_FA868_RPT

FA870

Print Pell Grant ESOA

Review and monitor Federal Pell Grant Fund allocations.

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

RUN_CNTL_PG_ESOA

FA871

YTD Originationsi

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

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

RUN_CNTL_PGOYTD_AL

FA872

YTD Originations Errors

Review conflicting information from RFMS and your application tables.

Financial Aid, Pell Payment, Year To Date Reports, YTD Originations Errors

RUN_CNTL_PGOYTD_ER

FA873

YTD Disbursements

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

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

RUN_CNTL_PGDYTD_AL

FA874

YTD Disbursement Errors

Review conflicting information from RFMS and your application tables.

Financial Aid, Pell Payment, Year To Date Reports, YTD Disbursement Errors

RUN_CNTL_PGDYTD_ER

FA875

Pell MRR Report by Batch

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

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

RUN_CNTL_FA_875_RPT

FA875A

Pell MRR Report

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

Financial Aid, Pell Payment, Multiple Reporting, MRR Report

RUN_CNTL_PG_MRR

FA875B

Pell MRR Report by MRR Status

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

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

RUN_CNTL_FA875B_RP

FA876

Pell Originations by Action Cd

Review and monitor students whose originations are acknowledged.

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

RUN_CNTL_PG_OACTN

FA877

Pell Disbursements by Action Cd

Review or monitor all students whose Disbursement records have been acknowledged.

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

RUN_CNTL_PG_DACTN

FA878

Pell Origination Records

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.

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

RUN_CNTL_FA878_RPT

FA879

Pell Origination by Orig Stat

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.

Financial Aid, Pell Payment, Origination Reports, Origination Status

RUN_CNTL_FA879_RPT

FA880

Pell Originations by Batch

Determines which detail records are included in a specific batch.

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

RUN_CNTL_FA880_RPT

FA880A

Rejected Pell Originations by Batch

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

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

RUN_CNTL_FA880A_RP

FA881

Pell Disbursements by Batch

Review detail records included in a specific batch.

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

RUN_CNTL_FA881_RPT

FA881A

Pell Disbursements by Batch

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

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

RUN_CNTL_FA881_RPT

FA882

Pell Records by Trans Stat

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.

Financial Aid, Pell Payment, Origination Reports, Transaction Status

RUN_CNTL_FA882_RPT

FA883

Pell Disbursement Records

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

Financial Aid, Pell Payment, Disbursement Reports, Disbursement Records

RUN_CNTL_FA883_RPT

FA884

Disbursements by Dsb Stat

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.

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

RUN_CNTL_FA884_RPT

FA885

Pell Cash Management

Review and monitor your cash management activity.

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

RUN_CNTL_FA885_RPT

FA886

Pell Disbursement Ackn Batch

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

Financial Aid, Pell Payment, Disbursement Reports, Disbursement Acknowledgment

RUN_CNTL_FA886RPT_GBL

FA887

Pell Origination Acknowledgements by Batch

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

Financial Aid, Pell Payment, Origination Reports, Origination Acknowledgement

RUN_CNTL_FA887_RPT

FA888

Pell Awds w/o Orig

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

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

RUN_CNTL_FA888_RPT

FA900

CL Rejected Application

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

Use after loading Application Response files.

Financial Aid, Loans ,Commonline Reconciliation, Rejected Application Report

RUN_CNTL_FA900_RPT

FA901

CommonLine Loans on Hold

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.

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

RUN_CNTL_FA901_RPT

FA902

CommonLine Validation Errors

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.

Financial Aid, Loans, Commonline Reconciliation, 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.

Financial Aid, Loans, Commonline Loans, CL 4 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.

Financial Aid, Loans, Commonline Reconciliation, Certification Request Report

RUN_CNTL_FA904_RPT

FA905

CommonLine Application Response Delinquencies

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.

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

RUN_CNTL_FA905_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.

Financial Aid, Disbursement, Reconciliation Report

RUN_CNTL_FA906_RPT

FA907

CommonLine 4 EFT Reconciliation

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.

Financial Aid, Loans, Commonline Reconciliation, EFT Discrepancy Reports

RUN_CNTL_FA907_RPT

FA909

CommonLine Check Reconciliation

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. he 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.

Financial Aid, Loans, Commonline Reconciliation, Check Reconciliation Report

RUN_CNTL_FA909_RPT

FA914

ISIR Load Summary

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

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

RUNCTL_FA914

FA919

ISIR Suspense Detail

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.

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

RUNCTL_FA919

FA920

Fund Roster

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.

Financial Aid, Fund Management, Fund Roster

RUN_CNTL_FA920_RPT

FA921

NSLDS FAT Load Errors

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.

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

RUNCTL_FA921

FA922

Overaward Report

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.

Financial Aid, Awards, Generate Overaward Report

RUN_CNTL_FA922_RPT

FA923

Pell Reconciliation Report

Review records reconciled with RFMS.

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

RUN_CNTL_FA_923_RPT

FA924

NSLDS Alert File Report

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.

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

RUNCTL_FA924

FA925

System Generated ISIRs

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 will cause the student’s ID to be determined and printed on the report.

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

SFA_RUNCTL_FA928

FADLBOOK

DL Originations Booking Status

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

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

RUN_CNTL_FADLBOOK

FADLEXCP

DL Disbursement Exceptions

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

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

RUNCTL_FA_EXCEP_LN

FADLSAS

DL School Account Statement

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.

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

RUNCTL_DLSAS

FAHDLXX

Hold File

SQR Report that produces a printable copy of the daily HOLD0XOP file sent by the CPS. Run daily.

Financial Aid, File Management, ISIR Import, Process Signature Hold Filet

RUNCTL_FAHLDXX

FAISRJAS

ISIR assumption/reject override

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.

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

RUNCNTL_FAISRJAS

FALPNERR

DL PNote Error

Takes PNote reject codes from the PNote acknowledge file and lists by PNote ID and error type. Use after you receive your Promissory Acknowledgement file.

Financial Aid, Loans, Direct Lending Disbursements, Disbursement Errors

RUN_CNTL_DL_RPT

FAMANFS2

DL Print Manifest Report Plus

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

Financial Aid, Loans, Direct Lending Management, 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.

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

RUNCTL_MANIFEST3

FAORIGRJ

DL Rejected Origination Changes

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

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

RUN_CNTL_DL_RPT

FATIVRTN

Return of TIV Funds Report

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

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

RUN_CNTL_FATIVRTN