CIT_AGGR_POLICY

Definition

The CIT_AGGR_POLICY table contains the list of charged items aggregation policies which are defined in the SAP CC system

Technical Data

Schema Version	5.0.6
Partitioned	No

Summary

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

Name	PK	FK	IX	Uses	Used by	Definition
OID	PK_CIT_AGGR_POLICY					The unique identifier of the charged items aggregation policy More...
CODE			IX_CIT_AGGR_POLICY_CODE			The unique code of the charged items aggregation policy
OWNER						The owner of the charged items aggregation policy
DESCRIPTION						A description of the charged items aggregation policy
ITEM_CLASS_CODE						The code of the charged item class associated to the charged items aggregation policy
VERSION_ID						The identifier of the version of the charged items aggregation policy

Column Details

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

OID

Definition	The unique identifier of the charged items aggregation policy
Description	The unique identifier of the charged items aggregation policy. It is generated by the SAP CC system.
Type	DECIMAL(28), NOT NULL
Primary Key	PK_CIT_AGGR_POLICY

CODE

Definition	The unique code of the charged items aggregation policy
Type	NVARCHAR(256), NOT NULL
Available Index	IX_CIT_AGGR_POLICY_CODE

OWNER

Definition	The owner of the charged items aggregation policy
Type	NVARCHAR(64), NOT NULL

DESCRIPTION

Definition	A description of the charged items aggregation policy
Type	NVARCHAR(2000), NULL

ITEM_CLASS_CODE

Definition	The code of the charged item class associated to the charged items aggregation policy
Type	NVARCHAR(256), NULL

VERSION_ID

Definition	The identifier of the version of the charged items aggregation policy
Type	DECIMAL(4), NOT NULL

Primary Key Details

See the primary key information:

PK_CIT_AGGR_POLICY

Column(s)	OID
Segment	CATALOG_INDX

Index Details

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

IX_CIT_AGGR_POLICY_CODE

Indexed Column(s)	CODE
Unique	Yes
Partitioned	No
Clustered	No