VERSION

Definition

The VERSION table contains the history of the database changes performed on an installed version of SAP Convergent Charging

Description

The VERSION table contains the history of the database changes performed on an installed version of SAP Convergent Charging. If the database schema changes, a row is inserted in this table with the new schema version number (see VERSION_ID). If the schema does not change, the schema version remains the same.

Technical Data

Schema Version	5.0.6
Filegroup	CATALOG_DATA
Partitioned	No

Summary

The VERSION 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
SYSTEM_ID						The SID (SAP System ID) of the SAP CC Core Server system that connects to this back-end database
INSTALL_DATE						The date of the database schema setup or update
VERSION_ID						The technical version number of the SAP CC Core Database schema More...
LAST_SETUP_DATE						The date when the instance map was last change
LAST_RATER_CONFIG_DATE						The date when the rater type instance configuration was last change
LAST_BACKUP_CONFIG_DATE						The date when the backup type instance configuration was last change
LAST_UPDATER_CONFIG_DATE						The date when the updater type instance configuration was last change
LAST_GUIDER_CONFIG_DATE						The date when the guider type instance configuration was last change

Column Details

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

SYSTEM_ID

Definition	The SID (SAP System ID) of the SAP CC Core Server system that connects to this back-end database
Type	NVARCHAR(3), NULL

INSTALL_DATE

Definition	The date of the database schema setup or update
Type	DATETIME, NOT NULL

VERSION_ID

Definition

The technical version number of the SAP CC Core Database schema

Description

This number must be compliant with the technical version number of the SAP CC Core Server system connected to this database. The third digit is the schema number is the same for all the database, whatever the technology. The two first digits are the technical major and minor version numbers of the SAP CC software.

5.0 stands for SAP CC 5.0
4.6 stands for SAP CC 4.1
4.5 stands for SAP CC 4.0
4.4 stands for SAP CC 3.0
4.3 stands for SAP CC 2.0

Type

NVARCHAR(20), NOT NULL

LAST_SETUP_DATE

Definition	The date when the instance map was last change
Type	DATETIME, NULL

LAST_RATER_CONFIG_DATE

Definition	The date when the rater type instance configuration was last change
Type	DATETIME, NULL

LAST_BACKUP_CONFIG_DATE

Definition	The date when the backup type instance configuration was last change
Type	DATETIME, NULL

LAST_UPDATER_CONFIG_DATE

Definition	The date when the updater type instance configuration was last change
Type	DATETIME, NULL

LAST_GUIDER_CONFIG_DATE

Definition	The date when the guider type instance configuration was last change
Type	DATETIME, NULL