Producing the FISAP Report
This section discusses how to:
Generate the FISAP report.
(Optional) Use FISAP queries.
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 |
|
Generate the FISAP report. |
Access the Report on Eligible Aid Applicants for Award Year 20nn - 20nn page (
).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.
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