Co-Operative PeopleTools Table Reference

Table: PS_SCHDLITEM	Return to Index
SCHDLITEM	Return to Index

Schedule Job Items

PeopleSoft Field Name Description
SCHEDULENAME Schedule Name
JOBNAMESRC Job Name Source
ITEM_NODE Item Node
PARENT_ITEM_NODE Parent Item Node
PRCSNAME Process Name
PRCSTYPE Process Type
PRCSJOBSEQ Process Job Item
PARENTJOBSEQNO Parent Job Sequence Number
PRCSITEMLEVEL Process Item Level
PARENTJOBNAME Parent Job Name
RUN_CNTL_ID Run Control ID
RUNSERVEROPTION Run Server Option
1=Any Server (default)
2=Specific Server
3=Specific OS
4=Primary Server
RUNSERVERNAME Run Server Name
Prompt Table: SERVERDEFN
Set Control Field: SERVERNAME
RUNSCHEDULEOPTION Run Schedule Option
0=Inactive
1=Active (default)
2=Completed
RUNTIME Process Scheduler Process Run Time
RUNTIMEOPTION Run Time Option
1=Job Rule Time
2=Specific Time
OPSYS Operating System
0=DOS (inactive)
1=NT/Win95 Client (inactive)
2=NT/Win2000
3=OS/2 (inactive)
4=UNIX
5=VMS (inactive)
6=MPE/XL (inactive)
7=OS390
8=NT
9=OS/400 (inactive)
OUTDESTTYPE Process Request output destination type.
0=Any
1=(None)
2=File
3=Printer
4=Window
5=Email
6=Web
7=Default
Prompt Table: OUTDESTTYPE
Set Control Field: GENPRCSTYPE
OUTDESTFORMAT 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)
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 Process Scheduler Output Destination
ESTCPUTIME Estimated CPU Time
GENPRCSTYPE 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 (inactive)
EMAIL_LOG_FLAG Email With Log
Default: 0
EMAIL_WEB_RPT Email Web Report
N=Display report in browser
Y=Email report
Default: 0
PSRF_FOLDER_NAME Reporting Folder's Name
Prompt Table: PRCSDEFNFLDR_VW
Set Control Field: PSRF_FOLDER_NAME
PRCSFILENAME FileName
Author: PeopleTools
Return to Index © Go-Faster Consultancy Ltd. Last updated 24 July 2010

PeopleSoft Field Name	Description
SCHEDULENAME	Schedule Name
JOBNAMESRC	Job Name Source
ITEM_NODE	Item Node
PARENT_ITEM_NODE	Parent Item Node
PRCSNAME	Process Name
PRCSTYPE	Process Type
PRCSJOBSEQ	Process Job Item
PARENTJOBSEQNO	Parent Job Sequence Number
PRCSITEMLEVEL	Process Item Level
PARENTJOBNAME	Parent Job Name
RUN_CNTL_ID	Run Control ID
RUNSERVEROPTION	Run Server Option 1=Any Server (default) 2=Specific Server 3=Specific OS 4=Primary Server
RUNSERVERNAME	Run Server Name Prompt Table: SERVERDEFN Set Control Field: SERVERNAME
RUNSCHEDULEOPTION	Run Schedule Option 0=Inactive 1=Active (default) 2=Completed
RUNTIME	Process Scheduler Process Run Time
RUNTIMEOPTION	Run Time Option 1=Job Rule Time 2=Specific Time
OPSYS	Operating System 0=DOS (inactive) 1=NT/Win95 Client (inactive) 2=NT/Win2000 3=OS/2 (inactive) 4=UNIX 5=VMS (inactive) 6=MPE/XL (inactive) 7=OS390 8=NT 9=OS/400 (inactive)
OUTDESTTYPE	Process Request output destination type. 0=Any 1=(None) 2=File 3=Printer 4=Window 5=Email 6=Web 7=Default Prompt Table: OUTDESTTYPE Set Control Field: GENPRCSTYPE
OUTDESTFORMAT	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) 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	Process Scheduler Output Destination
ESTCPUTIME	Estimated CPU Time
GENPRCSTYPE	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 (inactive)
EMAIL_LOG_FLAG	Email With Log Default: 0
EMAIL_WEB_RPT	Email Web Report N=Display report in browser Y=Email report Default: 0
PSRF_FOLDER_NAME	Reporting Folder's Name Prompt Table: PRCSDEFNFLDR_VW Set Control Field: PSRF_FOLDER_NAME
PRCSFILENAME	FileName

Author: PeopleTools
Return to Index	© Go-Faster Consultancy Ltd. Last updated 24 July 2010

SCHDLITEM

Table: PS_SCHDLITEM