PSCONQRSOUTDSVW

(SQL View)
 Index Back

SELECT DISTINCT O.OUTDESTTYPE , %Substring(X.XLATLONGNAME , 1, 10) FROM PS_PRCSOUTPUTLIST O , PS_PRCSOUTDESTTYPE P , PSXLATITEM X WHERE O.OUTDESTTYPE = X.FIELDVALUE AND X.FIELDNAME = 'OUTDESTTYPE' AND O.ACTIVE_FLAG = '1' AND O.GENPRCSTYPE = P.GENPRCSTYPE AND O.OUTDESTTYPE = P.OUTDESTTYPE AND O.GENPRCSTYPE = '5' AND O.OUTDESTTYPE IN ('2','4', '6') AND P.ACTIVE_FLAG = '1'

  • Related Language Record: PSCONQRSOUTVWLG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 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
    2 OUTDESTTYPEDESCR Character(10) VARCHAR2(10) NOT NULL Process Scheduler Destination Type