PTSCHEDPARM_VW

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 NameField TypeColumn TypeDescription
PTSCHDL_NAMECharacter(30)VARCHAR2(30) NOT NULLPartition Schedule
PTSCHED_REQPARAMCharacter(1)VARCHAR2(1) NOT NULLOptional Parameter
PTSCHED_PARAMNAMECharacter(60)VARCHAR2(60) NOT NULLModifiable Parameters
DESCR50Character(50)VARCHAR2(50) NOT NULLDescription of length 50
BCNAMECharacter(30)VARCHAR2(30) NOT NULLBusiness Component Name (see PSBCDEFN).
RUN_CNTL_IDCharacter(30)VARCHAR2(30) NOT NULLRun Control ID
PRCSTYPECharacter(30)VARCHAR2(30) NOT NULLProcess Type
PRCSNAMECharacter(12)VARCHAR2(12) NOT NULLProcess Name
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
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)
OUTDESTCharacter(127)VARCHAR2(127) NOT NULLProcess Scheduler Output Destination
SERVERNAMECharacter(8)VARCHAR2(8) NOT NULLServer Name
MENUNAMECharacter(30)VARCHAR2(30) NOT NULLMenu Name (see PSMENUDEFN).
MARKETCharacter(3)VARCHAR2(3) NOT NULLMarket translate values
BCPGNAMECharacter(30)VARCHAR2(30) NOT NULLPanel Group Name
index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
PTRef generated on 09-JUN-19