PARAMETER

Definition

The PARAMETER table contains information about the parameters defined in price plans

Technical Data

Schema Version	5.0.6
Tablespace	CATALOG_DATA
Partitioned	No

Summary

The PARAMETER table is defined by the following columns in your back-end database. See the column details for more information.

Name	IX	Uses	Definition
INDEX_IN_PLAN			The position of the parameter in the price plan
NAME			The name of the parameter
DESCRIPTION			The description of the parameter
VALUE_TYPE			The type of the parameter More...
IS_PRIVATE			The IS_PRIVATE field gives the visibility of the parameter More...
NUMBER_VALUE			The value of the parameter when it is a number
STRING_VALUE			The value of the parameter when it is a string
DATE_VALUE			The value of the parameter when it is a date
PLAN_OID	IX_PP_PARAMETER	PRICE_PLAN (OID)	The ID of the price plan that owns this parameter
NB_ADDITIONAL_INFO			The number of additional info for this parameter

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 parameter in the price plan
Type	DECIMAL(5), NOT NULL

NAME

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

DESCRIPTION

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

VALUE_TYPE

Definition The type of the parameter

Format

The possible values are:

0: number
1: string
2: date

Type DECIMAL(2), NOT NULL

IS_PRIVATE

Definition The IS_PRIVATE field gives the visibility of the parameter

Format

The possible values are:

0: External - The parameter can be modified outside the price plan, in an offer or a subscription for example.
1: Internal - The parameter cannot be modified outside the price plan.

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	VARCHAR(2000), NULL

DATE_VALUE

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

PLAN_OID

Definition	The ID of the price plan that owns this parameter
Type	DECIMAL(28), NOT NULL
Available Index	IX_PP_PARAMETER

NB_ADDITIONAL_INFO

Definition	The number of additional info for this parameter
Type	DECIMAL(3), NOT NULL

Index Details

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

IX_PP_PARAMETER

Indexed Column(s)	PLAN_OID
Unique	No
Partitioned	No
Tablespace	CATALOG_INDX