SCHDLITEM

index back

Schedule Job Items


PeopleSoft Field NameField TypeColumn TypeDescription
SCHEDULENAMECharacter(30)VARCHAR2(30) NOT NULLSchedule Name
JOBNAMESRCCharacter(8)VARCHAR2(8) NOT NULLJob Name Source
ITEM_NODECharacter(36)VARCHAR2(36) NOT NULLItem Node
PARENT_ITEM_NODECharacter(36)VARCHAR2(36) NOT NULLParent Item Node
PRCSNAMECharacter(12)VARCHAR2(12) NOT NULLProcess Name
PRCSTYPECharacter(30)VARCHAR2(30) NOT NULLProcess Type
PRCSJOBSEQNumber(5,0)INTEGER NOT NULLProcess Job Item
PARENTJOBSEQNONumber(10,0)DECIMAL(10) NOT NULLParent Job Sequence Number
PRCSITEMLEVELNumber(4,0)SMALLINT NOT NULLProcess Item Level
PARENTJOBNAMECharacter(30)VARCHAR2(30) NOT NULLParent Job Name
RUN_CNTL_IDCharacter(30)VARCHAR2(30) NOT NULLRun Control ID
RUNSERVEROPTIONCharacter(1)VARCHAR2(1) NOT NULLRun Server Option
1=Any Server
2=Specific Server
3=Specific OS
4=Primary Server

Default: 1

RUNSERVERNAMECharacter(8)VARCHAR2(8) NOT NULLRun Server Name

Prompt Table: SERVERDEFN
Set Control Field: SERVERNAME

RUNSCHEDULEOPTIONCharacter(1)VARCHAR2(1) NOT NULLRun Schedule Option
0=Inactive
1=Active
2=Completed

Default: 1

RUNTIMETime(15)TIMESTAMPProcess Scheduler Process Run Time
RUNTIMEOPTIONCharacter(1)VARCHAR2(1) NOT NULLRun Time Option
1=Job Rule Time
2=Specific Time
OPSYSCharacter(1)VARCHAR2(1) NOT NULLOperating 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
OUTDESTTYPECharacter(3)VARCHAR2(3) NOT NULLProcess 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

OUTDESTFORMATCharacter(3)VARCHAR2(3) NOT NULLProcess 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

OUTDESTCharacter(127)VARCHAR2(127) NOT NULLProcess Scheduler Output Destination
ESTCPUTIMENumber(8,2)DECIMAL(7,2) NOT NULLEstimated CPU Time
GENPRCSTYPECharacter(2)VARCHAR2(2) NOT NULLGeneric 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_FLAGCharacter(1)VARCHAR2(1) NOT NULLEmail With Log

Default: 0

EMAIL_WEB_RPTCharacter(1)VARCHAR2(1) NOT NULLEmail Web Report
0=Email report
1=Email report
N=Display report in browser
Y=Email report

Default: 0

PSRF_FOLDER_NAMECharacter(18)VARCHAR2(18) NOT NULLReporting Folder's Name

Prompt Table: PRCSDEFNFLDR_VW
Set Control Field: PSRF_FOLDER_NAME

PRCSFILENAMECharacter(254)VARCHAR2(254) NOT NULLFileName
PT_RETENTIONDAYSNumber(4,0)SMALLINT NOT NULLRetention Days
index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
PTRef generated on 09-JUN-19