PMN_PRCSLIST

Return to Index

View: PS_PMN_PRCSLIST

This view is used to list all the process requests in the Process Monitor.

PlatformView Text
DefaultSELECT 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 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 NameDescription
    SEQUENCENOSequence Number
    PRCSINSTANCEProcess Instance
    JOBINSTANCEJob Instance
    PRCSJOBSEQProcess Job Item
    PRCSTYPEProcess Type

    Prompt Table: PMN_PRCSTYPE_VW

    PRCSNAMEProcess Name
    RUNCNTLIDRun Control ID
    RUNLOCATIONRun Location
    0=Both (inactive)
    1=Client (inactive)
    2=Server
    RESTARTENABLEDRestart Enabled?
    SERVERNAMERUNServer Name - Runtime
    SERVERNAMERQSTServer Name Request
    RECURNAMERecurrence Name
    OPRIDA user's ID
    RQSTDTTMRequest Date/Time
    RUNDTTMRun Date/Time
    BEGINDTTMBegin Date/Time
    ENDDTTMEnd Date/Time
    RUNSTATUSProcess Scheduler Process Run Status
    1=Cancel
    10=Not Successful
    11=Posted (inactive)
    12=Unable to post (inactive)
    13=Resend (inactive)
    14=Posting (inactive)
    15=Content Generated (inactive)
    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
    RUNSTATUSDESCRRun Status
    DISTSTATUSDistribution Status
    0=None
    1=Scheduled
    2=Processing
    3=Generated
    4=Unable to Post
    5=Posted to Web
    6=Delete
    7=Posting
    GENPRCSTYPEGeneric 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 (inactive)
    OUTDESTTYPEProcess Request output destination type.
    0=Any
    1=(None)
    2=File
    3=Printer
    4=Window
    5=Email
    6=Web
    7=Default
    OUTDESTFORMATProcess 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)
    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)
    PRCSRTNCDProcess Return Code
    RQSTSTATUSUPDRequest Status Update
    RQSTSTATUSVIEWRequest Status View
    MAINJOBINSTANCEMain Job Instance
    PRCSITEMLEVELProcess Item Level
    SCHEDULENAMESchedule Name
    JOBNAMESRCJob Name Source
    RECURORIGPRCSINSTRecurrence Original Instance
    P_PRCSINSTANCEProcess Instance

    Author: PeopleTools

    Return to Index

    © Go-Faster Consultancy Ltd.  Last updated 24 July 2010