PSPRCSRQSTARCH

index back

Process Request

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

PeopleSoft Field Name Field Type Column Type Description
PRCSINSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
JOBINSTANCE Number(10,0) DECIMAL(10) NOT NULL Job Instance
ARCHIVE_DT Date(10) DATE Archive Date
MAINJOBINSTANCE Number(10,0) DECIMAL(10) NOT NULL Main Job Instance
PRCSJOBSEQ Number(5,0) INTEGER NOT NULL Process Job Item
PRCSJOBNAME Character(8) VARCHAR2(8) NOT NULL Process Job Name

Prompt Table: PRCSJOBDEFN

PRCSTYPE Character(30) VARCHAR2(30) NOT NULL Process Type

Prompt Table: PRCSTYPE_VW

PRCSNAME Character(12) VARCHAR2(12) NOT NULL Process Name

Prompt Table: PRCSDEFN

PRCSITEMLEVEL Number(4,0) SMALLINT NOT NULL Process Item Level
MAINJOBNAME Character(30) VARCHAR2(30) NOT NULL Main Job Name
MAINJOBSEQ Number(10,0) DECIMAL(10) NOT NULL Main Job Sequence
SERVERNAMERUN Character(8) VARCHAR2(8) NOT NULL Server Name - Runtime
OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
OPSYS Character(1) VARCHAR2(1) NOT NULL Operating 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
RECURNAME Character(30) VARCHAR2(30) NOT NULL Recurrence Name
RUNSTATUS Character(2) VARCHAR2(2) NOT NULL Process 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
BEGINDTTM DateTime(26) TIMESTAMP Begin Date/Time
ENDDTTM DateTime(26) TIMESTAMP End Date/Time
RUNCNTLID Character(30) VARCHAR2(30) NOT NULL Run Control ID
PRCSRTNCD Number(5,0) INTEGER NOT NULL Process Return Code
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
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)
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
PSRF_FOLDER_NAME Character(18) VARCHAR2(18) NOT NULL Reporting Folder's Name
SCHEDULENAME Character(30) VARCHAR2(30) NOT NULL Schedule Name
DELETE_FLAG Character(1) VARCHAR2(1) NOT NULL Deletion Flag
N=No
Y=Yes
PRCSOUTPUTDIR Character(254) VARCHAR2(254) NOT NULL Process Output Directory
index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
PTRef generated on 09-JUN-19