Changes between Version 30 and Version 31 of i2b2 Data Import PATS Mapping v1

Timestamp:

03/14/13 11:43:06 (11 years ago)

Author:

Richard Bramley

Comment:

--

i2b2 Data Import PATS Mapping v1

@@ -969 +969 @@
 ||!DateAndTimeOfOperation||41||varchar||||
 ||!NumberOfPreviousHeartOperations||42||int||||
-||!ResponsibleConsultantSurgeon||43||varchar|||| HERE
-||FirstOperator||44||varchar||||
-||FirstAssistant||45||varchar||||
-||FirstAssistantGrade||46||varchar||||
+||!ResponsibleConsultantSurgeon||43||varchar||||
+||!FirstOperator||44||varchar||||
+||!FirstAssistant||45||varchar||||
+||!FirstAssistantGrade||46||varchar||||
 ||FirstAssistant_CalmanYearOfTrainee||47||varchar||||
-||ResponsibleConsultantAnaesthetist||48||varchar||||
-||OperationFindings||49||varchar||||
-||ReferringCardiologist||50||varchar||||
-||DateOfReferral||51||date||||
-||DrugsOnAdmission||52||varchar||||
+||!ResponsibleConsultantAnaesthetist||48||varchar||||
+||!OperationFindings||49||varchar||||
+||!ReferringCardiologist||50||varchar||||
+||~~!DateOfReferral~~||51||date||IGNORED||
+||!DrugsOnAdmission||52||varchar||||
 ||Allergies||53||varchar||||
-||AllOtherAssistants||54||varchar||||
-||WaitingListStatusUpdated||55||varchar||||
-||SprCases||56||varchar||||
-||DateOfCurrentStatus||57||date||||
-||DateOfEndStatus||58||date||||
-||DateTimeRecordCreated||59||varchar||||
-||DateTimeRecordLastChanged||60||varchar||||
-||EnteredByTag||61||varchar||||
-||EntryCurrentStatus||62||varchar||||
-||EntryEndStatus||63||varchar||||
-||HospitalTag||64||varchar||||
+||!AllOtherAssistants||54||varchar||||
+||!WaitingListStatusUpdated||55||varchar||||
+||!SprCases||56||varchar||||
+||~~!DateOfCurrentStatus~~||57||date||IGNORED||
+||~~!DateOfEndStatus~~||58||date||IGNORED||
+||~~!DateTimeRecordCreated~~||59||varchar||IGNORED||
+||!DateTimeRecordLastChanged||60||varchar||||
+||!EnteredByTag||61||varchar||||
+||!EntryCurrentStatus||62||varchar||||
+||!EntryEndStatus||63||varchar||||
+||!HospitalTag||64||varchar||||
 
 === EPS_EPSINIVW
 
 ||Field Name||Column ID||Type||Comments||
-||EntryId||1||int||||
-||PatientId||2||int||||
-||DateOfEntry||3||date||||
-||TimeofEPSRFA||4||time||||
-||EntryStatus||5||varchar||||
-||PreviousEntry||6||int||||
-||NextEntry||7||int||||
-||DateOfAdmission||8||date||||
-||DateOfDischarge||9||date||||
-||DateAddedToWaitingList||10||date||||
-||HospitalIdentifier||11||varchar||||
-||PatientGender||12||varchar||||
-||AgeAtOperation||13||int||||
-||PatientEthnicGroup||14||varchar||||
-||PatientAdminStatus||15||varchar||||
+||~~!EntryId~~||1||int||IGNORED||
+||~~!PatientId~~||2||int||IGNORED||
+||~~!DateOfEntry~~||3||date||IGNORED||
+||~~!TimeofEPSRFA~~||4||time||IGNORED||
+||!EntryStatus||5||varchar||||
+||~~!PreviousEntry~~||6||int||||
+||~~!NextEntry~~||7||int||IGNORED||
+||~~!DateOfAdmission~~||8||date||IGNORED||
+||~~!DateOfDischarge~~||9||date||IGNORED||
+||~~!DateAddedToWaitingList~~||10||date||IGNORED||
+||!HospitalIdentifier||11||varchar||||
+||!PatientGender||12||varchar||||
+||!AgeAtOperation||13||int||||
+||!PatientEthnicGroup||14||varchar||||
+||!PatientAdminStatus||15||varchar||||
 ||IsThisARe_Do||16||varchar||||
 ||Preeps_ablationAetiology2||17||varchar||||
 ||Preeps_ablationEcg||18||varchar||||
 ||Prepacing_eps_ablationPresentingSymptom||19||varchar||||
