AV_MTCH_ORG_VW2

(SQL View)
 Index Back

Matching gifts gift view

All Matching gift records that have reference an organization

SELECT A.INSTITUTION , A.EXT_ORG_ID , A.EMPLID , A.SESSION_NO , A.GIFT_NO , A.EXPT_MTCH_AMT , A.CURRENCY_CD , 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 , C.GIFT_DT 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' AND B.SESS_STATUS='P'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution

Default Value: AV_GIFT_DTL.INSTITUTION

Prompt Table: INSTITUTN_SCRTY

2 EXT_ORG_ID Character(11) VARCHAR2(11) NOT NULL External Org ID

Default Value: AV_GIFT_DTL.EXT_ORG_ID

Prompt Table: AV_EXT_ORG_SRCH

3 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

Prompt Table: AV_REL_EP_MG_VW

4 SESSION_NO Character(11) VARCHAR2(11) NOT NULL Session Nbr
5 GIFT_NO Character(11) VARCHAR2(11) NOT NULL Gift Nbr

Prompt Table: AV_PGIFT_365_VW

6 EXPT_MTCH_AMT Number(16,2) DECIMAL(15,2) NOT NULL Expected Match Amount
7 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

Default Value: AV_GIFT_DTL.CURRENCY_CD

Prompt Table: CURRENCY_CD_TBL

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

Default Value: AV_GIFT_DTL.CURRENCY_CD

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 GIFT_DT Date(10) DATE Gift Date

Default Value: %date