A-Z Index of MS SQL Server Tables

The following tables exist in the database:

name description

ACQUISITION_SESSION The ACQUISITION_SESSION table contains information related to the acquisition session

BART_VERSION The BART_VERSION table contains the history of the database changes performed on an installed version of SAP CC BART

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

CERT_STORE The CERT_STORE table contains the certificates of clients allowed when using SSL

CLEAN_BART_JOB The table contains information for cleaning jobs

COLLECTION This table contains the collection of contracts that must be rerated together in a rerating session

ID_TABLE The ID_TABLE table is used for generating the OID (the unique ID of a CDR in the database)

INSTANCE_CERT_STORE The INSTANCE_CERT_STORE table links a service to a client certificate for using SSL

INSTANCE_KEY_STORE The INSTANCE_KEY_STORE table links a service to a key store entry for using SSL

KEY_STORE The KEY_STORE table contains the private keys and their associated certificates for using SSL

PARTITION_DIRECTORY The table contains the directories where tablespaces or filegroups are saved

PARTITION_PURGE The PARTITION_PURGE table contains defines the number of days/partitions of data stored in tables and the number of days/partitions created in advance

PARTITION_STATUS The PARTITION_STATUS table gives the partition date, the directory of the data file and the status of each partition

PROPERTIES The PROPERTIES table contains the name of the properties used in the CDR

PURGE_ARCHIVE_EXCEPTION The PURGE_ARCHIVE_EXCEPTION table contains information about errors occurring during the purge/archive process

RATING_SESSION The RATING_SESSION table contains information related to the batch rating and charging sessions

RATING_SESSION_JOB The RATING_SESSION_JOB table contains information related to rating session job

RERATING_SESSION The RERATING_SESSION table contains information used by the rerating process

RERATING_SESSION_ORDER The table contains the request sent by SAP Convergent Charging for rerating CDRs

SCHEDULABLE_JOB The SCHEDULABLE_JOB table contains general information related to jobs

name	description
ACQUISITION_SESSION	The ACQUISITION_SESSION table contains information related to the acquisition session
BART_VERSION	The BART_VERSION table contains the history of the database changes performed on an installed version of SAP CC BART
CDR	The CDR table is the main table and includes all the transactional data in the form of Consumption Data Records (CDRs)
CERT_STORE	The CERT_STORE table contains the certificates of clients allowed when using SSL
CLEAN_BART_JOB	The table contains information for cleaning jobs
COLLECTION	This table contains the collection of contracts that must be rerated together in a rerating session
ID_TABLE	The ID_TABLE table is used for generating the OID (the unique ID of a CDR in the database)
INSTANCE_CERT_STORE	The INSTANCE_CERT_STORE table links a service to a client certificate for using SSL
INSTANCE_KEY_STORE	The INSTANCE_KEY_STORE table links a service to a key store entry for using SSL
KEY_STORE	The KEY_STORE table contains the private keys and their associated certificates for using SSL
PARTITION_DIRECTORY	The table contains the directories where tablespaces or filegroups are saved
PARTITION_PURGE	The PARTITION_PURGE table contains defines the number of days/partitions of data stored in tables and the number of days/partitions created in advance
PARTITION_STATUS	The PARTITION_STATUS table gives the partition date, the directory of the data file and the status of each partition
PROPERTIES	The PROPERTIES table contains the name of the properties used in the CDR
PURGE_ARCHIVE_EXCEPTION	The PURGE_ARCHIVE_EXCEPTION table contains information about errors occurring during the purge/archive process
RATING_SESSION	The RATING_SESSION table contains information related to the batch rating and charging sessions
RATING_SESSION_JOB	The RATING_SESSION_JOB table contains information related to rating session job
RERATING_SESSION	The RERATING_SESSION table contains information used by the rerating process
RERATING_SESSION_ORDER	The table contains the request sent by SAP Convergent Charging for rerating CDRs
SCHEDULABLE_JOB	The SCHEDULABLE_JOB table contains general information related to jobs