AV_MTCH_O_G_VW

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

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

Prompt Table: INSTITUTN_SCRTY

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