RATE_PLAN_PARAMETER

Rate Plan Parameter

Definition

The RATE_PLAN_PARAMETER table contains the parameter definitions of the rate plans

Technical Data

Schema Version	2022.0.2
Filegroup	COCKPIT_DATA
Partitioned	No

Summary

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

Name	PK	IX	Uses	Definition
OID	PK_RATE_PLAN_PARAMETER			The unique identifier of the rate plan parameter. It is generated by the SAP CC Cockpit application.
NAME				The name of the parameter used by the rate plan
DATE_VALUE				The date value of the parameter when the parameter is type of date
DESCRIPTION				The description of the parameter used by the rate plan
IS_MANDATORY				Indicates whether the rate plan parameter is mandatory or not More...
IN_ERROR_STATE				Indicates whether the rate plan parameter is in error or not More...
NUMBER_VALUE				The number value of the parameter when the parameter is type of number
RATEPLAN_OID			RATE_PLAN (OID)	The unique identifier of the rate plan owning the Rate Plan. It is generated by the SAP CC Cockpit application.
RELEASED_OID		IX_RATE_PLAN_PARAMETER_RELEASED_OID		The unique identifier of the released rate plan parameter when its being modified
STATE		IX_RATE_PLAN_PARAMETER_STATE		The state of the rate plan parameter More...
STRING_VALUE				The string value of the parameter when the parameter is type of string
TYPE				The type of the parameter More...
SUB_TYPE				The subtype of the parameter More...
SUB_TYPE_INFO				The subtype info of the parameter, used to store mandatory data for some subtypes
READ_ONLY				This flag indicates if the parameter can be modified More...
SYSTEM_DEFINED				This flag indicates if the parameter is defined by system More...

Column Details

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

OID

Definition	The unique identifier of the rate plan parameter. It is generated by the SAP CC Cockpit application.
Type	DECIMAL(28), NOT NULL
Primary Key	PK_RATE_PLAN_PARAMETER

NAME

Definition	The name of the parameter used by the rate plan
Type	NVARCHAR(256), NULL

DATE_VALUE

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

DESCRIPTION

Definition	The description of the parameter used by the rate plan
Type	NVARCHAR(2000), NULL

IS_MANDATORY

Definition Indicates whether the rate plan parameter is mandatory or not

Format

The possible values are:

0: Optional
1: Mandatory, must be redefined at provider contract item level

Type BIT, NULL

IN_ERROR_STATE

Definition Indicates whether the rate plan parameter is in error or not

Format

The possible values are:

0: No errors
1: One or more errors

Type BIT, NULL

NUMBER_VALUE

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

RATEPLAN_OID

Definition	The unique identifier of the rate plan owning the Rate Plan. It is generated by the SAP CC Cockpit application.
Type	DECIMAL(28), NOT NULL

RELEASED_OID

Definition	The unique identifier of the released rate plan parameter when its being modified
Type	DECIMAL(28), NULL
Available Index	IX_RATE_PLAN_PARAMETER_RELEASED_OID

STATE

Definition	The state of the rate plan parameter
Format	The possible values are: `0`: CREATED `1`: MODIFIED `2`: RELEASED
Type	DECIMAL(3), NULL
Available Index	IX_RATE_PLAN_PARAMETER_STATE

STRING_VALUE

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

TYPE

Definition The type of the parameter

Format

The possible values are:

0: The parameter type is number
1: The parameter type is string
2: The parameter type is date

Type DECIMAL(10), NULL

SUB_TYPE

Definition The subtype of the parameter

Format

The possible values are:

0: The parameter subtype is mapping table unique identifier
1: The parameter subtype is range table unique identifier
2: The parameter subtype is mapping table key
3: The parameter subtype is currency

Type DECIMAL(10), NULL

SUB_TYPE_INFO

Definition	The subtype info of the parameter, used to store mandatory data for some subtypes
Type	NVARCHAR(256), NULL

READ_ONLY

Definition This flag indicates if the parameter can be modified

Format

The possible values are:

true: The parameter cannot be modified
false: The parameter can be modified

Type BIT, NULL

SYSTEM_DEFINED

Definition This flag indicates if the parameter is defined by system

Format

The possible values are:

true: The parameter is defined by the system
false: The parameter is not defined by the system

Type BIT, NULL

Primary Key Details

See the primary key information:

PK_RATE_PLAN_PARAMETER

Column(s)	OID
Filegroup	COCKPIT_DATA

Index Details

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

IX_RATE_PLAN_PARAMETER_RELEASED_OID

Indexed Column(s)	RELEASED_OID
Unique	No
Partitioned	No
Clustered	No
Filegroup	COCKPIT_INDX

IX_RATE_PLAN_PARAMETER_STATE

Indexed Column(s)	STATE
Unique	No
Partitioned	No
Clustered	No
Filegroup	COCKPIT_INDX