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;
No Comments