CACO_BATCH
Definition
The CACO_BATCH table contains the description of the charging contract used by the
batch service client
Technical Data
| Schema Version |
4.5.13 |
| Filegroup |
SUBSCRIBER_DATA |
| Partitioned |
Yes, when you use the partitioning scheme and corresponding SQL scripts |
Summary
The CACO_BATCH table is defined by the
following columns.
See the column details for more information.
Column Details
OID
| Definition |
The charging contract unique identifier |
| Type |
DECIMAL(28), NOT NULL |
| Primary Key |
PK_CACO_BATCH |
PARTITION_ID
| Definition |
The partition of the subscriber account |
| Type |
DECIMAL(4), NOT NULL |
BGRP_OID
| Definition |
The batch rating group identifier that this charging contract has registered |
| Type |
DECIMAL(2), NULL |
RERATING_LOCK_CODE
| Definition |
The code of the rerating operation which locks this charging contract |
| 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.
|
| Type |
NVARCHAR(64), NULL |
RERATING_LAST_CODE
| Definition |
The code of the last rerating operation performed on the charging contract |
| Description |
The code of the last rerating operation performed on the charging contract. This code
is only available for offline charging contracts.
|
| Type |
NVARCHAR(64), NULL |
RERATING_LAST_STATUS
| Definition |
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
|
| 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.
|
| Format |
The 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.
|
| Type |
DECIMAL(1), NULL |
RERATING_SUGGESTED_DATE
| Definition |
The rerating date suggested by the external billing system |
| Type |
DATETIME, NULL |
Primary Key Details
PK_CACO_BATCH
