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 NameField TypeColumn TypeDescription
PRCSNAMECharacter(12)VARCHAR2(12) NOT NULLProcess Name
PRCSTYPECharacter(30)VARCHAR2(30) NOT NULLProcess Type
DESCRCharacter(30)VARCHAR2(30) NOT NULLDescription
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
RUN_CNTL_IDCharacter(30)VARCHAR2(30) NOT NULLRun Control ID
PRCSJOBSEQNumber(5,0)INTEGER NOT NULLProcess Job Item
PRCSJOBNAMECharacter(8)VARCHAR2(8) NOT NULLProcess Job Name
PRCSITEMLEVELNumber(4,0)SMALLINT NOT NULLProcess Item Level
PTNONUNPRCSNAMECharacter(12)VARCHAR2(12) NOT NULLProcess Name
PTNONUNPRCSIDCharacter(100)VARCHAR2(100) NOT NULLDistinct Prcs Id
PARENTJOBSEQNONumber(10,0)DECIMAL(10) NOT NULLParent Job Sequence Number
OUTDESTCharacter(127)VARCHAR2(127) NOT NULLProcess Scheduler Output Destination
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

Prompt Table: %EDITTABLE17
Set Control Field: GENPRCSTYPE

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)

Prompt Table: %EDITTABLE2
Set Control Field: OUTDESTTYPE

OUTDESTSRCCharacter(1)VARCHAR2(1) NOT NULLProcess Request output destination source
0=(None)
1=Process Type Definition
2=Process Definition
3=User Specified
EMAIL_LOG_FLAGCharacter(1)VARCHAR2(1) NOT NULLEmail With Log

Default: 0

EMAIL_SUBJECTTEXTLong CharacterCLOBEmail Subject
EMAIL_TEXTLONGLong CharacterCLOBMessage Text
EMAIL_LISTLong CharacterCLOBEmail Address List
EMAIL_WEB_RPTCharacter(1)VARCHAR2(1) NOT NULLEmail Web Report
0=Email report
1=Email report
N=Display report in browser
Y=Email report
SET_JOB_DFLT_FLAGCharacter(1)VARCHAR2(1) NOT NULLSet Default Job Distribution
PSRF_FOLDER_NAMECharacter(18)VARCHAR2(18) NOT NULLReporting Folder's Name

Prompt Table: PRCSDEFNFLDR_VW
Set Control Field: PSRF_FOLDER_NAME

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