AV_AUD_INTV_AET

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
3	RUN_CNTL_ID	Character(30)	VARCHAR2(30) NOT NULL	Run Control ID
4	INSTITUTION	Character(5)	VARCHAR2(5) NOT NULL	Academic Institution
5	AV_SELECTION_PRCS	Character(1)	VARCHAR2(1) NOT NULL	Select of Process in Audience Criteria. B=Build/Merge Process P=Population Selection
6	AV_BUILD_TEMP	Character(1)	VARCHAR2(1) NOT NULL	Temporary Build Field used in Build Process.
7	AV_MERGE_INTV	Character(1)	VARCHAR2(1) NOT NULL	Merge to Initiative used in Build Process.
8	INTV_CD	Character(10)	VARCHAR2(10) NOT NULL	Initiative Code
9	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
10	AV_AUDIENCE	Character(10)	VARCHAR2(10) NOT NULL	Audience Code
11	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
12	EXIST	Character(1)	VARCHAR2(1) NOT NULL	Currency Exist