PRCSJOBDEFN (SQL Table)	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.

PRCSJOBDEFN

(SQL Table)

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 PeopleSoft Field Type Database Column Type Description

1 PRCSJOBNAME Character(8) VARCHAR2(8) NOT NULL Process Job Name

2 PRCSTYPE Character(30) VARCHAR2(30) NOT NULL Process Type
Default Value: PSJob

3 VERSION Number(10,0) DECIMAL(10) NOT NULL Version. Internal PeopleTools version for controlling caching of object. - Version/Table reference

4 DESCR Character(30) VARCHAR2(30) NOT NULL Description

5 SERVERNAME Character(8) VARCHAR2(8) NOT NULL Server Name
Prompt Table: SERVERDEFN

6 RECURNAME Character(30) VARCHAR2(30) NOT NULL Recurrence Name
Prompt Table: PRCSRECUR

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

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

9 NOTIFYPRCSOVRD Character(1) VARCHAR2(1) NOT NULL Override Process Notify

10 CNTDISTPRCSOVRD Character(1) VARCHAR2(1) NOT NULL Distribtuion Process Override

11 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.

12 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.

13 RETRYCOUNT Number(10,0) DECIMAL(10) NOT NULL Pub/Sub Retry Count
Default Value: 0

14 PRCSFILENAME Character(254) VARCHAR2(254) NOT NULL FileName

15 RECVRYPRCSTYPE Character(30) VARCHAR2(30) NOT NULL Recovery Process Type
Prompt Table: PRCSTYPE_ALT_VW

16 RECVRYPRCSNAME Character(12) VARCHAR2(12) NOT NULL Recovery Process Name
Prompt Table: PRCSDEFN_VW3
Set Control Field: RECVRYPRCSTYPE

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

18 PRCSCATEGORY Character(30) VARCHAR2(30) NOT NULL Process Category
Prompt Table: PRCS_CAT_TBL

19 TIMEOUTMAXMINS Number(5,0) INTEGER NOT NULL Time Out Max Minutes
Default Value: 0

20 MAXCONCURRENT Number(3,0) SMALLINT NOT NULL Maximum Concurrent Processes
Default Value: 0

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

22 PT_RETENTIONDAYS Number(4,0) SMALLINT NOT NULL Retention Days

23 PT_PRCS_EN_GEN_RUN Character(1) VARCHAR2(1) NOT NULL Enable Generic RunControl Page
Y/N Table Edit
Default Value: N

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

25 PT_OVRDFROMEMAILID Character(1) VARCHAR2(1) NOT NULL Override From Email
0=Disable
1=Enable
Default Value: 0

26 EMAILID Character(70) VARCHAR2(70) NOT NULL A user's E-mail address

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PRCSJOBNAME	Character(8)	VARCHAR2(8) NOT NULL	Process Job Name
2	PRCSTYPE	Character(30)	VARCHAR2(30) NOT NULL	Process Type Default Value: PSJob
3	VERSION	Number(10,0)	DECIMAL(10) NOT NULL	Version. Internal PeopleTools version for controlling caching of object. - Version/Table reference
4	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
5	SERVERNAME	Character(8)	VARCHAR2(8) NOT NULL	Server Name Prompt Table: SERVERDEFN
6	RECURNAME	Character(30)	VARCHAR2(30) NOT NULL	Recurrence Name Prompt Table: PRCSRECUR
7	JOBPRIORITY	Character(1)	VARCHAR2(1) NOT NULL	Job Priority 1=Low 5=Medium 9=High Default Value: 5
8	JOBRUNMODE	Character(1)	VARCHAR2(1) NOT NULL	Run parallel or serially 0=Run Serially 1=Run Parallel Default Value: 0
9	NOTIFYPRCSOVRD	Character(1)	VARCHAR2(1) NOT NULL	Override Process Notify
10	CNTDISTPRCSOVRD	Character(1)	VARCHAR2(1) NOT NULL	Distribtuion Process Override
11	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.
12	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.
13	RETRYCOUNT	Number(10,0)	DECIMAL(10) NOT NULL	Pub/Sub Retry Count Default Value: 0
14	PRCSFILENAME	Character(254)	VARCHAR2(254) NOT NULL	FileName
15	RECVRYPRCSTYPE	Character(30)	VARCHAR2(30) NOT NULL	Recovery Process Type Prompt Table: PRCSTYPE_ALT_VW
16	RECVRYPRCSNAME	Character(12)	VARCHAR2(12) NOT NULL	Recovery Process Name Prompt Table: PRCSDEFN_VW3 Set Control Field: RECVRYPRCSTYPE
17	OVERRIDEDFLTVALUE	Character(1)	VARCHAR2(1) NOT NULL	Can Over-Ride Defualt Value 0=Disable 1=Enable Default Value: 0
18	PRCSCATEGORY	Character(30)	VARCHAR2(30) NOT NULL	Process Category Prompt Table: PRCS_CAT_TBL
19	TIMEOUTMAXMINS	Number(5,0)	INTEGER NOT NULL	Time Out Max Minutes Default Value: 0
20	MAXCONCURRENT	Number(3,0)	SMALLINT NOT NULL	Maximum Concurrent Processes Default Value: 0
21	OVRRDPRCSRETNDAYS	Character(1)	VARCHAR2(1) NOT NULL	Override Process Retention Day 0=Disable 1=Enable Default Value: 0
22	PT_RETENTIONDAYS	Number(4,0)	SMALLINT NOT NULL	Retention Days
23	PT_PRCS_EN_GEN_RUN	Character(1)	VARCHAR2(1) NOT NULL	Enable Generic RunControl Page Y/N Table Edit Default Value: N
24	PT_PRCS_RUNCNTLSEC	Character(1)	VARCHAR2(1) NOT NULL	Allow Access By User With 0=Process Group Security 1=Full Process Security Default Value: 0
25	PT_OVRDFROMEMAILID	Character(1)	VARCHAR2(1) NOT NULL	Override From Email 0=Disable 1=Enable Default Value: 0
26	EMAILID	Character(70)	VARCHAR2(70) NOT NULL	A user's E-mail address