VIEW: APPS.IGFFV_STUDENT_BASE_RECORDS

Source

View Text - Preformatted

SELECT BASE.EFC_F, BASE.EFC_I, BASE.NEED_F, BASE.NEED_I, '_LA:BASE.VERIFICATION_PROCESS_RUN:IGF_LOOKUPS_VIEW:IGF_AP_YES_NO:MEANING', BASE.INST_VERIF_STATUS_DATE, '_LA:BASE.FED_VERIF_STATUS:IGF_LOOKUPS_VIEW:IGF_FED_VERIFY_STATUS:MEANING', BASE.FED_VERIF_STATUS_DATE, '_LA:BASE.INST_VERIF_STATUS:IGF_LOOKUPS_VIEW:IGF_INST_VERIFY_STATUS:MEANING', BASE.NSLDS_ELIGIBLE, BASE.EDE_CORRECTION_BATCH_ID, BASE.FA_PROCESS_STATUS_DATE, '_LA:BASE.ISIR_CORR_STATUS:IGF_LOOKUPS_VIEW:IGF_CORR_STATUS:MEANING', BASE.ISIR_CORR_STATUS_DATE, '_LA:BASE.ISIR_STATUS:IGF_LOOKUPS_VIEW:IGF_ISIR_STATUS:MEANING', BASE.ISIR_STATUS_DATE, BASE.PROFILE_STATUS, BASE.PROFILE_STATUS_DATE, BASE.PROFILE_FC, BASE.COA_FIXED, BASE.COA_F, BASE.COA_I, BASE.COA_PELL, BASE.DISBURSEMENT_HOLD, '_LA:BASE.FA_PROCESS_STATUS:IGF_LOOKUPS_VIEW:IGF_AAP_PROCESS_STATUS:MEANING', '_LA:BASE.NOTIFICATION_STATUS:IGF_LOOKUPS_VIEW:IGF_AW_NOTIFIC_STAT:MEANING', BASE.NOTIFICATION_STATUS_DATE, '_LA:BASE.NSLDS_DATA_OVERRIDE_FLG:IGF_LOOKUPS_VIEW:IGF_AP_YES_NO:MEANING', '_LA:BASE.PACKAGING_STATUS:IGF_LOOKUPS_VIEW:IGF_PACKAGING_STATUS:MEANING', BASE.PACKAGING_STATUS_DATE, BASE.PAYMENT_ISIR_ID, BASE.TARGET_GROUP, BASE.TOTAL_PACKAGE_ACCEPTED, BASE.TOTAL_PACKAGE_OFFERED, BASE.TOLERANCE_AMOUNT, '_LA:BASE.MANUAL_DISB_HOLD:IGF_LOOKUPS_VIEW:IGF_AP_YES_NO:MEANING', BASE.PELL_ALT_EXPENSE, BASE.ASSOC_ORG_NUM, '_LA:BASE.AWARD_FMLY_CONTRIBUTION_TYPE:IGF_LOOKUPS_VIEW: IGF_AP_ENROLLMENT_STATUS_TYPE:MEANING', PE.PARTY_NUMBER, PE.PARTY_NAME, CI.ALTERNATE_CODE, CI.DESCRIPTION, '_DF:IGF:IGF_AP_FA_BASE_REC_ALL_FLEX:BASE', BASE.CI_CAL_TYPE, BASE.CI_SEQUENCE_NUMBER, BASE.PERSON_ID, BASE.BASE_ID, BASE.CREATED_BY, BASE.CREATION_DATE, BASE.LAST_UPDATED_BY, BASE.LAST_UPDATE_DATE FROM IGF_AP_FA_BASE_REC_ALL BASE, IGS_CA_INST_ALL CI, HZ_PARTIES PE WHERE BASE.CI_CAL_TYPE = CI.CAL_TYPE AND BASE.CI_SEQUENCE_NUMBER = CI.SEQUENCE_NUMBER AND BASE.PERSON_ID = PE.PARTY_ID WITH READ ONLY

View Text - HTML Formatted

