

/****** Object:  Table [dbo].[QA_AgentDetails]    Script Date: 11/9/2019 2:56:43 PM ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[QA_AgentDetails](
	[Q_id] [int] IDENTITY(1,1) NOT NULL,
	[P_id] [int] NULL,
	[Agent_Name] [varchar](50) NULL,
	[Auditor_Name] [varchar](50) NULL,
	[Customer_Name] [varchar](50) NULL,
	[Date_of_Call] [datetime] NULL,
	[Date_of_Audit] [datetime] NULL,
	[Mobile] [varchar](12) NULL,
	[Brand] [varchar](50) NULL,
	[Month] [varchar](10) NULL,
	[AHT] [varchar](15) NULL,
	[External_Performance] [int] NULL,
	[Internal_Performance] [int] NULL,
	[Fatal_Error_Call] [int] NULL,
	[call_summary] [varchar](max) NULL,
	[areas_of_strength] [varchar](max) NULL,
	[areas_of_development] [varchar](max) NULL,
	[RecordingUrl] [varchar](400) NULL,
	[CallerEMPID] [varchar](20) NULL,
	[TLname] [varchar](50) NULL,
	[Disposition] [varchar](15) NULL,
	[ManagerName] [varchar](50) NULL,
	[LeadID] [varchar](10) NULL,
	[LeadStatusTime] [varchar](12) NULL,
	[Audit] [varchar](50) NULL,
	[CallDuration] [varchar](10) NULL,
	[Week] [varchar](10) NULL,
	[LeadSource] [varchar](50) NULL,
	[EvaluationMode] [varchar](50) NULL,
	[ACPT] [varchar](50) NULL,
	[log_id] [varchar](50) NULL,
	[FTR] [varchar](50) NULL,
	[Call_Class] [varchar](50) NULL,
	[Verifier_Code] [varchar](50) NULL,
	[No_Of_Call_Recordings] [varchar](50) NULL,
	[time_stamp] [timestamp] NOT NULL,
 CONSTRAINT [PK_QA_AgentDetails] PRIMARY KEY CLUSTERED 
(
	[Q_id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO

---------------------------

/****** Object:  Table [dbo].[QA_Assign_Log]    Script Date: 11/13/2019 11:11:47 AM ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[QA_Assign_Log](
	[Id] [int] IDENTITY(1,1) NOT NULL,
	[Log_Id] [varchar](100) NULL,
	[Manager] [varchar](30) NULL,
	[Assign_To] [varchar](30) NULL,
	[Assign_date] [varchar](50) NULL,
	[Process_ID] [int] NULL
) ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO

----------------------------------------


alter table QA_AgentDetails add FTR varchar(30)
alter table QA_AgentDetails add Call_Class varchar(50)
alter table QA_AgentDetails add Verifier_Code varchar(50)
alter table QA_AgentDetails add No_Of_Call_Recordings varchar(50)

alter table QA_Parameter_Master add Font_Color varchar(50)
alter table QA_Parameter_Master add BackGround_Color varchar(50)

alter table QA_Page_Master1 add CallStatus varchar(100)
Alter table QA_Page_Master1 ADD QA_Start_Date date
Alter table QA_Page_Master1 ADD QAProcess_ID int

alter table process_1_Log add status varchar(50)
alter table process_1_Log add QA_Assign_Agent varchar(50)
alter table process_1_Log add QA_Disposition varchar(50)
alter table process_1_Log add QA_Assign_TLAgent varchar(50)







