PRCSRUNCNTLDTL

index back

Run Control Rec - Tools

This is the tools run control record that stores the Run Control information per each process type/name required by process scheduler to run a process.

  • Parent record: PSOPRDEFN
  • PeopleSoft Field Name Field Type Column Type Description
    OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
    RUNCNTLID Character(30) VARCHAR2(30) NOT NULL Run Control ID
    PRCSTYPE Character(30) VARCHAR2(30) NOT NULL Process Type
    PRCSNAME 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)
    OUTDEST Character(127) VARCHAR2(127) NOT NULL Process Scheduler Output Destination
    PSRF_FOLDER_NAME Character(18) VARCHAR2(18) NOT NULL Reporting Folder's Name
    EMAIL_WEB_RPT Character(1) VARCHAR2(1) NOT NULL Email Web Report
    0=Email report
    1=Email report
    N=Display report in browser
    Y=Email report
    EMAIL_LOG_FLAG Character(1) VARCHAR2(1) NOT NULL Email With Log
    PRCSFILENAME Character(254) VARCHAR2(254) NOT NULL FileName
    PT_RETENTIONDAYS Number(4,0) SMALLINT NOT NULL Retention Days
    index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
    PTRef generated on 09-JUN-19