PMN_RECURLSTLNG

(SQL View)
 Index Back

Process Monitor Process List

This view is used to list all the process requests in the Process Monitor.

SELECT R.RECURNAME , X.LANGUAGE_CD , X.XLATSHORTNAME FROM PSPRCSRQST R , PSOPRDEFN B , PSPRCSPRFL C , PSXLATITEMLANG X WHERE B.OPRID = R.OPRID AND B.PRCSPRFLCLS = C.CLASSID AND R.RUNSTATUS = X.FIELDVALUE AND R.RUNSTATUS <> '2' AND X.FIELDNAME = 'RUNSTATUS' AND R.RECURNAME <> ' '

  • Related Language Record for PMN_RECUR_LIST

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 RECURNAME Character(30) VARCHAR2(30) NOT NULL Recurrence Name
    2 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    3 RUNSTATUSDESCR Character(10) VARCHAR2(10) NOT NULL Run Status