INSTITUTIONINTV_CDAV_RCG_DES_3_VW(SQL View) |
Index Back |
|---|---|
Outright Gifts to DateThis is a view of AV_RCG_DES and AV_GIFT_DTL that sums the amount of direct gifts to the campaign excluding outstanding pledges and deferred gifts. 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 = 'GIFT' OR B.GIFT_TYPE = 'MG') 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 = 'GIFT' OR B.GIFT_TYPE = 'MG') 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 | GIFT_AMT_TOT | Number(16,2) | DECIMAL(15,2) NOT NULL | Gift Table Total |