Use Station
Go
ALTER TABLE Station.dbo.tbNurseVitalSigns 
ADD Motor VARCHAR(20) NULL, 
    Verbal VARCHAR(20) NULL,
    EyeOpening VARCHAR(20) NULL,
    [Right] VARCHAR(20) NULL,
    [Left] VARCHAR(20) NULL,
    Input VARCHAR(100) NULL,
    [Output] VARCHAR(100) NULL;
Go

---------------------------------------------------------------------------------------
Use Station
Go
ALTER TABLE Station.dbo.tbNurseVitalSigns 
ADD 	
    [FIO2] [varchar](20) NULL,
	[TV] [varchar](20) NULL,
	[IERatio] [varchar](20) NULL,
	[MRate] [varchar](20) NULL,
	[Peep] [varchar](20) NULL;
Go

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


USE Patient_Data
Go
ALTER TABLE Patient_data.dbo.tbmaster
ADD PortalAccess bit Null;
GO

USE Patient_Data
Go
ALTER TABLE Patient_data.dbo.tbOutPatient
ADD MobileOnsite bit Null;
GO

USE PATIENT_DATA
GO

Alter Table Patient_Data..tbAdmWatcherMaster 
Add Relation varchar(30)

GO

GO
Alter Table Patient_Data..tbPatientHistory 
Add Precautions [text] NULL

GO

Alter table PATIENT_DATA..tbAdmPatientInfoUpdate
Alter column Remarks text

GO


Alter Table Patient_Data..tbpatient2
alter column vip bit 
GO

Alter Table Patient_Data..tbpatient2
alter column WithDrOrder bit 
GO

Alter Table Patient_Data..tbpatient2
alter column DTR bit 
GO

Alter Table Patient_Data..tbpatient2
alter column OkeyPH bit 
GO

Alter Table Patient_Data..tbpatient2
alter column Transient bit 
GO

Alter Table Patient_Data..tbpatient2
alter column Confidential bit 
GO


Alter Table Patient_Data..tbpatient
alter column WithAdmissionKit bit 
GO

Alter Table Patient_Data..tbpatient
alter column WithTransferFee bit 
GO


Alter Table Patient_Data..tbMaster2
Add PatientFindUs varchar(1)
GO

Alter Table Patient_Data..tbMaster2
Add PatientFindUsOtherRemarks varchar(50)
GO

Alter Table Patient_Data..tbPatient2 
Add PatientType varchar(1) null
GO

Alter Table tbMaster
Add ForeignAddress varchar(100)
GO

Alter Table tbMaster
Add Country varchar(30)

GO
Alter table Patient_Data..tbPastMaster
Add EmailAddress varchar(50)
GO

ALTER TABLE [dbo].[tbmaster2] ADD [FatherEmployer] [varchar](30) NULL
GO

ALTER TABLE [dbo].[tbmaster2] ADD [MotherEmployer] [varchar](30) NULL
GO

Alter TABLE [dbo].[tbAdmDischarge]Alter column
	[Remarks] [varchar](100) NULL
GO

Alter TABLE [dbo].[tbAdmittingSetUp]Add
	isAllowSupervisorConfirmation bit not null default (0)
GO

Alter TABLE [dbo].[tbAdmDischarge]add
	DeathDate datetime null

GO
Alter Table Patient_Data..tbMaster Alter Column
HouseStreet varchar(200)
GO

Alter Table Patient_Data..tbMaster2 Alter Column
SpouseAddress varchar(200)

Alter Table Patient_Data..tbMaster2 Alter Column
FatherAddress varchar(200)
GO

Alter Table Patient_Data..tbMaster2 Alter Column
MotherAddress varchar(200)
GO

Alter Table Patient_Data..tbMaster2 Alter Column
EmployerAddress varchar(200)
GO

Alter Table Patient_Data..tbMaster2 Alter Column
ContactAddress varchar(200)
GO

Alter Table Patient_Data..tbPatientInformant Alter Column
InformantAddress varchar(200)
GO

Alter Table Patient_Data..tbPatientGuarantor Alter Column
GuarantorAddress varchar(200)
GO

Alter Table PATIENT_DATA..tbadmittingsetup Add
isAllowCheckOPDConsultation bit not null default(1)
GO

