USE [Patient_Data]
GO

/****** Object:  Table [dbo].[tbPDFConverterSettings]    Script Date: 05/26/2014 18:21:12 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[tbPDFConverterSettings](
	[HospitalID] [int] NULL,
	[Title] [varchar](60) NULL,
	[Company] [varchar](100) NULL,
	[Address1] [varchar](70) NULL,
	[TinNo] [varchar](30) NULL,
	[PhoneNum] [varchar](30) NULL,
	[RecordOfficer] [varchar](50) NULL,
	[PediaAgeLimit] [int] NULL,
	[NewbornServiceID] [varchar](2) NULL,
	[DiedResultID] [varchar](1) NULL,
	[AutopsyResultID] [varchar](1) NULL,
	[CompanyLogo] [image] NULL,
	[SeniorDiscount] [float] NULL,
	[MTSServerName] [varchar](50) NULL,
	[ServerName] [varchar](50) NULL,
	[ByGeneric] [bit] NOT NULL,
	[CashEmployeeDiscount] [float] NULL,
	[CashEmployeeDiscount2] [float] NULL,
	[IsNursePrint] [bit] NOT NULL,
	[IsDRPrint] [bit] NOT NULL,
	[IsERprint] [bit] NOT NULL,
	[IsICPrint] [bit] NOT NULL,
	[IsNUPrint] [bit] NOT NULL,
	[IsORPrint] [bit] NOT NULL,
	[IsDIPrint] [bit] NOT NULL,
	[IsLBDirectCharging] [bit] NOT NULL,
	[IsXRDirectCharging] [bit] NOT NULL,
	[IsUSDirectCharging] [bit] NOT NULL,
	[IsCTDirectCharging] [bit] NOT NULL,
	[IsHSDirectCharging] [bit] NOT NULL,
	[RecordOfficerPosition] [varchar](50) NULL,
	[isERDirectcharging] [bit] NULL,
	[ConversionPath] [varchar](100) NULL,
	[FaxPath] [varchar](100) NULL,
	[LocalAccessNum] [int] NULL,
	[FaxWaitingTime] [int] NOT NULL,
	[WaitingTime] [int] NOT NULL,
	[SMTP_Server] [varchar](100) NULL,
	[SenderName] [varchar](100) NULL,
	[SenderEmail] [varchar](100) NULL,
	[EmailUsername] [varchar](50) NULL,
	[EmailPassword] [varchar](20) NULL,
	[ResendTime] [int] NULL,
	[FaxResendTime] [int] NULL,
	[RefreshTime] [int] NULL,
	[FaxRefreshTime] [int] NULL,
	[NotConvertedTime] [int] NULL,
	[FaxUnchargedTime] [int] NULL,
	[DefaultMessage] [text] NULL,
	[SpecFloatingTime] [int] NULL,
	[ClientName] [varchar](50) NULL,
	[OPDPassword] [varchar](20) NULL,
	[ConvertCashPatient] [int] NULL,
	[AutoStart] [int] NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO



                                                                             

                                                           
ALTER TABLE LABORATORY..TBLABMASTER
ADD QueueTag char(1),
	ConvertStatus varchar(1)

go



USE [Laboratory]
GO

/****** Object:  StoredProcedure [dbo].[Lab_ConvertPDF_ReportStatus]    Script Date: 03/21/2014 10:40:58 ******/
SET ANSI_NULLS OFF
GO

SET QUOTED_IDENTIFIER OFF
GO


CREATE PROCEDURE [dbo].[Lab_ConvertPDF_ReportStatus]
@StartDate as varchar(10),
@EndDate as varchar(10)

AS

SELECT	LM.QueueTag,
		LM.RefNum, 
		VM.LastName, 
		VM.Firstname, 
		VM.MiddleName, 
		E.LabExam, 
		S.LabSection, 
		convert(varchar(10),LB.VerifyDate,101) Verifydate
FROM	LABORATORY..tblablogbook LB
		left outer join tblabMaster LM on LM.requestnum = LB.requestNum	
		left outer join dbo.vwPatientResultEntry VM on LM.Hospnum = VM.Hospnum
		left outer join BUILD_FILE..tbCoLabExam E on LM.ItemID = E.LabExamID
		left outer join BUILD_FILE..tbColabSection S on LM.SectionID = S.LabSectionID
WHERE	LM.ConvertStatus = 'S' 
		AND (LB.Verifydate between @StartDate and @EndDate + ' 23:59:59.99')
