Return to Navigation

Producing the FISAP Report

This section discusses how to:

Note: Before you use a FISAP run control component for the first time in a new aid year, be sure to update your security profiles for correct viewing and use.

The aid year for this page is indicated by 20nn - 20nn in the page name and navigation path, and nn in the object name.

Page Name

Definition Name

Navigation

Usage

Report on Eligible Aid Applicants for Award Year 20nn - 20nn

RUNCTL_FA_FISAPnn

select Financial Aid, then select Fund Management, then select Generate FISAP Reports, then select FISAP Report 20nn-20nn

Generate the FISAP report.

Access the Report on Eligible Aid Applicants for Award Year 20nn - 20nn page (select Financial Aid, then select Fund Management, then select Generate FISAP Reports, then select FISAP Report 20nn-20nn).

Image: Report on Eligible Aid Applicants for Award Year 20nn - 20nn page

This example illustrates the fields and controls on the Report on Eligible Aid Applicants for Award Year 20nn - 20nn page. You can find definitions for the fields and controls later on this page.

Report on Eligible Aid Applicants for Award Year 20nn - 20nn page

The system populates, by default, the run controls set up on the Financial Aid Run Controls page. The file name for reports that are generated by this SQR is FAPFSPnn_XX.PDF, where nn is the aid year and XX is the processing instance.

Field or Control

Definition
Institution

Select the institution for which you want to generate the FISAP report. This list reflects those institutions or satellite campuses that you have previously identified.
Aid Year

Select the aid year for which you are reporting, not the aid year for which you are applying.
SSA Citizenship Override

Select if you want the report to include students with an SSA Citizenship Indicator override on the Database Matches page as eligible citizens on the FISAP.
DHS/INS Match Override

Select if you want the report to include students with a DHS/INS Match override on the Database Matches page as eligible citizens on the FISAP.
Print Student List

When you select this check box, the system prints an itemized list of all students in these two sections: Part II Section F and Part VI Section A.
Output Type

Select from: Both Paper and CSV File, CSV File, and Paper.

When you select Both Paper and CSV File, the system creates five separate and distinct comma delimited files in the location entered in the File Path field. The details are described as follows:

ELIGAPPL: Eligible Applicant Detail: This file is an itemized list of the student data counted in Part II Section F. The file is sorted in the following order: by report column letter, by FISAP Total Income, and then by EMPLID. After the system prints the details of each report column letter, it prints a row with the totals for that column letter.

The remaining four files are itemized details of Part VI Section A by fund.

DISTFWSP: Federal Work Study Distribution Detail

DISTPERK: Perkins Distribution Detail

DISTSEOG: SEOG Distribution Detail

DISTUNDP: Unduplicated Count Detail

The four distribution files are sorted in the following order: by Student Type, by FISAP Total Income, and then by EMPLID. Student Type is defined as follows:

1DUG: Dependent Undergraduate Students

2IUG: Independent Undergraduate Students

3GRAD: Graduate Students

4LTFT: Less Than Full Time Students

50EFC: Automatic Zero EFC Students
File Path

Enter the file path and directory name where the CSV file should be written. The process scheduler server must be able to read and write to this path.

After running this report, check the SQR log for messages. If a student has a blank NSLDS loan year or a student with an FSEOG award has a graduate or professional NSLDS loan year for the final term of the award year, the system generates an error in the SQR log when you run the FISAP report. These errors do not prevent the system from generating the FISAP report.

These queries are provided as data analysis tools only and are not supported by functionality.

The queries in the following table are available as a baseline data verification tool with which you can define additional queries to meet your institution's needs. No menu path is available. Instead, access the People Tools Query. Use the queries to analyze and compare data after the FISAP SQR has been processed.

Note: To run the FISAP queries, you might need to add tables to either the query tree QUERY_TREE_FA or to a custom query tree, which is accessible to the person who runs the FISAP queries. FISAP queries access the tables in the following list, which are included in the QUERY_TREE_FA. Review your implemented QUERY_TREE_FA, your custom query tree, or both to ensure that all tables accessed by the FISAP queries are included in either of these query trees. Add only those tables that are not already there.

