CACI_PARAMETER

Definition

The CACI_PARAMETER table contains the parameters of the charging contract items

Technical Data

Schema Version	5.0.6
Tablespace	SUBSCRIBER_DATA
Partitioned	Yes, when you use the partitioning scheme and corresponding SQL scripts

Summary

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

Name	PK	FK	IX	Uses	Used by	Definition
CACI_OID				CACI (OID)		The identifier of the charging contract item
CACO_OID			IX_CACI_IPR_CACO			The identifier of the charging contract
PARTITION_ID				CACI (PARTITION_ID)		The partition of the subscriber account
NAME_KEY						The identifier of the parameter name in the charge plan dictionary
VALUE_TYPE						The type of the parameter More...
NUMBER_VALUE						The value of the parameter when it is a number
STRING_VALUE						The value of the parameter when it is a string
DATE_VALUE						The value of the parameter when it is a date
START_DATE						The effective date of the parameter
END_DATE						The expiration date of the parameter

Column Details

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

CACI_OID

Definition	The identifier of the charging contract item
Type	DECIMAL(28), NOT NULL

CACO_OID

Definition	The identifier of the charging contract
Type	DECIMAL(28), NOT NULL
Available Index	IX_CACI_IPR_CACO

PARTITION_ID

Definition	The partition of the subscriber account
Type	DECIMAL(4), NOT NULL

NAME_KEY

Definition	The identifier of the parameter name in the charge plan dictionary
Type	DECIMAL(28), NOT NULL

VALUE_TYPE

Definition	The type of the parameter
Format	The possible values are: 0: number 1: string 2: date 3: currency
Type	DECIMAL(1), NOT NULL

NUMBER_VALUE

Definition	The value of the parameter when it is a number
Type	DECIMAL(28,6), NULL

STRING_VALUE

Definition	The value of the parameter when it is a string
Type	VARCHAR(2000), NULL

DATE_VALUE

Definition	The value of the parameter when it is a date
Type	TIMESTAMP, NULL

START_DATE

Definition	The effective date of the parameter
Type	TIMESTAMP, NULL

END_DATE

Definition	The expiration date of the parameter
Type	TIMESTAMP, NULL

Index Details

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

IX_CACI_IPR_CACO

Indexed Column(s)	CACO_OID
Unique	No
Partitioned	Yes
Tablespace	SUBSCRIBER_INDX