Jump to: navigation, search
(Created page with "= View CDR= Category:V:GIM:8.5DRAFT")
 
(Created page with "= View CDR= Category:V:GIM:8.5DRAFT")
Line 1: Line 1:
−
= View CDR=
+
= View CDR =
 +
 
 +
<onlyinclude>
 +
 
 +
{{PDMView
 +
|viewName = CDR
 +
|shortDesc =
 +
|viewDesc =
 +
|introduced =
 +
|SQL =  <source lang="xml" enclose="div">select
 +
irf.INTERACTION_RESOURCE_ID as ID,
 +
irf.INTERACTION_ID as INTERACTION_ID,
 +
mt.MEDIA_NAME_CODE as MEDIA_TYPE,
 +
it.INTERACTION_TYPE_CODE as INTERACTION_TYPE,
 +
ixn.SOURCE_ADDRESS as ORIGINATOR,
 +
ixn.TARGET_ADDRESS as TARGET,
 +
r.RESOURCE_TYPE_CODE as PARTY_TYPE,
 +
r.RESOURCE_NAME as PARTY_NAME,
 +
ixn.STATUS as STATUS,
 +
irf.START_TS-irf.MEDIATION_DURATION as START_TS,
 +
irf.END_TS-irf.AFTER_CALL_WORK_DURATION-irf.CONS_RCV_ACW_DURATION as END_TS,
 +
sdt.LABEL_TZ as TIME_ZONE_CODE,
 +
CONVERT(varchar,DATEADD(SECOND, irf.START_TS-irf.MEDIATION_DURATION
 +
-sdt.DATE_TIME_KEY,sdt.CAL_DATE),120) as START_DATE_TIME_STRING,
 +
CONVERT(varchar,DATEADD(SECOND, irf.END_TS-irf.AFTER_CALL_WORK_DURATION-irf.CONS_RCV_ACW_DURATION
 +
-edt.DATE_TIME_KEY,edt.CAL_DATE),120) as END_DATE_TIME_STRING,
 +
case when irf.INTERACTION_RESOURCE_ORDINAL = 1
 +
then 1
 +
else 0
 +
end as FIRST_LEG_FLAG,
 +
case when (
 +
irf.TALK_COUNT+
 +
irf.POST_CONS_XFER_TALK_COUNT+
 +
irf.CONF_INIT_TALK_COUNT+
 +
irf.CONF_JOIN_TALK_COUNT+
 +
irf.CONS_INIT_TALK_COUNT+
 +
irf.CONS_RCV_TALK_COUNT>0) then 1 else 0
 +
end as CONNECTED_FLAG,
 +
irf.END_TS- irf.AFTER_CALL_WORK_DURATION-irf.CONS_RCV_ACW_DURATION-irf.START_TS+irf.MEDIATION_DURATION as ELAPSED_DURATION,
 +
irf.TALK_DURATION+irf. POST_CONS_XFER_TALK_DURATION as ENGAGE_DURATION,
 +
irf.CONF_INIT_TALK_DURATION+irf.CONF_JOIN_TALK_DURATION as CONFERENCE_ENGAGE_DURATION,
 +
irf.CONS_INIT_TALK_DURATION+irf.CONS_RCV_TALK_DURATION as CONSULTATION_ENGAGE_DURATION,
 +
irf.CONS_INIT_HOLD_DURATION+irf.CONS_RCV_HOLD_DURATION+ irf.CONF_INIT_HOLD_DURATION+irf.CONF_JOIN_HOLD_DURATION+ irf.HOLD_DURATION+irf.POST_CONS_XFER_HOLD_DURATION as HOLD_DURATION,
 +
irf.INTERACTION_RESOURCE_ORDINAL as ORDINAL,
 +
td.TECHNICAL_RESULT_CODE as TECHNICAL_RESULT,
 +
td.RESOURCE_ROLE_CODE as PARTY_ROLE,
 +
irf.TENANT_KEY as TENANT_KEY
 +
from
 +
INTERACTION_RESOURCE_FACT irf
 +
join MEDIA_TYPE mt on irf.MEDIA_TYPE_KEY = mt.MEDIA_TYPE_KEY
 +
join INTERACTION_TYPE it on irf.INTERACTION_TYPE_KEY = it.INTERACTION_TYPE_KEY
 +
join INTERACTION_FACT ixn on irf.INTERACTION_ID = ixn.INTERACTION_ID and irf.INTERACTION_SDT_KEY=ixn.START_DATE_TIME_KEY
 +
join RESOURCE_ r on irf.RESOURCE_KEY = r.RESOURCE_KEY
 +
join CDR_DATE_TIME sdt on sdt.DATE_TIME_KEY = ((irf.START_TS-irf.MEDIATION_DURATION)/900)*900
 +
join CDR_DATE_TIME edt on edt.DATE_TIME_KEY = ((irf.END_TS-irf.AFTER_CALL_WORK_DURATION-irf.CONS_RCV_ACW_DURATION)/900)*900
 +
join TECHNICAL_DESCRIPTOR td on irf.TECHNICAL_DESCRIPTOR_KEY = td.TECHNICAL_DESCRIPTOR_KEY
 +
 
 +
</source>
 +
}}
 +
 
 +
{{PDMViewColumn
 +
|colName = ID
 +
|colDesc =
 +
}}
 +
 
 +
{{PDMViewColumn
 +
|colName = INTERACTION_ID
 +
|colDesc =
 +
}}
 +
 
 +
{{PDMViewColumn
 +
|colName = MEDIA_TYPE
 +
|colDesc =
 +
}}
 +
 
 +
{{PDMViewColumn
 +
|colName = INTERACTION_TYPE
 +
|colDesc =
 +
}}
 +
 
 +
{{PDMViewColumn
 +
|colName = ORIGINATOR
 +
|colDesc =
 +
}}
 +
 
 +
{{PDMViewColumn
 +
|colName = TARGET
 +
|colDesc =
 +
}}
 +
 
 +
{{PDMViewColumn
 +
|colName = PARTY_TYPE
 +
|colDesc =
 +
}}
 +
 
 +
{{PDMViewColumn
 +
|colName = PARTY_NAME
 +
|colDesc =
 +
}}
 +
 
 +
{{PDMViewColumn
 +
|colName = STATUS
 +
|colDesc =
 +
}}
 +
 
 +
{{PDMViewColumn
 +
|colName = START_TS
 +
|colDesc = The UTC-equivalent value of the date and time when the calling list was added to IDB, which may differ from when the calling list was actually added to contact center configuration.
 +
}}
 +
 
 +
{{PDMViewColumn
 +
|colName = END_TS
 +
|colDesc = The UTC-equivalent value of the date and time when the calling list was removed from contact center configuration.
 +
}}
 +
 
 +
{{PDMViewColumn
 +
|colName = TIME_ZONE_CODE
 +
|colDesc =
 +
}}
 +
 
 +
{{PDMViewColumn
 +
|colName = START_DATE_TIME_STRING
 +
|colDesc =
 +
}}
 +
 
 +
{{PDMViewColumn
 +
|colName = END_DATE_TIME_STRING
 +
|colDesc =
 +
}}
 +
 
 +
{{PDMViewColumn
 +
|colName = FIRST_LEG_FLAG
 +
|colDesc =
 +
}}
 +
 
 +
{{PDMViewColumn
 +
|colName = CONNECTED_FLAG
 +
|colDesc =
 +
}}
 +
 
 +
{{PDMViewColumn
 +
|colName = ELAPSED_DURATION
 +
|colDesc =
 +
}}
 +
 
 +
{{PDMViewColumn
 +
|colName = ENGAGE_DURATION
 +
|colDesc =
 +
}}
 +
 
 +
{{PDMViewColumn
 +
|colName = CONFERENCE_ENGAGE_DURATION
 +
|colDesc =
 +
}}
 +
 
 +
{{PDMViewColumn
 +
|colName = CONSULTATION_ENGAGE_DURATION
 +
|colDesc =
 +
}}
 +
 
 +
{{PDMViewColumn
 +
|colName = HOLD_DURATION
 +
|colDesc =
 +
}}
 +
 
 +
{{PDMViewColumn
 +
|colName = ORDINAL
 +
|colDesc =
 +
}}
 +
 
 +
{{PDMViewColumn
 +
|colName = TECHNICAL_RESULT
 +
|colDesc =
 +
}}
 +
 
 +
{{PDMViewColumn
 +
|colName = PARTY_ROLE
 +
|colDesc =
 +
}}
 +
 
 +
{{PDMViewColumn
 +
|colName = TENANT_KEY
 +
|colDesc = The surrogate key that is used to join to the TENANT dimension.
 +
}}
 +
 
 +
{{PDMRef
 +
|parentTable = INTERACTION_FACT
 +
|foreignKey = INTERACTION_ID
 +
}}
 +
 
 +
{{PDMRef
 +
|parentView = TENANT
 +
|foreignKey = TENANT_KEY
 +
}}
 +
 
 +
