PRCSOUTTYPE_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 GENPRCSTYPE , PTNONUNPRCSNAME , OUTDESTTYPE , ACTIVE_FLAG , DEFAULT_OUTPUT FROM PS_PRCSOUTDESTTYPE WHERE GENPRCSTYPE <> '9'

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