RORFS09 - FISAP Report for the 2008-2009 Award Year

Each year Title IV-eligible schools must report the fiscal year’s final campus-based aid disbursed by fund type, as well as the number of students receiving such aid. This reporting is done through the FISAP (Fiscal Operations Report and Application to Participate) which includes data from the SunGard Banner Financial Aid, Student, and Accounts Receivable modules. Banner provides two grids needed to report this campus-based data. You must then transfer the data to the Department of Education’s FISAP web site.

Data Dictionary: 2009-2010 Supplemental Extract (RWPXX08)

This Data Dictionary contains a brief description of the data elements in the 2009-2010 Supplemental Extract. This extract provides student-specific information relative to changes made to federal methodology for 2009-2010.

ACG Eligibility Report-RWRACG01-Updated

This report identifiesstudents who are potentially eligible for the AC Grant.

RORFS08 - FISAP Report for the 2007-2008 Award Year

Each year Title IV-eligible schools must report the fiscal year’s final campus-based aid disbursed by fund type, as well as the number of students receiving such aid. This reporting is done through the FISAP (Fiscal Operations Report and Application to Participate) which includes data from the SunGard Banner Financial Aid, Student, and Accounts Receivable modules. Banner provides two grids needed to report this campus-based data. You must then transfer the data to the Department of Education’s FISAP web site.

RSRENRL - Financial Aid Enrollment Hours Process

The Financial Aid Enrollment Hours Process (RSRENRL) is the Banner job used to populate students' Financial Aid Hours on ROAENRL.

RORFS07 - FISAP Report for the 2006-07 Award Year

The FISAP (Fiscal Operations Report and Application to Participate) includes data from the Banner Financial Aid, Student, and Accounts Receivable modules. SunGard Banner provides clients with two grids needed to report this campus-based data. You must then transfer the data to the Department of Education’s FISAP web site.

RERGRNT (COD Miscellaneous Report) Replaces RERPELL

RERGRNT is a report that allows you to identify students who have Pell COD processing exceptions such as “W” verification codes, rejected origination/disbursement records, etc.

RWPXDHE – Financial Aid DHE Extract

In anticipation of having to provide student unit record data at some future time to the Connecticut Department of Higher Education, the Team created two new extracts for college use. The RWPXDHE process will produce both a standard extract in the DHE specified format as well as a custom community college extract.

RWRXR01 - Resource Report

This report provides detailed information on resources that have been posted to a student’s Banner record.

RORFS06 - FISAP Report for the 2005-06 Award Year

The FISAP (Fiscal Operations Report and Application to Participate) includes data from the SCT Banner Financial Aid, Student, and Accounts Receivable modules. SCT Banner provides clients with two grids needed to report this campus-based data. You must then transfer the data to the Department of Education’s FISAP web site.

The Application Cohort Report provides the user with a summary of application processing activity for the college for the chosen award year. Users can quickly receive data on total applications, completed applications, awards, and enrollment.

College staff can now use RWRXW01 and generate web reports for your college. From within Banner, merely run RWRXW01 from job submission as with any other process and report request. Web Reports can be run for any period beginning with the 2003-2004 Award Year. 2 new parameters have been added to RWRXW01. Parameters 2 and 3 allow the user to specify a “start date” and an “end date” within the award year period. A pop-up calendar is available to assist you with the date insertion. In this way, you can easily compare your web application activity during similar time frames – e.g. August 2004 volume to August 2005 volume.

This data dictionary contains a brief description of the data elements contained in this extract. This extract (RWPXX03) lists financial aid grants, loans and work that paid to students’ accounts during a specified term.

RORFS05 - FISAP Report for the 2004-05 Award Year

The FISAP (Fiscal Operations Report and Application to Participate) includes data from the SCT Banner Financial Aid, Student, and Accounts Receivable modules. SCT Banner provides clients with two grids needed to report this campus-based data. You must then transfer the data to the Department of Education’s FISAP web site.

RORFS04 - FISAP Report for the 2003-04 Award Year

