USE [Hemodialysis]
GO

/****** Object:  Table [dbo].[tbHemodialysisResultEntry]    Script Date: 7/22/2025 3:23:50 PM ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[tbHemodialysisResultEntry](
	[HospNum] [varchar](15) NULL,
	[Idnum] [varchar](15) NULL,
	[RequestNum] [varchar](15) NULL,
	[DialysisNumber] [varchar](15) NULL,
	[MachineNumber] [varchar](15) NULL,
	[Patienttype] [varchar](1) NULL,
	[ResultDate] [datetime] NULL,
	[UserId] [varchar](10) NULL,
	[HdStartTime] [varchar](15) NULL,
	[HdEndTime] [varchar](15) NULL,
	[DryWeight] [varchar](15) NULL,
	[WtPreHD] [varchar](15) NULL,
	[WtPostHD] [varchar](15) NULL,
	[PostHDRemarks] [varchar](30) NULL,
	[HdNursePatient1] [varchar](30) NULL,
	[HdNursePatient2] [varchar](30) NULL,
	[HdNurseMachine1] [varchar](30) NULL,
	[HdNurseMachine2] [varchar](30) NULL,
	[UFV] [varchar](30) NULL,
	[BFR] [varchar](30) NULL,
	[DFR] [varchar](30) NULL,
	[Duration] [varchar](30) NULL,
	[Bath] [varchar](30) NULL,
	[Heparin] [varchar](30) NULL,
	[TxParameters] [varchar](50) NULL,
	[DialyzerType] [varchar](15) NULL,
	[DialyzerUse] [varchar](15) NULL,
	[BloodLineUse] [varchar](15) NULL,
	[PhysiciansOrders] [varchar](150) NULL,
	[SignificantData] [varchar](150) NULL,
	[Time1] [varchar](20) NULL,
	[Time2] [varchar](20) NULL,
	[Time3] [varchar](20) NULL,
	[Time4] [varchar](20) NULL,
	[Bfr1] [varchar](20) NULL,
	[Bfr2] [varchar](20) NULL,
	[Bfr3] [varchar](20) NULL,
	[Bfr4] [varchar](20) NULL,
	[AP1] [varchar](20) NULL,
	[AP2] [varchar](20) NULL,
	[AP3] [varchar](20) NULL,
	[AP4] [varchar](20) NULL,
	[VP1] [varchar](20) NULL,
	[VP2] [varchar](20) NULL,
	[VP3] [varchar](20) NULL,
	[VP4] [varchar](20) NULL,
	[TMP1] [varchar](20) NULL,
	[TMP2] [varchar](20) NULL,
	[TMP3] [varchar](20) NULL,
	[TMP4] [varchar](20) NULL,
	[TIMETIME1] [varchar](20) NULL,
	[TIMETIME2] [varchar](20) NULL,
	[TIMETIME3] [varchar](20) NULL,
	[TIMETIME4] [varchar](20) NULL,
	[TIMETIME5] [varchar](20) NULL,
	[TIMETIME6] [varchar](20) NULL,
	[TIMETIME7] [varchar](20) NULL,
	[TIMETIME8] [varchar](20) NULL,
	[TIMETIME9] [varchar](20) NULL,
	[TIMETIME10] [varchar](20) NULL,
	[BP1] [varchar](20) NULL,
	[BP2] [varchar](20) NULL,
	[BP3] [varchar](20) NULL,
	[BP4] [varchar](20) NULL,
	[BP5] [varchar](20) NULL,
	[BP6] [varchar](20) NULL,
	[BP7] [varchar](20) NULL,
	[BP8] [varchar](20) NULL,
	[BP9] [varchar](20) NULL,
	[BP10] [varchar](20) NULL,
	[CR1] [varchar](20) NULL,
	[CR2] [varchar](20) NULL,
	[CR3] [varchar](20) NULL,
	[CR4] [varchar](20) NULL,
	[CR5] [varchar](20) NULL,
	[CR6] [varchar](20) NULL,
	[CR7] [varchar](20) NULL,
	[CR8] [varchar](20) NULL,
	[CR9] [varchar](20) NULL,
	[CR10] [varchar](20) NULL,
	[RR1] [varchar](20) NULL,
	[RR2] [varchar](20) NULL,
	[RR3] [varchar](20) NULL,
	[RR4] [varchar](20) NULL,
	[RR5] [varchar](20) NULL,
	[RR6] [varchar](20) NULL,
	[RR7] [varchar](20) NULL,
	[RR8] [varchar](20) NULL,
	[RR9] [varchar](20) NULL,
	[RR10] [varchar](20) NULL,
	[TEMP1] [varchar](20) NULL,
	[TEMP2] [varchar](20) NULL,
	[TEMP3] [varchar](20) NULL,
	[TEMP4] [varchar](20) NULL,
	[TEMP5] [varchar](20) NULL,
	[TEMP6] [varchar](20) NULL,
	[TEMP7] [varchar](20) NULL,
	[TEMP8] [varchar](20) NULL,
	[TEMP9] [varchar](20) NULL,
	[TEMP10] [varchar](20) NULL,
	[Arrived] [varchar](20) NULL,
	[ArrAmbulatory] [varchar](1) NULL,
	[ArrWheelChair] [varchar](1) NULL,
	[ArrOther] [varchar](1) NULL,
	[ArrText] [varchar](30) NULL,
	[GaitSteady] [varchar](1) NULL,
	[GaitAssisted] [varchar](1) NULL,
	[GaitOther] [varchar](1) NULL,
	[GaitText] [varchar](30) NULL,
	[LOCAlert] [varchar](1) NULL,
	[LOCConfused] [varchar](1) NULL,
	[LOCDrowsy] [varchar](1) NULL,
	[LOCStupor] [varchar](1) NULL,
	[LOCOthers] [varchar](1) NULL,
	[LOCText] [varchar](30) NULL,
	[NVENone] [varchar](1) NULL,
	[NVEProminent] [varchar](1) NULL,
	[NVEOthers] [varchar](1) NULL,
	[NVEText] [varchar](30) NULL,
	[BreathingNormal] [varchar](1) NULL,
	[BreathingDyspneic] [varchar](1) NULL,
	[BreathingOthers] [varchar](1) NULL,
	[BreathingText] [varchar](30) NULL,
	[LungsClear] [varchar](1) NULL,
	[LungsRales] [varchar](1) NULL,
	[LungsRalesText] [varchar](30) NULL,
	[LungsOthers] [varchar](1) NULL,
	[LungsText] [varchar](30) NULL,
	[HeartRhythRegular] [varchar](1) NULL,
	[HeartRhythIrregular] [varchar](1) NULL,
	[HeartRhythOthers] [varchar](1) NULL,
	[HeartRhythText] [varchar](30) NULL,
	[EdemaNone] [varchar](1) NULL,
	[EdemaFace] [varchar](1) NULL,
	[EdemaAscites] [varchar](1) NULL,
	[EdemaUpperExt] [varchar](1) NULL,
	[EdemaLowerExt] [varchar](1) NULL,
	[EdemaText] [varchar](30) NULL,
	[EmotionalAppropriate] [varchar](1) NULL,
	[EmotionalIndifferent] [varchar](1) NULL,
	[EmotionalOthers] [varchar](1) NULL,
	[EmotionalText] [varchar](30) NULL,
	[SleepGood] [varchar](1) NULL,
	[SleepFair] [varchar](1) NULL,
	[SleepPoor] [varchar](1) NULL,
	[AppetiteGood] [varchar](1) NULL,
	[AppetiteFair] [varchar](1) NULL,
	[AppetitePoor] [varchar](1) NULL,
	[AccessCondGood] [varchar](1) NULL,
	[AccessCondOthers] [varchar](1) NULL,
	[AccessCondText] [varchar](30) NULL,
	[ComplaintsNone] [varchar](1) NULL,
	[ComplaintsOthers] [varchar](1) NULL,
	[ComplaintsText] [varchar](30) NULL,
	[PreDialysisNurse] [varchar](30) NULL,
	[SCCond] [varchar](30) NULL,
	[SCTemp] [varchar](30) NULL,
	[SCIntrlk] [varchar](30) NULL,
	[SCByPass] [varchar](30) NULL,
	[SCBleak] [varchar](30) NULL,
	[SCAirDTK] [varchar](30) NULL,
	[DialysateNa] [varchar](30) NULL,
	[DialysateBIC] [varchar](30) NULL,
	[DialysateK] [varchar](30) NULL,
	[DialysateCa] [varchar](30) NULL,
	[DialysateDex] [varchar](30) NULL,
	[DialysateT] [varchar](30) NULL,
	[DialysateCond] [varchar](30) NULL,
	[Prime] [varchar](30) NULL,
	[Resid] [varchar](30) NULL,
	[ID1] [varchar](30) NULL,
	[ID2] [varchar](30) NULL,
	[TreatmentUneventful] [varchar](1) NULL,
	[TreatmentEventful] [varchar](1) NULL,
	[IntraDialyticTime1] [varchar](20) NULL,
	[IntraDialyticTime2] [varchar](20) NULL,
	[IntraDialyticTime3] [varchar](20) NULL,
	[IntraDialyticTime4] [varchar](20) NULL,
	[IntraDialyticTime5] [varchar](20) NULL,
	[IntraDialyticTime6] [varchar](20) NULL,
	[IntraDialyticEvent1] [varchar](100) NULL,
	[IntraDialyticEvent2] [varchar](100) NULL,
	[IntraDialyticEvent3] [varchar](100) NULL,
	[IntraDialyticEvent4] [varchar](100) NULL,
	[IntraDialyticEvent5] [varchar](100) NULL,
	[IntraDialyticEvent6] [varchar](100) NULL,
	[PDEvalAccessCare] [varchar](1) NULL,
	[PDEvalAccessText] [varchar](50) NULL,
	[PDEvalEPO] [varchar](1) NULL,
	[PDEvalEPOText] [varchar](50) NULL,
	[PDEvalPxCondFair] [varchar](1) NULL,
	[PDEvalPxCondOthers] [varchar](1) NULL,
	[PDEvalPxCondText] [varchar](50) NULL,
	[PDEvalBreathNormal] [varchar](1) NULL,
	[PDEvalBreathDysp] [varchar](1) NULL,
	[PDEvalBreathOthers] [varchar](1) NULL,
	[PDEvalBreathText] [varchar](50) NULL,
	[PDEvalDischarge] [varchar](50) NULL,
	[PDEvalDcrAmbulatory] [varchar](1) NULL,
	[PDEvalDcrWheel] [varchar](1) NULL,
	[PDEvalDcrOThers] [varchar](1) NULL,
	[PDEvalDcrText] [varchar](50) NULL,
	[PDEvalNurse] [varchar](30) NULL,
	[OLD_HOSPNUM] [varchar](10) NULL,
	[DialyzerModel] [varchar](10) NULL,
	[ReUseNumber] [varchar](10) NULL,
	[CheckedBy] [varchar](250) NULL,
	[ResidualTest] [varchar](10) NULL,
	[Conductivity] [varchar](10) NULL,
	[Temperature] [varchar](10) NULL,
	[OCM] [varchar](10) NULL,
	[KTV] [varchar](10) NULL,
	[HCT] [varchar](10) NULL,
	[OtherObservations] [varchar](250) NULL,
	[UFGoal] [varchar](20) NULL,
	[DurationOrdered] [varchar](20) NULL,
	[DurationAchieved] [varchar](20) NULL,
	[AVFistula] [bit] NULL,
	[AVGraft] [bit] NULL,
	[PermaCath] [bit] NULL,
	[Temporary] [bit] NULL,
	[IntJugular] [bit] NULL,
	[Subclavian] [bit] NULL,
	[Fermoral] [bit] NULL,
	[StrongThrill] [bit] NULL,
	[WeakThrill] [bit] NULL,
	[ATWithBruit] [bit] NULL,
	[ATNoBruit] [bit] NULL,
	[LowMolecular] [bit] NULL,
	[LowDoseHeparin] [bit] NULL,
	[RegularHeparin] [bit] NULL,
	[Flushing] [bit] NULL,
	[Left] [bit] NULL,
	[Right] [bit] NULL,
	[TOALeft] [bit] NULL,
	[TOARight] [bit] NULL,
	[PrimedBy] [varchar](8) NULL,
	[InitiatedBy] [varchar](8) NULL,
	[TerminatedBy] [varchar](8) NULL,
	[ReprocessedBy] [varchar](8) NULL,
	[WtGain] [varchar](15) NULL,
	[UFVDW] [varchar](15) NULL,
	[UFVDesired] [varchar](15) NULL,
	[Good_Post] [varchar](1) NULL,
	[Fair_Post] [varchar](1) NULL,
	[Poor_Post] [varchar](1) NULL,
	[LOCAlert_Post] [varchar](1) NULL,
	[LOCConfused_Post] [varchar](1) NULL,
	[LOCStupor_Post] [varchar](1) NULL,
	[LOCOthers_Post] [varchar](1) NULL,
	[LOCText_Post] [varchar](30) NULL,
	[NVENone_Post] [varchar](1) NULL,
	[NVEProminent_Post] [varchar](1) NULL,
	[NVEOthers_Post] [varchar](1) NULL,
	[NVEText_Post] [varchar](30) NULL,
	[BreathingNormal_Post] [varchar](1) NULL,
	[BreathingDyspneic_Post] [varchar](1) NULL,
	[BreathingOthers_Post] [varchar](1) NULL,
	[BreathingText_Post] [varchar](30) NULL,
	[LungsClear_Post] [varchar](1) NULL,
	[LungsRales_Post] [varchar](1) NULL,
	[LungsRalesText_Post] [varchar](30) NULL,
	[LungsOthers_Post] [varchar](1) NULL,
	[LungsText_Post] [varchar](30) NULL,
	[HeartRhythRegular_Post] [varchar](1) NULL,
	[HeartRhythIrregular_Post] [varchar](1) NULL,
	[HeartRhythOthers_Post] [varchar](1) NULL,
	[HeartRhythText_Post] [varchar](30) NULL,
	[EdemaNone_Post] [varchar](1) NULL,
	[EdemaEyes_Post] [varchar](5) NULL,
	[EdemaAscites_Post] [varchar](1) NULL,
	[EdemaUpperExt_Post] [varchar](1) NULL,
	[EdemaLowerExt_Post] [varchar](1) NULL,
	[EdemaText_Post] [varchar](30) NULL,
	[Home_Post] [varchar](1) NULL,
	[Facility_Post] [varchar](1) NULL,
	[FacilityText_Post] [varchar](30) NULL,
	[PostHDWt1] [varchar](15) NULL,
	[PostHDWt2] [varchar](15) NULL,
	[PostHDWt3] [varchar](15) NULL,
	[PostHDWt4] [varchar](15) NULL,
	[ArrStretcherBedRidden] [varchar](1) NULL,
	[EdemaEyes] [varchar](1) NULL,
	[EdemaFace_Post] [varchar](1) NULL,
	[AssessedBy] [varchar](100) NULL,
	[InterDialyticWtGain] [varchar](15) NULL,
	[LOCDrowsy_Post] [varchar](1) NULL,
	[HDStarted] [varchar](15) NULL,
	[HDEnded] [varchar](15) NULL,
	[PreHD] [varchar](50) NULL,
	[PostHD] [varchar](50) NULL,
	[NewDialyzer] [varchar](15) NULL,
	[DSYes] [varchar](1) NULL,
	[DSNo] [varchar](1) NULL,
	[WitnessedBy] [varchar](20) NULL,
	[TCV] [varchar](15) NULL,
	[Tunnelled] [bit] NULL,
	[ACGoodBruit] [varchar](50) NULL,
	[ACOthers] [bit] NULL,
	[ACOthersText] [varchar](15) NULL,
	[Permanent] [bit] NULL,
	[PODialyzer] [varchar](30) NULL,
	[RBGMTime] [datetime] NULL,
	[RBGMResult] [varchar](100) NULL,
	[RBGMRemarks] [text] NULL,
	[Others_Post] [varchar](1) NULL,
	[TextOthers_Post] [varchar](100) NULL,
	[LabTests] [nvarchar](255) NULL,
	[PRNOthers] [nvarchar](255) NULL,
	[LMWHDose] [varchar](10) NULL,
	[LMWHDoseValue] [nvarchar](50) NULL,
	[UnfractionatedHeparin] [varchar](10) NULL,
	[RegularBolusValue] [nvarchar](50) NULL,
	[RegularMaintenanceValue] [nvarchar](50) NULL,
	[LowDoseBolusValue] [nvarchar](50) NULL,
	[LowDoseMaintenanceValue] [nvarchar](50) NULL,
	[NSSFlushing] [bit] NULL,
	[NSSAmount] [nvarchar](50) NULL,
	[NSSFrequency] [nvarchar](50) NULL,
	[TypeHemo] [bit] NULL,
	[EPOType] [nvarchar](50) NULL,
	[EPODose] [nvarchar](200) NULL,
	[EPORoute] [nvarchar](200) NULL,
	[IronSucroseDetails] [text] NULL,
	[IronSucroseRoute] [nvarchar](100) NULL,
	[OtherMedicineName] [text] NULL,
	[OtherMedicineDose] [text] NULL,
	[OtherMedicineRoute] [nvarchar](200) NULL,
	[Learner] [varchar](50) NULL,
	[Barrier] [varchar](100) NULL,
	[EducationNeeds] [varchar](50) NULL,
	[Diet] [varchar](50) NULL,
	[LearnersResponse] [varchar](100) NULL,
	[TeachingAid] [varchar](50) NULL,
	[DateTime] [datetime] NULL,
	[LearnerNameSignature] [varchar](100) NULL,
	[SpecificInfo] [text] NULL,
	[HealthcareProvider] [varchar](100) NULL,
	[LearnerOthers] [varchar](100) NULL,
	[BarrierOthers] [varchar](100) NULL,
	[NeedsOthers] [varchar](100) NULL,
	[AidOthers] [varchar](100) NULL,
	[BP_Pre] [varchar](100) NULL,
	[Temperature_Pre] [varchar](100) NULL,
	[PulseRate_Pre] [varchar](100) NULL,
	[RespRate_Pre] [varchar](100) NULL,
	[O2Sat_Pre] [varchar](100) NULL,
	[BP_Post] [varchar](100) NULL,
	[Temperature_Post] [varchar](100) NULL,
	[PulseRate_Post] [varchar](100) NULL,
	[RespRate_Post] [varchar](100) NULL,
	[O2Sat_Post] [varchar](100) NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

ALTER TABLE [dbo].[tbHemodialysisResultEntry] ADD  DEFAULT ((0)) FOR [AVFistula]
GO

ALTER TABLE [dbo].[tbHemodialysisResultEntry] ADD  DEFAULT ((0)) FOR [AVGraft]
GO

ALTER TABLE [dbo].[tbHemodialysisResultEntry] ADD  DEFAULT ((0)) FOR [PermaCath]
GO

ALTER TABLE [dbo].[tbHemodialysisResultEntry] ADD  DEFAULT ((0)) FOR [Temporary]
GO

ALTER TABLE [dbo].[tbHemodialysisResultEntry] ADD  DEFAULT ((0)) FOR [IntJugular]
GO

ALTER TABLE [dbo].[tbHemodialysisResultEntry] ADD  DEFAULT ((0)) FOR [Subclavian]
GO

ALTER TABLE [dbo].[tbHemodialysisResultEntry] ADD  DEFAULT ((0)) FOR [Fermoral]
GO

ALTER TABLE [dbo].[tbHemodialysisResultEntry] ADD  DEFAULT ((0)) FOR [StrongThrill]
GO

ALTER TABLE [dbo].[tbHemodialysisResultEntry] ADD  DEFAULT ((0)) FOR [WeakThrill]
GO

ALTER TABLE [dbo].[tbHemodialysisResultEntry] ADD  DEFAULT ((0)) FOR [ATWithBruit]
GO

ALTER TABLE [dbo].[tbHemodialysisResultEntry] ADD  DEFAULT ((0)) FOR [ATNoBruit]
GO

ALTER TABLE [dbo].[tbHemodialysisResultEntry] ADD  DEFAULT ((0)) FOR [LowMolecular]
GO

ALTER TABLE [dbo].[tbHemodialysisResultEntry] ADD  DEFAULT ((0)) FOR [LowDoseHeparin]
GO

ALTER TABLE [dbo].[tbHemodialysisResultEntry] ADD  DEFAULT ((0)) FOR [RegularHeparin]
GO

ALTER TABLE [dbo].[tbHemodialysisResultEntry] ADD  DEFAULT ((0)) FOR [Flushing]
GO

ALTER TABLE [dbo].[tbHemodialysisResultEntry] ADD  DEFAULT ((0)) FOR [Left]
GO

ALTER TABLE [dbo].[tbHemodialysisResultEntry] ADD  DEFAULT ((0)) FOR [Right]
GO

ALTER TABLE [dbo].[tbHemodialysisResultEntry] ADD  DEFAULT ((0)) FOR [TOALeft]
GO

ALTER TABLE [dbo].[tbHemodialysisResultEntry] ADD  DEFAULT ((0)) FOR [TOARight]
GO


