SERVERNAMEPRCSCATEGORY1=Low
5=Medium
9=High
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 Name | Field Type | Column Type | Description |
|---|---|---|---|
| SERVERNAME |
Character(8) | VARCHAR2(8) NOT NULL | Server Name |
| PRCSCATEGORY |
Character(30) | VARCHAR2(30) NOT NULL | Process Category |
| 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 2020, www.go-faster.co.uk | PeopleTools 8.58 PTRef generated on 21-DEC-20 |