METRIC_RECORD

Product Usage Metric Recordings (in Technical Data)

Definition


The METRIC table contains information about the usage metrics (of SAP Convergent Charging APIs) to audit the SAP product usage

Description


The METRIC table contains product usage information recorded as usage metrics collected and consolidated by the updater instance in the SAP CC Core Server system.

This information is available in GLAS files.

Technical Data


Schema Version 4.6.2
Filegroup CATALOG_DATA
Partitioned No

Summary


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 metric unique identifier. It is generated by the SAP CC system.
    RECORD_DATE        

      The date of the metric snapshot in the SAP CC user
      STATUS        

        The status of the metric
        TRANSAC        

          The number of transactions
          POSTPAID_TRANSAC        

            The number of postpaid transactions
            PREPAID_TRANSAC        

              The number of prepaid transactions
              SUBSCRIBER_ACCOUNT        

                The number of subscriber accounts

                Column Details

                The database schema defines the following columns. Check the definitions, types, available indexes, and formats:

                OID

                Definition The metric unique identifier. It is generated by the SAP CC system.
                Type DECIMAL(28), NOT NULL
                Primary Key PK_METRIC

                RECORD_DATE

                Definition The date of the metric snapshot in the SAP CC user
                Type DATETIME, NOT NULL

                STATUS

                Definition The status of the metric
                Type DECIMAL(1), NOT NULL

                TRANSAC

                Definition The number of transactions
                Type DECIMAL(28), NULL

                POSTPAID_TRANSAC

                Definition The number of postpaid transactions
                Type DECIMAL(28), NULL

                PREPAID_TRANSAC

                Definition The number of prepaid transactions
                Type DECIMAL(28), NULL

                SUBSCRIBER_ACCOUNT

                Definition The number of subscriber accounts
                Type DECIMAL(28), NULL

                Primary Key Details

                See the primary key information:

                PK_METRIC

                Column(s) OID
                Filegroup CATALOG_DATA