| Schema Version | 5.0.6 | |
| Tablespace | SUBSCRIBER_DATA | |
| Partitioned | Yes, when you use the partitioning scheme and corresponding SQL scripts | |
The CACO_BATCH 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_CACO_BATCH |
|
The charging contract unique identifier | |||
| PARTITION_ID |
|
The partition of the subscriber account | ||||
| BGRP_OID |
|
The batch rating group identifier that this charging contract has registered | ||||
| RERATING_LOCK_CODE |
|
The code of the rerating operation that locks this charging contract | ||||
| RERATING_LAST_CODE |
|
The code of the last rerating operation performed on the charging contract | ||||
| RERATING_LAST_STATUS |
|
The RERATING_LAST_STATUS field contains the last rerating status of the charging contract to detect if the rerating operation failed or succeeded | ||||
| RERATING_SUGGESTED_DATE |
|
The rerating date suggested by the external billing system |
The database schema defines the following columns. Check the definitions, types, available indexes, and formats:
| Definition | The charging contract unique identifier |
| Type | DECIMAL(28), NOT NULL |
| Primary Key | PK_CACO_BATCH |
| Definition | The partition of the subscriber account |
| Type | DECIMAL(4), NOT NULL |
| Definition | The batch rating group identifier that this charging contract has registered |
| Type | DECIMAL(2), NULL |
| Definition | The code of the rerating operation that 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 | VARCHAR(64), NULL |
| 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 | VARCHAR(64), NULL |
| Definition | The RERATING_LAST_STATUS field contains the last rerating status of the charging contract to detect if the rerating operation failed or succeeded |
| Description |
The RERATING_LAST_STATUS field contains the last rerating status of the charging contract
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:
|
| Type | DECIMAL(1), NULL |
| Definition | The rerating date suggested by the external billing system |
| Type | TIMESTAMP, NULL |
See the primary key information:
| Column(s) | OID |
| Tablespace | SUBSCRIBER_INDX |
