Alert - ALR_ALERTS | Alerts defined on application tables |
---|---|
Column Name | Descritpion |
APPLICATION_ID | Application identifier |
ENABLED_FLAG | Enabled flag |
START_DATE_ACTIVE | Creation date of alert |
END_DATE_ACTIVE | Last date alert is enabled |
TABLE_ID | Event table identifier |
TABLE_APPLICATION_ID | Application identifier for event table |
DESCRIPTION | Description |
FREQUENCY_TYPE | Periodic alert frequency type lookup code |
WEEKLY_CHECK_DAY | Day on which Oracle Alert checks a weekly periodic alert |
MONTHLY_CHECK_DAY_NUM | Day number on which Oracle Alert checks a monthly periodic alert |
DAYS_BETWEEN_CHECKS | Number of days Oracle Alert skips between Every N Calendar Days or Every N Business Days periodic alerts |
ALERT_ID | Alert identifier |
CHECK_BEGIN_DATE | Date to start Periodic Checks |
DATE_LAST_CHECKED | Date the alert was last checked |
INSERT_FLAG | Flag denoting whether or not event alert fires on insert |
UPDATE_FLAG | Flag denoting whether or not event alert fires on update |
DELETE_FLAG | No longer used |
MAINTAIN_HISTORY_DAYS | Number of days for which to save history |
CHECK_TIME | Alert check time for alerts checked only once on day of check |
CHECK_START_TIME | Time at which first periodic alert check is submitted for an alert scheduled to be checked more than once on a particular day |
CHECK_END_TIME | Time at which last periodic alert check is submitted for an alert scheduled to be checked more than once on a particular day |
SECONDS_BETWEEN_CHECKS | Interval (in seconds) for an alert scheduled to be checked more than once on a particular day |
ALERT_NAME | Alert name |
CHECK_ONCE_DAILY_FLAG | Flag denoting whether periodic alert is single-check or multiple checks on check day |
SQL_STATEMENT_TEXT | Select statement |
ONE_TIME_ONLY_FLAG | No longer used |
TABLE_NAME | Table name for event alert |
LAST_UPDATE_DATE | Standard Who column |
SECURITY_GROUP_ID | Used in hosted environments |
LAST_UPDATED_BY | Standard Who column |
CREATION_DATE | Standard Who column |
CREATED_BY | Standard Who column |
LAST_UPDATE_LOGIN | Standard Who column |
ALERT_CONDITION_TYPE | Identifies whether an alert is periodic or event |
Alert - ALR_ALERT_CHECKS | Alert check information |
---|---|
Column Name | Descritpion |
APPLICATION_ID | Application identifier |
SECURITY_GROUP_ID | Used in hosted environments |
ALERT_CHECK_ID | Alert check identifier |
LAST_UPDATE_DATE | Standard Who column |
LAST_UPDATED_BY | Standard Who column |
ALERT_ID | Alert identifier |
REQUEST_ID | Concurrent request identifier for the alert check |
SUCCESS_FLAG | Flag to indicate if alert check was successful |
CHECK_TIME | Time alert check completed |
HISTORY_PURGE_DATE | Date on which Periodic Alert Checker purges history for this alert check. If null, Oracle Alert did not save history for the alert check. |
Alert - ALR_ALERT_INPUTS | Alert inputs |
---|---|
Column Name | Descritpion |
APPLICATION_ID | Application identifier |
START_DATE_ACTIVE | Creation date of alert input |
END_DATE_ACTIVE | Last date alert input is enabled |
TITLE | Alert input description |
DATA_TYPE | Input data type |
DEFAULT_VALUE | Input default value |
ALERT_ID | Alert identifier |
SECURITY_GROUP_ID | Used in hosted environments |
NAME | Alert input name |
LAST_UPDATE_DATE | Standard Who column |
LAST_UPDATED_BY | Standard Who column |
CREATION_DATE | Standard Who column |
CREATED_BY | Standard Who column |
LAST_UPDATE_LOGIN | Standard Who column |
ENABLED_FLAG | Enabled flag |
Alert - ALR_ALERT_OUTPUTS | Alert outputs |
---|---|
Column Name | Descritpion |
APPLICATION_ID | Application identifier |
ENABLED_FLAG | Enabled flag |
START_DATE_ACTIVE | Alert output creation date |
END_DATE_ACTIVE | Last date alert output is enabled |
TITLE | Alert output description |
DETAIL_MAX_LEN | Maximum number of characters displayed for an output in a detail level action |
SUMMARY_MAX_LEN | Maximum number of characters displayed for an output in a summary level action |
DEFAULT_SUPPRESS_FLAG | Default suppress flag for alert output |
FORMAT_MASK | Number display format |
ALERT_ID | Alert identifier |
SECURITY_GROUP_ID | Used in hosted environments |
NAME | Alert output name |
SEQUENCE | Output order for each alert, ensuring that Oracle Alert selects the correct column value into the corresponding output. |
LAST_UPDATE_DATE | Standard Who column |
LAST_UPDATED_BY | Standard Who column |
CREATION_DATE | Standard Who column |
CREATED_BY | Standard Who column |
LAST_UPDATE_LOGIN | Standard Who column |
Alert - ALR_DISTRIBUTION_LISTS | Distribution lists |
---|---|
Column Name | Descritpion |
APPLICATION_ID | Application identifier |
TO_RECIPIENTS | List of primary recipients |
CC_RECIPIENTS | List of copy recipients |
BCC_RECIPIENTS | List of blind copy recipients |
PRINT_RECIPIENTS | List of print recipients |
PRINTER | Printer name |
REPLY_TO | Reply to mail ID |
END_DATE_ACTIVE | Last date distribution list is enabled |
ENABLED_FLAG | Enabled flag |
LIST_ID | Distribution list identifier |
SECURITY_GROUP_ID | Used in hosted environments |
NAME | Distribution list name |
LAST_UPDATE_DATE | Standard Who column |
LAST_UPDATED_BY | Standard Who column |
CREATION_DATE | Standard Who column |
CREATED_BY | Standard Who column |
LAST_UPDATE_LOGIN | Standard Who column |
DESCRIPTION | Description |
Alert - ALR_OUTPUT_HISTORY | Exception output history |
---|---|
Column Name | Descritpion |
APPLICATION_ID | Application identifier |
SECURITY_GROUP_ID | Used in hosted environments |
NAME | Output name |
CHECK_ID | Action set check identifier |
ROW_NUMBER | Exception number |
DATA_TYPE | Output data type |
VALUE | Actual value retrieved from the database for this output during the alert check |
Alert - ALR_ACTIONS | Alert and response actions |
---|---|
Column Name | Descritpion |
APPLICATION_ID | Application identifier |
LAST_UPDATE_LOGIN | Standard Who column |
END_DATE_ACTIVE | Last date action is enabled |
ENABLED_FLAG | Enabled flag |
DESCRIPTION | Description |
ACTION_LEVEL_TYPE | Action level lookup code |
DATE_LAST_EXECUTED | Date action was last performed |
FILE_NAME | Name of message, operating system script or SQL script whose body resides in an operating system file |
ARGUMENT_STRING | Argument list for SQL, operating system, and concurrent program actions |
PROGRAM_APPLICATION_ID | Application identifier for concurrent program |
CONCURRENT_PROGRAM_ID | Concurrent program identifier |
ACTION_ID | Action identifier |
LIST_APPLICATION_ID | Application identifier for distribution list |
LIST_ID | Distribution list identifier |
TO_RECIPIENTS | List of primary message recipients |
CC_RECIPIENTS | List of copy message recipients |
BCC_RECIPIENTS | List of blind copy message recipients |
PRINT_RECIPIENTS | List of print message recipients |
PRINTER | Printer name |
SUBJECT | Message subject text |
REPLY_TO | Reply to mail ID |
RESPONSE_SET_ID | Response set identifier |
NAME | Action name |
FOLLOW_UP_AFTER_DAYS | Number of days after which outstanding responses are automatically closed |
COLUMN_WRAP_FLAG | Column wrap flag |
MAXIMUM_SUMMARY_MESSAGE_WIDTH | Right margin of summary message |
BODY | Body of message, SQL script, or operating system script |
VERSION_NUMBER | Verion number of action |
ALERT_ID | Alert identifier |
SECURITY_GROUP_ID | Used in hosted environments |
ACTION_TYPE | Action type lookup code |
LAST_UPDATE_DATE | Standard Who column |
LAST_UPDATED_BY | Standard Who column |
CREATION_DATE | Standard Who column |
CREATED_BY | Standard Who column |
Alert - ALR_ACTUAL_RESPONSES | Responses expected and received for an alert message |
---|---|
Column Name | Descritpion |
APPLICATION_ID | Application identifier |
TEXT | Text of possible response |
SENT_BY | User ID of responder |
ALERT_CHECK_ID | Alert check identifier |
ALERT_ID | Alert identifier |
SECURITY_GROUP_ID | Used in hosted environments |
RESPONSE_SET_ID | Response set identifier |
RESPONSE_ID | Response identifier |
MESSAGE_HANDLE | Message identifier |
NODE_HANDLE | Node identifier |
OPEN_CLOSED | Response status |
CLOSE_RESPONSE_ON | Date after which Oracle Alert performs No Response actions if no response is received from any user |
ACTION_SET_PASS_FAIL | Denotes processing status of all actions associated with the response |
Alert - ALR_PROFILE_OPTIONS | Oracle Alert profile options and values |
---|---|
Column Name | Descritpion |
PROFILE_OPTION_NAME | Profile option name |
CREATED_BY | Standard Who column |
LAST_UPDATE_LOGIN | Standard Who column |
LOOKUP_TYPE | Oracle Alert lookup type for profile options whose values are a lookup code |
PROFILE_OPTION_VALUE | Profile option value assigned by user |
SECURITY_GROUP_ID | Used in hosted environments |
PROFILE_OPTION_LONG | Profile option value for options defined in long fields |
DESCRIPTION | Profile option description visible to user |
LONG_FLAG | Flag denoting whether profile option value is present in long field |
ENCRYPTED_PASSWORD | Encrypted password value for profile options with passwords (Oracle*Mail accounts) |
LAST_UPDATE_DATE | Standard Who column |
LAST_UPDATED_BY | Standard Who column |
CREATION_DATE | Standard Who column |
Alert - ALR_RESPONSE_ACTIONS | Member actions of a response set |
---|---|
Column Name | Descritpion |
APPLICATION_ID | Application identifier |
CREATED_BY | Standard Who column |
LAST_UPDATE_LOGIN | Standard Who column |
ENABLED_FLAG | Enabled flag |
END_DATE_ACTIVE | Last date response member action is enabled |
ALERT_ID | Alert identifier |
SECURITY_GROUP_ID | Used in hosted environments |
RESPONSE_SET_ID | Response set identifier |
RESPONSE_ID | Response identifier |
ACTION_ID | Action identifier |
SEQUENCE | Action sequence number within possible response |
LAST_UPDATE_DATE | Standard Who column |
LAST_UPDATED_BY | Standard Who column |
CREATION_DATE | Standard Who column |
Alert - ALR_RESPONSE_SETS | Response sets |
---|---|
Column Name | Descritpion |
APPLICATION_ID | Application identifier |
LAST_UPDATE_LOGIN | Standard Who column |
ENABLED_FLAG | Enabled flag |
END_DATE_ACTIVE | Last date response set is enabled |
RESPONSE_SET_ID | Response set identifier |
SECURITY_GROUP_ID | Used in hosted environments |
LAST_UPDATE_DATE | Standard Who column |
LAST_UPDATED_BY | Standard Who column |
CREATION_DATE | Standard Who column |
CREATED_BY | Standard Who column |
NAME | Response name |
ALERT_ID | Alert identifier |
DESCRIPTION | Description |
Alert - ALR_RESPONSE_VARIABLES | Response set variables |
---|---|
Column Name | Descritpion |
APPLICATION_ID | Application identifier |
CREATED_BY | Standard Who column |
LAST_UPDATE_LOGIN | Standard Who column |
TYPE | Response type |
DEFAULT_VALUE | Default value |
DATA_TYPE | Variable data type |
DETAIL_MAX_LEN | Maximum length |
ALERT_ID | Alert identifier |
SECURITY_GROUP_ID | Used in hosted environments |
RESPONSE_SET_ID | Response set identifier |
VARIABLE_NUMBER | Variable identifier |
NAME | Response variable name |
DESCRIPTION | Description |
LAST_UPDATE_DATE | Standard Who column |
LAST_UPDATED_BY | Standard Who column |
CREATION_DATE | Standard Who column |
Alert - ALR_RESPONSE_VARIABLE_VALUES | Actual variable and alert output values returned in a response message |
---|---|
Column Name | Descritpion |
MESSAGE_HANDLE | Message identifier |
SECURITY_GROUP_ID | Used in hosted environments |
NODE_HANDLE | Node identifier |
APPLICATION_ID | Application identifier |
ALERT_ID | Alert identifier |
RESPONSE_SET_ID | Response set identifier |
VARIABLE_NAME | Response set variable name |
VALUE | Response set variable value returned by user in response message |
DATA_TYPE | Variable data type |
DETAIL_MAX_LEN | Maximum length |
Alert - ALR_VALID_RESPONSES | Response text for each possible response to an alert message |
---|---|
Column Name | Descritpion |
APPLICATION_ID | Application identifier |
RESPONSE_TEXT | Text of possible valid response |
LAST_UPDATE_LOGIN | Standard Who column |
RESPONSE_NAME | Possible response name |
RESPONSE_ID | Response identifier |
SECURITY_GROUP_ID | Used in hosted environments |
LAST_UPDATE_DATE | Standard Who column |
LAST_UPDATED_BY | Standard Who column |
CREATION_DATE | Standard Who column |
CREATED_BY | Standard Who column |
ALERT_ID | Alert identifier |
RESPONSE_SET_ID | Response set identifier |
TYPE | Possible response type |
Alert - ALR_ACTION_DATA | Exceptions found during an action set check |
---|---|
Column Name | Descritpion |
APPLICATION_ID | Application identifier |
SECURITY_GROUP_ID | Used in hosted environments |
ACTION_HISTORY_ID | Action history identifier |
ROW_NUMBER | Exception identifier |
CHECK_ID | Action set check identifier |
DUPLICATE_FLAG | Flag indicating duplicate exception |
Alert - ALR_ACTION_GROUPS | Alert action, threshold, and escalation groups |
---|---|
Column Name | Descritpion |
APPLICATION_ID | Application identifier |
LAST_UPDATE_LOGIN | Standard Who column |
END_DATE_ACTIVE | Last date action group is enabled |
ENABLED_FLAG | Enabled flag |
DESCRIPTION | Description |
GROUP_TYPE | Escalation Group or Threshold Group |
ACTION_GROUP_ID | Action group identifier |
SECURITY_GROUP_ID | Used in hosted environments |
NAME | Action group name |
ALERT_ID | Alert identifier |
ACTION_GROUP_TYPE | Action group lookup type |
LAST_UPDATE_DATE | Standard Who column |
LAST_UPDATED_BY | Standard Who column |
CREATION_DATE | Standard Who column |
CREATED_BY | Standard Who column |
Alert - ALR_ACTION_GROUP_MEMBERS | Member actions of an alert action group |
---|---|
Column Name | Descritpion |
APPLICATION_ID | Application identifier |
LAST_UPDATE_LOGIN | Standard Who column |
END_DATE_ACTIVE | Last date action is enabled |
ENABLED_FLAG | Enabled flag |
ACTION_LEVEL | Detail action escalation level |
ACTION_GROUP_MEMBER_ID | Action group member identifier |
SECURITY_GROUP_ID | Used in hosted environments |
ACTION_GROUP_ID | Action group identifier |
ACTION_ID | Action identifier |
ALERT_ID | Alert identifier |
LAST_UPDATE_DATE | Standard Who column |
LAST_UPDATED_BY | Standard Who column |
CREATION_DATE | Standard Who column |
CREATED_BY | Standard Who column |
Alert - ALR_ACTION_HISTORY | Actual action execution history |
---|---|
Column Name | Descritpion |
APPLICATION_ID | Application identifier |
COLUMN_WRAP_FLAG | Column wrap flag |
MAXIMUM_SUMMARY_MESSAGE_WIDTH | Right margin of summary message |
ACTION_EXECUTED_FLAG | Flag recording whether or not Oracle Alert executed an action |
SUCCESS_FLAG | Flag denoting whether the action was performed successfully |
VERSION_NUMBER | Action version number |
MESSAGE_HANDLE | Response message identifier |
NODE_HANDLE | Response node identifier |
ACTION_HISTORY_ID | Action history identifier |
SECURITY_GROUP_ID | Used in hosted environments |
ALERT_ID | Alert identifier |
ACTION_SET_ID | Action set identifier |
CHECK_ID | Alert check identifier |
ACTION_ID | Action identifier |
ACTION_SET_MEMBER_ID | Action set member identifier |
LAST_UPDATE_DATE | Standard Who column |
ACTION_LEVEL | Detail action escalation level |
Alert - ALR_ACTION_OUTPUTS | Critical outputs used in a summary action |
---|---|
Column Name | Descritpion |
APPLICATION_ID | Application identifier |
CREATED_BY | Standard Who column |
LAST_UPDATE_LOGIN | Standard Who column |
ACTION_ID | Action identifier |
SECURITY_GROUP_ID | Used in hosted environments |
ALERT_ID | Alert identifier |
NAME | Action output name |
CRITICAL_FLAG | Flag denoting whether or not the output is critical in the summary action |
END_DATE_ACTIVE | Last Date the action is enabled |
LAST_UPDATE_DATE | Standard Who column |
LAST_UPDATED_BY | Standard Who column |
CREATION_DATE | Standard Who column |
Alert - ALR_ACTION_SETS | Alert action sets |
---|---|
Column Name | Descritpion |
APPLICATION_ID | Application identifier |
END_DATE_ACTIVE | Last date action set is enabled |
ENABLED_FLAG | Enabled flag |
RECIPIENTS_VIEW_ONLY_FLAG | Not used since Version 5.0 |
DESCRIPTION | Description |
SUPPRESS_FLAG | Flag recording whether you want to suppress duplicate exceptions found for the action set |
SUPPRESS_DAYS | Not used since Version 5.0 |
SEQUENCE | User-defined sequence number that identifies the execution order of enabled action sets for an alert |
ACTION_SET_ID | Action set identifier |
SECURITY_GROUP_ID | Used in hosted environments |
NAME | Action set name |
ALERT_ID | Alert identifier |
LAST_UPDATE_DATE | Standard Who column |
LAST_UPDATED_BY | Standard Who column |
CREATION_DATE | Standard Who column |
CREATED_BY | Standard Who column |
LAST_UPDATE_LOGIN | Standard Who column |
Alert - ALR_ACTION_SET_CHECKS | Action set check information |
---|---|
Column Name | Descritpion |
APPLICATION_ID | Application identifier |
SECURITY_GROUP_ID | Used in hosted environments |
CHECK_ID | Action set check identifier |
ALERT_ID | Alert identifier |
ACTION_SET_ID | Action set identifier |
ORACLE_ID | Oracle User identifier |
ALERT_CHECK_ID | Alert check identifier |
ROW_COUNT | Number of exceptions found for an action set check |
ACTION_COUNT | Number of actions performed for an action set check |
SUCCESS_FLAG | Success flag |
Alert - ALR_ACTION_SET_INPUTS | Alert action set inputs |
---|---|
Column Name | Descritpion |
APPLICATION_ID | Application identifier |
VALUE | Default action set input value |
ACTION_SET_ID | Action set identifier |
SECURITY_GROUP_ID | Used in hosted environments |
NAME | Action set input name |
ALERT_ID | Alert identifier |
LAST_UPDATE_DATE | Standard Who column |
LAST_UPDATED_BY | Standard Who column |
CREATION_DATE | Standard Who column |
CREATED_BY | Standard Who column |
LAST_UPDATE_LOGIN | Standard Who column |
Alert - ALR_ACTION_SET_MEMBERS | Member actions and action groups of alert action sets |
---|---|
Column Name | Descritpion |
APPLICATION_ID | Application identifier |
CREATION_DATE | Standard Who column |
CREATED_BY | Standard Who column |
LAST_UPDATE_LOGIN | Standard Who column |
END_DATE_ACTIVE | Last date action set member is enabled |
ENABLED_FLAG | Enabled flag |
SUMMARY_THRESHOLD | Only used if the action set member is a group, contains the number of exceptions above which Oracle Alert performs the summary action. A null value causes Oracle Alert to always perform detail level action; 0 causes summary level action. |
ABORT_FLAG | Flag denoting whether to abort the action set when an action set member fails |
ERROR_ACTION_SEQUENCE | The next action to perform when an error occurs |
ACTION_SET_MEMBER_ID | Action set member identifier |
SECURITY_GROUP_ID | Used in hosted environments |
ACTION_SET_ID | Action set identifier |
ACTION_ID | Action identifier |
ACTION_GROUP_ID | Action group identifier |
ALERT_ID | Alert identifier |
SEQUENCE | User-defined sequence number identifying the order of execution of an action or action group during an action set check |
LAST_UPDATE_DATE | Standard Who column |
LAST_UPDATED_BY | Standard Who column |
Alert - ALR_ACTION_SET_OUTPUTS | Alert action set outputs |
---|---|
Column Name | Descritpion |
APPLICATION_ID | Application identifier |
LAST_UPDATE_LOGIN | Standard Who column |
SUPPRESS_FLAG | Flag determines which outputs define a duplicate |
ACTION_SET_ID | Action set identifier |
SECURITY_GROUP_ID | Used in hosted environments |
NAME | Action set output name |
ALERT_ID | Alert identifier |
SEQUENCE | Action set output sequence (comes from the output sequence in the alert Select statement) |
LAST_UPDATE_DATE | Standard Who column |
LAST_UPDATED_BY | Standard Who column |
CREATION_DATE | Standard Who column |
CREATED_BY | Standard Who column |
Alert - ALR_LOOKUPS | Oracle Alert lookup types and codes |
---|---|
Column Name | Descritpion |
LOOKUP_TYPE | Oracle Alert lookup type |
LAST_UPDATE_LOGIN | Standard Who column |
CREATION_DATE | Standard Who column |
CREATED_BY | Standard Who column |
LOOKUP_CODE | Lookup code |
SECURITY_GROUP_ID | Used in hosted environments |
LAST_UPDATE_DATE | Standard Who column |
LAST_UPDATED_BY | Standard Who column |
MEANING | Lookup code meaning |
ENABLED_FLAG | Enabled flag |
DESCRIPTION | Lookup code description |
START_DATE_ACTIVE | Lookup code initial active date |
END_DATE_ACTIVE | Last date lookup code is enabled |
Alert - ALR_PERIODIC_SETS | Periodic alert sets |
---|---|
Column Name | Descritpion |
APPLICATION_ID | Application identifier |
SECURITY_GROUP_ID | Used in hosted environments |
PERIODIC_SET_ID | Periodic set identifier |
LAST_UPDATED_BY | Standard Who column |
LAST_UPDATE_DATE | Standard Who column |
CREATED_BY | Standard Who column |
CREATION_DATE | Standard Who column |
LAST_UPDATE_LOGIN | Standard Who column |
NAME | Periodic set name |
DESCRIPTION | Description |
Alert - ALR_PERIODIC_SET_MEMBERS | Member alerts and periodic sets of periodic sets |
---|---|
Column Name | Descritpion |
APPLICATION_ID | Application identifier |
CREATION_DATE | Standard Who column |
LAST_UPDATE_LOGIN | Standard Who column |
ENABLED_FLAG | Enabled flag |
END_DATE_ACTIVE | Last date periodic set is enabled |
PERIODIC_SET_ID | Periodic set identifier |
SECURITY_GROUP_ID | Used in hosted environments |
SEQUENCE | Periodic set member sequence number |
CHILD_APPLICATION_ID | Application identifier for periodic set member |
CHILD_ALERT_ID | Alert identifier for periodic set member |
CHILD_PERIODIC_SET_ID | Periodic set identifier for periodic set member |
LAST_UPDATED_BY | Standard Who column |
LAST_UPDATE_DATE | Standard Who column |
CREATED_BY | Standard Who column |
Alert - ALR_ALERT_INSTALLATIONS | Alert installation information |
---|---|
Column Name | Descritpion |
APPLICATION_ID | Application identifier |
LAST_UPDATE_LOGIN | Standard Who column |
ALERT_ID | Alert identifier |
SECURITY_GROUP_ID | Used in hosted environments |
ORACLE_ID | Oracle username |
DATA_GROUP_ID | Not currently used |
ENABLED_FLAG | Enabled flag |
LAST_UPDATE_DATE | Standard Who column |
LAST_UPDATED_BY | Standard Who column |
CREATION_DATE | Standard Who column |
CREATED_BY | Standard Who column |
Alert - ALR_MESSAGE_SYSTEMS | Electronic mail system information |
---|---|
Column Name | Descritpion |
NAME | Electronic mail system name |
LAST_UPDATE_LOGIN | Standard Who column |
CODE | Electronic mail system code |
SECURITY_GROUP_ID | Used in hosted environments |
COMMAND | Command to invoke electronic mail system |
ARGUMENTS | Arguments to invoke electronic mail system |
ENABLED_FLAG | Enabled flag |
LAST_UPDATE_DATE | Standard Who column |
LAST_UPDATED_BY | Standard Who column |
CREATION_DATE | Standard Who column |
CREATED_BY | Standard Who column |
Alert - ALR_ORACLE_MAIL_ACCOUNTS | Oracle*Mail mail account information |
---|---|
Column Name | Descritpion |
APPLICATION_ID | Application identifier |
CREATED_BY | Standard Who column |
LAST_UPDATE_LOGIN | Standard Who column |
ORACLE_ID | Oracle user identifier |
SECURITY_GROUP_ID | Used in hosted environments |
NAME | Electronic mail system account name |
ENCRYPTED_PASSWORD | Encrypted Oracle password |
SENDMAIL_ACCOUNT | Flag indicating whether or not this account is used to send alert message |
DEFAULT_RESPONSE_ACCOUNT | Flag indicating whether or not this account is the default response account |
LAST_UPDATE_DATE | Standard Who column |
LAST_UPDATED_BY | Standard Who column |
CREATION_DATE | Standard Who column |
Alert - ALR_RESPONSE_ACTION_HISTORY | Response processing history |
---|---|
Column Name | Descritpion |
RESPONSE_MESSAGE_ID | Response message identifier |
ALERT_ID | Alert identifier |
ORACLE_ID | Oracle user identifier |
SECURITY_GROUP_ID | Used in hosted environments |
SEQUENCE | Response action sequence |
ACTION_ID | Action identifier |
VERSION_NUMBER | Action version number |
SUCCESS_FLAG | Success flag |
MESSAGE_HANDLE | Message identifier |
NODE_HANDLE | Node identifier |
APPLICATION_ID | Application identifier |
Alert - ALR_RESPONSE_MESSAGES | Messages received in reply to an alert message |
---|---|
Column Name | Descritpion |
MESSAGE_HANDLE | Message identifier |
TO_RECIPIENTS | List of primary recipients |
CC_RECIPIENTS | List of copy recipients |
BCC_RECIPIENTS | List of blind copy recipients |
SENT_FROM | Mail account from which the message was sent |
REPLY_TO | Recipient of reply message |
SUBJECT | Message header |
RECEIVED | Time stamp of when the message is received |
BODY | Body of the message |
NODE_HANDLE | Node identifier |
SECURITY_GROUP_ID | Used in hosted environments |
APPLICATION_ID | Application identifier |
ALERT_ID | Alert identifier |
RESPONSE_SET_ID | Response set identifier |
RESPONSE_TYPE | Response type code |
RESPONSE_ID | Response identifier |
RESPONSE_MESSAGE_ID | Response message identifier |
DATE_PROCESSED | Date on which the response message was processed |
No hay comentarios:
Publicar un comentario