Tables

CDR

Consumption Detail Records

Description

Technical Data

Schema Version	4.5.2
Filegroup	CDR_DATA
Partitioned	Yes, when you use the partitioning scheme and corresponding SQL scripts

Summary

The CDR table is defined by the following columns. See the column details for more information.

Name	PK	FK	IX	Uses	Used by
OID			IX_CDR_OID
BGRP_OID			IX_SUBS_CDR IX_CDR_OID IX_CDR_SE IX_STATUS
NAME
USER_ID
SERVICE_ID
SUBSCRIPTION_ID			IX_SUBS_CDR
PARTITION_ID
CHARGE_ID
CONSUMPTION_DATE			IX_MAGIC_NUMBER IX_CDR_SE IX_STATUS
STATUS			IX_STATUS
ACQUISITION_DATE
ACQUISITION_ID
RATING_DATE
RATING_ID			IX_STATUS
ERROR_CODE
ERROR_DESCRIPTION
SOURCE
MAGIC_NUMBER			IX_MAGIC_NUMBER IX_STATUS
PROPERTIES
SNAPSHOT_ID
CHARGE_TYPE

Additional Information

Consult the online Help documentation of the SAP CC BART Tool user interface.

Column Details

OID

Definition	The unique ID of the CDR
Type	DECIMAL(28), NOT NULL
Available Index	IX_CDR_OID

BGRP_OID

Definition	The unique batch rating group ID
Type	DECIMAL(2), NOT NULL
Available Index	IX_SUBS_CDR
Available Index	IX_CDR_OID
Available Index	IX_CDR_SE
Available Index	IX_STATUS

NAME

Definition	The code name of the chargeable item that is sent to the SAP CC Core Server system to be batch charged
Type	NVARCHAR(256), NOT NULL

USER_ID

Definition	Part of the user access of the chargeable item
Description	Part of the user access of the chargeable item: technical identifier of an end customer who consumes a service. This ID relates to the customer service ID.
Type	NVARCHAR(256), NOT NULL

SERVICE_ID

Definition	Part of the user access of the chargeable item: technical identifier of the customer service.
Type	NVARCHAR(256), NOT NULL

SUBSCRIPTION_ID

Definition	The identifier of the subscription (or provider contract) determined by the consolidation operation
Type	DECIMAL(28), NOT NULL
Available Index	IX_SUBS_CDR

PARTITION_ID

Definition	The identifier of the partition determined by the consolidation operation
Type	DECIMAL(4), NOT NULL

CHARGE_ID

Definition	The identifier of the charge determined by the consolidation operation
Type	DECIMAL(28), NOT NULL

CONSUMPTION_DATE

Definition	The service consumption date recorded in the CDR
Type	DATETIME, NOT NULL
Available Index	IX_MAGIC_NUMBER
Available Index	IX_CDR_SE
Available Index	IX_STATUS

STATUS

Definition	The current status of the CDR
Format	The possible values are: `0`: the CDR has correctly been acquired and consolidated `1`: an attempt of rating has been done but a rating error occurs `2`: the CDR has been successfully rated and charged in bacth mode 3: the CDR is a duplicate 4: the CDR will be ignored by the next rating session. It has to be manually set. 5: DEPRECATED value 6: the CDR is selected to be rerated through the SAP CC rerating operation 7: the CDR has been acquired but not consolidated `8`: the CDR is linked to an online only subscription and not an offline subscription
Type	DECIMAL(1), NOT NULL
Available Index	IX_STATUS

ACQUISITION_DATE

Definition	The acquisition date of the CDR by the BART Server system
Type	DATETIME, NOT NULL

ACQUISITION_ID

Definition	The ID of the acquisition session during which the CDR was acquired from a downstream application or system
Type	DECIMAL(28), NULL

RATING_DATE

Definition	The date of the last batch rating and charging session
Type	DATETIME, NULL

RATING_ID

Definition	The ID of the last batch rating and charging session
Type	DECIMAL(28), NULL
Available Index	IX_STATUS

ERROR_CODE

Definition	The numerical code of the batch rating and charging error
Description	The numerical code of the batch rating and charging error. The BART Server system sets up this value depending on the charging result received from the Core Server system. Note Consult the Error Code Reference for Batch Charging documentation for more information about these codes.
Type	DECIMAL(4), NULL

ERROR_DESCRIPTION

Definition

The text description of the rating/charging error

Description

The detailed text description of the rating and charging error that is sent by the Core Server system to the BART Server system. The error description is visible in the BART Tool user interface.

Note

Consult the Error Code Reference for Batch Charging documentation for more information about the necessary investigations.

Type

NVARCHAR(1000), NULL

SOURCE

Definition	The source which the CDR comes from
Description	The source which the CDR comes from. For example, the name of the source file.
Type	NVARCHAR(1000), NULL

MAGIC_NUMBER

Definition	The business identifier of the CDR for deduplication
Type	CHAR(34), NULL
Available Index	IX_MAGIC_NUMBER
Available Index	IX_STATUS

PROPERTIES

Definition	The list of CDR properties values
Description	The list of CDR properties values. The structure of the data stored in this column is specified in the PROPERTIES table.
Type	NVARCHAR(4000), NULL

SNAPSHOT_ID

Definition	The snapshot identifier of the last rerating session
Type	DECIMAL(8), NOT NULL
Default	0

CHARGE_TYPE

Definition	The type of the charge (subscription/provider contract)
Type	DECIMAL(1), NOT NULL
Default	0

Index Details

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

IX_MAGIC_NUMBER

Indexed Column(s)	CONSUMPTION_DATE,MAGIC_NUMBER
Unique	Yes
Partitioned	Yes
Clustered	No
Filegroup	CDR_INDX

IX_SUBS_CDR

Indexed Column(s)	BGRP_OID,SUBSCRIPTION_ID
Unique	No
Partitioned	Yes
Clustered	No
Filegroup	CDR_INDX

IX_CDR_OID

Indexed Column(s)	BGRP_OID,OID
Unique	No
Partitioned	Yes
Clustered	No
Filegroup	CDR_INDX

IX_CDR_SE

Indexed Column(s)	CONSUMPTION_DATE,BGRP_OID
Unique	No
Partitioned	No
Clustered	No
Filegroup	CDR_INDX

IX_STATUS

Indexed Column(s)	BGRP_OID,CONSUMPTION_DATE,STATUS,RATING_ID,MAGIC_NUMBER
Unique	No
Partitioned	Yes
Clustered	Yes
Filegroup	CDR_INDX