DataBase

DataBase


QUEUE_LOG_REPO

 

Information of the queue calls state of campaigns input or output.

Parameter details

  • origid: Original id (can be repetead).

  • datetime: Datetime of the event.

  • callid: The call id.

  • queuename: Campaign name.

  • event: Check event list.

  • data a data5: Depends on the event.

Events

Event

Description

data1

data2

data3

data4

data5

Event

Description

data1

data2

data3

data4

data5

AGENTLOGIN

Agent Login.

N/A

N/A

N/A

N/A

N/A

AGENTLOGOFF

Agent logoff. Seconds logged in.

logintime

N/A



[automatic]

N/A

ABANDON

The caller abandoned their position in the queue. The position is the caller's position in the queue when they hungup, the origposition is the original position the caller was when they first entered the queue, and the waittime is how long the call had been waiting in the
queue at the time of disconnect.

position

origposition

waittime





COMPLETEAGENT

The caller was connected to an agent, and the call was terminated normally by the agent. The caller's hold time and the length of the call are both recorded. The caller's original position in the queue is recorded in origposition.



holdtime

calltime

origposition

N/A

N/A

COMPLETECALLER

The caller was connected to an agent, and the call was terminated normally by the caller. The caller's hold time and the length of the call are both recorded. The caller's original position in the queue is recorded in origposition.



holdtime

calltime

origposition

N/A

N/A

CONNECT

The caller was connected to an agent. Hold time represents the amount of time the caller was on hold. The bridged channel unique ID contains the unique ID of the queue member channel that is taking the call. This is useful when trying to link recording filenames to a particular call in the queue.

holdtime

bridgedchanneluniqueid

ringtime

N/A

N/A

ENTERQUEUE

A call has entered the queue. URL (if specified) and Caller*ID are placed in the log.

N/A

callerid



N/A

N/A

EXITEMPTY

The caller was exited from the queue forcefully because the queue had no reachable members and it's configured to do that to callers when there are no reachable members. The position is the caller's position in the queue when they hungup, the origposition is the original position the
caller was when they first entered the queue, and the waittime is how long the call had been waiting in the queue at the time of disconnect.

position

origposition

waittime

N/A

N/A

EXITWITHKEY

The caller elected to use a menu key to exit the queue. The key and the caller's position in the queue are recorded.

key

position

origposition

waittime

N/A

EXITWITHTIMEOUT

The caller was on hold too long and the timeout expired. The position in the queue when the timeout step is recorder as the position entered and the amount of time I hope.

position

origposition

waittime

N/A

N/A

RINGNOANSWER

After trying for ringtime ms to connect to the available queue member the attempt ended without the member picking up the call.

ringtime

  N/A

  N/A

N/A

N/A

REALPAUSE/REALUNPAUSE

The Agent was change to Pause or Unpause pausetime: time in seconds on unpause



pausetime

  N/A

N/A 

N/A

N/A

UNBREAK/BREAK

Break with motive(descanso), have account that between BREAK and UNBREAK motive: BATHROOM, TRAINING, LUNCH, PERSONAL, OTHER. on breaktime in seconds when unbreak.

motive

comment

breaktime

N/A

N/A

 OUTCALL

Call for out call, status of the ended call, duration in seconds since answered, total time in seconds, dialed number and unique id.

dialstatus

duration

totaltime

 dialednumber

guid

 PAUSE/UNPAUSE

 Telephony Pause per campaign. We do not use in reports.











PAUSEALL/UNPAUSEALL

Telephony When Paused on all campaigns. We do not use in reports.











ATTENDEDTRANSFER

 Completed Call by Agent Until Transfered

BRIDGE

 

holdtime (seconds)

duration (seconds)

origin position

BLINDTRANSFER

 Completed Call by Agent Until Transfered

extension

context

holdtime

calltime

origposition

TRANSFER

 Completed Call by Agent Until Transfered

extension

context

holdtime

calltime

origposition

HOLD

