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

AV_MBR_CRIT3_VW

(SQL View)

Mbr Organization Criteria vw

this table defines a Non Dues Membership Organization

SELECT BUSINESS_UNIT , AV_MBR_ORG_COD , AV_MBR_CRIT_TYP , AV_AUDIENCE 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

3 AV_MBR_CRIT_TYP Character(1) VARCHAR2(1) NOT NULL This field is used to capture the type of Membership Criteria the user is setting up. It will identify whether to search for Person (people) or Organization (businesses).
B=Both
O=Organization
P=Person

4 AV_AUDIENCE Character(10) VARCHAR2(10) NOT NULL Audience 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
3	AV_MBR_CRIT_TYP	Character(1)	VARCHAR2(1) NOT NULL	This field is used to capture the type of Membership Criteria the user is setting up. It will identify whether to search for Person (people) or Organization (businesses). B=Both O=Organization P=Person
4	AV_AUDIENCE	Character(10)	VARCHAR2(10) NOT NULL	Audience Code