PTSCHED_VW

 index back

SELECT A.PTSCHDL_NAME ,A.PRCSTYPE ,A.PRCSNAME ,A.OUTDESTTYPE ,A.OUTDESTFORMAT ,B.SERVERNAME ,A.OUTDEST FROM PS_PTSCHEDULER A , PS_PTSMPLCUSTSETUP B WHERE A.PTSCHDL_NAME= B.PTSCHDL_NAME AND A.PTSCHDL_NAME <> ' '

PeopleSoft Field Name Field Type Column Type Description
PTSCHDL_NAME Character(30) VARCHAR2(30) NOT NULL Partition Schedule
PRCSTYPE Character(30) VARCHAR2(30) NOT NULL Process Type
PRCSNAME Character(12) VARCHAR2(12) NOT NULL Process Name
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
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)
SERVERNAME Character(8) VARCHAR2(8) NOT NULL Server Name
OUTDEST Character(127) VARCHAR2(127) NOT NULL Process Scheduler Output Destination
index back (c)David Kurtz 2020, www.go-faster.co.uk PeopleTools 8.58
PTRef generated on 21-DEC-20