ACCESS_ACTI_CHRONOLOGY

Definition

The ACCESS_ACTI_CHRONOLOGY table contains the chronology of access for a charge activation

Technical Data

Schema Version	5.0.6
Partitioned	Yes, when you use the partitioning scheme and corresponding SQL scripts

Summary

The ACCESS_ACTI_CHRONOLOGY 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
ACTI_OID			IX_ACCESS_ACTIVATION			The OID of the charge activation
ACCE_OID			IX_ACCESS_OWNER	ACCESS_TABLE (OID)		The OID of the access
ACCE_PARTITION_ID			IX_ACCESS_OWNER	ACCESS_TABLE (PARTITION_ID)		The partition of the access
START_DATE						The start date for the chronology
ACCE_TYPE						The type of the target More...
SUBS_OID			IX_ACTI_CHRO_SUBS	SUBSCRIPTION (OID)		The identifier of the subscription, which contains the charge activation
CACO_OID			IX_ACTI_CHRO_CACO			The identifier of the charging contract which contains the charge activation
PARTITION_ID						The partition of the subscriber account containing the charge activation
BGRP_OID						The ID of the batch rating group
SUAC_OID						The unique identifier of the subscriber account related to the subscription or charging contract

Column Details

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

ACTI_OID

Definition	The OID of the charge activation
Type	DECIMAL(28), NULL
Available Index	IX_ACCESS_ACTIVATION

ACCE_OID

Definition	The OID of the access
Type	DECIMAL(28), NOT NULL
Available Index	IX_ACCESS_OWNER

ACCE_PARTITION_ID

Definition	The partition of the access
Type	DECIMAL(4), NULL
Available Index	IX_ACCESS_OWNER

START_DATE

Definition	The start date for the chronology
Type	DATETIME, NULL

ACCE_TYPE

Definition	The type of the target
Format	The possible values are: 0: Subscription 1: Charging Contract
Type	DECIMAL(1), NULL

SUBS_OID

Definition	The identifier of the subscription, which contains the charge activation
Type	DECIMAL(28), NULL
Available Index	IX_ACTI_CHRO_SUBS

CACO_OID

Definition	The identifier of the charging contract which contains the charge activation
Type	DECIMAL(28), NULL
Available Index	IX_ACTI_CHRO_CACO

PARTITION_ID

Definition	The partition of the subscriber account containing the charge activation
Type	DECIMAL(4), NULL

BGRP_OID

Definition	The ID of the batch rating group
Type	DECIMAL(2), NOT NULL

SUAC_OID

Definition	The unique identifier of the subscriber account related to the subscription or charging contract
Type	DECIMAL(28), NULL

Index Details

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

IX_ACCESS_OWNER

Indexed Column(s)	ACCE_PARTITION_ID,ACCE_OID
Unique	No
Partitioned	No
Clustered	No

IX_ACCESS_ACTIVATION

Indexed Column(s)	ACTI_OID
Unique	No
Partitioned	No
Clustered	No

IX_ACTI_CHRO_SUBS

Indexed Column(s)	SUBS_OID
Unique	No
Partitioned	No
Clustered	No

IX_ACTI_CHRO_CACO

Indexed Column(s)	CACO_OID
Unique	No
Partitioned	No
Clustered	No