PRCSJOBDEFN

index back

Job Defn

This record is used to organize individual processes into jobs. One or more processes organized as a job can be scheduled to run as a job. These processes could be of the same or different type and can run either in series or parallel.

  • Related language record: PRCSJOBDEFNLANG
  • PeopleSoft Field Name Field Type Column Type Description
    PRCSJOBNAME Character(8) VARCHAR2(8) NOT NULL Process Job Name
    PRCSTYPE Character(30) VARCHAR2(30) NOT NULL Process Type

    Default: PSJob

    VERSION Number(10,0) DECIMAL(10) NOT NULL Version. Internal PeopleTools version for controlling caching of object. - Version/Table reference
    DESCR Character(30) VARCHAR2(30) NOT NULL Description
    SERVERNAME Character(8) VARCHAR2(8) NOT NULL Server Name

    Prompt Table: SERVERDEFN

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

    Prompt Table: PRCSRECUR

    JOBPRIORITY Character(1) VARCHAR2(1) NOT NULL Job Priority
    1=Low
    5=Medium
    9=High

    Default: 5

    JOBRUNMODE Character(1) VARCHAR2(1) NOT NULL Run parallel or serially
    0=Run Serially
    1=Run Parallel

    Default: 0

    NOTIFYPRCSOVRD Character(1) VARCHAR2(1) NOT NULL Override Process Notify
    CNTDISTPRCSOVRD Character(1) VARCHAR2(1) NOT NULL Distribtuion Process Override
    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.
    RETRYCOUNT Number(10,0) DECIMAL(10) NOT NULL Pub/Sub Retry Count

    Default: 0

    PRCSFILENAME Character(254) VARCHAR2(254) NOT NULL FileName
    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

    OVERRIDEDFLTVALUE Character(1) VARCHAR2(1) NOT NULL Can Over-Ride Defualt Value
    0=Disable
    1=Enable

    Default: 0

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

    Prompt Table: PRCS_CAT_TBL

    TIMEOUTMAXMINS Number(5,0) INTEGER NOT NULL Time Out Max Minutes

    Default: 0

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

    Default: 0

    OVRRDPRCSRETNDAYS Character(1) VARCHAR2(1) NOT NULL Override Process Retention Day
    0=Disable
    1=Enable

    Default: 0

    PT_RETENTIONDAYS Number(4,0) SMALLINT NOT NULL Retention Days
    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

    PT_OVRDFROMEMAILID Character(1) VARCHAR2(1) NOT NULL Override From Email
    0=Disable
    1=Enable

    Default: 0

    EMAILID Character(70) VARCHAR2(70) NOT NULL A user's E-mail address
    index back (c)David Kurtz 2020, www.go-faster.co.uk PeopleTools 8.58
    PTRef generated on 21-DEC-20