CCON_TIER_TABLE_INSTANCE

Definition

The CCON_TIER_TABLE_INSTANCE table contains information about tier table instances in charge conditions

Technical Data

Schema Version	4.5.13
Filegroup	CATALOG_DATA
Partitioned	No

Summary

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

Name	PK	FK	IX	Uses	Used by
OID	PK_CCTIERTI				CCON_TIER_TABLE_ROW (TINS_OID)
TTAB_CODE
CCON_OID			IX_CCTIERTI_CCON_OID	CHARGE_CONDITION (OID)
NAME
INSTANCE_NAME
VALIDATION_DATE

Column Details

OID

Definition	The identifier of the tier table instance
Type	DECIMAL(28), NOT NULL
Primary Key	PK_CCTIERTI

TTAB_CODE

Definition	The code of the tier table owning the instance
Type	NVARCHAR(256), NULL

CCON_OID

Definition	The identifier of the charge condition
Type	DECIMAL(28), NULL
Available Index	IX_CCTIERTI_CCON_OID

NAME

Definition	The name of the instance
Type	NVARCHAR(256), NULL

INSTANCE_NAME

Definition	The name of the instance, which is enriched
Type	NVARCHAR(256), NULL

VALIDATION_DATE

Definition	The date when the instance becomes valid
Type	DATETIME, NULL

Primary Key Details

PK_CCTIERTI

Column(s)	OID
Filegroup	CATALOG_DATA

Index Details

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

IX_CCTIERTI_CCON_OID

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