AVINTV1AUDPOPVW (SQL View)	Index Back
Initiative Audience This view will select all Initiative already built with audience criteria for Pop Selection.

AVINTV1AUDPOPVW

(SQL View)

Initiative Audience

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

SELECT DISTINCT A.INSTITUTION , A.INTV_CD , A.DESCR60 FROM PS_AV_INTV_TBL A , PS_AV_INTV_AUDIENC B WHERE A.INSTITUTION = B.INSTITUTION AND A.INTV_CD = B.INTV_CD AND BUILT_FLG='Y' AND A.AV_SELECTION_PRCS = 'P'

# 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 DESCR60 Character(60) VARCHAR2(60) NOT NULL Description

#	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	DESCR60	Character(60)	VARCHAR2(60) NOT NULL	Description