Groups
ALERT_PENDING
Col # | Column Name | Data Type | Field Length | Not Null? | Data Def. | Comments |
|---|---|---|---|---|---|---|
| 1 | ID | NUMBER | 22 | N | Primary key | |
| 2 | ALERT_ID | NUMBER | 22 | Y | ||
| 3 | SUBSCRIPTION_ID | NUMBER | 22 | Y | ||
| 4 | CREATED_DATE | DATE | 7 | Y | ||
| 5 | PARAMETERS | VARCHAR2 | 1000 | Y | ||
| 6 | BILLING_GROUP_ID | NUMBER | 22 | Y | ||
| 7 | STATUS_ID | NUMBER | 22 | Y | ||
| 8 | START_DATE | DATE | 7 | Y |
Holds queue of alerts to be executed by the Alert Engine. Records are created when the subscription.current_balance or billing_group.balance passes the defined limit in the direction specified.