ORDER BY LB.VerifyDate,VM.LastName,VM.FirstName,VM.MiddleName 

GO


ALTER TABLE LABORATORY..TBLABMASTER
ADD EmailStatus varchar(1)
GO

USE [Laboratory]
GO

/****** Object:  StoredProcedure [dbo].[Lab_ConvertPDF_SetfgridQueue]    Script Date: 03/21/2014 11:04:20 ******/
SET ANSI_NULLS OFF
GO

SET QUOTED_IDENTIFIER OFF
GO


CREATE PROCEDURE [dbo].[Lab_ConvertPDF_SetfgridQueue] 
@VerifyDate varchar(10)
AS

	BEGIN
		SELECT	TOP 10
				LM.HospNum, 
				LM.RequestNum,
				LM.RefNum, 
				LM.SectionID, 
				LM.QueueTag, 
				LM.SpecimenID,
				CLE.LabExam, 
				CLS.LabSection, 
				V.LastName, 
				V.FirstName, 
				V.MiddleName, 
				LLB.VerifyDate, 
				LLB.AccessionNum, 
				LM.UserId
		FROM	Laboratory..tbLabLogBook LLB 
				LEFT OUTER JOIN Laboratory..tbLabMaster LM ON LM.RequestNum = LLB.RequestNum
				LEFT OUTER JOIN Laboratory.dbo.vwPatientResultEntry V ON LM.HospNum = V.hospnum
				LEFT OUTER JOIN Build_File..tbCoLabExam CLE ON LM.ItemID = CLE.LabExamID
				LEFT OUTER JOIN Build_File..tbCoLabSection CLS ON LM.SectionID = CLS.LabSectionID
		WHERE	(LLB.VerifyDate between @VerifyDate and @VerifyDate + ' 23:59:59.99') AND
				 LM.RequestStatus = 'W' 
				 AND (LM.ConvertStatus = 'X' OR LM.ConvertStatus = 'R')
		ORDER BY LLB.VerifyDate
	END;

GO


USE [Laboratory]
GO

/****** Object:  StoredProcedure [dbo].[Lab_ConvertPDF]    Script Date: 03/21/2014 11:15:15 ******/
SET ANSI_NULLS OFF
GO

SET QUOTED_IDENTIFIER OFF
GO


CREATE PROCEDURE [dbo].[Lab_ConvertPDF]
@VerifyDate varchar(10),
@VerifyDateEnd varchar(10) = @VerifyDate
AS

	BEGIN
		SELECT	LM.RequestNum, 
				LM.RefNum, 
				LM.UserID,
				LM.QueueTag, 
				CLS.LabSection, 
				CLE.LabExam, 
				LLB.AccessionNum
		FROM	Laboratory..tbLabLogBook LLB
				LEFT OUTER JOIN Laboratory..tbLabMaster LM  ON LM.RequestNum = LLB.RequestNum
				LEFT OUTER JOIN Build_File..tbCoLabExam CLE ON LM.ItemID = CLE.LabExamID
				LEFT OUTER JOIN Build_File..tbCoLabSection CLS ON LM.SectionID = CLS.LabSectionID
		WHERE  (LLB.VerifyDate between @VerifyDate and @VerifyDateEnd + ' 23:59:59.99') 
				AND LM.RequestStatus = 'W' 
				and (LM.ConvertStatus = 'X' OR LM.ConvertStatus = 'P')
		ORDER BY LLB.VerifyDate
	END;



GO


ALTER TABLE LABORATORY..TBLABMASTER
ADD	  ConvertQueueTag VARCHAR(1),
	  EmailResult VARCHAR(1)
	  
go 


USE [Laboratory]
GO

/****** Object:  StoredProcedure [dbo].[Lab_ConvertPDF_SetlstSent_Search]    Script Date: 03/21/2014 11:44:08 ******/
SET ANSI_NULLS OFF
GO

SET QUOTED_IDENTIFIER OFF
GO



