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

back

Tables

Table Date Range Start Date Field Records
PACE_PACE1981-2006Dateofimplant_procedure7056
GGHPACEICD_GGHPACEICDINIALVW2006-2012DateOfProcedure_Implant5519
GGHPACEICD_GGHPACEICD2006-2010DateOfProcedure_Implant3981

Columns

Column PACE_PACE GGHPACEICD_GGHPACEICDINIALVW GGHPACEICD_GGHPACEICD
AccessToAdditionalLeadY
AcuteComplicationsY
AcuteComplications_within6wksY
AdapterY
AdapterAditionalLeadY
AdditionalLeadDetailsY
AdditionalLeadPlacedY
AdditionalLeadWherePlacedY
AdditionLeadModelY
AditionalLead5_6mmY
AditionalLeadStabilityChecksAt1vOkY
AdministrativeCategoryY
AetiologyOfDiseaseY
AgeAtPacemakerImplantY
AgeAtProcedure YY
ALeadImpedance_ohmsY
Anti_TachycardiaPacingOn_Ccad YY
AtrialLead_ftY
AtrialLead2ConfirmCorrectConnection YY
AtrialLead2Current_5v_0_5ms YY
AtrialLead2Impedance_ohms YY
AtrialLead2ImplantApproachCcad YY
AtrialLead2ManufacturerCcad YY
AtrialLead2ModelCcad YY
AtrialLead2RWave_mv YY
AtrialLead2SerialNumberCcad YY
AtrialLead2Stability_1v YY
AtrialLead2ThresholdProblems YY
AtrialLead2Twitch_10v YY
AtrialLead5_6mmY
AtrialLeadAccessY
AtrialLeadAdapterY
AtrialLeadBpegCodeY
AtrialLeadConfirmCorrectConnection YY
AtrialLeadCurrent_5v_0_5ms YY
AtrialLeadCurrentAt5v_0_5msY
AtrialLeadDetailsY
AtrialLeadImpedance_ohms YY
AtrialLeadImplantApproachCcad YY
AtrialLeadImplantDateY
AtrialLeadManufacturerY
AtrialLeadManufacturerCcad YY
AtrialLeadModelY
AtrialLeadModelCcad YY
AtrialLeadPWave_mv YY
AtrialLeadRepositionedY
AtrialLeadSerialNumberY
AtrialLeadSerialNumberCcad YY
AtrialLeadStability_1v YY
AtrialLeadStabilityChecksAt1vOkY
AtrialLeadThreshold_0_5ms YY
AtrialLeadThresholdProblemsYYY
AtrialLeadTwitch_10v YY
AtrialLeas2Threshold_0_5ms YY
AtrialThresholdAt0_5msY
AtrialThresholdAt1_0msY
AuditLoopClosedY
AuditTrail YY
AvDelay_paced YY
AvDelay_sensed_Ccad YY
BiventricularDelay_paced YY
BiventricularPacingOn_Ccad YY
BiventricularPacingWhichChamberPacedFirst_Ccad YY
BivFunctionCcad YY
Bmi Y
BpegCodeAditionalLeadY
BradycardiaPacingModeCcad YY
BradycardiaPacingOn_Ccad YY
Ccso YY
ChangesToCurrentMedication Y
ClinicalGuidance Y
ComplicationsY
ComplicationsBeforeDischarge YY
ConfirmPacingAtrialLead YY
ConfirmPacingAtrialLead2 YY
ConfirmPacingVentricularLead YY
ConfirmPacingVentricularLead2 YY
ConnectorAtrialLead YY
ConnectorAtrialLead2 YY
ConnectorVentricularLead YY
ConnectorVentricularLead2 YY
ConsultantResponsibleForProcedureCcad YY
Continue1 Y
Continue10 Y
Continue11 Y
Continue12 Y
Continue13 Y
Continue14 Y
Continue15 Y
Continue16 Y
Continue17 Y
Continue18 Y
Continue2 Y
Continue3 Y
Continue4 Y
Continue5 Y
Continue6 Y
Continue7 Y
Continue8 Y
Continue9 Y
ContractY
CurrentAt5v_0_5msY
CurrentAt5v_0_5msAditionalLeadY
DataTransferredY
DateAndTimeProcedureEnd YY
DateAndTimeProcedureStart YY
DateAtrialLead2ChangedCcad YY
DateAtrialLead2Cut_cappedAndBuried YY
DateAtrialLeadChangedCcad YY
DateAtrialLeadCut_cappedAndBuried YY
DateAtrialLeadRemoved_cappedY
DateAtrialLeadRepositionedY
DateAuditLoopClosedY
DateFormFilledInY
DateGeneratorChangedCcad YY
DateGeneratorExplantedY
DateLeadRepositionedY
DateOfAcuteComplicationY
DateOfAdmissionYYY
DateOfAtrialLead2Implant YY
DateOfAtrialLeadImplant YY
DateOfComplication YY
DateOfComplicationsY
DateOfCurrentStatus Y
DateOfDeathY
DateOfDeathPostDischargeY
DateOfDischargeYYY
DateOfEndStatus Y
DateOfExplant YY
DateOfFileClosureCcad YY
DateOfFirstImplantCcad YY
DateOfFirstPacemakerImplantY
DateOfImplant_procedureY
DateOfImplantOfThisLeadY
DateOfProcedure_Implant YY
DateOfReferalFromOtherHospitalY
DateOfRemovel_repositionY
DateOfRepositionOfUnitY
DateOfTransferYYY
DateOfVentricularLead2Implant YY
DateOfVentricularLeadImplant YY
DateOnWaitingListY
DateTimeRecordCreated Y
DateTimeRecordLastChanged Y
DateVentricularLead2ChangedCcad YY
DateVentricularLead2Cut_cappedAndBuried YY
DateVentricularLeadChangedCcad YY
DateVentricularLeadCut_cappedAndBuried YY
DateVentricularLeadRemoved_cappedY
DaysOnListY
DaysTemporaryPacingWireY
DaysWaitingForTransferY
DeathPostDischargeInterval_daysY
DefbrillatorLeadSiteCcad YY
DermabondY
DeviceFileClosureCcad YY
Df1Y
Df1AditionalLeadY
Df1AtrialLeadY
DischargeDelayedDueToComplication YY
DischargeDelayedDuToComplicationY
DischargeDestination Y
DischargeDrugs_name_dose_frequencyY
DischargedToY
DischargeWard Y
Drug1 Y
Drug10 Y
Drug11 Y
Drug12 Y
Drug13 Y
Drug14 Y
Drug15 Y
Drug16 Y
Drug17 Y
Drug18 Y
Drug2 Y
Drug3 Y
Drug4 Y
Drug5 Y
Drug6 Y
Drug7 Y
Drug8 Y
Drug9 Y
DrugSensitivity Y
DurationOfSickNoteInDays Y
EcgY
EnteredByTag Y
EntryCurrentStatusY Y
EntryEndStatusY Y
EntryIdYYY
EntryStatusYYY
EpsTestedNice YY
ExceededDrl Y
GeneratorDetailsY
GeneratorManufacturerY
GeneratorManufacturerCcad YY
GeneratorModelY
GeneratorModelCcad YY
GeneratorPacingModeCcad YY
GeneratorSerialNumberY
GeneratorSerialNumberCcad YY
GeneratorSiteY
GeneratorSiteOfImplantCcad YY
GlenfieldCardiologistY
GpAtTimeOfProcedure YY
GpPracticeCodeYYY
Grade Y
Height Y
HospitalCodeY
HospitalIdentifierCcad YY
HospitalTag Y
IcdFunctionCcad YY
IcdIndicationCcad YY
IfOtherComplicationPleaseState YY
ImmediateComplicationsY
ImpedanceAditionalLeadY
ImplantedAtWhichHospitalY
InfectionY
IntervalBetweenProc_LoopClosed_daysY
InterventionCcad YY
Is_1Y
Is_1AditionalLeadY
Is_1AtrialLeadY
LeadExtractedCcad YY
Lv1Y
Lv1AditionalLeadY
Lv1AtrialLeadY
Lvef_30_Nice YY
LvFunctionAssessmentCcad YY
LvPortPlugged YY
ManufacturerOfAdditionalLeadY
MedicalRecordNumber YY
MedicalRecordNumberAtTimeOfEntryY
MedicationOnDischarge1Y
MedicationOnDischarge2Y
MedicationOnDischarge3Y
MedicationOnDischarge4Y
MedicationOnDischarge5Y
MedicationOnDischarge6Y
MedicationOnDischarge7Y
MedicationOnDischarge8Y
MedicationOnDischarge9Y
ModelOfAdditionalLeadY
NameOfDischargingDoctor Y
NameOfGp YY
NextEntryYYY
NumberOfDays1 Y
NumberOfDays10 Y
NumberOfDays11 Y
NumberOfDays12 Y
NumberOfDays13 Y
NumberOfDays14 Y
NumberOfDays15 Y
NumberOfDays16 Y
NumberOfDays17 Y
NumberOfDays18 Y
NumberOfDays2 Y
NumberOfDays3 Y
NumberOfDays4 Y
NumberOfDays5 Y
NumberOfDays6 Y
NumberOfDays7 Y
NumberOfDays8 Y
NumberOfDays9 Y
NumberOfDaysDeviceImplantedYYY
NumberOfDaysDischargeDelayed Y
NyhaDyspnoeaStatus_pre_ProcedureStableOnly_Ccad YY
Operator1Y
Operator2Y
OtherComplicationsY
OtherComplications2Y
OtherComplicationSpecifyY
OtherOperators YY
OtherOperatorsOldData YY
PacemakerChecksTransferredYYY
PacingModeY
PacingProcedureComplicationsCcad YY
PacingRate_low_Ccad YY
PagerNumber Y
PatientAdminStatusCcad YY
PatientCareTransferredToY
PatientEthnicGroupCcad YY
PatientGenderCcad YY
PatientIdYYY
PcgY
PctYYY
PolarityOfAdditionalLeadY
PolarityOfAtrialLeadYYY
PolarityOfAtrialLead2 YY
PolarityOfVentricularLeadYYY
PolarityOfVentricularLead2 YY
PostOpStay_daysY
Predevice_ablationQrsDuration_ms_Ccad YY
Predevice_eps_ablationPresentingSymptomCcad YY
PredeviceAetiologyCcad YY
PredeviceEcgCcad YY
PreOpAnxiety_depressionY
PreOpMobilityY
PreOpPain_discomfortY
PreOpSelfCareY
PreopStay_daysY
PreOpUsualActivitiesY
PresentingSymptom_sY
PreviousEntryYYY
PrimaryOperatorCcad YY
PrimaryOperatorCcadOldData YY
PrimaryReplacementAppropriateTherapy Y
ProceduralComplicationY
ProcedureEndTimeY
ProcedureReport YY
ProcedureStartTimeY
ProcedureTime_minsY
ProcedureTypeY
ProcedureUrgency YY
ProphylacticAntibioticsY
PWaveMvY
Radiographer Y
ReasonAuditLoopClosedY
ReasonForAtrialLeadRemoval_cappingY
ReasonForExceedingDrl Y
ReasonForExplant_removal_refirringY
ReasonForFileClosureY
ReasonForRemoval_refitting_repairY
ReasonForRemoval_refitting_repairAditionalLeadY
ReasonForRemoval_refitting_repairAtrialLeadY
ReasonForVentricularLeadRemoval_cappingY
RepositionOfUnitY
RepositionOfVentricularLeadY
Route1 Y
Route10 Y
Route11 Y
Route12 Y
Route13 Y
Route14 Y
Route15 Y
Route16 Y
Route17 Y
Route18 Y
Route2 Y
Route3 Y
Route4 Y
Route5 Y
Route6 Y
Route7 Y
Route8 Y
Route9 Y
RWave_qrsY
ScreeningDose Y
ScreeningTime Y
ScreeningTime_minsY
SerialNumberOfAdditionalLeadY
SickNoteGiven Y
SideUsed YY
StabilityChecksAt1vOkY
StatusY
TechnicianIdY
TemporaryWire YY
TemporaryWireInSituForProcedureY
ThresholdAt0_5msAditionalLeadY
ThresholdAt1_0msAditionalLeadY
ThresholdProblemsY
ThresholdProblemsAditionalLeadY
TimeOfEntryY
TimeOfProcedure_Implant YY
TotalDaysInHospital YY
TotalHospitalStay_dayY
TotalTimeInMinutesY
TotalTimeOfProcedure YY
TransferredTo YY
TypeOfAdmissionY
TypeOfAtrialLead2Procedure YY
TypeOfAtrialLeadProcedure YY
TypeOfComplication YY
TypeOfInterventionY
TypeOfIntervention2Y
TypeOfProcedure YY
TypeOfVentricularLead2Procedure YY
TypeOfVentricularLeadProcedure YY
VentLead_ftY
VentricularLead2ConfirmCorrectConnection YY
VentricularLead2Current_5v_0_5ms YY
VentricularLead2Impedance_ohms YY
VentricularLead2ImplantApproachCcad YY
VentricularLead2ManufacturerCcad YY
VentricularLead2ModelCcad YY
VentricularLead2RWave_mv YY
VentricularLead2SerialNumberCcad YY
VentricularLead2Stability_1v YY
VentricularLead2Threshold_0_5ms YY
VentricularLead2ThresholdProblems YY
VentricularLead2Twitch_10v YY
VentricularLead5_6mmY
VentricularLeadAccessY
VentricularLeadBpegCodeY
VentricularLeadConfirmCorrectConnection YY
VentricularLeadCurrent_5v_0_5ms YY
VentricularLeadDetailsY
VentricularLeadImpedance_ohms YY
VentricularLeadImplantApproachCcad YY
VentricularLeadImplantDateY
VentricularLeadManufacturerY
VentricularLeadManufacturerCcad YY
VentricularLeadModelY
VentricularLeadModelCcad YY
VentricularLeadRWave_mv YY
VentricularLeadSerialNumberY
VentricularLeadSerialNumberCcad YY
VentricularLeadStability_1v YY
VentricularLeadThreshold_0_5ms YY
VentricularLeadThresholdProblems YY
VentricularLeadTwitch_10v YY
VentricularThreshold_v_0_5msY
VfShockTherapyOn_Ccad YY
VLeadImpedance_ohmsY
VLeadThreshold_v_1_0msY
Vs_1Y
Vs_1AditionalLeadY
Vs_1AtrialLeadY
VtShockTherapyOn_Ccad YY
Ward YY
WasInterventionRequiredY
WasInterventionRequired2Y
WaveAditionalLeadY
Weight Y
WhyThisALead2EventuallyExplantedCcad YY
WhyThisALeadEventuallyExplantedCcad YY
WhyThisGeneratorEventuallyExplantedCcad YY
WhyThisVLead2EventuallyExplantedCcad YY
WhyThisVLeadEventuallyExplantedCcad YY
Last modified 10 years ago Last modified on 04/05/13 15:59:27
Note: See TracWiki for help on using the wiki.