AV_INTV_BUILD (SQL View)	Index Back
Initiative Audience Build Initiative Audience Build Record.

AV_INTV_BUILD

(SQL View)

Initiative Audience Build

Initiative Audience Build Record.

SELECT A.INSTITUTION , A.INTV_CD , B.AV_AUDIENCE , B.AUD_TYPE , A.AV_SELECTION_PRCS , A.INTV_TYPE , B.AV_MBR_CRIT_TYP , A.START_DT , A.END_DT FROM PS_AV_INTV_TBL A , PS_AV_INTV_AUDIENC B WHERE A.INSTITUTION = B.INSTITUTION AND A.INTV_CD = B.INTV_CD AND B.BUILT_FLG = 'N'

# 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_AUDIENCE Character(10) VARCHAR2(10) NOT NULL Audience Code

4 AUD_TYPE Character(1) VARCHAR2(1) NOT NULL Indicates whether the population is being identified for Segmentation, Reporting, or Administration.
A=Administrative
R=Reporting
S=Segmentation

5 AV_SELECTION_PRCS Character(1) VARCHAR2(1) NOT NULL Select of Process in Audience Criteria.
B=Build/Merge Process
P=Population Selection

6 INTV_TYPE Character(10) VARCHAR2(10) NOT NULL Initiative Type

7 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

8 START_DT Date(10) DATE Start Date

9 END_DT Date(10) DATE end date

#	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_AUDIENCE	Character(10)	VARCHAR2(10) NOT NULL	Audience Code
4	AUD_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Indicates whether the population is being identified for Segmentation, Reporting, or Administration. A=Administrative R=Reporting S=Segmentation
5	AV_SELECTION_PRCS	Character(1)	VARCHAR2(1) NOT NULL	Select of Process in Audience Criteria. B=Build/Merge Process P=Population Selection
6	INTV_TYPE	Character(10)	VARCHAR2(10) NOT NULL	Initiative Type
7	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
8	START_DT	Date(10)	DATE	Start Date
9	END_DT	Date(10)	DATE	end date