OPRIDDEFAULT_FLAGY/N Table Edit
OTA_THRES_IDPrompt Table: PC_PE_OTA_DEFN
PC_OTA_SEL_INDPC_OTA_CHART_SELPC_PE_OTA_PRS(SQL Table) |
Index Back |
|---|---|
OTA General PersonalizationThis record is the general personalization record for Operational Threshold Alerts. It only specifies which OTA's have been selected by the user. Specific personalization records for each OTA define the filter criteria for each OTA. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | OPRID |
Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 2 | DEFAULT_FLAG |
Character(1) | VARCHAR2(1) NOT NULL |
Default
Y/N Table Edit |
| 3 | OTA_THRES_ID |
Character(5) | VARCHAR2(5) NOT NULL |
A unique identifier for an Operational Threshold Alert
Prompt Table: PC_PE_OTA_DEFN |
| 4 | PC_OTA_SEL_IND |
Character(1) | VARCHAR2(1) NOT NULL | Select |
| 5 | PC_OTA_CHART_SEL |
Character(1) | VARCHAR2(1) NOT NULL | Chart |