PMN_PRCSACTV_VW

index back

SELECT S.SERVERNAME , S.PRCSTYPE , S.PRCSPRIORITY , A.ITEMCOUNT , S.MAXCONCURRENT FROM PS_SERVERMONITOR A , PS_SERVERCLASS S WHERE A.OBJTYPE = 2 AND S.SERVERNAME = A.SERVERNAME AND S.PRCSTYPE = A.OBJNAME

PeopleSoft Field NameField TypeColumn TypeDescription
SERVERNAMECharacter(8)VARCHAR2(8) NOT NULLServer Name
PRCSTYPECharacter(30)VARCHAR2(30) NOT NULLProcess Type
PRCSPRIORITYCharacter(1)VARCHAR2(1) NOT NULLProcess Priority
1=Low
5=Medium
9=High
ITEMCOUNTNumber(4,0)SMALLINT NOT NULLItem Count
MAXCONCURRENTNumber(3,0)SMALLINT NOT NULLMaximum Concurrent Processes
index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
PTRef generated on 09-JUN-19