INSTITUTIONINTV_TYPEINTV_CDDefault Value: %Date
A=Active
I=Inactive
Default Value: A
AV_VOL_ADD_2_VW(SQL View) |
Index Back |
|---|---|
Vol Sub-Group prompt 2 for AddThis is a view of the AV_VOL_GRP_TBL that is used on the search record for adding sub-groups. It will show all the Initiatives that exist for Leaderhship groups and Intv_Type ======================================================== 5/8/01 (JPM) - Modified view WHERE clause. EFFDT no longer a descending key field. old sql: SELECT DISTINCT INSTITUTION ,INTV_TYPE ,INTV_CD ,EFFDT ,EFF_STATUS FROM PS_AV_VOL_GRP_TBL WHERE VOL_GRP_LVL = 1 ======================================================== |
| SELECT DISTINCT A.INSTITUTION ,A.INTV_TYPE ,A.INTV_CD ,A.EFFDT ,A.EFF_STATUS FROM PS_AV_VOL_GRP_TBL A WHERE A.VOL_GRP_LVL = 1 AND A.INTV_TYPE <> ' ' 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.VOL_GRP_NBR = A.VOL_GRP_NBR AND A1.EFF_STATUS = 'A') |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | INSTITUTION |
Character(5) | VARCHAR2(5) NOT NULL | Academic Institution |
| 2 | INTV_TYPE |
Character(10) | VARCHAR2(10) NOT NULL | Initiative Type |
| 3 | INTV_CD |
Character(10) | VARCHAR2(10) NOT NULL | Initiative Code |
| 4 | EFFDT | Date(10) | DATE |
Effective Date
Default Value: %Date |
| 5 | EFF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Effective Status
A=Active I=Inactive Default Value: A |