Groups
ALERT_PENDING
Col # | Column Name | Data Type | Field Length | Not Null? | Data Def. | Comments |
---|---|---|---|---|---|---|
1 | ID | NUMBER | 22 | N | ||
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 pending alerts to be picked up by the Alert Engine. Records are created when the subscription.current_balance or billing_group.balance passes the defined limit in the direction specified.