VERSION
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
Summary
The VERSION table is defined by the
following columns.
See the column details for more information.
Column Details
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 technial major and minor version numbers of the SAP
CC software. 4.5 stands for SAP CC 4.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 |
