OTA_THRES_IDH=Hours
M=Monetary
N=Number
P=Percent
N=Chart Not Available
Y=Chart Available
E=Alert Exceed Target
U=Alert Under Target
PC_PE_OTA_DEFN(SQL Table) |
Index Back |
|---|---|
Operational Threshold AlertESA Operational Threshold Alert Definition |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | OTA_THRES_ID |
Character(5) | VARCHAR2(5) NOT NULL | A unique identifier for an Operational Threshold Alert |
| 2 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 3 | OBJECTOWNERID | Character(4) | VARCHAR2(4) NOT NULL | Object owner identifier |
| 4 | OTA_UNIT_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Used in Operational Threshold Alerts to determine the units the each threshold is in.
H=Hours M=Monetary N=Number P=Percent |
| 5 | CHART_IND | Character(1) | VARCHAR2(1) NOT NULL |
This fields indicates whether a chart is available with a given Operational Threshold Alert.
N=Chart Not Available Y=Chart Available |
| 6 | ALERT_IND | Character(1) | VARCHAR2(1) NOT NULL |
Identifies the type of Alert.
E=Alert Exceed Target U=Alert Under Target |
| 7 | MENUNAME | Character(30) | VARCHAR2(30) NOT NULL | Menu Name (see PSMENUDEFN). |
| 8 | PNLGRPNAME | Character(18) | VARCHAR2(18) NOT NULL | Component Name |
| 9 | PNLNAME | Character(30) | VARCHAR2(30) NOT NULL | Page Name (see PSPNLDEFN). |