CREATE PROCEDURE [dbo].[Lab_ConvertPDF_SetlstSent_Search]
@VerifyDate varchar(10),
@SearchKey varchar(50)
AS

	BEGIN
		SELECT	LM.HospNum, 
				LM.UserID, 
				LM.RefNum, 
				LM.EmailResult,
				LLB.RequestNum, 
				LLB.AccessionNum,
				CLS.LabSection, 
				CLE.LabExam, 
				LM.QueueTag,
				M.LastName, 
				M.FirstName, 
				M.MiddleName, 
				C.lastname as MoaLastName, 
				C.Firstname as MoaFirstname, 
				C.Middlename as MoaMiddlename,
				convert(varchar(10),LLB.VerifyDate,101) VerifyDate
		FROM	Laboratory..tbLabLogBook LLB 
				LEFT OUTER JOIN Laboratory..tbLabMaster LM ON LM.RequestNum = LLB.RequestNum
				LEFT OUTER JOIN Laboratory.dbo.vwPatientResultEntry M ON LM.HospNum = M.HospNum
				LEFT OUTER JOIN Patient_Data..tbcashpatient C ON LM.HospNum = C.HospNum
				LEFT OUTER JOIN Build_File..tbCoLabExam CLE ON LM.ItemID = CLE.LabExamID
				LEFT OUTER JOIN Build_File..tbCoLabSection CLS ON LM.SectionID = CLS.LabSectionID
		WHERE	LM.RequestStatus = 'W' and LM.ConvertStatus = 'S'
				AND (LLB.VerifyDate between @VerifyDate and @VerifyDate + ' 23:59:59.99')
				AND (M.LastName LIKE @SearchKey+'%' OR LM.RefNum = @SearchKey or C.LastName LIKE @SearchKey+'%') 
				AND (LM.ConvertQueueTag is null OR  LM.COnvertQueueTag = 'L')
		ORDER BY LLB.VerifyDate, M.LastName, M.FirstName, M.MiddleName
	END;

GO



USE [Laboratory]
GO

/****** Object:  StoredProcedure [dbo].[Lab_ConvertPDF_SetlstSent_SearchAll]    Script Date: 03/21/2014 11:46:00 ******/
SET ANSI_NULLS OFF
GO

SET QUOTED_IDENTIFIER OFF
GO


CREATE PROCEDURE [dbo].[Lab_ConvertPDF_SetlstSent_SearchAll]
@SearchKey varchar(50)
AS

SELECT	LM.HospNum, 
		LLB.RequestNum, 
		LM.RefNum, 
		LM.EmailResult,
		CLS.LabSection, 
		CLE.LabExam, 
		LLB.AccessionNum,
		M.LastName, 
		M.FirstName, 
		M.MiddleName, 
		LM.UserID, 
		LM.QueueTag,
		convert(varchar(10),LLB.VerifyDate,101) VerifyDate
FROM	Laboratory..tbLabLogBook LLB 
		LEFT OUTER JOIN Laboratory..tbLabMaster LM ON LM.RequestNum = LLB.RequestNum
		LEFT OUTER JOIN Laboratory.dbo.vwPatientResultEntry M ON LM.HospNum = M.HospNum
		LEFT OUTER JOIN Build_File..tbCoLabExam CLE ON LM.ItemID = CLE.LabExamID
		LEFT OUTER JOIN Build_File..tbCoLabSection CLS ON LM.SectionID = CLS.LabSectionID
WHERE	LM.RequestStatus = 'W' and LM.ConvertStatus = 'S'
		AND (M.LastName LIKE @SearchKey+'%' OR LM.RefNum = @SearchKey) 
		AND (LM.QueueTag is null OR  LM.QueueTag = 'L')
ORDER BY LLB.VerifyDate, M.LastName, M.FirstName, M.MiddleName

GO


USE [Laboratory]
GO

/****** Object:  StoredProcedure [dbo].[Lab_ConvertPDF_SetlstUnSent]    Script Date: 03/21/2014 11:46:24 ******/
SET ANSI_NULLS OFF
GO

SET QUOTED_IDENTIFIER OFF
GO


CREATE PROCEDURE [dbo].[Lab_ConvertPDF_SetlstUnSent]
@VerifyDate varchar(10),
@SearchKey varchar(50)

AS

	BEGIN
		SELECT	LM.UserID, 
				LM.RefNum,
				LLB.RequestNum, 
				LLB.AccessionNum, 
				LM.QueueTag,
				CLS.LabSection, 
				CLE.LabExam, 
				V.LastName, 
				V.FirstName, 
				V.MiddleName, 
				LLB.VerifyDate
		FROM	Laboratory..tbLabLogBook LLB 
				LEFT OUTER JOIN Laboratory..tbLabMaster LM ON LM.RequestNum = LLB.RequestNum
				LEFT OUTER JOIN Build_File..tbCoLabExam CLE ON LM.ItemID = CLE.LabExamID
				LEFT OUTER JOIN Build_File..tbCoLabSection CLS ON LM.SectionID = CLS.LabSectionID
				LEFT OUTER JOIN Laboratory.dbo.vwPatientResultEntry V ON LM.HospNum = V.hospnum
		WHERE	(LLB.VerifyDate between @VerifyDate and @VerifyDate + ' 23:59:59.99') 
				AND LM.RequestStatus = 'W' 
				AND (LM.ConvertStatus = 'X' OR LM.ConvertStatus = 'P')
				AND (V.LastName LIKE @SearchKey+'%' OR LM.RefNum = @SearchKey) 
		ORDER BY LLB.VerifyDate
	END;

