The METRIC_RECORD table contains product and system usage information recorded as
usage metrics.
The system measures multiple values. Each database record stores a list of metric
values.
You use this information to audit your system.
In the SAP CC Core Server system, the updater instance collects, consolidates, and
purges the usage metrics daily.
Licensing may use some of these metrics and includes statistics in your license auditing
reports.
| Schema Version | 5.0.6 | |
| Filegroup | CATALOG_DATA | |
| Partitioned | No | |
The METRIC_RECORD 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 |
|---|---|---|---|---|---|---|
| OID | PK_METRIC |
|
The unique identifier of the usage metric set. It is generated by the SAP CC system. | |||
| RECORD_DATE |
|
The date and time of the recording for the set of usage metric values | ||||
| STATUS |
|
The processing status of the usage metric recording (complete or partial) | ||||
| TRANSAC |
|
The number of transactions generated by the system | ||||
| POSTPAID_TRANSAC |
|
The number of postpaid transactions | ||||
| PREPAID_TRANSAC |
|
The number of prepaid transactions | ||||
| SUBSCRIBER_ACCOUNT |
|
The number of subscriber accounts in master data |
The database schema defines the following columns. Check the definitions, types, available indexes, and formats:
| Definition | The unique identifier of the usage metric set. It is generated by the SAP CC system. |
| Type | DECIMAL(28), NOT NULL |
| Primary Key | PK_METRIC |
| Definition | The date and time of the recording for the set of usage metric values |
| Type | DATETIME, NOT NULL |
| Definition | The processing status of the usage metric recording (complete or partial) |
| Description |
|
| Type | DECIMAL(1), NOT NULL |
| Definition | The number of transactions generated by the system |
| Type | DECIMAL(28), NULL |
| Definition | The number of postpaid transactions |
| Type | DECIMAL(28), NULL |
| Definition | The number of prepaid transactions |
| Type | DECIMAL(28), NULL |
| Definition | The number of subscriber accounts in master data |
| Type | DECIMAL(28), NULL |
See the primary key information:
| Column(s) | OID |
| Filegroup | CATALOG_DATA |