The FISAP (Fiscal Operations Report and Application to Participate) includes data from the SCT Banner Financial Aid, Student, and Accounts Receivable modules. SCT Banner provides clients with two grids needed to report this campus-based data. You must then transfer the data to the Department of Education’s FISAP web site.

COD Import/Export Report (RERIMEX)

The COD Import/Export Report allows you to review all XML files that have been extracted from Banner for transmission to COD and/or to review COD responses that have been imported into your Banner system.

RERPELL (Pell COD Miscellaneous Report)

RERPELL has been replaced by RERGRNT. Please see description for RERGRNT above.

Data Dictionary: Financial Aid Award Extract (RWPXX02)

The Data Dictionary contains a brief description of the data elements in the Financial Aid Award Extract.

(RORFS03) - FISAP Report for the 2002-03 Award Year

Each year Title IV-eligible schools must report the fiscal year’s final campus-based aid disbursed by fund type, as well as the number of students receiving such aid. This reporting is done through the FISAP (Fiscal Operations Report and Application to Participate) which includes data from the SCT Banner Financial Aid, Student, and Accounts Receivable modules.

(RWRXL01) – Detailed Results

These detailed results pages will list the student’s Banner ID, Name, Letter Code and Delivery Method (emailed/printed) for each letter generated from the RWRXL01 process. A summation of the delivery method used is included at the end of the detailed results pages.

(RORFS02) – FISAP Report for the 2001-02 Award Year

RORFS02 is the Banner process/report that produces data for your college’s FISAP Report. Banner provides data and back-up documentation for the two grids of the FISAP - Part II, Section F, Information on Eligible Aid Applicants and Part VI, Section A, Distribution of Program Recipients and Expenditures by Type of Students.

RWRXE02 - Pell Grant/Perkins Data Report

This report selects students who are Pell Grant recipients and are also enrolled in an “occupational” certificate or degree program at the college.

RWRXE03 - Pell Grant Recipient Report

This report selects students who have received a disbursement of federal Pell Grant dollars in the chosen aid year.

Data Dictionary: Financial Aid Student Extract (RWPXX01)

The Data Dictionary contains a brief description of the data elements in the Financial Aid Student Extract.

Payroll Exception Report

The Payroll Exception Report was developed to identify student errors that may have occurred during the Payroll Load process. When a student appears on this report, the payroll load for that student is prevented. After you have corrected the error, the earnings of the student must be manually entered into Banner. This manual adjustment would be done on RJASEME (Student Employment Mass Entry Form).

(RJRSEEC) - Employee Earning Control Report

This report provides a listing of hours worked by pay period. You can run this report for all pay periods in the aid year or select both a starting and ending pay period range. This report can be run for just one student or for all students. The report output shows authorized hours and award amount, pay date, pay & hours worked, gross pay and status.

(RJRDPPR) - Departmental Pay Period Report

This report displays information for the monitoring of student earnings. You can produce this report for either a student, a department or multiple departments.

For each department/placements, this report lists the students assigned to that area, the student’s name, Banner ID, State Employee #, the authorized hours and work award, remaining eligibility (hours and award amount), percentage of award remaining, lat pay date and work status.

(RWRXJ01) - Student Employment Authorization Report

This report is actually a transaction form to be used by the financial aid office to transmit student authorizations and other related information to the college payroll office.

RWRXJ01 uses data from the RJASEAR form, the Student Employment Authorization Form, to determine report activity and populate the report. The “Activity Date” and “Status” date fields in the Authorizations block on the RJASEAR form are essential fields in the development of RWRXJ01.

(RORFS01) - FISAP Report

RORFS01 is the Banner process/report that produces data for your college’s FISAP Report. Banner provides data and back-up documentation for the two grids of the FISAP – Part II, Section F, Information on Eligible Aid Applications and Part VI, Section A, Distribution of Program Recipients and Expenditures by Type of Students. You will enter this data into the electronic FISAP software or FISAP on the Web for submission to the U.S. Department of Education

