OUTTYPENONUNLNG

(SQL View)
 Index Back

Output type Non unique process

This view is used by request dialog to populate output types for non unique processes

SELECT DISTINCT O.GENPRCSTYPE , O.PTNONUNPRCSNAME , O.OUTDESTTYPE , X.LANGUAGE_CD , %Substring(X.XLATLONGNAME , 1,10) FROM PS_PRCSOUTPUTLIST O , PSXLATITEMLANG X WHERE O.OUTDESTTYPE = X.FIELDVALUE AND X.FIELDNAME = 'OUTDESTTYPE' AND O.ACTIVE_FLAG = '1'

  • Related Language Record for OUTTYPENONUN

    • # 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 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    5 OUTDESTTYPEDESCR Character(10) VARCHAR2(10) NOT NULL Process Scheduler Destination Type