wiki:i2b2 - UHL clinical informatics system integration PATS CS PostProcedure Combined

back

Tables

Table Date Range Start Date Field Records
CS_PostProcedure1998-2004DateOfDischarge7901
CS2003F_PostProcedure2004-2013DateOfDischargeOrDeath9383
CS2010F_PostProcedure2011-2013DateOfOperation2007

Columns

Column CS_PostProcedure CS2003F_PostProcedure CS2010F_PostProcedure
AddedToW_l YY
AdditionToParsonnetScore_CatastrophicState_scores10_50Y
AdditionToParsonnetScore_OtherRareCircumstances_scores2_10Y
AdditiveEuroscore Y
AdequacyOfPremedY
AdmissionCategoryY
AdmissionTimeToRecovery_cicuY
AdmissionTimeToRecovery_cicu_pcu YY
AdmittedFrom_hospitalNameOrWard YY
AdmittedFrom_hospitalNameOrWardNo_Y
AdmittedToCardiacSurgeryYY (ignored)Y
AdmittedToCicuY
AdviceToGp Y
AdviceToGpAndAnyMedicationChangedOrStopped Y (ignored)
Airway_MallampatiY
AllDataEnteredY
AllergicReactionY
AmountOfTimeInRecovery_cicuY
AmountOfTimeInRecovery_cicu_pcu YY
AmountOfTimeIntubatedY
AmountOfTimeIntubated_pcu YY
AnalgesiaUsedPcuYYY
AprotininY
AreaPatientAdmittedToY
AreaPatientAdmittedTo_pcu YY
Arrhythmia_S Y (ignored)Y
ArrhythmiaOtherComplicationFreeText YY
ArrhythmiasY
ArrivalInAnaestheticRoomY
ArrythmiasY
AuditLoopClosedY
AuditTrailYYY
BackOnBypassY
BairhuggerWithPatientY
BairhuggerWithPatient_pcu YY
BleedingY
BloodProductsY
BloodUsedYYY
BmiY
BmiOver35Y
BodyMassIndex YY
BodySurfaceArea YY
BsaY
BypassY
Cardioplegia_Infusion Y
Cardioplegia_InfusionMode Y
Cardioplegia_Solution YY
Cardioplegia_Temperature YY
Cardioplegia_Timing YY
CardioplegiaMethodY
CardioplegiaMethod_2Y
CardiopulmonaryBypassYYY
CardiopulmonaryBypass_2Y
CauseOfDeathYYY
CirculatoryArrestTime_minY
CirculatoryArrestTime_min2Y
ComingOffBypassY
Comments Y (ignored)Y
Continue1 YY
Continue10 YY
Continue11 YY
Continue12 YY
Continue13 YY
Continue14 YY
Continue15 YY
Continue16 YY
Continue17 YY
Continue18 YY
Continue19 YY
Continue2 YY
Continue20 YY
Continue21 YY
Continue22 YY
Continue23 YY
Continue24 YY
Continue3 YY
Continue4 YY
Continue5 YY
Continue6 YY
Continue7 YY
Continue8 YY
Continue9 YY
CouncilCase YY
Cs1999ComplexCabgBayesScore Y
Cumulative1sr2nd3rd4th5thStayInCicu YY
Cumulative1st2nd3rd4thStayInCicu YY
Cumulative1st2ndAnd3rdStayInCicu YY
CumulativeBypassTime Y
CumulativeBypassTime_minY
CumulativeBypassTime_min2Y
CumulativeBypassTimeInMin Y
CumulativeCrossClampTime Y
CumulativeCrossClampTimeInMin Y
CumulativeStayFirstAndSecondAdmissionToCicu YY
CumulativeXcTime_minY
CumulativeXcTime_min2Y
DateAddedToW_l Y (ignored)Y
DateAdmittedToCicuY
DateAuditLoopClosedY
DateFirstAdmittedToCicu Y (ignored)Y
DateFirstDischargedFromCicu Y (ignored)Y
DateFormFilledInY
DateOfDeathY
DateOfDischargeY
DateOfDischargeOrDeath Y (ignored)Y
DateOfFifthAdmissionToCicu Y (ignored)Y
DateOfFifthDischargeFromCicu Y (ignored)Y
DateOfFirstReadmissionY
DateOfFollow_UpY
DateOfFollowUp Y (ignored)Y
DateOfFourthAdmissionToCicu Y (ignored)Y
DateOfFourthDischargeFromCicu Y (ignored)Y
DateOfSecondAdmissionToCicu Y (ignored)Y
DateOfSecondDischargeFromCicu Y (ignored)Y
DateOfSecondReadmissionY
DateOfThirdAdmissionToCicu Y (ignored)Y
DateOfThirdDischargeFromCicu Y (ignored)Y
DateTimeRecordCreated Y (ignored)Y
DateTimeRecordLastChanged Y (ignored)Y
DaysVentilatedY
DiedOnCicuY
DischargeCommentY
DischargedCardiacSurgeryY
DischargeDestination_FromCardiothoracicWard Y
DischargeDestinationFromCardiothoracicWard Y
DischargedFromCardiacSurgery Y (ignored)Y
DischargedFromCicuY
DischargeToY
DischargeWard YY
DiureticsY
DoesPatientMeetDischargeCriteriaY
DoesPatientMeetDischargeCriteria_pcu YY
DoesPatientMeetInterOperativeCriteriaY
DoesPatientMeetInterOperativeCriteria_pcu YY
DoesPatientNeedAFollowUpAppiontment YY
DosageY
Dosage_pcu YY
Drug1 Y (ignored)Y
Drug10 Y (ignored)Y
Drug11 Y (ignored)Y
Drug12 Y (ignored)Y
Drug13 YY
Drug14 YY
Drug15 YY
Drug16 YY
Drug17 YY
Drug18 YY
Drug2 Y (ignored)Y
Drug3 Y (ignored)Y
Drug4 Y (ignored)Y
Drug5 Y (ignored)Y
Drug6 Y (ignored)Y
Drug7 Y (ignored)Y
Drug8 Y (ignored)Y
Drug9 Y (ignored)Y
DrugDose19 Y (ignored)Y
DrugDose20 Y (ignored)Y
DrugDose21 Y (ignored)Y
DrugDose22 Y (ignored)Y
DrugDose23 Y (ignored)Y
DrugDose24 YY
DrugForm19 YY
DrugForm20 YY
DrugForm21 YY
DrugForm22 YY
DrugForm23 YY
DrugForm24 YY
DrugFrequency19 YY
DrugFrequency20 YY
DrugFrequency21 YY
DrugFrequency22 YY
DrugFrequency23 YY
DrugFrequency24 YY
DrugNameAndStrength19 Y (ignored)Y
DrugNameAndStrength20 Y (ignored)Y
DrugNameAndStrength21 Y (ignored)Y
DrugNameAndStrength22 Y (ignored)Y
DrugNameAndStrength23 Y (ignored)Y
DrugNameAndStrength24 YY
DrugRoute1 YY
DrugRoute10 YY
DrugRoute11 YY
DrugRoute12 YY
DrugRoute13 YY
DrugRoute14 YY
DrugRoute15 YY
DrugRoute16 YY
DrugRoute17 YY
DrugRoute18 YY
DrugRoute19 YY
DrugRoute2 YY
DrugRoute20 YY
DrugRoute21 YY
DrugRoute22 YY
DrugRoute23 YY
DrugRoute24 YY
DrugRoute3 YY
DrugRoute4 YY
DrugRoute5 YY
DrugRoute6 YY
DrugRoute7 YY
DrugRoute8 YY
DrugRoute9 YY
DrugSensitivity Y (ignored)Y
EcgChanges_IschaemicY
EnteredByTag YY
EntryCurrentStatusY
EntryEndStatusY
EntryIdYY (ignored)Y
EntryStatusY
EpiduralY
EuroscoreYY
EuroscoreMinumumDatasetCheck YY
ExtubationDateAndTimeY
ExtubationDateAndTime_pcu YY
FastTrackPatientY
FifthAdmissionToCicuTotalStay_nights YY
FirstAnaesthetistGradeY
FirstAssistantY
FirstAssistant_sa YY
FirstReadmissionDischargeDateY
FirstReadmissionStay_nightsY
FirstSite_conduit_locationY
FirstSiteCommentsY
FirstSiteComments_sa Y (ignored)Y
FirstSiteCommentsMadeY
FirstSiteCommentsMade_sa YY
FirstSiteConduei_location_sa YY
FollowUpRequired YY
FollowUpTimeInWeeks_months Y (ignored)Y
FourthAdmissionToCicuTotalStay_nights YY
FundingSourceY
GastrointestinalComplications YY
GastrointestinalOtherComplicationFreeText YY
GiComplicationsY
GpPracticeCodeY
GpPracticeCodeAtTimeOfSurgery Y (ignored)Y
GradeOfDischargingDoctor Y (ignored)Y
HaemodynamicInstabilityY
HeartRhythmActivityY
Height_cmY
HeightInCm YY
HospitalTag YY
HowMuchColloidUsedInRecoveryY
HowMuchColloidUsedInRecovery_pcu YY
IabpInsertionBySaY
IabpInsertionBySa_sa YY
IabpInsertionCommentsY
IabpInsertionComments_sa YY
IabpInsertionCommentsMadeY
IabpInsertionCommentsMade_sa YY
IabpRemovalBySaY
IabpRemovalBySa_sa YY
IabpRemovalCommentsY
IabpRemovalComments_sa YY
IabpRemovalCommentsMadeY
IabpRemovalCommentsMade_sa YY
IfNoStateWhyY
IfNoStateWhy_pcu YY
IfNotOperatedOnSamedayGiveReason Y
IfNoWhyY
IfNoWhy_pcu YY
IfSickNoteOfferedDurationInDays YY
IfYesY
InfectiveComplicationsYYY
InfectiveOtherComplicationFreeText Y (ignored)Y
InformationGivenToPatient Y (ignored)Y
InitialConsultantInJointCase YY
InotropesUsedY
InotropesUsed_pcu YY
InsertionOfPacemakerWiresViaVatsProcedure YY
IntervalBetweenProc_LoopClosedY
Intra_AorticBalloonPumpUsed Y
IntraAorticBalloonPumpUsed Y
IntubationY
IntubationTimeInHours YY
LogisticEuroscore YY
LongestXcTimeIfVf_xcUsed_minY
LongestXcTimeIfVf_xcUsed_min2Y
LowCardiacOutputYYY
LowCardiacOutputOtherComplicationFreeText YY
LowUrineOutputY
LowUrineOutput_pcu YY
ManagementPlan Y (ignored)Y
MedicalRecordNumberYY (ignored)Y
MedicationChangedByPharmacist YY
MedicationOnDischarge1Y
MedicationOnDischarge10Y
MedicationOnDischarge2Y
MedicationOnDischarge3Y
MedicationOnDischarge4Y
MedicationOnDischarge5Y
MedicationOnDischarge6Y
MedicationOnDischarge7Y
MedicationOnDischarge8Y
MedicationOnDischarge9Y
MultisystemFailureY
MutisystemFailure YY
NameOfDischargingDoctor Y (ignored)Y
NameOfDoctorCompletingBooklet Y (ignored)Y
NameOfGpAtTimeOfSurgery Y (ignored)Y
NameOfReferringGpY
NameOfReferringGpAtTimeOfSurgeryType8 Y (ignored)Y
NeurologicalComplicationsY
NewHaemofiltration_DialysisPost_Operatively Y
NewHaemofiltrationOrDialysis Y
NewPost_OperativeNeurologicalDysfunction Y
NewPost_OperativeStroke Y
NextEntryY
Non_CardioplegiaMyocardialProtection Y
Non_CardioplegicMyocardialProtection Y
NonCardioplegiaMyocardialProtectionY
NonCardioplegiaMyocardialProtection_2Y
NumberOfDays1 YY
NumberOfDays10 YY
NumberOfDays11 YY
NumberOfDays12 YY
NumberOfDays13 YY
NumberOfDays14 YY
NumberOfDays15 YY
NumberOfDays16 YY
NumberOfDays17 YY
NumberOfDays18 YY
NumberOfDays19 YY
NumberOfDays2 YY
NumberOfDays20 YY
NumberOfDays21 YY
NumberOfDays22 YY
NumberOfDays23 YY
NumberOfDays24 YY
NumberOfDays3 YY
NumberOfDays4 YY
NumberOfDays5 YY
NumberOfDays6 YY
NumberOfDays7 YY
NumberOfDays8 YY
NumberOfDays9 YY
OverallCommentsY
OverallComments_sa Y (ignored)Y
PagerNumber Y (ignored)Y
PainScoeOnWakingY
PainScoreOnWaking_pcu YY
ParsonetDiabetesY
Parsonnet_AdditionsForCatastrophicStates YY
Parsonnet_AdditionsForRareConditions YY
ParsonnetMinumumDatasetCheck YY
ParsonnetScore_patsY
ParsonnetScoreFromHardData YY
ParsonnetScoreWithCatastrophicStatesAndRareConditi YY
PatientIdYY (ignored)Y
PatientIdentifiedForSamedayAdmission YY
PatientStatusY
PctY
PctAtTimeOfSurgery Y (ignored)Y
PcuPatientY
PcuPatient_pcu YY
Peri_InductionStabilityY
PeriOperativeComplicationsY
Pharmacist YY
PlaceOfDischargeY
PlaceOfDischarge_pcu YY
PleaseStateArrhythmias_pcu YY
PleaseStateArrythmiasY
Post_OperativeStayInDays Y
PostCpbAprotininY
PostCpbIabpY
PostCpbInotropesY
PostCpbPacemakerY
PostCpbVasodilatorsY
PostDischargeDateOfDeathY
PostDischargeDeathInterval_daysY
PostOperativeComplicationsY
PostOperativeStayInDays Y
PostOpStay_daysY
PotassiumDoseInMmolsY
PotassiumDoseInMmols_pcu YY
PotassiumUsedY
PotassiumUsed_pcu YY
Pre_OperativeStayInDays Y
PreBypassY
PreBypassAdverseEventsY
PredominantMethodOfMyocardialProtection Y
PredominantMyocardialPreservationY
PredominantMyocardialPreservation_2Y
PredominantMyocardialProtection Y
PremedicationY
PreOpAnxiety_DepressionY
PreOperativeStayInDays Y
PreOpMobilityY
PreOpPain_DiscomfortY
PreOpSelfCareY
PreopStay_daysY
PreOpUsualActivitiesY
PreviousAnaestheticAdverseEventsY
PreviousEntryY
PrimaryPerfusionistYY (ignored)Y
PrimaryPerfusionist_2Y
ProposedDateOfAdmission Y (ignored)Y
PulmonaryComplicationsYY (ignored)Y
PulmonaryOtherComplicationFreeText YY
Re_Operation Y
ReAdmittedToCicuYYY
ReaonForIabpUse Y
ReasonAuditLoopClosedY
ReasonForIntra_OperativeIntra_AorticBalloonPumpUse Y
RecalibratedParsonnetRiskCabgY
RecordOfWardStayCompletedY
Referral_OpInterval_daysY
ReferralToOperation_days YY
ReferringGpSourceQuestionY
ReferringPurchaserY
RenalComplicationsYYY
RenalOtherComplicationFreeText YY
ReoperationY
RespiratoryY
ScrubNurseY
SctsComplexCabgBayesScore Y
SecondAdmissionTotalStay_nignts YY
SecondAnaesthetistY
SecondAnaesthetistGradeY
SecondaryPerfusionistY
SecondAssistantY
SecondAssistant_sa YY
SecondBypass YY
SecondBypassTotal YY
SecondCardioplegiaInfusion YY
SecondCardioplegiaSolution YY
SecondCardioplegiaTemperature YY
SecondCardioplegiaTiming YY
SecondCiculatoryArrestTotal YY
SecondCrossClampTotal YY
SecondMyocardialProtection YY
SecondNon_CardioplegiaMyocardialProtection YY
SecondPrimaryPerfusionist YY
SecondReadmissionDischargeDateY
SecondReadmissionStay_nightsY
SecondSite_conduit_locationY
SecondSiteCommentsY
SecondSiteComments_sa Y (ignored)Y
SecondSiteCommentsMadeY
SecondSiteCommentsMade_sa YY
SecondSiteConduit_location_sa YY
SeondaryPerfusionist_2Y
SickNoteOffered YY
SonographerYYY
SonographistYYY
StatePharmacistChanges YY
StayOnCicu_nightsY
SternalResuturingY
SternotomyClosureBySaY
SternotomyClosureBySa_sa YY
SternotomyClosureCommentsY
SternotomyClosureComments_sa YY
SternotomyClosureCommentsMadeY
SternotomyClosureCommentsMade_sa YY
SternotomyCommentsY
SternotomyComments_sa YY
SternotomyCommentsMadeY
SternotomyCommentsMade_sa YY
SternotomyPerformedBySaY
SternotomyPerformedBySa_sa YY
SurgicalAssistantY
SurgicalAssistant_sa YY
TeachingOfOtherStaffBySaY
TeachingOfOtherStaffBySa_sa YY
TeachingOfOtherStaffCommentsY
TeachingOfOtherStaffComments_sa YY
TeachingOfOtherStaffCommentsMadeY
TeachingOfOtherStaffCommentsMade_sa YY
TemperatureOnAdmissionY
TemperatureOnAdmission_pcu YY
TemporaryPacingY
TheatreNumberY
ThirdAdmissionToCicuTotalStay_nights YY
ThirdAssistantY
ThirdAssistant_sa YY
ThirdSite_conduit_locationY
ThirdSiteCommentsY
ThirdSiteComments_sa YY
ThirdSiteCommentsMadeY
ThirdSiteCommentsMade_sa YY
ThirdSiteConduit_location_sa YY
TimeOfDischargeY
TimeOfDischarge_pcu YY
ToePerformedYYY
TotalBloodLostOnDischargeFromRecoveryY
TotalBloodLostOnDischargeFromRecovery_pcu YY
TotalCardiacSurgeryLos_daysY
TotalCardiacSurgeryLosDays YY
TotalCirculatoryArrestTime Y
TotalCirculatoryArrestTimeInMin Y
TotalFirstStayOnCicu YY
TotalHospitalStay_daysY
TotalMorphineDoseUsedIncludingBolusY
TotalMorphineDoseUsedIncludingBolus_pcu YY
TotalStayInDays YY
TotalStayOnCicuY
TransferedToTheatreSuiteOnOxygenY
TreatmentOfArrhythmias_pcu YY
TreatmentOfArrythmiaY
TypeOfBypassY
TypeOfColloidUsedY
TypeOfColloidUsed_pcu YY
TypeOfInotropeY
UrgentPriorityCheckedY
VascularAccess_ArterrialY
VascularAccess_CentralY
VascularAccess_VenousY
VasoconstrictorsY
VasodilatorsY
VentilationYYY
WasPatientDischargedFromPcuToHduY
WasPatientDischargedFromPcuToHdu_pcu YY
Weight_kgY
WeightInKg YY
WereClottingProductsUsedY
WereClottingProductsUsed_pcu YY
WereThereAnyArrhythmias_pcu YY
WereThereArrythmiasY
WhatO2SystemWasUsedY
WhatO2SystemWasUsed_pcu YY
WhatProductsWereUsedY
WhatProductsWereUsed_pcu YY
WHO_POSSIBLE_DUPLICATE Y (ignored)
WHO_REGISTRY_INDICATOR Y
Last modified 11 years ago Last modified on 04/11/13 15:27:36
Note: See TracWiki for help on using the wiki.