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	4.5.13
Partitioned	No

Summary

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

Name	PK	FK	IX	Uses	Used by
OID	PK_SPENDSTATMON
MONITORING_ID			IX_SSM_MONITORING_ID
MONITORING_DATE
SSRL_ID
CACO_OID			IX_SSM_CACO_OID
EXPIRATION_DATE			IX_SSM_EXPIRATION_DATE
SPENDING_STATUS_IDS
PARTITION_ID	PK_SPENDSTATMON

Column Details

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	SECONDDATE, 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	SECONDDATE, 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	BLOB, 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

PK_SPENDSTATMON

Column(s)	PARTITION_ID,OID
Tablespace	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

IX_SSM_MONITORING_ID

Indexed Column(s)	MONITORING_ID
Unique	Yes
Partitioned	No

IX_SSM_EXPIRATION_DATE

Indexed Column(s)	EXPIRATION_DATE
Unique	Yes
Partitioned	No