CREATE VIEW vwconvvoiceoverviewdata AS (
 SELECT cv.conversationid,
    cv.sentimentscore,
    cv.sentimenttrend,
    cv.agentdurationpercentage,
    cv.customerdurationpercentage,
    cv.silencedurationpercentage,
    cv.overtalkdurationpercentage,
    cv.overtalkcount,
    cv.ivrdurationpercentage,
    cv.acddurationpercentage,
    cv.otherdurationpercentage,
    cs.conversationstartdate,
    cs.conversationstartdateltc,
    cs.conversationenddate,
    cs.conversationenddateltc,
    cs.ttalkcomplete,
    cs.ani,
    cs.dnis,
    cs.firstmediatype,
    cs.divisionid,
    cs.firstqueueid,
    cs.firstqueuename,
    cs.lastqueueid,
    cs.lastqueuename,
    cs.firstagentid,
    cs.firstagentname,
    cs.firstagentdepartment AS firstagentdept,
    cs.firstagentmanager AS firstagentmanagerid,
    cs.firstagentmanager AS firstagentmanagername,
    cs.lastagentid,
    cs.lastagentname,
    cs.lastagentdepartment AS lastagentdept,
    cs.lastagentmanager AS lastagentmanagerid,
    cs.lastagentmanager AS lastagentmanagername,
    cs.firstwrapupcode,
    cs.firstwrapname AS firstwrapupname,
    cs.lastwrapupcode,
    cs.lastwrapname AS lastwrapupname,
    dd.name AS divisionname
   FROM ((convvoiceoverviewdata cv
     LEFT JOIN vwconvsummarydata cs ON (((cs.conversationid)::text = (cv.conversationid)::text)))
     LEFT JOIN divisiondetails dd ON (((cs.divisionid)::text = (dd.id)::text)))
)