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