SUBSCRIPTION

Subscriptions (in Customer Master Data)

Definition

The SUBSCRIPTION table stored the subscription details including subscriptions

Technical Data

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

Summary

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

Name	PK	IX	Uses	Used by	Definition
OID	PK_SUBSCRIPTION			SUBS_TRANSLATION_INSTANCE (SUBS_OID) SUBS_TIER_TABLE_INSTANCE (SUBS_OID) SUBS_PARAMETER (SUBS_OID) SUBSCRIPTION (PARENT_SUBS_OID) SUBS_ADDITIONAL_INFO (SUBS_OID) COUNTER_SNAPSHOT (SNAPSHOT_SUB_OID) CHARGE_ACTIVATION (SUBS_OID) ACTI_DEPENDENT (DEP_SUBS_OID) ACCESS_ACTI_CHRONOLOGY (SUBS_OID)	The subscription unique identifier
CODE		IX_SUBS_SUAC_G IX_SUB_CODE			The identification code (or codename) of the subscription
SUAC_OID		IX_SUBS_SUAC IX_SUBS_SUAC_G	SUAC (OID)		The unique object ID (OID) of the assigned subscriber account
EFFECTIVE_DATE					The effective date of the subscription
NEXT_ACTIVATION_DATE					The date of the next activation for the subscription
EXPIRATION_DATE					The expiration date of the subscription
PRICE_FREEZE_EFFECTIVE_DATE					The date of a price freeze
PRICE_FREEZE_EXPIRATION_DATE					The expiration date of a price freeze
COMMITMENT_EXPIRATION_DATE					The expiration of a commitment
SUSPENSION_DATE					The date the subscription was suspended
RESUMPTION_DATE					The date since the subscription is not suspended any more
CANCELLATION_DATE					The date since the subscription is canceled
OFFE_OID		IX_SUB_OFFE			The unique object ID (OID) of the offer for the subscription
OFFER_CODE		IX_SUBS_OCOD	OFFER (CODE)		The identification code (or codename) of the offer for the subscription
OFFER_CONDITION_CODE			OFFER_CONDITION (SUB_CODE)		The identification code (or codename) of the offer condition for the subscription
ROOT_SUBS_OID		IX_S_ROOT_SUBS_OID			The unique object ID (OID) of the root subscription
PARENT_SUBS_OID		IX_SUB_SUBID IX_SUBS_SUAC_G	SUBSCRIPTION (OID)		The unique object ID (OID) of the direct parent subscription
PARTITION_ID		IX_S_ROOT_SUBS_OID			The partition of the subscriber account assigned to the subscription
STATUS					The status of the subscription More...
TYPE					The type of the subscription More...
BGRP_OID			BATCH_RATING_GROUP_DESCRIPTION (BGRP_OID)		The batch rating group ID that this subscription has registered
RERATING_LOCK_CODE					The identification code of the rerating operation that locks this subscription More...
RERATING_LAST_CODE					The code of the last rerating operation called on the subscription More...
RERATING_LAST_STATUS					The RERATING_LAST_STATUS field gives the last rerating status of the subscription More...
RERATING_SUGGESTED_DATE					The rerating date suggested by the external invoicing or billing system
OVERRIDE_DEPENDENCIES					Defines whether the subscription overrides the offer level dependencies

Column Details

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

OID

Definition	The subscription unique identifier
Type	DECIMAL(28), NOT NULL
Primary Key	PK_SUBSCRIPTION

CODE

Definition	The identification code (or codename) of the subscription
Type	NVARCHAR(256), NULL
Available Index	IX_SUBS_SUAC_G
Available Index	IX_SUB_CODE

SUAC_OID

Definition	The unique object ID (OID) of the assigned subscriber account
Type	DECIMAL(28), NULL
Available Index	IX_SUBS_SUAC
Available Index	IX_SUBS_SUAC_G

EFFECTIVE_DATE

Definition	The effective date of the subscription
Type	DATETIME, NULL

NEXT_ACTIVATION_DATE

Definition	The date of the next activation for the subscription
Type	DATETIME, NULL

EXPIRATION_DATE

Definition	The expiration date of the subscription
Type	DATETIME, NULL

PRICE_FREEZE_EFFECTIVE_DATE

Definition	The date of a price freeze
Type	DATETIME, NULL

PRICE_FREEZE_EXPIRATION_DATE

Definition	The expiration date of a price freeze
Type	DATETIME, NULL

COMMITMENT_EXPIRATION_DATE

Definition	The expiration of a commitment
Type	DATETIME, NULL

SUSPENSION_DATE

Definition	The date the subscription was suspended
Type	DATETIME, NULL

RESUMPTION_DATE

Definition	The date since the subscription is not suspended any more
Type	DATETIME, NULL

CANCELLATION_DATE

Definition	The date since the subscription is canceled
Type	DATETIME, NULL

OFFE_OID

Definition	The unique object ID (OID) of the offer for the subscription
Type	DECIMAL(28), NULL
Available Index	IX_SUB_OFFE

OFFER_CODE

Definition	The identification code (or codename) of the offer for the subscription
Type	NVARCHAR(256), NULL
Available Index	IX_SUBS_OCOD

OFFER_CONDITION_CODE

Definition	The identification code (or codename) of the offer condition for the subscription
Type	NVARCHAR(256), NULL

ROOT_SUBS_OID

