INSTITUTIONGCLUB_CDGCLUB_LVLFISCAL_YEARAV_GC_ML_SUM_VW(SQL View) |
Index Back |
|---|---|
Giving Club Level Member CountReturns the number of valid members in a giving clublevel for a particular fiscal year. |
| SELECT INSTITUTION , GCLUB_CD , GCLUB_LVL , FISCAL_YEAR , CURRENCY_CD , SUM(GCLUB_AMT) FROM PS_AV_GCLUB_MBR WHERE (GCLUB_MBR_STATUS = 'M' OR GCLUB_MBR_STATUS = 'X') GROUP BY INSTITUTION, GCLUB_CD, GCLUB_LVL, FISCAL_YEAR, CURRENCY_CD |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | INSTITUTION |
Character(5) | VARCHAR2(5) NOT NULL | Academic Institution |
| 2 | GCLUB_CD |
Character(9) | VARCHAR2(9) NOT NULL | Giving Club Code |
| 3 | GCLUB_LVL |
Character(9) | VARCHAR2(9) NOT NULL | Giving Club Level |
| 4 | FISCAL_YEAR |
Number(4,0) | SMALLINT NOT NULL | Fiscal Year |
| 5 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
| 6 | GCLUB_MBR_AMT | Number(16,2) | DECIMAL(15,2) NOT NULL | Total Amount |