call_result_codes

Table name: call_result_codes

Contains/Role:

  • Holds the description for the different possible result codes (i.e. the “outcome”) of a call event.
  • Table call_events holds a foreign key against this table.

  Some more info to be found here.

Column NameDatatypeDescription
result_codeChar (2)
Primary key.

Currently these result codes are in use:

?Unknown
aInterrupt in queue (media type phone, event_type='q')
bTwo meanings:
1) For event type 'q': FallBack exit used.
2) For event type 'c': Busy
cTwo meanings:
1) For event type 'q': Admin removed call from queue (Cancel).
2) For event type 'c': Timeout in setup phase.
dTwo meanings:
1) For event type ‘m’: Default exit used
2) For event type ‘q’: Deleted (request was deleted from queue)
eError
fThe queue was full (event type = 'q')
hHang-up - the call was terminated by caller before the event was completed (event type 'c', 'm' and 'q')
kOk
mTwo meanings:
1) For event type 'm' (for media type phone): Max tries exceeded
2) For event type 'q' (for media type email): Moved (to another queue)
nNo match for the DTMF used (event type 'm' only)
qTwo meanings:
1) For event type 'q': Call-back is ordered.
2) For event type 'c': Caller hang-up while call to agent was in set-up phase
sThe queue was closed (event_type 'q')
tTimeout (event type 'c', 'q' and 'm'). 
For event type 'c' this means "ringing timeout", aka 'no answer".
 
descriptVarchar (255)Describes the code.

Published

Last updated

4
-1