AV_MTCH_ORG_VW

(SQL View)
 Index Back

Matching gifts gift view

All Matching gift records that have reference an organization before 7.26.00: 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 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' AND (A.MTCH_DT IS NULL AND A.MTCH_DENIED_DT IS NULL)

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 , B.GIFT_DT FROM PS_AV_MTCH_GIFT A , PS_AV_GIFT_DTL B , PS_AV_SESSION_TBL C WHERE B.BUSINESS_UNIT = C.BUSINESS_UNIT AND B.SESSION_NO = C.SESSION_NO AND A.SESSION_NO = B.SESSION_NO AND A.GIFT_NO = B.GIFT_NO AND B.ADJUSTMENT_FLG='N' AND C.SESS_STATUS='P' AND (A.MTCH_DT IS NULL AND A.MTCH_DENIED_DT IS NULL)

# 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

Prompt Table: AV_EXT_ORG_SRCH

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

Prompt Table: AV_PEOPLE_SRCH

4 SESSION_NO Character(11) VARCHAR2(11) NOT NULL Session Nbr
5 GIFT_NO Character(11) VARCHAR2(11) NOT NULL Gift Nbr
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

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
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