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

back

Tables

Table Date Range Start Date Field Records
VERTED_VERTED1999-2010DateOfCardioversion3760
VERTED_VERTEDINIALVW1901(sic - 1999 appears to be the first sensible date)-2011DateOfCardioversion3754

Columns

Column VERTED_VERTED VERTED_VERTEDINIALVW
AdmissionTypeYY
AgeAtCardioversionYY
AlanineTransaminase_altY
AlbuminY
AlkalinePhosphataseY
Anaesthetic_sedationYY
AnaesthetistYY
AnyOtherCommentsYY
AnyUntowardsEventsYY
Ap_2YY
Ap_3YY
Ap_4YY
Ap_5YY
Ap_6YY
AuditLoopClosedYY
BloodPressureYY
BurnMarksYY
CardioversionCancelledYY
CardioversionNotDoneY
ComplicationsPreDischargeYY
ConsultantYY
ConsultantsHospitalBase Y
ConsultantTitle Y
ContractDetailsYY
CreatinineY
DateAndTimeOfCardioversionYY
DateAuditLoopClosedYY
DateFormCompletedY
DateOfAdmissionYY
DateOfCardioversionYY
DateOfCurrentStatusYY
DateOfDeathPostDischargeYY
DateOfDischargeYY
DateOfEchoYY
DateOfEndStatusYY
DateOfFollowUpYY
DateOfLastCardioversionYY
DateOnWaitingListYY
DateTimeRecordCreatedYY
DateTimeRecordLastChangedYY
DeathYY
DischargeToFollow_Up_daysYY
DoctorCheckY
DoctorReading1MonthEcgYY
DoctorReading1WeekEcgYY
DoctorSigningLetter Y
DoesPatientRememberShocksYY
DoseOfFlumazenilYY
DrugListOnAdmissionY
DrugListOnDischargeYY
DrugsOnAdmissionYY
DurationOfAfYY
EcgResultAt1MonthYY
EcgResultAt1WeekYY
EchoPerformedYY
EnteredByTagYY
EntryCurrentStatusYY
EntryEndStatusYY
EntryIdYY
EntryStatusYY
ExternalCardioversionYY
FollowUpAt_HospitalYY
FreeThyroxineYY
GlucoseY
GpPracticeCodeYY
HasPatientHadPreviousCardioversionYY
HeartRate_priorToDischargeYY
HeightYY
HospitalTagYY
IfAccepted_DurationInDays Y
IfRevertsToAfYY
IfSedationDoseYY
ImmeadiateReinitiationOfAf_irafYY
ImportLinkId Y
InrYY
InternalCardioversionYY
IntervalBetweenProc_LoopClosed_daysYY
IsProcedureForRecuurrenceOfAfOfFailureYY
JoulesDelivered_1YY
JoulesDelivered_2YY
JoulesDelivered_3YY
JoulesDelivered_4YY
JoulesDelivered_5YY
JoulesDelivered_6YY
LeftAtriumSizeY
LvFunctionY
ManagementPlan Y
MedicalAssistantYY
MedicalRecordNumberYY
MedicationOnDischarge1YY
MedicationOnDischarge10YY
MedicationOnDischarge11YY
MedicationOnDischarge12YY
MedicationOnDischarge13YY
MedicationOnDischarge2YY
MedicationOnDischarge3YY
MedicationOnDischarge4YY
MedicationOnDischarge5YY
MedicationOnDischarge6YY
MedicationOnDischarge7YY
MedicationOnDischarge8YY
MedicationOnDischarge9YY
MitralRegurgitationY
MitralRegurgitationGradeY
MitralStenosisY
NextEntryYY
NumberOfPreviousCardioversionYY
OperatorYY
OutcomeSuccesYY
PacemakerYY
PacemakerModeYY
PadsOrPaddlesYY
PatientIdYY
PcBloodPressure_1Y
PcBloodPressure_2Y
PcBloodPressure_3Y
PcgYY
PcPulse_1Y
PcPulse_2Y
PcPulse_3Y
PcRhythm_1Y
PcRhythm_2Y
PcRhythm_3Y
PctYY
PcTime_1Y
PcTime_2Y
PcTime_3Y
PostDischargeDeathInterval_daysYY
PostOpStay_daysYY
PotassiumY
PreOpAnxiety_DepressionY
PreOpMobilityY
PreOpPain_DiscomfortY
PreOpSelfCareY
PreOpStay_daysYY
PreOpUsualActivitiesY
PreviousEntryYY
PulseY
ReasonYY
ReasonAuditLoopClosedYY
ReasonForCancellationYY
ReasonWhyYesOrNoYY
ReCardiovertYY
ReferralToOp_daysYY
ReversalYY
RhythmYY
Rhythm_1YY
Rhythm_2YY
Rhythm_3YY
Rhythm_4YY
Rhythm_5YY
Rhythm_6YY
RhythmAfterCardioversionYY
SickNoteOfferedToPatient Y
SodiumY
ThyroidStimulatingHormoneYY
Time_1Y
Time_2Y
Time_3Y
Time_4Y
Time_5Y
Time_6Y
TimeOfCardioversionYY
TitleOfDoctorSigning Y
TotalBilirubinY
TotalDoseOfSedationYY
TotalJulesDeliveredYY
TotalLos_daysYY
TotalNumberOfShocksYY
TriscupidRegurgitationY
TriscupidRegurgitationGradeY
TypeOfDefibUsedYY
UnderlyingCardiacDiagnosis2 Y
UnderlyingCardiacDiagnosis3 Y
UnderlyingCardiacDiagnosis4 Y
UnderlyingCardiacDiagnosis5 Y
UnderlyingCardiacDiagnosis6 Y
UnderlyingCardiacDiagnosisForAfYY
UreaY
WasProcedureUnpleasantYY
WeightYY
Last modified 11 years ago Last modified on 04/08/13 08:33:56
Note: See TracWiki for help on using the wiki.