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

PSPRCSRUNCNTL

(SQL Table)

Run Control Rec - Tools

This is the tools run control record that stores the Run Control information 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 VERSION Number(10,0) DECIMAL(10) NOT NULL Version. Internal PeopleTools version for controlling caching of object. - Version/Table reference

4 SERVERNAME Character(8) VARCHAR2(8) NOT NULL Server Name

5 OUTDESTTYPE Character(3) VARCHAR2(3) NOT NULL Process Request output destination type.
0=Any
1=(None)
2=File
3=Printer
4=Window
5=Email
6=Web
7=Default
8=Feed
9=IB Node

6 OUTDESTFORMAT Character(3) VARCHAR2(3) NOT NULL Process Request output format
0=Any
1=(None)
10=Postscript (*.lis)
11=Crystal Report (*.rpt)
12=Rich Text File (*.rtf)
13=SQR Portable Format (*.spf)
14=Text Files (*.txt)
15=Other
16=Default
17=XML Format(*.xml)
18=Data Mover Data File (*.dat)
19=Crystal Report Explorer(*.rpt)
2=Acrobat (*.pdf)
20=XMLP
21=Atom
22=Transformation
23=Printer Command Lang. (*.pcl)
24=PostScript (*.ps)
3=Comma delimited (*.csv)
4=HP Format (*.lis)
5=HTML Documents (*.htm)
6=Line Printer Format (*.lis)
7=Lotus 1-2-3 Files (*.wks)
8=Microsoft Excel Files (*.xls)
9=Microsoft Word (*.doc)

7 SRVRDESTFILE Character(127) VARCHAR2(127) NOT NULL Server File Destination

8 SRVRDESTPRINTER Character(127) VARCHAR2(127) NOT NULL Server Destination Printer

9 CLNTDESTFILE Character(127) VARCHAR2(127) NOT NULL Client Destination File

10 CLNTDESTPRINTER Character(127) VARCHAR2(127) NOT NULL Client Destination Printer

11 RUNLOCATION Character(1) VARCHAR2(1) NOT NULL Run Location
0=Both
1=Client
2=Server

12 LASTUPDDTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.

13 LASTUPDOPRID Character(30) VARCHAR2(30) NOT NULL Specifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.

#	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	VERSION	Number(10,0)	DECIMAL(10) NOT NULL	Version. Internal PeopleTools version for controlling caching of object. - Version/Table reference
4	SERVERNAME	Character(8)	VARCHAR2(8) NOT NULL	Server Name
5	OUTDESTTYPE	Character(3)	VARCHAR2(3) NOT NULL	Process Request output destination type. 0=Any 1=(None) 2=File 3=Printer 4=Window 5=Email 6=Web 7=Default 8=Feed 9=IB Node
6	OUTDESTFORMAT	Character(3)	VARCHAR2(3) NOT NULL	Process Request output format 0=Any 1=(None) 10=Postscript (.lis) 11=Crystal Report (.rpt) 12=Rich Text File (.rtf) 13=SQR Portable Format (.spf) 14=Text Files (.txt) 15=Other 16=Default 17=XML Format(.xml) 18=Data Mover Data File (.dat) 19=Crystal Report Explorer(.rpt) 2=Acrobat (.pdf) 20=XMLP 21=Atom 22=Transformation 23=Printer Command Lang. (.pcl) 24=PostScript (.ps) 3=Comma delimited (.csv) 4=HP Format (.lis) 5=HTML Documents (.htm) 6=Line Printer Format (.lis) 7=Lotus 1-2-3 Files (.wks) 8=Microsoft Excel Files (.xls) 9=Microsoft Word (.doc)
7	SRVRDESTFILE	Character(127)	VARCHAR2(127) NOT NULL	Server File Destination
8	SRVRDESTPRINTER	Character(127)	VARCHAR2(127) NOT NULL	Server Destination Printer
9	CLNTDESTFILE	Character(127)	VARCHAR2(127) NOT NULL	Client Destination File
10	CLNTDESTPRINTER	Character(127)	VARCHAR2(127) NOT NULL	Client Destination Printer
11	RUNLOCATION	Character(1)	VARCHAR2(1) NOT NULL	Run Location 0=Both 1=Client 2=Server
12	LASTUPDDTTM	DateTime(26)	TIMESTAMP	Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
13	LASTUPDOPRID	Character(30)	VARCHAR2(30) NOT NULL	Specifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.