wiki:i2b2 - UHL clinical informatics system integration PATS Rehab Combined

Version 4 (modified by Richard Bramley, 12 years ago) ( diff )

--

back

Tables

Table Date Range Start Date Field Records
UHLREHAB_UHLREHABVWpt11899(sic)-2013DateofinitialRehabHeartfailurecontact16923
UHLREHAB_UHLREHABVWpt11901(sic)-2013Dateofinitiatingevent16923

I think that these two tables are, in fact, two halves of the same table.

Columns

AceinhibitorAdditionalnotesAgeatcontactAnginaAspirinAssessmentNoDONOTCHANGESHOULDBE11Assessmentnumber2DONOTCHANGESHOULDBE22Assessmentnumber3DONOTCHANGESHOULDBE33AsthmaAttendPhase3BasicLifeSupportTrainingdateBasicLifeSupportTrainingsiteBetaBlockerBLStrainingBMIBPdiastolicBPsystolicCancerCholesteroldateCholesterolHDLresultCholesterolLDLresultCholesterolratioCholesterolresultChronicbackproblemsChronicbronchitisClaudicationClopidogrelCommunicationCompletedwebstudyConsultantnameDonotuseConsultantphonenumberDonotuseContactattemptsafterdischargeContactnotesblankDonotuseDatecompletedPhase1DateofadmissionDateOfCurrentStatusDateofdischargeDateOfEndStatusDateofinitialRehabHeartfailurecontactDateofinitiatingeventDatesenttoPATSDateTimeRecordCreatedDateTimeRecordLastChangedDescribeothercomplaintDiabetesInitialContactDiabetesPhase1EmphysemaEnteredByTagEntryCurrentStatusEntryEndStatusEntryIdEntryStatusEthnicGroupExit30x5ExitAceinhibitorExitAlcoholExitAspirinExitBetaBlockerExitBMIExitBPcontrolledExitBPdiastolicExitBPsystolicExitCholesterolandTriglyceridesresultdateExitCholesterolHDLresultExitCholesterolLDLresultExitCholesterolratioExitCholesterolresultExitClopidogrelExitdatecompletedExitdatestartedExitdetailsandotherreferalsExitDiabetesExitHADscoreanxietyExitHADscoredepressionExitHealthcareprofessionalExitHeightExitHRQOLChangeinhealthExitHRQOLDailyactivitiesExitHRQOLFeelingsExitHRQOLOverallhealthExitHRQOLPainExitHRQOLPhysicalfitnessExitHRQOLQualityoflifeExitHRQOLSocialactivitesExitHRQOLSocialsupportExitHypercholesterolaemia48ExitHypertensionExitMACNEWEmotionalScoreExitMACNEWPhysicalScoreExitMACNEWscoreExitMACNEWSocialScoreExitNoofFruitVegportionsperdayExitOccupationExitOilyFishWeekExitOmacorExitonwardreferralsExitPhysicalactivityfrequencyExitPhysicalactivitymildExitPhysicalactivitymoderateExitphysicalactivitytotalExitPhysicalactivityvigerousExitReadmittedreasonExitSaltExitSF36ChangeinhealthExitSF36EnergyvitalityExitSF36GeneralhealthperceptionExitSF36MentalhealthExitSF36PainExitSF36PhysicalfunctioningscoreExitSF36RolelimitationemotionalproblemsExitSF36RolelimitationphysicalproblemsExitSF36SocialfunctioningExitsiteExitSmokingExitSmokingcessationsupportExitSmokinginlast4weeksExitStatinExitTriglyceridesresultExitWaistcmExitWeightFacilitatorcontactnumberDonotuseFamilyHistorylessthan65FirstfollowupdoneExitFirstfollowupdueExitGPNameGPPracticecodeHealthcareprofessionalHeartFailure12mexerciselessthan20to30minutesHeartFailure6mexerciselessthan20to30minutesHeartfailure6monthassessmentifnotdonereasonHeartfailure6monthChronicheartquestionnaireDypsnoeHeartfailure6monthChronicheartquestionnaireEmotionHeartfailure6monthChronicheartquestionnaireFatigueHeartfailure6monthChronicheartquestionnaireMasteryHeartfailure6monthESWTHeartfailure6monthESWTEndBORGbreathpeakexerciseHeartfailure6monthESWTEndBORGexertionpeakexerciseHeartfailure6monthESWTreasonnotdoneHeartfailure6monthESWTTimeinsecondsHeartfailure6monthHADscoreAnxietyHeartfailure6monthHADscoreDepressionHeartfailure6monthMentalhealthHeartfailure6monthRolelimitationemotionalproblemsHeartfailure6monthSF36ChangeinhealthHeartfailure6monthSF36EnergyvitalityHeartfailure6monthSF36GeneralhealthHeartfailure6monthSF36PainHeartfailure6monthSF36PhysicalfunctioningscoreHeartfailure6monthSF36RolelimitationphysicalprobleHeartfailure6monthSF36SocialfunctioningHeartfailure6monthSWTBORGbreathpeakexerciseHeartfailure6monthSWTBORGbreathrestHeartfailure6monthSWTBORGexertionpeakexerciseHeartfailure6monthSWTdateHeartfailure6monthSWTDiastolicBPrestHeartfailure6monthSWTEnddiastolicBPHeartfailure6monthSWTEndheartrateHeartfailure6monthSWTEndReasonforterminationHeartfailure6monthSWTEndsystolicBPHeartfailure6monthSWTheartraterestHeartfailure6monthSWTHeartrhythmHeartfailure6monthSWTNYHAHeartfailure6monthSWTReasonforterminationHeartfailure6monthSWTreasonifnotdonethisvisitHeartfailure6monthSWTresultHeartfailure6monthSWTSystolicBPrestHeartfailureAdmissiontohospitalwithheartfailureHeartfailureDateofPreChronicheartquestionnaireresuHeartfailureLVSDdiagnosisconfirmedHeartfailurePostChronicheartquestionnaireDypsnoeaHeartfailurePostChronicheartquestionnaireEmotionalHeartfailurePostChronicheartquestionnaireFatigueHeartfailurePostChronicheartquestionnaireMasteryHeartFailurePostESWTEndBORGbreathpeakexerciseHeartFailurePostESWTEndBORGexertionpeakexerciseHeartFailurePostESWTEndReasonforterminationHeartFailurePostESWTTimeinsecondsHeartFailurepostexerciselessthan20to30minutesHeartfailurePostHADscoreAnxietyHeartfailurePostHADscoreDepressionHeartfailurePostSF36ChangeinhealthHeartfailurePostSF36EnergyvitalityHeartfailurePostSF36GeneralhealthHeartfailurePostSF36MentalhealthHeartfailurePostSF36PainHeartfailurePostSF36PhysicalfunctioningscoreHeartfailurePostSF36RolelimitationemotionalproblemHeartfailurePostSF36RolelimitationphysicalproblemsHeartfailurePostSF36SocialfunctioningHeartfailurePreChronicheartquestionnaireDypsnoeaHeartfailurePreChronicheartquestionnaireEmotionalHeartfailurePreChronicheartquestionnaireFatigueHeartfailurePreChronicheartquestionnaireMasteryHeartfailurePreESWTEndBORGbreathpeakexerciseHeartfailurePreESWTEndBORGexertionpeakexerciseHeartfailurePreESWTENDReasonforterminationHeartfailurePreESWTLevelHeartfailurePreESWTTimeHeartFailurepreexerciselessthan20to30minutesHeartfailureprefirstadmissionlengthofstayindaysHeartfailurePreHADscoreAnxietyHeartfailurePreHADscoreDepressionHeartfailurePreSF36ChangeinhealthHeartfailurePreSF36EnergyvitalityHeartfailurePreSF36GeneralhealthperceptionHeartfailurePreSF36MentalhealthHeartfailurePreSF36PainHeartfailurePreSF36PhysicalfunctioningscoreHeartfailurePreSF36RolelimitationemotionalproblemsHeartfailurePreSF36RolelimitationphysicalproblemsHeartfailurePreSF36SocialfunctioningHeartFailurePreSWTNYHAHeightHomephonenumberHospitalTagHypercholesterolaemia48HypertensionImportLinkIdInitialContactpointInterpreterrequiredKeyworkernameDonotuseLanguagespokenMaritalstatusMedicalrecordnumberattimeofentryMedicalrecordnumberattimeofregistryentryMedicationCommentsMeetscriteratoattendPhase3educationMeetscriteratoattendPhase3exerciseNameofrefereeDonotuseNameofreferingGPNextEntryNextofKinDonotuseNumberofPhaseonesOccupationOsteoarthritisOsteoporosisOtherOtherpreviouseventsPatientGenderPatientIdPCTPhase1Phase130x5inthelast4weeksPhase1AlcoholPhase1commentsPhase1datePhase1HADscoreanxietyPhase1HADscoredepressionPhase1inpreadmissionPhase1InvitetoRehabPhase1NoofFruitVegportionsperdayPhase1OilyFishWeekPhase1SaltPhase1sitePhase2Phase230x5Phase2AceinhibitorPhase2AlcoholPhase2AspirinPhase2BetaBlockerPhase2ClopidogrelPhase2completedPhase2datecompletedPhase2datestartedPhase2HealthcareprofessionalPhase2invitetorehabPhase2NoofFruitVegportionsperdayPhase2OilyFishWeekPhase2ReadmissionnumberPhase2readmittedreasonPhase2ReferralsmadePhase2SaltPhase2sitePhase2SmokingPhase2SmokingcessationsupportPhase2StatinPhase3Phase3AcuteeventsduringrehabPhase3DateacuteeventsduringrehabfromPhase3DateacuteeventsduringrehabtoPhase3datecompletedPhase3datestartedPhase3educationattendedPhase3exerciseattendedPhase3readmittedPhase3ReadmittedreasonPhase3sitePhase4Phase4referralPosteventcommentsPostSWTBorgbreathlessnessPostSWTBorgexertionPostSWTNoncompletionPostSWTrestingBPdiastolicPostSWTrestingBPsystolicPostSWTrestingHRPostSWTresultPostSWTtrueBPdiastolicPostSWTtrueBPsystolicPostSWTtrueHRPracticeBorgbreathlessnessPracticeBorgExertionPracticePostBPDiastolicPracticePostBPsystolicPracticePostHRPracticeRestingBPDiastolicPracticerestingHRPracticeSWTresultPre3OmacorPrePhase330x5PrePhase3AceinhibitorPrePhase3AcuteeventsduringrehabPrePhase3AlcoholPrePhase3AspirinPrePhase3attendancePrePhase3BetaBlockerPrePhase3BMIPrePhase3BPdiastolicPrePhase3BPsystolicPrePhase3ClopidogrelPrePhase3datePrePhase3DateacuteeventsduringrehabfromPrePhase3DateacuteeventsduringrehabtoPrePhase3HADscoreanxietyPrePhase3HADscoreDepressionPrePhase3HealthcareprofessionalPrePhase3HeightPrePhase3HRQOLChangeinhealthPrePhase3HRQOLDailyactivitiesPrePhase3HRQOLFeelingPrePhase3HRQOLOverallhealthPrePhase3HRQOLPainPrePhase3HRQOLPhysicalfitnessPrePhase3HRQOLQualityoflifePrePhase3HRQOLSocialactivitiesPrePhase3HRQOLSocialsupportPrePhase3HypertensionPrePhase3MACNEWEmotionalScorePrephase3MACNEWPhysicalScorePrePhase3MACNEWscorePrephase3MACNEWSocialScorePrePhase3medicationcommentsPrePhase3NoofFruitVegportionsperdayPrePhase3OccupationPrePhase3OilyFishWeekPrephase3otherreferralsPrePhase3PhysicalactivityfrequencyPrePhase3PhysicalactivitymildPrePhase3PhysicalactivitymoderatePrePhase3PhysicalactivitytotalPrePhase3PhysicalactivityVigerousPrePhase3readmissiondatePrePhase3readmissiondischargedatePrePhase3readmittedPrePhase3ReadmittedreasonPrePhase3ReferralsPrePhase3riskassessmentPrePhase3SaltPrePhase3SF36ChangeinhealthPrePhase3SF36EnergyvitalityPrePhase3SF36GeneralhealthperceptionPrePhase3SF36MentalhealthPrePhase3SF36PainPrephase3SF36PhysicalfunctioningscorePrePhase3SF36RolelimitationemotionalproblemsPrePhase3SF36RolelimitationphysicalproblemsPrePhase3SF36SocialfunctioningPrePhase3sitePrePhase3SmokingPrePhase3SmokingcessationsupportPrePhase3Smokinginlast4weeksPrePhase3StatinPrePhase3WaistcmPrePhase3WeightPreviousEntryProceedtoExitAppointmentProceedtophase2ProceedtoprePhase3ReasonfirstfollowupnotdoneExitReasonfornoSWTReasonfornottakingpartPhase1ReasonfornottakingpartPhase2ReasonfornottakingpartPhase3ReasonfornottakingpartPhase4Reasonphase1missedReasonphase1missedcommentsReasonswhyasecondSWTwasnotdoneReasonwebstudynotofferedReasonyearlyfollowupnotdoneReferralsReferredbyRefertoPhase4RehabdocumentationstoredRehabdocumentationstoresRehabilitationtypeRehabInitiatingeventRehabpercentcompletedRehabphaseBACRADONOTCHANGESHOULDBEPHASE2RehabphaseBACRADONOTCHANGESHOULDBEPHASE3RehabphaseBACRADONOTCHANGESHOULDBEPHASE4RehabreasonnoncompletedRehabreasonnotcompletedPhase1RehabreasonnotcompletedPhase2RehabreasonnotcompletedPhase3RheumatoidarthritisSecondPrePh3MACNEWEmotionalScoreSecondPrePh3MACNEWPhysicalScoreSecondPrePh3MACNEWSocialScoreSecondPrePhase3HADAnxietySecondPrePhase3HADDepressionSecondPrePhase3healthcareprofessionalSecondPrePhase3MACNEWscoreSecondPrePhase3siteSecondPrePhase3SWTPostresultSecondPrePhase3SWTPracticeresultSeondPrePhase3dateSiteoffirstrehabSmokingcessationsupportSmokinginlast4weeksSouthAsianSAprogramattendedSouthAsianSAprogramofferedSponsoredWalkStatinStrokeSWTPrePhase3practicerestingBPSystolicTimeOfEntryTreatmentassociatedwithinitiatingeventTriglyceridesresultTrueBorgbreathlessnessTrueBorgExertionTruePostBPDiastolicTruePostBPSystolicTruePostHRTrueRestingBpDiastolicTrueRestingBPsystolicTrueRestingHRTrueSWTresultTwelveMonth30x5TwelvemonthAceinhibitorTwelvemonthAspirinTwelvemonthBetaBlockerTwelveMonthBMITwelveMonthBPcontrolledTwelveMonthBPdiastolicTwelveMonthBPsystolicTwelveMonthCholesterolTwelveMonthCholesterolHDLTwelveMonthCholesterolLDLTwelveMonthCholesterolratioTwelveMonthCholesteroltotalTwelveMonthCholesterolTriglyceridesTwelvemonthClopidogrelTwelvemonthEmploymentstatusTwelveMonthHADscoreanxietyTwelveMonthHADscoreDepressionTwelveMonthHeightTwelveMonthHypercholesterolaemia48TwelveMonthHypertensionTwelveMonthMACNEWEmotionalScoreTwelveMonthMACNEWPhysicalScoreTwelveMonthMACNEWscoreTwelveMonthMACNEWSocialScoreTwelvemonthmedicationcommentsTwelvemonthOmacorTwelvemonthPackyearTwelveMonthPhysicalactivityfrequencyTwelveMonthPhysicalactivitymildTwelveMonthPhysicalactivitymoderateTwelveMonthPhysicalactivitytotalTwelveMonthPhysicalactivityVigerousTwelvemonthSmokinginlast4weeksTwelvemonthStatinTwelveMonthwaistcmTwelveMonthWeightTwelveSmokingcessationsupportWebstudyofferedWeightYearlyfollowupdateYearlyfollowupdoneYearlyfollowupdueYearlyHRQOLChangeinhealthYearlyHRQOLDailyactivitiesYearlyHRQOLFeelingsYearlyHRQOLOverallhealthYearlyHRQOLPainYearlyHRQOLPhysicalfitnessYearlyHRQOLQualityoflifeYearlyHRQOLSocialactivitiesYearlyHRQOLSocialsupport
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
YY
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Yn
Note: See TracWiki for help on using the wiki.