Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Section
Column
width33%

Groups

Wiki Markup
{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
width33%

ALERT_PENDING

Col #

Column NameData TypeField LengthNot 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

  
Column
width33%

Holds queue of alerts to be executed by the Alert Engine /wiki/spaces/NWRARSDEPRECATED/pages/113422553. Records are created when the subscription.current_balance or billing_group.balance passes the defined limit in the direction specified.