{float:left|width=200px|background=lightgrey|border=solid blue 2px|margin=1px|padding=0px}
{children:page=Rator DB ER Diagram Navigator|depth=1|excerpt=trueindent=1px}
{float}
Column
width
33%
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
Column
width
33%
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.