INSTITUTIONEMPLIDEXT_ORG_IDDESIGNATIONAV_DES_PHIL_VW(SQL View) |
Index Back |
|---|---|
Philanthropic DesignationsThis view contains the total # of Gifts, total Gift amount, start and end dates for a Designation. 07/20/99 CD Modified SQL: SELECT INSTITUTION, EMPLID, EXT_ORG_ID, DESIGNATION, COUNT (DISTINCT GIFT_NO), SUM (RCG_DES_AMT), MIN (GIFT_DT), MAX (GIFT_DT) FROM PS_AV_RCG_DES WHERE STATUS = 'A' GROUP BY INSTITUTION, EMPLID, EXT_ORG_ID, DESIGNATION |
| SELECT DISTINCT INSTITUTION , EMPLID , EXT_ORG_ID , DESIGNATION , AV_DES_BU , COUNT (*) , SUM (RCG_DES_AMT) , CURRENCY_CD , MIN (GIFT_DT) , MAX (GIFT_DT) FROM PS_AV_RCG_DES WHERE STATUS = 'A' GROUP BY INSTITUTION, EMPLID, EXT_ORG_ID, DESIGNATION,AV_DES_BU, CURRENCY_CD |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | INSTITUTION |
Character(5) | VARCHAR2(5) NOT NULL | Academic Institution |
| 2 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 3 | EXT_ORG_ID |
Character(11) | VARCHAR2(11) NOT NULL | External Org ID |
| 4 | DESIGNATION |
Character(11) | VARCHAR2(11) NOT NULL | Designation |
| 5 | AV_DES_BU | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 6 | NUM_GIFTS | Number(11,0) | DECIMAL(11) NOT NULL | Number of Gifts |
| 7 | RCG_DES_AMT | Signed Number(17,2) | DECIMAL(15,2) NOT NULL | Amount |
| 8 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
| 9 | FRST_GIFT_DT | Date(10) | DATE | 1st Gift Date |
| 10 | LAST_GIFT_DT | Date(10) | DATE | Last Gift Date |