Alter Table Patient_Data.dbo.tbOutPatientHistory
Add Precautions [text] NULL
GO

Alter Table Patient_Data..tbOutPatient 
Add PAD bit not null default(0)
GO

Alter Table Patient_Data..tbPatient2
Add PAD bit not null default(0)
GO

Alter table Patient_Data..tbAdmittingSetup
Add isAllowHospitalizationGuide bit not null default (0)
GO

Alter Table Patient_Data..tbMaster
Alter column [Barangay] [varchar](100) NULL
GO

Alter Table Patient_Data..tbMaster2
Alter Column [Employer] [varchar](100) NULL
GO

Alter Table Patient_Data..tbMaster 
Alter Column FirstName varchar(50)
GO

Alter Table Patient_Data..tbmaster_Merged 
Alter Column FirstName varchar(50)
GO


USE [PATIENT_DATA]
GO
/****** Object:  StoredProcedure [dbo].[sp_Adm_User_Department_Access]    Script Date: 09/16/2014 16:29:05 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

Create PROCEDURE [dbo].[sp_Adm_SupervisorConfirmation]
@UserCode As Varchar(10),
@Password As Varchar(32),
@DepartmentID As Varchar(4)=NULL


 AS

	BEGIN

		Select *
		From Password..tbPasswordMain
		Where EmployeeID = @UserCode and
			Password= @Password and right_Code2 ='S' and
			((DepartmentID='00' and OriginalDepartment='00') or
			(DepartmentID='1' and OriginalDepartment='1') or
			(DepartmentID='20' or OriginalDepartment='20') or
			 (DepartmentID='1' and OriginalDepartment=@DepartmentID) or
			 (DepartmentID=@DepartmentID and OriginalDepartment=@DepartmentID)
			)

	END

GO


GO
SET QUOTED_IDENTIFIER ON
GO

Create PROCEDURE [dbo].[OPD_DailyCensusNewPatient]
	@reportDate as varchar(10)
as


	Select 
	B.Hospnum,  
	A.IDNum, 
	B.LastName, 
	B.FirstName, 
	B.MiddleName, 
	A.AdmDate,
	C.Company as Account, 
	A.AccountNum,D.LastName+', '+D.FirstName+' '+D.MiddleName as Doctor
	from Patient_Data..tbOutpatient A
	Left Outer Join Patient_Data..tbMaster B on A.Hospnum = B.Hospnum
	Left Outer Join Build_File..tbcoCompany C on A.AccountNum = C.AccountNum
	Left outer Join Build_File..tbCoDoctor D on A.DoctorID1 = D.DoctorID
	where A.AdmDate between @reportDate and @reportDate + ' 23:59:59.99'
	And A.PatientStatus ='N'
	order by a.AdmDate

GO



USE [PATIENT_DATA]

GO

ALTER TABLE [tbAdmWaitingList]
ADD	[EndDateReserved] [datetime] NULL,
	[ServiceID] [varchar](10) NULL,
	[AdmissionType] [varchar](10) NULL,
	[JoneltaID] [varchar](10) NULL
GO




-----------------------------------------------------------------------------------------------------------------
CREATE INDEX [by_RequestDateRefNum] ON Radiology..tbRISPatientQueueNo([RequestDate],[RefNum]) 
GO
-----------------------------------------------------------------------------------------------------------------

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

USE [REGISTER]
GO

Alter TABLE [dbo].[tbMedicalHistory]Add
	[Eye] [varchar](1) NULL,
	[Veins] [varchar](1) NULL,
	[Blood] [varchar](1) NULL,
	[Thyroid] [varchar](1) NULL,
	--[Skin] [varchar](1) NULL,
	[Allergies] [varchar](1) NULL,
	[Infectious] [varchar](1) NULL,
	[Genital] [varchar](1) NULL,
	[Pregnancy] [varchar](1) NULL,
	[Sleep] [varchar](1) NULL,
	[Depression] [varchar](1) NULL,
	[Memory] [varchar](1) NULL,
	[Balance] [varchar](1) NULL,
	[mobility] [varchar](1) NULL,
	[Amputation] [varchar](1) NULL,
	[GeneralAnswer] [varchar](100) NULL,
	[Repatriated] [varchar](1) NULL,
	[Hospitalized] [varchar](1) NULL,
	[Declared] [varchar](1) NULL,
	[Revoked] [varchar](1) NULL,
	[Aware] [varchar](1) NULL,
	[Healthy] [varchar](1) NULL,
	[Allergic] [varchar](1) NULL,
	[Prescription] [varchar](1) NULL,
	[Comments] [varchar](100) NULL

GO
-----------------------------------------------------------------------------------------------------------------
GO
USE [REGISTER]
GO

Alter TABLE [dbo].[tbMedicalHistory]Add
	[Gynaecological] [varchar](1) NULL,
	[LastMenstrualPeriod] [datetime] NULL,
	[LastTropicalDisease] [datetime] NULL,
	[Schistosomiasis] [varchar](1) NULL,
	[LastSchistosomiasis] [datetime] NULL,
	[LastAllergy] [varchar](50) NULL,
	[AllegicMedication] [varchar](250) NULL
GO
-----------------------------------------------------------------------------------------------------------------

-----------------------------------------------------------------------------------------------------------------
Use Station
Go
ALTER TABLE Station.dbo.tbNurse_AdministeredMedicines
ALTER COLUMN
Quantity float NULL;
Go
/****** Object:  StoredProcedure [dbo].[sp_Nurse_Save_Patient_AdministeredMedicines_xp]    Script Date: 03/31/2015 10:40:52 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

create PROCEDURE [dbo].[sp_Nurse_Save_Patient_AdministeredMedicines_xp]
@idnum as varchar(10),
@itemid as varchar(10),
@quantity as float,
@requestnum as varchar(10),
@administereddate as datetime,
@administeredby as varchar(10),
@UserID  as varchar(10),
@RefNum As varchar(10)=NULL

AS

BEGIN

Insert into STATION..tbNurse_AdministeredMedicines(IDNum, Transdate, ItemID, Quantity, RequestNum
,AdministeredDate, AdministeredBy, UserID, ReferenceNum)
Values(@idnum,getdate(),@itemid,@quantity,@requestnum,@administereddate,@administeredby,@UserID,@RefNum);

END



USE RADIOLOGY
GO

ALTER TABLE RADIOLOGY..tbRadiologyRevenues alter column DICOMModality varchar(50)
GO

UPDATE  RADIOLOGY..tbRadiologyRevenues set DICOMModality = 'CR,DR,DX' where GType=2
GO




alter table patient_data..tbhospitalinfo add HasOutPatients varchar(1)
GO
alter table patient_data..tbhospitalinfo add HasInPatients varchar(1)
GO

---------------------------------------------------------------------------------------
USE Patient_DATA
GO

Alter Table Patient_Data..tbpatient
Add HMONum varchar(20)

GO

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

 
Use Station
Go
ALTER TABLE Station.dbo.tbNurse_AdministeredMedicines
ADD
    [SchedTime1] [datetime] NULL,
    [SchedTime2] [datetime] NULL,
    [SchedTime3] [datetime] NULL,
    [SchedTime4] [datetime] NULL,
    [SchedTime5] [datetime] NULL,
    [SchedTime6] [datetime] NULL,
    [SchedTime7] [datetime] NULL,
[SchedTime8] [datetime] NULL,
DoseStatus CHAR(2) NULL,
SequenceNumber VARCHAR(20) NULL,
Dosage VARCHAR(8) NULL;
Go
Use Station
Go
ALTER TABLE Station.dbo.tbNurse_AdministeredMedicines
ADD
Quantity float NULL;
Go
Use Station
Go
ALTER TABLE Station.dbo.tbNurse_AdministeredMedicines
ALTER COLUMN
Quantity float NULL;
Go
 
---------------------------------------------------------------------------------------
Create Procedure sp_Med_ForeignersTypeOfStay --'01/01/2014','12/31/2014'
@StartDate varchar(10),
@EndDate varchar(10)
as
----Set @StartDate ='01/01/2014'
----Set @EndDate ='12/31/2014'


Select A.IdNum,A.HospNum,A.AdmDate,A.DcrDate,
		B.LastName+', '+B.FirstName+' '+B.MiddleName as PatientName,
		E.StayTypeID,E.StayType,
		F.NationalityID,F.Nationality,
		G.Town+' '+G.Province as LocalAddress,
		B.ForeignAddress+','+B.Country as ForeignAddress
		
From PATIENT_DATA..tbpatient A
Left Outer Join PATIENT_DATA..tbMaster B on A.HospNum = B.HospNum
Left Outer Join PATIENT_DATA..tbMaster2 C on A.HospNum = C.HospNum
Left Outer Join BUILD_FILE..tbCoStayType E on A.StayTypeID = E.StayTypeID
Left Outer Join BUILD_FILE..tbCoNationality F on C.NationalityID = F.NationalityID
Left Outer Join BUILD_FILE..tbcoAddress G on B.ZipCode = G.ZipCode

Where AdmDate between @StartDate and @EndDate +' 23:59:59:99'
And C.NationalityID <>'1'

GO

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

Use Build_File
Go
ALTER TABLE Build_File.dbo.ERBeds
ADD
TransDate  datetime,
Ninitial VARCHAR(10);
Go

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

Use Patient_Data
Go
ALTER TABLE Patient_Data.dbo.tbPatientDocs
ADD
HospNum varchar(50) NULL;
Go

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

USE [Password]

GO


CREATE INDEX [byDepartmentID] ON [dbo].[tbPasswordMain]
(
	[DepartmentID] ASC
)

GO


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

USE [Build_FIle]
GO


Alter TABLE [dbo].[tbCoDoctor]
add
	[SpecialtyID]  [varchar](4) NULL

GO
Alter TABLE [dbo].[tbCoDoctor]
add

	[Cellphone] [varchar](20) NULL
GO




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

USE [Patient_Data]
GO


Alter TABLE [dbo].[tbPatientDocs] add 	[HospNum] [varchar](50) NULL

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

USE [Inventory]
GO

/****** Object:  UserDefinedFunction [dbo].[Get_Item_Name]    Script Date: 7/10/2015 1:56:59 PM ******/
SET ANSI_NULLS OFF
GO

