PSPRCSQUE

Return to Index

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

PeopleSoft Field NameField TypeDescription
PRCSINSTANCEDECIMAL(10) NOT NULLProcess Instance
JOBINSTANCEDECIMAL(10) NOT NULLJob Instance
PRCSJOBSEQINTEGER NOT NULLProcess Job Item
PRCSJOBNAMEVARCHAR2(8) NOT NULLProcess Job Name

Prompt Table: PRCSJOBDEFN

MAINJOBINSTANCEDECIMAL(10) NOT NULLMain Job Instance
PRCSTYPEVARCHAR2(30) NOT NULLProcess Type

Prompt Table: PRCSTYPE_VW

PRCSNAMEVARCHAR2(12) NOT NULLProcess Name

Prompt Table: PRCSDEFN

MAINJOBNAMEVARCHAR2(30) NOT NULLMain Job Name
MAINJOBSEQDECIMAL(10) NOT NULLMain Job Sequence
PRCSITEMLEVELSMALLINT NOT NULLProcess Item Level
RUNLOCATIONVARCHAR2(1) NOT NULLRun Location
0=Both
1=Client
2=Server
OPSYSVARCHAR2(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
SERVERNAMERQSTVARCHAR2(8) NOT NULLServer Name Request

Prompt Table: SERVERDEFN

SERVERNAMERUNVARCHAR2(8) NOT NULLServer Name - Runtime
SERVERASSIGNVARCHAR2(8) NOT NULLAssigned Remote Server
RUNDTTMDATERun Date/Time
RECURNAMEVARCHAR2(30) NOT NULLRecurrence Name

Prompt Table: PRCSRECUR

OPRIDVARCHAR2(30) NOT NULLA user's ID
PRCSPRTYINTEGER NOT NULLProcess Priority
SESSIONIDNUMDECIMAL(10) NOT NULLSession ID Number
RUNSTATUSVARCHAR2(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
RQSTDTTMDATERequest Date/Time
RECURDTTMDATERecur Date/Time
LASTUPDDTTMDATESpecifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
RUNCNTLIDVARCHAR2(30) NOT NULLRun Control ID
PRCSRTNCDINTEGER NOT NULLProcess Return Code
CONTINUEJOBSMALLINT NOT NULLContinue Job
USERNOTIFIEDSMALLINT NOT NULLUser Notified
INITIATEDNEXTSMALLINT NOT NULLInitiated Next Process
OUTDESTTYPEVARCHAR2(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
OUTDESTFORMATVARCHAR2(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
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)
ORIGPRCSINSTANCEDECIMAL(10) NOT NULLOriginal Process Instance
GENPRCSTYPEVARCHAR2(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
RESTARTENABLEDVARCHAR2(1) NOT NULLRestart Enabled?
TIMEZONEVARCHAR2(9) NOT NULLTime Zone
EMAIL_WEB_RPTVARCHAR2(1) NOT NULLEmail Web Report
0=Email report
1=Email report
N=Display report in browser
Y=Email report
EMAIL_LOG_FLAGVARCHAR2(1) NOT NULLEmail With Log
PSRF_FOLDER_NAMEVARCHAR2(18) NOT NULLReporting Folder's Name
SCHEDULENAMEVARCHAR2(30) NOT NULLSchedule Name
PRCSWINPOPVARCHAR2(1) NOT NULLWindow Popup
MCFREN_URL_IDVARCHAR2(15) NOT NULLREN Server Cluster ID
RETRYCOUNTDECIMAL(10) NOT NULLPub/Sub Retry Count
RECURORIGPRCSINSTDECIMAL(10) NOT NULLRecurrence Original Instance
P_PRCSINSTANCEDECIMAL(10) NOT NULLProcess Instance
PRCSCATEGORYVARCHAR2(30) NOT NULLProcess Category
PRCSCURREXPIREDTTMDATECurrent Expiration Datetime
DISTSTATUSVARCHAR2(2) NOT NULLDistribution Status
0=None
1=Scheduled
2=Processing
3=Generated
4=Unable to Post
5=Posted to Web
6=Delete
7=Posting

Default: 1

PRCSSTARTDTTMDATECurrent Expiration Datetime
RUNSERVEROPTIONVARCHAR2(1) NOT NULLRun Server Option
1=Any Server
2=Specific Server
3=Specific OS
4=Primary Server
TUXSVCIDSMALLINT NOT NULLThis represents the tuxedo service ID used in Optimization framework.
PT_RETENTIONDAYSSMALLINT NOT NULLRetention Days
PRCSRUNNOTIFYVARCHAR2(1) NOT NULLStatus Notification
PTNONUNPRCSIDVARCHAR2(100) NOT NULLDistinct Prcs Id

Author: PeopleTools 8.52

Return to Index

© David Kurtz  Last updated 01 August 2015