GO


USE [Laboratory]
GO

/****** Object:  StoredProcedure [dbo].[Lab_ConvertPDF_SetlstUnSentAll]    Script Date: 03/21/2014 11:47:08 ******/
SET ANSI_NULLS OFF
GO

SET QUOTED_IDENTIFIER OFF
GO


CREATE PROCEDURE [dbo].[Lab_ConvertPDF_SetlstUnSentAll]
@SearchKey varchar(50)

AS

	BEGIN
		SELECT	LM.UserID, 
				LM.RefNum,
				LLB.RequestNum, 
				LLB.AccessionNum, 
				LM.QueueTag,
				CLS.LabSection, 
				CLE.LabExam, 
				M.LastName, 
				M.FirstName, 
				M.MiddleName, 
				LLB.VerifyDate
		FROM	Laboratory..tbLabLogBook LLB 
				LEFT OUTER JOIN Laboratory..tbLabMaster LM ON LM.RequestNum = LLB.RequestNum
				LEFT OUTER JOIN Laboratory.dbo.vwPatientResultEntry M ON LM.HospNum = M.HospNum
				LEFT OUTER JOIN Build_File..tbCoLabExam CLE ON LM.ItemID = CLE.LabExamID
				LEFT OUTER JOIN Build_File..tbCoLabSection CLS ON LM.SectionID = CLS.LabSectionID
		WHERE   LM.RequestStatus = 'W' 
				and (LM.ConvertStatus = 'X' OR LM.ConvertStatus = 'P')
				AND (M.LastName LIKE @SearchKey+'%' OR LM.RefNum = @SearchKey) 
		ORDER BY LLB.VerifyDate
	END;	

GO


USE [Laboratory]
GO

/****** Object:  StoredProcedure [dbo].[Lab_ConvertPDF_UpdateConvertStatus]    Script Date: 03/21/2014 11:48:08 ******/
SET ANSI_NULLS OFF
GO

SET QUOTED_IDENTIFIER OFF
GO


CREATE PROCEDURE [dbo].[Lab_ConvertPDF_UpdateConvertStatus]
@RequestNum varchar(8)
AS

UPDATE	Laboratory..tbLabMaster
SET		ConvertStatus = 'S'
WHERE	RequestNum LIKE @RequestNum
GO


USE [Laboratory]
GO

/****** Object:  StoredProcedure [dbo].[Lab_ConvertPDF_UpdatePreferences]    Script Date: 03/21/2014 11:48:36 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE PROCEDURE [dbo].[Lab_ConvertPDF_UpdatePreferences]
	@ConversionPath varchar(100) = '',
	@DefaultMessage text = '',
	@ConversionWaitingTime int = 0,
	@ReConversionTime int = 0,
	@RefreshTime int = 0,
	@NotConvertedTime int = 0,	
	@ConvertCashPatient int = 0,
	@AutoStart int = 0
	
AS

UPDATE	Patient_Data..tbPDFConverterSettings
SET		ConversionPath = @ConversionPath,
		DefaultMessage = @DefaultMessage,
		WaitingTime = @ConversionWaitingTime,
		ResendTime = @ReConversionTime,
		RefreshTime = @RefreshTime,
		NotConvertedTime = @NotConvertedTime,
		ConvertCashPatient = @ConvertCashPatient,
		AutoStart = @AutoStart
WHERE	HospitalID = 1
GO


USE [Laboratory]
GO

/****** Object:  StoredProcedure [dbo].[Lab_ConvertPDF_Reconvert]    Script Date: 03/21/2014 11:49:08 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER OFF
GO


CREATE PROCEDURE [dbo].[Lab_ConvertPDF_Reconvert]
@RequestNum varchar(10)
AS
	BEGIN
		SELECT	LM.RequestNum, 
				M.LastName, 
				M.FirstName, 
				M.MiddleName, 
				PEA.EmailAddress, 
				LLB.VerifyDate, 
				CLS.LabSection, 
				CLE.LabExam, 
				LM.HospNum
		FROM	Laboratory..tbLabMaster LM
				LEFT OUTER JOIN Laboratory.dbo.vwPatientResultEntry M ON LM.HospNum = M.HospNum
				LEFT OUTER JOIN Patient_Data..tbPatientEmailAddresses PEA ON LM.HospNum = PEA.HospNum
				LEFT OUTER JOIN Laboratory..tbLabLogBook LLB ON LM.RequestNum = LLB.RequestNum
				LEFT OUTER JOIN Build_File..tbCoLabExam CLE ON LM.ItemID = CLE.LabExamID
				LEFT OUTER JOIN Build_File..tbCoLabSection CLS ON LM.SectionID = CLS.LabSectionID
		WHERE	LM.RequestNum = @RequestNum 
				and LM.RequestStatus = 'W'
				and LM.ConvertStatus = 'S'
		ORDER BY LLB.VerifyDate
	END;
GO


USE [Laboratory]
GO

/****** Object:  StoredProcedure [dbo].[Lab_ConvertPDF_PauseSending]    Script Date: 03/21/2014 11:49:27 ******/
SET ANSI_NULLS OFF
GO

