Content
This table contains CDR data read from the innovaphone PBX CDR connector.
Note: this table should be used with caution, as it is not always possible to match records to jtel ACD call records.
Note: this table is not supported by jtel support, enquiries regarding the contents of this table are strictly processed on a consulting basis only.
For a reference of the fields supplied by Innovaphone, please see http://wiki.innovaphone.com/index.php?title=Reference11r1:Concept_Call_Detail_Record_CDR_PBX.
Fields
Field | Type | Meaning |
|---|---|---|
ID | INT | A unique ID assigned to each record. |
Name | VARCHAR | The cn attribute of the reported CDR. |
Number | VARCHAR | The e164 attribute of the reported CDR. |
ShortName | VARCHAR | The h323 attribute of the reported CDR. |
bOutbound | BOOLEAN | If the dir attribute of the reported CDR is “to” then bOutbound = FALSE (0). TRUE (1) otherwise. |
bBusy | BOOLEAN | If the cause attribute of the reported CDR is 17, then bBusy = TRUE (1), FALSE (0) otherwise. |
bExternal | BOOLEAN | If the type attribute of the reported CDR is ext, then bExternal = TRUE (1), FALSE (0) otherwise. Additionally as a workaround for a presumed bug in the Innovaphone CDRs, when the h323 element is empty on receipt of alert-to or rel-from, then this field is also set to TRUE (1). |
RemoteParty | VARCHAR | The e164 attribute of the reported CDR. |
dtCreated | TIMESTAMP | The date and time on which the CDR record was created. |
nRingSeconds | INT | The number if seconds the call was ringing for. |
nConnSeconds | INT | The number if seconds the call was connected for. |
nReleaseSeconds | INT | The numer of seconds after the call was started when it was released. |
nEnquirySeconds | INT | The number of seconds the call was in enquiry status, if a call transfer was performed or aborted. |
bRelease | BOOLEAN | If the call was released (disconnected) by the local party (the cn) then TRUE (1), FALSE (0) otherwise. |
bCallRefused | BOOLEAN | If the call was rejected by the receiving party then TRUE (1), FALSE (0) otherwise. |
cfFromName | VARCHAR | The dn attribute of the cf tag if a call forward was indicated. |
cfFromNumber | VARCHAR | The e164 attribute of the cf tag if a call forward was indicated. |
cfFromShortName | VARCHAR | The h323 attribute of the cf tag if a call forward was indicated. |
remoteName | VARCHAR | The dn attribute received in the alert-to or alert-from message. |
remoteNumber | VARCHAR | The e164 attribute received in the alert-to or alert-from message. |
remoteShortName | VARCHAR | The h323 attribute received in the alert-to or alert-from message. |
ctFromName | VARCHAR | In the case of a transfer-to event, the value of the dn attribute of the CDR, |
ctFromNumber | VARCHAR | In the case of a transfer-to event, the value of the e164 attribute of the CDR. |
ctFromShortName | VARCHAR | In the case of a transfer-to event, the value of the h323 attribute of the CDR. |
ctToName | VARCHAR | The dn attribute of the ct tag or to tag if present. |
ctToNumber | VARCHAR | The e164 attribute of the ct tag or to tag if present. |
ctToShortName | VARCHAR | The h323 attribute of the ct tag or to tag if present. |
XMLData | TEXT | The XML data supplied to the CDR endpoint. |
dtLastModified | TIMESTAMP | The date and time at which this entry was last modified. |