PMN_RUNSTATLANG

(SQL View)
 Index Back

Process Monitor Run Status

This view is used to list all the valid Run Statuses for the Process Monitor.

SELECT %Substring(X.FIELDVALUE ,1,2) , X.LANGUAGE_CD , %Substring(X.XLATSHORTNAME ,1,10) FROM PSXLATITEMLANG X , PSXLATITEM Y WHERE X.FIELDNAME = 'RUNSTATUS' AND X.FIELDNAME = Y.FIELDNAME AND X.FIELDVALUE = Y.FIELDVALUE AND X.EFFDT = Y.EFFDT AND Y.EFF_STATUS = 'A' AND X.FIELDVALUE <> '2'

  • Related Language Record for PMN_RUNSTATUS

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 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
    2 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    3 RUNSTATUSDESCR Character(10) VARCHAR2(10) NOT NULL Run Status