RATE_PLAN_PARAMETER

Rate Plan Parameter

Definition

The RATE_PLAN_PARAMETER table contains the parameter definitions of the rate plans

Technical Data

Schema Version	2023.0.3
Segment	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
VALUE_CONSTRAINT				Indicates whether the rate plan parameter is mandatory, mandatory unmodifiable or optional 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 is 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
SYSTEM_TYPE				The system-reserved type of the parameter 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

VALUE_CONSTRAINT

Definition Indicates whether the rate plan parameter is mandatory, mandatory unmodifiable or optional

Format

The possible values are:

0: Mandatory, must be defined at provider contract item level
1: Mandatory unmodifiable, must be defined at provider contract item level, cannot be modified after status is Released
2: Optional

Type DECIMAL(3), 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 NUMERIC(1,0), 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 is 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

SYSTEM_TYPE

Definition The system-reserved type of the parameter

Format

The possible values are:

0: The parameter system-reserved type is SAP_BILL_CYCLE_DATE
1: The parameter system-reserved type is CURRENCY

Type DECIMAL(10), NULL

Primary Key Details

See the primary key information:

PK_RATE_PLAN_PARAMETER

Column(s)	OID
Segment	COCKPIT_INDX

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
Segment	COCKPIT_INDX

IX_RATE_PLAN_PARAMETER_STATE

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