[[i2b2 - UHL clinical informatics system integration PATS Mappings v1|back]] Start Date Field: !DateOfCardioversion ||Field Name||Column ID||Type||Comments|| ||~~!EntryId~~||1||int||Ignored For Field Name|| ||~~!PatientId~~||2||int||Ignored For Field Name|| ||~~!DateOfCardioversion~~||3||date||Ignored For Datatype|| ||~~!TimeOfCardioversion~~||4||time||Ignored For Datatype|| ||!EntryStatus||5||varchar|||| ||~~!PreviousEntry~~||6||int||Ignored For Field Name|| ||~~!NextEntry~~||7||int||Ignored For Field Name|| ||~~!DateOnWaitingList~~||8||date||Ignored For Datatype|| ||!AgeAtCardioversion||9||int|||| ||~~!BloodPressure~~||10||varchar||Ignored For No Enum|| ||~~Height~~||11||varchar||Ignored For No Enum|| ||Rhythm||12||varchar|||| ||~~!DrugsOnAdmission~~||13||varchar||Ignored For No Enum|| ||~~!DateOfEcho~~||14||date||Ignored For Datatype|| ||Pacemaker||15||varchar|||| ||Weight||16||float|||| ||Inr||17||float|||| ||JoulesDelivered_1||18||int|||| ||~~Rhythm_1~~||19||varchar||Ignored For No Enum|| ||JoulesDelivered_2||20||int|||| ||~~Rhythm_2~~||21||varchar||Ignored For No Enum|| ||JoulesDelivered_3||22||int|||| ||Rhythm_3||23||varchar|||| ||JoulesDelivered_4||24||int|||| ||Rhythm_4||25||varchar|||| ||JoulesDelivered_5||26||int|||| ||Rhythm_5||27||varchar|||| ||JoulesDelivered_6||28||int|||| ||Rhythm_6||29||varchar|||| ||!InternalCardioversion||30||varchar|||| ||!ExternalCardioversion||31||varchar|||| ||!OutcomeSucces||32||varchar|||| ||Death||33||varchar|||| ||!CardioversionCancelled||34||varchar|||| ||~~Reason~~||35||varchar||Ignored For No Enum|| ||~~!DateOfDischarge~~||36||date||Ignored For Datatype|| ||~~!DateOfAdmission~~||37||date||Ignored For Datatype|| ||!RhythmAfterCardioversion||38||varchar|||| ||!AdmissionType||39||varchar|||| ||~~!DateOfFollowUp~~||40||date||Ignored For Datatype|| ||Ap_2||41||varchar|||| ||Ap_3||42||varchar|||| ||Ap_4||43||varchar|||| ||Ap_5||44||varchar|||| ||Ap_6||45||varchar|||| ||Consultant||46||varchar|||| ||!ContractDetails||47||varchar|||| ||Pcg||48||varchar|||| ||~~MedicationOnDischarge1~~||49||varchar||Ignored For No Enum|| ||~~MedicationOnDischarge2~~||50||varchar||Ignored For No Enum|| ||~~MedicationOnDischarge3~~||51||varchar||Ignored For No Enum|| ||~~MedicationOnDischarge4~~||52||varchar||Ignored For No Enum|| ||~~MedicationOnDischarge5~~||53||varchar||Ignored For No Enum|| ||~~MedicationOnDischarge6~~||54||varchar||Ignored For No Enum|| ||~~MedicationOnDischarge7~~||55||varchar||Ignored For No Enum|| ||~~MedicationOnDischarge8~~||56||varchar||Ignored For No Enum|| ||~~MedicationOnDischarge9~~||57||varchar||Ignored For No Enum|| ||!AuditLoopClosed||58||varchar|||| ||~~!DateAuditLoopClosed~~||59||date||Ignored For Datatype|| ||!ReasonAuditLoopClosed||60||varchar|||| ||~~!DateOfDeathPostDischarge~~||61||date||Ignored For Datatype|| ||PostDischargeDeathInterval_days||62||int|||| ||!ReasonForCancellation||63||varchar|||| ||IntervalBetweenProc_LoopClosed_days||64||int|||| ||PreOpStay_days||65||int|||| ||PostOpStay_days||66||int|||| ||TotalLos_days||67||int|||| ||ReferralToOp_days||68||int|||| ||DischargeToFollow_Up_days||69||int|||| ||!EchoPerformed||70||varchar|||| ||ImmeadiateReinitiationOfAf_iraf||71||varchar|||| ||!PacemakerMode||72||varchar|||| ||EcgResultAt1Week||73||varchar|||| ||EcgResultAt1Month||74||varchar|||| ||!ReCardiovert||75||varchar|||| ||!ReasonWhyYesOrNo||76||varchar|||| ||Anaesthetic_sedation||77||varchar|||| ||~~!IfSedationDose~~||78||varchar||Ignored For No Enum|| ||Reversal||79||varchar|||| ||!ComplicationsPreDischarge||80||varchar|||| ||!DoseOfFlumazenil||81||varchar|||| ||!TypeOfDefibUsed||82||varchar|||| ||!DoesPatientRememberShocks||83||varchar|||| ||!WasProcedureUnpleasant||84||varchar|||| ||~~!AnyOtherComments~~||85||varchar||Ignored For No Enum|| ||!BurnMarks||86||varchar|||| ||~~HeartRate_priorToDischarge~~||87||varchar||Ignored For No Enum|| ||Anaesthetist||88||varchar|||| ||!MedicalAssistant||89||varchar|||| ||~~!UnderlyingCardiacDiagnosisForAf~~||90||varchar||Ignored For No Enum|| ||~~!DrugListOnDischarge~~||91||varchar||Ignored For No Enum|| ||!FreeThyroxine||92||float|||| ||!ThyroidStimulatingHormone||93||float|||| ||~~Operator~~||94||varchar||Ignored For No Enum|| ||DoctorReading1WeekEcg||95||varchar|||| ||DoctorReading1MonthEcg||96||varchar|||| ||!PadsOrPaddles||97||varchar|||| ||!IfRevertsToAf||98||varchar|||| ||~~!AnyUntowardsEvents~~||99||varchar||Ignored For No Enum|| ||!DurationOfAf||100||varchar|||| ||FollowUpAt_Hospital||101||varchar|||| ||!TotalDoseOfSedation||102||varchar|||| ||!TotalJulesDelivered||103||float|||| ||!NumberOfPreviousCardioversion||104||varchar|||| ||~~!GpPracticeCode~~||105||varchar||Ignored For No Enum|| ||Pct||106||varchar|||| ||!TotalNumberOfShocks||107||int|||| ||~~!MedicalRecordNumber~~||108||varchar||Ignored For No Enum|| ||!HasPatientHadPreviousCardioversion||109||varchar|||| ||~~!DateOfLastCardioversion~~||110||date||Ignored For Datatype|| ||!IsProcedureForRecuurrenceOfAfOfFailure||111||varchar|||| ||~~MedicationOnDischarge10~~||112||varchar||Ignored For No Enum|| ||~~MedicationOnDischarge11~~||113||varchar||Ignored For No Enum|| ||~~MedicationOnDischarge12~~||114||varchar||Ignored For No Enum|| ||MedicationOnDischarge13||115||varchar|||| ||~~!DateAndTimeOfCardioversion~~||116||varchar||Ignored For No Enum|| ||~~UnderlyingCardiacDiagnosis2~~||117||varchar||Ignored For No Enum|| ||~~UnderlyingCardiacDiagnosis3~~||118||varchar||Ignored For No Enum|| ||~~UnderlyingCardiacDiagnosis4~~||119||varchar||Ignored For No Enum|| ||~~UnderlyingCardiacDiagnosis5~~||120||varchar||Ignored For No Enum|| ||UnderlyingCardiacDiagnosis6||121||varchar|||| ||!ConsultantTitle||122||varchar|||| ||!ConsultantsHospitalBase||123||varchar|||| ||!SickNoteOfferedToPatient||124||varchar|||| ||IfAccepted_DurationInDays||125||int|||| ||!ManagementPlan||126||varchar|||| ||!DoctorSigningLetter||127||varchar|||| ||!TitleOfDoctorSigning||128||varchar|||| ||~~!DateOfCurrentStatus~~||129||date||Ignored For Datatype|| ||~~!DateOfEndStatus~~||130||date||Ignored For Datatype|| ||!DateTimeRecordCreated||131||varchar|||| ||!DateTimeRecordLastChanged||132||varchar|||| ||!EnteredByTag||133||varchar|||| ||!EntryCurrentStatus||134||varchar|||| ||!EntryEndStatus||135||varchar|||| ||!HospitalTag||136||varchar|||| ||!ImportLinkId||137||int||||