ACQUISITION_SESSION
CDR Acquisition Sessions
Description
consumption detail records (CDRs)
Technical Data
| Schema Version |
4.5.2 |
|
| Partitioned |
No |
Summary
The ACQUISITION_SESSION table is defined by the
following columns.
See the column details for more information.
Column Details
OID
| Definition |
The unique ID of the CDR acquisition session |
| Type |
DECIMAL(28), NOT NULL |
| Primary Key |
PK_ACQUISITION_SESSION |
START_DATE
| Definition |
The start date of the acquisition session |
| Type |
SECONDDATE, 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
