How to Know the list of processes run by a User with distribution status description from backend in Peoplesoft

By default the "Process Monitor Process List(PS_PMN_PRCSLIST)" table will not have the description of the Distribution status it will have the Fieldvalue (i.e the translate field value of the DISTSTATUS field) of the distribution status. The below Query will give you the Description of the process distribution status.

Here is the Query to know the Processes ran by a user with its distribution status description:

SQL Syntax:  
select * from PS_PMN_PRCSLIST P,PSXLATITEM X where OPRID='<operator id>  and P.DISTSTATUS=X.FIELDVALUE

Example for The processes Run By the VP1 user:

select OPRID,PRCSINSTANCE, PRCSTYPE, RUNSTATUSDESCR, DISTSTATUS, X.XLATSHORTNAME as DISTSTATUSDESCR from PS_PMN_PRCSLIST,PSXLATITEM X where  X.FIELDNAME='DISTSTATUS' and X.Fieldvalue=DISTSTATUS and  OPRID ='VP1';