</onlyinclude>
  
 
[[Category:V:GIM:8.5DRAFT]]
 
[[Category:V:GIM:8.5DRAFT]]

Revision as of 09:00, May 9, 2016

View CDR

Description

Reserved

Column List

Column Description
ID
INTERACTION_ID
MEDIA_TYPE
INTERACTION_TYPE
ORIGINATOR
TARGET
PARTY_TYPE
PARTY_NAME
STATUS
START_TS The UTC-equivalent value of the date and time when the calling list was added to IDB, which may differ from when the calling list was actually added to contact center configuration.
END_TS The UTC-equivalent value of the date and time when the calling list was removed from contact center configuration.
TIME_ZONE_CODE
START_DATE_TIME_STRING
END_DATE_TIME_STRING
FIRST_LEG_FLAG
CONNECTED_FLAG
ELAPSED_DURATION
ENGAGE_DURATION
CONFERENCE_ENGAGE_DURATION
CONSULTATION_ENGAGE_DURATION
HOLD_DURATION
ORDINAL
TECHNICAL_RESULT
PARTY_ROLE
TENANT_KEY The surrogate key that is used to join to the TENANT dimension.


References

The summary List of References will include the following entries for this table or view:


Child Table/View Child Table/View Column Parent Table/View Parent Table/View Column
CDR INTERACTION_ID INTERACTION_FACT INTERACTION_ID
CDR TENANT_KEY TENANT TENANT_KEY
Comments or questions about this documentation? Contact us for support!