SPENDING_STATUS_MONITORING

Definition

The SPENDING_STATUS_MONITORING table contains all the necessary information to monitor the spending status of a charging contract. A spending status monitoring is identified by its spending status monitoring identifier and or its internal unique identifier.

Technical Data

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

Summary

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

Name	PK	IX	Definition
OID	PK_SPENDSTATMON		The internal unique identifier of the spending status monitoring. It is generated by the SAP CC system.
MONITORING_ID		IX_SSM_MONITORING_ID	The external identifier given by the client application
MONITORING_DATE			The starting date and time of the spending status monitoring
SSRL_ID			The identifier of the spending status report listener in charge of processing the spending statuses
CACO_OID		IX_SSM_CACO_OID	The identifier of the charging contract
EXPIRATION_DATE		IX_SSM_EXPIRATION_DATE	The date and time after which the spending status monitoring is not relevant anymore
SPENDING_STATUS_IDS			The list of the spending status IDs of the charging contract to monitor.
PARTITION_ID	PK_SPENDSTATMON		The database partition identifier of the subscriber account of the charging contract

Column Details

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

OID

Definition	The internal unique identifier of the spending status monitoring. It is generated by the SAP CC system.
Type	DECIMAL(28), NOT NULL
Primary Key	PK_SPENDSTATMON

MONITORING_ID

Definition	The external identifier given by the client application
Type	NVARCHAR(256), NOT NULL
Available Index	IX_SSM_MONITORING_ID

MONITORING_DATE

Definition	The starting date and time of the spending status monitoring
Type	DATETIME, NOT NULL

SSRL_ID

Definition	The identifier of the spending status report listener in charge of processing the spending statuses
Type	DECIMAL(4), NOT NULL

CACO_OID

Definition	The identifier of the charging contract
Type	DECIMAL(28), NOT NULL
Available Index	IX_SSM_CACO_OID

EXPIRATION_DATE

Definition	The date and time after which the spending status monitoring is not relevant anymore
Type	DATETIME, NOT NULL
Available Index	IX_SSM_EXPIRATION_DATE

SPENDING_STATUS_IDS

Definition	The list of the spending status IDs of the charging contract to monitor.
Type	VARBINARY(MAX), NULL

PARTITION_ID

Definition	The database partition identifier of the subscriber account of the charging contract
Type	DECIMAL(4), NOT NULL
Primary Key	PK_SPENDSTATMON

Primary Key Details

See the primary key information:

PK_SPENDSTATMON

Column(s)	PARTITION_ID,OID
Filegroup	SESSION_RATING_DATA

Index Details

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

IX_SSM_CACO_OID

Indexed Column(s)	CACO_OID
Unique	Yes
Partitioned	Yes
Clustered	No
Filegroup	SESSION_RATING_INDX

IX_SSM_MONITORING_ID

Indexed Column(s)	MONITORING_ID
Unique	Yes
Partitioned	No
Clustered	No
Filegroup	SESSION_RATING_INDX

IX_SSM_EXPIRATION_DATE

Indexed Column(s)	EXPIRATION_DATE
Unique	Yes
Partitioned	No
Clustered	No
Filegroup	SESSION_RATING_INDX