PSAERSOUTDSVWLG

index back

SELECT DISTINCT O.OUTDESTTYPE , L.LANGUAGE_CD , %Substring (L.XLATLONGNAME , 1, 10) FROM PS_PRCSOUTPUTLIST O , PS_PRCSOUTDESTTYPE P , PSXLATITEMLANG L WHERE O.OUTDESTTYPE = L.FIELDVALUE AND L.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', '5', '6')

  • Related language record for PSAERSOUTDSVW
  • PeopleSoft Field NameField TypeColumn TypeDescription
    OUTDESTTYPECharacter(3)VARCHAR2(3) NOT NULLProcess 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
    LANGUAGE_CDCharacter(3)VARCHAR2(3) NOT NULLLanguage Code translate values
    OUTDESTTYPEDESCRCharacter(10)VARCHAR2(10) NOT NULLProcess Scheduler Destination Type
    index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
    PTRef generated on 09-JUN-19