FISAP Report for Credit Hour Programs

Campus Cafe provides a FISAP report to assist institutions with reporting Federal Work Study and FSEOG programming to the Government. Currently this report is setup to support Credit Hour programs as far as enrollment numbers are concerned, but Clock Hour instructions still may find the report helpful with the other report fields that are needed to complete the report.

This report can be found by navigating to the base analytic SSRS reports → Financial Aid Folder → FISAP From Student Finder List

 

Methodology

This report gives the user summary data that can be used with the annual FISAP Reporting process.

Step 1. Use student finder to query a list of students needing to be reporting on the FISAP

  • Please review the video on the Student Finder documentation page if needing instructions on how to pull a list of enrolled students.

  • the student finders query should include all enrolled students in a degree seeking program for the July 1st to June 30th of the reporting period reporting period.

  • Student lists can be pulled in a number of ways; some example filters to use separately or in conjunction with each other could be:

    • Single Semester (A user can select multiple single semesters to evaluate at the same time, e.g. Select

      image-20240927-174223.png

       

    • Excluding the Summary level 99 with “blank”

    • Single semester Degree Levels to Include/exclude

    • Single Semester Credits taken to make sure you’re only including enrollments with at least 1 credit hour.

      image-20240927-174319.png

    • Other Fields that may be helpful to pull in a list of eligible students.

      • Enrolled in Sem

      • Degree Major

      • Degree Level

      • Session Row Range is within the time period being evaluated

      • Enrollment Date Range filters

Step 2. Once the user has verified the list in the student finder are eligible to be included in the FISAP report then click the "Export ID's To Reports" from the Actions list. Documentation Link: Export IDs to Reports

Step 3. Use the parameters at the top of the page input your Data Base Code, Your personal User ID, so your specific student finder list is pulled into this report.

Step 4. Select the ISIR Award Year (2024 for the 23-24 Year), Billing Semester lower and upper range for the associated Tuition and Fees for calculation.

Step 5. Click View Report and review report.

Step 6. Check for Uncredentialed Program students issues to see if a student should be counted as a degree seeking student.

  • Navigate to the 2nd or 3rd page to see the raw student data to verify if all students listed as “Uncredentialed” are in-fact a non-degree seeking student.

  • Students will be reported as uncredentialed if the student is enrolled in a program that is:

    • Not marked with “Degree Seeking” in the major maintenance

    • Missing a degree start date

    • Missing a major

    • or you are incorrectly pulling in students that should not be included in the report.

  • Per FISAP instructions, if these students are taking at least one undergraduate or graduate course that is not deemed an “audit” or “highschool concurrent”, they are to be included in both the Enrollment Numbers and the billed tuition/fees section.

    • You will need to review each student that is marked with an uncredentialed program and manually include them in the Undergraduate or Graduate Enrollment headcounts.

  • These students are not reported in the enrollment number sections

 

Assumptions and Notes:

  • The report assumes that associated Tuition and Fees are properly marked with the "T-Tuition" 1098-T Report Code flag for tax reporting under the Billing Transaction Codes Maintenance.

    • Tuition and Fee transactions codes that are not marked with the 1098-T tuition flag will not be calculated.

  • First Bachelor's by July field is pulled from the ISIR itself, it does not look at any prior completed degrees in the system for this field if that student completed a degree mid-year.

  • Awards are reported by their Award Year. e.g. 2024 Award Year = July 1, 2023 to June 30th, 2024

  • Majors need to be set up under the Major Maintenance to have a credential level set.

  • The report assumes that the students' reported program starts before the end of reporting date range (June 30th of the period), and the program is a degree seeking program

  • FWS Funds are from the scheduled amounts since FWS isn't disburse to the student's ledgers.

    • FWS amounts should be scheduled for the exact amounts distributed to students. If a student didn't receive all of the original quoted FWS, the scheduled amount should be adjusted under the financial aid module

  • The Report uses the Default/Active Selected ISIR for the Award Year for the student.

    • Rejected ISIR's marked as Default are NOT counted in the enrollment totals by FISAP Income or Fundings because they are technically NOT eligible for Title IV with a rejected ISIR of enrolled and eligible for aid per the FISAP Report Instruction Manual.