PMN_RUNSTATUS

(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) , %Substring(X.XLATSHORTNAME ,1,10) FROM PSXLATITEM X WHERE X.FIELDNAME = 'RUNSTATUS' AND X.EFF_STATUS = 'A' AND X.FIELDVALUE <> '2'

  • Related Language Record: PMN_RUNSTATLANG

    • # 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 RUNSTATUSDESCR Character(10) VARCHAR2(10) NOT NULL Run Status