OUTDESTFORMAT

(SQL View)
 Index Back

Request Dialog - Output Type

This view is used by the Process Scheduler Request Dialog to filter Output Types.

SELECT O.GENPRCSTYPE , O.PTNONUNPRCSNAME , O.OUTDESTTYPE , O.OUTDESTFORMAT , X.XLATSHORTNAME FROM PS_PRCSOUTPUTLIST O , PSXLATITEM X WHERE O.OUTDESTFORMAT = X.FIELDVALUE AND X.FIELDNAME = 'OUTDESTFORMAT' AND O.ACTIVE_FLAG = '1'

  • Related Language Record: OUTDESTFMT_LANG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 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
    2 PTNONUNPRCSNAME Character(12) VARCHAR2(12) NOT NULL Process Name
    3 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
    4 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)
    5 OUTDESTFORMATDESCR Character(10) VARCHAR2(10) NOT NULL Process Scheduler Destination Format