PMN_PRCSLIST

(SQL View)
 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 PeopleSoft Field Type Database Column Type Description
    1 SEQUENCENO Number(10,0) DECIMAL(10) NOT NULL Sequence Number
    2 PRCSINSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
    3 JOBINSTANCE Number(10,0) DECIMAL(10) NOT NULL Job Instance
    4 PRCSJOBSEQ Number(5,0) INTEGER NOT NULL Process Job Item
    5 PRCSTYPE Character(30) VARCHAR2(30) NOT NULL Process Type

    Prompt Table: PMN_PRCSTYPE_VW

    6 PRCSNAME Character(12) VARCHAR2(12) NOT NULL Process Name
    7 RUNCNTLID Character(30) VARCHAR2(30) NOT NULL Run Control ID
    8 RUNLOCATION Character(1) VARCHAR2(1) NOT NULL Run Location
    0=Both
    1=Client
    2=Server
    9 RESTARTENABLED Character(1) VARCHAR2(1) NOT NULL Restart Enabled?
    10 SERVERNAMERUN Character(8) VARCHAR2(8) NOT NULL Server Name - Runtime
    11 SERVERNAMERQST Character(8) VARCHAR2(8) NOT NULL Server Name Request
    12 RECURNAME Character(30) VARCHAR2(30) NOT NULL Recurrence Name
    13 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
    14 RQSTDTTM DateTime(26) TIMESTAMP Request Date/Time
    15 RUNDTTM DateTime(26) TIMESTAMP Run Date/Time
    16 BEGINDTTM DateTime(26) TIMESTAMP Begin Date/Time
    17 ENDDTTM DateTime(26) TIMESTAMP End Date/Time
    18 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
    19 RUNSTATUSDESCR Character(10) VARCHAR2(10) NOT NULL Run Status
    20 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
    21 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
    22 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
    23 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)
    24 PRCSRTNCD Number(5,0) INTEGER NOT NULL Process Return Code
    25 RQSTSTATUSUPD Number(1,0) SMALLINT NOT NULL Request Status Update
    26 RQSTSTATUSVIEW Number(1,0) SMALLINT NOT NULL Request Status View
    27 MAINJOBINSTANCE Number(10,0) DECIMAL(10) NOT NULL Main Job Instance
    28 PRCSITEMLEVEL Number(4,0) SMALLINT NOT NULL Process Item Level
    29 SCHEDULENAME Character(30) VARCHAR2(30) NOT NULL Schedule Name
    30 JOBNAMESRC Character(8) VARCHAR2(8) NOT NULL Job Name Source
    31 RECURORIGPRCSINST Number(10,0) DECIMAL(10) NOT NULL Recurrence Original Instance
    32 P_PRCSINSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
    33 PTNONUNPRCSID Character(100) VARCHAR2(100) NOT NULL Distinct Prcs Id