RATE_COMPONENT

Definition

The RATE_COMPONENT table contains basic information about rating and charging components

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.

Technical Data

Schema Version	5.0.6
Tablespace	CATALOG_DATA
Partitioned	No

Summary

The RATE_COMPONENT table is defined by the following columns in your back-end database. See the column details for more information.

Name	PK	IX	Uses	Used by	Definition
OID	PK_RATE_COMPONENT			RATE_COMPONENT_PROPERTY (RCOM_OID) RATE_COMPONENT (RCOM_OID)	The component unique ID. It is generated by the SAP CC system.
NAME					The name of the component
DESCRIPTION					The description of the component
TYPE					The type of the component More...
RCOM_OID		IX_RCOM_RCOM	RATE_COMPONENT (OID)		The parent component ID
INDEX_IN_RCOM					The position of the rate component into its parent component
RCHO_OID		IX_RCOM_RCOH	RATE_COMPONENT_HOLDER (OID)		The component holder

Column Details

The database schema defines the following columns. Check the definitions, types, available indexes, and formats:

OID

Definition	The component unique ID. It is generated by the SAP CC system.
Type	DECIMAL(28), NOT NULL
Primary Key	PK_RATE_COMPONENT

NAME

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

DESCRIPTION

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

TYPE

Definition The type of the component

Format

The 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
40: property introducer
41: tier table introducer
42: concatenate
43: mapping table introducer
44: state schedule updater
45: refill
46: switching
47: range table introducer
48: create allowance
49: allowance event sender
50: allowance validity period updater
51: event allowance
52: allowance property introducer
53: allowance event updater
54: allow
55: debit counter
56: credit counter

Type DECIMAL(3), NOT NULL

RCOM_OID

Definition	The parent component ID
Type	DECIMAL(28), NULL
Available Index	IX_RCOM_RCOM

INDEX_IN_RCOM

Definition	The position of the rate component into its parent component
Type	DECIMAL(5), NOT NULL

RCHO_OID

Definition	The component holder
Type	DECIMAL(28), NULL
Available Index	IX_RCOM_RCOH

Primary Key Details

See the primary key information:

PK_RATE_COMPONENT

Column(s)	OID
Tablespace	CATALOG_INDX

Index Details

The following database indexes are available in the RATE_COMPONENT database table to improve the speed of data retrieval operations during the business processes of SAP Convergent Charging:

IX_RCOM_RCOM

Indexed Column(s)	RCOM_OID
Unique	No
Partitioned	No
Tablespace	CATALOG_INDX

IX_RCOM_RCOH

Indexed Column(s)	RCHO_OID
Unique	No
Partitioned	No
Tablespace	CATALOG_INDX