AV_RCG_DES_6_VW (SQL View)	Index Back
Pledge Payments to Date This is a view of AV_RCG_DES and AV_GIFT_DTL that sums all payments made toward pledges to this campaign. before 8.2.00 SELECT A.INSTITUTION, A.INTV_CD, SUM(A.RCG_DES_AMT) FROM PS_AV_RCG_DES A, PS_AV_GIFT_DTL B WHERE A.INSTITUTION = B.INSTITUTION AND A.SESSION_NO = B.SESSION_NO AND A.GIFT_NO = B.GIFT_NO AND A.STATUS = 'A' AND A.RECOGNITION_TYPE = 'H' AND (A.AV_SESS_TYPE = 'AG' OR A.AV_SESS_TYPE = 'G') AND B.GIFT_TYPE = 'PP' GROUP BY A.INSTITUTION, A.INTV_CD

AV_RCG_DES_6_VW

(SQL View)

Pledge Payments to Date

This is a view of AV_RCG_DES and AV_GIFT_DTL that sums all payments made toward pledges to this campaign. before 8.2.00 SELECT A.INSTITUTION, A.INTV_CD, SUM(A.RCG_DES_AMT) FROM PS_AV_RCG_DES A, PS_AV_GIFT_DTL B WHERE A.INSTITUTION = B.INSTITUTION AND A.SESSION_NO = B.SESSION_NO AND A.GIFT_NO = B.GIFT_NO AND A.STATUS = 'A' AND A.RECOGNITION_TYPE = 'H' AND (A.AV_SESS_TYPE = 'AG' OR A.AV_SESS_TYPE = 'G') AND B.GIFT_TYPE = 'PP' GROUP BY A.INSTITUTION, A.INTV_CD

SELECT A.INSTITUTION, A.INTV_CD, SUM(A.RCG_DES_AMT) FROM PS_AV_RCG_DES A, PS_AV_GIFT_DTL B WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.SESSION_NO = B.SESSION_NO AND A.GIFT_NO = B.GIFT_NO AND A.STATUS = 'A' AND A.RECOGNITION_TYPE = 'H' AND (A.AV_SESS_TYPE = 'AG' OR A.AV_SESS_TYPE = 'G') AND B.GIFT_TYPE = 'PP' GROUP BY A.INSTITUTION, A.INTV_CD

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution

2 INTV_CD Character(10) VARCHAR2(10) NOT NULL Initiative Code

3 RCG_DES_AMT_TOT Number(16,2) DECIMAL(15,2) NOT NULL Field used to sum RCG_DES_AMT from PS_AV_RCG_DES.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	INSTITUTION	Character(5)	VARCHAR2(5) NOT NULL	Academic Institution
2	INTV_CD	Character(10)	VARCHAR2(10) NOT NULL	Initiative Code
3	RCG_DES_AMT_TOT	Number(16,2)	DECIMAL(15,2) NOT NULL	Field used to sum RCG_DES_AMT from PS_AV_RCG_DES.