AV_MTCH_OFY_VW

(SQL View)
 Index Back

Actual Match Amount

Actual Match Amount by Fiscal Year

SELECT A.INSTITUTION , A.EXT_ORG_ID , B.FISCAL_YEAR , SUM(A.ACTL_MTCH_AMT) FROM PS_AV_MTCH_GIFT A , PS_AV_GIFT_DTL B , PS_AV_SESSION_TBL C , PS_AV_GIFT_DTL B1 , PS_AV_SESSION_TBL C1 WHERE A.INSTITUTION = B.INSTITUTION AND A.MTCH_SESSION_NO = B.SESSION_NO AND A.MTCH_GIFT_NO = B.GIFT_NO AND B.ADJUSTMENT_FLG = 'N' AND A.INSTITUTION = C.INSTITUTION AND A.MTCH_SESSION_NO = C.SESSION_NO AND C.SESS_STATUS = 'P' AND A.INSTITUTION = B1.INSTITUTION AND A.SESSION_NO = B1.SESSION_NO AND A.GIFT_NO = B1.GIFT_NO AND B1.ADJUSTMENT_FLG = 'N' AND A.INSTITUTION = C1.INSTITUTION AND A.SESSION_NO = C1.SESSION_NO AND C1.SESS_STATUS = 'P' GROUP BY A.INSTITUTION ,A.EXT_ORG_ID ,B.FISCAL_YEAR

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution
2 EXT_ORG_ID Character(11) VARCHAR2(11) NOT NULL External Org ID
3 FISCAL_YEAR Number(4,0) SMALLINT NOT NULL Fiscal Year
4 ACTL_MTCH_AMT Number(16,2) DECIMAL(15,2) NOT NULL Actual Match Amount