INSTITUTIONINTV_CDAV_MBR_ORG_CODVOL_GRP_NBREFFDTA=Active
I=Inactive
AV_VOL_GRP_VW(SQL View) |
Index Back |
|---|---|
Volunteer Group ViewThis view mirrors the AV_VOL_GRP_TBL for use in the AV_VOL_GA_SBP panel. ======================================================== 5/4/01 (JPM) Modified SQL, I removed most of the WHERE clause. Also, made effdt a descending key. old sql: SELECT A.INSTITUTION ,A.INTV_CD ,A.AV_MBR_ORG_COD ,A.VOL_GRP_NBR ,A.EFFDT ,A.EFF_STATUS ,A.VOL_GROUP_NAME ,A.VOL_GRP_LVL ,A.VOL_STRCT_NBR ,A.INTV_TYPE FROM PS_AV_VOL_GRP_TBL A WHERE A.VOL_GRP_LVL = 2 AND A.EFFDT = ( SELECT MAX(A1.EFFDT) FROM PS_AV_VOL_GRP_TBL A1 WHERE A1.INSTITUTION = A.INSTITUTION AND A1.INTV_CD = A.INTV_CD AND A1.AV_MBR_ORG_COD = A.AV_MBR_ORG_COD AND A1.VOL_GRP_NBR = A.VOL_GRP_NBR AND A1.EFFDT <= %CurrentDateIn) AND A.EFF_STATUS = 'A' ======================================================== |
| SELECT A.INSTITUTION ,A.INTV_CD ,A.AV_MBR_ORG_COD ,A.VOL_GRP_NBR ,A.EFFDT ,A.EFF_STATUS ,A.VOL_GROUP_NAME ,A.VOL_GRP_LVL ,A.VOL_STRCT_NBR ,A.INTV_TYPE FROM PS_AV_VOL_GRP_TBL A WHERE A.VOL_GRP_LVL = 2 |
| # | 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 | AV_MBR_ORG_COD |
Character(10) | VARCHAR2(10) NOT NULL | Member Organization Code |
| 4 | VOL_GRP_NBR |
Number(9,0) | DECIMAL(9) NOT NULL | Volunteer Group |
| 5 | EFFDT |
Date(10) | DATE | Effective Date |
| 6 | EFF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Effective Status
A=Active I=Inactive |
| 7 | VOL_GROUP_NAME | Character(50) | VARCHAR2(50) NOT NULL | Volunteer Group |
| 8 | VOL_GRP_LVL | Number(1,0) | SMALLINT NOT NULL | Group Level |
| 9 | VOL_STRCT_NBR | Number(9,0) | DECIMAL(9) NOT NULL | Volunteer Structure Nbr |
| 10 | INTV_TYPE | Character(10) | VARCHAR2(10) NOT NULL | Initiative Type |