SET QUOTED_IDENTIFIER OFF
GO


CREATE PROCEDURE [dbo].[Lab_ConvertPDF_PauseSending]
@RequestNum varchar(8)
AS

UPDATE	Laboratory..tbLabMaster
SET		EmailStatus = 'P'
WHERE	RequestNum LIKE @RequestNum

GO

USE [Laboratory]
GO

/****** Object:  StoredProcedure [dbo].[Lab_ConvertPDF_Failed]    Script Date: 03/21/2014 11:50:05 ******/
SET ANSI_NULLS OFF
GO

SET QUOTED_IDENTIFIER OFF
GO


CREATE PROCEDURE [dbo].[Lab_ConvertPDF_Failed]
@RequestNum varchar(8)
AS

UPDATE	Laboratory..tbLabMaster
SET		ConvertStatus = 'U'
WHERE	RequestNum LIKE @RequestNum


GO

USE [Laboratory]
GO

/****** Object:  StoredProcedure [dbo].[Lab_ConvertPDF_Resend_Unsent]    Script Date: 03/21/2014 11:50:25 ******/
SET ANSI_NULLS OFF
GO

SET QUOTED_IDENTIFIER OFF
GO


CREATE PROCEDURE [dbo].[Lab_ConvertPDF_Resend_Unsent]
@RequestNum varchar(10)
AS

SELECT	LM.RequestNum, 
		M.LastName, 
		M.FirstName, 
		M.MiddleName, 
		PEA.EmailAddress, 
		LLB.VerifyDate, 
		CLS.LabSection, 
		CLE.LabExam, 
		LM.HospNum
FROM	Laboratory..tbLabMaster LM
		LEFT OUTER JOIN Laboratory.dbo.vwPatientResultEntry M ON LM.HospNum = M.HospNum
		LEFT OUTER JOIN Patient_Data..tbPatientEmailAddresses PEA ON LM.HospNum = PEA.HospNum
		LEFT OUTER JOIN Laboratory..tbLabLogBook LLB ON LM.RequestNum = LLB.RequestNum
		LEFT OUTER JOIN Build_File..tbCoLabExam CLE ON LM.ItemID = CLE.LabExamID
		LEFT OUTER JOIN Build_File..tbCoLabSection CLS ON LM.SectionID = CLS.LabSectionID
WHERE	LM.RequestStatus = 'W' 
		AND LM.RequestNum = @RequestNum  
		AND LM.ConvertStatus = 'X'
ORDER BY LLB.VerifyDate

GO

USE [Laboratory]
GO

/****** Object:  StoredProcedure [dbo].[Lab_ConvertPDF_ResumeSending]    Script Date: 03/21/2014 11:50:39 ******/
SET ANSI_NULLS OFF
GO

SET QUOTED_IDENTIFIER OFF
GO


CREATE PROCEDURE [dbo].[Lab_ConvertPDF_ResumeSending]
@RequestNum varchar(8)
AS

UPDATE	Laboratory..tbLabMaster
SET		ConvertStatus = 'X'
WHERE	RequestNum LIKE @RequestNum

GO


