INSTITUTIONINTV_CDAV_CMPGN_ITP_VW(SQL View) |
Index Back |
|---|---|
Irrevocable Trust Present ValView to produce the Irrevocable Trust Present Value. |
| SELECT A.INSTITUTION, A.INTV_CD, SUM(B.TRUST_FUT_VAL) FROM PS_AV_TRUST_TBL A, PS_AV_TRUST_VAL B WHERE A.INSTITUTION = B.INSTITUTION AND A.EMPLID = B.EMPLID AND A.PGIVING_NBR = B.PGIVING_NBR AND A.PG_IRREVOCABLE = 'Y' AND B.TRUST_VAL_DT = (SELECT MAX(B1.TRUST_VAL_DT) FROM PS_AV_TRUST_VAL B1 WHERE B1.INSTITUTION = B.INSTITUTION AND B1.EMPLID = B.EMPLID AND B1.PGIVING_NBR = B.PGIVING_NBR) 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 | DEFERRED_GIFT_TOT | Number(16,2) | DECIMAL(15,2) NOT NULL | Field used in views to sum various Deferred Gift Amounts. ex: Irrevocable Gifts - Present Value Irrevocable Gifts - Market Value Revocable Gifts - Present Value Revocable Gifts - Market Value |