CREATE VIEW vwdetailedinteractiondata AS (
 SELECT di.keyid,
    di.conversationid,
    di.conversationstartdate,
    di.conversationstartdateltc,
    di.conversationenddate,
    di.conversationenddateltc,
    di.conversationminmos,
    di.conversationminrfactor,
    di.originaldirection,
    di.participantid,
    di.participantname,
    di.purpose,
    di.mediatype,
    di.externaltag,
    di.ani,
    di.dnis,
    di.sessiondnis,
    di.edgeid,
    di.gencode,
    di.remotedisplayable,
    di.segmentstartdate,
    di.segmentstartdateltc,
    di.segmentenddate,
    di.segmentenddateltc,
    di.segmenttime,
    di.convtosegmentstarttime,
    di.convtosegmentendtime,
    (di.segmenttime / 86400.00) AS segmenttimeday,
    (di.convtosegmentstarttime / 86400.00) AS convtosegmentstarttimeday,
    (di.convtosegmentendtime / 86400.00) AS convtosegmentendtimeday,
    di.segmenttype,
    di.conference,
    di.disconnectiontype,
    di.wrapupcode,
    di.wrapupnote,
    wd.name AS wrapupdesc,
    di.recordingexists,
    di.sessionprovider,
    di.flowid,
    di.flowname,
    di.flowversion,
    di.flowtype,
    di.exitreason,
    di.entryreason,
    di.entrytype,
    di.transfertype,
    di.transfertargetname,
    di.queueid,
    qd.name AS queuename,
    di.userid,
    ud.name AS agentname,
    ud.managerid,
    ud.managername,
    di.issuedcallback,
    di.nflow,
    di.tivr,
    (di.tivr / 86400.00) AS tivrday,
    di.tflow,
    (di.tflow / 86400.00) AS tflowday,
    di.tflowdisconnect,
    (di.tflowdisconnect / 86400.00) AS tflowdisconnectday,
    di.tflowexit,
    (di.tflowexit / 86400.00) AS tflowexitday,
    di.tflowout,
    (di.tflowout / 86400.00) AS tflowoutday,
    di.tacd,
    (di.tacd / 86400.00) AS tacdday,
    di.tacw,
    (di.tacw / 86400.00) AS tacwday,
    di.talert,
    (di.talert / 86400.00) AS talertday,
    di.tanswered,
    (di.tanswered / 86400.00) AS tansweredday,
    di.ttalk,
    (di.ttalk / 86400.00) AS ttalkday,
    di.ttalkcomplete,
    (di.ttalkcomplete / 86400.00) AS ttalkcompleteday,
    di.thandle,
    (di.thandle / 86400.00) AS thandleday,
    di.tcontacting,
    (di.tcontacting / 86400.00) AS tcontactingday,
    di.tdialing,
    (di.tdialing / 86400.00) AS tdialingday,
    di.tnotresponding,
    (di.tnotresponding / 86400.00) AS tnotrespondingday,
    di.tabandon,
    (di.tabandon / 86400.00) AS tabandonday,
    di.theld,
    (di.theld / 86400.00) AS theldday,
    di.theldcomplete,
    (di.theldcomplete / 86400.00) AS theldcompleteday,
    di.tvoicemail,
    (di.tvoicemail / 86400.00) AS tvoicemailday,
    di.tmonitoring,
    (di.tmonitoring / 86400.00) AS tmonitoringday,
    di.noffered,
    di.nconnected,
    di.nconsult,
    di.nconsulttransferred,
    di.ntransferred,
    di.nblindtransferred,
    di.nerror,
    di.noutbound,
    di.nstatetransitionerror,
    di.noversla,
    di.nbotinteractions,
    di.tpark,
    di.tparkcomplete,
    di.omessagecount,
    di.omessagesegmentcount,
    di.omessageturn,
    di.sessiondirection,
    di.segdestinationconversationid,
    di.divisionid,
    dd.name AS divisionname,
    di.updated,
    di.sessionid,
    di.protocolcallid,
    di.remotenamedisplayable,
    di.callbackusername,
    di.callbacknumbers,
    di.scriptid,
    di.skipenabled,
    di.timeoutseconds,
    di.flowouttype,
    di.roomid,
    di.callbackscheduledtime,
    di.transfertargetaddress,
    di.startinglanguage,
    di.endinglanguage,
    di.requestedroutingskillids,
    di.sipresponsecodes,
    di.q850responsecodes,
    di.errorcode,
    di.requestedlanguageid,
    di.externalcontactid,
    di.externalorganizationid,
    di.codecs,
    di.minmos,
    di.minrfactor,
    di.maxlatencyms,
    di.receivedpackets,
    di.discardedpackets,
    di.overrunpackets,
    di.invalidpackets,
    di.duplicatepackets
   FROM ((((detailedinteractiondata di
     LEFT JOIN vwuserdetail ud ON (((ud.id)::text = (di.userid)::text)))
     LEFT JOIN queuedetails qd ON (((qd.id)::text = (di.queueid)::text)))
     LEFT JOIN wrapupdetails wd ON (((wd.id)::text = (di.wrapupcode)::text)))
     LEFT JOIN divisiondetails dd ON (((dd.id)::text = (di.divisionid)::text)))
)