PRCSRQSTITEMS

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 FROM PS_PRCSJOBDEFN J

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

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

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

Default: 0

EMAIL_SUBJECTTEXT Long Character CLOB Email Subject
EMAIL_TEXTLONG Long Character CLOB Message Text
EMAIL_LIST Long Character CLOB Email Address List
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
SET_JOB_DFLT_FLAG Character(1) VARCHAR2(1) NOT NULL Set Default Job Distribution
PSRF_FOLDER_NAME Character(18) VARCHAR2(18) NOT NULL Reporting Folder's Name

Prompt Table: PRCSDEFNFLDR_VW
Set Control Field: PSRF_FOLDER_NAME

FILEDEPEND Character(1) VARCHAR2(1) NOT NULL File Dependency
PRCSFILENAME Character(254) VARCHAR2(254) NOT NULL FileName
PT_RETENTIONDAYS Number(4,0) SMALLINT NOT NULL Retention Days
index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
PTRef generated on 09-JUN-19