-||GeneratorPacingMode||20||varchar||||
+||!GeneratorPacingMode||20||varchar||||
 ||Preeps_ablationPreviousIntervention||21||varchar||||
 ||Preeps_ablationArrhythmia||22||varchar||||
 ||Eps_ablationIndicationForIntervention||23||varchar||||
-||Preicd_ablationQrsDuration||24||int||||
+||!Preicd_ablationQrsDuration||24||int||||
 ||Date_timeOfProcedure||25||varchar||||
-||ProcedureUrgency||26||varchar||||
-||OperativeUrgency||27||varchar||||
-||PrimaryOperator||28||varchar||||
-||FirstOperatorStatus||29||varchar||||
-||SecondOperator||30||varchar||||
-||SecondOperatorStatus||31||varchar||||
-||ThirdOperator||32||varchar||||
-||ThirdOperatorStatus||33||varchar||||
+||!ProcedureUrgency||26||varchar||||
+||!OperativeUrgency||27||varchar||||
+||!PrimaryOperator||28||varchar||||
+||!FirstOperatorStatus||29||varchar||||
+||!SecondOperator||30||varchar||||
+||!SecondOperatorStatus||31||varchar||||
+||!ThirdOperator||32||varchar||||
+||!ThirdOperatorStatus||33||varchar||||
 ||Ccso||34||varchar||||
 ||AblationProcedure_s||35||varchar||||
-||AccessoryPathway||36||varchar||||
-||NumberOfElectrodeCatheters||37||int||||
-||MappingTechnique||38||varchar||||
-||TransseptalApproach||39||varchar||||
+||!AccessoryPathway||36||varchar||||
+||!NumberOfElectrodeCatheters||37||int||||
+||!MappingTechnique||38||varchar||||
+||!TransseptalApproach||39||varchar||||
 ||Anticoagulation||40||varchar||||
 ||HeparinDose_iu||41||int||||
-||TotalFluoroscopyTime||42||float||||
-||ProcedureStartTime||43||varchar||||
-||ProcedureEndTime||44||varchar||||
-||ProcedureDuration||45||int||||
-||AblationAttempted||46||varchar||||
-||WaitingTime||47||int||||
-||WhyAblationNotAttempted||48||varchar||||
-||NumberOfEnergyApplications||49||int||||
-||TotalTimeOfEnergyApplication||50||int||||
-||AblationEnergySource||51||varchar||||
+||!TotalFluoroscopyTime||42||float||||
+||!ProcedureStartTime||43||varchar||||
+||!ProcedureEndTime||44||varchar||||
+||!ProcedureDuration||45||int||||
+||!AblationAttempted||46||varchar||||
+||!WaitingTime||47||int||||
+||!WhyAblationNotAttempted||48||varchar||||
+||!NumberOfEnergyApplications||49||int||||
+||!TotalTimeOfEnergyApplication||50||int||||
+||!AblationEnergySource||51||varchar||||
 ||Catheter||52||varchar||||
-||CatheterReach||53||varchar||||
+||!CatheterReach||53||varchar||||
 ||Ga||54||varchar||||
-||WhichPulmonaryVeinsAblated||55||varchar||||
+||!WhichPulmonaryVeinsAblated||55||varchar||||
 ||Success||56||varchar||||
