table schema

CREATE TABLE [dbo].[Termination_Call_Detail](
	[RecoveryKey] [bigint] NOT NULL,
	[MRDomainID] [bigint] NOT NULL DEFAULT ((0)),
	[AgentSkillTargetID] [bigint] NULL DEFAULT (NULL),
	[SkillGroupSkillTargetID] [bigint] NULL DEFAULT (NULL),
	[ServiceSkillTargetID] [bigint] NULL DEFAULT (NULL),
	[PeripheralID] [bigint] NOT NULL,
	[RouteID] [bigint] NULL DEFAULT (NULL),
	[RouterCallKeyDay] [bigint] NULL DEFAULT (NULL),
	[RouterCallKey] [bigint] NULL DEFAULT (NULL),
	[DateTime] [datetime] NOT NULL,
	[UTC_DateTime] [int] NULL DEFAULT (NULL),
	[PeripheralCallType] [int] NULL DEFAULT (NULL),
	[DigitsDialed] [varchar](40) NULL DEFAULT (NULL),
	[PeripheralCallKey] [int] NULL DEFAULT (NULL),
	[CallDisposition] [int] NOT NULL,
	[NetworkTime] [int] NULL DEFAULT (NULL),
	[NetworkSkillGroupQTime] [bigint] NULL DEFAULT (NULL),
	[Duration] [int] NULL DEFAULT (NULL),
	[ECCPayloadID] [bigint] NULL DEFAULT (NULL),
	[EnterpriseQueueTime] [bigint] NULL DEFAULT (NULL),
	[RingTime] [int] NULL DEFAULT (NULL),
	[DelayTime] [int] NULL DEFAULT (NULL),
	[TimeToAband] [int] NULL DEFAULT (NULL),
	[HoldTime] [int] NULL DEFAULT (NULL),
	[TalkTime] [int] NULL DEFAULT (NULL),
	[WorkTime] [int] NULL DEFAULT (NULL),
	[LocalQTime] [int] NULL DEFAULT (NULL),
	[LocationParamPKID] [varchar](128) NULL DEFAULT (NULL),
	[LocationParamName] [varchar](50) NULL DEFAULT (NULL),
	[BillRate] [int] NULL DEFAULT (NULL),
	[CallSegmentTime] [int] NULL DEFAULT (NULL),
	[ConferenceTime] [int] NULL DEFAULT (NULL),
	[Variable1] [varchar](40) NULL DEFAULT (NULL),
	[Variable2] [varchar](40) NULL DEFAULT (NULL),
	[Variable3] [varchar](40) NULL DEFAULT (NULL),
	[Variable4] [varchar](40) NULL DEFAULT (NULL),
	[Variable5] [varchar](40) NULL DEFAULT (NULL),
	[UserToUser] [varchar](131) NULL DEFAULT (NULL),
	[NewTransaction] [char](1) NULL DEFAULT (NULL),
	[Originated] [char](1) NULL DEFAULT (NULL),
	[RecoveryDay] [int] NOT NULL,
	[TimeZone] [int] NULL DEFAULT (NULL),
	[NetworkTargetID] [int] NULL DEFAULT (NULL),
	[TrunkGroupID] [int] NULL DEFAULT (NULL),
	[DNIS] [varchar](32) NULL DEFAULT (NULL),
	[InstrumentPortNumber] [int] NULL DEFAULT (NULL),
	[AgentPeripheralNumber] [varchar](32) NULL DEFAULT (NULL),
	[ICRCallKey] [int] NOT NULL,
	[ICRCallKeyParent] [int] NULL DEFAULT (NULL),
	[ICRCallKeyChild] [int] NULL DEFAULT (NULL),
	[Variable6] [varchar](40) NULL DEFAULT (NULL),
	[Variable7] [varchar](40) NULL DEFAULT (NULL),
	[Variable8] [varchar](40) NULL DEFAULT (NULL),
	[Variable9] [varchar](40) NULL DEFAULT (NULL),
	[Variable10] [varchar](40) NULL DEFAULT (NULL),
	[ANI] [varchar](32) NULL DEFAULT (NULL),
	[AnsweredWithinServiceLevel] [char](1) NULL DEFAULT (NULL),

	[Priority] [int] NULL DEFAULT (NULL),
	[ProtocolID] [bigint] NULL DEFAULT (NULL),
	[PstnTrunkGroupID] [varchar](32) NULL DEFAULT (NULL),
	[PstnTrunkGroupChannelNumber] [bigint] NULL DEFAULT (NULL),
	[Trunk] [int] NULL DEFAULT (NULL),
	[WrapupData] [varchar](40) NULL DEFAULT (NULL),
	[SourceAgentPeripheralNumber] [varchar](32) NULL DEFAULT (NULL),
	[SourceAgentSkillTargetID] [int] NULL DEFAULT (NULL),
	[StartDateTimeUTC] [datetime] NULL DEFAULT (NULL),
	[CallDispositionFlag] [int] NULL DEFAULT (NULL),
	[RouterCallKeySequenceNumber] [int] NULL DEFAULT (NULL),
	[RoutedSkillGroupSkillTargetID] [bigint] NULL DEFAULT (NULL),
	[RoutedServiceSkillTargetID] [bigint] NULL DEFAULT (NULL),
	[CED] [varchar](30) NULL DEFAULT (NULL),
	[CallTypeID] [int] NULL DEFAULT (NULL),
	[CallTypeReportingDateTime] [datetime] NULL DEFAULT (NULL),
	[UTC_CallTypeReportingDateTime] [int] NULL DEFAULT (NULL),
	[CallReferenceID] [varchar](32) NULL DEFAULT (NULL),
	[CallGUID] [varchar](32) NULL DEFAULT (NULL),
	[BadCallTag] [char](1) NULL DEFAULT (NULL),
	[ApplicationTaskDisposition] [int] NULL DEFAULT (NULL),
	[ApplicationData] [varchar](100) NULL DEFAULT (NULL),
	[NetQTime] [int] NULL DEFAULT (NULL),
	[DbDateTime] [datetime] NULL DEFAULT (NULL),
	[UTC_DbDateTime] [int] NULL DEFAULT (NULL),
	[OrigDialedNumberID] [bigint] NULL DEFAULT (NULL),
	[DialedNumberID] [bigint] NULL DEFAULT (NULL),
 CONSTRAINT [PK_Termination_Call_Detail_RecoveryKey] PRIMARY KEY CLUSTERED
(
	[RecoveryKey] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = ON, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]