DISB_ID_TBL

FISAP_STDNT_VW

ISIR_COMPUTED

ISIR_CONTROL

ISIR_STUDENT

ITEM_TYPE_FA

PERSONAL_DTSAVW

STDNT_AID_ATRBT

STDNT_AWARDS

STDNT_AWRD_DISB

STDNT_FA_TERM

TERM_TBL

Query ID

Query Objective and Description

Note

QUERIES TO SUPPORT APPLICATION PART II - Section F

   

FISAP_ELIG_APP_GRAD_IND

This query identifies graduate professional students for Application Part II - Section F on a detail level.

If necessary, make appropriate line item adjustments to Application Part II - Section F, Column E.

FISAP_ELIG_APP_UGRD_DEP_DEG

This query identifies dependent undergraduate students with a prior degree for Application Part II - Section F on a detail level.

If necessary, make appropriate line item adjustments to Application Part II - Section F, Column B.

FISAP_ELIG_APP_UGRD_DEP_NOT_FT

This query identifies dependent undergraduate students who are less than full-time in the final term of their award year for Application Part II - Section F on a detail level.

If necessary, make appropriate line item adjustments to Application Part II - Section F.

FISAP_ELIG_APP_UGRD_DEP_NO_DEG

This query identifies dependent undergraduate students without a prior degree for Application Part II - Section F on a detail level.

If necessary, make appropriate line item adjustments to Application Part II - Section F, Column A.

FISAP_ELIG_APP_UGRD_IND_DEG

This query identifies independent undergraduate students with a prior degree for Application Part II - Section F on a detail level.

If necessary, make appropriate line item adjustments to Application Part II - Section F, Column D.

FISAP_ELIG_APP_IND_NO_DEG

This query identifies independent undergraduate students without a prior degree for Application Part II - Section F on a detail level.

If necessary, make appropriate line item adjustments to Application Part II - Section F, Column C.

QUERIES TO SUPPORT APPLICATION PART VI - PROGRAM SUMMARY - Section A

   

FISAP_DISTRIBUTION_AUTO_0_EFC

This query identifies students who received Campus-Based funds and whose EFC is considered to be an Auto Zero EFC. The Auto Zero EFC is based on data that is obtained from the student's ISIR record.

If necessary, make appropriate line item adjustments to Application Part VI - Program Summary data, Item #18.

FISAP_DISTRIBUTION_GRAD

This query identifies Campus-Based funds that are disbursed to graduate and professional students for Application Part VI - Section A on a detail level.

If necessary, make appropriate line item adjustments to Application Part VI - Program Summary data, Item #15.

FISAP_DISTRIBUTION_UGRD_DEPEND

This query identifies Campus-Based funds that are disbursed to dependent undergraduate students for Application Part VI - Section A on a detail level.

If necessary, make appropriate line item adjustments to Application Part VI - Program Summary data, Items #1-7.

FISAP_DISTRIBUTION_UGRD_IND

This query identifies Campus-Based funds that are disbursed to independent undergraduate students for Application Part VI - Section A on a detail level.

If necessary, make appropriate line item adjustments to Application Part VI - Program Summary data, Items #8-14.

FISAP_NO_DISB_IN_GRAD_MAX_TERM

This query identifies graduate students who did not receive Campus-Based funds in the final term of their award year. This same group of students, however, received Campus-Based funds as undergraduates in previous terms in the same award year.

If necessary, make appropriate line item adjustments to Application Part VI - Program Summary data.

FISAP_NO_DISB_NOT_FT_MAX_TERM

This query identifies students who did not receive Campus-Based funds and whose enrollment status is classified as less than full-time in the final term of their award year.

If necessary, make appropriate line item adjustments to Application Part VI - Program Summary data.

FISAP_DISTRIBUTION_LTFT

This query identifies every disbursement for all students who have Perkins, Federal Work-Study, or FSEOG awards, and whose enrollment status for the last term of the award year is less than full-time.

If necessary, make appropriate line item adjustments to Application Part VI - Program Summary data.

See also PeopleTools: Query, “PeopleSoft Query Security.

PeopleTools: Security Administration