PRCSRQSTITEMS

(SQL View)
 Index Back

Request Dialog - Work Rec

This derived record is used by the Process Scheduler Request Dialog.

SELECT DISTINCT J.PRCSJOBNAME , J.PRCSTYPE , J.DESCR , ' ' , '9' , 0 ,J.PRCSJOBNAME , 0 , ' ' , ' ' ,0 , ' ' , ' ' , ' ' , ' ' , ' ' , %Substring(' ', 1, 1) , %Substring(' ', 1, 1) , %Substring(' ', 1, 1) , ' ' , ' ' , ' ' ,'0' ,J.PRCSFILENAME ,J.PT_RETENTIONDAYS ,J.PT_OVRDFROMEMAILID FROM PS_PRCSJOBDEFN J

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PRCSNAME Character(12) VARCHAR2(12) NOT NULL Process Name
2 PRCSTYPE Character(30) VARCHAR2(30) NOT NULL Process Type
3 DESCR Character(30) VARCHAR2(30) NOT NULL Description
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 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
6 PRCSJOBSEQ Number(5,0) INTEGER NOT NULL Process Job Item
7 PRCSJOBNAME Character(8) VARCHAR2(8) NOT NULL Process Job Name
8 PRCSITEMLEVEL Number(4,0) SMALLINT NOT NULL Process Item Level
9 PTNONUNPRCSNAME Character(12) VARCHAR2(12) NOT NULL Process Name
10 PTNONUNPRCSID Character(100) VARCHAR2(100) NOT NULL Distinct Prcs Id
11 PARENTJOBSEQNO Number(10,0) DECIMAL(10) NOT NULL Parent Job Sequence Number
12 OUTDEST Character(127) VARCHAR2(127) NOT NULL Process Scheduler Output Destination
13 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

Prompt Table: %EDITTABLE17
Set Control Field: GENPRCSTYPE

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

Prompt Table: %EDITTABLE2
Set Control Field: OUTDESTTYPE

15 OUTDESTSRC Character(1) VARCHAR2(1) NOT NULL Process Request output destination source
0=(None)
1=Process Type Definition
2=Process Definition
3=User Specified
16 EMAIL_LOG_FLAG Character(1) VARCHAR2(1) NOT NULL Email With Log

Default Value: 0

17 EMAIL_SUBJECTTEXT Long Character CLOB Email Subject
18 EMAIL_TEXTLONG Long Character CLOB Message Text
19 EMAIL_LIST Long Character CLOB Email Address List
20 EMAIL_WEB_RPT Character(1) VARCHAR2(1) NOT NULL Email Web Report
0=Email report
1=Email report
N=Display report in browser
Y=Email report
21 SET_JOB_DFLT_FLAG Character(1) VARCHAR2(1) NOT NULL Set Default Job Distribution
22 PSRF_FOLDER_NAME Character(18) VARCHAR2(18) NOT NULL Reporting Folder's Name

Prompt Table: PRCSDEFNFLDR_VW
Set Control Field: PSRF_FOLDER_NAME

23 FILEDEPEND Character(1) VARCHAR2(1) NOT NULL File Dependency
24 PRCSFILENAME Character(254) VARCHAR2(254) NOT NULL FileName
25 PT_RETENTIONDAYS Number(4,0) SMALLINT NOT NULL Retention Days
26 PT_OVRDFROMEMAILID Character(1) VARCHAR2(1) NOT NULL Override From Email
0=Disable
1=Enable

Default Value: 0