Report Description

As part of FISAP reporting, we need to maintain the Part VI Program Summary Report for the Federal Award Year. This report will show the distribution of aid recipients and the amounts spent during the Federal Award Year—by taxable and untaxed income levels—for undergraduate dependent students, undergraduate independent students, and/or graduate/ professional students.

The section VI Grid report provides the amounts to be entered into the FISAP web screens for the income grids and for the SEOG/Perkins/FWS award information. 

CCC needs the ability to run this at the enterprise level.

Report Parameters / Filters

• Enterprise (single select)
• Institution (multi select)
• Campus (multi select)
• Site (multi select)
• Federal Award Year (single select)
  
  

Header

Output Columns

• Taxable And Untaxed Category Student Type
• Federal Perkins Loans
  
  • Recipients (a)
  • Funds (b)
• FSEOG
  • Recipients (c)
  • Funds (d)
• FWS
  • Recipients (e)
  • Funds (f)
• Unduplicated Recipients (g)

Rules

1. The student must have an official ISIR on file that was used to award federal aid from and the student must have had enrollment in the federal award year specified by the report parameters.
   • Official ISIRs are identified as transaction numbers “01” or greater and which have an “official” Expected Family Contribution (EFC) calculated by the Central Processing System (CPS). (Primary EFC not blank)
2. If student has an ISIR but Expected Family Contribution is blank on ISIR, then do not count that student for this report.
3. The student must have an actual enrollment for one or more payment periods associated to the federal award year specified by the report parameters to be included in the FISAP report.
4. The less-than-full-time row counts all students that were enrolled at less-than-half-time when they received that column's particular fund. This would be considered a duplicate count of the student who was also counted in the income bucket row.
5. The unduplicated count of students required for FISAP Part 6, Section A should count the student only one time when they are placed in the grid. The rows allow for counting the student multiple times based on the awards he has received; however, the unduplicated recipient column would show the student only once. For example, the student who is in the undergraduate dependent income bracket $24,000-$29,999 receiving Perkins, FSEOG, and FWS would show in each award column as a recipient count and their award amount; however, they would only be reported one time in the unduplicated recipient column. This is not the sum of the previous columns.
6. For Perkins (FPERK) and FWS recipients: A student who was a recipient in more than one academic category in federal award year (e.g., undergraduate one term and graduate in another, dependent in one term and independent in another, or full time in one term, less than full time in another) should be reported in the category in which he or she was enrolled during the final term of the federal award year. If the student is a graduate student, they are always included in the independent graduate column regardless of dependency status. For FSEOG recipients, always include the student in an undergraduate category.
7. For any cross payment period, include awards only if it is awarded for reporting year. For instance reporting year is 13-14 FAY and the cross payment period is awarded from 14-15 FAY not 13-14 FAY budget. Do not include this award. This should be included in next year 14-15 FAY.
8. FWS earnings (paid amount) should come from Work Study Tab for the student. Use the sum of the FWS earnings (paid amount) for the FAY specified by the report parameters.
9. For FSEOG and FPERK, use the sum of the paid disbursements for the FAY specified by the report parameters.

Data Definition