Groups
PROCESS_MONITOR_SQL
| Col # | Column Name | Data Type | Field Length | Not Null? | Data Def. | Comments |
|---|---|---|---|---|---|---|
| 1 | ID | NUMBER | 22 | N | Primary key | |
| 2 | NAME | VARCHAR2 | 200 | Y | ||
| 3 | ALERT_RECEIPIENT_GROUP_ID | NUMBER | 22 | Y | ||
| 4 | ENABLED | NUMBER | 22 | Y | ||
| 5 | SQL_STMT | VARCHAR2 | 1024 | Y | ||
| 6 | MIN_VALUE | NUMBER | 22 | Y | ||
| 7 | MAX_VALUE | NUMBER | 22 | Y | ||
| 8 | DESCRIPTION | VARCHAR2 | 200 | Y | ||
| 9 | COLUMN_NAME | VARCHAR2 | 50 | Y | ||
| 10 | NEXT_ALERT | DATE | 7 | Y | ||
| 11 | ALERT_INTERVAL | NUMBER | 22 | Y | ||
| 12 | ALLOWED_RANGE_EXCEEDED | VARCHAR2 | 4 | Y | ||
| 13 | CONFIRM_RANGE_OK | VARCHAR2 | 4 | Y |