Contents
This table contains data pertaining to incoming calls to the system, which were not serviced by the system because:
No service number was found for the called number
A routing application was not associated with the service number
The service number status was closed
The service number was inactive, because the date and time for the expiry of the service number had been reached
Fields
Field | Type | Meaning |
|---|---|---|
ID | INT | A unique ID assigned to this call record. |
ANumber | VARCHAR | The A-number in E.164 format. |
ANumberRaw | VARCHAR | The raw A-number from the signalling protocol. |
ANumberType | INT | The type of the A-Number from the D-channel. Note - for VoIP installations this will be 0. This field may be removed in a future release. |
ANumberPlan | INT | The numbering plan of the A-Number from the D-channel. Note - for VoIP installations this will be 0. This field may be removed in a future release. |
bPresentationRestricted | BOOLEAN | The presentation of the A-Number from the D-channel. Note - for VoIP installations this will be 0. This field may be removed in a future release. |
UserProvided | VARCHAR | The User Provided A-number in E.164 format. Note, in VoIP installations, this number will be empty. |
UserProvidedRaw | VARCHAR | The raw User Provided A-number from the signalling protocol. Note, in VoIP installations, this number will be empty. |
UserProvidedType | INT | The type of the User Provided A-Number from the D-channel. Note - for VoIP installations this will be 0. This field may be removed in a future release. |
UserProvidedPlan | INT | The numbering plan of the User Provided A-Number from the D-channel. Note - for VoIP installations this will be 0. This field may be removed in a future release. |
BNumber | VARCHAR | The dialled B-number (platform destination) in E.164 format. |
BNumberRaw | VARCHAR | The dialled B-number (platform destination) from the signalling protocol. |
BNumberType | INT | The type of the B-Number from the D-channel. Note - for VoIP installations this will be 0. This field may be removed in a future release. |
BNumberPlan | INT | The numbering plan of the B-Number from the D-channel. Note - for VoIP installations this will be 0. This field may be removed in a future release. |
dtCallStart | TIMESTAMP | The date and time the call entered the system. |
dtCallEnd | TIMESTAMP | The date and time the call was released (hungup) by the system or by the caller. |
Action | VARCHAR | The action code associated with why the call was not connected. See Value Reference - Action Code |
Reason | VARCHAR | A textual explanation of the action code. |
CallSeconds | INT | The duration in seconds from dtCallStart to dtCallEnd. Note, it is not recommended to use this field, it is better to calculate the time difference between dtCallStart and dtCallEnd. This field may be removed in a future release. |
MachineID | INT | The Machine ID of the jtel telephony server on which the call was processed. |
Line | INT | The Logical line number on the jtel telephony server on which the call was processed. |
StartSequenceID | INT | The Start Sequence ID of the jtel telephony server. |
Controller | INT | The logical controller number on the jtel telephony server on which the call was processed. Note, for VoIP installations this field will always be 1. This field may be removed in a future release. |
BChannel | INT | The B-channel on which the call was received. Note, for VoIP installations this field will always be -1. This field may be removed in a future release. |