Process Run Status

In the PeopleTools look at the translates on the field RUNSTATUS or use the query.

select FIELDVALUE, XLATLONGNAME 

from PSXLATITEM 

where FIELDNAME = 'RUNSTATUS'

Here's a summary of the run status translates. Note that not all of these are active.

Value

 Status

 

1

 Cancel

 

2

 Delete

 

3

 Error

 

4

 Hold

 

5

 Queued

 

6

 Initiated

 

7

 Processing

 

8

 Cancelled

 

9

 Success

 

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

 

The following query will give you a summary of the process run statuses in your process request table:

select 

 RUNSTATUS,

 (

 select XLATSHORTNAME

 from PSXLATITEM

 where FIELDNAME = 'RUNSTATUS'

 and FIELDVALUE = RUNSTATUS

 ) as RUNSTATUS_DESCR,

 count(PRCSINSTANCE)

from 

 PSPRCSRQST

group by 

 RUNSTATUS

order by 

 RUNSTATUS;

As a PeopleSoft Administration it is worth running this query regularly to check if there any unusual processes statuses.