(RWRXG01) - Conn. Aid to Public College Students (CAPCS) Report

RWRXG01 is the end-of-year Connecticut Aid to Public College Students (CAPCS) Report, colloquially known as the CAP Report.

Output from this report provides data for submission to the Department of Higher Education.

RWRXT01 - Potential Unofficial Title IV Withdrawls Report

This report provides information on Title IV recipients who were enrolled at your college during a given term and earned no academic credit for that term.

(RPRVABN) - VA Benefits on FAFSA Report

RBRVABN is a report that identifies those students who have indicated on their FAFSAs that they will be receiving VA benefits during the parameter aid year.

(RWRXO01) - Consolidated Packaging Report

The Consolidated Packaging Report gives a variety of data on your financial aid applicants for the specified parameter aid year.

(RRREXIT) - Exit Interview Requirement Report

The Exit Interview Requirement Report (RRREXIT) will identify students who may require an exit interview. This process also posts the exit interview tracking requirement to the student’s record. Students selected must have had loans in any year which is less than or equal to the parameter year.

(RWRXE01) - Remaining Pell Eligibility Report

RWRXE01 is a report that will identify students who may have Pell Grant entitlement remaining for the summer session. This report lists students enrolled during the  academic year who have Pell Grant awards with remaining Pell Grant eligibility.  (Remaining Pell eligiblity is determined by the student’s scheduled Pell Grant award minus Pell Grant paid to date.  If the amount remaining is greater than zero, the student will appear on this report.)

(RERPELL) - The Pell RFMS Report

RERPELL is a report that allows you to identify students who have Pell RFMS processing exceptions such as “W” verification codes, rejected origination/disbursement records, etc.

(RPRLNAG) - The Loan Proceeds Aging Report

The Loan Proceeds Aging Report is used to identify any student for whom FFELP loan funds have been received in Banner but have not yet been disbursed to the student’s account.  RPRLNAG will show the number of days between the receipt of the student’s loan funds and the date the report is run.

(RWRXS01) - The Satisfactory Academic Progress Report

Lists Financial Aid students and their current SAP codes assigned in Banner.   The report shows Name, SSN, Banner ID, Term Code and SAP Status Code.  Depending on the value(s) you enter for Parameter 02, this report can be run for a specific SAP code, multiple codes, or for all codes.

(RWRXA01)  - The Bookstore Report.

Provides information needed to determine students’ eligibility for bookstore charges.  The team prepared this report for you to use as a tool when granting bookstore charges.

(RPRAWRD)- Applicant Award Report

The Applicant Award Report is a detailed report on applicant awards for the current aid year.

(RRRAREQ) - Applicant Requirements Tracking Report

The Applicant Requirements Tracking Report provides detailed information on each applicant's tracking requirements and the status of each requirement.

(RBRABUD) - Applicant Budget Report

The Applicant Budget Report prints budget information for applicants.

(RBRBCMP) - Budget Component Report

The Budget Component Report give a list of all budget components in each budget group.

(RORAPLT) - Basic Applicant Report

The Basic Applicant Report produces a listing of applicant Names, Id's, Application Dates and Tracking, Budgeting and Packaging group codes.

(RPRAWDB) - Student Award and Disbursement Report

The new Student Award and Disbursement Report can be requested at any time, not just produced as a result of the disbursement process. The report prints the summary by fund of the accepted award amount, memo'd amount, authorized amount, and disbursed amount.

(RORCALC) - Calculated Values Report

RORCALC calculates an applicant’s FM values for Gross Need, Unmet Need and EFC.  These values are stored in the student’s RORSTAT record. 

(RPRADSB) - Applicant Disbursement Report

The Applicant Disbursement Report provides the user with an easy and effective way to report cumulative disbursement information on a student for a particular term. 

RFRBUDG - Fund Budget Report

This report gives information on allocations, offers, accepted, paid and remaining allocations.

RFRABAL – Account Balances Report

This report prints detailed information on the status of each fund for the aid year.