OCON_PARAMETER

Description


Technical Data


Schema Version 4.5.13
Filegroup CATALOG_DATA
Partitioned No

Summary


The OCON_PARAMETER table is defined by the following columns. See the column details for more information.

Name PK FK IX Uses Used by
INDEX_IN_OCON          
NAME          
DESCRIPTION          
PARAMETER_NAME          
VALUE_TYPE          
IS_PRIVATE          
NUMBER_VALUE          
STRING_VALUE          
DATE_VALUE          
OCON_OID     IX_OCPA_OCON  OFFER_CONDITION (OID)
 
 
VALIDATION_DATE          

Column Details


INDEX_IN_OCON

Definition The index of the parameter in the offer condition
Type DECIMAL(5), NOT NULL

NAME

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

DESCRIPTION

Definition The description of the parameter
Type NVARCHAR(2000), NULL

PARAMETER_NAME

Definition The parameter in the offer condition can be linked to a parameter with the same type defined in the offer containing the offer condition
Description The parameter in the offer condition can be linked to a parameter with the same type defined in the offer containing the offer condition. The PARAMETER_NAME field gives the name of the parameter defined in the offer
Type NVARCHAR(256), NULL

VALUE_TYPE

Definition The type of the parameter
Format

The possible values are:

  • 0: number
  • 1: string
  • 2: date

Type DECIMAL(1), NOT NULL

IS_PRIVATE

Definition The IS_PRIVATE field gives the visibility of the parameter
Format

The possible values are:

  • 0: The parameter can be modified in a subscription.
  • 1: The parameter can be modified in an offer.

Type DECIMAL(1), NOT NULL

NUMBER_VALUE

Definition The value of the parameter when it is a number
Type DECIMAL(28,6), NULL

STRING_VALUE

Definition The value of the parameter when it is a string
Type NVARCHAR(2000), NULL

DATE_VALUE

Definition The value of the parameter when it is a date
Type DATETIME, NULL

OCON_OID

Definition The identifier of the offer condition owning the parameter
Type DECIMAL(28), NOT NULL
Available Index IX_OCPA_OCON

VALIDATION_DATE

Definition The date when the parameter becomes valid
Type DATETIME, NULL

Index Details


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

IX_OCPA_OCON

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