Agent put call on hold

channel

calleridname

calleridnum

connectedlinename

connectedlinenum

UNHOLD

Agent unhold the call, this event can be missing if call is hang before unhold by the agent

channel

calleridname

calleridnum

connectedlinename

connectedlinenum

FINISHWRAPUP

If an agent finish wrapup before its time this event rises to tell you how much time left he had

timeleft









ADDMEMBER

A member was added to the queue.

N/A

N/A

N/A

N/A

N/A

AGENTDUMP

The agent dumped the caller while listening to the queue announcement.

N/A

N/A

N/A

N/A

N/A

CREATEDQUEUE

A new queue was created

N/A

N/A

N/A

N/A

N/A

QUEUESTART

The queueing system has been started for the first time this session.

N/A

N/A

N/A

N/A

N/A

REMOVEMEMBER

A queue member was removed from the queue.

N/A

N/A

N/A

N/A

N/A

PHONEATTENDEDTRANSFERATTEMPT

When an agent attempts to initiate an attended transfer.

callguid

"AGENT", "CAMPAIGN" or "EXTERNAL"

If data1 is EXTERNAL, dialed phone number upon transfer.

If data1 is AGENT, phone number of the agent to whom the call is transferred.

If data1 is CAMPAIGN, name of the campaign to which the call is transferred.

If data1 is CAMPAIGN, DID of the campaign to which the transfer was marked. If data1 is not CAMPAIGN, data3 is not defined.

N/A

PHONEATTENDEDTRANSFER

When an attended transfer is successfully completed.

callguid

N/A

N/A

N/A

N/A

 


CDR_REPO

 

Call Detail Record.

Parameter details

  • calldate:  Start date of the call.

  • clid: Callerid complete name and number.

  • src: Source.

  • dst: Destination.

  • dcontext: Destination context.

  • channel: Source channel.

  • dstchannel: Destination channel.

  • lastapp: Last workflow activity.

  • duration: Total duration.

  • billsec: Duration from answered.

  • disposition: Resut of the call.

  • amaflags: Not used.

  • accountcode: Agent name or other.

  • userfield: Where we tag the record.

  • uniqueid: Call id.

  • type: If was recorded.

  • guid: Unique id and recording name.

  • causecode: Code of the provider when the call finish.

  • campaign: Campaign name.

  • charged_balance: For virtual pbx billing.

  • real_balance: For virtual pbx billing.

  • note: For billing.

  • contact: Id of the dialer contact.

  • finishtime: If configured Tagging recording this is the date/time of finish adding disposition code.

  • rating: Mean of the quality .

  • dialerbase: Name of the dialer base.


SMS_REPO

 

Text messages.

Parameter details

  • id: Unique id.

  • idm: Depends on the API used.

  • campaign: Campaign. 

  • dateprocessed: Date of sent or arrival.

  • direction: I o O (inbound or outbound).

  • callerid: Source or origen.

  • message: Short text message.

  • agent: Agent.

  • smsbase: Dialer base.

  • result: Depends on the API.

  • readsms: si fue leido

  • sessionid: guid para session con agente 


WEBCHAT_LOG_REPO

 

Events

Evento

Descripcion

data1

data2

data3

data4

data5

ABANDON

El cliente abandonó en una cola antes que lo atendieran. position es donde estaba en el momento de cortar, origposition es en la posición que entro inicialmente, waittime es el tiempo que espero hasta cortar.

position

origposition

waittime

email



COMPLETEAGENT

El que solicito fue conectado a un agente, y el chat fue terminado normalmente por el agente. El holdtime del agente y la duración de la llamada son guardadas al igual que la posición inicial donde entró la llamada a la cola.



holdtime

chattime

origposition

messageqt

N/A

COMPLETECALLER

El que llamó fue conectado a un agente, y el webchat fue terminado normalmente por el que llamó. El holdtime del agente y la duración del webchat son guardadas al igual que la posición inicial donde entro el webchat a la cola.