PRCSOUTPUT_VW

(SQL View)
 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.

SELECT O.GENPRCSTYPE , O.OUTDESTTYPE , O.OUTDESTFORMAT , O.DEFAULT_OUTPUT ,O.ACTIVE_FLAG FROM PS_PRCSOUTPUTLIST O , PS_PRCSOUTTYPE_VW P WHERE O.GENPRCSTYPE <> '9' AND O.GENPRCSTYPE = P.GENPRCSTYPE AND O.OUTDESTTYPE = P.OUTDESTTYPE AND P.ACTIVE_FLAG = '1'

# 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 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
3 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)
4 DEFAULT_OUTPUT Character(1) VARCHAR2(1) NOT NULL Default Output
5 ACTIVE_FLAG Character(1) VARCHAR2(1) NOT NULL Active Flag
A=Active
I=Inactive