Product: | IGF - Financial Aid |
---|---|
Description: | Displays the FISAP reporting data populated by the FISAP report |
Implementation/DBA Data: | APPS.IGF_AW_FISAP_REP_V |
SELECT FISAP.BATCH_ID
, FISAP.FISAP_DTLS_ID
, BATCH.CI_CAL_TYPE
, BATCH.CI_SEQUENCE_NUMBER
, CA.ALTERNATE_CODE
, BATCH.DESCRIPTION
, BATCH.REPORTED_TIME_TXT
, FISAP.ISIR_ID
, ISIR.TRANSACTION_NUM
, ISIR.CURRENT_SSN
, ISIR.FIRST_NAME
, ISIR.LAST_NAME
, FABASE.PERSON_ID
, HZ.PARTY_NUMBER
, FISAP.DEPENDENCY_STATUS
, FISAP.CAREER_LEVEL
, FISAP.AUTO_ZERO_EFC_FLAG
, FISAP.FISAP_INCOME_AMT
, FISAP.ENROLLMENT_STATUS
, FISAP.PERKINS_DISB_AMT
, FISAP.FWS_DISB_AMT
, FISAP.FSEOG_DISB_AMT
, FISAP.PART_II_SECTION_F_FLAG
, FISAP.PART_VI_SECTION_A_FLAG
, FISAP.CREATED_BY
, FISAP.CREATION_DATE
, FISAP.LAST_UPDATED_BY
, FISAP.LAST_UPDATE_DATE
, FISAP.LAST_UPDATE_LOGIN
, FISAP.PROGRAM_APPLICATION_ID
, FISAP.PROGRAM_ID
, FISAP.PROGRAM_UPDATE_DATE
, FISAP.REQUEST_ID
FROM IGF_AW_FISAP_REP FISAP
, IGF_AW_FISAP_BATCH BATCH
, IGF_AP_ISIR_MATCHED ISIR
, IGF_AP_FA_BASE_REC_ALL FABASE
, IGS_CA_INST CA
, HZ_PARTIES HZ
WHERE FISAP.BATCH_ID = BATCH.BATCH_ID
AND FISAP.ISIR_ID = ISIR.ISIR_ID
AND ISIR.BASE_ID = FABASE.BASE_ID
AND BATCH.CI_CAL_TYPE = CA.CAL_TYPE
AND BATCH.CI_SEQUENCE_NUMBER = CA.SEQUENCE_NUMBER
AND FABASE.PERSON_ID = HZ.PARTY_ID