Vol Sub-Group prompt 1 for Add
This 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 Intv_Types that exist for Leaderhship groups.
========================================================
5/18/01 - (JPM) Removed EFFDT and EFF_STATUS. Modified SQL too.
SELECT DISTINCT A.INSTITUTION
,A.INTV_TYPE
,A.EFFDT
,A.EFF_STATUS
FROM PS_AV_VOL_GRP_TBL A
WHERE A.VOL_GRP_LVL = 1
AND A.INTV_CD <> ' '
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')
======================================================== |
INSTITUTION