AP_OUTTYPE_VW

(SQL View)
 Index Back

AP OutDestType Vw


SELECT DISTINCT O.OUTDESTTYPE , %Substring(X.XLATLONGNAME ,1,10) FROM PSXLATITEM X , PS_PRCSOUTPUTLIST O , PSOPTIONS B WHERE X.FIELDNAME = 'OUTDESTTYPE' AND X.FIELDVALUE IN ('2','3','6') AND X.FIELDVALUE = O.OUTDESTTYPE AND O.GENPRCSTYPE = '3'

  • Related Language Record: AP_OUTTYPE_VWLG

    • # 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