AV_MTCH_MGP_VW

(SQL View)
 Index Back

Matching Gift

This view only returns non adjusted matching gifts for a specified Match Session and Match Gift Number. Used in Adj MG processing. Added Sess Status to use in chosen gift number field edit. If a chosen gift is a MG gift and any of the match gift records it relieves is not posted, cannot adjust yet.

SELECT A.INSTITUTION , A.SESSION_NO , A.GIFT_NO , A.EXT_ORG_ID , A.EMPLID , A.CURRENCY_CD , A.EXPT_MTCH_AMT , A.MTCH_FRM_RCVD_DT , A.MTCH_SESSION_NO , A.MTCH_GIFT_NO , A.ACTL_MTCH_AMT , A.CURRENCY_CD1 , A.MTCH_DT , A.MTCH_DENIED_DT , A.DESCR50 , B.SESS_STATUS FROM PS_AV_MTCH_GIFT A , PS_AV_SESSION_TBL B , PS_AV_GIFT_DTL C WHERE A.INSTITUTION=B.INSTITUTION AND A.INSTITUTION=C.INSTITUTION AND A.SESSION_NO=B.SESSION_NO AND A.SESSION_NO=C.SESSION_NO AND A.GIFT_NO=C.GIFT_NO AND C.ADJUSTMENT_FLG='N'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution
2 SESSION_NO Character(11) VARCHAR2(11) NOT NULL Session Nbr
3 GIFT_NO Character(11) VARCHAR2(11) NOT NULL Gift Nbr
4 EXT_ORG_ID Character(11) VARCHAR2(11) NOT NULL External Org ID
5 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
6 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
7 EXPT_MTCH_AMT Number(16,2) DECIMAL(15,2) NOT NULL Expected Match Amount
8 MTCH_FRM_RCVD_DT Date(10) DATE Match Form Processed Date
9 MTCH_SESSION_NO Character(11) VARCHAR2(11) NOT NULL Session Nbr
10 MTCH_GIFT_NO Character(11) VARCHAR2(11) NOT NULL Match Gift Number
11 ACTL_MTCH_AMT Number(16,2) DECIMAL(15,2) NOT NULL Actual Match Amount
12 CURRENCY_CD1 Character(3) VARCHAR2(3) NOT NULL Currency Code
13 MTCH_DT Date(10) DATE Match Date
14 MTCH_DENIED_DT Date(10) DATE Denied Date
15 DESCR50 Character(50) VARCHAR2(50) NOT NULL Description of length 50
16 SESS_STATUS Character(1) VARCHAR2(1) NOT NULL Session Status
B=Balanced
O=Open
P=Posted
Q=Queued
S=Suspense