COUNTER_DESC

Definition


The COUNTER_DESC table contains the description of the counters used in charge components

Technical Data


Schema Version 5.0.6
Filegroup CATALOG_DATA
Partitioned No

Summary


The COUNTER_DESC 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
INDEX_IN_PLAN        

    The position of the counter in the price plan
    NAME        

      The name of the counter
      DESCRIPTION        

        The description of the counter
        IS_TRANSIENT        

          The IS_TRANSIENT field indicates if the counter is transient or persistent

          More...

          TYPE        

            The TYPE field indicates if the counter is an increment counter

            More...

            INITIAL_VALUE        

              The initial value of the counter
              PLAN_OID     IX_CDES_PLAN  PRICE_PLAN (OID)
               

                The identifier of the price plan that owns this counter

                Column Details

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

                INDEX_IN_PLAN

                Definition The position of the counter in the price plan
                Type DECIMAL(5), NOT NULL

                NAME

                Definition The name of the counter
                Type NVARCHAR(256), NOT NULL

                DESCRIPTION

                Definition The description of the counter
                Type NVARCHAR(256), NULL

                IS_TRANSIENT

                Definition The IS_TRANSIENT field indicates if the counter is transient or persistent
                Format

                The possible values are:

                • 0: persistent
                • 1: transient

                Type DECIMAL(1), NOT NULL

                TYPE

                Definition The TYPE field indicates if the counter is an increment counter
                Format

                The possible values are:

                • 0: decrement distributed counter or persistent counter
                • 1: increment distributed counter

                Type DECIMAL(1), NOT NULL

                INITIAL_VALUE

                Definition The initial value of the counter
                Type DECIMAL(28,6), NOT NULL

                PLAN_OID

                Definition The identifier of the price plan that owns this counter
                Type DECIMAL(28), NOT NULL
                Available Index IX_CDES_PLAN

                Index Details

                The following database indexes are available in the COUNTER_DESC database table to improve the speed of data retrieval operations during the business processes of SAP Convergent Charging:

                IX_CDES_PLAN

                Indexed Column(s) PLAN_OID
                Unique No
                Partitioned No
                Clustered No
                Filegroup CATALOG_INDX