PRCSJOBDEFN |
index back |
|---|---|
Job Defn |
| 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
|
| 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 |