PM_INSTANCE_ID01=Warning
02=Urgent
03=Emergency
N=False
Y=True
PSPMALERTLOG(SQL Table) |
Index Back |
|---|
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PM_INSTANCE_ID |
Number(20,0) | DECIMAL(20) NOT NULL | Instance Identifier |
| 2 | PM_AGENTID | Number(10,0) | DECIMAL(10) NOT NULL | Performance Monitor Agent Identifier. |
| 3 | PM_AGENT_DTTM | DateTime(26) | TIMESTAMP | Agent Date/Time |
| 4 | PM_MON_DTTM | DateTime(26) | TIMESTAMP | Monitor Date/Time |
| 5 | PM_ALERT_SEVERITY | Character(2) | VARCHAR2(2) NOT NULL |
Alert Severity
01=Warning 02=Urgent 03=Emergency |
| 6 | PM_ALERT_CATEGORY | Character(64) | VARCHAR2(64) NOT NULL | Alert Category |
| 7 | PM_ALERT_TYPE | Character(64) | VARCHAR2(64) NOT NULL | Alert Type |
| 8 | PM_ALERT_CODE | Character(9) | VARCHAR2(9) NOT NULL | Alert Code |
| 9 | PM_ALERT_READ | Character(1) | VARCHAR2(1) NOT NULL |
Alert Read
N=False Y=True |
| 10 | PM_ALERT_MSG | Character(254) | VARCHAR2(254) NOT NULL | Alert Message |