Data sets

A data set is a container that holds data and information about that data’s structure, layout, and format. It is a single store of related data in the data model. This table lists the data sets that are part of the Calabrio ONE data model and the data fields (columns) that belong in each data set.

Data set name	Column name	Column type	Formula text	Included	Mapped	Mapped to
Agent Connection Detail	acd_src	STRING	[acd_src]	Yes	Yes	Data Source
Agent Connection Detail	aqd_acd_enddatetime	DATE	[aqd_acd_enddatetime]	Yes	No
Agent Connection Detail	aqd_acd_startdatetime	DATE	[aqd_acd_startdatetime]	Yes	Yes	Call Start Datetime - ACD
Agent Connection Detail	aqd_callcount	NUMBER	[aqd_callcount]	Yes	Yes	Call Count - ACD
Agent Connection Detail	aqd_calltime	NUMBER	[aqd_calltime]	Yes	Yes	Call Time
Agent Connection Detail	aqd_callwrapupdata	STRING	[aqd_callwrapupdata]	Yes	No
Agent Connection Detail	aqd_holdtime	NUMBER	[aqd_holdtime]	Yes	Yes	Hold Time
Agent Connection Detail	aqd_queuecount	NUMBER	[aqd_queuecount]	Yes	Yes	Queue Count - ACD
Agent Connection Detail	aqd_queueorder	STRING	[aqd_queueorder]	Yes	No
Agent Connection Detail	aqd_queuetime	NUMBER	[aqd_queuetime]	Yes	Yes	Queue Time - ACD
Agent Connection Detail	aqd_resourceid	STRING	[aqd_resourceid]	Yes	Yes	ACD Resource Id
Agent Connection Detail	aqd_ringtime	NUMBER	[aqd_ringtime]	Yes	Yes	Ring Time
Agent Connection Detail	aqd_talktime	NUMBER	[aqd_talktime]	Yes	Yes	Talk Time
Agent Connection Detail	aqd_worktime	NUMBER	[aqd_worktime]	Yes	Yes	Work Time
Agent Connection Detail	autowork	STRING	[autowork]	Yes	No
Agent Connection Detail	call_result_code_cat	STRING	[call_result_code_cat]	Yes	No
Agent Connection Detail	call_result_code_desc	STRING	[call_result_code_desc]	Yes	Yes	Call Result Code Description
Agent Connection Detail	call_result_code_name	STRING	[call_result_code_name]	Yes	No
Agent Connection Detail	call_result_code_value	NUMBER	[call_result_code_value]	Yes	Yes	Call Result Code Value
Agent Connection Detail	contactservicequeueid	NUMBER	[contactservicequeueid]	Yes	Yes	Contact Service Queue ID
Agent Connection Detail	csq_is_active	NUMBER	[csq_is_active]	Yes	No
Agent Connection Detail	csq_resourcegroupid	STRING	[csq_resourcegroupid]	Yes	No
Agent Connection Detail	csqname	STRING	[csqname]	Yes	Yes	Contact Service Queue Name
Agent Connection Detail	disposition_code_cat	STRING	[disposition_code_cat]	Yes	No
Agent Connection Detail	disposition_code_desc	STRING	[disposition_code_desc]	Yes	Yes	Disposition Code Description
Agent Connection Detail	disposition_code_name	STRING	[disposition_code_name]	Yes	Yes	Disposition Code Name
Agent Connection Detail	disposition_code_value	NUMBER	[disposition_code_value]	Yes	Yes	Disposition Code Value
Agent Connection Detail	extension	NUMBER	[extension]	Yes	Yes	Extension
Agent Connection Detail	is_active	NUMBER	[is_active]	Yes	No
Agent Connection Detail	is_autoavail	NUMBER	[is_autoavail]	Yes	No
Agent Connection Detail	last_updated_time	STRING	[last_updated_time]	Yes	No
Agent Connection Detail	nodeid	NUMBER	[nodeid]	Yes	Yes	Node ID
Agent Connection Detail	orderinrg	STRING	[orderinrg]	Yes	No
Agent Connection Detail	orderlist	STRING	[orderlist]	Yes	No
Agent Connection Detail	privatedata	STRING	[privatedata]	Yes	No
Agent Connection Detail	profileid	NUMBER	[profileid]	Yes	Yes	Profile ID
Agent Connection Detail	prompt	STRING	[prompt]	Yes	No
Agent Connection Detail	qindex	NUMBER	[qindex]	Yes	Yes	Qindex
Agent Connection Detail	queuealgorithm	STRING	[queuealgorithm]	Yes	No
Agent Connection Detail	queuetype	NUMBER	[queuetype]	Yes	No
Agent Connection Detail	queuetype_desc	STRING	[queuetype_desc]	Yes	No
Agent Connection Detail	recordid	NUMBER	[recordid]	Yes	Yes	Contact Service Queue Record ID
Agent Connection Detail	resourcefirstname	STRING	[resourcefirstname]	Yes	Yes	Resource Firstname
Agent Connection Detail	resourcegroupid	STRING	[resourcegroupid]	Yes	No
Agent Connection Detail	resourcelastname	STRING	[resourcelastname]	Yes	Yes	Resource Lastname
Agent Connection Detail	resourceloginid	STRING	[resourceloginid]	Yes	Yes	Resource Login ID
Agent Connection Detail	resourcename	STRING	[resourcename]	Yes	Yes	Resource Name
Agent Connection Detail	resourcepooltype	STRING	[resourcepooltype]	Yes	No
Agent Connection Detail	resourceskillmapid	STRING	[resourceskillmapid]	Yes	No
Agent Connection Detail	resourcetype	NUMBER	[resourcetype]	Yes	Yes	Resource Type
Agent Connection Detail	resourcetype_desc	STRING	[resourcetype_desc]	Yes	Yes	Resource Type Description
Agent Connection Detail	selectioncriteria	STRING	[selectioncriteria]	Yes	No
Agent Connection Detail	servicelevel	NUMBER	[servicelevel]	Yes	Yes	Contact Service Queue Service Level
Agent Connection Detail	servicelevelpercentage	NUMBER	[servicelevelpercentage]	Yes	Yes	Contact Service Queue Service Level Percentage
Agent Connection Detail	sessionid	NUMBER	[sessionid]	Yes	Yes	Session ID
Agent Connection Detail	sessionseqnum	NUMBER	[sessionseqnum]	Yes	Yes	Session Sequence Number
Agent Connection Detail	skillgroupid	STRING	[skillgroupid]	Yes	No
Agent Connection Detail	wrapuptime	NUMBER	[wrapuptime]	Yes	Yes	Wrapup Time
Agent State Detail	acd_src	STRING	[acd_src]	Yes	Yes	Data Source
Agent State Detail	agentid	STRING	[agentid]	Yes	No
Agent State Detail	asd_event_enddatetime	DATE	[asd_event_enddatetime]	Yes	Yes	Event End Time
Agent State Detail	asd_event_startdatetime	DATE	[asd_event_startdatetime]	Yes	Yes	Event Start Time
Agent State Detail	asd_eventdatetime	DATE	[asd_eventdatetime]	Yes	Yes	State Transition Time
Agent State Detail	assignedteamid	NUMBER	[assignedteamid]	Yes	No
Agent State Detail	dateinactive	STRING	[dateinactive]	No	No
Agent State Detail	event_duration	NUMBER	[event_duration]	Yes	Yes	Event Duration
Agent State Detail	eventcount	NUMBER	[eventcount]	Yes	Yes	Event Count
Agent State Detail	eventtype	NUMBER	[eventtype]	Yes	Yes	eventtype
Agent State Detail	eventtype_code_cat	STRING	[eventtype_code_cat]	Yes	No
Agent State Detail	eventtype_code_desc	STRING	[eventtype_code_desc]	Yes	Yes	Event Type Code Description
Agent State Detail	eventtype_code_key	NUMBER	[eventtype_code_key]	No	No
Agent State Detail	eventtype_code_name	STRING	[eventtype_code_name]	Yes	No
Agent State Detail	eventtype_code_value	NUMBER	[eventtype_code_value]	Yes	Yes	Event Type Code Value
Agent State Detail	extension	NUMBER	[extension]	Yes	Yes	Extension
Agent State Detail	is_active	NUMBER	[is_active]	Yes	No
Agent State Detail	is_autoavail	NUMBER	[is_autoavail]	Yes	No
Agent State Detail	is_valid_event	NUMBER	[is_valid_event]	Yes	Yes	Is Valid Event
Agent State Detail	last_updated_time	STRING	[last_updated_time]	Yes	No
Agent State Detail	orderinrg	STRING	[orderinrg]	Yes	No
Agent State Detail	profileid	NUMBER	[profileid]	Yes	Yes	Profile ID
Agent State Detail	reason_code_cat	STRING	[reason_code_cat]	Yes	No
Agent State Detail	reason_code_desc	STRING	[reason_code_desc]	Yes	Yes	Reason Code Description
Agent State Detail	reason_code_name	STRING	[reason_code_name]	Yes	No
Agent State Detail	reason_code_value	STRING	[reason_code_value]	Yes	Yes	Reason Code Value
Agent State Detail	reasoncode	NUMBER	[reasoncode]	Yes	Yes	reasoncode
Agent State Detail	reasoncode_key	STRING	[reasoncode_key]	No	No
Agent State Detail	resourcefirstname	STRING	[resourcefirstname]	Yes	Yes	Resource Firstname
Agent State Detail	resourcegroupid	STRING	[resourcegroupid]	Yes	No
Agent State Detail	resourcelastname	STRING	[resourcelastname]	Yes	Yes	Resource Lastname
Agent State Detail	resourceloginid	STRING	[resourceloginid]	Yes	Yes	Resource Login ID
Agent State Detail	resourcename	STRING	[resourcename]	Yes	Yes	Resource Name
Agent State Detail	resourceskillmapid	STRING	[resourceskillmapid]	Yes	No
Agent State Detail	resourcetype	NUMBER	[resourcetype]	Yes	Yes	Resource Type
Agent State Detail	resourcetype_desc	STRING	[resourcetype_desc]	Yes	Yes	Resource Type Description
Contact Call Detail	accountnumber	STRING	[accountnumber]	Yes	No
Contact Call Detail	acd_src	STRING	[acd_src]	Yes	Yes	Data Source
Contact Call Detail	applicationid	NUMBER	[applicationid]	Yes	Yes	Application ID
Contact Call Detail	applicationname	STRING	[applicationname]	Yes	Yes	Application Name
Contact Call Detail	applicationtaskid	STRING	[applicationtaskid]	Yes	No
Contact Call Detail	badcalltag	STRING	[badcalltag]	Yes	No
Contact Call Detail	callcount	NUMBER	[callcount]	Yes	Yes	Call Count - CCD
Contact Call Detail	callednumber	STRING	[callednumber]	Yes	Yes	Called Number
Contact Call Detail	callerentereddigits	STRING	[callerentereddigits]	Yes	No
Contact Call Detail	campaignid	STRING	[campaignid]	Yes	No
Contact Call Detail	ccd_acd_enddatetime	DATE	[ccd_acd_enddatetime]	Yes	Yes	Call End Datetime - CCD
Contact Call Detail	ccd_acd_startdatetime	DATE	[ccd_acd_startdatetime]	Yes	Yes	Call Start Datetime - CCD
Contact Call Detail	conference	NUMBER	[conference]	Yes	Yes	Conference Calls
Contact Call Detail	connecttime	NUMBER	[connecttime]	Yes	Yes	Connect Time
Contact Call Detail	contactdisp_code_cat	STRING	[contactdisp_code_cat]	Yes	No
Contact Call Detail	contactdisp_code_desc	STRING	[contactdisp_code_desc]	Yes	Yes	Contact Disposition Code Description
Contact Call Detail	contactdisp_code_name	STRING	[contactdisp_code_name]	Yes	No
Contact Call Detail	contactdisp_code_value	NUMBER	[contactdisp_code_value]	Yes	Yes	Contact Disposition Code Value
Contact Call Detail	contacttype_code_cat	STRING	[contacttype_code_cat]	Yes	No
Contact Call Detail	contacttype_code_desc	STRING	[contacttype_code_desc]	Yes	Yes	Contact Type Code Description
Contact Call Detail	contacttype_code_name	STRING	[contacttype_code_name]	Yes	No
Contact Call Detail	contacttype_code_value	NUMBER	[contacttype_code_value]	Yes	Yes	Contact Type Code Value
Contact Call Detail	customvariable1	STRING	[customvariable1]	Yes	Yes	Custom Variable 1
Contact Call Detail	customvariable2	STRING	[customvariable2]	Yes	Yes	Custom Variable 2
Contact Call Detail	customvariable3	STRING	[customvariable3]	Yes	Yes	Custom Variable 3
Contact Call Detail	customvariable4	STRING	[customvariable4]	Yes	Yes	Custom Variable 4
Contact Call Detail	customvariable5	STRING	[customvariable5]	Yes	Yes	Custom Variable 5
Contact Call Detail	customvariable6	STRING	[customvariable6]	Yes	Yes	Custom Variable 6
Contact Call Detail	customvariable7	STRING	[customvariable7]	Yes	No
Contact Call Detail	customvariable8	STRING	[customvariable8]	Yes	No
Contact Call Detail	customvariable9	STRING	[customvariable9]	Yes	Yes	Custom Variable 9
Contact Call Detail	customvariable10	STRING	[customvariable10]	Yes	Yes	Custom Variable 10
Contact Call Detail	dest_assignedteamid	NUMBER	[dest_assignedteamid]	Yes	No
Contact Call Detail	dest_dateinactive	STRING	[dest_dateinactive]	Yes	No
Contact Call Detail	dest_extension	NUMBER	[dest_extension]	Yes	No
Contact Call Detail	dest_is_active	NUMBER	[dest_is_active]	Yes	No
Contact Call Detail	dest_is_autoavail	NUMBER	[dest_is_autoavail]	Yes	No
Contact Call Detail	dest_orderinrg	STRING	[dest_orderinrg]	Yes	No
Contact Call Detail	dest_resourcefirstname	STRING	[dest_resourcefirstname]	Yes	No
Contact Call Detail	dest_resourcegroupid	STRING	[dest_resourcegroupid]	Yes	No
Contact Call Detail	dest_resourcelastname	STRING	[dest_resourcelastname]	Yes	No
Contact Call Detail	dest_resourceloginid	STRING	[dest_resourceloginid]	Yes	No
Contact Call Detail	dest_resourcename	STRING	[dest_resourcename]	Yes	No
Contact Call Detail	dest_resourceskillmapid	STRING	[dest_resourceskillmapid]	Yes	No
Contact Call Detail	dest_resourcetype	NUMBER	[dest_resourcetype]	Yes	No
Contact Call Detail	dest_resourcetype_desc	STRING	[dest_resourcetype_desc]	Yes	No
Contact Call Detail	destprotocolcallref	STRING	[destprotocolcallref]	Yes	No
Contact Call Detail	desttype_code_cat	STRING	[desttype_code_cat]	Yes	No
Contact Call Detail	desttype_code_desc	STRING	[desttype_code_desc]	Yes	Yes	Destination Type Code Description
Contact Call Detail	desttype_code_name	STRING	[desttype_code_name]	Yes	No
Contact Call Detail	desttype_code_value	NUMBER	[desttype_code_value]	Yes	Yes	Destination Type Code Value
Contact Call Detail	dispositionreason	STRING	[dispositionreason]	Yes	No
Contact Call Detail	flowout	NUMBER	[flowout]	Yes	Yes	Calls Flow Out
Contact Call Detail	last_updated_time	STRING	[last_updated_time]	Yes	No
Contact Call Detail	metservicelevel	NUMBER	[metservicelevel]	Yes	Yes	Calls Met Service Level
Contact Call Detail	nodeid	NUMBER	[nodeid]	Yes	Yes	Node ID
Contact Call Detail	orig_assignedteamid	NUMBER	[orig_assignedteamid]	Yes	No
Contact Call Detail	orig_dateinactive	STRING	[orig_dateinactive]	No	No
Contact Call Detail	orig_extension	NUMBER	[orig_extension]	Yes	Yes	Originator Extension
Contact Call Detail	orig_is_active	NUMBER	[orig_is_active]	Yes	No
Contact Call Detail	orig_is_autoavail	NUMBER	[orig_is_autoavail]	Yes	No
Contact Call Detail	orig_orderinrg	STRING	[orig_orderinrg]	Yes	No
Contact Call Detail	orig_resourcefirstname	STRING	[orig_resourcefirstname]	Yes	Yes	Originator Resource First Name
Contact Call Detail	orig_resourcegroupid	STRING	[orig_resourcegroupid]	Yes	No
Contact Call Detail	orig_resourcelastname	STRING	[orig_resourcelastname]	Yes	Yes	Originator Resource Last Name
Contact Call Detail	orig_resourceloginid	STRING	[orig_resourceloginid]	Yes	Yes	Originator Resource Login ID
Contact Call Detail	orig_resourcename	STRING	[orig_resourcename]	Yes	Yes	Originator Resource Name
Contact Call Detail	orig_resourcetype	NUMBER	[orig_resourcetype]	Yes	Yes	Originator Resource Type
Contact Call Detail	orig_resourcetype_desc	STRING	[orig_resourcetype_desc]	Yes	Yes	Originator Type Description
Contact Call Detail	origcallednumber	STRING	[origcallednumber]	Yes	No
Contact Call Detail	originatordn	STRING	[originatordn]	Yes	Yes	Originatordn
Contact Call Detail	origprotocolcallref	STRING	[origprotocolcallref]	Yes	No
Contact Call Detail	origtype_code_cat	STRING	[origtype_code_cat]	Yes	No
Contact Call Detail	origtype_code_desc	STRING	[origtype_code_desc]	Yes	Yes	Originator Type Code Description
Contact Call Detail	origtype_code_name	STRING	[origtype_code_name]	Yes	No
Contact Call Detail	origtype_code_value	NUMBER	[origtype_code_value]	Yes	Yes	Originator Type Code Value
Contact Call Detail	profileid	NUMBER	[profileid]	Yes	Yes	Profile ID
Contact Call Detail	redirect	NUMBER	[redirect]	Yes	Yes	Calls Redirected
Contact Call Detail	rig_resourceskillmapid	STRING	[rig_resourceskillmapid]	Yes	No
Contact Call Detail	sessionid	NUMBER	[sessionid]	Yes	Yes	Session ID
Contact Call Detail	sessionseqnum	NUMBER	[sessionseqnum]	Yes	Yes	Session Sequence Number
Contact Call Detail	transfer	NUMBER	[transfer]	Yes	Yes	Calls Transfered
Contact Queue Detail	acd_src	STRING	[acd_src]	Yes	Yes	Data Source
Contact Queue Detail	assignedteamid	NUMBER	[assignedteamid]	Yes	No
Contact Queue Detail	autowork	STRING	[autowork]	Yes	No
Contact Queue Detail	contactservicequeueid	NUMBER	[contactservicequeueid]	Yes	Yes	Contact Service Queue ID
Contact Queue Detail	cqd_call_startdatetime	DATE	[cqd_call_startdatetime]	Yes	Yes	Call Start Datetime - CQD
Contact Queue Detail	csq_dateinactive	STRING	[csq_dateinactive]	No	No
Contact Queue Detail	csq_is_active	NUMBER	[csq_is_active]	No	No
Contact Queue Detail	csq_resourcegroupid	STRING	[csq_resourcegroupid]	Yes	No
Contact Queue Detail	csqname	STRING	[csqname]	Yes	Yes	Contact Service Queue Name
Contact Queue Detail	disposition_code_cat	STRING	[disposition_code_cat]	Yes	No
Contact Queue Detail	disposition_code_desc	STRING	[disposition_code_desc]	Yes	Yes	Disposition Code Description
Contact Queue Detail	disposition_code_name	STRING	[disposition_code_name]	Yes	Yes	Disposition Code Name
Contact Queue Detail	disposition_code_value	NUMBER	[disposition_code_value]	Yes	Yes	Disposition Code Value
Contact Queue Detail	extension	NUMBER	[extension]	Yes	Yes	Extension
Contact Queue Detail	is_autoavail	NUMBER	[is_autoavail]	No	No
Contact Queue Detail	last_updated_time	STRING	[last_updated_time]	Yes	No
Contact Queue Detail	metservicelevel	NUMBER	[metservicelevel]	Yes	Yes	Calls Met Service Level
Contact Queue Detail	nodeid	NUMBER	[nodeid]	Yes	Yes	Node ID
Contact Queue Detail	orderinrg	STRING	[orderinrg]	Yes	No
Contact Queue Detail	orderlist	STRING	[orderlist]	Yes	No
Contact Queue Detail	privatedata	STRING	[privatedata]	Yes	No
Contact Queue Detail	profileid	NUMBER	[profileid]	Yes	Yes	Profile ID
Contact Queue Detail	prompt	STRING	[prompt]	Yes	No
Contact Queue Detail	qindex	NUMBER	[qindex]	Yes	Yes	Qindex
Contact Queue Detail	queuealgorithm	STRING	[queuealgorithm]	Yes	No
Contact Queue Detail	queuecount	NUMBER	[queuecount]	Yes	Yes	Queue Count - CQD
Contact Queue Detail	queueorder	STRING	[queueorder]	Yes	No
Contact Queue Detail	queuetime	NUMBER	[queuetime]	Yes	Yes	Queue Time - CQD
Contact Queue Detail	queuetype	NUMBER	[queuetype]	Yes	No
Contact Queue Detail	queuetype_desc	STRING	[queuetype_desc]	Yes	No
Contact Queue Detail	recordid	NUMBER	[recordid]	Yes	Yes	Contact Service Queue Record ID
Contact Queue Detail	resource_dateinactive	STRING	[resource_dateinactive]	No	No
Contact Queue Detail	resource_is_active	NUMBER	[resource_is_active]	No	No
Contact Queue Detail	resourcefirstname	STRING	[resourcefirstname]	Yes	Yes	Resource Firstname
Contact Queue Detail	resourcegroupid	STRING	[resourcegroupid]	Yes	No
Contact Queue Detail	resourcelastname	STRING	[resourcelastname]	Yes	Yes	Resource Lastname
Contact Queue Detail	resourceloginid	STRING	[resourceloginid]	Yes	Yes	Resource Login ID
Contact Queue Detail	resourcename	STRING	[resourcename]	Yes	Yes	Resource Name
Contact Queue Detail	resourcepooltype	STRING	[resourcepooltype]	Yes	No
Contact Queue Detail	resourceskillmapid	STRING	[resourceskillmapid]	Yes	No
Contact Queue Detail	resourcetype	NUMBER	[resourcetype]	Yes	Yes	Resource Type
Contact Queue Detail	resourcetype_desc	STRING	[resourcetype_desc]	Yes	Yes	Resource Type Description
Contact Queue Detail	selectioncriteria	STRING	[selectioncriteria]	Yes	No
Contact Queue Detail	servicelevel	NUMBER	[servicelevel]	Yes	Yes	Contact Service Queue Service Level
Contact Queue Detail	servicelevelpercentage	NUMBER	[servicelevelpercentage]	Yes	Yes	Contact Service Queue Service Level Percentage
Contact Queue Detail	sessionid	NUMBER	[sessionid]	Yes	Yes	Session ID
Contact Queue Detail	sessionseqnum	NUMBER	[sessionseqnum]	Yes	Yes	Session Sequence Number
Contact Queue Detail	skillgroupid	STRING	[skillgroupid]	Yes	No
Contact Queue Detail	targetid	STRING	[targetid]	Yes	Yes	CQD Target Id
Contact Queue Detail	targettype	STRING	[targettype]	Yes	Yes	CQD Target Type
Contact Queue Detail	wrapuptime	NUMBER	[wrapuptime]	Yes	Yes	Wrapup Time