INSTITUTIONGCLUB_CDPrompt Table: AV_GCLUB_TBL
GCLUB_LVLAV_FYR_LONG2AV_GCLUB_FYR_VW(SQL View) |
Index Back |
|---|---|
Giving Club Fiscal Year ViewGiving Club Fiscal Year View View changed 072202 by JFL - Old view: "SELECT DISTINCT INSTITUTION, GCLUB_CD, GCLUB_LVL, FISCAL_YEAR FROM PS_AV_GCLUB_MBR" |
| SELECT DISTINCT INSTITUTION , GCLUB_CD , GCLUB_LVL , FISCAL_YEAR FROM PS_AV_GCLUB_MBR WHERE GCLUB_MBR_STATUS = 'M' |
| # | 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
Prompt Table: AV_GCLUB_TBL |
| 3 | GCLUB_LVL |
Character(9) | VARCHAR2(9) NOT NULL | Giving Club Level |
| 4 | AV_FYR_LONG2 |
Number(11,0) | DECIMAL(11) NOT NULL | Fiscal Year |