PMN_RUNSTATLANG

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 Field Type Column Type Description
    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
    LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code translate values
    RUNSTATUSDESCR Character(10) VARCHAR2(10) NOT NULL Run Status
    index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
    PTRef generated on 09-JUN-19