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 Name Field Type Column Type Description
SERVERNAME Character(8) VARCHAR2(8) NOT NULL Server Name
PRCSTYPE Character(30) VARCHAR2(30) NOT NULL Process Type
PRCSPRIORITY Character(1) VARCHAR2(1) NOT NULL Process Priority
1=Low
5=Medium
9=High
ITEMCOUNT Number(4,0) SMALLINT NOT NULL Item Count
MAXCONCURRENT Number(3,0) SMALLINT NOT NULL Maximum Concurrent Processes
index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
PTRef generated on 09-JUN-19