INSTITUTIONINTV_CDAV_RCG_DES_7_VW(SQL View) |
Index Back |
|---|---|
Gits-in-Kind to DateThis is a view of AV_RCG_DES and AV_GIFT_DTL that sums all gifts with a gift type of Gift-in-Kind that have been given to the 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 = 'GIK' 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 = 'GIK' 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. |