OUTFMTNONUNLANG

index back

Output Fmt Non Unique process

This view is used by the Process Scheduler Request Dialog to filter Output Format for Non Unique processes.
SELECT O.GENPRCSTYPE , O.PTNONUNPRCSNAME , O.OUTDESTTYPE , O.OUTDESTFORMAT , X.LANGUAGE_CD , X.XLATSHORTNAME FROM PS_PRCSOUTPUTLIST O , PSXLATITEMLANG X WHERE O.OUTDESTFORMAT = X.FIELDVALUE AND X.FIELDNAME = 'OUTDESTFORMAT' AND O.ACTIVE_FLAG = '1'

  • Related language record for OUTFORMATNONUN
  • PeopleSoft Field NameField TypeColumn TypeDescription
    GENPRCSTYPECharacter(2)VARCHAR2(2) NOT NULLGeneric 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
    PTNONUNPRCSNAMECharacter(12)VARCHAR2(12) NOT NULLProcess Name
    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
    OUTDESTFORMATCharacter(3)VARCHAR2(3) NOT NULLProcess Request output format
    0=Any
    1=(None)
    10=Postscript (*.lis)
    11=Crystal Report (*.rpt)
    12=Rich Text File (*.rtf)
    13=SQR Portable Format (*.spf)
    14=Text Files (*.txt)
    15=Other
    16=Default
    17=XML Format(*.xml)
    18=Data Mover Data File (*.dat)
    19=Crystal Report Explorer(*.rpt)
    2=Acrobat (*.pdf)
    20=XMLP
    21=Atom
    22=Transformation
    23=Printer Command Lang. (*.pcl)
    24=PostScript (*.ps)
    3=Comma delimited (*.csv)
    4=HP Format (*.lis)
    5=HTML Documents (*.htm)
    6=Line Printer Format (*.lis)
    7=Lotus 1-2-3 Files (*.wks)
    8=Microsoft Excel Files (*.xls)
    9=Microsoft Word (*.doc)
    LANGUAGE_CDCharacter(3)VARCHAR2(3) NOT NULLLanguage Code translate values
    OUTDESTFORMATDESCRCharacter(10)VARCHAR2(10) NOT NULLProcess Scheduler Destination Format
    index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
    PTRef generated on 09-JUN-19