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 Name Field Type Column Type Description
    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
    PTNONUNPRCSNAME Character(12) VARCHAR2(12) NOT NULL Process Name
    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
    OUTDESTFORMAT Character(3) VARCHAR2(3) NOT NULL Process 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_CD Character(3) VARCHAR2(3) NOT NULL Language Code translate values
    OUTDESTFORMATDESCR Character(10) VARCHAR2(10) NOT NULL Process Scheduler Destination Format
    index back (c)David Kurtz 2020, www.go-faster.co.uk PeopleTools 8.58
    PTRef generated on 21-DEC-20