INSTITUTIONGCLUB_CDGCLUB_LVLFISCAL_YEARAV_GC_ML_CNT_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, COUNT(*) FROM PS_AV_GCLUB_MBR WHERE GCLUB_MBR_STATUS = 'M' GROUP BY INSTITUTION, GCLUB_CD, GCLUB_LVL, FISCAL_YEAR |
| # | 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 | GCLUB_MBR_CNT | Number(7,0) | INTEGER NOT NULL | Member Count |