AV_AUD_MBR_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	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
6	AV_SELECTION_PRCS	Character(1)	VARCHAR2(1) NOT NULL	Select of Process in Audience Criteria. B=Build/Merge Process P=Population Selection
7	AV_BUILD_TEMP	Character(1)	VARCHAR2(1) NOT NULL	Temporary Build Field used in Build Process.
8	AV_MERGE_INTV	Character(1)	VARCHAR2(1) NOT NULL	Merge to Initiative used in Build Process.
9	AV_MBR_ORG_COD	Character(10)	VARCHAR2(10) NOT NULL	Member Organization Code
10	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
11	AV_AUDIENCE	Character(10)	VARCHAR2(10) NOT NULL	Audience Code
12	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
13	EXIST	Character(1)	VARCHAR2(1) NOT NULL	Currency Exist