SCHDLDEFN (SQL Table)	Index Back
Schedule Definition

SCHDLDEFN

(SQL Table)

Schedule Definition

Related Language Record: SCHDLDEFNLANG

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SCHEDULENAME Character(30) VARCHAR2(30) NOT NULL Schedule Name

2 JOBNAMESRC Character(8) VARCHAR2(8) NOT NULL Job Name Source
Prompt Table: PRCSJOBDEFN
Set Control Field: PRCSJOBNAME

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 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

6 SCHEDULESTATUS Character(1) VARCHAR2(1) NOT NULL Schedule Status
0=Inactive
1=Active
2=Completed
Default Value: 0

7 SCHDLPRIORITY Character(1) VARCHAR2(1) NOT NULL Schedule Priority
1=Low
2=Medium
3=High
5=Medium
9=High
Default Value: 5

8 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID

9 STARTDATETIME DateTime(26) TIMESTAMP Start Datetime

10 TIMEZONE Character(9) VARCHAR2(9) NOT NULL Time Zone
Prompt Table: PSTIMEZONE

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

12 SRVRRUNOPTION Character(1) VARCHAR2(1) NOT NULL Server Run Option
1=Any Server
2=Specific Server
3=Specific OS
4=Primary Server
Default Value: 1

13 PRIMARYSRVRNAME Character(8) VARCHAR2(8) NOT NULL Primary Server Name
Prompt Table: SERVERDEFN
Set Control Field: SERVERNAME

14 OPSYS Character(1) VARCHAR2(1) NOT NULL Operating System
0=DOS
1=NT/Win95 Client
2=Windows
3=OS/2
4=UNIX
5=VMS
6=MPE/XL
7=OS390
8=NT
9=OS/400

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

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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SCHEDULENAME	Character(30)	VARCHAR2(30) NOT NULL	Schedule Name
2	JOBNAMESRC	Character(8)	VARCHAR2(8) NOT NULL	Job Name Source Prompt Table: PRCSJOBDEFN Set Control Field: PRCSJOBNAME
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	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
6	SCHEDULESTATUS	Character(1)	VARCHAR2(1) NOT NULL	Schedule Status 0=Inactive 1=Active 2=Completed Default Value: 0
7	SCHDLPRIORITY	Character(1)	VARCHAR2(1) NOT NULL	Schedule Priority 1=Low 2=Medium 3=High 5=Medium 9=High Default Value: 5
8	RUN_CNTL_ID	Character(30)	VARCHAR2(30) NOT NULL	Run Control ID
9	STARTDATETIME	DateTime(26)	TIMESTAMP	Start Datetime
10	TIMEZONE	Character(9)	VARCHAR2(9) NOT NULL	Time Zone Prompt Table: PSTIMEZONE
11	RECURNAME	Character(30)	VARCHAR2(30) NOT NULL	Recurrence Name Prompt Table: PRCSRECUR
12	SRVRRUNOPTION	Character(1)	VARCHAR2(1) NOT NULL	Server Run Option 1=Any Server 2=Specific Server 3=Specific OS 4=Primary Server Default Value: 1
13	PRIMARYSRVRNAME	Character(8)	VARCHAR2(8) NOT NULL	Primary Server Name Prompt Table: SERVERDEFN Set Control Field: SERVERNAME
14	OPSYS	Character(1)	VARCHAR2(1) NOT NULL	Operating System 0=DOS 1=NT/Win95 Client 2=Windows 3=OS/2 4=UNIX 5=VMS 6=MPE/XL 7=OS390 8=NT 9=OS/400
15	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.
16	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.