| 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