ALTER TABLE Employee_HealthData_Intermediate
ADD AbsoluteBasophilis NVARCHAR(100) NULL


ALTER TABLE Employee_HealthData
ALTER COLUMN QualifyingEventID BIGINT NULL

ALTER TABLE Employee_HealthData_History
ALTER COLUMN QualifyingEventID BIGINT NULL

ALTER TABLE Employee_HealthData_Intermediate
ALTER COLUMN QualifyingEventID BIGINT NULL

ALTER TABLE Employee_Healthdata_Intermediate
ADD	[Sodium] [nvarchar](100) NULL,
	[BloodGroup] [nvarchar](100) NULL,
	[BMI] [nvarchar](100) NULL,
	[WHR] [nvarchar](100) NULL,
	[WaistSize] [nvarchar](100) NULL,
	[HipSize] [nvarchar](100) NULL,
	[LDLHDLRatio] [nvarchar](100) NULL,
	[TotalHDLRatio] [nvarchar](100) NULL,
	[GlucoseFasting] [nvarchar](100) NULL,
	[PulseRateResting] [nvarchar](100) NULL,
	[ECHO] [nvarchar](100) NULL,
	[TMT] [nvarchar](100) NULL,
	[BilirubinConjugated] [nvarchar](100) NULL,
	[BilirubinTotal] [nvarchar](100) NULL,
	[BilirubinUnconjugated] [nvarchar](100) NULL,
	[SGPT] [nvarchar](100) NULL,
	[BloodUreaNitrogen] [nvarchar](100) NULL,
	[Creatinine] [nvarchar](100) NULL,
	[TSH] [nvarchar](100) NULL,
	[MCH] [nvarchar](100) NULL,
	[MCHC] [nvarchar](100) NULL,
	[MCV] [nvarchar](100) NULL,
	[PCV] [nvarchar](100) NULL,
	[PlateletCount] [nvarchar](100) NULL,
	[RBCCount] [nvarchar](100) NULL,
	[WBCCount] [nvarchar](100) NULL,
	[Hemoglobin] [nvarchar](100) NULL,
	[AbsoluteEosinophils] [nvarchar](100) NULL,
	[AbsoluteLymphocytes] [nvarchar](100) NULL,
	[AbsoluteMonocytes] [nvarchar](100) NULL,
	[AbsoluteNeutrophils] [nvarchar](100) NULL,
	[Basophilis] [nvarchar](100) NULL,
	[Eosinophils] [nvarchar](100) NULL,
	[Lymphocytes] [nvarchar](100) NULL,
	[Monocytes] [nvarchar](100) NULL,
	[Neutrophils] [nvarchar](100) NULL,
	[Parasites] [nvarchar](100) NULL,
	[Platelets] [nvarchar](100) NULL,
	[RBCMorphology] [nvarchar](100) NULL,
	[WBCAbnormilities] [nvarchar](100) NULL,
	[UrineAcetone] [nvarchar](100) NULL,
	[UrineAlbumin] [nvarchar](100) NULL,
	[UrineAppearance] [nvarchar](100) NULL,
	[UrineBilePigments] [nvarchar](100) NULL,
	[UrineBileSalts] [nvarchar](100) NULL,
	[UrineCasts] [nvarchar](100) NULL,
	[UrineColor] [nvarchar](100) NULL,
	[UrineCrystals] [nvarchar](100) NULL,
	[UrineEpethelialCells] [nvarchar](100) NULL,
	[UrineGlucose] [nvarchar](100) NULL,
	[UrinepH] [nvarchar](100) NULL,
	[UrinePusCells] [nvarchar](100) NULL,
	[UrineRBC] [nvarchar](100) NULL,
	[Urobillinogen] [nvarchar](100) NULL,
	[StoolCulture] [nvarchar](100) NULL,
	[ChestXray] [nvarchar](100) NULL,
	[BloodRhTyping] [nvarchar](100) NULL,
	[TotalAlbumin] [nvarchar](100) NULL,
	[TotalProtein] [nvarchar](100) NULL,
	[UricAcid] [nvarchar](100) NULL,
	[Calcium] [nvarchar](100) NULL,
	[Potassium] [nvarchar](100) NULL