PRCSJOBDEFN |
index back |
---|---|
Job Defn |
PeopleSoft Field Name | Field Type | Column Type | Description |
---|---|---|---|
![]() |
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
|
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 |