These are some important tables that can be used on reports. Database: ccrepo

QUEUE_LOG_REPO

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

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.

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		N/A	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	N/A	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.
TRANSFER	Completed Call by Agent Until Transfered	extension	context	holdtime	calltime	origposition

CDR_REPO

Call Detail Record.

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: Not used.
rating: Mean of the quality .
dialerbase: Name of the dialer base.

SMS_REPO

Text messages.

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.

SIPCHAT

Chat between agents and supervisors.

id: Automatic.
datecreated: Of the message.
src: Source.
dest: Destination.
message: Text message.
srcagent: Source agent.
dstagent: Destination agent.
status: Message status (SUCCESS, FAILURE).

AUDITORY

System auditory.

id: Automatic.
datetime: Of the event.
userid: User.
host: Source ip address.
action: Action.

BLACK_LIST_HISTORY

Historical of the do not call registry or who tried to enter.

id: Automatic.
calldate: Date time of the intent.
src: Agent.
dst: Inbound or outbound number.

DIALERS

To Load dialers directly on the database you have first to insert the calls_spool and then the dialer_base, check that there is no other active list for this campaign or insert inactive.

CALLS_SPOOL

campaign: Dialer campaign.
destination: Phone to dial.
status: Status (1 ready, 0 in progress, 3 black list blocked).
data: Variables for workflows and forms.
alternatives: List delimited by : of alternative phones.
contact: Contact id for the CDR trace.
dialerbase: List name.
priority: Prioridad (9999 usually, never 1 but can be > 1 so the smaller values are executed first).
agentphone: For progressive this is the agent extension .

DIALER BASE

id: Autogenerated.
campaign: Dialer campaign name.
name: List name.
records: Count of records.
active: If active.

uContact Older Versions

d. DataBase v5