Field description
Last modified by Frank Schmidt on 2026/01/26 05:01
Introduction
If the contact center is configured accordingly, CDR data (Call Detail Records) and agent data are written to the database. The tables used, including their fields, are therefore described in more detail below.
Tables
CDR
The CDR table contains all call data (Call Detail Records). To represent a complete call history, a new record is written each time the CDRState field changes. All fields from the previous record are retained and, if applicable, updated with current values.
| Column name | Description |
| CDRCallId | Unique ID of the call |
| CDROriginationNumber | Caller’s phone number |
| CDROriginationName | Caller’s name |
| CDRCalledNumber | Phone number of the called party |
| CDRCalledName | Name of the called party |
| CDRDestinationNumber | Phone number to which the call was delivered |
| CDRDestinationName | Name to which the call was delivered |
| CDRStartDate | Date and time when the call started |
| CDRScriptConnectDate | Date and time when the call was connected to its script (e.g., queue) |
| CDRDeliveredDate | Date and time when the call was delivered |
| CDRConnectDate | Date and time when the call was connected |
| CDREndDate | Date and time when the call ended |
| CDRCurrency | |
| CDRCosts | Cost of the call (calculated based on the settings in Swyx and the duration of the call) |
| CDRState | Status of the call |
| CDRPublicAccessPrefix | |
| CDRLCRProvider | |
| CDRProjectNumber | |
| CDRAOC | |
| CDROriginationDevice | Name of the trunk through which the call was received (Inbound) |
| CDRDestinationDevice | Name of the trunk through which the call was made (Outbound) |
| CDRTransferredByNumber | Phone number of the user who transferred the call |
| CDRTransferredByName | Name of the user who transferred the call |
| CDRTransferredCallId1 | CallID of the original call |
| CDRTransferredCallId2 | CallID of the original call |
| CDRTransferredToCallId | CallID to which the call was transferred |
| CDRTransferDate | Date and time of the transfer" |
| CDRDisconnectReason | Reason why the call was ended |
| CDRConnectedNumber | Phone number to which the call was connected |
| CDRConnectedName | Name to which the phone number was connected |
| CDRCustom0 | Call delivery destination (Available only for queue calls) |
| CDRCustom1 | Remark of the call (Available only for queue calls) |
| CDRCustom2 | (Available only for queue calls) |
| CDRCustom3 | Name of the queue (Available only for queue calls) |
| CDRCustom4 | ID of the queue (Available only for queue calls) |
| CDRCustom5 | Name of the queue(Available only for queue calls) |
| CDRCustom6 | (Available only for queue calls) |
| CDRCustom7 | (Available only for queue calls) |
| CDRCustom8 | (Available only for queue calls) |
| CDRCustom9 | (Available only for queue calls) |
| CDRCustom10 | (Available only for queue calls) |
| CDRCustom11 | (Available only for queue calls) |
| CDRCustom12 | (Available only for queue calls) |
| CDRCustom13 | (Available only for queue calls) |
| CDRCustom14 | (Available only for queue calls) |
| CDRCustom15 | (Available only for queue calls) |
| CDRCustom16 | (Available only for queue calls) |
| CDRCustom17 | (Available only for queue calls) |
| CDRCustom18 | (Available only for queue calls) |
| CDRCustom19 | (Available only for queue calls) |
| CDRCustom20 | (Available only for queue calls) |
| CDRTimeStamp | Date and time of the status change |
| CDRId | Unique ID of the database entry (call process) |
| CDRCallsInQueue | Number of calls in the queue at the time of the call |
| CDRPreviousState | Previous status of the call |
| CDRTypeInbound | Indicates whether it is an incoming call (1 = Inbound, 0 = Other) |
| CDRTypeOutbound | Indicates whether it is an outgoing call (1 = Outbound, 0 = Other) |
| CDRTypeCallback | Indicates whether it is a callback (1 = Callback, 0 = Other) |
| CDRTypeQueue | Indicates whether it is a queue call (1 = Queue, 0 = Other) |
| CDRTypeCDR | Indicates whether it is a Swyx call (1 = Swyx, 0 = Other) |
| CDRTimeOffset | Time difference between state and previous state in seconds |
QueueLogonGroups
This table contains all information about the agents. All status changes are logged, including agent status changes within the queues/contact center as well as within Swyx itself.
| Column name | Description |
| ID | Unique ID of the entry |
| LogOnDate | Date and time when the status started |
| LogOffDate | Date and time when the status ended (NULL if the status is current) |
| UserGroup | Group in which the status was set |
| UserName | Name of the user whose status was changed |
| PostProcessing | 1 if the user is in post-processing, otherwise 0 |
| CallID | CallID of the call that caused the status change |
| OnHold | 1 if the call is on hold, otherwise 0 |
| Pause | 1 if the user is on break, otherwise 0 |
| RemoteLogon | 1 if the login is remote, otherwise 0 |
| ChangedBy1 | Name of the user who changed the status |
| ChangedOn1 | Date and time of the change |
| ChangedBy2 | Name of the user who changed the status |
| ChangedOn2 | Date and time of the change |
| PauseDescription | |
| StatusText | Status text of the pause reason |
| System | 1 if it is a system login, otherwise 0 |
| Away | 1 if the user is absent, otherwise 0 |
| DND | 1 if the user is DND (Do Not Disturb), otherwise 0 |
| ChangedFrom1 | IP address from which the change came |
| ChangedFrom2 | IP address from which the change came |