Tables

CDR

Consumption Detail Records

Definition

The CDR table is the main table and includes all the transactional data in the form of Consumption Data Records (CDRs)

Description

The CDR table is the main table and includes all the transactional data in the form of Consumption Data Records (CDRs). It contains all the consumption data records (CDRs) acquired, consolidated, and archived by the SAP CC BART Server system after the batch acquisition and batch charging operations.

Technical Data

Schema Version	5.0.5
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 in your back-end database. See the column details for more information.

Name	IX	Definition
OID	IX_CDR_OID	The unique ID of the CDR
BGRP_OID	IX_SUBS_CDR IX_CDR_OID IX_CDR_SE IX_STATUS	The unique batch rating group ID
NAME		The code name of the chargeable item that is sent to the SAP CC Core Server system to be batch charged
USER_ID		Part of the user access of the chargeable item More...
SERVICE_ID		Part of the user access of the chargeable item: technical identifier of the customer service.
SUBSCRIPTION_ID	IX_SUBS_CDR	The identifier of the subscription (or provider contract) determined by the consolidation operation
PARTITION_ID		The identifier of the partition determined by the consolidation operation
SUAC_ID		The identifier of the subscriber account determined by the consolidation operation
CHARGE_ID		The identifier of the charge determined by the consolidation operation
CONSUMPTION_DATE	IX_MAGIC_NUMBER IX_CDR_SE IX_STATUS	The service consumption date recorded in the CDR
STATUS	IX_STATUS	The current status of the CDR More...
ACQUISITION_DATE		The acquisition date of the CDR by the BART Server system
ACQUISITION_ID		The ID of the acquisition session during which the CDR was acquired from a downstream application or system
RATING_DATE		The date of the last batch rating and charging session
RATING_ID	IX_STATUS	The ID of the last batch rating and charging session
ERROR_CODE		The numerical code of the batch rating and charging error More...
ERROR_DESCRIPTION		The text description of the rating/charging error More...
SOURCE		The source which the CDR comes from More...
MAGIC_NUMBER	IX_MAGIC_NUMBER IX_STATUS	The business identifier of the CDR for deduplication
PROPERTIES		The list of CDR properties values More...
SNAPSHOT_ID		The snapshot identifier of the last rerating session
CHARGE_TYPE		The type of the charge (subscription/provider contract)

Additional Information

Consult the primary help of the SAP CC BART Tool user interface.

Column Details

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

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

SUAC_ID

Definition	The identifier of the subscriber account determined by the consolidation operation
Type	DECIMAL(28), 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