AV_INTV2_AUD_VW (SQL View)	Index Back
Initiative Audience This view will select all Initiative already built with audience criteria.

AV_INTV2_AUD_VW

(SQL View)

Initiative Audience

This view will select all Initiative already built with audience criteria.

SELECT DISTINCT A.INSTITUTION , A.INTV_CD , A.AV_MBR_CRIT_TYP ,B.XLATSHORTNAME FROM PS_AV_INTV_AUDIENC A , PSXLATITEM B WHERE B.FIELDNAME = 'AV_MBR_CRIT_TYP' AND A.AV_MBR_CRIT_TYP = B.FIELDVALUE AND BUILT_FLG='Y'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 INTV_CD Character(10) VARCHAR2(10) NOT NULL Initiative 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	INSTITUTION	Character(5)	VARCHAR2(5) NOT NULL	Academic Institution
2	INTV_CD	Character(10)	VARCHAR2(10) NOT NULL	Initiative 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