Changes between Version 13 and Version 14 of i2b2 Data Import PATS Mapping v1


Ignore:
Timestamp:
03/14/13 09:45:56 (12 years ago)
Author:
Richard Bramley
Comment:

--

Legend:

Unmodified
Added
Removed
Modified
  • i2b2 Data Import PATS Mapping v1

    v13 v14  
    896896
    897897=== CS2010F_PreProcedure
     898
     899||Field Name||Column ID||Type||Comments||
     900||EntryId||1||int||||
     901||PatientId||2||int||||
     902||DateOfOperation||3||date||||
     903||TimeOfEntry||4||time||||
     904||EntryStatus||5||varchar||||
     905||PreviousEntry||6||int||||
     906||NextEntry||7||int||||
     907||AgeAtOperation||8||int||||
     908||Gender||9||varchar||||
     909||DateOfAdmission||10||date||||
     910||AnginaStatusPre_Surgery||11||varchar||||
     911||DyspnoeaStatusPre_Surgery||12||varchar||||
     912||NumberOfPreviousMis||13||varchar||||
     913||IntervalBetweenSurgeryAndLastMi||14||varchar||||
     914||PreviousPci||15||varchar||||
     915||PreviousCardiacSurgery||16||varchar||||
     916||DateOfLastCardiacOperation||17||date||||
     917||DiabetesManagement||18||varchar||||
     918||HistoryOfHypertension||19||varchar||||
     919||CigaretteSmokingHistory||20||varchar||||
     920||HistoryOfPulmonaryDisease||21||varchar||||
     921||HistoryOfNeurologicalDisease||22||varchar||||
     922||Pre_OperativeHeartRhythm||23||varchar||||
     923||DateOfLastCatheterisation||24||date||||
     924||PaSystolic||25||int||||
     925||IntravenousNitratesOrAnyHeparin||26||varchar||||
     926||IntravenousInotropesPriorToAnaesthesia||27||varchar||||
     927||VentilatedPreOperation||28||varchar||||
     928||CardiogenicShock_pre_Operation||29||varchar||||
     929||OperativeUrgency||30||varchar||||
     930||FirstOperatorGrade||31||varchar||||
     931||FirstOperator_CalmanYearOfTrainee||32||varchar||||
     932||CardiacProcedures||33||varchar||||
     933||OtherCardiacProcedures||34||varchar||||
     934||OtherThoracicAndVascularProcedures||35||varchar||||
     935||LeftMainStemDisease||36||varchar||||
     936||ExtentOfCoronaryVesselDisease||37||varchar||||
     937||ExtracardiacArteriopathy||38||varchar||||
     938||EjectionFractionCategory||39||varchar||||
     939||AdministrativeCategory||40||varchar||||
     940||DateAndTimeOfOperation||41||varchar||||
     941||NumberOfPreviousHeartOperations||42||int||||
     942||ResponsibleConsultantSurgeon||43||varchar||||
     943||FirstOperator||44||varchar||||
     944||FirstAssistant||45||varchar||||
     945||FirstAssistantGrade||46||varchar||||
     946||FirstAssistant_CalmanYearOfTrainee||47||varchar||||
     947||ResponsibleConsultantAnaesthetist||48||varchar||||
     948||OperationFindings||49||varchar||||
     949||ReferringCardiologist||50||varchar||||
     950||DateOfReferral||51||date||||
     951||DrugsOnAdmission||52||varchar||||
     952||Allergies||53||varchar||||
     953||AllOtherAssistants||54||varchar||||
     954||WaitingListStatusUpdated||55||varchar||||
     955||SprCases||56||varchar||||
     956||DateOfCurrentStatus||57||date||||
     957||DateOfEndStatus||58||date||||
     958||DateTimeRecordCreated||59||varchar||||
     959||DateTimeRecordLastChanged||60||varchar||||
     960||EnteredByTag||61||varchar||||
     961||EntryCurrentStatus||62||varchar||||
     962||EntryEndStatus||63||varchar||||
     963||HospitalTag||64||varchar||||
     964
    898965=== EPS_EPSINIVW
    899966=== GGHMINAP_GGHMINAP