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 | 4.6.2 | |
| 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 | ||||
| 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. 4.6 stands for SAP CC 4.1. |
| 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 |