PMN_CATGACTV_VW

index back

SELECT S.SERVERNAME , S.PRCSCATEGORY , S.PRCSPRIORITY , A.ITEMCOUNT , S.MAXCONCURRENT FROM PS_SERVERMONITOR A , PS_SERVERCATEGORY S WHERE A.OBJTYPE = 1 AND S.SERVERNAME = A.SERVERNAME AND S.PRCSCATEGORY = A.OBJNAME

PeopleSoft Field NameField TypeColumn TypeDescription
SERVERNAMECharacter(8)VARCHAR2(8) NOT NULLServer Name
PRCSCATEGORYCharacter(30)VARCHAR2(30) NOT NULLProcess Category
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