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 NameField TypeColumn TypeDescription
    OPRIDCharacter(30)VARCHAR2(30) NOT NULLA user's ID (see PSOPRDEFN).
    RUNCNTLIDCharacter(30)VARCHAR2(30) NOT NULLRun Control ID
    PRCSTYPECharacter(30)VARCHAR2(30) NOT NULLProcess Type
    PRCSNAMECharacter(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)
    OUTDESTCharacter(127)VARCHAR2(127) NOT NULLProcess Scheduler Output Destination
    PSRF_FOLDER_NAMECharacter(18)VARCHAR2(18) NOT NULLReporting Folder's Name
    EMAIL_WEB_RPTCharacter(1)VARCHAR2(1) NOT NULLEmail Web Report
    0=Email report
    1=Email report
    N=Display report in browser
    Y=Email report
    EMAIL_LOG_FLAGCharacter(1)VARCHAR2(1) NOT NULLEmail With Log
    PRCSFILENAMECharacter(254)VARCHAR2(254) NOT NULLFileName
    PT_RETENTIONDAYSNumber(4,0)SMALLINT NOT NULLRetention Days
    index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
    PTRef generated on 09-JUN-19