AV_MTCH_OTNP_VW (SQL View)	Index Back
Org Actl Mtch NotPosted Organization Match Summary for Match Gift records whose Match Gift Gift No Session Status <> 'P'. Since these Match Gift records are not complete until their attached gifts are posted, this view sums the Expected amounts. When the attached gift is posted, the Match Gift moves from this view to the AV_MTCH_OT_VW and sums the actual match amount.

AV_MTCH_OTNP_VW

(SQL View)

Org Actl Mtch NotPosted

Organization Match Summary for Match Gift records whose Match Gift Gift No Session Status <> 'P'. Since these Match Gift records are not complete until their attached gifts are posted, this view sums the Expected amounts. When the attached gift is posted, the Match Gift moves from this view to the AV_MTCH_OT_VW and sums the actual match amount.

SELECT A.INSTITUTION , A.EXT_ORG_ID , SUM(A.EXPT_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 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 (C.SESS_STATUS <> 'P' ) GROUP BY A.INSTITUTION , A.EXT_ORG_ID

# 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 EXPT_MTCH_AMT Number(16,2) DECIMAL(15,2) NOT NULL Expected Match Amount

#	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	EXPT_MTCH_AMT	Number(16,2)	DECIMAL(15,2) NOT NULL	Expected Match Amount