Overview | Core Database Schema | All Tables All Columns

Table: SUBSCRIPTION

Table Name SUBSCRIPTION
Table Description The SUBSCRIPTION table describes the subscription details.
Tablespace SUBSCRIBER_DATA
Database Core Database
Partitioned Yes
Columns
OID
CODE
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
OFFER_CODE
OFFER_CONDITION_CODE
ROOT_SUBS_OID
PARENT_SUBS_OID
PARTITION_ID
STATUS
TYPE
BGRP_OID
RERATING_LOCK_CODE
RERATING_LAST_CODE
RERATING_LAST_STATUS
RERATING_SUGGESTED_DATE
OVERRIDE_DEPENDENCIES

Columns of the Table

The SUBSCRIPTION database table is defined by the following columns.

Column: OID

Value Type BIGINT, NOT NULL
Key(s) Primary Key: PK_SUBSCRIPTION

Foreign K.:

  • Foreign table: SUBSCRIPTION
  • Foreign field(s): OID
Index(es) IX_SUB_OFFE
IX_SUB_SUBID (unique) (oracle)
IX_SUB_SUBID (unique) (oracle)
IX_SUB_SUBID (unique) (sqlserver)
IX_SUBS_SUAC
IX_SUBS_SUAC_G
IX_S_ROOT_SUBS_OID (unique) (oracle)
IX_S_ROOT_SUBS_OID (unique) (sqlserver)
Column Description The subscription unique identifier.


Column: CODE

Value Type VARCHAR(256)
Index(es) IX_SUBS_OCOD
IX_SUBS_SUAC_G
IX_SUB_CODE (unique) (oracle)
IX_SUB_CODE (unique) (sqlserver)
Column Description The code of the subscription.


Column: SUAC_OID

Value Type BIGINT
Index(es) IX_SUBS_SUAC
IX_SUBS_SUAC_G
Column Description The identifier of the subscriber account.


Column: EFFECTIVE_DATE

Value Type DATE
Column Description The effective date of the subscription.


Column: NEXT_ACTIVATION_DATE

Value Type DATE
Column Description The date of the next activation for the subscription.


Column: EXPIRATION_DATE

Value Type DATE
Column Description The expiration date of the subscription.


Column: PRICE_FREEZE_EFFECTIVE_DATE

Value Type DATE
Column Description The date of a price freeze.


Column: PRICE_FREEZE_EXPIRATION_DATE

Value Type DATE
Column Description The expiration date of a price freeze.


Column: COMMITMENT_EXPIRATION_DATE

Value Type DATE
Column Description The expiration of a commitment.


Column: SUSPENSION_DATE

Value Type DATE
Column Description The date the subscription was suspended.


Column: RESUMPTION_DATE

Value Type DATE
Column Description The date since the subscription is not suspended any more.


Column: CANCELLATION_DATE

Value Type DATE
Column Description The date since the subscription is cancelled.


Column: OFFE_OID

Value Type BIGINT
Index(es) IX_SUB_OFFE
Column Description The ID of the offer for the subscription.


Column: OFFER_CODE

Value Type VARCHAR(256)
Index(es) IX_SUBS_OCOD
Column Description The code of the offer for the subscription.


Column: OFFER_CONDITION_CODE

Value Type VARCHAR(256)
Column Description The code of the offer condition for the subscription.


Column: ROOT_SUBS_OID

Value Type BIGINT
Index(es) IX_S_ROOT_SUBS_OID (unique) (oracle)
IX_S_ROOT_SUBS_OID (unique) (sqlserver)
Column Description The ID of the root subscription.


Column: PARENT_SUBS_OID

Value Type BIGINT
Key(s) -

Foreign K.:

  • Foreign table: SUBSCRIPTION
  • Foreign field(s): OID
Index(es) IX_SUB_SUBID (unique) (oracle)
IX_SUB_SUBID (unique) (oracle)
IX_SUB_SUBID (unique) (sqlserver)
IX_SUBS_SUAC_G
Column Description The ID of the direct parent subscription.


Column: PARTITION_ID

Value Type SMALLINT, NOT NULL
Index(es) IX_S_ROOT_SUBS_OID (unique) (sqlserver)
Column Description The partition of the subscriber account owning the subscription.


Column: STATUS

Value Type DECIMAL(1), NOT NULL
Default Value 0
Column Description

The status of the subscription.

Possible values are:

  • 0: active
  • 1: locked
  • 2: closed


Column: TYPE

Value Type DECIMAL(2)
Column Description

The type of the subscription.

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 realtime.
  • 2: online. The subscription is only charged online (realtime). It is not compatible with rerating.


Column: BGRP_OID

Value Type DECIMAL(2)
Column Description The batch rating group ID that this subscription has registered .


Column: RERATING_LOCK_CODE

Value Type VARCHAR(64)
Column Description The code of the rerating operation that locks this subscription. If available, the subscription is currently rerated by the process that owns this code.


Column: RERATING_LAST_CODE

Value Type VARCHAR(64)
Column Description The code of the last rerating operation called on the subscription. This code is available only if subscription type is offline.


Column: RERATING_LAST_STATUS

Value Type DECIMAL(1)
Column Description

The RERATING_LAST_STATUS field gives the last rerating status of the subscription in order to detect if the rerating operation failed. Its value is a positive in case of success, a negative one in case of failure.

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.


Column: RERATING_SUGGESTED_DATE

Value Type DATE
Column Description The rerating date suggested by the external billing system.


Column: OVERRIDE_DEPENDENCIES

Value Type DECIMAL(1), NOT NULL
Column Description Defines whether the subscription overrides the offer level dependencies.


Top of the list


SAP Convergent Charging 3.0

Document Version: SP04 and later

(c) Copyright 2011 SAP AG. All rights reserved.