View: IGF_SP_FUND_MAST_V

Product:	IGF - Financial Aid
Description:	Stores Details and the properties of all the funds
Implementation/DBA Data:	APPS.IGF_SP_FUND_MAST_V

View Text

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
, FMAST.ELIG_CRITERIA
, 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_UPDATED_BY
, FMAST.LAST_UPDATE_DATE
, FMAST.LAST_UPDATE_LOGIN
, FMAST.REQUEST_ID
, FMAST.PROGRAM_ID
, FMAST.PROGRAM_APPLICATION_ID
, FMAST.PROGRAM_UPDATE_DATE
, NULL
, NULL
, FMAST.THRESHOLD_PERCT
, FMAST.THRESHOLD_VALUE
, NULL
, NULL
, NULL
, FMAST.SPNSR_REF_NUM SPNSR_REF_NUM
, FMAST.PARTY_ID PARTY_ID
, FIPV.PERSON_NUMBER PARTY_NUMBER
, FMAST.SPNSR_FEE_TYPE
, FMAST.MIN_CREDIT_POINTS
, FMAST.GROUP_ID
, PIG.DESCRIPTION
, FMAST.SPNSR_ATTRIBUTE_CATEGORY
, FMAST.SPNSR_ATTRIBUTE1
, FMAST.SPNSR_ATTRIBUTE2
, FMAST.SPNSR_ATTRIBUTE3
, FMAST.SPNSR_ATTRIBUTE4
, FMAST.SPNSR_ATTRIBUTE5
, FMAST.SPNSR_ATTRIBUTE6
, FMAST.SPNSR_ATTRIBUTE7
, FMAST.SPNSR_ATTRIBUTE8
, FMAST.SPNSR_ATTRIBUTE9
, FMAST.SPNSR_ATTRIBUTE10
, FMAST.SPNSR_ATTRIBUTE11
, FMAST.SPNSR_ATTRIBUTE12
, FMAST.SPNSR_ATTRIBUTE13
, FMAST.SPNSR_ATTRIBUTE14
, FMAST.SPNSR_ATTRIBUTE15
, FMAST.SPNSR_ATTRIBUTE16
, FMAST.SPNSR_ATTRIBUTE17
, FMAST.SPNSR_ATTRIBUTE18
, FMAST.SPNSR_ATTRIBUTE19
, FMAST.SPNSR_ATTRIBUTE20
, FMAST.VER_APP_STAT_OVERRIDE
, FMAST.GIFT_AID
, FMAST.SEND_WITHOUT_DOC
, BM.AWARD_YEAR_STATUS_CODE
, FMAST.DISB_ROUNDING_CODE
, IGF_AW_GEN.LOOKUP_DESC ('IGF_AW_DISB_ROUNDING'
, FMAST.DISB_ROUNDING_CODE) DISB_ROUNDING_DESC
, FMAST.RE_PKG_VERIF_FLAG
, FMAST.DONOT_REPKG_IF_CODE
, FMAST.LOCK_AWARD_FLAG
FROM IGF_AW_FUND_MAST FMAST
, IGF_AP_BATCH_AW_MAP BM
, IGS_CA_INST CI
, IGF_AW_FUND_CAT FCAT
, IGS_EN_ATD_TYPE ATT
, IGS_FI_CR_TYPES CR
, IGS_FI_PARTIES_V FIPV
, IGS_PE_PERSID_GROUP PIG
WHERE FMAST.CI_CAL_TYPE = BM.CI_CAL_TYPE
AND FMAST.CI_SEQUENCE_NUMBER = BM.CI_SEQUENCE_NUMBER
AND BM.CI_CAL_TYPE = CI.CAL_TYPE
AND BM.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 = FIPV.PERSON_ID
AND FMAST.GROUP_ID = PIG.GROUP_ID (+)
AND FCAT.SYS_FUND_TYPE = 'SPONSOR'
AND BM.AWARD_YEAR_STATUS_CODE IN ('O'
, 'C'
, 'LD')

Columns