PSPRCSRQSTARCH

index back

Process Request

This record contains the process request information to run a process request.

PeopleSoft Field NameField TypeColumn TypeDescription
PRCSINSTANCENumber(10,0)DECIMAL(10) NOT NULLProcess Instance
JOBINSTANCENumber(10,0)DECIMAL(10) NOT NULLJob Instance
ARCHIVE_DTDate(10)DATEArchive Date
MAINJOBINSTANCENumber(10,0)DECIMAL(10) NOT NULLMain Job Instance
PRCSJOBSEQNumber(5,0)INTEGER NOT NULLProcess Job Item
PRCSJOBNAMECharacter(8)VARCHAR2(8) NOT NULLProcess Job Name

Prompt Table: PRCSJOBDEFN

PRCSTYPECharacter(30)VARCHAR2(30) NOT NULLProcess Type

Prompt Table: PRCSTYPE_VW

PRCSNAMECharacter(12)VARCHAR2(12) NOT NULLProcess Name

Prompt Table: PRCSDEFN

PRCSITEMLEVELNumber(4,0)SMALLINT NOT NULLProcess Item Level
MAINJOBNAMECharacter(30)VARCHAR2(30) NOT NULLMain Job Name
MAINJOBSEQNumber(10,0)DECIMAL(10) NOT NULLMain Job Sequence
SERVERNAMERUNCharacter(8)VARCHAR2(8) NOT NULLServer Name - Runtime
OPRIDCharacter(30)VARCHAR2(30) NOT NULLA user's ID (see PSOPRDEFN).
OPSYSCharacter(1)VARCHAR2(1) NOT NULLOperating System
0=DOS
1=NT/Win95 Client
2=Windows
3=OS/2
4=UNIX
5=VMS
6=MPE/XL
7=OS390
8=NT
9=OS/400
RECURNAMECharacter(30)VARCHAR2(30) NOT NULLRecurrence Name
RUNSTATUSCharacter(2)VARCHAR2(2) NOT NULLProcess Scheduler Process Run Status
1=Cancel
10=Not Successful
11=Posted
12=Unable to post
13=Resend
14=Posting
15=Content Generated
16=Pending
17=Success With Warning
18=Blocked
19=Restart
2=Delete
3=Error
4=Hold
5=Queued
6=Initiated
7=Processing
8=Cancelled
9=Success
BEGINDTTMDateTime(26)TIMESTAMPBegin Date/Time
ENDDTTMDateTime(26)TIMESTAMPEnd Date/Time
RUNCNTLIDCharacter(30)VARCHAR2(30) NOT NULLRun Control ID
PRCSRTNCDNumber(5,0)INTEGER NOT NULLProcess Return Code
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)
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
PSRF_FOLDER_NAMECharacter(18)VARCHAR2(18) NOT NULLReporting Folder's Name
SCHEDULENAMECharacter(30)VARCHAR2(30) NOT NULLSchedule Name
DELETE_FLAGCharacter(1)VARCHAR2(1) NOT NULLDeletion Flag
N=No
Y=Yes
PRCSOUTPUTDIRCharacter(254)VARCHAR2(254) NOT NULLProcess Output Directory
index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
PTRef generated on 09-JUN-19