PSPRCSJOBSTATUS

index back

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
MAINJOBINSTANCE Number(10,0) DECIMAL(10) NOT NULL Main Job Instance
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
DISTSTATUS Character(2) VARCHAR2(2) NOT NULL Distribution 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
SRVRTYPE Character(2) VARCHAR2(2) NOT NULL Server Type
1=Application Server
2=Distribution Agent
SERVERNAMERUN Character(8) VARCHAR2(8) NOT NULL Server Name - Runtime
RECEIVED Number(1,0) SMALLINT NOT NULL Server Received
index back (c)David Kurtz 2020, www.go-faster.co.uk PeopleTools 8.58
PTRef generated on 21-DEC-20