McDewey

Keys and NULL Option Data Type Description Name NULL DBINT Indicates the internal code corresponding to the SIP response received from the gateway for outbound dialer calls. The internal code is calculated as 10000

• SIP response code. For example: If the SIP gateway returns a 400 Bad Request response: CallResultDetail = 10400 For Personal Callback calls, CallResultDetail reflects the agent's status when the callback cannot be completed: 20000: Agent Logged Out 20001: Agent Not Ready CallResultDetail NULL CHAR(1) Status of the customer record for Zone1. For the values that can populate this field, see Dialer Detail: CallStatusZone, on page 660. CallStatusZone1 NULL CHAR(1) Status of the customer record for Zone2. For the values that can populate this field, see Dialer Detail: CallStatusZone, on page 660. CallStatusZone2 IE2 NULL DBDATETIME This value indicates interval date time that Router used TCD record to calculate Call Type related historical data. CampaignReportingDateTime FK NULL DBINT The campaign that the call was placed for. CampaignID NULL DBINT The value is the offset in minutes that the customer is from UTC (formerly GMT). Note CustomerTimeZone for PCB calls in Dialer_Detail is always NULL. CustomerTimeZone IE5 NOT NULL DBDATETIME DateTime (in Central Controller local time) at the start of the interval when the row was generated. DateTime IE1 NULL DBDATETIME DateTime (in Central Controller local time) when the records are written to the HDS database. The logger database has NULL for this column. DbDateTime Database Schema Handbook for Cisco Unified Contact Center Enterprise, Release 15.0(1) 227 All Tables Dialer_Detail