AV_RUNCTL_MBR (SQL Table)	Index Back
Process Run Control This record holds the data needed to process the Build Member Audience cobol program.

AV_RUNCTL_MBR

(SQL Table)

Process Run Control

This record holds the data needed to process the Build Member Audience cobol program.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
Prompt Table: OPERATOR_VW

2 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID

3 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
Default Value: AV_OPR_DEF_TBL.BUSINESS_UNIT
Prompt Table: AV_BUS_UNIT_TBL

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
Default Value: B

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.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN). Prompt Table: OPERATOR_VW
2	RUN_CNTL_ID	Character(30)	VARCHAR2(30) NOT NULL	Run Control ID
3	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Default Value: AV_OPR_DEF_TBL.BUSINESS_UNIT Prompt Table: AV_BUS_UNIT_TBL
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 Default Value: B
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.