NRCT

Definition


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

Technical Data


Schema Version 4.5.13
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
Tablespace CATALOG_INDX

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