Overview | Core Database Schema | All Tables All Columns

Table: CACO_BATCH

Table Name CACO_BATCH
Table Description The CACO_BATCH table contains the description of the charging contract used by the batch service client.
Tablespace SUBSCRIBER_DATA
Database Core Database
Partitioned Yes
Columns
OID
PARTITION_ID
BGRP_OID
RERATING_LOCK_CODE
RERATING_LAST_CODE
RERATING_LAST_STATUS
RERATING_SUGGESTED_DATE

Columns of the Table

The CACO_BATCH database table is defined by the following columns.

Column: OID

Value Type BIGINT, NOT NULL
Key(s) Primary Key: PK_CACO_BATCH
Column Description The charging contract unique identifier.


Column: PARTITION_ID

Value Type SMALLINT, NOT NULL
Column Description The partition of the subscriber account.


Column: BGRP_OID

Value Type DECIMAL(2)
Column Description The batch rating group identifier that this charging contract has registered .


Column: RERATING_LOCK_CODE

Value Type VARCHAR(64)
Column Description The code of the rerating operation which locks this charging contract. If this code is set, it means that the charging contract is currently being 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 performed on the charging contract. This code is only available for offline charging contracts.


Column: RERATING_LAST_STATUS

Value Type DECIMAL(1)
Column Description

The RERATING_LAST_STATUS field contains the last rerating status of the charging contract in order to detect if the rerating operation failed or succeeded. This status is a positive value in case of success, and a negative value 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, which means that the rerating operation failed because of a provider contract export and a provider contract unlock issue.
  • -7: UNLOCK_FAILURE, which means that the rerating operation failed because of a provider contract unlock issue.
  • -6: EXPORT_FAILURE, which means that the rerating operation failed because of a provider contract export issue.
  • -5: BART_RESTORATION_FAILURE, which means that the restoration process failed for the last rerating operation because the BART Server denied the rerating operation.
  • -4: DEPRECATED
  • -3: COUNTER_RESTORATION_FAILURE, which means that the counter restoration process failed.
  • -2: NOT_LOCKED_FAILURE, which means that the rerating operation failed because the provider contract was not locked (but should have been locked).
  • -1: ALREADY_LOCKED_FAILURE, which means that the rerating operation failed because the provider contract was locked by a concurrent rating process or another previous rerating operation.
  • 0: UNSET.
  • 1: SELECTION_SUCCESS, which means that the restoration process was successful for the last rerating operation.
  • 2: RESTORATION_SUCCESS.
  • 3: RERATING_SUCCESS, which means that the rerating process was successful.


Column: RERATING_SUGGESTED_DATE

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


Top of the list


SAP Convergent Charging 3.0

Document Version: SP04 and later

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