OBJECT_SNAPSHOT
Definition
The OBJECT_SNAPSHOT table contains copies of objects, which are created either before
or after the execution of an operation which changed the object (creation, modification
or deletion)
Technical Data
| Schema Version |
4.5.13 |
| Filegroup |
OBJECT_CHANGE_DATA |
| Partitioned |
Yes, when you use the partitioning scheme and corresponding SQL scripts |
Summary
The OBJECT_SNAPSHOT table is defined by the
following columns.
See the column details for more information.
Column Details
OID
| Definition |
The unique identifier of the object snapshot |
| Type |
DECIMAL(28), NOT NULL |
| Available Index |
IX_OBJ_SNPSH_OID |
PARTITION_ID
| Definition |
The partition identifier of the object associated to the snapshot (will be set to
-1 for technical objects which are unique in the SAP CC system or for the objects
without partition identifier)
|
| Type |
DECIMAL(4), NOT NULL |
| Available Index |
IX_OBJ_SNPSH_OID |
RECORDING_DATE
| Definition |
The date when the object snapshot was recorded |
| Type |
DATETIME, NOT NULL |
| Available Index |
IX_OBJ_SNPSH_OID |
VERSION_ID
| Definition |
The version of the SAP Convergent Charging Core Server when the object change log
was recorded
|
| Type |
NVARCHAR(20), NOT NULL |
VALUE
| Definition |
The value of the object snapshot |
| Type |
VARBINARY(MAX), NOT NULL |
Index Details
The following database indexes are available in the
OBJECT_SNAPSHOT database table to improve the speed of data retrieval operations during
the business processes of SAP Convergent Charging:
IX_OBJ_SNPSH_OID
| Indexed Column(s) |
PARTITION_ID,OID,RECORDING_DATE |
| Unique |
Yes |
| Partitioned |
Yes |
| Clustered |
Yes |
| Filegroup |
OBJECT_CHANGE_INDX |
