PRCSRQSTDLGLIST

(SQL View)
 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 Name PeopleSoft Field Type Database Column Type Description
1 DESCR Character(30) VARCHAR2(30) NOT NULL Description
2 PRCSNAME Character(12) VARCHAR2(12) NOT NULL Process Name
3 PRCSTYPE Character(30) VARCHAR2(30) NOT NULL Process Type
4 GENPRCSTYPE Character(2) VARCHAR2(2) NOT NULL Generic 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
5 PRCSJOBSEQ Number(5,0) INTEGER NOT NULL Process Job Item
6 PRCSJOBNAME Character(8) VARCHAR2(8) NOT NULL Process Job Name
7 PNLGRPNAME Character(18) VARCHAR2(18) NOT NULL Component Name
8 OUTDESTSRC Character(1) VARCHAR2(1) NOT NULL Process Request output destination source
0=(None)
1=Process Type Definition
2=Process Definition
3=User Specified
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 PSRF_FOLDER_NAME Character(18) VARCHAR2(18) NOT NULL Reporting Folder's Name
13 PRCSTYPEDESCR Character(30) VARCHAR2(30) NOT NULL Process Type Description
14 FILEDEPEND Character(1) VARCHAR2(1) NOT NULL File Dependency
15 PRCSFILENAME Character(254) VARCHAR2(254) NOT NULL FileName
16 PT_RETENTIONDAYS Number(4,0) SMALLINT NOT NULL Retention Days