AV_MBR_CRIT1_VW (SQL View)	Index Back
Mbr Organization Criteria vw this table defines a Non Dues Membership Organization

AV_MBR_CRIT1_VW

(SQL View)

Mbr Organization Criteria vw

this table defines a Non Dues Membership Organization

SELECT BUSINESS_UNIT , AV_MBR_ORG_COD FROM PS_AV_MBR_CRIT_TBL WHERE BUILT_FLG='Y'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
2	AV_MBR_ORG_COD	Character(10)	VARCHAR2(10) NOT NULL	Member Organization Code