PSPRCSQUE

index back

Process Request Queue

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
PRCSJOBSEQNumber(5,0)INTEGER NOT NULLProcess Job Item
PRCSJOBNAMECharacter(8)VARCHAR2(8) NOT NULLProcess Job Name

Prompt Table: PRCSJOBDEFN

MAINJOBINSTANCENumber(10,0)DECIMAL(10) NOT NULLMain Job Instance
PRCSTYPECharacter(30)VARCHAR2(30) NOT NULLProcess Type

Prompt Table: PRCSTYPE_VW

PRCSNAMECharacter(12)VARCHAR2(12) NOT NULLProcess Name

Prompt Table: PRCSDEFN

MAINJOBNAMECharacter(30)VARCHAR2(30) NOT NULLMain Job Name
MAINJOBSEQNumber(10,0)DECIMAL(10) NOT NULLMain Job Sequence
PRCSITEMLEVELNumber(4,0)SMALLINT NOT NULLProcess Item Level
RUNLOCATIONCharacter(1)VARCHAR2(1) NOT NULLRun Location
0=Both
1=Client
2=Server
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
SERVERNAMERQSTCharacter(8)VARCHAR2(8) NOT NULLServer Name Request

Prompt Table: SERVERDEFN

SERVERNAMERUNCharacter(8)VARCHAR2(8) NOT NULLServer Name - Runtime
SERVERASSIGNCharacter(8)VARCHAR2(8) NOT NULLAssigned Remote Server
RUNDTTMDateTime(26)TIMESTAMPRun Date/Time
RECURNAMECharacter(30)VARCHAR2(30) NOT NULLRecurrence Name

Prompt Table: PRCSRECUR

OPRIDCharacter(30)VARCHAR2(30) NOT NULLA user's ID (see PSOPRDEFN).
PRCSPRTYNumber(5,0)INTEGER NOT NULLProcess Priority
SESSIONIDNUMNumber(10,0)DECIMAL(10) NOT NULLSession ID Number
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
RQSTDTTMDateTime(26)TIMESTAMPRequest Date/Time
RECURDTTMDateTime(26)TIMESTAMPRecur Date/Time
LASTUPDDTTMDateTime(26)TIMESTAMPSpecifies 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.
RUNCNTLIDCharacter(30)VARCHAR2(30) NOT NULLRun Control ID
PRCSRTNCDNumber(5,0)INTEGER NOT NULLProcess Return Code
CONTINUEJOBNumber(1,0)SMALLINT NOT NULLContinue Job
USERNOTIFIEDNumber(1,0)SMALLINT NOT NULLUser Notified
INITIATEDNEXTNumber(1,0)SMALLINT NOT NULLInitiated Next Process
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)
ORIGPRCSINSTANCENumber(10,0)DECIMAL(10) NOT NULLOriginal Process Instance
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
RESTARTENABLEDCharacter(1)VARCHAR2(1) NOT NULLRestart Enabled?
TIMEZONECharacter(9)VARCHAR2(9) NOT NULLTime Zone
EMAIL_WEB_RPTCharacter(1)VARCHAR2(1) NOT NULLEmail Web Report
0=Email report
1=Email report
N=Display report in browser
Y=Email report
EMAIL_LOG_FLAGCharacter(1)VARCHAR2(1) NOT NULLEmail With Log
PSRF_FOLDER_NAMECharacter(18)VARCHAR2(18) NOT NULLReporting Folder's Name
SCHEDULENAMECharacter(30)VARCHAR2(30) NOT NULLSchedule Name
PRCSWINPOPCharacter(1)VARCHAR2(1) NOT NULLWindow Popup
MCFREN_URL_IDCharacter(15)VARCHAR2(15) NOT NULLREN Server Cluster ID
RETRYCOUNTNumber(10,0)DECIMAL(10) NOT NULLPub/Sub Retry Count
RECURORIGPRCSINSTNumber(10,0)DECIMAL(10) NOT NULLRecurrence Original Instance
P_PRCSINSTANCENumber(10,0)DECIMAL(10) NOT NULLProcess Instance
PRCSCATEGORYCharacter(30)VARCHAR2(30) NOT NULLProcess Category
PRCSCURREXPIREDTTMDateTime(26)TIMESTAMPCurrent Expiration Datetime
DISTSTATUSCharacter(2)VARCHAR2(2) NOT NULLDistribution Status
0=None
1=Scheduled
2=Processing
3=Generated
4=Unable to Post
5=Posted to Web
6=Delete
7=Posting
9=Pending for Approval

Default: 1

PRCSSTARTDTTMDateTime(26)TIMESTAMPCurrent Expiration Datetime
RUNSERVEROPTIONCharacter(1)VARCHAR2(1) NOT NULLRun Server Option
1=Any Server
2=Specific Server
3=Specific OS
4=Primary Server
TUXSVCIDNumber(3,0)SMALLINT NOT NULLThis represents the tuxedo service ID used in Optimization framework.
PT_RETENTIONDAYSNumber(4,0)SMALLINT NOT NULLRetention Days
PRCSRUNNOTIFYCharacter(1)VARCHAR2(1) NOT NULLStatus Notification
PTNONUNPRCSIDCharacter(100)VARCHAR2(100) NOT NULLDistinct Prcs Id
QRYXFORMNAMECharacter(30)VARCHAR2(30) NOT NULLTransformation Name
MSGNODENAMECharacter(30)VARCHAR2(30) NOT NULLApplication Message Node Name. Name of the Application Message Node Definition. (see PSMSGNODEDEFN).
CDM_APPROVAL_FLAGCharacter(1)VARCHAR2(1) NOT NULLApproval Required

Default: N

index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
PTRef generated on 09-JUN-19