Contents
This table contains data received from a TAPI PBX connector.
Note: the purpose of this table is to track calls in the TAPI connector, as TAPI events are not “conclusive”. I.e. the reception of a particular event may depend on the events received previously. It is not possible to ascertain the exact status of a call based on a single event.
This table should not be used for statistical purposes.
Fields
Field | Type | Meaning |
---|---|---|
ID | INT | A unique ID assigned to each entry. |
PBXCallID | INT | The ID of the record from the PBX or NULL if PBXCallUID is used (see below). |
Origin | INT | TAPI Field “Origin”: Outbound = 1: The call originated from this station as an outgoing call. Internal = 2: The call originated as an incoming call at a station internal to the same switching environment. For example, a call from one extension to another on the same PBX. External = 4: The call originated as an incoming call on an external line. Unknown = 16: The call origin is currently unknown but may become known later. Unavail = 32: The call origin is not available and will never become known for this call. Conference = 64: The call is a conference call, that is, it is the application's connection to the conference bridge in the switch. Inbound = 128: The call originated as an incoming call, but the service provider is unable to determine whether it came from another station on the same switch or from an external line. |
Reason | INT | TAPI Field „Reason“: FwdBusy = 2: This call was forwarded from another extension that was busy at the time of the call. FwdNoAnswer = 4: The call was forwarded from another extension that didn't answer the call after some number of rings. FwdUncond = 8: The call was forwarded unconditionally from another number. Pickup = 16: The call was picked up from another extension. Unpark = 32: The call was retrieved as a parked call. Redirect = 64: The call was redirected to this station. CallCompletion = 128: The call was the result of a call completion request. Transfer = 256: The call has been transferred from another number. Reminder = 512: The call is a reminder (or "recall") that the user has a call parked or on hold for (potentially) a long time. Unknown = 1024: The reason for the call is currently unknown but may become known later. Unavail = 2048: The reason for the call is unavailable and will not become known later. Intrude = 4096: The call intruded onto the line, either by a call completion action invoked by another station or by operator action. Depending on switch implementation, the call may appear either in the connected state, or conferenced with an existing active call on the line. Parked = 8192: The call was parked on the address. Usually, it appears initially in the onhold state. CampedOn = 16384: The call was camped on the address. Usually, it appears initially in the onhold state. If an active call becomes idle, the camped-on call may change to the offering state and the device start ringing. RouteRequest = 32768: The call appears on the address because the switch needs routing instructions from the application. |
CallState | INT | TAPI CallState field. This field may change its value over the lifetime of the call and is used for internal tracking purposes only. Defined values: Unknown = 0: The call exists, but its state is currently unknown. Offering = 1: The call is being offered to the station, signaling the arrival of a new call. Dialing = 2: The originator is dialing digits on the call. Connected = 3: The call has been established and the connection is made. Disconnected = 4: The call has been disconnected. Idle = 5: The call has been disconnected and is no longer active. This is the final state of the call before it's destroyed. A call can never transition out of the idle state. Accepted = 6: The call was in the offering state and has been accepted by the called party. DialTone = 7: The call is receiving a dial tone from the switch, which means that the switch is ready to receive a dialed number. Proceeding = 8: Dialing has completed and the call is proceeding through the switch or telephone network. This occurs after dialing is complete and before the call reaches the dialed party, as indicated by ringback, busy, or answer. Ringback = 9: The station to be called has been reached, and the destination's switch is generating a ring tone back to the originator. A ringback means that the destination address is being alerted to the call. OnHold = 10: The call is on hold by the switch. This frees the physical line, which allows another call to use the line. OnHoldPendingConference = 11: The call is currently on hold while it is being added to a conference. OnHoldPendingTransfer = 12: The call is currently on hold awaiting transfer to another number. Conferenced = 13: The call is a member of a conference call and is logically in the connected state. |
AddressName | VARCHAR | Name of the device or address in the PBX system. |
ExtractedNumber | VARCHAR | The phone number of the device, extracted from the name of the device using a pattern in the TAPI connector. |
OriginalAddressName | VARCHAR | The contents of the original Address Name in case the Address Name changes (for example, during a call transfer). |
OriginalExtractedNumber | VARCHAR | The contents of the original Extracted Number in case the Address Name changes (for example, during a call transfer). |
CallerID | VARCHAR | The calling party number, exactly as reported by TAPI. |
CalledID | VARCHAR | The called party number, exactly as reported by TAPI. |
ConnectedID | VARCHAR | The connected number, exactly as reported by TAPI. |
RedirectionID | VARCHAR | The number to which the call is being redirected, exactly as reported by TAPI. |
RedirectingID | VARCHAR | The number from which the call is being redirected, exactly as reported by TAPI. |
StatisticsPartAID | INT | ID of the StatisticsPartA data record for the call, or NULL if no match is possible. |
dtCallOffer | TIMESTAMP | Date and time of call setup. |
dtCallInProgress | TIMESTAMP | Date and time of reception of progress (ringing or progress message in PBX). |
dtCallConnect | TIMESTAMP | Date and time of call connect. |
dtCallDisconnect | TIMESTAMP | Date and time of call disconnect. |
dtCallOnHold | TIMESTAMP | Date and time when the call was put on hold. |
dtCallOffHold | TIMESTAMP | Date and time when the call was retrieved from hold. |
dtCreated | TIMESTAMP | Timestamp of the creation of the data record. |
PBXCallUID | VARCHAR | The UID of the call in the PBX, or NULL if PBXCallID is used. |