PRCSRUNCNTLEOPT (SQL Table)	Index Back
Run Control Rec - Tools This is the tools run control record that stores the Run Control information per each process type/name required by process scheduler to run a process.

PRCSRUNCNTLEOPT

(SQL Table)

Run Control Rec - Tools

This is the tools run control record that stores the Run Control information per each process type/name required by process scheduler to run a process.

Parent record: PSOPRDEFN

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

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

3 PRCSTYPE Character(30) VARCHAR2(30) NOT NULL Process Type

4 PRCSNAME Character(12) VARCHAR2(12) NOT NULL Process Name

5 RQSTTEXTTYPE Character(2) VARCHAR2(2) NOT NULL Process Request Text Type. This describes the different long text fields associated with a specific Process Reuqest
1=Email Address
2=Email Subject
3=Email Text
4=Email Address Expanded List
5=Distribution List
6=Original Extended Parameter
7=Extended Parameter

6 RQST_TEXT Long Character CLOB Process Request long text fields. This is used to hold values for any long text associated with a process request. For instance, this includes Email informationlike text, subject, or addresss.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
2	RUNCNTLID	Character(30)	VARCHAR2(30) NOT NULL	Run Control ID
3	PRCSTYPE	Character(30)	VARCHAR2(30) NOT NULL	Process Type
4	PRCSNAME	Character(12)	VARCHAR2(12) NOT NULL	Process Name
5	RQSTTEXTTYPE	Character(2)	VARCHAR2(2) NOT NULL	Process Request Text Type. This describes the different long text fields associated with a specific Process Reuqest 1=Email Address 2=Email Subject 3=Email Text 4=Email Address Expanded List 5=Distribution List 6=Original Extended Parameter 7=Extended Parameter
6	RQST_TEXT	Long Character	CLOB	Process Request long text fields. This is used to hold values for any long text associated with a process request. For instance, this includes Email informationlike text, subject, or addresss.