DICO

Definition

The DICO table contains information about distributed counters

Description

The DICO table contains the values of the persistent counters that are associated to shared allowances.

Technical Data

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

Summary

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

Name	PK	IX	Uses	Definition
COUN_KEY	PK_DICO	IX_DICO_VERSION_ID	COUNTER (COUN_KEY)	The internal identification key of the distributed counter
TYPE				The TYPE field indicates if the distributed counter is an increment or a decrement counter More...
ALLO_OID	PK_DICO	IX_DICO_VERSION_ID	ALLO (OID)	The identifier of the shared allowance holding the distributed counter
HOLD_OID	PK_DICO	IX_DICO_VERSION_ID		The identifier of the holder of the distributed counter More...
PARTITION_ID	PK_DICO	IX_DICO_VERSION_ID		The identifier of the database partition that contains the distributed counter
STATUS				The status of the distributed counter More...
VALUE				The value of the distributed counter
VERSION_ID		IX_DICO_VERSION_ID		The identifier of the version of the distributed counter

Column Details

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

COUN_KEY

Definition	The internal identification key of the distributed counter
Type	DECIMAL(4), NOT NULL
Primary Key	PK_DICO
Available Index	IX_DICO_VERSION_ID

TYPE

Definition The TYPE field indicates if the distributed counter is an increment or a decrement counter

Format

The possible values are:

0: Decrement counter
1: Increment counter

Type DECIMAL(1), NOT NULL

ALLO_OID

Definition	The identifier of the shared allowance holding the distributed counter
Type	DECIMAL(28), NOT NULL
Primary Key	PK_DICO
Available Index	IX_DICO_VERSION_ID

HOLD_OID

Definition	The identifier of the holder of the distributed counter
Description	The identifier of the holder of the distributed counter, that can be: A charge activation of an allowance An allowance
Type	DECIMAL(28), NOT NULL
Primary Key	PK_DICO
Available Index	IX_DICO_VERSION_ID

PARTITION_ID

Definition	The identifier of the database partition that contains the distributed counter
Type	DECIMAL(4), NOT NULL
Primary Key	PK_DICO
Available Index	IX_DICO_VERSION_ID

STATUS

Definition The status of the distributed counter

Format

The possible values are:

0 : usable. Set when the counter is created to inform that this counter is usable
1 : empty. Set by the rater to inform that this counter is empty
2 : not usable. The counter is not usable because the holding allowance has been purged or deleted, or because the counter is empty without any existing reservation
3 : locked_closed. The counter is locked because the holding allowance is owned by a provider contract that is locked or closed

Type DECIMAL(4), NOT NULL

VALUE

Definition	The value of the distributed counter
Type	DECIMAL(28,6), NULL

VERSION_ID

Definition	The identifier of the version of the distributed counter
Type	DECIMAL(28), NOT NULL
Available Index	IX_DICO_VERSION_ID

Primary Key Details

See the primary key information:

PK_DICO

Column(s)	PARTITION_ID,ALLO_OID,HOLD_OID,COUN_KEY
Segment	COUNTER_INDX

Index Details

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

IX_DICO_VERSION_ID

Indexed Column(s)	PARTITION_ID,VERSION_ID,ALLO_OID,HOLD_OID,COUN_KEY
Unique	Yes
Partitioned	Yes
Clustered	No