PRCSRUNCNTLDTL

(SQL Table)
 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 PeopleSoft Field Type Database Column Type Description
    1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
    2 RUNCNTLID Character(30) VARCHAR2(30) NOT NULL Run Control ID
    3 PRCSTYPE Character(30) VARCHAR2(30) NOT NULL Process Type
    4 PRCSNAME Character(12) VARCHAR2(12) NOT NULL Process Name
    5 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
    6 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)
    7 OUTDEST Character(127) VARCHAR2(127) NOT NULL Process Scheduler Output Destination
    8 PSRF_FOLDER_NAME Character(18) VARCHAR2(18) NOT NULL Reporting Folder's Name
    9 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
    10 EMAIL_LOG_FLAG Character(1) VARCHAR2(1) NOT NULL Email With Log
    11 PRCSFILENAME Character(254) VARCHAR2(254) NOT NULL FileName
    12 PT_RETENTIONDAYS Number(4,0) SMALLINT NOT NULL Retention Days
    13 PT_OVRDFROMEMAILID Character(1) VARCHAR2(1) NOT NULL Override From Email
    0=Disable
    1=Enable

    Default Value: 0