Definition	The unique object ID (OID) of the root subscription
Type	DECIMAL(28), NULL
Available Index	IX_S_ROOT_SUBS_OID

PARENT_SUBS_OID

Definition	The unique object ID (OID) of the direct parent subscription
Type	DECIMAL(28), NULL
Available Index	IX_SUB_SUBID
Available Index	IX_SUBS_SUAC_G

PARTITION_ID

Definition	The partition of the subscriber account assigned to the subscription
Type	DECIMAL(4), NOT NULL
Available Index	IX_S_ROOT_SUBS_OID

STATUS

Definition	The status of the subscription
Format	The possible values are: `0`: Active `1`: Locked `2`: Closed
Type	DECIMAL(1), NOT NULL
Default	0

TYPE

Definition The type of the subscription

Format

The possible values are:

-1: (UNSET): The type of the subscription is not set (used for sub-subscriptions).
0: (OFFLINE): The subscription is only charged offline (batch). The subscription generates snapshots, which are backups of its counter values for rerating purpose. It belongs to one and only one batch rating group.
1: (HYBRID): The subscription is charged both online and offline, depending for example on the service that is consumed. It belongs to a batch rating group but, contrary to an offline subscription, it is not compatible with rerating but is designed to be charged in real-time.
2: (ONLINE): The subscription is only charged online (real-time). It is not compatible with rerating.

Type DECIMAL(2), NULL

BGRP_OID

Definition	The batch rating group ID that this subscription has registered
Type	DECIMAL(2), NULL

RERATING_LOCK_CODE

Definition	The identification code of the rerating operation that locks this subscription
Description	The identification code of the rerating operation that locks this subscription. If available, the subscription is currently rerated by the process that owns this code.
Type	NVARCHAR(64), NULL

RERATING_LAST_CODE

Definition	The code of the last rerating operation called on the subscription
Description	The code of the last rerating operation called on the subscription. This code is available only if subscription type is offline.
Type	NVARCHAR(64), NULL

RERATING_LAST_STATUS

Definition	The RERATING_LAST_STATUS field gives the last rerating status of the subscription
Description	The RERATING_LAST_STATUS field gives the last rerating status of the subscription to detect if the rerating operation failed. Its value is a positive in case of success, a negative one in case of failure.
Format	The possible values are: `-9`: (PREPAID_ACCOUNT_FAILURE): The rerating process has failed due to a contract with a prepaid account. `-8`: (EXPORT_AND_UNLOCK_FAILURE): The rerating operation failed due to a subscription exportation and a subscription unlock issue. `-7`: (UNLOCK_FAILURE): The rerating operation failed due to a subscription unlock issue. `-6`: (EXPORT_FAILURE): The rerating operation failed due to a subscription exportation issue. `-5`: (BART_RESTORATION_FAILURE): The restoration process failed for the last rerating operation because BART has denied rerating for this operation. `-4`: (BILLING_FAILURE): The rerating operation failed due to a billing issue. `-3`: (COUNTER_RESTORATION_FAILURE): The counter restoration process failed. `-2`: (NOT_LOCKED_FAILURE): The rerating operation failed because the subscription was not locked but should have been. `-1`: (ALREADY_LOCKED_FAILURE): The rerating operation failed because the subscription was locked by a concurrent rating process or another previous rerating operation. `0`: (UNSET) `1`: (SELECTION_SUCCESS): The restoration process was successful for the last rerating operation. `2`: (RESTORATION_SUCCESS) `3`: (RERATING_SUCCESS): The rerating process was successful.
Type	DECIMAL(1), NULL

RERATING_SUGGESTED_DATE

Definition	The rerating date suggested by the external invoicing or billing system
Type	DATETIME, NULL

OVERRIDE_DEPENDENCIES

Definition	Defines whether the subscription overrides the offer level dependencies
Type	DECIMAL(1), NOT NULL

Primary Key Details

See the primary key information:

PK_SUBSCRIPTION

Column(s)	PARTITION_ID,OID
Filegroup	SUBSCRIBER_DATA

Index Details

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

IX_SUB_OFFE

Indexed Column(s)	OFFE_OID
Unique	No
Partitioned	No
Clustered	No
Filegroup	SUBSCRIBER_INDX

IX_SUB_SUBID

Indexed Column(s)	PARENT_SUBS_OID
Unique	No
Partitioned	Yes
Clustered	No
Filegroup	SUBSCRIBER_INDX

IX_S_ROOT_SUBS_OID

Indexed Column(s)	ROOT_SUBS_OID, PARTITION_ID
Unique	No
Partitioned	No
Clustered	No
Filegroup	SUBSCRIBER_INDX

IX_SUBS_OCOD

Indexed Column(s)	OFFER_CODE
Unique	No
Partitioned	No
Clustered	No
Filegroup	SUBSCRIBER_INDX

IX_SUBS_SUAC

Indexed Column(s)	SUAC_OID
Unique	No
Partitioned	Yes
Clustered	No
Filegroup	SUBSCRIBER_INDX

IX_SUBS_SUAC_G

Indexed Column(s)	SUAC_OID, PARENT_SUBS_OID, CODE
Unique	No
Partitioned	No
Clustered	No
Filegroup	SUBSCRIBER_INDX

IX_SUB_CODE

Indexed Column(s)	CODE
Unique	No
Partitioned	No
Clustered	No
Filegroup	SUBSCRIBER_INDX