SCHDLITEM

index back

Schedule Job Items


PeopleSoft Field Name Field Type Column Type Description
SCHEDULENAME Character(30) VARCHAR2(30) NOT NULL Schedule Name
JOBNAMESRC Character(8) VARCHAR2(8) NOT NULL Job Name Source
ITEM_NODE Character(36) VARCHAR2(36) NOT NULL Item Node
PARENT_ITEM_NODE Character(36) VARCHAR2(36) NOT NULL Parent Item Node
PRCSNAME Character(12) VARCHAR2(12) NOT NULL Process Name
PRCSTYPE Character(30) VARCHAR2(30) NOT NULL Process Type
PRCSJOBSEQ Number(5,0) INTEGER NOT NULL Process Job Item
PARENTJOBSEQNO Number(10,0) DECIMAL(10) NOT NULL Parent Job Sequence Number
PRCSITEMLEVEL Number(4,0) SMALLINT NOT NULL Process Item Level
PARENTJOBNAME Character(30) VARCHAR2(30) NOT NULL Parent Job Name
RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
RUNSERVEROPTION Character(1) VARCHAR2(1) NOT NULL Run Server Option
1=Any Server
2=Specific Server
3=Specific OS
4=Primary Server

Default: 1

RUNSERVERNAME Character(8) VARCHAR2(8) NOT NULL Run Server Name

Prompt Table: SERVERDEFN
Set Control Field: SERVERNAME

RUNSCHEDULEOPTION Character(1) VARCHAR2(1) NOT NULL Run Schedule Option
0=Inactive
1=Active
2=Completed

Default: 1

RUNTIME Time(15) TIMESTAMP Process Scheduler Process Run Time
RUNTIMEOPTION Character(1) VARCHAR2(1) NOT NULL Run Time Option
1=Job Rule Time
2=Specific Time
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
OUTDESTTYPE Character(3) VARCHAR2(3) NOT NULL Process Request output destination type.
0=Any
1=(None)
2=File
3=Printer
4=Window
5=Email
6=Web
7=Default
8=Feed
9=IB Node

Prompt Table: %EDITTABLE17
Set Control Field: GENPRCSTYPE

OUTDESTFORMAT Character(3) VARCHAR2(3) NOT NULL Process Request output format
0=Any
1=(None)
10=Postscript (*.lis)
11=Crystal Report (*.rpt)
12=Rich Text File (*.rtf)
13=SQR Portable Format (*.spf)
14=Text Files (*.txt)
15=Other
16=Default
17=XML Format(*.xml)
18=Data Mover Data File (*.dat)
19=Crystal Report Explorer(*.rpt)
2=Acrobat (*.pdf)
20=XMLP
21=Atom
22=Transformation
23=Printer Command Lang. (*.pcl)
24=PostScript (*.ps)
3=Comma delimited (*.csv)
4=HP Format (*.lis)
5=HTML Documents (*.htm)
6=Line Printer Format (*.lis)
7=Lotus 1-2-3 Files (*.wks)
8=Microsoft Excel Files (*.xls)
9=Microsoft Word (*.doc)

Prompt Table: OUTDESTFORMAT
Set Control Field: OUTDESTTYPE

OUTDEST Character(127) VARCHAR2(127) NOT NULL Process Scheduler Output Destination
ESTCPUTIME Number(8,2) DECIMAL(7,2) NOT NULL Estimated CPU Time
GENPRCSTYPE Character(2) VARCHAR2(2) NOT NULL Generic Process Type
0=Other
1=SQR
2=PeopleSoft COBOL
3=Crystal Report
4=Winword Macro
5=Application Engine
6=Cube Builder
7=nVision
8=Data Mover
9=PSJob
EMAIL_LOG_FLAG Character(1) VARCHAR2(1) NOT NULL Email With Log

Default: 0

EMAIL_WEB_RPT Character(1) VARCHAR2(1) NOT NULL Email Web Report
0=Email report
1=Email report
N=Display report in browser
Y=Email report

Default: 0

PSRF_FOLDER_NAME Character(18) VARCHAR2(18) NOT NULL Reporting Folder's Name

Prompt Table: PRCSDEFNFLDR_VW
Set Control Field: PSRF_FOLDER_NAME

PRCSFILENAME Character(254) VARCHAR2(254) NOT NULL FileName
PT_RETENTIONDAYS Number(4,0) SMALLINT NOT NULL Retention Days
index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
PTRef generated on 09-JUN-19