The COUNTER_SNAPSHOT table contains counter values of subscriptions or charging contracts.
The SAP CC system records the counter values in a snapshot during the charging and
refilling operations.
Note A subscription that is not set 'batch only' does not have any entry in this database
table.
| Schema Version | 5.0.6 | |
| Filegroup | C_SNAPSHOT_DATA | |
| Partitioned | Yes, when you use the partitioning scheme and corresponding SQL scripts | |
The COUNTER_SNAPSHOT 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 |
|---|---|---|---|---|---|---|
| SNAPSHOT_SUB_OID | PK_COUNTER_SNAPSHOT | SUBSCRIPTION (OID)
CACO (OID) |
|
The ID of the subscription or charging contract that the counters belong to | ||
| SNAPSHOT_ID | PK_COUNTER_SNAPSHOT |
|
The ID of the snapshot | |||
| SNAPSHOT_VALUE |
|
The compound value of all the counters in the subscription or charging contract | ||||
| PARTITION_ID | PK_COUNTER_SNAPSHOT |
|
The partition ID of the subscriber account holding the subscription or charging contract |
The database schema defines the following columns. Check the definitions, types, available indexes, and formats:
| Definition | The ID of the subscription or charging contract that the counters belong to |
| Description |
The identifier of the subscription or charging contract that includes
the counters recorded in the snapshot.
|
| Type | DECIMAL(28), NOT NULL |
| Primary Key | PK_COUNTER_SNAPSHOT |
| Definition | The ID of the snapshot |
| Type | DECIMAL(4), NOT NULL |
| Primary Key | PK_COUNTER_SNAPSHOT |
| Definition | The compound value of all the counters in the subscription or charging contract |
| Type | VARBINARY(MAX), NULL |
| Definition | The partition ID of the subscriber account holding the subscription or charging contract |
| Description |
The identifier of the database partition of the subscriber account that holds the subscription or charging contract.
|
| Type | DECIMAL(4), NOT NULL |
| Primary Key | PK_COUNTER_SNAPSHOT |
See the primary key information:
| Column(s) | PARTITION_ID,SNAPSHOT_SUB_OID,SNAPSHOT_ID |
| Filegroup | C_SNAPSHOT_DATA |
