SUBSCRIPTION

Subscriptions (in Customer Master Data)

Definition

The SUBSCRIPTION table stored the subscription details including subscriptions

Technical Data

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

Summary

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

Name	PK	IX	Uses	Used by
OID	PK_SUBSCRIPTION	IX_SUB_SUBID		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)
CODE		IX_SUBS_SUAC_G IX_SUB_CODE
SUAC_OID		IX_SUBS_SUAC IX_SUBS_SUAC_G	SUAC (OID) SUAC (OID)
EFFECTIVE_DATE
NEXT_ACTIVATION_DATE
EXPIRATION_DATE
PRICE_FREEZE_EFFECTIVE_DATE
PRICE_FREEZE_EXPIRATION_DATE
COMMITMENT_EXPIRATION_DATE
SUSPENSION_DATE
RESUMPTION_DATE
CANCELLATION_DATE
OFFE_OID		IX_SUB_OFFE
OFFER_CODE		IX_SUBS_OCOD
OFFER_CONDITION_CODE
ROOT_SUBS_OID		IX_S_ROOT_SUBS_OID
PARENT_SUBS_OID		IX_SUB_SUBID IX_SUBS_SUAC_G	SUBSCRIPTION (OID)
PARTITION_ID		IX_SUBS_PART_ID
STATUS
TYPE
BGRP_OID			BATCH_RATING_GROUP_DESCRIPTION (BGRP_OID)
RERATING_LOCK_CODE
RERATING_LAST_CODE
RERATING_LAST_STATUS
RERATING_SUGGESTED_DATE
OVERRIDE_DEPENDENCIES

Column Details

OID

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

CODE

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

SUAC_OID

Definition	The identifier of the 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	DATE, NULL

NEXT_ACTIVATION_DATE

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

EXPIRATION_DATE

Definition	The expiration date of the subscription
Type	DATE, NULL

PRICE_FREEZE_EFFECTIVE_DATE

Definition	The date of a price freeze
Type	DATE, NULL

PRICE_FREEZE_EXPIRATION_DATE

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

COMMITMENT_EXPIRATION_DATE

Definition	The expiration of a commitment
Type	DATE, NULL

SUSPENSION_DATE

Definition	The date the subscription was suspended
Type	DATE, NULL

RESUMPTION_DATE

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

CANCELLATION_DATE

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

OFFE_OID

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

OFFER_CODE

Definition	The code of the offer for the subscription
Type	VARCHAR2(256 CHAR), NULL
Available Index	IX_SUBS_OCOD

OFFER_CONDITION_CODE

Definition	The code of the offer condition for the subscription
Type	VARCHAR2(256 CHAR), NULL

ROOT_SUBS_OID

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

PARENT_SUBS_OID

Definition	The ID 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 owning the subscription
Type	DECIMAL(4), NOT NULL
Available Index	IX_SUBS_PART_ID

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	VARCHAR2(64 CHAR), 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	VARCHAR2(64 CHAR), 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	DATE, NULL

OVERRIDE_DEPENDENCIES

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

Primary Key Details

PK_SUBSCRIPTION

Column(s)	OID
Tablespace	SUBSCRIBER_INDX

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
Tablespace	SUBSCRIBER_INDX

IX_SUB_SUBID

Indexed Column(s)	PARENT_SUBS_OID, OID
Unique	No
Partitioned	No
Tablespace	SUBSCRIBER_INDX

IX_S_ROOT_SUBS_OID

Indexed Column(s)	ROOT_SUBS_OID
Unique	No
Partitioned	Yes
Tablespace	SUBSCRIBER_INDX

IX_SUBS_OCOD

Indexed Column(s)	OFFER_CODE
Unique	No
Partitioned	No
Tablespace	SUBSCRIBER_INDX

IX_SUBS_SUAC

Indexed Column(s)	SUAC_OID
Unique	No
Partitioned	Yes
Tablespace	SUBSCRIBER_INDX

IX_SUBS_SUAC_G

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

IX_SUB_CODE

Indexed Column(s)	CODE
Unique	Yes
Partitioned	No
Tablespace	SUBSCRIBER_INDX

IX_SUBS_PART_ID

Indexed Column(s)	PARTITION_ID
Unique	No
Partitioned	No
Tablespace	SUBSCRIBER_INDX