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 Name Field Type Column Type Description
    PRCSTYPE Character(30) VARCHAR2(30) NOT NULL Process Type

    Prompt Table: PRCSTYPE_ALT_VW

    PRCSNAME Character(12) VARCHAR2(12) NOT NULL Process Name
    VERSION Number(10,0) DECIMAL(10) NOT NULL Version. Internal PeopleTools version for controlling caching of object. - Version/Table reference

    Default: 0

    PARMLIST Character(254) VARCHAR2(254) NOT NULL Parameter List
    PARMLISTTYPE Character(1) VARCHAR2(1) NOT NULL Parameter List Type
    0=None
    1=Override
    2=Prepend
    3=Append

    Default: 0

    CMDLINE Character(127) VARCHAR2(127) NOT NULL Command Line
    CMDLINETYPE Character(1) VARCHAR2(1) NOT NULL Command Line Type
    0=None
    1=Override
    2=Prepend
    3=Append

    Default: 0

    WORKINGDIR Character(127) VARCHAR2(127) NOT NULL Working Directory
    WORKINGDIRTYPE Character(1) VARCHAR2(1) NOT NULL Working Directory Type
    0=None
    1=Override
    2=Prepend
    3=Append

    Default: 0

    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

    Default: 0

    OUTDEST Character(127) VARCHAR2(127) NOT NULL Process Scheduler Output Destination
    OUTDESTSRC Character(1) VARCHAR2(1) NOT NULL Process Request output destination source
    0=(None)
    1=Process Type Definition
    2=Process Definition
    3=User Specified

    Default: 3

    Prompt Table: OUTDESTSRC

    SQRRTFLAG Character(1) VARCHAR2(1) NOT NULL SQR Runtime
    0=No
    1=Yes

    Default: 0

    LOGRQST Character(1) VARCHAR2(1) NOT NULL Log client request
    0=No
    1=Yes

    Default: 1

    APIAWARE Character(1) VARCHAR2(1) NOT NULL Process Scheduler API Aware
    0=No
    1=Yes

    Default: 1

    PRCSPRIORITY Character(1) VARCHAR2(1) NOT NULL Process Priority
    1=Low
    5=Medium
    9=High

    Default: 5

    RUNLOCATION Character(1) VARCHAR2(1) NOT NULL Run Location
    0=Both
    1=Client
    2=Server

    Default: 2

    SERVERNAME Character(8) VARCHAR2(8) NOT NULL Server Name

    Prompt Table: SERVERDEFN

    MVSSHELLID Character(3) VARCHAR2(3) NOT NULL Job Shell ID
    MSGLOGTBL Character(15) VARCHAR2(15) NOT NULL Message Log Table

    Prompt Table: PSRECDEFN

    RQSTTBL Character(15) VARCHAR2(15) NOT NULL Run Control Request Table

    Prompt Table: PSRECDEFN

    RECURNAME Character(30) VARCHAR2(30) NOT NULL Recurrence Name

    Prompt Table: PRCSRECUR

    DESCR Character(30) VARCHAR2(30) NOT NULL Description
    LASTUPDDTTM DateTime(26) TIMESTAMP Specifies 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.
    LASTUPDOPRID Character(30) VARCHAR2(30) NOT NULL Specifies 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.
    DESCRLONG Long Character CLOB Long Description
    RECVRYPRCSTYPE Character(30) VARCHAR2(30) NOT NULL Recovery Process Type

    Prompt Table: PRCSTYPE_ALT_VW

    RECVRYPRCSNAME Character(12) VARCHAR2(12) NOT NULL Recovery Process Name

    Prompt Table: PRCSDEFN_VW3
    Set Control Field: RECVRYPRCSTYPE

    RETENTIONDAYS Number(3,0) SMALLINT NOT NULL Retention Days
    PT_RETENTIONDAYS Number(4,0) SMALLINT NOT NULL Retention Days
    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)
    PSRF_FOLDER_NAME Character(18) VARCHAR2(18) NOT NULL Reporting Folder's Name

    Prompt Table: PRCSDEFNFLDR_VW
    Set Control Field: PSRF_FOLDER_NAME

    RESTARTENABLED Character(1) VARCHAR2(1) NOT NULL Restart Enabled?

    Default: 0

    RETRYCOUNT Number(10,0) DECIMAL(10) NOT NULL Pub/Sub Retry Count

    Default: 0

    TIMEOUTMINUTES Number(5,0) INTEGER NOT NULL Time out minutes

    Default: 0

    MAXCONCURRENT Number(3,0) SMALLINT NOT NULL Maximum Concurrent Processes

    Default: 0

    PRCSCATEGORY Character(30) VARCHAR2(30) NOT NULL Process Category

    Prompt Table: PRCS_CAT_TBL

    FILEDEPEND Character(1) VARCHAR2(1) NOT NULL File Dependency

    Default: 0

    PRCSFILENAME Character(254) VARCHAR2(254) NOT NULL FileName
    TIMEOUTMAXMINS Number(5,0) INTEGER NOT NULL Time Out Max Minutes

    Default: 0

    PRCSSHOWURL Number(1,0) SMALLINT NOT NULL Show URL for current component
    PT_PRCS_EN_GEN_RUN Character(1) VARCHAR2(1) NOT NULL Enable Generic RunControl Page

    Y/N Table Edit

    Default: N

    PT_PRCS_RUNCNTLSEC Character(1) VARCHAR2(1) NOT NULL Allow Access By User With
    0=Process Group Security
    1=Full Process Security

    Default: 0

    PRCSREADONLY Character(1) VARCHAR2(1) NOT NULL Flag for MRO process
    0=No
    1=Yes

    Default: 0

    TIMESTENMODE Character(1) VARCHAR2(1) NOT NULL TimesTen Mode
    0=No
    1=Yes
    2=Exclusive

    Default: 0

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