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	2025.0.0
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	FK	IX	Uses	Used by	Definition
OID	PK_SPENDSTATMON					The internal unique identifier of the spending status monitoring. It is generated by the SAP CC system.
CLIENT_NUMBER						The client number associated to the spending status monitoring
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

CLIENT_NUMBER

Definition	The client number associated to the spending status monitoring
Type	DECIMAL(3), NOT NULL

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	IMAGE, 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
Segment	SESSION_RATING_INDX

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

IX_SSM_MONITORING_ID

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

IX_SSM_EXPIRATION_DATE

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