SELECT BASE.EFC_F
, BASE.EFC_I
, BASE.NEED_F
, BASE.NEED_I
, '_LA:BASE.VERIFICATION_PROCESS_RUN:IGF_LOOKUPS_VIEW:IGF_AP_YES_NO:MEANING'
, BASE.INST_VERIF_STATUS_DATE
, '_LA:BASE.FED_VERIF_STATUS:IGF_LOOKUPS_VIEW:IGF_FED_VERIFY_STATUS:MEANING'
, BASE.FED_VERIF_STATUS_DATE
, '_LA:BASE.INST_VERIF_STATUS:IGF_LOOKUPS_VIEW:IGF_INST_VERIFY_STATUS:MEANING'
, BASE.NSLDS_ELIGIBLE
, BASE.EDE_CORRECTION_BATCH_ID
, BASE.FA_PROCESS_STATUS_DATE
, '_LA:BASE.ISIR_CORR_STATUS:IGF_LOOKUPS_VIEW:IGF_CORR_STATUS:MEANING'
, BASE.ISIR_CORR_STATUS_DATE
, '_LA:BASE.ISIR_STATUS:IGF_LOOKUPS_VIEW:IGF_ISIR_STATUS:MEANING'
, BASE.ISIR_STATUS_DATE
, BASE.PROFILE_STATUS
, BASE.PROFILE_STATUS_DATE
, BASE.PROFILE_FC
, BASE.COA_FIXED
, BASE.COA_F
, BASE.COA_I
, BASE.COA_PELL
, BASE.DISBURSEMENT_HOLD
, '_LA:BASE.FA_PROCESS_STATUS:IGF_LOOKUPS_VIEW:IGF_AAP_PROCESS_STATUS:MEANING'
, '_LA:BASE.NOTIFICATION_STATUS:IGF_LOOKUPS_VIEW:IGF_AW_NOTIFIC_STAT:MEANING'
, BASE.NOTIFICATION_STATUS_DATE
, '_LA:BASE.NSLDS_DATA_OVERRIDE_FLG:IGF_LOOKUPS_VIEW:IGF_AP_YES_NO:MEANING'
, '_LA:BASE.PACKAGING_STATUS:IGF_LOOKUPS_VIEW:IGF_PACKAGING_STATUS:MEANING'
, BASE.PACKAGING_STATUS_DATE
, BASE.PAYMENT_ISIR_ID
, BASE.TARGET_GROUP
, BASE.TOTAL_PACKAGE_ACCEPTED
, BASE.TOTAL_PACKAGE_OFFERED
, BASE.TOLERANCE_AMOUNT
, '_LA:BASE.MANUAL_DISB_HOLD:IGF_LOOKUPS_VIEW:IGF_AP_YES_NO:MEANING'
, BASE.PELL_ALT_EXPENSE
, BASE.ASSOC_ORG_NUM
, '_LA:BASE.AWARD_FMLY_CONTRIBUTION_TYPE:IGF_LOOKUPS_VIEW: IGF_AP_ENROLLMENT_STATUS_TYPE:MEANING'
, PE.PARTY_NUMBER
, PE.PARTY_NAME
, CI.ALTERNATE_CODE
, CI.DESCRIPTION
, '_DF:IGF:IGF_AP_FA_BASE_REC_ALL_FLEX:BASE'
, BASE.CI_CAL_TYPE
, BASE.CI_SEQUENCE_NUMBER
, BASE.PERSON_ID
, BASE.BASE_ID
, BASE.CREATED_BY
, BASE.CREATION_DATE
, BASE.LAST_UPDATED_BY
, BASE.LAST_UPDATE_DATE
FROM IGF_AP_FA_BASE_REC_ALL BASE
, IGS_CA_INST_ALL CI
, HZ_PARTIES PE
WHERE BASE.CI_CAL_TYPE = CI.CAL_TYPE
AND BASE.CI_SEQUENCE_NUMBER = CI.SEQUENCE_NUMBER
AND BASE.PERSON_ID = PE.PARTY_ID WITH READ ONLY