AV_CMPGN_TTG_VW

(SQL View)
 Index Back

Campaign Top Ten Gift View

This view will bring back in order from greatest to least the top ten gifts given to a campaign. 30 Mar 2000 - Added Currency Code from AV_RCG_DES for multicurrency.

SELECT SUM(A.RCG_DES_AMT) , A.INSTITUTION , A.SESSION_NO , A.GIFT_NO , A.EMPLID , A.EXT_ORG_ID , A.INTV_CD , A.GIFT_DT , A.SA_ID_TYPE , A.AV_SESS_TYPE , A.CNST_TYPE , A.CURRENCY_CD FROM PS_AV_RCG_DES A , PS_AV_SESSION_TBL B WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.SESSION_NO = B.SESSION_NO AND B.SESS_STATUS = 'P' AND A.RECOGNITION_TYPE = 'H' AND A.STATUS = 'A' AND A.GIFT_TYPE <> 'PP' GROUP BY A.INSTITUTION, A.SESSION_NO, A.GIFT_NO, A.EMPLID, A.EXT_ORG_ID, A.INTV_CD, A.GIFT_DT, A.SA_ID_TYPE, A.AV_SESS_TYPE, A.CNST_TYPE, A.CURRENCY_CD

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 RCG_DES_AMT Signed Number(17,2) DECIMAL(15,2) NOT NULL Amount
2 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution
3 SESSION_NO Character(11) VARCHAR2(11) NOT NULL Session Nbr
4 GIFT_NO Character(11) VARCHAR2(11) NOT NULL Gift Nbr
5 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
6 EXT_ORG_ID Character(11) VARCHAR2(11) NOT NULL External Org ID
7 INTV_CD Character(10) VARCHAR2(10) NOT NULL Initiative Code
8 GIFT_DT Date(10) DATE Gift Date
9 SA_ID_TYPE Character(1) VARCHAR2(1) NOT NULL ID Type
O=Organization
P=Person
10 AV_SESS_TYPE Character(2) VARCHAR2(2) NOT NULL Session Type
AG=Gift Adjustment
AM=Adjust Membership
AP=Pledge Adjustment
G=Gift
M=Membership
PL=Pledge
11 CNST_TYPE Number(3,0) SMALLINT NOT NULL Constituent Type
12 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code