PRCSDEFN

index back

Process Defn

This record is used for defining processes that can run within the Process Scheduler. Security information like panel groups and process groups is also provided here.

  • Related language record: PRCSDEFNLANG
  • Parent record of PRCSDEFNGRP PRCSDEFNPNL PRCSDEFNXFER PRCSGRP_VW PSPRCSGRP_VW
  • PeopleSoft Field NameField TypeColumn TypeDescription
    PRCSTYPECharacter(30)VARCHAR2(30) NOT NULLProcess Type

    Prompt Table: PRCSTYPE_ALT_VW

    PRCSNAMECharacter(12)VARCHAR2(12) NOT NULLProcess Name
    VERSIONNumber(10,0)DECIMAL(10) NOT NULLVersion. Internal PeopleTools version for controlling caching of object. - Version/Table reference

    Default: 0

    PARMLISTCharacter(254)VARCHAR2(254) NOT NULLParameter List
    PARMLISTTYPECharacter(1)VARCHAR2(1) NOT NULLParameter List Type
    0=None
    1=Override
    2=Prepend
    3=Append

    Default: 0

    CMDLINECharacter(127)VARCHAR2(127) NOT NULLCommand Line
    CMDLINETYPECharacter(1)VARCHAR2(1) NOT NULLCommand Line Type
    0=None
    1=Override
    2=Prepend
    3=Append

    Default: 0

    WORKINGDIRCharacter(127)VARCHAR2(127) NOT NULLWorking Directory
    WORKINGDIRTYPECharacter(1)VARCHAR2(1) NOT NULLWorking Directory Type
    0=None
    1=Override
    2=Prepend
    3=Append

    Default: 0

    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

    Default: 0

    OUTDESTCharacter(127)VARCHAR2(127) NOT NULLProcess Scheduler Output Destination
    OUTDESTSRCCharacter(1)VARCHAR2(1) NOT NULLProcess Request output destination source
    0=(None)
    1=Process Type Definition
    2=Process Definition
    3=User Specified

    Default: 3

    Prompt Table: OUTDESTSRC

    SQRRTFLAGCharacter(1)VARCHAR2(1) NOT NULLSQR Runtime
    0=No
    1=Yes

    Default: 0

    LOGRQSTCharacter(1)VARCHAR2(1) NOT NULLLog client request
    0=No
    1=Yes

    Default: 1

    APIAWARECharacter(1)VARCHAR2(1) NOT NULLProcess Scheduler API Aware
    0=No
    1=Yes

    Default: 1

    PRCSPRIORITYCharacter(1)VARCHAR2(1) NOT NULLProcess Priority
    1=Low
    5=Medium
    9=High

    Default: 5

    RUNLOCATIONCharacter(1)VARCHAR2(1) NOT NULLRun Location
    0=Both
    1=Client
    2=Server

    Default: 2

    SERVERNAMECharacter(8)VARCHAR2(8) NOT NULLServer Name

    Prompt Table: SERVERDEFN

    MVSSHELLIDCharacter(3)VARCHAR2(3) NOT NULLJob Shell ID
    MSGLOGTBLCharacter(15)VARCHAR2(15) NOT NULLMessage Log Table

    Prompt Table: PSRECDEFN

    RQSTTBLCharacter(15)VARCHAR2(15) NOT NULLRun Control Request Table

    Prompt Table: PSRECDEFN

    RECURNAMECharacter(30)VARCHAR2(30) NOT NULLRecurrence Name

    Prompt Table: PRCSRECUR

    DESCRCharacter(30)VARCHAR2(30) NOT NULLDescription
    LASTUPDDTTMDateTime(26)TIMESTAMPSpecifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
    LASTUPDOPRIDCharacter(30)VARCHAR2(30) NOT NULLSpecifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
    DESCRLONGLong CharacterCLOBLong Description
    RECVRYPRCSTYPECharacter(30)VARCHAR2(30) NOT NULLRecovery Process Type

    Prompt Table: PRCSTYPE_ALT_VW

    RECVRYPRCSNAMECharacter(12)VARCHAR2(12) NOT NULLRecovery Process Name

    Prompt Table: PRCSDEFN_VW3
    Set Control Field: RECVRYPRCSTYPE

    RETENTIONDAYSNumber(3,0)SMALLINT NOT NULLRetention Days
    PT_RETENTIONDAYSNumber(4,0)SMALLINT NOT NULLRetention Days
    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)
    PSRF_FOLDER_NAMECharacter(18)VARCHAR2(18) NOT NULLReporting Folder's Name

    Prompt Table: PRCSDEFNFLDR_VW
    Set Control Field: PSRF_FOLDER_NAME

    RESTARTENABLEDCharacter(1)VARCHAR2(1) NOT NULLRestart Enabled?

    Default: 0

    RETRYCOUNTNumber(10,0)DECIMAL(10) NOT NULLPub/Sub Retry Count

    Default: 0

    TIMEOUTMINUTESNumber(5,0)INTEGER NOT NULLTime out minutes

    Default: 0

    MAXCONCURRENTNumber(3,0)SMALLINT NOT NULLMaximum Concurrent Processes

    Default: 0

    PRCSCATEGORYCharacter(30)VARCHAR2(30) NOT NULLProcess Category

    Prompt Table: PRCS_CAT_TBL

    FILEDEPENDCharacter(1)VARCHAR2(1) NOT NULLFile Dependency

    Default: 0

    PRCSFILENAMECharacter(254)VARCHAR2(254) NOT NULLFileName
    TIMEOUTMAXMINSNumber(5,0)INTEGER NOT NULLTime Out Max Minutes

    Default: 0

    PRCSSHOWURLNumber(1,0)SMALLINT NOT NULLShow URL for current component
    PT_PRCS_EN_GEN_RUNCharacter(1)VARCHAR2(1) NOT NULLEnable Generic RunControl Page

    Y/N Table Edit

    Default: N

    PT_PRCS_RUNCNTLSECCharacter(1)VARCHAR2(1) NOT NULLAllow Access By User With
    0=Process Group Security
    1=Full Process Security

    Default: 0

    PRCSREADONLYCharacter(1)VARCHAR2(1) NOT NULLFlag for MRO process
    0=No
    1=Yes

    Default: 0

    TIMESTENMODECharacter(1)VARCHAR2(1) NOT NULLTimesTen Mode
    0=No
    1=Yes
    2=Exclusive

    Default: 0

    index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
    PTRef generated on 09-JUN-19