SERVERNAMEPRCSCATEGORY1=Low
5=Medium
9=High
PMN_CATGACTV_VW(SQL View) |
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 | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SERVERNAME |
Character(8) | VARCHAR2(8) NOT NULL | Server Name |
| 2 | PRCSCATEGORY |
Character(30) | VARCHAR2(30) NOT NULL | Process Category |
| 3 | PRCSPRIORITY | Character(1) | VARCHAR2(1) NOT NULL |
Process Priority
1=Low 5=Medium 9=High |
| 4 | ITEMCOUNT | Number(4,0) | SMALLINT NOT NULL | Item Count |
| 5 | MAXCONCURRENT | Number(3,0) | SMALLINT NOT NULL | Maximum Concurrent Processes |