USE [Laboratory]
GO
/****** Object:  StoredProcedure [dbo].[Lab_ConvertPDF_Resend_Unsent]    Script Date: 03/21/2014 17:40:30 ******/
SET ANSI_NULLS OFF
GO
SET QUOTED_IDENTIFIER OFF
GO


ALTER PROCEDURE [dbo].[Lab_ConvertPDF_Resend_Unsent]
@RequestNum varchar(10)
AS

SELECT	LM.RequestNum, 
		M.LastName, 
		M.FirstName, 
		M.MiddleName, 
		--PEA.EmailAddress, 
		LLB.VerifyDate, 
		CLS.LabSection, 
		CLE.LabExam, 
		LM.HospNum
FROM	Laboratory..tbLabMaster LM
		LEFT OUTER JOIN Laboratory.dbo.vwPatientResultEntry M ON LM.HospNum = M.HospNum
		--LEFT OUTER JOIN Patient_Data..tbPatientEmailAddresses PEA ON LM.HospNum = PEA.HospNum
		LEFT OUTER JOIN Laboratory..tbLabLogBook LLB ON LM.RequestNum = LLB.RequestNum
		LEFT OUTER JOIN Build_File..tbCoLabExam CLE ON LM.ItemID = CLE.LabExamID
		LEFT OUTER JOIN Build_File..tbCoLabSection CLS ON LM.SectionID = CLS.LabSectionID
WHERE	LM.RequestStatus = 'W' 
		AND LM.RequestNum = @RequestNum  
		AND LM.ConvertStatus = 'X'
ORDER BY LLB.VerifyDate

GO






































USE [Build_FIle]
GO

/****** Object:  Table [dbo].[tbPDFConverterSettings]    Script Date: 07/02/2014 16:24:55 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[tbPDFConverterSettings](
	[HospitalID] [int] NULL,
	[Title] [varchar](60) NULL,
	[Company] [varchar](100) NULL,
	[Address1] [varchar](70) NULL,
	[TinNo] [varchar](30) NULL,
	[PhoneNum] [varchar](30) NULL,
	[RecordOfficer] [varchar](50) NULL,
	[PediaAgeLimit] [int] NULL,
	[NewbornServiceID] [varchar](2) NULL,
	[DiedResultID] [varchar](1) NULL,
	[AutopsyResultID] [varchar](1) NULL,
	[CompanyLogo] [image] NULL,
	[SeniorDiscount] [float] NULL,
	[MTSServerName] [varchar](50) NULL,
	[ServerName] [varchar](50) NULL,
	[ByGeneric] [bit] NOT NULL,
	[CashEmployeeDiscount] [float] NULL,
	[CashEmployeeDiscount2] [float] NULL,
	[IsNursePrint] [bit] NOT NULL,
	[IsDRPrint] [bit] NOT NULL,
	[IsERprint] [bit] NOT NULL,
	[IsICPrint] [bit] NOT NULL,
	[IsNUPrint] [bit] NOT NULL,
	[IsORPrint] [bit] NOT NULL,
	[IsDIPrint] [bit] NOT NULL,
	[IsLBDirectCharging] [bit] NOT NULL,
	[IsXRDirectCharging] [bit] NOT NULL,
	[IsUSDirectCharging] [bit] NOT NULL,
	[IsCTDirectCharging] [bit] NOT NULL,
	[IsHSDirectCharging] [bit] NOT NULL,
	[RecordOfficerPosition] [varchar](50) NULL,
	[isERDirectcharging] [bit] NULL,
	[ConversionPath] [varchar](100) NULL,
	[FaxPath] [varchar](100) NULL,
	[LocalAccessNum] [int] NULL,
	[FaxWaitingTime] [int] NOT NULL,
	[WaitingTime] [int] NOT NULL,
	[SMTP_Server] [varchar](100) NULL,
	[SenderName] [varchar](100) NULL,
	[SenderEmail] [varchar](100) NULL,
	[EmailUsername] [varchar](50) NULL,
	[EmailPassword] [varchar](20) NULL,
	[ResendTime] [int] NULL,
	[FaxResendTime] [int] NULL,
	[RefreshTime] [int] NULL,
	[FaxRefreshTime] [int] NULL,
	[NotConvertedTime] [int] NULL,
	[FaxUnchargedTime] [int] NULL,
	[DefaultMessage] [text] NULL,
	[SpecFloatingTime] [int] NULL,
	[ClientName] [varchar](50) NULL,
	[OPDPassword] [varchar](20) NULL,
	[ConvertCashPatient] [int] NULL,
	[AutoStart] [int] NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO