USE [PATIENT_DATA]

GO

Alter TABLE [tbAdmittingSetUp] Add
	[isAllowIdnumWithYear] [bit] NOT NULL DEFAULT ((0))
GO
----------------------------------------------------------------------
USE [PATIENT_DATA]

GO

Alter TABLE [tbAdmittingSetUp] Add
	[isAllowShowPendingRoomTransfer] [bit] NOT NULL DEFAULT ((0))
GO
----------------------------------------------------------------------

USE [PATIENT_DATA]

GO

Alter TABLE [tbAdmittingSetUp] Add
	[isAllowCheckPHICStay24Hour] [bit] NOT NULL DEFAULT ((0))
GO
----------------------------------------------------------------------

USE [PATIENT_DATA]

GO

Alter TABLE [tbAdmittingSetUp] Add
	[isValidateAdmChieftDiet] [bit] NOT NULL DEFAULT ((0))
GO
----------------------------------------------------------------------


USE [PATIENT_DATA]

GO

Alter TABLE [tbAdmittingSetUp] Add
	[IsAllowUserValidation] [bit] NOT NULL DEFAULT ((0))

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

USE [PATIENT_DATA]

GO

Alter TABLE [tbAdmittingSetUp] Add
	[isAllowTagCreditLimit] [bit] NOT NULL DEFAULT ((0))

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

USE [PATIENT_DATA]

GO

Alter TABLE [tbAdmittingSetUp] Add
	[isAllowedBrowsePhotoImage] [bit] NOT NULL DEFAULT ((0))
GO
----------------------------------------------------------------------
USE [PATIENT_DATA]

GO

Alter TABLE [tbAdmittingSetUp] Add
	[isAllowAffiliatedDoctorsOnly] [bit] NOT NULL DEFAULT ((0))

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

GO

Alter TABLE [tbpatient2]Add
	[transfered] [bit] NOT NULL DEFAULT ('0')
GO
----------------------------------------------------------------------
USE [PATIENT_DATA]

GO

Alter TABLE [tbpatient2]Add
	[CreditLimitCode] [varchar](5) NULL
GO
----------------------------------------------------------------------
USE [PATIENT_DATA]

GO

Alter TABLE [tbpatient] Add
	[SOAUserName] [varchar](50) NULL

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

GO
Alter TABLE [tbpatient] Add
	[AccountNum1] [varchar](10) NULL

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

GO
Alter TABLE [tbpatient] Add
	[BillTimeStart] [datetime] NULL

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

GO
Alter TABLE [tbpatient] Add
	[BillTimeEnd] [datetime] NULL

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

GO
Alter TABLE [tbpatient] Add
	[PTDiagnosisID] [varchar](10) NULL

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

GO
Alter TABLE [tbpatient] Add
	[PTDiagnosisOthers] [varchar](10) NULL

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

GO
Alter TABLE [tbpatient] Add
	[AdmLocation] [varchar](1) NULL

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

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

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

GO
Alter TABLE [tbpatient] Add
	[isDirectAdmission] [bit] NOT NULL DEFAULT ((0))

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

GO
Alter TABLE [tbpatient] Add
	[FindUs] [varchar](2) NULL

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

GO
Alter TABLE [tbpatient] Add
	[FindUsID] [varchar](2) NULL

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

USE [PATIENT_DATA]

GO

Alter TABLE [tbpatient_Revoke_Report]add
Remarks varchar(500)

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

USE [PATIENT_DATA]

GO

Alter TABLE [tbAdmittingSetUp]add
[isAllowIdnumWithYear] [bit] NOT NULL DEFAULT ((0))

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

USE [PATIENT_DATA]

GO

Alter TABLE [tbAdmittingSetUp]add
[isAllowShowPendingRoomTransfer] [bit] NOT NULL DEFAULT ((0))

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

USE [PATIENT_DATA]

GO

Alter TABLE [tbAdmittingSetUp]add
[isAllowCheckPHICStay24Hour] [bit] NOT NULL DEFAULT ((0))

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

USE [PATIENT_DATA]

GO

Alter TABLE [tbAdmittingSetUp]add
[isValidateAdmChieftDiet] [bit] NOT NULL DEFAULT ((0))

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

USE [PATIENT_DATA]

GO

Alter TABLE [tbAdmittingSetUp]add
[IsAllowUserValidation] [bit] NOT NULL DEFAULT ((0))

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

USE [PATIENT_DATA]

GO

Alter TABLE [tbAdmittingSetUp]add
[isAllowTagCreditLimit] [bit] NOT NULL DEFAULT ((0))

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

USE [PATIENT_DATA]

GO

Alter TABLE [tbAdmittingSetUp]add
[isAllowedBrowsePhotoImage] [bit] NOT NULL DEFAULT ((0))

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

USE [PATIENT_DATA]

GO

Alter TABLE [tbAdmittingSetUp]add
[isAllowAffiliatedDoctorsOnly] [bit] NOT NULL DEFAULT ((0))
GO
----------------------------------------------------------------------
USE [PATIENT_DATA]

GO

Alter TABLE [tbAdmittingSetUp]add
[isAllowCheckAdmdateGreaterThanCharges] [bit] NOT NULL DEFAULT ((0))
GO
----------------------------------------------------------------------
USE [PATIENT_DATA]

GO

Alter TABLE [tbAdmittingSetUp]add
[isAllowNewInsuranceHMOcondition] [bit] NOT NULL DEFAULT ((1))
GO
----------------------------------------------------------------------