Product: | IGF - Financial Aid |
---|---|
Description: | Stores all the details and the properties for each fund |
Implementation/DBA Data: | APPS.IGF_AW_FUND_MAST_V |
SELECT FMAST.ROW_ID
, FMAST.FUND_ID
, FMAST.FUND_CODE
, FMAST.DESCRIPTION
, FCAT.FUND_TYPE
, FCAT.FUND_SOURCE
, FCAT.FED_FUND_CODE
, FCAT.SYS_FUND_TYPE
, FMAST.CI_CAL_TYPE
, FMAST.CI_SEQUENCE_NUMBER
, CI.ALTERNATE_CODE
, CI.START_DT
, CI.END_DT
, FMAST.DISCONTINUE_FUND
, FMAST.ENTITLEMENT
, FMAST.AUTO_PKG
, FMAST.SELF_HELP
, FMAST.ALLOW_MAN_PKG
, FMAST.UPDATE_NEED
, FMAST.DISBURSE_FUND
, FMAST.AVAILABLE_AMT
, FMAST.OFFERED_AMT
, FMAST.PENDING_AMT
, FMAST.ACCEPTED_AMT
, FMAST.DECLINED_AMT
, FMAST.CANCELLED_AMT
, FMAST.REMAINING_AMT
, FMAST.ENROLLMENT_STATUS
, ATT.DESCRIPTION
, FMAST.PRN_AWARD_LETTER
, FMAST.OVER_AWARD_AMT
, FMAST.OVER_AWARD_PERCT
, FMAST.MIN_AWARD_AMT
, FMAST.MAX_AWARD_AMT
, FMAST.MAX_YEARLY_AMT
, FMAST.MAX_LIFE_AMT
, FMAST.MAX_LIFE_TERM
, FMAST.FM_FC_METHD
, IGF_AW_GEN.LOOKUP_DESC('IGF_AW_NEED_METHOD'
, FMAST.FM_FC_METHD)
, FMAST.ROUNDOFF_FACT
, IGF_AW_GEN.LOOKUP_DESC('IGF_AW_ROUND_OFF'
, FMAST.ROUNDOFF_FACT)
, FMAST.REPLACE_FC
, FMAST.ALLOW_OVERAWARD
, FMAST.PCKG_AWD_STAT
, IGF_AW_GEN.LOOKUP_DESC('IGF_AWARD_STATUS'
, FMAST.PCKG_AWD_STAT)
, FMAST.ORG_RECORD_REQ
, FMAST.DISB_RECORD_REQ
, FMAST.PROM_NOTE_REQ
, FMAST.MIN_NUM_DISB
, FMAST.MAX_NUM_DISB
, FMAST.FEE_TYPE
, FMAST.TOTAL_OFFERED
, FMAST.TOTAL_ACCEPTED
, FMAST.TOTAL_DECLINED
, FMAST.TOTAL_REVOKED
, FMAST.TOTAL_CANCELLED
, FMAST.TOTAL_DISBURSED
, FMAST.TOTAL_COMMITTED
, FMAST.COMMITTED_AMT
, FMAST.DISBURSED_AMT
, FMAST.AWD_NOTICE_TXT
, FMAST.DISB_VERF_DA
, FMAST.FUND_EXP_DA
, FMAST.NSLDS_DISB_DA
, FMAST.DISB_EXP_DA
, FMAST.FUND_RECV_REQD
, FMAST.SHOW_ON_BILL
, FMAST.BILL_DESC
, FMAST.CREDIT_TYPE_ID
, NULL
, CR.CREDIT_TYPE_NAME
, FMAST.ATTRIBUTE_CATEGORY
, FMAST.ATTRIBUTE1
, FMAST.ATTRIBUTE2
, FMAST.ATTRIBUTE3
, FMAST.ATTRIBUTE4
, FMAST.ATTRIBUTE5
, FMAST.ATTRIBUTE6
, FMAST.ATTRIBUTE7
, FMAST.ATTRIBUTE8
, FMAST.ATTRIBUTE9
, FMAST.ATTRIBUTE10
, FMAST.ATTRIBUTE11
, FMAST.ATTRIBUTE12
, FMAST.ATTRIBUTE13
, FMAST.ATTRIBUTE14
, FMAST.ATTRIBUTE15
, FMAST.ATTRIBUTE16
, FMAST.ATTRIBUTE17
, FMAST.ATTRIBUTE18
, FMAST.ATTRIBUTE19
, FMAST.ATTRIBUTE20
, FMAST.CREATED_BY
, FMAST.CREATION_DATE
, FMAST.LAST_UPDATE_DATE
, FMAST.LAST_UPDATED_BY
, FMAST.LAST_UPDATE_LOGIN
, FMAST.PROGRAM_APPLICATION_ID
, FMAST.PROGRAM_ID
, FMAST.PROGRAM_UPDATE_DATE
, FMAST.REQUEST_ID
, NULL
, NULL
, NULL
, NULL
, FMAST.THRESHOLD_PERCT
, FMAST.THRESHOLD_VALUE
, NULL
, NULL
, NULL
, CR.SUBACCOUNT_ID SUBACCOUNT_ID
, FMAST.SPNSR_REF_NUM SPNSR_REF_NUM
, FMAST.PARTY_ID PARTY_ID
, HZ.PARTY_NUMBER PARTY_NUMBER
, FMAST.SPNSR_FEE_TYPE SPNSR_FEE_TYPE
, FMAST.MIN_CREDIT_POINTS MIN_CREDIT_POINTS
, FMAST.GROUP_ID GROUP_ID
, PIG.DESCRIPTION PERSID_GROUP_DESCRIPTION
, FMAST.SPNSR_ATTRIBUTE_CATEGORY SPNSR_ATTRIBUTE_CATEGORY
, FMAST.SPNSR_ATTRIBUTE1 SPNSR_ATTRIBUTE1
, FMAST.SPNSR_ATTRIBUTE2 SPNSR_ATTRIBUTE2
, FMAST.SPNSR_ATTRIBUTE3 SPNSR_ATTRIBUTE3
, FMAST.SPNSR_ATTRIBUTE4 SPNSR_ATTRIBUTE4
, FMAST.SPNSR_ATTRIBUTE5 SPNSR_ATTRIBUTE5
, FMAST.SPNSR_ATTRIBUTE6 SPNSR_ATTRIBUTE6
, FMAST.SPNSR_ATTRIBUTE7 SPNSR_ATTRIBUTE7
, FMAST.SPNSR_ATTRIBUTE8 SPNSR_ATTRIBUTE8
, FMAST.SPNSR_ATTRIBUTE9 SPNSR_ATTRIBUTE9
, FMAST.SPNSR_ATTRIBUTE10 SPNSR_ATTRIBUTE10
, FMAST.SPNSR_ATTRIBUTE11 SPNSR_ATTRIBUTE11
, FMAST.SPNSR_ATTRIBUTE12 SPNSR_ATTRIBUTE12
, FMAST.SPNSR_ATTRIBUTE13 SPNSR_ATTRIBUTE13
, FMAST.SPNSR_ATTRIBUTE14 SPNSR_ATTRIBUTE14
, FMAST.SPNSR_ATTRIBUTE15 SPNSR_ATTRIBUTE15
, FMAST.SPNSR_ATTRIBUTE16 SPNSR_ATTRIBUTE16
, FMAST.SPNSR_ATTRIBUTE17 SPNSR_ATTRIBUTE17
, FMAST.SPNSR_ATTRIBUTE18 SPNSR_ATTRIBUTE18
, FMAST.SPNSR_ATTRIBUTE19 SPNSR_ATTRIBUTE19
, FMAST.SPNSR_ATTRIBUTE20 SPNSR_ATTRIBUTE20
, FMAST.VER_APP_STAT_OVERRIDE
, FMAST.GIFT_AID
, FMAST.SEND_WITHOUT_DOC
, FMAST.RE_PKG_VERIF_FLAG
, FMAST.DONOT_REPKG_IF_CODE
, IGF_AW_GEN.LOOKUP_DESC('IGF_AW_REPKG_CODE'
, FMAST.DONOT_REPKG_IF_CODE)
, FMAST.LOCK_AWARD_FLAG
, FMAST.DISB_ROUNDING_CODE
, IGF_AW_GEN.LOOKUP_DESC ('IGF_AW_DISB_ROUNDING'
, FMAST.DISB_ROUNDING_CODE) DISB_ROUNDING_DESC
, FMAST.VIEW_ONLY_FLAG
, FMAST.ACCEPT_LESS_AMT_FLAG
, FMAST.ALLOW_INC_POST_ACCEPT_FLAG
, FMAST.MIN_INCREASE_AMT
, FMAST.ALLOW_DEC_POST_ACCEPT_FLAG
, FMAST.MIN_DECREASE_AMT
, FMAST.ALLOW_DECLN_POST_ACCEPT_FLAG
, FMAST.STATUS_AFTER_DECLINE
, FMAST.FUND_INFORMATION_TXT
, IGF_AW_GEN.LOOKUP_DESC('IGF_AW_FUND_SOURCE'
, FCAT.FUND_SOURCE)
FROM IGF_AW_FUND_MAST FMAST
, IGS_CA_INST CI
, IGF_AW_FUND_CAT FCAT
, IGS_EN_ATD_TYPE ATT
, IGS_FI_CR_TYPES CR
, HZ_PARTIES HZ
, IGS_PE_PERSID_GROUP PIG
WHERE FMAST.CI_CAL_TYPE = CI.CAL_TYPE
AND FMAST.CI_SEQUENCE_NUMBER = CI.SEQUENCE_NUMBER
AND FMAST.FUND_CODE = FCAT.FUND_CODE
AND FMAST.ENROLLMENT_STATUS = ATT. ATTENDANCE_TYPE (+)
AND FMAST.CREDIT_TYPE_ID = CR.CREDIT_TYPE_ID (+)
AND FMAST.PARTY_ID = HZ.PARTY_ID (+)
AND FMAST.GROUP_ID = PIG.GROUP_ID (+)