PTSCHEDPARM_VW

(SQL View)
 Index Back

SELECT A.PTSCHDL_NAME , A.PTSCHED_REQPARAM , A.PTSCHED_PARAMNAME , A.DESCR50 , B.BCNAME , D.RUN_CNTL_ID , B.PRCSTYPE , B.PRCSNAME , B.OUTDESTTYPE , B.OUTDESTFORMAT , B.OUTDEST , D.SERVERNAME , C.MENUNAME , C.MARKET , C.BCPGNAME FROM PS_PTSCHEDMODFYPAR A , PS_PTSCHEDULER B , PSBCDEFN C , PS_PTSMPLCUSTSETUP D WHERE A.PTSCHDL_NAME = B.PTSCHDL_NAME AND A.PTSCHDL_NAME = D.PTSCHDL_NAME AND B.PTSCHDL_NAME = D.PTSCHDL_NAME AND C.BCNAME = B.BCNAME UNION SELECT B.PTSCHDL_NAME , ' ' , ' ' , ' ' , B.BCNAME , D.RUN_CNTL_ID , B.PRCSTYPE , B.PRCSNAME , B.OUTDESTTYPE , B.OUTDESTFORMAT , B.OUTDEST , D.SERVERNAME , C.MENUNAME , C.MARKET , C.BCPGNAME FROM PS_PTSCHEDULER B , PSBCDEFN C , PS_PTSMPLCUSTSETUP D WHERE B.PTSCHDL_NAME = D.PTSCHDL_NAME AND C.BCNAME = B.BCNAME

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PTSCHDL_NAME Character(30) VARCHAR2(30) NOT NULL Partition Schedule
2 PTSCHED_REQPARAM Character(1) VARCHAR2(1) NOT NULL Optional Parameter
3 PTSCHED_PARAMNAME Character(60) VARCHAR2(60) NOT NULL Modifiable Parameters
4 DESCR50 Character(50) VARCHAR2(50) NOT NULL Description of length 50
5 BCNAME Character(30) VARCHAR2(30) NOT NULL Business Component Name (see PSBCDEFN).
6 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
7 PRCSTYPE Character(30) VARCHAR2(30) NOT NULL Process Type
8 PRCSNAME Character(12) VARCHAR2(12) NOT NULL Process Name
9 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
10 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)
11 OUTDEST Character(127) VARCHAR2(127) NOT NULL Process Scheduler Output Destination
12 SERVERNAME Character(8) VARCHAR2(8) NOT NULL Server Name
13 MENUNAME Character(30) VARCHAR2(30) NOT NULL Menu Name (see PSMENUDEFN).
14 MARKET Character(3) VARCHAR2(3) NOT NULL Market
15 BCPGNAME Character(30) VARCHAR2(30) NOT NULL Panel Group Name