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

Version 6 (modified by Richard Bramley, 11 years ago) ( diff )

--

back

Tables

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

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

Columns

Column UHLREHAB_UHLREHABVWpt1 UHLREHAB_UHLREHABVWpt2
AceinhibitorY
Additionalnotes Y
AgeatcontactY
Angina Y
AspirinY
AssessmentNoDONOTCHANGESHOULDBE11Y
Assessmentnumber2DONOTCHANGESHOULDBE22Y
Assessmentnumber3DONOTCHANGESHOULDBE33 Y
Asthma Y
AttendPhase3Y
BasicLifeSupportTrainingdate Y
BasicLifeSupportTrainingsite Y
BetaBlockerY
BLStraining Y
BMIY
BPdiastolicY
BPsystolicY
Cancer Y
Cholesteroldate Y
CholesterolHDLresultY
CholesterolLDLresultY
CholesterolratioY
CholesterolresultY
Chronicbackproblems Y
Chronicbronchitis Y
Claudication Y
ClopidogrelY
CommunicationY
Completedwebstudy Y
ConsultantnameDonotuseY
ConsultantphonenumberDonotuseY
ContactattemptsafterdischargeY
ContactnotesblankDonotuseY
DatecompletedPhase1 Y
DateofadmissionY
DateOfCurrentStatus Y
DateofdischargeY
DateOfEndStatus Y
DateofinitialRehabHeartfailurecontactY
Dateofinitiatingevent Y
DatesenttoPATSY
DateTimeRecordCreated Y
DateTimeRecordLastChanged Y
DescribeothercomplaintY
DiabetesInitialContact Y
DiabetesPhase1Y
Emphysema Y
EnteredByTag Y
EntryCurrentStatus Y
EntryEndStatus Y
EntryIdYY
EntryStatusY
EthnicGroupY
Exit30x5 Y
ExitAceinhibitorY
ExitAlcohol Y
ExitAspirinY
ExitBetaBlockerY
ExitBMIY
ExitBPcontrolledY
ExitBPdiastolicY
ExitBPsystolicY
ExitCholesterolandTriglyceridesresultdateY
ExitCholesterolHDLresultY
ExitCholesterolLDLresultY
ExitCholesterolratioY
ExitCholesterolresultY
ExitClopidogrelY
ExitdatecompletedY
ExitdatestartedY
ExitdetailsandotherreferalsY
ExitDiabetesY
ExitHADscoreanxietyY
ExitHADscoredepressionY
ExitHealthcareprofessionalY
ExitHeightY
ExitHRQOLChangeinhealthY
ExitHRQOLDailyactivitiesY
ExitHRQOLFeelingsY
ExitHRQOLOverallhealthY
ExitHRQOLPainY
ExitHRQOLPhysicalfitnessY
ExitHRQOLQualityoflifeY
ExitHRQOLSocialactivitesY
ExitHRQOLSocialsupportY
ExitHypercholesterolaemia48Y
ExitHypertensionY
ExitMACNEWEmotionalScore Y
ExitMACNEWPhysicalScore Y
ExitMACNEWscoreY
ExitMACNEWSocialScore Y
ExitNoofFruitVegportionsperday Y
ExitOccupationY
ExitOilyFishWeek Y
ExitOmacor Y
ExitonwardreferralsY
ExitPhysicalactivityfrequencyY
ExitPhysicalactivitymildY
ExitPhysicalactivitymoderateY
ExitphysicalactivitytotalY
ExitPhysicalactivityvigerousY
ExitReadmittedreasonY
ExitSalt Y
ExitSF36ChangeinhealthY
ExitSF36EnergyvitalityY
ExitSF36GeneralhealthperceptionY
ExitSF36MentalhealthY
ExitSF36PainY
ExitSF36PhysicalfunctioningscoreY
ExitSF36RolelimitationemotionalproblemsY
ExitSF36RolelimitationphysicalproblemsY
ExitSF36SocialfunctioningY
ExitsiteY
ExitSmokingY
ExitSmokingcessationsupportY
ExitSmokinginlast4weeks Y
ExitStatinY
ExitTriglyceridesresultY
ExitWaistcmY
ExitWeightY
FacilitatorcontactnumberDonotuseY
FamilyHistorylessthan65Y
FirstfollowupdoneExit Y
FirstfollowupdueExit Y
GPNameY
GPPracticecodeY
HealthcareprofessionalY
HeartFailure12mexerciselessthan20to30minutes Y
HeartFailure6mexerciselessthan20to30minutes Y
Heartfailure6monthassessmentifnotdonereason Y
Heartfailure6monthChronicheartquestionnaireDypsnoe Y
Heartfailure6monthChronicheartquestionnaireEmotion Y
Heartfailure6monthChronicheartquestionnaireFatigue Y
Heartfailure6monthChronicheartquestionnaireMastery Y
Heartfailure6monthESWT Y
Heartfailure6monthESWTEndBORGbreathpeakexercise Y
Heartfailure6monthESWTEndBORGexertionpeakexercise Y
Heartfailure6monthESWTreasonnotdone Y
Heartfailure6monthESWTTimeinseconds Y
Heartfailure6monthHADscoreAnxiety Y
Heartfailure6monthHADscoreDepression Y
Heartfailure6monthMentalhealth Y
Heartfailure6monthRolelimitationemotionalproblems Y
Heartfailure6monthSF36Changeinhealth Y
Heartfailure6monthSF36Energyvitality Y
Heartfailure6monthSF36Generalhealth Y
Heartfailure6monthSF36Pain Y
Heartfailure6monthSF36Physicalfunctioningscore Y
Heartfailure6monthSF36Rolelimitationphysicalproble Y
Heartfailure6monthSF36Socialfunctioning Y
Heartfailure6monthSWTBORGbreathpeakexercise Y
Heartfailure6monthSWTBORGbreathrest Y
Heartfailure6monthSWTBORGexertionpeakexercise Y
Heartfailure6monthSWTdate Y
Heartfailure6monthSWTDiastolicBPrest Y
Heartfailure6monthSWTEnddiastolicBP Y
Heartfailure6monthSWTEndheartrate Y
Heartfailure6monthSWTEndReasonfortermination Y
Heartfailure6monthSWTEndsystolicBP Y
Heartfailure6monthSWTheartraterest Y
Heartfailure6monthSWTHeartrhythm Y
Heartfailure6monthSWTNYHA Y
Heartfailure6monthSWTReasonfortermination Y
Heartfailure6monthSWTreasonifnotdonethisvisit Y
Heartfailure6monthSWTresult Y
Heartfailure6monthSWTSystolicBPrest Y
HeartfailureAdmissiontohospitalwithheartfailure Y
HeartfailureDateofPreChronicheartquestionnaireresu Y
HeartfailureLVSDdiagnosisconfirmed Y
HeartfailurePostChronicheartquestionnaireDypsnoea Y
HeartfailurePostChronicheartquestionnaireEmotional Y
HeartfailurePostChronicheartquestionnaireFatigue Y
HeartfailurePostChronicheartquestionnaireMastery Y
HeartFailurePostESWTEndBORGbreathpeakexercise Y
HeartFailurePostESWTEndBORGexertionpeakexercise Y
HeartFailurePostESWTEndReasonfortermination Y
HeartFailurePostESWTTimeinseconds Y
HeartFailurepostexerciselessthan20to30minutes Y
HeartfailurePostHADscoreAnxiety Y
HeartfailurePostHADscoreDepression Y
HeartfailurePostSF36Changeinhealth Y
HeartfailurePostSF36Energyvitality Y
HeartfailurePostSF36Generalhealth Y
HeartfailurePostSF36Mentalhealth Y
HeartfailurePostSF36Pain Y
HeartfailurePostSF36Physicalfunctioningscore Y
HeartfailurePostSF36Rolelimitationemotionalproblem Y
HeartfailurePostSF36Rolelimitationphysicalproblems Y
HeartfailurePostSF36Socialfunctioning Y
HeartfailurePreChronicheartquestionnaireDypsnoea Y
HeartfailurePreChronicheartquestionnaireEmotional Y
HeartfailurePreChronicheartquestionnaireFatigue Y
HeartfailurePreChronicheartquestionnaireMastery Y
HeartfailurePreESWTEndBORGbreathpeakexercise Y
HeartfailurePreESWTEndBORGexertionpeakexercise Y
HeartfailurePreESWTENDReasonfortermination Y
HeartfailurePreESWTLevel Y
HeartfailurePreESWTTime Y
HeartFailurepreexerciselessthan20to30minutes Y
Heartfailureprefirstadmissionlengthofstayindays Y
HeartfailurePreHADscoreAnxiety Y
HeartfailurePreHADscoreDepression Y
HeartfailurePreSF36Changeinhealth Y
HeartfailurePreSF36Energyvitality Y
HeartfailurePreSF36Generalhealthperception Y
HeartfailurePreSF36Mentalhealth Y
HeartfailurePreSF36Pain Y
HeartfailurePreSF36Physicalfunctioningscore Y
HeartfailurePreSF36Rolelimitationemotionalproblems Y
HeartfailurePreSF36Rolelimitationphysicalproblems Y
HeartfailurePreSF36Socialfunctioning Y
HeartFailurePreSWTNYHA Y
HeightY
Homephonenumber Y
HospitalTag Y
Hypercholesterolaemia48Y
HypertensionY
ImportLinkId Y
InitialContactpointY
InterpreterrequiredY
KeyworkernameDonotuseY
LanguagespokenY
MaritalstatusY
MedicalrecordnumberattimeofentryY
MedicalrecordnumberattimeofregistryentryY
MedicationComments Y
MeetscriteratoattendPhase3educationY
MeetscriteratoattendPhase3exerciseY
NameofrefereeDonotuseY
NameofreferingGPY
NextEntryY
NextofKinDonotuseY
NumberofPhaseones Y
OccupationY
Osteoarthritis Y
Osteoporosis Y
Other Y
OtherpreviouseventsY
PatientGenderY
PatientIdY
PCTY
Phase1 Y
Phase130x5inthelast4weeks Y
Phase1Alcohol Y
Phase1comments Y
Phase1dateY
Phase1HADscoreanxietyY
Phase1HADscoredepressionY
Phase1inpreadmission Y
Phase1InvitetoRehab Y
Phase1NoofFruitVegportionsperday Y
Phase1OilyFishWeek Y
Phase1Salt Y
Phase1siteY
Phase2 Y
Phase230x5 Y
Phase2AceinhibitorY
Phase2Alcohol Y
Phase2AspirinY
Phase2BetaBlockerY
Phase2ClopidogrelY
Phase2completed Y
Phase2datecompletedY
Phase2datestartedY
Phase2HealthcareprofessionalY
Phase2invitetorehab Y
Phase2NoofFruitVegportionsperday Y
Phase2OilyFishWeek Y
Phase2Readmissionnumber Y
Phase2readmittedreasonY
Phase2ReferralsmadeY
Phase2Salt Y
Phase2siteY
Phase2SmokingY
Phase2SmokingcessationsupportY
Phase2StatinY
Phase3 Y
Phase3AcuteeventsduringrehabY
Phase3DateacuteeventsduringrehabfromY
Phase3DateacuteeventsduringrehabtoY
Phase3datecompletedY
Phase3datestartedY
Phase3educationattendedY
Phase3exerciseattendedY
Phase3readmitted Y
Phase3ReadmittedreasonY
Phase3site Y
Phase4 Y
Phase4referralY
Posteventcomments Y
PostSWTBorgbreathlessnessY
PostSWTBorgexertionY
PostSWTNoncompletionY
PostSWTrestingBPdiastolicY
PostSWTrestingBPsystolicY
PostSWTrestingHRY
PostSWTresultY
PostSWTtrueBPdiastolicY
PostSWTtrueBPsystolicY
PostSWTtrueHRY
PracticeBorgbreathlessnessY
PracticeBorgExertionY
PracticePostBPDiastolicY
PracticePostBPsystolicY
PracticePostHRY
PracticeRestingBPDiastolicY
PracticerestingHRY
PracticeSWTresultY
Pre3Omacor Y
PrePhase330x5 Y
PrePhase3AceinhibitorY
PrePhase3AcuteeventsduringrehabY
PrePhase3Alcohol Y
PrePhase3AspirinY
PrePhase3attendanceY
PrePhase3BetaBlockerY
PrePhase3BMIY
PrePhase3BPdiastolicY
PrePhase3BPsystolicY
PrePhase3ClopidogrelY
PrePhase3dateY
PrePhase3DateacuteeventsduringrehabfromY
PrePhase3DateacuteeventsduringrehabtoY
PrePhase3HADscoreanxietyY
PrePhase3HADscoreDepressionY
PrePhase3HealthcareprofessionalY
PrePhase3HeightY
PrePhase3HRQOLChangeinhealthY
PrePhase3HRQOLDailyactivitiesY
PrePhase3HRQOLFeelingY
PrePhase3HRQOLOverallhealthY
PrePhase3HRQOLPainY
PrePhase3HRQOLPhysicalfitnessY
PrePhase3HRQOLQualityoflifeY
PrePhase3HRQOLSocialactivitiesY
PrePhase3HRQOLSocialsupportY
PrePhase3HypertensionY
PrePhase3MACNEWEmotionalScore Y
Prephase3MACNEWPhysicalScore Y
PrePhase3MACNEWscoreY
Prephase3MACNEWSocialScore Y
PrePhase3medicationcomments Y
PrePhase3NoofFruitVegportionsperday Y
PrePhase3OccupationY
PrePhase3OilyFishWeek Y
Prephase3otherreferrals Y
PrePhase3PhysicalactivityfrequencyY
PrePhase3PhysicalactivitymildY
PrePhase3PhysicalactivitymoderateY
PrePhase3PhysicalactivitytotalY
PrePhase3PhysicalactivityVigerousY
PrePhase3readmissiondate Y
PrePhase3readmissiondischargedate Y
PrePhase3readmitted Y
PrePhase3ReadmittedreasonY
PrePhase3ReferralsY
PrePhase3riskassessmentY
PrePhase3Salt Y
PrePhase3SF36ChangeinhealthY
PrePhase3SF36EnergyvitalityY
PrePhase3SF36GeneralhealthperceptionY
PrePhase3SF36MentalhealthY
PrePhase3SF36PainY
Prephase3SF36PhysicalfunctioningscoreY
PrePhase3SF36RolelimitationemotionalproblemsY
PrePhase3SF36RolelimitationphysicalproblemsY
PrePhase3SF36SocialfunctioningY
PrePhase3siteY
PrePhase3SmokingY
PrePhase3SmokingcessationsupportY
PrePhase3Smokinginlast4weeks Y
PrePhase3StatinY
PrePhase3WaistcmY
PrePhase3WeightY
PreviousEntryY
ProceedtoExitAppointmentY
Proceedtophase2Y
ProceedtoprePhase3Y
ReasonfirstfollowupnotdoneExit Y
ReasonfornoSWTY
ReasonfornottakingpartPhase1 Y
ReasonfornottakingpartPhase2 Y
ReasonfornottakingpartPhase3Y
ReasonfornottakingpartPhase4 Y
Reasonphase1missed Y
Reasonphase1missedcomments Y
ReasonswhyasecondSWTwasnotdone Y
Reasonwebstudynotoffered Y
ReasonyearlyfollowupnotdoneY
ReferralsY
ReferredbyY
RefertoPhase4Y
RehabdocumentationstoredY
Rehabdocumentationstores Y
Rehabilitationtype Y
RehabInitiatingeventY
RehabpercentcompletedY
RehabphaseBACRADONOTCHANGESHOULDBEPHASE2Y
RehabphaseBACRADONOTCHANGESHOULDBEPHASE3 Y
RehabphaseBACRADONOTCHANGESHOULDBEPHASE4Y
RehabreasonnoncompletedY
RehabreasonnotcompletedPhase1 Y
RehabreasonnotcompletedPhase2 Y
RehabreasonnotcompletedPhase3 Y
Rheumatoidarthritis Y
SecondPrePh3MACNEWEmotionalScore Y
SecondPrePh3MACNEWPhysicalScore Y
SecondPrePh3MACNEWSocialScore Y
SecondPrePhase3HADAnxiety Y
SecondPrePhase3HADDepression Y
SecondPrePhase3healthcareprofessional Y
SecondPrePhase3MACNEWscore Y
SecondPrePhase3site Y
SecondPrePhase3SWTPostresult Y
SecondPrePhase3SWTPracticeresult Y
SeondPrePhase3date Y
Siteoffirstrehab Y
SmokingcessationsupportY
Smokinginlast4weeksY
SouthAsianSAprogramattended Y
SouthAsianSAprogramofferedY
SponsoredWalk Y
StatinY
Stroke Y
SWTPrePhase3practicerestingBPSystolicY
TimeOfEntryY
Treatmentassociatedwithinitiatingevent Y
TriglyceridesresultY
TrueBorgbreathlessnessY
TrueBorgExertionY
TruePostBPDiastolicY
TruePostBPSystolicY
TruePostHRY
TrueRestingBpDiastolicY
TrueRestingBPsystolicY
TrueRestingHRY
TrueSWTresultY
TwelveMonth30x5 Y
TwelvemonthAceinhibitor Y
TwelvemonthAspirin Y
TwelvemonthBetaBlocker Y
TwelveMonthBMI Y
TwelveMonthBPcontrolled Y
TwelveMonthBPdiastolic Y
TwelveMonthBPsystolic Y
TwelveMonthCholesterol Y
TwelveMonthCholesterolHDL Y
TwelveMonthCholesterolLDL Y
TwelveMonthCholesterolratio Y
TwelveMonthCholesteroltotal Y
TwelveMonthCholesterolTriglycerides Y
TwelvemonthClopidogrel Y
TwelvemonthEmploymentstatus Y
TwelveMonthHADscoreanxiety Y
TwelveMonthHADscoreDepression Y
TwelveMonthHeight Y
TwelveMonthHypercholesterolaemia48 Y
TwelveMonthHypertension Y
TwelveMonthMACNEWEmotionalScore Y
TwelveMonthMACNEWPhysicalScore Y
TwelveMonthMACNEWscore Y
TwelveMonthMACNEWSocialScore Y
Twelvemonthmedicationcomments Y
TwelvemonthOmacor Y
TwelvemonthPackyear Y
TwelveMonthPhysicalactivityfrequency Y
TwelveMonthPhysicalactivitymild Y
TwelveMonthPhysicalactivitymoderate Y
TwelveMonthPhysicalactivitytotal Y
TwelveMonthPhysicalactivityVigerous Y
TwelvemonthSmokinginlast4weeks Y
TwelvemonthStatin Y
TwelveMonthwaistcm Y
TwelveMonthWeight Y
TwelveSmokingcessationsupport Y
Webstudyoffered Y
WeightY
Yearlyfollowupdate Y
YearlyfollowupdoneY
YearlyfollowupdueY
YearlyHRQOLChangeinhealthY
YearlyHRQOLDailyactivitiesY
YearlyHRQOLFeelingsY
YearlyHRQOLOverallhealthY
YearlyHRQOLPainY
YearlyHRQOLPhysicalfitnessY
YearlyHRQOLQualityoflifeY
YearlyHRQOLSocialactivitiesY
YearlyHRQOLSocialsupportYn
Note: See TracWiki for help on using the wiki.