PRCSRQSTDLGLIST

index back

Request Dialog - Process List

This view is used to list all the valid process requests on a Process Scheduler Request dialog for a given panel group.
SELECT DISTINCT J.DESCR , J.PRCSJOBNAME , J.PRCSTYPE , '9' , 0 ,J.PRCSJOBNAME , P.PNLGRPNAME , ' ' , ' ' , ' ' , ' ' , ' ' , K.PRCSTYPEDESCR , '0' , ' ' , J.PT_RETENTIONDAYS FROM PS_PRCSJOBDEFN J , PS_PRCSJOBPNL P , PS_PRCSTYPEDEFN K WHERE J.PRCSJOBNAME = P.PRCSJOBNAME AND J.PRCSTYPE = K.PRCSTYPE

PeopleSoft Field NameField TypeColumn TypeDescription
DESCRCharacter(30)VARCHAR2(30) NOT NULLDescription
PRCSNAMECharacter(12)VARCHAR2(12) NOT NULLProcess Name
PRCSTYPECharacter(30)VARCHAR2(30) NOT NULLProcess Type
GENPRCSTYPECharacter(2)VARCHAR2(2) NOT NULLGeneric 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
PRCSJOBSEQNumber(5,0)INTEGER NOT NULLProcess Job Item
PRCSJOBNAMECharacter(8)VARCHAR2(8) NOT NULLProcess Job Name
PNLGRPNAMECharacter(18)VARCHAR2(18) NOT NULLComponent Name
OUTDESTSRCCharacter(1)VARCHAR2(1) NOT NULLProcess Request output destination source
0=(None)
1=Process Type Definition
2=Process Definition
3=User Specified
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
PSRF_FOLDER_NAMECharacter(18)VARCHAR2(18) NOT NULLReporting Folder's Name
PRCSTYPEDESCRCharacter(30)VARCHAR2(30) NOT NULLProcess Type Description
FILEDEPENDCharacter(1)VARCHAR2(1) NOT NULLFile Dependency
PRCSFILENAMECharacter(254)VARCHAR2(254) NOT NULLFileName
PT_RETENTIONDAYSNumber(4,0)SMALLINT NOT NULLRetention Days
index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
PTRef generated on 09-JUN-19