PRCSOUTPUTLIST (SQL Table)	Index Back
Prcs Output List This record is used by the Process Scheduler to store all the valid output type, output format for each genprcs.

PRCSOUTPUTLIST

(SQL Table)

Prcs Output List

This record is used by the Process Scheduler to store all the valid output type, output format for each genprcs.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 GENPRCSTYPE Character(2) VARCHAR2(2) NOT NULL Generic Process Type
0=Other
1=SQR
2=PeopleSoft COBOL
3=Crystal Report
4=Winword Macro
5=Application Engine
6=Cube Builder
7=nVision
8=Data Mover
9=PSJob

2 PTNONUNPRCSNAME Character(12) VARCHAR2(12) NOT NULL Process Name
Default Value: -

3 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

4 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)

5 ACTIVE_FLAG Character(1) VARCHAR2(1) NOT NULL Active Flag
A=Active
I=Inactive

6 DEFAULT_OUTPUT Character(1) VARCHAR2(1) NOT NULL Default Output

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	GENPRCSTYPE	Character(2)	VARCHAR2(2) NOT NULL	Generic Process Type 0=Other 1=SQR 2=PeopleSoft COBOL 3=Crystal Report 4=Winword Macro 5=Application Engine 6=Cube Builder 7=nVision 8=Data Mover 9=PSJob
2	PTNONUNPRCSNAME	Character(12)	VARCHAR2(12) NOT NULL	Process Name Default Value: -
3	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
4	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)
5	ACTIVE_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Active Flag A=Active I=Inactive
6	DEFAULT_OUTPUT	Character(1)	VARCHAR2(1) NOT NULL	Default Output