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 NameField TypeColumn TypeDescription
    SEQUENCENONumber(10,0)DECIMAL(10) NOT NULLSequence Number
    PRCSINSTANCENumber(10,0)DECIMAL(10) NOT NULLProcess Instance
    JOBINSTANCENumber(10,0)DECIMAL(10) NOT NULLJob Instance
    PRCSJOBSEQNumber(5,0)INTEGER NOT NULLProcess Job Item
    PRCSTYPECharacter(30)VARCHAR2(30) NOT NULLProcess Type

    Prompt Table: PMN_PRCSTYPE_VW

    PRCSNAMECharacter(12)VARCHAR2(12) NOT NULLProcess Name
    RUNCNTLIDCharacter(30)VARCHAR2(30) NOT NULLRun Control ID
    RUNLOCATIONCharacter(1)VARCHAR2(1) NOT NULLRun Location
    0=Both
    1=Client
    2=Server
    RESTARTENABLEDCharacter(1)VARCHAR2(1) NOT NULLRestart Enabled?
    SERVERNAMERUNCharacter(8)VARCHAR2(8) NOT NULLServer Name - Runtime
    SERVERNAMERQSTCharacter(8)VARCHAR2(8) NOT NULLServer Name Request
    RECURNAMECharacter(30)VARCHAR2(30) NOT NULLRecurrence Name
    OPRIDCharacter(30)VARCHAR2(30) NOT NULLA user's ID (see PSOPRDEFN).
    RQSTDTTMDateTime(26)TIMESTAMPRequest Date/Time
    RUNDTTMDateTime(26)TIMESTAMPRun Date/Time
    BEGINDTTMDateTime(26)TIMESTAMPBegin Date/Time
    ENDDTTMDateTime(26)TIMESTAMPEnd Date/Time
    RUNSTATUSCharacter(2)VARCHAR2(2) NOT NULLProcess 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
    RUNSTATUSDESCRCharacter(10)VARCHAR2(10) NOT NULLRun Status
    DISTSTATUSCharacter(2)VARCHAR2(2) NOT NULLDistribution 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
    GENPRCSTYPECharacter(2)VARCHAR2(2) NOT NULLGeneric 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
    OUTDESTTYPECharacter(3)VARCHAR2(3) NOT NULLProcess 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
    OUTDESTFORMATCharacter(3)VARCHAR2(3) NOT NULLProcess 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)
    PRCSRTNCDNumber(5,0)INTEGER NOT NULLProcess Return Code
    RQSTSTATUSUPDNumber(1,0)SMALLINT NOT NULLRequest Status Update
    RQSTSTATUSVIEWNumber(1,0)SMALLINT NOT NULLRequest Status View
    MAINJOBINSTANCENumber(10,0)DECIMAL(10) NOT NULLMain Job Instance
    PRCSITEMLEVELNumber(4,0)SMALLINT NOT NULLProcess Item Level
    SCHEDULENAMECharacter(30)VARCHAR2(30) NOT NULLSchedule Name
    JOBNAMESRCCharacter(8)VARCHAR2(8) NOT NULLJob Name Source
    RECURORIGPRCSINSTNumber(10,0)DECIMAL(10) NOT NULLRecurrence Original Instance
    P_PRCSINSTANCENumber(10,0)DECIMAL(10) NOT NULLProcess Instance
    PTNONUNPRCSIDCharacter(100)VARCHAR2(100) NOT NULLDistinct Prcs Id
    index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
    PTRef generated on 09-JUN-19