PMN_PRCSLIST

index back

Process Monitor Process List

This view is used to list all the process requests in the Process Monitor.
SELECT R.PRCSINSTANCE - R.PRCSJOBSEQ , R.PRCSINSTANCE , R.JOBINSTANCE , R.PRCSJOBSEQ , R.PRCSTYPE , R.PRCSNAME , R.RUNCNTLID , R.RUNLOCATION , R.RESTARTENABLED , R.SERVERNAMERUN , R.SERVERNAMERQST , R.RECURNAME , R.OPRID , R.RQSTDTTM , R.RUNDTTM , R.BEGINDTTM , R.ENDDTTM , R.RUNSTATUS , X.XLATSHORTNAME , R.DISTSTATUS , R.GENPRCSTYPE , R.OUTDESTTYPE , R.OUTDESTFORMAT , R.PRCSRTNCD , C.RQSTSTATUSUPD , C.RQSTSTATUSVIEW , R.MAINJOBINSTANCE , R.PRCSITEMLEVEL , R.SCHEDULENAME , %Substring(R.PRCSNAME , 1,8) , R.RECURORIGPRCSINST , R.P_PRCSINSTANCE , R.PTNONUNPRCSID FROM PSPRCSRQST R , PSOPRDEFN B , PSPRCSPRFL C , PSXLATITEM X WHERE B.OPRID = R.OPRID AND B.PRCSPRFLCLS = C.CLASSID AND R.RUNSTATUS = X.FIELDVALUE AND R.RUNSTATUS <> '2' AND X.FIELDNAME = 'RUNSTATUS'

  • Related language record: PMN_PRCSLISTLNG
  • PeopleSoft Field Name Field Type Column Type Description
    SEQUENCENO Number(10,0) DECIMAL(10) NOT NULL Sequence Number
    PRCSINSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
    JOBINSTANCE Number(10,0) DECIMAL(10) NOT NULL Job Instance
    PRCSJOBSEQ Number(5,0) INTEGER NOT NULL Process Job Item
    PRCSTYPE Character(30) VARCHAR2(30) NOT NULL Process Type

    Prompt Table: PMN_PRCSTYPE_VW

    PRCSNAME Character(12) VARCHAR2(12) NOT NULL Process Name
    RUNCNTLID Character(30) VARCHAR2(30) NOT NULL Run Control ID
    RUNLOCATION Character(1) VARCHAR2(1) NOT NULL Run Location
    0=Both
    1=Client
    2=Server
    RESTARTENABLED Character(1) VARCHAR2(1) NOT NULL Restart Enabled?
    SERVERNAMERUN Character(8) VARCHAR2(8) NOT NULL Server Name - Runtime
    SERVERNAMERQST Character(8) VARCHAR2(8) NOT NULL Server Name Request
    RECURNAME Character(30) VARCHAR2(30) NOT NULL Recurrence Name
    OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
    RQSTDTTM DateTime(26) TIMESTAMP Request Date/Time
    RUNDTTM DateTime(26) TIMESTAMP Run Date/Time
    BEGINDTTM DateTime(26) TIMESTAMP Begin Date/Time
    ENDDTTM DateTime(26) TIMESTAMP End Date/Time
    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
    RUNSTATUSDESCR Character(10) VARCHAR2(10) NOT NULL Run Status
    DISTSTATUS Character(2) VARCHAR2(2) NOT NULL Distribution Status
    0=None
    1=Scheduled
    2=Processing
    3=Generated
    4=Unable to Post
    5=Posted to Web
    6=Delete
    7=Posting
    9=Pending for Approval
    GENPRCSTYPE Character(2) VARCHAR2(2) NOT NULL Generic Process Type
    0=Other
    1=SQR
    2=PeopleSoft COBOL
    3=Crystal Report
    4=Winword Macro
    5=Application Engine
    6=Cube Builder
    7=nVision
    8=Data Mover
    9=PSJob
    OUTDESTTYPE Character(3) VARCHAR2(3) NOT NULL Process Request output destination type.
    0=Any
    1=(None)
    2=File
    3=Printer
    4=Window
    5=Email
    6=Web
    7=Default
    8=Feed
    9=IB Node
    OUTDESTFORMAT Character(3) VARCHAR2(3) NOT NULL Process Request output format
    0=Any
    1=(None)
    10=Postscript (*.lis)
    11=Crystal Report (*.rpt)
    12=Rich Text File (*.rtf)
    13=SQR Portable Format (*.spf)
    14=Text Files (*.txt)
    15=Other
    16=Default
    17=XML Format(*.xml)
    18=Data Mover Data File (*.dat)
    19=Crystal Report Explorer(*.rpt)
    2=Acrobat (*.pdf)
    20=XMLP
    21=Atom
    22=Transformation
    23=Printer Command Lang. (*.pcl)
    24=PostScript (*.ps)
    3=Comma delimited (*.csv)
    4=HP Format (*.lis)
    5=HTML Documents (*.htm)
    6=Line Printer Format (*.lis)
    7=Lotus 1-2-3 Files (*.wks)
    8=Microsoft Excel Files (*.xls)
    9=Microsoft Word (*.doc)
    PRCSRTNCD Number(5,0) INTEGER NOT NULL Process Return Code
    RQSTSTATUSUPD Number(1,0) SMALLINT NOT NULL Request Status Update
    RQSTSTATUSVIEW Number(1,0) SMALLINT NOT NULL Request Status View
    MAINJOBINSTANCE Number(10,0) DECIMAL(10) NOT NULL Main Job Instance
    PRCSITEMLEVEL Number(4,0) SMALLINT NOT NULL Process Item Level
    SCHEDULENAME Character(30) VARCHAR2(30) NOT NULL Schedule Name
    JOBNAMESRC Character(8) VARCHAR2(8) NOT NULL Job Name Source
    RECURORIGPRCSINST Number(10,0) DECIMAL(10) NOT NULL Recurrence Original Instance
    P_PRCSINSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
    PTNONUNPRCSID Character(100) VARCHAR2(100) NOT NULL Distinct Prcs Id
    index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
    PTRef generated on 09-JUN-19