PTHCALRTCONF(SQL Table) |
Index Back |
---|
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | PTHC_METRIC | Character(128) | VARCHAR2(128) NOT NULL | Metric |
2 | PTHC_DOMTYPE | Character(4) | VARCHAR2(4) NOT NULL | Domain Type |
3 | PTHC_ALRTHOST | Character(64) | VARCHAR2(64) NOT NULL | Host Port |
4 | PTHC_DBNAME | Character(16) | VARCHAR2(16) NOT NULL | DBName |
5 | PTHC_DOMNAME | Character(254) | VARCHAR2(254) NOT NULL | Dom Name |
6 | PTHC_THRESHVAL | Number(9,3) | DECIMAL(8,3) NOT NULL | Thresh Val |
7 | PTHC_THRESHTYPE | Character(4) | VARCHAR2(4) NOT NULL |
ThreshType
HIGH=> LOW=< |
8 | PTHC_FREQ | Number(5,0) | INTEGER NOT NULL | Frequency |
9 | PTHC_NOTIF | Character(4) | VARCHAR2(4) NOT NULL |
Notification Type
0=Single 1=Repeated |