RATE_COMPONENT

Table: RATE_COMPONENT

Table Name

RATE_COMPONENT

Table Description

The RATE_COMPONENT table contains basic information about rating and charging components. The rating components are used to build price plans and the charging components are used to build charging plan.

Tablespace

CATALOG_DATA

Database

Core Database

Columns

OID
NAME
DESCRIPTION
TYPE
RCOM_OID
INDEX_IN_RCOM
RCHO_OID

Columns of the Table

The RATE_COMPONENT database table is defined by the following columns.

Column: OID

Value Type	BIGINT, NOT NULL
Key(s)	Primary Key: PK_RATE_COMPONENT	Foreign K.: Foreign table: RATE_COMPONENT_HOLDER RATE_COMPONENT Foreign field(s): OID OID
Index(es)	IX_RCOM_RCOM IX_RCOM_RCOH
Column Description	The component unique ID. It is generated by the system.

Column: NAME

Value Type	VARCHAR(256)
Column Description	The name of the component.

Column: DESCRIPTION

Value Type	VARCHAR(2000)
Column Description	The description of the component.

Column: TYPE

Value Type	DECIMAL(3), NOT NULL
Column Description	The type of the component. Possible values are: 0: date in slot 1: filter 2: generic function 3: multi-valued evaluator 4: polynomial 5: prefix switch 6: property type converter 7: prorate 8: public holiday 9: public holiday splitter 10: shift date 11: switch number comparison 12: switch table 13: time adapter 14: time slot splitter 15: aggregate 16: arithmetic 17: comparison 18: counter update 19: date comparison 20: duration 21: flat 22: free 23: linear 24: no access 25: number splitter 26: string comparison 27: in macro 28: pre macro 29: out property update 30: pre table 31: usage charge 32: recurring charge 33: one shot charge 34: default charge 35: internal charge action 36: external charge action 37: refill charge action 38: default charge action 39: alert triggering

Value Type

DECIMAL(3), NOT NULL

Column Description

The type of the component.

Possible values are:

0: date in slot
1: filter
2: generic function
3: multi-valued evaluator
4: polynomial
5: prefix switch
6: property type converter
7: prorate
8: public holiday
9: public holiday splitter
10: shift date
11: switch number comparison
12: switch table
13: time adapter
14: time slot splitter
15: aggregate
16: arithmetic
17: comparison
18: counter update
19: date comparison
20: duration
21: flat
22: free
23: linear
24: no access
25: number splitter
26: string comparison
27: in macro
28: pre macro
29: out property update
30: pre table
31: usage charge
32: recurring charge
33: one shot charge
34: default charge
35: internal charge action
36: external charge action
37: refill charge action
38: default charge action
39: alert triggering

Column: RCOM_OID

Value Type	BIGINT
Key(s)	-	Foreign K.: Foreign table: RATE_COMPONENT Foreign field(s): OID
Index(es)	IX_RCOM_RCOM
Column Description	The parent component ID.

Column: INDEX_IN_RCOM

Value Type	DECIMAL(5), NOT NULL
Column Description	The position of the rate component into its parent component.

Column: RCHO_OID

Value Type	BIGINT
Key(s)	-	Foreign K.: Foreign table: RATE_COMPONENT_HOLDER Foreign field(s): OID
Index(es)	IX_RCOM_RCOH
Column Description	The component holder.

Top of the list

SAP Convergent Charging 3.0

Document Version: SP04 and later