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

AV_MBR_CRIT2_VW

(SQL View)

Mbr Organization Criteria vw

this table defines a Non Dues Membership Organization

SELECT DISTINCT A.BUSINESS_UNIT , A.AV_MBR_ORG_COD , A.AV_MBR_CRIT_TYP , B.XLATSHORTNAME FROM PS_AV_MBR_CRIT_TBL A , PSXLATITEM B WHERE B.FIELDNAME = 'AV_MBR_CRIT_TYP' AND B.FIELDVALUE = A.AV_MBR_CRIT_TYP AND 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 XLATSHORTNAME Character(10) VARCHAR2(10) NOT NULL Translate Value Short Name

#	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	XLATSHORTNAME	Character(10)	VARCHAR2(10) NOT NULL	Translate Value Short Name