USE [PATIENT_DATA]

Go

Alter TABLE [tbOPD_settings]Add
	[isAllowRegistertoHemodialysis] [bit] NOT NULL DEFAULT ((1))

GO
------------------------------------------------------------------
USE [PATIENT_DATA]

Go
Alter TABLE [tbOPD_settings]Add
	[isAllowWithPFRate] [bit] NOT NULL DEFAULT ((1))
GO
------------------------------------------------------------------
USE [PATIENT_DATA]

Go
Alter TABLE [tbOPD_settings]Add
	[isAllowHMORate] [bit] NOT NULL DEFAULT ((1))
GO
------------------------------------------------------------------
USE [PATIENT_DATA]

Go
Alter TABLE [tbOPD_settings]Add
	[isAllowPostChargePersonal] [bit] NOT NULL DEFAULT ((0))
GO
------------------------------------------------------------------
USE [PATIENT_DATA]

Go
Alter TABLE [tbOPD_settings]Add
	[isAllowCheckCreditLimit] [bit] NOT NULL DEFAULT ((1))
GO
------------------------------------------------------------------
USE [PATIENT_DATA]

Go
Alter TABLE [tbOPD_settings]Add
	[isAllowProcedureWithDoctorPF] [bit] NOT NULL DEFAULT ((1))
GO
------------------------------------------------------------------

USE [PATIENT_DATA]

Go
Alter TABLE [tbOPD_settings]Add
	[isAllowHMOInternationalRate] [bit] NOT NULL DEFAULT ((1))
GO
------------------------------------------------------------------
USE [PATIENT_DATA]

Go
Alter TABLE [tbOPD_settings]Add
	[IsAllowValidatePackageExpirationDate] [bit] NOT NULL DEFAULT ((0))
GO
------------------------------------------------------------------
USE [PATIENT_DATA]

Go
Alter TABLE [tbOPD_settings]Add
	[isAllowMaxicareRate] [bit] NOT NULL DEFAULT ((0))
GO
------------------------------------------------------------------
USE [PATIENT_DATA]

Go
Alter TABLE [tbOPD_settings]Add
	[isAllowHMIRate] [bit] NOT NULL DEFAULT ((0))
GO
------------------------------------------------------------------
USE [PATIENT_DATA]

Go
Alter TABLE [tbOPD_settings]Add
	[SeniorDiscountRate] [bit] NOT NULL DEFAULT ((1))
GO
------------------------------------------------------------------
USE [PATIENT_DATA]

Go
Alter TABLE [tbOPD_settings]Add
	[dailytime] [bit] NOT NULL DEFAULT ((0))
GO
------------------------------------------------------------------
USE [PATIENT_DATA]

Go
Alter TABLE [tbOPD_settings]Add
	[isAllowPromptApprovalNumEntry] [bit] NOT NULL DEFAULT ((0))
GO
------------------------------------------------------------------
USE [PATIENT_DATA]

Go
Alter TABLE [tbOPD_settings]Add
	[isAllowCodeIncVitalSigns] [bit] NOT NULL DEFAULT ((0))

GO
------------------------------------------------------------------
USE PATIENT_DATA
GO

Alter Table Patient_Data..tbopd_settings Add
isRequirePhysician bit not null default (0)

GO
------------------------------------------------------------------

USE [PATIENT_DATA]

GO

Alter TABLE [tbmaster]Add
	[DateCreated] [datetime] NULL DEFAULT (getdate())
GO
----------------------------------------------------------------------

USE [PATIENT_DATA]

GO

Alter TABLE [tbmaster]Add
	[PWDID] [varchar](30) NULL
GO
----------------------------------------------------------------------

USE [PATIENT_DATA]

GO

Alter TABLE [tbmaster]Add
	[TINNumber] [varchar](50) NULL
GO
----------------------------------------------------------------------

USE [PATIENT_DATA]

GO

Alter TABLE [tbmaster]Add
	[SpouseAddress] [varchar](200) NULL
GO
----------------------------------------------------------------------
USE Patient_Data
Go

Alter Table Patient_Data..tbOutpatient Add
ServDateStart1 Datetime,
ServDateEnd1 Datetime,

ServDateStart2 Datetime,
ServDateEnd2 Datetime,

ServDateStart3 Datetime,
ServDateEnd3 Datetime,

ServDateStart4 Datetime,
ServDateEnd4 Datetime,

ServDateStart5 Datetime,
ServDateEnd5 Datetime

GO
----------------------------------------------------------------------
USE [PATIENT_DATA]
GO

Alter TABLE [tbOutPatient]Add
	[Version] [varchar](20) NULL

GO
----------------------------------------------------------------------