PARAMETER
Definition
The PARAMETER table contains information about the parameters defined in price plans
Technical Data
Summary
The PARAMETER table is defined by the
following columns.
See the column details for more information.
Column Details
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 |
NVARCHAR(256), NOT NULL |
DESCRIPTION
| Definition |
The description of the parameter |
| Type |
NVARCHAR(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 |
NVARCHAR(2000), NULL |
DATE_VALUE
| Definition |
The value of the parameter when it is a date |
| Type |
DATETIME, 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 |
| Clustered |
No |
| Filegroup |
CATALOG_INDX |
