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.

PRCSOUTTYPE_VW

(SQL View)

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

#	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