ACQUISITION_SESSION
CDR Acquisition Sessions
Description
consumption detail records (CDRs)
Technical Data
| Schema Version |
4.5.2 |
| Filegroup |
BART_DATA |
| Partitioned |
No |
Summary
The ACQUISITION_SESSION table is defined by the
following columns.
See the column details for more information.
Column Details
OID
START_DATE
| Definition |
The start date of the acquisition session |
| Type |
DATETIME, NOT NULL |
DURATION
| Definition |
The duration of the acquisition session |
| Type |
DECIMAL(28), NULL |
NB_CDR_NEW
| Definition |
The number of CDRs with the status "new" or "no_provisioning" |
| Type |
DECIMAL(28), NULL |
NB_CDR_DUPLICATE
| Definition |
The number of CDRs with the status "duplicated" |
| Type |
DECIMAL(28), NULL |
NB_CDR_CONSOLIDATE
| Definition |
The number of CDRs that were successfully consolidated during the batch acquisition |
| Type |
DECIMAL(28), NULL |
SOURCE
| Definition |
The source of the acquisition session. For example, a file or a downstream system. |
| Type |
NVARCHAR(2000), NULL |
DESCRIPTION
| Definition |
The comprehensive description of the acquisition session |
| Type |
NVARCHAR(2000), NULL |
ACQUISITION_MODE
| Definition |
The mode of the acquisition |
| Type |
DECIMAL(1), NOT NULL |
| Default |
0 |
STATUS
| Definition |
The current status of the CDR acquisition session |
| Type |
DECIMAL(1), NOT NULL |
| Default |
0 |
Primary Key Details
PK_ACQUISITION_SESSION
Index Details
The following database indexes are available in the
ACQUISITION_SESSION database table to improve the speed of data retrieval operations during
the business processes of SAP Convergent Charging:
IX_ACQUISITION_SESSION
| Indexed Column(s) |
OID |
| Unique |
No |
| Partitioned |
No |
| Clustered |
No |
| Filegroup |
BART_INDX |
