AV_VOL_MBR_VW (SQL View)	Index Back
Volunteer Member View This view shows all the Distinct occurrences of Membr Org Code on the Volunteer Group Table where Intv_Cd = NULL. ======================================================== 5/18/01 (JPM) - Removed EFFDT and EFF_STATUS. Also, modified sql. old sql: SELECT DISTINCT INSTITUTION , EFFDT , AV_MBR_ORG_COD , EFF_STATUS FROM PS_AV_VOL_GRP_TBL WHERE INTV_CD = ' ' ========================================================

AV_VOL_MBR_VW

(SQL View)

Volunteer Member View

This view shows all the Distinct occurrences of Membr Org Code on the Volunteer Group Table where Intv_Cd = NULL. ======================================================== 5/18/01 (JPM) - Removed EFFDT and EFF_STATUS. Also, modified sql. old sql: SELECT DISTINCT INSTITUTION , EFFDT , AV_MBR_ORG_COD , EFF_STATUS FROM PS_AV_VOL_GRP_TBL WHERE INTV_CD = ' ' ========================================================

SELECT DISTINCT INSTITUTION , AV_MBR_ORG_COD FROM PS_AV_VOL_GRP_TBL WHERE INTV_CD = ' ' AND EFF_STATUS = 'A'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution

2 RSRC_MBR_ORG_CD Character(10) VARCHAR2(10) NOT NULL Member Organization Code

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	INSTITUTION	Character(5)	VARCHAR2(5) NOT NULL	Academic Institution
2	RSRC_MBR_ORG_CD	Character(10)	VARCHAR2(10) NOT NULL	Member Organization Code