EVENT_RATE

Definition


The EVENT_RATE table contains information about event rates

Technical Data


Schema Version 4.5.13
Tablespace CATALOG_DATA
Partitioned No

Summary


The EVENT_RATE table is defined by the following columns. See the column details for more information.

Name PK FK IX Uses Used by
OID PK_EVENT_RATE        RATE_COMPONENT_HOLDER (EVRA_OID)
 
INDEX_IN_PLAN          
NAME          
DESCRIPTION          
EVENT_CODE          
PLAN_OID       PRICE_PLAN (OID)
 
 

Column Details


OID

Definition The unique identifier of the event rate
Type DECIMAL(28), NOT NULL
Primary Key PK_EVENT_RATE

INDEX_IN_PLAN

Definition The position of the event rate in the price plan
Type DECIMAL(5), NOT NULL

NAME

Definition The name of the rate
Type VARCHAR(256), NOT NULL

DESCRIPTION

Definition The description of the rate
Type VARCHAR(2000), NULL

EVENT_CODE

Definition The event code of this rate
Type VARCHAR(256), NULL

PLAN_OID

Definition The ID of the price plan of the event rate
Type DECIMAL(28), NOT NULL

Primary Key Details


PK_EVENT_RATE

Column(s) OID
Tablespace CATALOG_INDX