BAS_ODEM_PRNCTL (SQL Table)	Index Back
Online Print Configuration This record is used to contain the user preferences regarding runlocation and output type for the check printing SQRs run within Online Check processing. These preferences are stored by Operator Id.

BAS_ODEM_PRNCTL

(SQL Table)

Online Print Configuration

This record is used to contain the user preferences regarding runlocation and output type for the check printing SQRs run within Online Check processing. These preferences are stored by Operator Id.

# 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 RUNLOCATION Character(1) VARCHAR2(1) NOT NULL Run Location
0=Both
1=Client
2=Server
Default Value: 2

3 SERVERNAME Character(8) VARCHAR2(8) NOT NULL Server Name
Prompt Table: SERVERDEFN

4 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
Default Value: 2

5 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)
Default Value: 4

6 OUTDEST Character(127) VARCHAR2(127) NOT NULL Process Scheduler Output Destination

#	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	RUNLOCATION	Character(1)	VARCHAR2(1) NOT NULL	Run Location 0=Both 1=Client 2=Server Default Value: 2
3	SERVERNAME	Character(8)	VARCHAR2(8) NOT NULL	Server Name Prompt Table: SERVERDEFN
4	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 Default Value: 2
5	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) Default Value: 4
6	OUTDEST	Character(127)	VARCHAR2(127) NOT NULL	Process Scheduler Output Destination