NOTIFICATION

Groups

NOTIFICATION

Column NameData TypeField LengthNot Null?Data Def.Comments

ID

NUMBER

 

N

 'Primary' key
VALID_FROMDATE

 

 

 

 

VALID_TO

DATE

 

 

 

 

PRIORITY

NUMBER

 

 

  

MESSAGE_TYPE_ID

NUMBER

 

 

  

CHANGED_BY_OPERATOR_ID

NUMBER

 

 

  
CUSTOMER_TYPE

VARCHAR2

1000

 

 

 

BROADCAST_CHANNEL

VARCHAR2

500

 

 

 

CREATE_DATE

DATE

 

 

  
LAST_CHANGED_DATE

DATE

 

 

 

 

IS_PUBLISHED

CHAR1

Default 'N'

 

  

Added with 10.3.1 in support of Notification feature.

 

Â