SERVERNAMEPRCSTYPE1=Low
5=Medium
9=High
PMN_PRCSACTV_VW(SQL View) |
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 | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SERVERNAME |
Character(8) | VARCHAR2(8) NOT NULL | Server Name |
| 2 | PRCSTYPE |
Character(30) | VARCHAR2(30) NOT NULL | Process Type |
| 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 |