AVCRTORGBLD_VW (SQL View)	Index Back
Organization Criteria View This view captures Audience Selection Criteria for Organizations with Build/Merge Option.

AVCRTORGBLD_VW

(SQL View)

Organization Criteria View

This view captures Audience Selection Criteria for Organizations with Build/Merge Option.

SELECT INSTITUTION , AV_MBR_CRIT_TYP , AV_AUDIENCE , DESCR60 , AV_APPROVED FROM PS_AV_AUDIENCE_TBL WHERE AV_MBR_CRIT_TYP='O' AND AV_APPROVED='Y' AND AV_SELECTION_PRCS = 'B'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution
Default Value: AV_OPR_DEF_TBL.INSTITUTION
Prompt Table: INSTITUTION_TBL

2 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
Default Value: P

3 AV_AUDIENCE Character(10) VARCHAR2(10) NOT NULL Audience Code

4 DESCR60 Character(60) VARCHAR2(60) NOT NULL Description

5 AV_APPROVED Character(1) VARCHAR2(1) NOT NULL Approved

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	INSTITUTION	Character(5)	VARCHAR2(5) NOT NULL	Academic Institution Default Value: AV_OPR_DEF_TBL.INSTITUTION Prompt Table: INSTITUTION_TBL
2	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 Default Value: P
3	AV_AUDIENCE	Character(10)	VARCHAR2(10) NOT NULL	Audience Code
4	DESCR60	Character(60)	VARCHAR2(60) NOT NULL	Description
5	AV_APPROVED	Character(1)	VARCHAR2(1) NOT NULL	Approved