CCON_PARAMETER

Definition

The CCON_PARAMETER table contains information about parameters in charge conditions

Description

The CCON_PARAMETER table contains information about parameters in charge conditions. These parameters are first created in the price plan of the charge component corresponding to the charge condition. Then they are redefined in the charge condition.

Technical Data

Schema Version	5.0.6
Filegroup	CATALOG_DATA
Partitioned	No

Summary

The CCON_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
INDEX_IN_CCON						The index of the parameter in the charge condition
NAME						The name of the parameter
DESCRIPTION						The description of the parameter
PARAMETER_NAME						The parameter in the charge condition can be linked to a parameter with the same type defined in the offer More...
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
CCON_OID			IX_CCPA_CCON	CHARGE_CONDITION (OID)		The identifier of the charge condition owning the parameter
VALIDATION_DATE						The date when the parameter becomes valid

Column Details

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

INDEX_IN_CCON

Definition	The index of the parameter in the charge condition
Type	DECIMAL(5), NOT NULL

NAME

Definition	The name of the parameter
Type	NVARCHAR(256), NULL

DESCRIPTION

Definition	The description of the parameter
Type	NVARCHAR(2000), NULL

PARAMETER_NAME

Definition	The parameter in the charge condition can be linked to a parameter with the same type defined in the offer
Description	The parameter in the charge condition can be linked to a parameter with the same type defined in the offer. The PARAMETER_NAME field gives the name of the parameter defined in the offer.
Type	NVARCHAR(256), NULL

VALUE_TYPE

Definition	The type of the parameter
Format	The possible values are: 0: number 1: string 2: date
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	NVARCHAR(2000), NULL

DATE_VALUE

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

CCON_OID

Definition	The identifier of the charge condition owning the parameter
Type	DECIMAL(28), NOT NULL
Available Index	IX_CCPA_CCON

VALIDATION_DATE

Definition	The date when the parameter becomes valid
Type	DATETIME, NULL

Index Details

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

IX_CCPA_CCON

Indexed Column(s)	CCON_OID
Unique	No
Partitioned	No
Clustered	No
Filegroup	CATALOG_INDX