-||TransientHeartBlock||57||varchar||||
-||AblationComplications||58||varchar||||
-||AvBlock||59||varchar||||
-||DeviceImplanted||60||varchar||||
+||!TransientHeartBlock||57||varchar||||
+||!AblationComplications||58||varchar||||
+||!AvBlock||59||varchar||||
+||!DeviceImplanted||60||varchar||||
 ||IntraopDrugs2||61||varchar||||
 ||ProcedureReport_comment||62||varchar||||
 ||Early_24hrs_Recurrence||63||varchar||||
 ||ChestDrain||64||varchar||||
-||PericardialTap||65||varchar||||
-||ArterialRepair||66||varchar||||
-||DeathOnSameAdmission||67||varchar||||
-||LateRecurrenceOfArrhythmia||68||varchar||||
+||!PericardialTap||65||varchar||||
+||!ArterialRepair||66||varchar||||
+||!DeathOnSameAdmission||67||varchar||||
+||!LateRecurrenceOfArrhythmia||68||varchar||||
 ||TimeToRecurrence_months||69||int||||
 ||DateLastFollow_Up||70||date||||
-||PreOpStay||71||int||||
-||PostOpStay||72||int||||
-||TotalHospitalStay||73||int||||
-||TotalTimeOnWaitingList||74||int||||
-||ReferringGpOrDentist||75||varchar||||
-||NameOfReferringGpOrDentist||76||varchar||||
-||GpPracticeCode||77||varchar||||
+||!PreOpStay||71||int||||
+||!PostOpStay||72||int||||
+||!TotalHospitalStay||73||int||||
+||!TotalTimeOnWaitingList||74||int||||
+||!ReferringGpOrDentist||75||varchar||||
+||!NameOfReferringGpOrDentist||76||varchar||||
+||!GpPracticeCode||77||varchar||||
 ||Pct||78||varchar||||
-||MedicalRecordNumberAtTimeOfEntry||79||varchar||||
-||AuditTrail||80||varchar||||
-||CatheterCcad||81||varchar||||
-||CatheterReachCcad||82||varchar||||
-||AfAblationStrategies||83||varchar||||
+||!MedicalRecordNumberAtTimeOfEntry||79||varchar||||
+||!AuditTrail||80||varchar||||
+||!CatheterCcad||81||varchar||||
+||!CatheterReachCcad||82||varchar||||
+||!AfAblationStrategies||83||varchar||||
 ||Score||84||int||||
 ||Tvac_pvac||85||varchar||||
@@ -1083 +1083 @@
 ||Weight||87||float||||
 ||Bmi||88||float||||
-||ScreeningDose||89||float||||
-||ExceededDrl||90||varchar||||
+||!ScreeningDose||89||float||||
+||!ExceededDrl||90||varchar||||
 ||Radiographer||91||varchar||||
-||ReasonForExceedingDrl||92||varchar||||
-||DateOfCurrentStatus||93||date||||
-||DateOfEndStatus||94||date||||
-||DateTimeRecordCreated||95||varchar||||
-||DateTimeRecordLastChanged||96||varchar||||
-||EnteredByTag||97||varchar||||
-||EntryCurrentStatus||98||varchar||||
-||EntryEndStatus||99||varchar||||
-||HospitalTag||100||varchar||||
-||ImportLinkId||101||int||||
+||!ReasonForExceedingDrl||92||varchar||||
+||~~!DateOfCurrentStatus~~||93||date||IGNORED||
+||~~!DateOfEndStatus~~||94||date||IGNORED||
+||!DateTimeRecordCreated||95||varchar||||
+||!DateTimeRecordLastChanged||96||varchar||||
+||!EnteredByTag||97||varchar||||
+||!EntryCurrentStatus||98||varchar||||
+||!EntryEndStatus||99||varchar||||
+||!HospitalTag||100||varchar||||
+||!ImportLinkId||101||int||||
 
 === GGHMINAP_GGHMINAP