Changes between Version 23 and Version 24 of i2b2 Data Import PATS Mapping v1


Ignore:
Timestamp:
03/14/13 09:58:47 (11 years ago)
Author:
Richard Bramley
Comment:

--

Legend:

Unmodified
Added
Removed
Modified
  • i2b2 Data Import PATS Mapping v1

    v23 v24  
    24632463
    24642464=== VERTED_VERTEDINIALVW
     2465
     2466||Field Name||Column ID||Type||Comments||
     2467||EntryId||1||int||||
     2468||PatientId||2||int||||
     2469||DateOfCardioversion||3||date||||
     2470||TimeOfCardioversion||4||time||||
     2471||EntryStatus||5||varchar||||
     2472||PreviousEntry||6||int||||
     2473||NextEntry||7||int||||
     2474||DateOnWaitingList||8||date||||
     2475||AgeAtCardioversion||9||int||||
     2476||BloodPressure||10||varchar||||
     2477||Height||11||varchar||||
     2478||Rhythm||12||varchar||||
     2479||DrugsOnAdmission||13||varchar||||
     2480||DateOfEcho||14||date||||
     2481||Pacemaker||15||varchar||||
     2482||Weight||16||float||||
     2483||Inr||17||float||||
     2484||JoulesDelivered_1||18||int||||
     2485||Rhythm_1||19||varchar||||
     2486||JoulesDelivered_2||20||int||||
     2487||Rhythm_2||21||varchar||||
     2488||JoulesDelivered_3||22||int||||
     2489||Rhythm_3||23||varchar||||
     2490||JoulesDelivered_4||24||int||||
     2491||Rhythm_4||25||varchar||||
     2492||JoulesDelivered_5||26||int||||
     2493||Rhythm_5||27||varchar||||
     2494||JoulesDelivered_6||28||int||||
     2495||Rhythm_6||29||varchar||||
     2496||InternalCardioversion||30||varchar||||
     2497||ExternalCardioversion||31||varchar||||
     2498||OutcomeSucces||32||varchar||||
     2499||Death||33||varchar||||
     2500||CardioversionCancelled||34||varchar||||
     2501||Reason||35||varchar||||
     2502||DateOfDischarge||36||date||||
     2503||DateOfAdmission||37||date||||
     2504||RhythmAfterCardioversion||38||varchar||||
     2505||AdmissionType||39||varchar||||
     2506||DateOfFollowUp||40||date||||
     2507||Ap_2||41||varchar||||
     2508||Ap_3||42||varchar||||
     2509||Ap_4||43||varchar||||
     2510||Ap_5||44||varchar||||
     2511||Ap_6||45||varchar||||
     2512||Consultant||46||varchar||||
     2513||ContractDetails||47||varchar||||
     2514||Pcg||48||varchar||||
     2515||MedicationOnDischarge1||49||varchar||||
     2516||MedicationOnDischarge2||50||varchar||||
     2517||MedicationOnDischarge3||51||varchar||||
     2518||MedicationOnDischarge4||52||varchar||||
     2519||MedicationOnDischarge5||53||varchar||||
     2520||MedicationOnDischarge6||54||varchar||||
     2521||MedicationOnDischarge7||55||varchar||||
     2522||MedicationOnDischarge8||56||varchar||||
     2523||MedicationOnDischarge9||57||varchar||||
     2524||AuditLoopClosed||58||varchar||||
     2525||DateAuditLoopClosed||59||date||||
     2526||ReasonAuditLoopClosed||60||varchar||||
     2527||DateOfDeathPostDischarge||61||date||||
     2528||PostDischargeDeathInterval_days||62||int||||
     2529||ReasonForCancellation||63||varchar||||
     2530||IntervalBetweenProc_LoopClosed_days||64||int||||
     2531||PreOpStay_days||65||int||||
     2532||PostOpStay_days||66||int||||
     2533||TotalLos_days||67||int||||
     2534||ReferralToOp_days||68||int||||
     2535||DischargeToFollow_Up_days||69||int||||
     2536||EchoPerformed||70||varchar||||
     2537||ImmeadiateReinitiationOfAf_iraf||71||varchar||||
     2538||PacemakerMode||72||varchar||||
     2539||EcgResultAt1Week||73||varchar||||
     2540||EcgResultAt1Month||74||varchar||||
     2541||ReCardiovert||75||varchar||||
     2542||ReasonWhyYesOrNo||76||varchar||||
     2543||Anaesthetic_sedation||77||varchar||||
     2544||IfSedationDose||78||varchar||||
     2545||Reversal||79||varchar||||
     2546||ComplicationsPreDischarge||80||varchar||||
     2547||DoseOfFlumazenil||81||varchar||||
     2548||TypeOfDefibUsed||82||varchar||||
     2549||DoesPatientRememberShocks||83||varchar||||
     2550||WasProcedureUnpleasant||84||varchar||||
     2551||AnyOtherComments||85||varchar||||
     2552||BurnMarks||86||varchar||||
     2553||HeartRate_priorToDischarge||87||varchar||||
     2554||Anaesthetist||88||varchar||||
     2555||MedicalAssistant||89||varchar||||
     2556||UnderlyingCardiacDiagnosisForAf||90||varchar||||
     2557||DrugListOnDischarge||91||varchar||||
     2558||FreeThyroxine||92||float||||
     2559||ThyroidStimulatingHormone||93||float||||
     2560||Operator||94||varchar||||
     2561||DoctorReading1WeekEcg||95||varchar||||
     2562||DoctorReading1MonthEcg||96||varchar||||
     2563||PadsOrPaddles||97||varchar||||
     2564||IfRevertsToAf||98||varchar||||
     2565||AnyUntowardsEvents||99||varchar||||
     2566||DurationOfAf||100||varchar||||
     2567||FollowUpAt_Hospital||101||varchar||||
     2568||TotalDoseOfSedation||102||varchar||||
     2569||TotalJulesDelivered||103||float||||
     2570||NumberOfPreviousCardioversion||104||varchar||||
     2571||GpPracticeCode||105||varchar||||
     2572||Pct||106||varchar||||
     2573||TotalNumberOfShocks||107||int||||
     2574||MedicalRecordNumber||108||varchar||||
     2575||HasPatientHadPreviousCardioversion||109||varchar||||
     2576||DateOfLastCardioversion||110||date||||
     2577||IsProcedureForRecuurrenceOfAfOfFailure||111||varchar||||
     2578||MedicationOnDischarge10||112||varchar||||
     2579||MedicationOnDischarge11||113||varchar||||
     2580||MedicationOnDischarge12||114||varchar||||
     2581||MedicationOnDischarge13||115||varchar||||
     2582||DateAndTimeOfCardioversion||116||varchar||||
     2583||UnderlyingCardiacDiagnosis2||117||varchar||||
     2584||UnderlyingCardiacDiagnosis3||118||varchar||||
     2585||UnderlyingCardiacDiagnosis4||119||varchar||||
     2586||UnderlyingCardiacDiagnosis5||120||varchar||||
     2587||UnderlyingCardiacDiagnosis6||121||varchar||||
     2588||ConsultantTitle||122||varchar||||
     2589||ConsultantsHospitalBase||123||varchar||||
     2590||SickNoteOfferedToPatient||124||varchar||||
     2591||IfAccepted_DurationInDays||125||int||||
     2592||ManagementPlan||126||varchar||||
     2593||DoctorSigningLetter||127||varchar||||
     2594||TitleOfDoctorSigning||128||varchar||||
     2595||DateOfCurrentStatus||129||date||||
     2596||DateOfEndStatus||130||date||||
     2597||DateTimeRecordCreated||131||varchar||||
     2598||DateTimeRecordLastChanged||132||varchar||||
     2599||EnteredByTag||133||varchar||||
     2600||EntryCurrentStatus||134||varchar||||
     2601||EntryEndStatus||135||varchar||||
     2602||HospitalTag||136||varchar||||
     2603||ImportLinkId||137||int||||