ACCESS_ACTI_CHRONOLOGY

Definition

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

Technical Data

Schema Version	4.5.13
Partitioned	No

Summary

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

Name	PK	FK	IX	Uses	Used by
ACTI_OID			IX_ACCESS_ACTIVATION
ACCE_OID			IX_ACCESS_OWNER	ACCESS_TABLE (OID)
ACCE_PARTITION_ID			IX_ACCESS_OWNER	ACCESS_TABLE (PARTITION_ID)
START_DATE
ACCE_TYPE
SUBS_OID			IX_ACTI_CHRO_SUBS	SUBSCRIPTION (OID)
CACO_OID			IX_ACTI_CHRO_CACO
PARTITION_ID
BGRP_OID
SUAC_OID

Column Details

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	SECONDDATE, 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

IX_ACCESS_ACTIVATION

Indexed Column(s)	ACTI_OID
Unique	No
Partitioned	No

IX_ACTI_CHRO_SUBS

Indexed Column(s)	SUBS_OID
Unique	No
Partitioned	No

IX_ACTI_CHRO_CACO

Indexed Column(s)	CACO_OID
Unique	No
Partitioned	No