SET QUOTED_IDENTIFIER OFF
GO



CREATE FUNCTION [dbo].[Get_Item_Name](
@ItemName AS Varchar(50),
@ItemDesc AS Varchar(50)
)
RETURNS Varchar(50) AS  
BEGIN 
	RETURN ltrim(rtrim(isnull(@itemname,'') + ' ' +  isnull(@itemdesc,'')))  
END



GO

---------------------------------------------------------------------------------------
USE [Patient_Data]
GO

ALTER TABLE [dbo].[tbpatient] ADD
	[isWellBaby] [bit] NOT NULL DEFAULT('0')

GO
---------------------------------------------------------------------------------------
GO
USE Patient_Data
GO

Alter Table Patient_data..tbAdmittingSetUp
Add isAllowAccountConsolidation Bit Not Null default(0)

GO
---------------------------------------------------------------------------------------
GO
alter table patient_data..tboutpatienttimein alter column serviceid varchar(10)
GO


USE [dbRecords]
GO

alter table dbrecords..tblrecfiles alter column file_name varchar(150)
GO

CREATE CLUSTERED INDEX [by_recfile_id] ON [dbo].[tblRecFiles]([recfile_id] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)
GO

CREATE NONCLUSTERED INDEX [by_IDNum] ON [dbo].[tblRecFiles](    [admission_id] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO




alter table patient_data..tbOutPatientHistory add UserID varchar(50)
GO
alter table patient_data..tbOutPatientHistory add TransDate DateTime
GO


alter table patient_data..tbPatientHistory add UserID varchar(50)
GO
alter table patient_data..tbPatientHistory add TransDate DateTime
GO
---------------------------------------------------------------------------------------
GO

USE BUILD_FILE
GO


Alter PROCEDURE [dbo].[sp_Bui_Find_Last_Item_Number](@RevenueId as varchar(2))
AS
If (@revenueid = 'AU')
    select max(cast(audexamid as integer)) as lastnumber from tbcoaudexam

else
If (@revenueid = 'CT')
    select max(cast(ctexamid as integer)) as lastnumber from tbcoctexam

else
If (@revenueid = 'HS')
    select max(cast(hsexamid as integer)) as lastnumber from tbcohsexam

else
If (@revenueid = 'LB')
    select max(cast(labexamid as integer)) as lastnumber from tbcolabexam

else
If (@revenueid = 'NU')
    select max(cast(nucexamid as integer)) as lastnumber from tbconucexam

else
If (@revenueid = 'PT')
    select max(cast(ptexamid as integer)) as lastnumber from tbcoptexam

else
If (@revenueid = 'PA')
    select max(cast(rtsexamid as integer)) as lastnumber from tbcortsexam

else
If (@revenueid = 'US')
    select max(cast(
                 Case when isnumeric(ultraexamid ) = 0 then '0'
                          else  ultraexamid
                          end
                  as integer)) as lastnumber from tbcoultraexam

else
If (@revenueid = 'XR')
    select max(cast(xrayexamid as integer)) as lastnumber from tbcoxrayexam
else

if (@revenueid = 'NS')
select max(cast(itemid as integer)) as lastnumber from inventory..tbInvMaster

else
	--select max(cast(otherrevenueid as float)) as lastnumber from tbcootherrevenue where Othersectionid=@revenueid
   --select max(cast(otherrevenueid as integer)) as lastnumber from tbcootherrevenue where (OtherSectionID <> 'OR' and OtherSectionID <> 'ES') and IsNumeric(OtherRevenueID) = 1
       select max(cast(otherrevenueid as integer)) as lastnumber from tbcootherrevenue where  IsNumeric(OtherRevenueID) = 1
GO
 ---------------------------------------------------------------------------------------
GO
alter table  Radiology..tbRadiologyRevenues alter column DICOMModality varchar(50)
GO


CREATE INDEX [by_MedsysHealthRecID] ON Patient_data.[dbo].[tbmaster] ([MedsysHealthRecID])
GO

=================================================================================
Use Patient_Data
				Go
				ALTER TABLE Patient_Data.dbo.tbERMaster
				ADD
				isStat bit NULL;
				Go



USE [Build_FIle]
GO

/****** Object:  Table [dbo].[tbOutPatientRooms]    Script Date: 8/11/2015 4:04:20 PM ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[tbOutPatientRooms](
	[ID] [bigint] IDENTITY(1,1) NOT NULL,
	[Department] [varchar](50) NULL,
	[DoctorsRoom] [varchar](50) NULL,
	[DoctorID] [varchar](50) NULL,
	[ServiceID] [varchar](50) NULL
) ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO

alter table patient_data..tbpatientdocs  add  ID bigint identity not null
go
CREATE INDEX [by_ID] ON patient_data..tbpatientdocs(ID) 
go


----------------------------------------------------------------------
use Register
go

ALTER TABLE [Register].[dbo].[tbMedicalHistory]
ADD

txtHeadaches VARCHAR(100),
Vertigo VARCHAR(1),
txtVertigo VARCHAR(100),
txtDiabetes VARCHAR(100),
EENT VARCHAR(1),
txtEENT VARCHAR(100),
txtAsthma VARCHAR(100),
txtTuberculosis VARCHAR(100),
COPD VARCHAR(1),
txtCOPD VARCHAR(100),
txtHeart VARCHAR(100),
Hypertension VARCHAR(1),
txtHypertension VARCHAR(100),
Liver VARCHAR(1),
txtLiver VARCHAR(100),
txtStomach VARCHAR(100),
GIT VARCHAR(1),
txtGIT VARCHAR(100),
txtKidney VARCHAR(100),
Allergies VARCHAR(1),
txtAllergies VARCHAR(100),
Infections VARCHAR(1),
txtInfections VARCHAR(100),
txtCancer VARCHAR(100),
Pregnant VARCHAR(1),
txtPregnant VARCHAR(100),
Abortion VARCHAR(1),
txtAbortion VARCHAR(100),
txtDateOfLastDelivery VARCHAR(100),
txtDateLastMens VARCHAR(100),
txtMeno VARCHAR(100),
txtOthers VARCHAR(100)

Go

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

use Doctors
go

ALTER TABLE Doctors.dbo.FamilyHistory
ADD

 Hypertension [bit] NOT NULL DEFAULT(0),
 Asthma [bit] NOT NULL DEFAULT(0),
 Hospitalization varchar(50),
 Injuries varchar(50),
 Medication varchar(50)

Go
------------------------------------------------
 
use Register
go

ALTER TABLE Register.dbo.tbPhysicalExamination
ADD
 
 Temperature varchar(20),
 URColor varchar(20),
 URTransparency varchar(20),
 URReaction varchar(20),
 URSpecificGravity varchar(20),
 URWBC varchar(20),
 UREpithelial varchar(20),
 URMucus varchar(20),
 URBacteria varchar(20),
 URAmorphus varchar(20),
 URAmorphusUrates varchar(20),
 URYeast varchar(20),
 URCrystals varchar(20), 
 URCasts varchar(20),
 UROthers varchar(20),
 FECColor varchar(20),
 FECConsistency varchar(20),
 FECBlood varchar(20),
 FECUrobilin varchar(20),
 FECMucus varchar(20),
 FECOccult varchar(20),
 FECBilirubin varchar(20),
 FECOva varchar(20),
 FECAmoeb varchar(20),
 FECRemarks varchar(20),
 FECWBC varchar(20),
 FECRBC varchar(20),
 URRemarks varchar(20),
 MedTech varchar(30),
 MedTechPRC varchar(30),
 BMI varchar(20),
 MCV varchar(30),
MCH varchar(30),
MCHC varchar(30),
Neutrophils varchar(30),
Lymphocytes varchar(30),
Monocytes varchar(30),
Eosinophils varchar(30),
Basophila varchar(30),
XrayReport text,
 XrayImpression text,
 Radiologist varchar (30),
 PRCRadiologist varchar (30),
 ECGImpression text,
 ECGTech varchar (30),
 PRCECGTech varchar (30),
 BUA varchar (30),
 Cholesterol varchar (30),
 HDL varchar (30),
 LDL varchar (30),
 Triglycerides varchar (30),
 RiskFactor varchar (30),
 FOBT varchar (30),
 Pathologist varchar (30),
 PRCPathologist varchar (30)
 
Go

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

use Register
go

ALTER TABLE Register.dbo.tbMedicalHistory
ADD
 
txtClassification text,
txtInitialDiagnosis text,
txtDocExaminer text,
txtDocPRC text,
txtRecommendations text,
txtDentalRecommendation text,
txtDentalExaminer text,
txtDentalExaminerPRC text

Go
------------------------------------------------


use Register
go

ALTER TABLE REGISTER.dbo.tbPhysicalExamination
ALTER COLUMN
Built varchar(20);

Go

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

 
use FixedAsset
go

ALTER TABLE FixedAsset.dbo.tblrequester
ADD
fld_DepHead  VARCHAR(50),
fld_DepHeadStatus VARCHAR(20),
fld_MM VARCHAR(50),
fld_MMStatus VARCHAR(20),
fld_CFO VARCHAR(50),
fld_CFOStatus VARCHAR(20),
fld_PO VARCHAR(50),
fld_POStatus VARCHAR(20),
fld_EVP VARCHAR(50),
fld_EVPStatus VARCHAR(20),
fld_DM VARCHAR(50),
fld_DMStatus VARCHAR(20) NULL;

Go
 ---------------------------------------------------
 
		use FixedAsset
		go
		
		ALTER TABLE FixedAsset.dbo.tblrequester
		ADD  
		fld_ApprovalStatus VARCHAR(50) NULL;
		GO
 
---------------------------------------------------
 
Use patient_data
Go
ALTER TABLE patient_data.dbo.tbPatientImage
ADD
fld_TicketNumber varchar(20) NULL;
Go


-------------------------------------------------------
alter table patient_data..tbOutPatientHistory add UserID varchar(50)
GO
alter table patient_data..tbOutPatientHistory add TransDate DateTime
GO

-------------------------------------------------------
alter table patient_data..tbPatientHistory add UserID varchar(50)
GO
alter table patient_data..tbPatientHistory add TransDate DateTime
GO

 
	
	use FixedAsset
go

ALTER TABLE FixedAsset.dbo.tblrequester
ADD
fld_Exec VARCHAR(50),
fld_ExecStatus VARCHAR(20)
Go
---------------------------------------------------
 
	use FixedAsset
go

ALTER TABLE FixedAsset.dbo.tblrequester
ADD
fld_AddApp1 VARCHAR(50),
fld_AddApp1Status VARCHAR(20),
fld_AddApp2 VARCHAR(50),
fld_AddApp2Status VARCHAR(20),
fld_AddApp3 VARCHAR(50),
fld_AddApp3Status VARCHAR(20)
Go
 
---------------------------------------------------
Use FixedAsset
Go
CREATE TABLE FixedAsset.dbo.tbPR_Items
(
[TransNo] [bigint] IDENTITY(1,1) NOT NULL,
fld_TicketNumber VARCHAR(20),
Qty VARCHAR(20),
Uom VARCHAR(20),
ItemName VARCHAR(100),
ItemID VARCHAR(20),
[Description] VARCHAR(100),
UnitCost VARCHAR(20),
Supplier VARCHAR(50),
PRNumber VARCHAR(50)
)
Go 
 
Use FixedAsset
Go
CREATE TABLE FixedAsset.dbo.tbPRNumber
(
PRNumber bigint
)
Go 
 
---------------------------------------------------
	Use FixedAsset
Go
ALTER TABLE FixedAsset.dbo.tbPR_Items
ADD
[Status] VARCHAR(10)
Go

 ---------------------------------------------------
	
	ALTER TABLE FixedAsset.dbo.tbPR_Items
ADD
[Vendor1] VARCHAR(50),
[Vendor1Price] VARCHAR(50),
[Vendor2] VARCHAR(50),
[Vendor2Price] VARCHAR(50),
[Vendor3] VARCHAR(50),
[Vendor3Price] VARCHAR(50)
Go

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

use Register
go

ALTER TABLE REGISTER.dbo.tbPhysicalExamination ALTER COLUMN SkinFind varchar(5000)
ALTER TABLE REGISTER.dbo.tbPhysicalExamination ALTER COLUMN HeadFind varchar(5000)
ALTER TABLE REGISTER.dbo.tbPhysicalExamination ALTER COLUMN EyesFind varchar(5000) 
ALTER TABLE REGISTER.dbo.tbPhysicalExamination ALTER COLUMN PupilsFind varchar(5000)  
ALTER TABLE REGISTER.dbo.tbPhysicalExamination ALTER COLUMN EarsFind varchar(5000)
ALTER TABLE REGISTER.dbo.tbPhysicalExamination ALTER COLUMN NoseFind varchar(5000) 
ALTER TABLE REGISTER.dbo.tbPhysicalExamination ALTER COLUMN MouthFind varchar(5000) 
ALTER TABLE REGISTER.dbo.tbPhysicalExamination ALTER COLUMN DentalFind varchar(5000)
ALTER TABLE REGISTER.dbo.tbPhysicalExamination ALTER COLUMN NeckFind varchar(5000)
ALTER TABLE REGISTER.dbo.tbPhysicalExamination ALTER COLUMN ChestFind varchar(5000)
ALTER TABLE REGISTER.dbo.tbPhysicalExamination ALTER COLUMN LungsFind varchar(5000)
ALTER TABLE REGISTER.dbo.tbPhysicalExamination ALTER COLUMN HeartFind varchar(5000)
ALTER TABLE REGISTER.dbo.tbPhysicalExamination ALTER COLUMN AbdomenFind varchar(5000)
ALTER TABLE REGISTER.dbo.tbPhysicalExamination ALTER COLUMN BackFind varchar(5000)
ALTER TABLE REGISTER.dbo.tbPhysicalExamination ALTER COLUMN AnusFind varchar(5000)
ALTER TABLE REGISTER.dbo.tbPhysicalExamination ALTER COLUMN GUFind varchar(5000)
ALTER TABLE REGISTER.dbo.tbPhysicalExamination ALTER COLUMN inguinalsFind  varchar(5000)
ALTER TABLE REGISTER.dbo.tbPhysicalExamination ALTER COLUMN ReflexesFind varchar(5000)
ALTER TABLE REGISTER.dbo.tbPhysicalExamination ALTER COLUMN ExtremitiesFind varchar(5000)

Go