AV_AUDIENCE_TBL

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	INSTITUTION	Character(5)	VARCHAR2(5) NOT NULL	Academic Institution Default Value: AV_OPR_DEF_TBL.INSTITUTION Prompt Table: INSTITUTION_TBL
2	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
3	AV_AUDIENCE	Character(10)	VARCHAR2(10) NOT NULL	Audience Code
4	EFFDT	Date(10)	DATE NOT NULL	Effective Date Default Value: %date
5	EFF_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Effective Status A=Active I=Inactive Default Value: A
6	AV_APPROVED	Character(1)	VARCHAR2(1) NOT NULL	Approved Y/N Table Edit Default Value: N
7	DESCR60	Character(60)	VARCHAR2(60) NOT NULL	Description
8	AV_SELECTION_PRCS	Character(1)	VARCHAR2(1) NOT NULL	Select of Process in Audience Criteria. B=Build/Merge Process P=Population Selection Default Value: B
9	SCCPS_POP_SEL	Character(1)	VARCHAR2(1) NOT NULL	Population Selection checkbox - used to incidate on run controls that pop selection was selected for use. Y/N Table Edit Default Value: Y
10	SCCPS_TOOL_ID	Number(15,0)	DECIMAL(15) NOT NULL	Tool ID - the unique key for a pop select tool Prompt Table: SCCPS_TOOL_VW
11	SCCPS_QUERY_NAME	Character(50)	VARCHAR2(50) NOT NULL	Query / Section name used by population selection Prompt Table: %EDITTABLE
12	SCCPS_CNTXT_ID	Number(15,0)	DECIMAL(15) NOT NULL	Context ID - the unique key that identifies the pop selection context Prompt Table: SCCPS_CNTXT_VW
13	ATTACHSYSFILENAME	Character(128)	VARCHAR2(128) NOT NULL	Unique Sys Filename
14	ATTACHUSERFILE	Character(64)	VARCHAR2(64) NOT NULL	Attached File
15	SCCPS_FILE_PATH	Character(254)	VARCHAR2(254) NOT NULL	Pop Select File Path and Name