NRCT

Definition

The NRCT table contains the list of conditions associated to the defined reporting condition sets

Technical Data

Schema Version	4.5.13
Filegroup	CATALOG_DATA
Partitioned	No

Summary

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

Name	PK	FK	IX	Uses	Used by
POLICY_OID			IX_NBR_RPT_CDT_POLICY
REPORT_CONDITION_SET_OID	PK_NUMB_RPT_CDT
FIELD_NAME	PK_NUMB_RPT_CDT
TYPE
VALUE

Column Details

POLICY_OID

Definition	The unique identifier of the charged items aggregation policy
Type	DECIMAL(28), NOT NULL
Available Index	IX_NBR_RPT_CDT_POLICY

REPORT_CONDITION_SET_OID

Definition	The unique identifier of the reporting condition set
Type	DECIMAL(28), NOT NULL
Primary Key	PK_NUMB_RPT_CDT

FIELD_NAME

Definition	The name of the field concerned by the charged items aggregation rule
Type	NVARCHAR(256), NOT NULL
Primary Key	PK_NUMB_RPT_CDT

TYPE

Definition	The type of condition
Format	The possible values are: 1: GreaterThan
Type	DECIMAL(4), NOT NULL

VALUE

Definition	The value of the condition
Type	DECIMAL(28,6), NULL

Primary Key Details

PK_NUMB_RPT_CDT

Column(s)	REPORT_CONDITION_SET_OID,FIELD_NAME
Filegroup	CATALOG_DATA

Index Details

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

IX_NBR_RPT_CDT_POLICY

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