
/****** Object:  Table [dbo].[HMS_User]    Script Date: 04/02/2017 00:22:06 ******/
SET IDENTITY_INSERT [dbo].[HMS_User] ON
INSERT [dbo].[HMS_User] ([UserId], [FirstName], [MiddleName], [LastName], [Email], [Phone], [Password], [CompanyId], [RoleId], [Address1], [Address2], [City], [State], [ZipCode], [Country], [ProfilePic], [IsActive], [IsDeleted], [CreatedDate], [ModifiedDate], [CreatedBy]) VALUES (2, N'Demo', N'M', N'Admin', N'admin@email.com', N'123456789', N'123456', 1, 2, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 0, CAST(0x0000A4860016F733 AS DateTime), CAST(0x0000A746004C8158 AS DateTime), NULL)
INSERT [dbo].[HMS_User] ([UserId], [FirstName], [MiddleName], [LastName], [Email], [Phone], [Password], [CompanyId], [RoleId], [Address1], [Address2], [City], [State], [ZipCode], [Country], [ProfilePic], [IsActive], [IsDeleted], [CreatedDate], [ModifiedDate], [CreatedBy]) VALUES (3, N'Demo', N'M', N'Doctor', N'doctor@email.com', N'512515147', N'123456', 1, 3, NULL, NULL, NULL, NULL, NULL, NULL, N'20170330060659.jpg', 1, 0, CAST(0x0000A71901273729 AS DateTime), CAST(0x0000A7460064CBCC AS DateTime), 31)
INSERT [dbo].[HMS_User] ([UserId], [FirstName], [MiddleName], [LastName], [Email], [Phone], [Password], [CompanyId], [RoleId], [Address1], [Address2], [City], [State], [ZipCode], [Country], [ProfilePic], [IsActive], [IsDeleted], [CreatedDate], [ModifiedDate], [CreatedBy]) VALUES (4, N'Demo', N'M', N'Nurse', N'nurse@email.com', N'485566475', N'123456', 1, 4, NULL, NULL, NULL, NULL, NULL, NULL, N'20170330060746.jpg', 1, 0, CAST(0x0000A71901325FB9 AS DateTime), CAST(0x0000A7460065032B AS DateTime), 31)
INSERT [dbo].[HMS_User] ([UserId], [FirstName], [MiddleName], [LastName], [Email], [Phone], [Password], [CompanyId], [RoleId], [Address1], [Address2], [City], [State], [ZipCode], [Country], [ProfilePic], [IsActive], [IsDeleted], [CreatedDate], [ModifiedDate], [CreatedBy]) VALUES (5, N'Demo', N'M', N'Pharmacist', N'pharmacist@email.com', N'8745123698', N'123456', 1, 5, NULL, NULL, NULL, NULL, NULL, NULL, N'20170330061126.jpg', 1, 0, CAST(0x0000A719013343E5 AS DateTime), CAST(0x0000A7460066054B AS DateTime), 31)
INSERT [dbo].[HMS_User] ([UserId], [FirstName], [MiddleName], [LastName], [Email], [Phone], [Password], [CompanyId], [RoleId], [Address1], [Address2], [City], [State], [ZipCode], [Country], [ProfilePic], [IsActive], [IsDeleted], [CreatedDate], [ModifiedDate], [CreatedBy]) VALUES (6, N'Demo', N'M', N'Laboratorist', N'laboratorist@email.com', N'875589947', N'123456', 1, 6, NULL, NULL, NULL, NULL, NULL, NULL, N'20170330061255.jpg', 1, 0, CAST(0x0000A71901331258 AS DateTime), CAST(0x0000A74600666DCF AS DateTime), 31)
INSERT [dbo].[HMS_User] ([UserId], [FirstName], [MiddleName], [LastName], [Email], [Phone], [Password], [CompanyId], [RoleId], [Address1], [Address2], [City], [State], [ZipCode], [Country], [ProfilePic], [IsActive], [IsDeleted], [CreatedDate], [ModifiedDate], [CreatedBy]) VALUES (7, N'Demo', N'M', N'Accountant', N'accountant@email.com', N'879456123', N'123456', 1, 7, NULL, NULL, NULL, NULL, NULL, NULL, N'20170330061234.jpg', 1, 0, CAST(0x0000A71901338BD2 AS DateTime), CAST(0x0000A746006654FC AS DateTime), 31)
INSERT [dbo].[HMS_User] ([UserId], [FirstName], [MiddleName], [LastName], [Email], [Phone], [Password], [CompanyId], [RoleId], [Address1], [Address2], [City], [State], [ZipCode], [Country], [ProfilePic], [IsActive], [IsDeleted], [CreatedDate], [ModifiedDate], [CreatedBy]) VALUES (8, N'Rosio', N'M', N'Cork', N'rosio.cork@email.com', N'123456789', N'123456', 1, 6, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 0, CAST(0x0000A4860016F733 AS DateTime), CAST(0x0000A746005631FB AS DateTime), NULL)
INSERT [dbo].[HMS_User] ([UserId], [FirstName], [MiddleName], [LastName], [Email], [Phone], [Password], [CompanyId], [RoleId], [Address1], [Address2], [City], [State], [ZipCode], [Country], [ProfilePic], [IsActive], [IsDeleted], [CreatedDate], [ModifiedDate], [CreatedBy]) VALUES (9, N'Glory', N'M', N'Culzer', N'glory.culzer@email.com', N'123456789', N'123456', 1, 3, NULL, NULL, NULL, NULL, NULL, NULL, N'20170330071930.png', 1, 0, CAST(0x0000A4860016F733 AS DateTime), CAST(0x0000A7460078B70D AS DateTime), NULL)
INSERT [dbo].[HMS_User] ([UserId], [FirstName], [MiddleName], [LastName], [Email], [Phone], [Password], [CompanyId], [RoleId], [Address1], [Address2], [City], [State], [ZipCode], [Country], [ProfilePic], [IsActive], [IsDeleted], [CreatedDate], [ModifiedDate], [CreatedBy]) VALUES (10, N'Clay', N'M', N'Hoa', N'clay.hoa@email.com', N'123456789', N'123456', 1, 5, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 0, CAST(0x0000A4860016F733 AS DateTime), CAST(0x0000A74600568F53 AS DateTime), NULL)
INSERT [dbo].[HMS_User] ([UserId], [FirstName], [MiddleName], [LastName], [Email], [Phone], [Password], [CompanyId], [RoleId], [Address1], [Address2], [City], [State], [ZipCode], [Country], [ProfilePic], [IsActive], [IsDeleted], [CreatedDate], [ModifiedDate], [CreatedBy]) VALUES (11, N'Teri', N'M', N'Emard', N'teri.emard@email.com', N'123456789', N'123456', 1, 4, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 0, CAST(0x0000A4860016F733 AS DateTime), CAST(0x0000A7460056B2CC AS DateTime), NULL)
INSERT [dbo].[HMS_User] ([UserId], [FirstName], [MiddleName], [LastName], [Email], [Phone], [Password], [CompanyId], [RoleId], [Address1], [Address2], [City], [State], [ZipCode], [Country], [ProfilePic], [IsActive], [IsDeleted], [CreatedDate], [ModifiedDate], [CreatedBy]) VALUES (12, N'Tarra', N'H', N'Ogg', N'tarra.ogg@email.com', N'123456789', N'123456', 1, 4, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 0, CAST(0x0000A4860016F733 AS DateTime), CAST(0x0000A74600595AA4 AS DateTime), NULL)
INSERT [dbo].[HMS_User] ([UserId], [FirstName], [MiddleName], [LastName], [Email], [Phone], [Password], [CompanyId], [RoleId], [Address1], [Address2], [City], [State], [ZipCode], [Country], [ProfilePic], [IsActive], [IsDeleted], [CreatedDate], [ModifiedDate], [CreatedBy]) VALUES (13, N'Victor', N'M', N'Jones', N'admin@jmanderson.com', N'123456789', N'123456', 10, 2, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 0, CAST(0x0000A4860016F733 AS DateTime), CAST(0x0000A74600510352 AS DateTime), NULL)
INSERT [dbo].[HMS_User] ([UserId], [FirstName], [MiddleName], [LastName], [Email], [Phone], [Password], [CompanyId], [RoleId], [Address1], [Address2], [City], [State], [ZipCode], [Country], [ProfilePic], [IsActive], [IsDeleted], [CreatedDate], [ModifiedDate], [CreatedBy]) VALUES (14, N'Richard', N'M', N'Johnson', N'admin@mountsinai.com', N'123456789', N'123456', 7, 2, NULL, NULL, NULL, NULL, NULL, NULL, N'20170330071829.png', 1, 0, CAST(0x0000A4860016F733 AS DateTime), CAST(0x0000A74600786FD3 AS DateTime), NULL)
INSERT [dbo].[HMS_User] ([UserId], [FirstName], [MiddleName], [LastName], [Email], [Phone], [Password], [CompanyId], [RoleId], [Address1], [Address2], [City], [State], [ZipCode], [Country], [ProfilePic], [IsActive], [IsDeleted], [CreatedDate], [ModifiedDate], [CreatedBy]) VALUES (15, N'Nick', N'M', N'Patrick', N'admin@national.com', N'123456789', N'123456', 9, 2, NULL, NULL, NULL, NULL, NULL, NULL, N'20170330071821.png', 1, 0, CAST(0x0000A4860016F733 AS DateTime), CAST(0x0000A746007865CD AS DateTime), NULL)
INSERT [dbo].[HMS_User] ([UserId], [FirstName], [MiddleName], [LastName], [Email], [Phone], [Password], [CompanyId], [RoleId], [Address1], [Address2], [City], [State], [ZipCode], [Country], [ProfilePic], [IsActive], [IsDeleted], [CreatedDate], [ModifiedDate], [CreatedBy]) VALUES (16, N'Mark', N'M', N'Doe', N'admin@providence.com', N'123456789', N'123456', 2, 2, NULL, NULL, NULL, NULL, NULL, NULL, N'20170330071811.png', 1, 0, CAST(0x0000A4860016F733 AS DateTime), CAST(0x0000A74600785A2E AS DateTime), NULL)
INSERT [dbo].[HMS_User] ([UserId], [FirstName], [MiddleName], [LastName], [Email], [Phone], [Password], [CompanyId], [RoleId], [Address1], [Address2], [City], [State], [ZipCode], [Country], [ProfilePic], [IsActive], [IsDeleted], [CreatedDate], [ModifiedDate], [CreatedBy]) VALUES (17, N'Jack', N'M', N'Wade', N'admin@royal.com', N'123456789', N'123456', 8, 2, NULL, NULL, NULL, NULL, NULL, NULL, N'20170330070948.png', 1, 0, CAST(0x0000A4860016F733 AS DateTime), CAST(0x0000A74600760C80 AS DateTime), NULL)
INSERT [dbo].[HMS_User] ([UserId], [FirstName], [MiddleName], [LastName], [Email], [Phone], [Password], [CompanyId], [RoleId], [Address1], [Address2], [City], [State], [ZipCode], [Country], [ProfilePic], [IsActive], [IsDeleted], [CreatedDate], [ModifiedDate], [CreatedBy]) VALUES (18, N'Steve', N'M', N'Doe', N'admin@sanford.com', N'123456789', N'123456', 6, 2, NULL, NULL, NULL, NULL, NULL, NULL, N'20170330071838.png', 1, 0, CAST(0x0000A4860016F733 AS DateTime), CAST(0x0000A746007879B6 AS DateTime), NULL)
INSERT [dbo].[HMS_User] ([UserId], [FirstName], [MiddleName], [LastName], [Email], [Phone], [Password], [CompanyId], [RoleId], [Address1], [Address2], [City], [State], [ZipCode], [Country], [ProfilePic], [IsActive], [IsDeleted], [CreatedDate], [ModifiedDate], [CreatedBy]) VALUES (19, N'Joe', N'M', N'Tucker', N'joe.tucker@email.com', N'123456789', N'123456', 1, 6, NULL, NULL, NULL, NULL, NULL, NULL, N'20170330074142.png', 1, 0, CAST(0x0000A4860016F733 AS DateTime), CAST(0x0000A746007ECF4E AS DateTime), NULL)
INSERT [dbo].[HMS_User] ([UserId], [FirstName], [MiddleName], [LastName], [Email], [Phone], [Password], [CompanyId], [RoleId], [Address1], [Address2], [City], [State], [ZipCode], [Country], [ProfilePic], [IsActive], [IsDeleted], [CreatedDate], [ModifiedDate], [CreatedBy]) VALUES (20, N'Mary', N'M', N'Doe', N'mary.doe@email.com', N'123456789', N'123456', 1, 7, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 0, CAST(0x0000A4860016F733 AS DateTime), CAST(0x0000A7460053BB92 AS DateTime), NULL)
INSERT [dbo].[HMS_User] ([UserId], [FirstName], [MiddleName], [LastName], [Email], [Phone], [Password], [CompanyId], [RoleId], [Address1], [Address2], [City], [State], [ZipCode], [Country], [ProfilePic], [IsActive], [IsDeleted], [CreatedDate], [ModifiedDate], [CreatedBy]) VALUES (21, N'Jane', N'M', N'Smith', N'jane.smith@email.com', N'123456789', N'123456', 1, 7, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 0, CAST(0x0000A4860016F733 AS DateTime), CAST(0x0000A7460053F2DA AS DateTime), NULL)
INSERT [dbo].[HMS_User] ([UserId], [FirstName], [MiddleName], [LastName], [Email], [Phone], [Password], [CompanyId], [RoleId], [Address1], [Address2], [City], [State], [ZipCode], [Country], [ProfilePic], [IsActive], [IsDeleted], [CreatedDate], [ModifiedDate], [CreatedBy]) VALUES (22, N'Justina', N'M', N'Hasty', N'justina.hasty@email.com', N'123456789', N'123456', 1, 4, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 0, CAST(0x0000A4860016F733 AS DateTime), CAST(0x0000A7460054F387 AS DateTime), NULL)
INSERT [dbo].[HMS_User] ([UserId], [FirstName], [MiddleName], [LastName], [Email], [Phone], [Password], [CompanyId], [RoleId], [Address1], [Address2], [City], [State], [ZipCode], [Country], [ProfilePic], [IsActive], [IsDeleted], [CreatedDate], [ModifiedDate], [CreatedBy]) VALUES (23, N'Sue', N'M', N'Laboy', N'sue.laboy@email.com', N'123456789', N'123456', 1, 7, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 0, CAST(0x0000A4860016F733 AS DateTime), CAST(0x0000A74600551ED3 AS DateTime), NULL)
INSERT [dbo].[HMS_User] ([UserId], [FirstName], [MiddleName], [LastName], [Email], [Phone], [Password], [CompanyId], [RoleId], [Address1], [Address2], [City], [State], [ZipCode], [Country], [ProfilePic], [IsActive], [IsDeleted], [CreatedDate], [ModifiedDate], [CreatedBy]) VALUES (24, N'Yuki', N'M', N'Folsi', N'yuki.folsi@email.com', N'123456789', N'123456', 1, 3, NULL, NULL, NULL, NULL, NULL, NULL, N'20170330071948.png', 1, 0, CAST(0x0000A4860016F733 AS DateTime), CAST(0x0000A7460078CC57 AS DateTime), NULL)
INSERT [dbo].[HMS_User] ([UserId], [FirstName], [MiddleName], [LastName], [Email], [Phone], [Password], [CompanyId], [RoleId], [Address1], [Address2], [City], [State], [ZipCode], [Country], [ProfilePic], [IsActive], [IsDeleted], [CreatedDate], [ModifiedDate], [CreatedBy]) VALUES (25, N'Sage', N'M', N'Ruta', N'sage.ruta@email.com', N'123456789', N'123456', 1, 4, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 0, CAST(0x0000A4860016F733 AS DateTime), CAST(0x0000A74600559D13 AS DateTime), NULL)
INSERT [dbo].[HMS_User] ([UserId], [FirstName], [MiddleName], [LastName], [Email], [Phone], [Password], [CompanyId], [RoleId], [Address1], [Address2], [City], [State], [ZipCode], [Country], [ProfilePic], [IsActive], [IsDeleted], [CreatedDate], [ModifiedDate], [CreatedBy]) VALUES (26, N'Jerry', N'M', N'Zurcher', N'jerry.zurcher@email.com', N'125258525', N'123456', 1, 6, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 0, CAST(0x0000A6E8013393D2 AS DateTime), CAST(0x0000A7460057376A AS DateTime), NULL)
INSERT [dbo].[HMS_User] ([UserId], [FirstName], [MiddleName], [LastName], [Email], [Phone], [Password], [CompanyId], [RoleId], [Address1], [Address2], [City], [State], [ZipCode], [Country], [ProfilePic], [IsActive], [IsDeleted], [CreatedDate], [ModifiedDate], [CreatedBy]) VALUES (27, N'John', N'M', N'Doe', N'admin@inca.com', N'12344557', N'123456', 4, 2, NULL, NULL, NULL, NULL, NULL, NULL, N'20170330071802.png', 1, 0, CAST(0x0000A71500BFC08F AS DateTime), CAST(0x0000A74600784FBA AS DateTime), 0)
INSERT [dbo].[HMS_User] ([UserId], [FirstName], [MiddleName], [LastName], [Email], [Phone], [Password], [CompanyId], [RoleId], [Address1], [Address2], [City], [State], [ZipCode], [Country], [ProfilePic], [IsActive], [IsDeleted], [CreatedDate], [ModifiedDate], [CreatedBy]) VALUES (28, N'Buddy', N'M', N'Clony', N'buddy.clony@email.com', N'1234567', N'123456', 1, 5, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 0, CAST(0x0000A71501025E2E AS DateTime), CAST(0x0000A74600577368 AS DateTime), 0)
INSERT [dbo].[HMS_User] ([UserId], [FirstName], [MiddleName], [LastName], [Email], [Phone], [Password], [CompanyId], [RoleId], [Address1], [Address2], [City], [State], [ZipCode], [Country], [ProfilePic], [IsActive], [IsDeleted], [CreatedDate], [ModifiedDate], [CreatedBy]) VALUES (29, N'Jim', N'M', N'Peterson', N'admin@farberdan.com', N'12122332332', N'123456', 5, 2, NULL, NULL, NULL, NULL, NULL, NULL, N'20170330071750.png', 1, 0, CAST(0x0000A715010348AC AS DateTime), CAST(0x0000A74600784250 AS DateTime), 0)
INSERT [dbo].[HMS_User] ([UserId], [FirstName], [MiddleName], [LastName], [Email], [Phone], [Password], [CompanyId], [RoleId], [Address1], [Address2], [City], [State], [ZipCode], [Country], [ProfilePic], [IsActive], [IsDeleted], [CreatedDate], [ModifiedDate], [CreatedBy]) VALUES (30, N'Raum', N'M', N'Lace', N'raum.lace@email.com', N'585441247', N'123456', 1, 6, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 0, CAST(0x0000A7150105E882 AS DateTime), CAST(0x0000A7460057A488 AS DateTime), 0)
INSERT [dbo].[HMS_User] ([UserId], [FirstName], [MiddleName], [LastName], [Email], [Phone], [Password], [CompanyId], [RoleId], [Address1], [Address2], [City], [State], [ZipCode], [Country], [ProfilePic], [IsActive], [IsDeleted], [CreatedDate], [ModifiedDate], [CreatedBy]) VALUES (31, N'Andrew', N'M', N'Hudson', N'andrew.hudson@inca.com', N'12345678', N'123456', 4, 2, NULL, NULL, NULL, NULL, NULL, NULL, N'20170330071728.png', 1, 0, CAST(0x0000A716013A6F1E AS DateTime), CAST(0x0000A7460078278D AS DateTime), 0)
INSERT [dbo].[HMS_User] ([UserId], [FirstName], [MiddleName], [LastName], [Email], [Phone], [Password], [CompanyId], [RoleId], [Address1], [Address2], [City], [State], [ZipCode], [Country], [ProfilePic], [IsActive], [IsDeleted], [CreatedDate], [ModifiedDate], [CreatedBy]) VALUES (32, N'Jack', N'M', N'Smith', N'admin@intermountain.com', N'123456789', N'123456', 11, 2, NULL, NULL, NULL, NULL, NULL, NULL, N'20170330071741.png', 1, 0, CAST(0x0000A4860016F733 AS DateTime), CAST(0x0000A7460078373D AS DateTime), NULL)
INSERT [dbo].[HMS_User] ([UserId], [FirstName], [MiddleName], [LastName], [Email], [Phone], [Password], [CompanyId], [RoleId], [Address1], [Address2], [City], [State], [ZipCode], [Country], [ProfilePic], [IsActive], [IsDeleted], [CreatedDate], [ModifiedDate], [CreatedBy]) VALUES (33, N'Cyril', N'M', N'Behen', N'cyril.behen@email.com', N'123456789', N'123456', 1, 7, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 0, CAST(0x0000A4860016F733 AS DateTime), CAST(0x0000A7460054C9B1 AS DateTime), NULL)
INSERT [dbo].[HMS_User] ([UserId], [FirstName], [MiddleName], [LastName], [Email], [Phone], [Password], [CompanyId], [RoleId], [Address1], [Address2], [City], [State], [ZipCode], [Country], [ProfilePic], [IsActive], [IsDeleted], [CreatedDate], [ModifiedDate], [CreatedBy]) VALUES (34, N'Mayra', N'M', N'Munse', N'mayra.munse@email.com', N'123456789', N'123456', 1, 5, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 0, CAST(0x0000A4860016F733 AS DateTime), CAST(0x0000A7460055EEB1 AS DateTime), NULL)
INSERT [dbo].[HMS_User] ([UserId], [FirstName], [MiddleName], [LastName], [Email], [Phone], [Password], [CompanyId], [RoleId], [Address1], [Address2], [City], [State], [ZipCode], [Country], [ProfilePic], [IsActive], [IsDeleted], [CreatedDate], [ModifiedDate], [CreatedBy]) VALUES (35, N'Jose', N'M', N'Glick', N'jose.glick@email.com', N'123456789', N'123456', 1, 5, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 0, CAST(0x0000A4860016F733 AS DateTime), CAST(0x0000A7460055C2B5 AS DateTime), NULL)
INSERT [dbo].[HMS_User] ([UserId], [FirstName], [MiddleName], [LastName], [Email], [Phone], [Password], [CompanyId], [RoleId], [Address1], [Address2], [City], [State], [ZipCode], [Country], [ProfilePic], [IsActive], [IsDeleted], [CreatedDate], [ModifiedDate], [CreatedBy]) VALUES (36, N'Lai', N'M', N'Gato', N'lai.gato@email.com', N'123456789', N'123456', 1, 3, NULL, NULL, NULL, NULL, NULL, NULL, N'20170330071940.png', 1, 0, CAST(0x0000A4860016F733 AS DateTime), CAST(0x0000A7460078C2EA AS DateTime), NULL)
INSERT [dbo].[HMS_User] ([UserId], [FirstName], [MiddleName], [LastName], [Email], [Phone], [Password], [CompanyId], [RoleId], [Address1], [Address2], [City], [State], [ZipCode], [Country], [ProfilePic], [IsActive], [IsDeleted], [CreatedDate], [ModifiedDate], [CreatedBy]) VALUES (37, N'Lonny', N'R', N'Samara', N'lonny.samara@email.com', N'987654321', N'123456', 1, 8, N'21, New Live colony', NULL, NULL, NULL, NULL, NULL, NULL, 1, 0, CAST(0x0000A71A011F56E9 AS DateTime), CAST(0x0000A746005C9762 AS DateTime), 31)
INSERT [dbo].[HMS_User] ([UserId], [FirstName], [MiddleName], [LastName], [Email], [Phone], [Password], [CompanyId], [RoleId], [Address1], [Address2], [City], [State], [ZipCode], [Country], [ProfilePic], [IsActive], [IsDeleted], [CreatedDate], [ModifiedDate], [CreatedBy]) VALUES (38, N'Brett', N'M', N'Ryser', N'brett.ryser@email.com', N'123454322', N'123456', 1, 3, NULL, NULL, NULL, NULL, NULL, NULL, N'20170330071921.png', 1, 0, CAST(0x0000A728017FB6B6 AS DateTime), CAST(0x0000A7460078ACC1 AS DateTime), 31)
INSERT [dbo].[HMS_User] ([UserId], [FirstName], [MiddleName], [LastName], [Email], [Phone], [Password], [CompanyId], [RoleId], [Address1], [Address2], [City], [State], [ZipCode], [Country], [ProfilePic], [IsActive], [IsDeleted], [CreatedDate], [ModifiedDate], [CreatedBy]) VALUES (39, N'Selma', N'M', N'Hurser', N'selma.hurse@email.com', N'84554455112', N'123456', 1, 8, N'123 Main Street, Nr. State highway, State', NULL, NULL, NULL, NULL, NULL, NULL, 1, 0, CAST(0x0000A7290153B6FA AS DateTime), CAST(0x0000A746005B7A9D AS DateTime), 31)
INSERT [dbo].[HMS_User] ([UserId], [FirstName], [MiddleName], [LastName], [Email], [Phone], [Password], [CompanyId], [RoleId], [Address1], [Address2], [City], [State], [ZipCode], [Country], [ProfilePic], [IsActive], [IsDeleted], [CreatedDate], [ModifiedDate], [CreatedBy]) VALUES (40, N'Ricky', N'M', N'Nayar', N'ricky.nayar@email.com', N'128855841', N'123456', 1, 8, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 0, CAST(0x0000A72F013DAB1E AS DateTime), CAST(0x0000A746005C5002 AS DateTime), 31)
INSERT [dbo].[HMS_User] ([UserId], [FirstName], [MiddleName], [LastName], [Email], [Phone], [Password], [CompanyId], [RoleId], [Address1], [Address2], [City], [State], [ZipCode], [Country], [ProfilePic], [IsActive], [IsDeleted], [CreatedDate], [ModifiedDate], [CreatedBy]) VALUES (41, N'Michel', N'V', N'Munis', N'michel.munis@email.com', N'1234567987', N'123456', 1, 8, N'12 Opera park, Syndey street, Aus', NULL, NULL, NULL, NULL, NULL, NULL, 1, 0, CAST(0x0000A73600EF3F88 AS DateTime), CAST(0x0000A746005BE9D1 AS DateTime), 31)
INSERT [dbo].[HMS_User] ([UserId], [FirstName], [MiddleName], [LastName], [Email], [Phone], [Password], [CompanyId], [RoleId], [Address1], [Address2], [City], [State], [ZipCode], [Country], [ProfilePic], [IsActive], [IsDeleted], [CreatedDate], [ModifiedDate], [CreatedBy]) VALUES (42, N'Gary', N'M', N'Yori', N'gary.youri@email.com', N'147852369', N'123456', 1, 8, N'1, Lee Street', NULL, NULL, NULL, NULL, NULL, N'20170330070549.png', 1, 0, CAST(0x0000A73600EF95C2 AS DateTime), CAST(0x0000A7460074F459 AS DateTime), 31)
INSERT [dbo].[HMS_User] ([UserId], [FirstName], [MiddleName], [LastName], [Email], [Phone], [Password], [CompanyId], [RoleId], [Address1], [Address2], [City], [State], [ZipCode], [Country], [ProfilePic], [IsActive], [IsDeleted], [CreatedDate], [ModifiedDate], [CreatedBy]) VALUES (43, N'Shane', N'A', N'Wade', N'shane.wade@email.com', N'456789123', N'123456', 1, 8, N'10, Platinum, Lotus road, Aus', NULL, NULL, NULL, NULL, NULL, NULL, 1, 0, CAST(0x0000A73600F24488 AS DateTime), CAST(0x0000A746005CBB37 AS DateTime), 31)
INSERT [dbo].[HMS_User] ([UserId], [FirstName], [MiddleName], [LastName], [Email], [Phone], [Password], [CompanyId], [RoleId], [Address1], [Address2], [City], [State], [ZipCode], [Country], [ProfilePic], [IsActive], [IsDeleted], [CreatedDate], [ModifiedDate], [CreatedBy]) VALUES (44, N'Hoa', N'N', N'Sarao', N'hoa.sarao@email.com', N'123456789', N'123456', 1, 8, N'15, Lotus Plaza, Aus', NULL, NULL, NULL, NULL, NULL, NULL, 1, 0, CAST(0x0000A7360115EBF7 AS DateTime), CAST(0x0000A746005C1618 AS DateTime), 31)
INSERT [dbo].[HMS_User] ([UserId], [FirstName], [MiddleName], [LastName], [Email], [Phone], [Password], [CompanyId], [RoleId], [Address1], [Address2], [City], [State], [ZipCode], [Country], [ProfilePic], [IsActive], [IsDeleted], [CreatedDate], [ModifiedDate], [CreatedBy]) VALUES (45, N'Cassi', N'M', N'Lipkin', N'cassi.lipkin@email.com', N'5285544789', N'123456', 1, 8, N'12, New Street', NULL, NULL, NULL, NULL, NULL, N'20170330072206.png', 1, 0, CAST(0x0000A74600796DFD AS DateTime), CAST(0x0000A74600796DFD AS DateTime), 2)
SET IDENTITY_INSERT [dbo].[HMS_User] OFF
/****** Object:  Table [dbo].[HMS_PrescriptionDetail]    Script Date: 04/02/2017 00:22:06 ******/
SET IDENTITY_INSERT [dbo].[HMS_PrescriptionDetail] ON
INSERT [dbo].[HMS_PrescriptionDetail] ([PrescriptionDetailId], [PrescriptionId], [PatientId], [MedicineId], [NoOfDays], [WhenToTake], [IsBeforeMeal]) VALUES (3, 2, 37, 3, 5, N'1-1-1', 0)
INSERT [dbo].[HMS_PrescriptionDetail] ([PrescriptionDetailId], [PrescriptionId], [PatientId], [MedicineId], [NoOfDays], [WhenToTake], [IsBeforeMeal]) VALUES (4, 2, 37, 6, 5, N'1-1-1', 0)
INSERT [dbo].[HMS_PrescriptionDetail] ([PrescriptionDetailId], [PrescriptionId], [PatientId], [MedicineId], [NoOfDays], [WhenToTake], [IsBeforeMeal]) VALUES (5, 2, 37, 2, 5, N'1-0-1', 0)
INSERT [dbo].[HMS_PrescriptionDetail] ([PrescriptionDetailId], [PrescriptionId], [PatientId], [MedicineId], [NoOfDays], [WhenToTake], [IsBeforeMeal]) VALUES (6, 2, 37, 1, 5, N'1-0-0', 1)
INSERT [dbo].[HMS_PrescriptionDetail] ([PrescriptionDetailId], [PrescriptionId], [PatientId], [MedicineId], [NoOfDays], [WhenToTake], [IsBeforeMeal]) VALUES (7, 3, 42, 1, 3, N'1-1-1', 0)
SET IDENTITY_INSERT [dbo].[HMS_PrescriptionDetail] OFF
/****** Object:  Table [dbo].[HMS_Prescription]    Script Date: 04/02/2017 00:22:06 ******/
SET IDENTITY_INSERT [dbo].[HMS_Prescription] ON
INSERT [dbo].[HMS_Prescription] ([PrescriptionId], [PatientCheckupId], [PatientId], [TreatmentId], [CaseHistory], [ExtraNotes], [PrescriptionDate]) VALUES (2, 2, 37, 1, NULL, NULL, CAST(0x0000A72A0147699F AS DateTime))
INSERT [dbo].[HMS_Prescription] ([PrescriptionId], [PatientCheckupId], [PatientId], [TreatmentId], [CaseHistory], [ExtraNotes], [PrescriptionDate]) VALUES (3, 3, 42, 0, NULL, NULL, CAST(0x0000A7460073BE64 AS DateTime))
SET IDENTITY_INSERT [dbo].[HMS_Prescription] OFF
/****** Object:  Table [dbo].[HMS_PaymentDetail]    Script Date: 04/02/2017 00:22:06 ******/
SET IDENTITY_INSERT [dbo].[HMS_PaymentDetail] ON
INSERT [dbo].[HMS_PaymentDetail] ([PaymentDetailId], [PaymentId], [PaymentCategoryId], [PaymentAmount]) VALUES (12, 3, 1, 50.0000)
INSERT [dbo].[HMS_PaymentDetail] ([PaymentDetailId], [PaymentId], [PaymentCategoryId], [PaymentAmount]) VALUES (13, 1, 1, 10.0000)
INSERT [dbo].[HMS_PaymentDetail] ([PaymentDetailId], [PaymentId], [PaymentCategoryId], [PaymentAmount]) VALUES (14, 1, 2, 50.0000)
INSERT [dbo].[HMS_PaymentDetail] ([PaymentDetailId], [PaymentId], [PaymentCategoryId], [PaymentAmount]) VALUES (15, 7, 1, 500.0000)
INSERT [dbo].[HMS_PaymentDetail] ([PaymentDetailId], [PaymentId], [PaymentCategoryId], [PaymentAmount]) VALUES (16, 7, 2, 250.0000)
INSERT [dbo].[HMS_PaymentDetail] ([PaymentDetailId], [PaymentId], [PaymentCategoryId], [PaymentAmount]) VALUES (17, 7, 3, 300.0000)
INSERT [dbo].[HMS_PaymentDetail] ([PaymentDetailId], [PaymentId], [PaymentCategoryId], [PaymentAmount]) VALUES (18, 8, 1, 100.0000)
INSERT [dbo].[HMS_PaymentDetail] ([PaymentDetailId], [PaymentId], [PaymentCategoryId], [PaymentAmount]) VALUES (19, 8, 2, 500.0000)
SET IDENTITY_INSERT [dbo].[HMS_PaymentDetail] OFF
/****** Object:  Table [dbo].[HMS_PaymentCategory]    Script Date: 04/02/2017 00:22:06 ******/
SET IDENTITY_INSERT [dbo].[HMS_PaymentCategory] ON
INSERT [dbo].[HMS_PaymentCategory] ([PaymentCategoryId], [PaymentCategory], [CompanyId], [Description], [IsActive], [IsDeleted], [CreatedDate], [ModifiedDate], [CreatedBy], [ModifiedBy]) VALUES (1, N'Consulting Charge', 1, N'General Consulting Charge', 1, 0, CAST(0x0000A73200CFA7EF AS DateTime), NULL, 31, NULL)
INSERT [dbo].[HMS_PaymentCategory] ([PaymentCategoryId], [PaymentCategory], [CompanyId], [Description], [IsActive], [IsDeleted], [CreatedDate], [ModifiedDate], [CreatedBy], [ModifiedBy]) VALUES (2, N'Medicine Charge', 1, N'Medicine Charge', 1, 0, CAST(0x0000A73201475E95 AS DateTime), NULL, 31, NULL)
INSERT [dbo].[HMS_PaymentCategory] ([PaymentCategoryId], [PaymentCategory], [CompanyId], [Description], [IsActive], [IsDeleted], [CreatedDate], [ModifiedDate], [CreatedBy], [ModifiedBy]) VALUES (3, N'Blood Report', 1, N'Blood Report', 1, 0, CAST(0x0000A7320147701D AS DateTime), NULL, 31, NULL)
INSERT [dbo].[HMS_PaymentCategory] ([PaymentCategoryId], [PaymentCategory], [CompanyId], [Description], [IsActive], [IsDeleted], [CreatedDate], [ModifiedDate], [CreatedBy], [ModifiedBy]) VALUES (4, N'Injection Charge', 1, N'Injection Charge', 1, 0, CAST(0x0000A73300D71F85 AS DateTime), NULL, 31, NULL)
INSERT [dbo].[HMS_PaymentCategory] ([PaymentCategoryId], [PaymentCategory], [CompanyId], [Description], [IsActive], [IsDeleted], [CreatedDate], [ModifiedDate], [CreatedBy], [ModifiedBy]) VALUES (5, N'X-ray Charge', 1, N'X-ray Charge', 1, 0, CAST(0x0000A73300E72347 AS DateTime), NULL, 31, NULL)
INSERT [dbo].[HMS_PaymentCategory] ([PaymentCategoryId], [PaymentCategory], [CompanyId], [Description], [IsActive], [IsDeleted], [CreatedDate], [ModifiedDate], [CreatedBy], [ModifiedBy]) VALUES (6, N'MRI Charge', 1, N'MRI', 1, 0, CAST(0x0000A73300E73735 AS DateTime), NULL, 31, NULL)
SET IDENTITY_INSERT [dbo].[HMS_PaymentCategory] OFF
/****** Object:  Table [dbo].[HMS_Payment]    Script Date: 04/02/2017 00:22:06 ******/
SET IDENTITY_INSERT [dbo].[HMS_Payment] ON
INSERT [dbo].[HMS_Payment] ([PaymentId], [InvoiceNumber], [PatientId], [CompanyId], [PaymentDate], [SubTotal], [Discount], [Tax], [GrandTotal], [PaymentStatus], [IsDeleted], [CreatedDate], [ModifiedDate], [CreatedBy], [ModifiedBy]) VALUES (1, N'INV-1', 40, 1, CAST(0x0000A73300C291AA AS DateTime), 60.0000, 1.0000, 0.0000, 59.0000, 0, 1, CAST(0x0000A73300C291AA AS DateTime), CAST(0x0000A74800514F6B AS DateTime), 31, 2)
INSERT [dbo].[HMS_Payment] ([PaymentId], [InvoiceNumber], [PatientId], [CompanyId], [PaymentDate], [SubTotal], [Discount], [Tax], [GrandTotal], [PaymentStatus], [IsDeleted], [CreatedDate], [ModifiedDate], [CreatedBy], [ModifiedBy]) VALUES (2, N'INV-2', 37, 1, CAST(0x0000A73300ECAEE3 AS DateTime), 0.0000, 0.0000, 0.0000, 0.0000, 0, 1, CAST(0x0000A73300ECAEE3 AS DateTime), NULL, 31, NULL)
INSERT [dbo].[HMS_Payment] ([PaymentId], [InvoiceNumber], [PatientId], [CompanyId], [PaymentDate], [SubTotal], [Discount], [Tax], [GrandTotal], [PaymentStatus], [IsDeleted], [CreatedDate], [ModifiedDate], [CreatedBy], [ModifiedBy]) VALUES (3, N'INV-3', 37, 1, CAST(0x0000A733011CFAFF AS DateTime), 50.0000, 0.0000, 0.0000, 50.0000, 1, 1, CAST(0x0000A733011CFAFF AS DateTime), CAST(0x0000A74800514512 AS DateTime), 31, 2)
INSERT [dbo].[HMS_Payment] ([PaymentId], [InvoiceNumber], [PatientId], [CompanyId], [PaymentDate], [SubTotal], [Discount], [Tax], [GrandTotal], [PaymentStatus], [IsDeleted], [CreatedDate], [ModifiedDate], [CreatedBy], [ModifiedBy]) VALUES (4, N'INV-4', 0, 1, CAST(0x0000A74800512ECC AS DateTime), 0.0000, 0.0000, 0.0000, 0.0000, 0, 0, CAST(0x0000A74800512ECC AS DateTime), NULL, 2, NULL)
INSERT [dbo].[HMS_Payment] ([PaymentId], [InvoiceNumber], [PatientId], [CompanyId], [PaymentDate], [SubTotal], [Discount], [Tax], [GrandTotal], [PaymentStatus], [IsDeleted], [CreatedDate], [ModifiedDate], [CreatedBy], [ModifiedBy]) VALUES (5, N'INV-5', 0, 1, CAST(0x0000A74800515A83 AS DateTime), 0.0000, 0.0000, 0.0000, 0.0000, 0, 0, CAST(0x0000A74800515A83 AS DateTime), NULL, 2, NULL)
INSERT [dbo].[HMS_Payment] ([PaymentId], [InvoiceNumber], [PatientId], [CompanyId], [PaymentDate], [SubTotal], [Discount], [Tax], [GrandTotal], [PaymentStatus], [IsDeleted], [CreatedDate], [ModifiedDate], [CreatedBy], [ModifiedBy]) VALUES (6, N'INV-6', 0, 1, CAST(0x0000A74800516C2E AS DateTime), 0.0000, 0.0000, 0.0000, 0.0000, 0, 0, CAST(0x0000A74800516C2E AS DateTime), NULL, 2, NULL)
INSERT [dbo].[HMS_Payment] ([PaymentId], [InvoiceNumber], [PatientId], [CompanyId], [PaymentDate], [SubTotal], [Discount], [Tax], [GrandTotal], [PaymentStatus], [IsDeleted], [CreatedDate], [ModifiedDate], [CreatedBy], [ModifiedBy]) VALUES (7, N'INV-7', 42, 1, CAST(0x0000A7480051B462 AS DateTime), 1050.0000, 0.0000, 0.0000, 1050.0000, 1, 0, CAST(0x0000A7480051B462 AS DateTime), NULL, 2, NULL)
INSERT [dbo].[HMS_Payment] ([PaymentId], [InvoiceNumber], [PatientId], [CompanyId], [PaymentDate], [SubTotal], [Discount], [Tax], [GrandTotal], [PaymentStatus], [IsDeleted], [CreatedDate], [ModifiedDate], [CreatedBy], [ModifiedBy]) VALUES (8, N'INV-8', 44, 1, CAST(0x0000A7480051EB95 AS DateTime), 600.0000, 0.0000, 0.0000, 600.0000, 0, 0, CAST(0x0000A7480051EB95 AS DateTime), NULL, 2, NULL)
SET IDENTITY_INSERT [dbo].[HMS_Payment] OFF
/****** Object:  Table [dbo].[HMS_PatientTestDetail]    Script Date: 04/02/2017 00:22:06 ******/
SET IDENTITY_INSERT [dbo].[HMS_PatientTestDetail] ON
INSERT [dbo].[HMS_PatientTestDetail] ([PatientTestDetailId], [PatientTestId], [LabTestId], [Result], [Remarks]) VALUES (2, 1, 1, N'20.5      ', N'normal')
INSERT [dbo].[HMS_PatientTestDetail] ([PatientTestDetailId], [PatientTestId], [LabTestId], [Result], [Remarks]) VALUES (4, 2, 3, NULL, NULL)
SET IDENTITY_INSERT [dbo].[HMS_PatientTestDetail] OFF
/****** Object:  Table [dbo].[HMS_PatientTest]    Script Date: 04/02/2017 00:22:06 ******/
SET IDENTITY_INSERT [dbo].[HMS_PatientTest] ON
INSERT [dbo].[HMS_PatientTest] ([PatientTestId], [CompanyId], [PatientId], [ConsultantId], [DeliveryDate], [TestDate], [ReportStatus], [IsDeleted], [CreatedDate], [ModifiedDate], [CreatedBy], [ModifiedBy]) VALUES (1, 1, 42, 32, CAST(0x0000A74700000000 AS DateTime), CAST(0x0000A74400000000 AS DateTime), 0, 0, CAST(0x0000A7440125852E AS DateTime), CAST(0x0000A7440141A123 AS DateTime), 31, 31)
INSERT [dbo].[HMS_PatientTest] ([PatientTestId], [CompanyId], [PatientId], [ConsultantId], [DeliveryDate], [TestDate], [ReportStatus], [IsDeleted], [CreatedDate], [ModifiedDate], [CreatedBy], [ModifiedBy]) VALUES (2, 1, 41, 32, CAST(0x0000A74700000000 AS DateTime), CAST(0x0000A74500000000 AS DateTime), 1, 0, CAST(0x0000A74401423144 AS DateTime), CAST(0x0000A74401431882 AS DateTime), 31, 31)
SET IDENTITY_INSERT [dbo].[HMS_PatientTest] OFF
/****** Object:  Table [dbo].[HMS_PatientDetail]    Script Date: 04/02/2017 00:22:06 ******/
SET IDENTITY_INSERT [dbo].[HMS_PatientDetail] ON
INSERT [dbo].[HMS_PatientDetail] ([PatientId], [PatientCode], [UserId], [PatientType], [BirthDate], [Gender], [BloodGroup]) VALUES (1, NULL, 37, NULL, CAST(0x000073AE00000000 AS DateTime), N'Female', N'O+')
INSERT [dbo].[HMS_PatientDetail] ([PatientId], [PatientCode], [UserId], [PatientType], [BirthDate], [Gender], [BloodGroup]) VALUES (2, NULL, 39, NULL, CAST(0x000070C100000000 AS DateTime), N'Female', N'O+')
INSERT [dbo].[HMS_PatientDetail] ([PatientId], [PatientCode], [UserId], [PatientType], [BirthDate], [Gender], [BloodGroup]) VALUES (3, NULL, 40, NULL, CAST(0x0000A72F00000000 AS DateTime), N'Male', N'A-')
INSERT [dbo].[HMS_PatientDetail] ([PatientId], [PatientCode], [UserId], [PatientType], [BirthDate], [Gender], [BloodGroup]) VALUES (4, NULL, 41, NULL, CAST(0x0000726000000000 AS DateTime), N'Male', N'B+')
INSERT [dbo].[HMS_PatientDetail] ([PatientId], [PatientCode], [UserId], [PatientType], [BirthDate], [Gender], [BloodGroup]) VALUES (5, NULL, 42, NULL, CAST(0x00007B4A00000000 AS DateTime), N'Male', N'AB+')
INSERT [dbo].[HMS_PatientDetail] ([PatientId], [PatientCode], [UserId], [PatientType], [BirthDate], [Gender], [BloodGroup]) VALUES (6, NULL, 43, NULL, CAST(0x000070B600000000 AS DateTime), N'Male', N'AB-')
INSERT [dbo].[HMS_PatientDetail] ([PatientId], [PatientCode], [UserId], [PatientType], [BirthDate], [Gender], [BloodGroup]) VALUES (7, NULL, 44, NULL, CAST(0x00007AEE00000000 AS DateTime), N'Female', N'O-')
INSERT [dbo].[HMS_PatientDetail] ([PatientId], [PatientCode], [UserId], [PatientType], [BirthDate], [Gender], [BloodGroup]) VALUES (8, NULL, 45, NULL, CAST(0x000086C200000000 AS DateTime), N'Female', N'A-')
SET IDENTITY_INSERT [dbo].[HMS_PatientDetail] OFF
/****** Object:  Table [dbo].[HMS_PatientCheckup]    Script Date: 04/02/2017 00:22:06 ******/
SET IDENTITY_INSERT [dbo].[HMS_PatientCheckup] ON
INSERT [dbo].[HMS_PatientCheckup] ([PatientCheckupId], [PatientId], [CheckupDate], [DoctorId], [Symptoms], [Diagnosis], [CreatedDate], [CreatedBy], [ModifiedDate], [ModifiedBy]) VALUES (2, 37, CAST(0x0000A72A00000000 AS DateTime), 32, N'Fever', N'Report', CAST(0x0000A72A0147699E AS DateTime), 31, NULL, NULL)
INSERT [dbo].[HMS_PatientCheckup] ([PatientCheckupId], [PatientId], [CheckupDate], [DoctorId], [Symptoms], [Diagnosis], [CreatedDate], [CreatedBy], [ModifiedDate], [ModifiedBy]) VALUES (3, 42, CAST(0x0000A73600000000 AS DateTime), 38, N'Headache', N'Migrane report', CAST(0x0000A7460073BE30 AS DateTime), 2, NULL, NULL)
SET IDENTITY_INSERT [dbo].[HMS_PatientCheckup] OFF
/****** Object:  Table [dbo].[HMS_MedicineCategory]    Script Date: 04/02/2017 00:22:06 ******/
SET IDENTITY_INSERT [dbo].[HMS_MedicineCategory] ON
INSERT [dbo].[HMS_MedicineCategory] ([MedicineCategoryId], [MedicineCategory], [CompanyId], [IsActive], [IsDeleted], [CreatedDate], [ModifiedDate], [CreatedBy], [ModifiedBy]) VALUES (1, N'Fever', 1, 1, 0, CAST(0x0000A72A014162FF AS DateTime), NULL, 31, NULL)
INSERT [dbo].[HMS_MedicineCategory] ([MedicineCategoryId], [MedicineCategory], [CompanyId], [IsActive], [IsDeleted], [CreatedDate], [ModifiedDate], [CreatedBy], [ModifiedBy]) VALUES (2, N'Cold', 1, 1, 0, CAST(0x0000A72A014177C8 AS DateTime), CAST(0x0000A732000B68ED AS DateTime), 31, 31)
INSERT [dbo].[HMS_MedicineCategory] ([MedicineCategoryId], [MedicineCategory], [CompanyId], [IsActive], [IsDeleted], [CreatedDate], [ModifiedDate], [CreatedBy], [ModifiedBy]) VALUES (3, N'Anxiety', 1, 1, 0, CAST(0x0000A7460172569F AS DateTime), NULL, 2, NULL)
INSERT [dbo].[HMS_MedicineCategory] ([MedicineCategoryId], [MedicineCategory], [CompanyId], [IsActive], [IsDeleted], [CreatedDate], [ModifiedDate], [CreatedBy], [ModifiedBy]) VALUES (4, N'GERD', 1, 1, 0, CAST(0x0000A7460172B276 AS DateTime), NULL, 2, NULL)
INSERT [dbo].[HMS_MedicineCategory] ([MedicineCategoryId], [MedicineCategory], [CompanyId], [IsActive], [IsDeleted], [CreatedDate], [ModifiedDate], [CreatedBy], [ModifiedBy]) VALUES (5, N' Severe Pain', 1, 1, 0, CAST(0x0000A7460172E1CB AS DateTime), NULL, 2, NULL)
INSERT [dbo].[HMS_MedicineCategory] ([MedicineCategoryId], [MedicineCategory], [CompanyId], [IsActive], [IsDeleted], [CreatedDate], [ModifiedDate], [CreatedBy], [ModifiedBy]) VALUES (6, N'Depression', 1, 1, 0, CAST(0x0000A74601735617 AS DateTime), NULL, 2, NULL)
INSERT [dbo].[HMS_MedicineCategory] ([MedicineCategoryId], [MedicineCategory], [CompanyId], [IsActive], [IsDeleted], [CreatedDate], [ModifiedDate], [CreatedBy], [ModifiedBy]) VALUES (7, N'Arthritis', 1, 1, 0, CAST(0x0000A746017428B1 AS DateTime), NULL, 2, NULL)
INSERT [dbo].[HMS_MedicineCategory] ([MedicineCategoryId], [MedicineCategory], [CompanyId], [IsActive], [IsDeleted], [CreatedDate], [ModifiedDate], [CreatedBy], [ModifiedBy]) VALUES (8, N'Nerve pain', 1, 1, 0, CAST(0x0000A7460174894E AS DateTime), NULL, 2, NULL)
INSERT [dbo].[HMS_MedicineCategory] ([MedicineCategoryId], [MedicineCategory], [CompanyId], [IsActive], [IsDeleted], [CreatedDate], [ModifiedDate], [CreatedBy], [ModifiedBy]) VALUES (9, N'High BP', 1, 1, 0, CAST(0x0000A7460174BD20 AS DateTime), NULL, 2, NULL)
INSERT [dbo].[HMS_MedicineCategory] ([MedicineCategoryId], [MedicineCategory], [CompanyId], [IsActive], [IsDeleted], [CreatedDate], [ModifiedDate], [CreatedBy], [ModifiedBy]) VALUES (10, N'Type 2 Diabities', 1, 1, 0, CAST(0x0000A7460174DF6B AS DateTime), NULL, 2, NULL)
INSERT [dbo].[HMS_MedicineCategory] ([MedicineCategoryId], [MedicineCategory], [CompanyId], [IsActive], [IsDeleted], [CreatedDate], [ModifiedDate], [CreatedBy], [ModifiedBy]) VALUES (11, N'Infection', 1, 1, 0, CAST(0x0000A7460175338E AS DateTime), NULL, 2, NULL)
SET IDENTITY_INSERT [dbo].[HMS_MedicineCategory] OFF
/****** Object:  Table [dbo].[HMS_Medicine]    Script Date: 04/02/2017 00:22:06 ******/
SET IDENTITY_INSERT [dbo].[HMS_Medicine] ON
INSERT [dbo].[HMS_Medicine] ([MedicineId], [CompanyId], [MedicineName], [Description], [MedicineCategoryId], [CostPrice], [SalePrice], [AvailableQuantity], [UnitId], [HMS_Company], [IsActive], [IsDeleted], [CreatedDate], [ModifiedDate], [CreatedBy], [ModifiedBy]) VALUES (1, 1, N'Tramadol', NULL, 5, 50.0000, 60.0000, 1000, 1, NULL, 1, 0, CAST(0x0000A72900000000 AS DateTime), CAST(0x0000A7460172F90D AS DateTime), 31, 2)
INSERT [dbo].[HMS_Medicine] ([MedicineId], [CompanyId], [MedicineName], [Description], [MedicineCategoryId], [CostPrice], [SalePrice], [AvailableQuantity], [UnitId], [HMS_Company], [IsActive], [IsDeleted], [CreatedDate], [ModifiedDate], [CreatedBy], [ModifiedBy]) VALUES (2, 1, N'Lorazepam', NULL, 3, 60.0000, 70.0000, 1200, 1, NULL, 1, 0, CAST(0x0000A72900000000 AS DateTime), CAST(0x0000A746017337A2 AS DateTime), 31, 2)
INSERT [dbo].[HMS_Medicine] ([MedicineId], [CompanyId], [MedicineName], [Description], [MedicineCategoryId], [CostPrice], [SalePrice], [AvailableQuantity], [UnitId], [HMS_Company], [IsActive], [IsDeleted], [CreatedDate], [ModifiedDate], [CreatedBy], [ModifiedBy]) VALUES (3, 1, N'Citalopram', NULL, 6, 70.0000, 80.0000, 1400, 1, NULL, 1, 0, CAST(0x0000A72900000000 AS DateTime), CAST(0x0000A7460173BACA AS DateTime), 31, 2)
INSERT [dbo].[HMS_Medicine] ([MedicineId], [CompanyId], [MedicineName], [Description], [MedicineCategoryId], [CostPrice], [SalePrice], [AvailableQuantity], [UnitId], [HMS_Company], [IsActive], [IsDeleted], [CreatedDate], [ModifiedDate], [CreatedBy], [ModifiedBy]) VALUES (4, 1, N'Lexapro', NULL, 3, 80.0000, 80.0000, 1500, 1, NULL, 1, 0, CAST(0x0000A72900000000 AS DateTime), CAST(0x0000A746017272B2 AS DateTime), 31, 2)
INSERT [dbo].[HMS_Medicine] ([MedicineId], [CompanyId], [MedicineName], [Description], [MedicineCategoryId], [CostPrice], [SalePrice], [AvailableQuantity], [UnitId], [HMS_Company], [IsActive], [IsDeleted], [CreatedDate], [ModifiedDate], [CreatedBy], [ModifiedBy]) VALUES (6, 1, N'Acetaminophen', NULL, 1, NULL, NULL, NULL, NULL, NULL, 1, 0, CAST(0x0000A72A014333A3 AS DateTime), CAST(0x0000A7460171C2F1 AS DateTime), 31, 2)
INSERT [dbo].[HMS_Medicine] ([MedicineId], [CompanyId], [MedicineName], [Description], [MedicineCategoryId], [CostPrice], [SalePrice], [AvailableQuantity], [UnitId], [HMS_Company], [IsActive], [IsDeleted], [CreatedDate], [ModifiedDate], [CreatedBy], [ModifiedBy]) VALUES (7, 1, N'Omeprazole', NULL, 4, NULL, NULL, NULL, NULL, NULL, 1, 0, CAST(0x0000A7460172A066 AS DateTime), CAST(0x0000A7460172C11C AS DateTime), 2, 2)
INSERT [dbo].[HMS_Medicine] ([MedicineId], [CompanyId], [MedicineName], [Description], [MedicineCategoryId], [CostPrice], [SalePrice], [AvailableQuantity], [UnitId], [HMS_Company], [IsActive], [IsDeleted], [CreatedDate], [ModifiedDate], [CreatedBy], [ModifiedBy]) VALUES (8, 1, N'Cymbalta', NULL, 3, NULL, NULL, NULL, NULL, NULL, 1, 0, CAST(0x0000A7460173E4D0 AS DateTime), NULL, 2, NULL)
INSERT [dbo].[HMS_Medicine] ([MedicineId], [CompanyId], [MedicineName], [Description], [MedicineCategoryId], [CostPrice], [SalePrice], [AvailableQuantity], [UnitId], [HMS_Company], [IsActive], [IsDeleted], [CreatedDate], [ModifiedDate], [CreatedBy], [ModifiedBy]) VALUES (9, 1, N'Ativan', NULL, 3, NULL, NULL, NULL, NULL, NULL, 1, 0, CAST(0x0000A7460174060D AS DateTime), NULL, 2, NULL)
INSERT [dbo].[HMS_Medicine] ([MedicineId], [CompanyId], [MedicineName], [Description], [MedicineCategoryId], [CostPrice], [SalePrice], [AvailableQuantity], [UnitId], [HMS_Company], [IsActive], [IsDeleted], [CreatedDate], [ModifiedDate], [CreatedBy], [ModifiedBy]) VALUES (10, 1, N'Naproxen', NULL, 7, NULL, NULL, NULL, NULL, NULL, 1, 0, CAST(0x0000A746017446B5 AS DateTime), NULL, 2, NULL)
INSERT [dbo].[HMS_Medicine] ([MedicineId], [CompanyId], [MedicineName], [Description], [MedicineCategoryId], [CostPrice], [SalePrice], [AvailableQuantity], [UnitId], [HMS_Company], [IsActive], [IsDeleted], [CreatedDate], [ModifiedDate], [CreatedBy], [ModifiedBy]) VALUES (11, 1, N'Ibuprofen', NULL, 7, NULL, NULL, NULL, NULL, NULL, 1, 0, CAST(0x0000A746017456D8 AS DateTime), NULL, 2, NULL)
INSERT [dbo].[HMS_Medicine] ([MedicineId], [CompanyId], [MedicineName], [Description], [MedicineCategoryId], [CostPrice], [SalePrice], [AvailableQuantity], [UnitId], [HMS_Company], [IsActive], [IsDeleted], [CreatedDate], [ModifiedDate], [CreatedBy], [ModifiedBy]) VALUES (12, 1, N'Gabapentin', NULL, 8, NULL, NULL, NULL, NULL, NULL, 1, 0, CAST(0x0000A74601747A44 AS DateTime), CAST(0x0000A746017498C4 AS DateTime), 2, 2)
INSERT [dbo].[HMS_Medicine] ([MedicineId], [CompanyId], [MedicineName], [Description], [MedicineCategoryId], [CostPrice], [SalePrice], [AvailableQuantity], [UnitId], [HMS_Company], [IsActive], [IsDeleted], [CreatedDate], [ModifiedDate], [CreatedBy], [ModifiedBy]) VALUES (13, 1, N'Metoprolol', NULL, 9, NULL, NULL, NULL, NULL, NULL, 1, 0, CAST(0x0000A7460174C746 AS DateTime), NULL, 2, NULL)
INSERT [dbo].[HMS_Medicine] ([MedicineId], [CompanyId], [MedicineName], [Description], [MedicineCategoryId], [CostPrice], [SalePrice], [AvailableQuantity], [UnitId], [HMS_Company], [IsActive], [IsDeleted], [CreatedDate], [ModifiedDate], [CreatedBy], [ModifiedBy]) VALUES (14, 1, N'Metformin', NULL, 10, NULL, NULL, NULL, NULL, NULL, 1, 0, CAST(0x0000A7460174EA96 AS DateTime), NULL, 2, NULL)
INSERT [dbo].[HMS_Medicine] ([MedicineId], [CompanyId], [MedicineName], [Description], [MedicineCategoryId], [CostPrice], [SalePrice], [AvailableQuantity], [UnitId], [HMS_Company], [IsActive], [IsDeleted], [CreatedDate], [ModifiedDate], [CreatedBy], [ModifiedBy]) VALUES (15, 1, N'Xanax', NULL, 3, NULL, NULL, NULL, NULL, NULL, 1, 0, CAST(0x0000A7460174FFF4 AS DateTime), NULL, 2, NULL)
INSERT [dbo].[HMS_Medicine] ([MedicineId], [CompanyId], [MedicineName], [Description], [MedicineCategoryId], [CostPrice], [SalePrice], [AvailableQuantity], [UnitId], [HMS_Company], [IsActive], [IsDeleted], [CreatedDate], [ModifiedDate], [CreatedBy], [ModifiedBy]) VALUES (16, 1, N'Amoxicillin', NULL, 11, NULL, NULL, NULL, NULL, NULL, 1, 0, CAST(0x0000A74601753BFF AS DateTime), NULL, 2, NULL)
SET IDENTITY_INSERT [dbo].[HMS_Medicine] OFF
/****** Object:  Table [dbo].[HMS_LabTestCategory]    Script Date: 04/02/2017 00:22:06 ******/
SET IDENTITY_INSERT [dbo].[HMS_LabTestCategory] ON
INSERT [dbo].[HMS_LabTestCategory] ([LabTestCategoryId], [LabTestCategoryName], [Description], [CompanyId], [IsActive], [IsDeleted], [CreatedDate], [ModifiedDate], [CreatedBy], [ModifiedBy]) VALUES (1, N'Blood', N'Blood Report', 1, 1, 0, CAST(0x0000A7430124C9A5 AS DateTime), CAST(0x0000A7430125270E AS DateTime), 31, 31)
INSERT [dbo].[HMS_LabTestCategory] ([LabTestCategoryId], [LabTestCategoryName], [Description], [CompanyId], [IsActive], [IsDeleted], [CreatedDate], [ModifiedDate], [CreatedBy], [ModifiedBy]) VALUES (2, N'Diabetic', N'Diabetic', 1, 1, 0, CAST(0x0000A7430124D737 AS DateTime), CAST(0x0000A748006D11EE AS DateTime), 31, 2)
INSERT [dbo].[HMS_LabTestCategory] ([LabTestCategoryId], [LabTestCategoryName], [Description], [CompanyId], [IsActive], [IsDeleted], [CreatedDate], [ModifiedDate], [CreatedBy], [ModifiedBy]) VALUES (3, N'Heart', NULL, 1, 1, 0, CAST(0x0000A748006CA91D AS DateTime), NULL, 2, NULL)
INSERT [dbo].[HMS_LabTestCategory] ([LabTestCategoryId], [LabTestCategoryName], [Description], [CompanyId], [IsActive], [IsDeleted], [CreatedDate], [ModifiedDate], [CreatedBy], [ModifiedBy]) VALUES (4, N'Liver', NULL, 1, 1, 0, CAST(0x0000A748006CB6A4 AS DateTime), NULL, 2, NULL)
INSERT [dbo].[HMS_LabTestCategory] ([LabTestCategoryId], [LabTestCategoryName], [Description], [CompanyId], [IsActive], [IsDeleted], [CreatedDate], [ModifiedDate], [CreatedBy], [ModifiedBy]) VALUES (5, N'Kidney', NULL, 1, 1, 0, CAST(0x0000A748006CE6BE AS DateTime), NULL, 2, NULL)
INSERT [dbo].[HMS_LabTestCategory] ([LabTestCategoryId], [LabTestCategoryName], [Description], [CompanyId], [IsActive], [IsDeleted], [CreatedDate], [ModifiedDate], [CreatedBy], [ModifiedBy]) VALUES (6, N'Thyroid', NULL, 1, 1, 0, CAST(0x0000A748006CF6FA AS DateTime), NULL, 2, NULL)
SET IDENTITY_INSERT [dbo].[HMS_LabTestCategory] OFF
/****** Object:  Table [dbo].[HMS_LabTest]    Script Date: 04/02/2017 00:22:06 ******/
SET IDENTITY_INSERT [dbo].[HMS_LabTest] ON
INSERT [dbo].[HMS_LabTest] ([LabTestId], [CompanyId], [LabTestName], [LabTestCategoryId], [LabTestPrice], [TestUnit], [ReferenceRange], [IsActive], [IsDeleted], [CreatedDate], [ModifiedDate], [CreatedBy], [ModifiedBy]) VALUES (1, 1, N'Neutrophil Count', 1, NULL, N'Count', N'12-15', 1, 0, CAST(0x0000A74301468B56 AS DateTime), CAST(0x0000A748006D9B50 AS DateTime), 31, 2)
INSERT [dbo].[HMS_LabTest] ([LabTestId], [CompanyId], [LabTestName], [LabTestCategoryId], [LabTestPrice], [TestUnit], [ReferenceRange], [IsActive], [IsDeleted], [CreatedDate], [ModifiedDate], [CreatedBy], [ModifiedBy]) VALUES (2, 1, N'Blood Glucose', 2, NULL, N'mmol', N'120-180', 1, 0, CAST(0x0000A74301470047 AS DateTime), CAST(0x0000A748006E6889 AS DateTime), 31, 2)
INSERT [dbo].[HMS_LabTest] ([LabTestId], [CompanyId], [LabTestName], [LabTestCategoryId], [LabTestPrice], [TestUnit], [ReferenceRange], [IsActive], [IsDeleted], [CreatedDate], [ModifiedDate], [CreatedBy], [ModifiedBy]) VALUES (3, 1, N'Average Glucose ', 2, NULL, N'mmol', N'120-150', 1, 0, CAST(0x0000A7430147202E AS DateTime), CAST(0x0000A748006E86EF AS DateTime), 31, 2)
INSERT [dbo].[HMS_LabTest] ([LabTestId], [CompanyId], [LabTestName], [LabTestCategoryId], [LabTestPrice], [TestUnit], [ReferenceRange], [IsActive], [IsDeleted], [CreatedDate], [ModifiedDate], [CreatedBy], [ModifiedBy]) VALUES (4, 1, N'Total Leucocyte', 1, NULL, N'Count', N'1000-1500', 1, 0, CAST(0x0000A748006D83CB AS DateTime), NULL, 2, NULL)
INSERT [dbo].[HMS_LabTest] ([LabTestId], [CompanyId], [LabTestName], [LabTestCategoryId], [LabTestPrice], [TestUnit], [ReferenceRange], [IsActive], [IsDeleted], [CreatedDate], [ModifiedDate], [CreatedBy], [ModifiedBy]) VALUES (5, 1, N'Lymphocyte Count', 1, NULL, N'Count', N'5200-5500', 1, 0, CAST(0x0000A748006DB339 AS DateTime), NULL, 2, NULL)
INSERT [dbo].[HMS_LabTest] ([LabTestId], [CompanyId], [LabTestName], [LabTestCategoryId], [LabTestPrice], [TestUnit], [ReferenceRange], [IsActive], [IsDeleted], [CreatedDate], [ModifiedDate], [CreatedBy], [ModifiedBy]) VALUES (6, 1, N'Eosinophil Count', 1, NULL, N'Count', N'2500-2700', 1, 0, CAST(0x0000A748006DC8C0 AS DateTime), NULL, 2, NULL)
INSERT [dbo].[HMS_LabTest] ([LabTestId], [CompanyId], [LabTestName], [LabTestCategoryId], [LabTestPrice], [TestUnit], [ReferenceRange], [IsActive], [IsDeleted], [CreatedDate], [ModifiedDate], [CreatedBy], [ModifiedBy]) VALUES (7, 1, N'Total Cholesterol', 3, NULL, N'mmol', N'15-18', 1, 0, CAST(0x0000A748006E1448 AS DateTime), NULL, 2, NULL)
SET IDENTITY_INSERT [dbo].[HMS_LabTest] OFF
/****** Object:  Table [dbo].[HMS_ExpenseCategory]    Script Date: 04/02/2017 00:22:06 ******/
SET IDENTITY_INSERT [dbo].[HMS_ExpenseCategory] ON
INSERT [dbo].[HMS_ExpenseCategory] ([ExpenseCategoryId], [ExpenseCategory], [CompanyId], [Description], [IsActive], [IsDeleted], [CreatedDate], [ModifiedDate], [CreatedBy], [ModifiedBy]) VALUES (1, N'Laundry', 1, N'Laundry Charge', 1, 0, CAST(0x0000A73200D0E88D AS DateTime), NULL, 31, NULL)
INSERT [dbo].[HMS_ExpenseCategory] ([ExpenseCategoryId], [ExpenseCategory], [CompanyId], [Description], [IsActive], [IsDeleted], [CreatedDate], [ModifiedDate], [CreatedBy], [ModifiedBy]) VALUES (2, N'Salary', 1, N'Staff Salary', 1, 0, CAST(0x0000A748004F35A8 AS DateTime), NULL, 2, NULL)
INSERT [dbo].[HMS_ExpenseCategory] ([ExpenseCategoryId], [ExpenseCategory], [CompanyId], [Description], [IsActive], [IsDeleted], [CreatedDate], [ModifiedDate], [CreatedBy], [ModifiedBy]) VALUES (3, N'Medicine Purchase', 1, NULL, 1, 0, CAST(0x0000A748004F44AB AS DateTime), NULL, 2, NULL)
INSERT [dbo].[HMS_ExpenseCategory] ([ExpenseCategoryId], [ExpenseCategory], [CompanyId], [Description], [IsActive], [IsDeleted], [CreatedDate], [ModifiedDate], [CreatedBy], [ModifiedBy]) VALUES (4, N'Equipment Maintainance', 1, NULL, 1, 0, CAST(0x0000A748004F65C6 AS DateTime), NULL, 2, NULL)
INSERT [dbo].[HMS_ExpenseCategory] ([ExpenseCategoryId], [ExpenseCategory], [CompanyId], [Description], [IsActive], [IsDeleted], [CreatedDate], [ModifiedDate], [CreatedBy], [ModifiedBy]) VALUES (5, N'New Equipment', 1, NULL, 1, 0, CAST(0x0000A748004F7373 AS DateTime), NULL, 2, NULL)
INSERT [dbo].[HMS_ExpenseCategory] ([ExpenseCategoryId], [ExpenseCategory], [CompanyId], [Description], [IsActive], [IsDeleted], [CreatedDate], [ModifiedDate], [CreatedBy], [ModifiedBy]) VALUES (6, N'Canteen', 1, NULL, 1, 0, CAST(0x0000A748004FF4C6 AS DateTime), NULL, 2, NULL)
SET IDENTITY_INSERT [dbo].[HMS_ExpenseCategory] OFF
/****** Object:  Table [dbo].[HMS_Expense]    Script Date: 04/02/2017 00:22:06 ******/
SET IDENTITY_INSERT [dbo].[HMS_Expense] ON
INSERT [dbo].[HMS_Expense] ([ExpenseId], [CompanyId], [ExpenseDate], [ExpenseCategoryId], [ExpenseAmount], [IsDeleted], [CreatedDate], [ModifiedDate], [CreatedBy], [ModifiedBy]) VALUES (1, 1, CAST(0x0000A732011251B4 AS DateTime), 1, 50.2000, 0, CAST(0x0000A732011251B4 AS DateTime), CAST(0x0000A73201129709 AS DateTime), 31, 31)
INSERT [dbo].[HMS_Expense] ([ExpenseId], [CompanyId], [ExpenseDate], [ExpenseCategoryId], [ExpenseAmount], [IsDeleted], [CreatedDate], [ModifiedDate], [CreatedBy], [ModifiedBy]) VALUES (2, 1, CAST(0x0000A74800509E47 AS DateTime), 6, 2250.0000, 0, CAST(0x0000A74800509E47 AS DateTime), NULL, 2, NULL)
INSERT [dbo].[HMS_Expense] ([ExpenseId], [CompanyId], [ExpenseDate], [ExpenseCategoryId], [ExpenseAmount], [IsDeleted], [CreatedDate], [ModifiedDate], [CreatedBy], [ModifiedBy]) VALUES (3, 1, CAST(0x0000A7480050B4F5 AS DateTime), 5, 18900.0000, 0, CAST(0x0000A7480050B4F5 AS DateTime), NULL, 2, NULL)
INSERT [dbo].[HMS_Expense] ([ExpenseId], [CompanyId], [ExpenseDate], [ExpenseCategoryId], [ExpenseAmount], [IsDeleted], [CreatedDate], [ModifiedDate], [CreatedBy], [ModifiedBy]) VALUES (4, 1, CAST(0x0000A7480050CBD1 AS DateTime), 2, 50500.0000, 0, CAST(0x0000A7480050CBD1 AS DateTime), NULL, 2, NULL)
INSERT [dbo].[HMS_Expense] ([ExpenseId], [CompanyId], [ExpenseDate], [ExpenseCategoryId], [ExpenseAmount], [IsDeleted], [CreatedDate], [ModifiedDate], [CreatedBy], [ModifiedBy]) VALUES (5, 1, CAST(0x0000A7480050E4DE AS DateTime), 1, 1000.0000, 0, CAST(0x0000A7480050E4DE AS DateTime), NULL, 2, NULL)
SET IDENTITY_INSERT [dbo].[HMS_Expense] OFF
/****** Object:  Table [dbo].[HMS_Company]    Script Date: 04/02/2017 00:22:06 ******/
SET IDENTITY_INSERT [dbo].[HMS_Company] ON
INSERT [dbo].[HMS_Company] ([CompanyId], [CompanyName], [Address1], [Address2], [City], [State], [ZipCode], [Email], [Phone], [Fax], [IsActive], [IsDeleted], [CreatedDate], [ModifiedDate], [CreatedBy]) VALUES (1, N'Demo Hospital', N'Address1', N'Address2', N'City', N'State', N'32024', N'admin@hmspro.com', N'123456789', N'123456789', 1, 0, CAST(0x0000A71400000000 AS DateTime), CAST(0x0000A74600452DB4 AS DateTime), 1)
INSERT [dbo].[HMS_Company] ([CompanyId], [CompanyName], [Address1], [Address2], [City], [State], [ZipCode], [Email], [Phone], [Fax], [IsActive], [IsDeleted], [CreatedDate], [ModifiedDate], [CreatedBy]) VALUES (2, N'Providence Hospital', N'Address1', N'Address2', N'City', N'State', N'32025', N'admin@providence.com', N'125252525', N'125252525', 1, 0, CAST(0x0000A71400000000 AS DateTime), CAST(0x0000A74600436077 AS DateTime), 1)
INSERT [dbo].[HMS_Company] ([CompanyId], [CompanyName], [Address1], [Address2], [City], [State], [ZipCode], [Email], [Phone], [Fax], [IsActive], [IsDeleted], [CreatedDate], [ModifiedDate], [CreatedBy]) VALUES (4, N'INCA Hospital', N'Address1', N'Address2', N'City', N'State', N'32025', N'admin@inca.com', N'323244534', N'1123332234', 1, 0, CAST(0x0000A7160121A9CD AS DateTime), CAST(0x0000A7460043A2A6 AS DateTime), 0)
INSERT [dbo].[HMS_Company] ([CompanyId], [CompanyName], [Address1], [Address2], [City], [State], [ZipCode], [Email], [Phone], [Fax], [IsActive], [IsDeleted], [CreatedDate], [ModifiedDate], [CreatedBy]) VALUES (5, N'Farber Dan Hospital', N'Address1', N'Address2', N'City', N'State', N'32025', N'admin@farberdan.com', N'261123345', N'712239974', 1, 0, CAST(0x0000A7160121C649 AS DateTime), CAST(0x0000A7460044EA41 AS DateTime), 0)
INSERT [dbo].[HMS_Company] ([CompanyId], [CompanyName], [Address1], [Address2], [City], [State], [ZipCode], [Email], [Phone], [Fax], [IsActive], [IsDeleted], [CreatedDate], [ModifiedDate], [CreatedBy]) VALUES (6, N'Sanford Hospital', N'Address1', N'Address2', N'City', N'State', N'32025', N'admin@sanford.com', N'322222211', N'855441244', 1, 0, CAST(0x0000A7160122F8E2 AS DateTime), CAST(0x0000A7460044AB52 AS DateTime), 0)
INSERT [dbo].[HMS_Company] ([CompanyId], [CompanyName], [Address1], [Address2], [City], [State], [ZipCode], [Email], [Phone], [Fax], [IsActive], [IsDeleted], [CreatedDate], [ModifiedDate], [CreatedBy]) VALUES (7, N'Mount Sinai Hospital', N'Address1', N'Address2', N'City', N'State', N'32025', N'admin@mountsinai.com', N'2552844528', N'1669554852', 1, 0, CAST(0x0000A716012303E0 AS DateTime), CAST(0x0000A746004473FC AS DateTime), 0)
INSERT [dbo].[HMS_Company] ([CompanyId], [CompanyName], [Address1], [Address2], [City], [State], [ZipCode], [Email], [Phone], [Fax], [IsActive], [IsDeleted], [CreatedDate], [ModifiedDate], [CreatedBy]) VALUES (8, N'Royal Hospital', N'Address1', N'Address2', N'City', N'State', N'32025', N'admin@royal.com', N'8544525521', N'8455566858', 1, 0, CAST(0x0000A7160123B508 AS DateTime), CAST(0x0000A74600443512 AS DateTime), 0)
INSERT [dbo].[HMS_Company] ([CompanyId], [CompanyName], [Address1], [Address2], [City], [State], [ZipCode], [Email], [Phone], [Fax], [IsActive], [IsDeleted], [CreatedDate], [ModifiedDate], [CreatedBy]) VALUES (9, N'National Hospital', N'Address1', N'Address2', N'City', N'State', N'32025', N'admin@national.com', N'231888644', N'565711821', 1, 0, CAST(0x0000A71601255DBF AS DateTime), CAST(0x0000A7460043E405 AS DateTime), 0)
INSERT [dbo].[HMS_Company] ([CompanyId], [CompanyName], [Address1], [Address2], [City], [State], [ZipCode], [Email], [Phone], [Fax], [IsActive], [IsDeleted], [CreatedDate], [ModifiedDate], [CreatedBy]) VALUES (10, N'J.M. Anderson Hospital', N'Address1', N'Address 2', N'City', N'State', N'32052', N'admin@jmanderson.com', N'123445554', N'123232323', 1, 0, CAST(0x0000A71601274E74 AS DateTime), CAST(0x0000A7460042F7FE AS DateTime), 0)
INSERT [dbo].[HMS_Company] ([CompanyId], [CompanyName], [Address1], [Address2], [City], [State], [ZipCode], [Email], [Phone], [Fax], [IsActive], [IsDeleted], [CreatedDate], [ModifiedDate], [CreatedBy]) VALUES (11, N'Intermountain Hospital', N'12, New Street', N'Nr. Tween Tower', N'New York', N'NY', N'382558', N'admin@intermountain.com', N'123456789', N'123456789', 1, 0, CAST(0x0000A71601394975 AS DateTime), CAST(0x0000A74600451E8E AS DateTime), 0)
SET IDENTITY_INSERT [dbo].[HMS_Company] OFF
/****** Object:  Table [dbo].[HMS_BedCategory]    Script Date: 04/02/2017 00:22:06 ******/
SET IDENTITY_INSERT [dbo].[HMS_BedCategory] ON
INSERT [dbo].[HMS_BedCategory] ([BedCategoryId], [BedCategory], [Description], [CompanyId], [IsActive], [IsDeleted], [CreatedDate], [ModifiedDate], [CreatedBy], [ModifiedBy]) VALUES (1, N'General', N'General Room Bed', 1, 1, 0, CAST(0x0000A73400EDFDD8 AS DateTime), CAST(0x0000A73400EE548B AS DateTime), 31, 31)
INSERT [dbo].[HMS_BedCategory] ([BedCategoryId], [BedCategory], [Description], [CompanyId], [IsActive], [IsDeleted], [CreatedDate], [ModifiedDate], [CreatedBy], [ModifiedBy]) VALUES (2, N'Semi Special Beds', N'Semi Special Beds', 1, 1, 0, CAST(0x0000A73400EE1613 AS DateTime), NULL, 31, NULL)
INSERT [dbo].[HMS_BedCategory] ([BedCategoryId], [BedCategory], [Description], [CompanyId], [IsActive], [IsDeleted], [CreatedDate], [ModifiedDate], [CreatedBy], [ModifiedBy]) VALUES (3, N'Special Rooms', N'Special Rooms', 1, 1, 0, CAST(0x0000A73400EE2969 AS DateTime), NULL, 31, NULL)
INSERT [dbo].[HMS_BedCategory] ([BedCategoryId], [BedCategory], [Description], [CompanyId], [IsActive], [IsDeleted], [CreatedDate], [ModifiedDate], [CreatedBy], [ModifiedBy]) VALUES (4, N'ICU Beds', N'ICU Beds', 1, 1, 0, CAST(0x0000A73400EE36D7 AS DateTime), NULL, 31, NULL)
INSERT [dbo].[HMS_BedCategory] ([BedCategoryId], [BedCategory], [Description], [CompanyId], [IsActive], [IsDeleted], [CreatedDate], [ModifiedDate], [CreatedBy], [ModifiedBy]) VALUES (5, N'VIP', N'VIP Beds', 1, 1, 0, CAST(0x0000A73400EE47F0 AS DateTime), NULL, 31, NULL)
SET IDENTITY_INSERT [dbo].[HMS_BedCategory] OFF
/****** Object:  Table [dbo].[HMS_BedAllotment]    Script Date: 04/02/2017 00:22:06 ******/
SET IDENTITY_INSERT [dbo].[HMS_BedAllotment] ON
INSERT [dbo].[HMS_BedAllotment] ([BedAllotmentId], [PatientId], [CompanyId], [BedCategoryId], [BedId], [AllotmentDate], [DischargeDate], [Notes], [CreatedDate], [ModifiedDate], [CreatedBy], [ModifiedBy]) VALUES (1, 37, 1, 1, 1, CAST(0x0000A73400EEF3E0 AS DateTime), CAST(0x0000A73700EEF3E0 AS DateTime), NULL, CAST(0x0000A73600F01BD4 AS DateTime), NULL, 31, NULL)
INSERT [dbo].[HMS_BedAllotment] ([BedAllotmentId], [PatientId], [CompanyId], [BedCategoryId], [BedId], [AllotmentDate], [DischargeDate], [Notes], [CreatedDate], [ModifiedDate], [CreatedBy], [ModifiedBy]) VALUES (2, 41, 1, 1, 3, CAST(0x0000A73600C5C100 AS DateTime), NULL, NULL, CAST(0x0000A73600F04D6A AS DateTime), NULL, 31, NULL)
INSERT [dbo].[HMS_BedAllotment] ([BedAllotmentId], [PatientId], [CompanyId], [BedCategoryId], [BedId], [AllotmentDate], [DischargeDate], [Notes], [CreatedDate], [ModifiedDate], [CreatedBy], [ModifiedBy]) VALUES (3, 42, 1, 1, 5, CAST(0x0000A73600C5C100 AS DateTime), CAST(0x0000A73A00CF5DF0 AS DateTime), NULL, CAST(0x0000A73600F0E286 AS DateTime), NULL, 31, NULL)
INSERT [dbo].[HMS_BedAllotment] ([BedAllotmentId], [PatientId], [CompanyId], [BedCategoryId], [BedId], [AllotmentDate], [DischargeDate], [Notes], [CreatedDate], [ModifiedDate], [CreatedBy], [ModifiedBy]) VALUES (4, 43, 1, 4, 2, CAST(0x0000A70D00C5C100 AS DateTime), CAST(0x0000A71000C5C100 AS DateTime), NULL, CAST(0x0000A73600F28917 AS DateTime), NULL, 31, NULL)
SET IDENTITY_INSERT [dbo].[HMS_BedAllotment] OFF
/****** Object:  Table [dbo].[HMS_Bed]    Script Date: 04/02/2017 00:22:06 ******/
SET IDENTITY_INSERT [dbo].[HMS_Bed] ON
INSERT [dbo].[HMS_Bed] ([BedId], [CompanyId], [BedName], [Description], [BedCategoryId], [IsAvailable], [IsActive], [IsDeleted], [CreatedDate], [ModifiedDate], [CreatedBy], [ModifiedBy]) VALUES (1, 1, N'G-001', N'G1', 1, 0, 1, 0, CAST(0x0000A7340102E2B6 AS DateTime), CAST(0x0000A7340114DBB1 AS DateTime), 31, 31)
INSERT [dbo].[HMS_Bed] ([BedId], [CompanyId], [BedName], [Description], [BedCategoryId], [IsAvailable], [IsActive], [IsDeleted], [CreatedDate], [ModifiedDate], [CreatedBy], [ModifiedBy]) VALUES (2, 1, N'ICU-1', N'ICU1', 4, 0, 1, 0, CAST(0x0000A73401033B15 AS DateTime), NULL, 31, NULL)
INSERT [dbo].[HMS_Bed] ([BedId], [CompanyId], [BedName], [Description], [BedCategoryId], [IsAvailable], [IsActive], [IsDeleted], [CreatedDate], [ModifiedDate], [CreatedBy], [ModifiedBy]) VALUES (3, 1, N'G-002', N'G2', 1, 0, 1, 0, CAST(0x0000A734010348C1 AS DateTime), NULL, 31, NULL)
INSERT [dbo].[HMS_Bed] ([BedId], [CompanyId], [BedName], [Description], [BedCategoryId], [IsAvailable], [IsActive], [IsDeleted], [CreatedDate], [ModifiedDate], [CreatedBy], [ModifiedBy]) VALUES (4, 1, N'SS-001', N'Semi special 1', 2, 1, 1, 0, CAST(0x0000A73401150975 AS DateTime), NULL, 31, NULL)
INSERT [dbo].[HMS_Bed] ([BedId], [CompanyId], [BedName], [Description], [BedCategoryId], [IsAvailable], [IsActive], [IsDeleted], [CreatedDate], [ModifiedDate], [CreatedBy], [ModifiedBy]) VALUES (5, 1, N'G-003', N'b3', 1, 1, 1, 0, CAST(0x0000A73600EDA3A8 AS DateTime), CAST(0x0000A73600EDB076 AS DateTime), 31, 31)
INSERT [dbo].[HMS_Bed] ([BedId], [CompanyId], [BedName], [Description], [BedCategoryId], [IsAvailable], [IsActive], [IsDeleted], [CreatedDate], [ModifiedDate], [CreatedBy], [ModifiedBy]) VALUES (6, 1, N'G-4', NULL, 1, 1, 1, 0, CAST(0x0000A73600EDB920 AS DateTime), NULL, 31, NULL)
INSERT [dbo].[HMS_Bed] ([BedId], [CompanyId], [BedName], [Description], [BedCategoryId], [IsAvailable], [IsActive], [IsDeleted], [CreatedDate], [ModifiedDate], [CreatedBy], [ModifiedBy]) VALUES (7, 1, N'G-5', NULL, 1, 1, 1, 0, CAST(0x0000A73600EDC30F AS DateTime), NULL, 31, NULL)
SET IDENTITY_INSERT [dbo].[HMS_Bed] OFF
