Product: | IGF - Financial Aid |
---|---|
Description: | Holds the summarized information of all the financial aid processes for a student for an academic year |
Implementation/DBA Data: | APPS.IGF_AP_FA_BASE_REC |
SELECT FABASE.ROWID
, FABASE.BASE_ID
, FABASE.CI_CAL_TYPE
, FABASE.PERSON_ID
, FABASE.CI_SEQUENCE_NUMBER
, FABASE.ORG_ID
, FABASE.EFC_F
, FABASE.EFC_I
, FABASE.NEED_F
, FABASE.NEED_I
, FABASE.COA_PENDING
, FABASE.VERIFICATION_PROCESS_RUN
, FABASE.INST_VERIF_STATUS_DATE
, FABASE.MANUAL_VERIF_FLAG
, FABASE.FED_VERIF_STATUS
, FABASE.FED_VERIF_STATUS_DATE
, FABASE.INST_VERIF_STATUS
, FABASE.NSLDS_ELIGIBLE
, FABASE.EDE_CORRECTION_BATCH_ID
, FABASE.FA_PROCESS_STATUS_DATE
, FABASE.ISIR_CORR_STATUS
, FABASE.ISIR_CORR_STATUS_DATE
, FABASE.ISIR_STATUS
, FABASE.ISIR_STATUS_DATE
, FABASE.PROFILE_STATUS
, FABASE.PROFILE_STATUS_DATE
, FABASE.PROFILE_FC
, NULL
, FABASE.COA_FIXED
, FABASE.COA_CODE_I
, FABASE.COA_F
, FABASE.COA_I
, FABASE.COA_PELL
, FABASE.DISBURSEMENT_HOLD
, FABASE.FA_PROCESS_STATUS
, FABASE.NOTIFICATION_STATUS
, FABASE.NOTIFICATION_STATUS_DATE
, NULL
, FABASE.NSLDS_DATA_OVERRIDE_FLG
, FABASE.PACKAGING_STATUS
, FABASE.PROF_JUDGEMENT_FLG
, FABASE.PACKAGING_STATUS_DATE
, FABASE.PAYMENT_ISIR_ID
, FABASE.TARGET_GROUP
, FABASE.TOTAL_PACKAGE_ACCEPTED
, FABASE.TOTAL_PACKAGE_OFFERED
, FABASE.ADMSTRUCT_ID
, FABASE.ADMSEGMENT_1
, FABASE.ADMSEGMENT_2
, FABASE.ADMSEGMENT_3
, FABASE.ADMSEGMENT_4
, FABASE.ADMSEGMENT_5
, FABASE.ADMSEGMENT_6
, FABASE.ADMSEGMENT_7
, FABASE.ADMSEGMENT_8
, FABASE.ADMSEGMENT_9
, FABASE.ADMSEGMENT_10
, FABASE.ADMSEGMENT_11
, FABASE.ADMSEGMENT_12
, FABASE.ADMSEGMENT_13
, FABASE.ADMSEGMENT_14
, FABASE.ADMSEGMENT_15
, FABASE.ADMSEGMENT_16
, FABASE.ADMSEGMENT_17
, FABASE.ADMSEGMENT_18
, FABASE.ADMSEGMENT_19
, FABASE.ADMSEGMENT_20
, FABASE.PACKSTRUCT_ID
, FABASE.PACKSEGMENT_1
, FABASE.PACKSEGMENT_2
, FABASE.PACKSEGMENT_3
, FABASE.PACKSEGMENT_4
, FABASE.PACKSEGMENT_5
, FABASE.PACKSEGMENT_6
, FABASE.PACKSEGMENT_7
, FABASE.PACKSEGMENT_8
, FABASE.PACKSEGMENT_9
, FABASE.PACKSEGMENT_10
, FABASE.PACKSEGMENT_11
, FABASE.PACKSEGMENT_12
, FABASE.PACKSEGMENT_13
, FABASE.PACKSEGMENT_14
, FABASE.PACKSEGMENT_15
, FABASE.PACKSEGMENT_16
, FABASE.PACKSEGMENT_17
, FABASE.PACKSEGMENT_18
, FABASE.PACKSEGMENT_19
, FABASE.PACKSEGMENT_20
, FABASE.MISCSTRUCT_ID
, FABASE.MISCSEGMENT_1
, FABASE.MISCSEGMENT_2
, FABASE.MISCSEGMENT_3
, FABASE.MISCSEGMENT_4
, FABASE.MISCSEGMENT_5
, FABASE.MISCSEGMENT_6
, FABASE.MISCSEGMENT_7
, FABASE.MISCSEGMENT_8
, FABASE.MISCSEGMENT_9
, FABASE.MISCSEGMENT_10
, FABASE.MISCSEGMENT_11
, FABASE.MISCSEGMENT_12
, FABASE.MISCSEGMENT_13
, FABASE.MISCSEGMENT_14
, FABASE.MISCSEGMENT_15
, FABASE.MISCSEGMENT_16
, FABASE.MISCSEGMENT_17
, FABASE.MISCSEGMENT_18
, FABASE.MISCSEGMENT_19
, FABASE.MISCSEGMENT_20
, FABASE.TOLERANCE_AMOUNT
, FABASE.CREATED_BY
, FABASE.CREATION_DATE
, FABASE.LAST_UPDATED_BY
, FABASE.LAST_UPDATE_DATE
, FABASE.LAST_UPDATE_LOGIN
, FABASE.REQUEST_ID
, FABASE.PROGRAM_APPLICATION_ID
, FABASE.PROGRAM_ID
, FABASE.PROGRAM_UPDATE_DATE
, FABASE.MANUAL_DISB_HOLD
, FABASE.PELL_ALT_EXPENSE
, FABASE.ASSOC_ORG_NUM
, FABASE.AWARD_FMLY_CONTRIBUTION_TYPE
, ISIR_LOCKED_BY
, FABASE.ADNL_UNSUB_LOAN_ELIG_FLAG
, FABASE.LOCK_AWD_FLAG
, FABASE.LOCK_COA_FLAG
FROM IGF_AP_FA_BASE_REC_ALL FABASE
WHERE NVL (FABASE.ORG_ID
, NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 1)
, ' '
, NULL
, SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 10)))
, -99)) = NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 1)
, ' '
, NULL
, SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 10)))
, -99)