PTSCHED_VW

(SQL View)

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 PeopleSoft Field Type Database Column Type Description

1 PTSCHDL_NAME Character(30) VARCHAR2(30) NOT NULL Partition Schedule

2 PRCSTYPE Character(30) VARCHAR2(30) NOT NULL Process Type

3 PRCSNAME Character(12) VARCHAR2(12) NOT NULL Process Name

4 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

5 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)

6 SERVERNAME Character(8) VARCHAR2(8) NOT NULL Server Name

7 OUTDEST Character(127) VARCHAR2(127) NOT NULL Process Scheduler Output Destination

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PTSCHDL_NAME	Character(30)	VARCHAR2(30) NOT NULL	Partition Schedule
2	PRCSTYPE	Character(30)	VARCHAR2(30) NOT NULL	Process Type
3	PRCSNAME	Character(12)	VARCHAR2(12) NOT NULL	Process Name
4	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
5	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)
6	SERVERNAME	Character(8)	VARCHAR2(8) NOT NULL	Server Name
7	OUTDEST	Character(127)	VARCHAR2(127) NOT NULL	Process Scheduler Output Destination