Changes between Version 27 and Version 28 of i2b2 Data Import PATS Mapping v1
- Timestamp:
- 03/14/13 11:05:43 (12 years ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
i2b2 Data Import PATS Mapping v1
v27 v28 516 516 ||!StatePharmacistChanges||299||varchar|||| 517 517 ||!InformationGivenToPatient||300||varchar|||| 518 ||~~!DateTimeRecordCreated~~||301||datetime||IGNORED|| HERE!!519 || DateTimeRecordLastChanged||302||datetime||||520 || EnteredByTag||303||varchar||||521 || HospitalTag||304||varchar||||518 ||~~!DateTimeRecordCreated~~||301||datetime||IGNORED|| 519 ||~~!DateTimeRecordLastChanged~~||302||datetime|||| 520 ||!EnteredByTag||303||varchar|||| 521 ||!HospitalTag||304||varchar|||| 522 522 ||WHO_REGISTRY_INDICATOR||305||varchar|||| 523 || WHO_POSSIBLE_DUPLICATE||306||char||||523 ||~~WHO_POSSIBLE_DUPLICATE~~||306||char||IGNORED|| 524 524 525 525 === CS2003F_PreProcedure 526 526 527 527 ||Field Name||Column ID||Type||Comments|| 528 || EntryId||1||int||||529 || PatientId||2||int||||530 || DateOfOperation_ccad||3||datetime||||531 || TimeOfOperation_ccad||4||datetime||||532 || EntryStatus||5||varchar||||533 || PreviousEntry||6||int||||534 || NextEntry||7||int||||535 || AgeAtSurgery||8||int||||528 ||~~!EntryId~~||1||int||IGNORED|| 529 ||~~!PatientId~~||2||int||IGNORED|| 530 ||~~DateOfOperation_ccad~~||3||datetime||IGNORED|| 531 ||~~TimeOfOperation_ccad~~||4||datetime||IGNORED|| 532 ||!EntryStatus||5||varchar|||| 533 ||~~!PreviousEntry~~||6||int||IGNORED|| 534 ||~~!NextEntry~~||7||int||IGNORED|| 535 ||!AgeAtSurgery||8||int|||| 536 536 ||Gender||9||varchar|||| 537 || DateOfAdmission||10||datetime||||537 ||~~!DateOfAdmission~~||10||datetime||IGNORED|| 538 538 ||AnginaStatusPre_Surgery||11||varchar|||| 539 539 ||DyspnoeaStatusPre_Surgery||12||varchar|||| 540 || NumberOfPreviousMis||13||varchar||||541 || IntervalBetweenOperationAndLastMi||14||varchar||||542 || PreviousPci||15||varchar||||543 || DateOfLastPci||16||datetime||||540 ||!NumberOfPreviousMis||13||varchar|||| 541 ||!IntervalBetweenOperationAndLastMi||14||varchar|||| 542 ||!PreviousPci||15||varchar|||| 543 ||~~!DateOfLastPci~||16||datetime||IGNORED|| 544 544 ||PreviousCardiac_VascularOrThoracicSurgicalInterven||17||varchar|||| 545 || DateOfLastCardiacOperation||18||datetime||||546 || DiabetesManagement||19||varchar||||545 ||~~!DateOfLastCardiacOperation~~||18||datetime||IGNORED|| 546 ||!DiabetesManagement||19||varchar|||| 547 547 ||Hypertension||20||varchar|||| 548 || CigaretteSmokingHistory||21||varchar||||549 || RenalDiseaseAtTheTimeOfSurgery||22||varchar||||550 || HistoryOfPulmonaryDisease||23||varchar||||551 || HistoryOfNeurologicalDisease||24||varchar||||548 ||!CigaretteSmokingHistory||21||varchar|||| 549 ||!RenalDiseaseAtTheTimeOfSurgery||22||varchar|||| 550 ||!HistoryOfPulmonaryDisease||23||varchar|||| 551 ||!HistoryOfNeurologicalDisease||24||varchar|||| 552 552 ||Pre_OperativeHeartRhythm||25||varchar|||| 553 || DateOfCatheterisation||26||datetime||||553 ||~~!DateOfCatheterisation~~||26||datetime||IGNORED|| 554 554 ||PaSystolic_ifKnown||27||int|||| 555 555 ||AvGradient_ifKnown||28||int|||| … … 557 557 ||MeanPawp_la_ifKnown||30||int|||| 558 558 ||IvNitrates_HeparinOfAnyKind||31||varchar|||| 559 || IvInotropesPriorToAnaesthesia||32||varchar||||559 ||!IvInotropesPriorToAnaesthesia||32||varchar|||| 560 560 ||Ventilated||33||varchar|||| 561 || CardiogenicShock||34||varchar||||562 || OperativePriority||35||varchar||||563 || FirstOperatorGrade||36||varchar||||561 ||!CardiogenicShock||34||varchar|||| 562 ||!OperativePriority||35||varchar|||| 563 ||!FirstOperatorGrade||36||varchar|||| 564 564 ||FirstOperator_CalmanYearOfTrainee||37||varchar|||| 565 || CardiacProcedures||38||varchar||||566 || NumberOfDistalCoronaryAnastomoses||39||int||||565 ||!CardiacProcedures||38||varchar|||| 566 ||!NumberOfDistalCoronaryAnastomoses||39||int|||| 567 567 ||NumberOfValvesReplaced_Repaired||40||int|||| 568 || NumberOfSegmentsOfTheAorta||41||int||||569 || OtherCardiacProcedures||42||varchar||||570 || OtherThoracicAndVascularProcedures||43||varchar||||568 ||!NumberOfSegmentsOfTheAorta||41||int|||| 569 ||!OtherCardiacProcedures||42||varchar|||| 570 ||!OtherThoracicAndVascularProcedures||43||varchar|||| 571 571 ||NeurologicalDysfunction_euroscore||44||varchar|||| 572 || LeftMainStemDisease||45||varchar||||573 || ExtentOfCoronaryArteryDisease||46||varchar||||574 || ExtracardiacArteriopathy||47||varchar||||575 || EjectionFractionCategory||48||varchar||||576 || AdmissionCategory||49||varchar||||577 || CarotidBruits||50||varchar||||578 || LeftOrRightHeartCatheterisation||51||varchar||||572 ||!LeftMainStemDisease||45||varchar|||| 573 ||!ExtentOfCoronaryArteryDisease||46||varchar|||| 574 ||!ExtracardiacArteriopathy||47||varchar|||| 575 ||!EjectionFractionCategory||48||varchar|||| 576 ||!AdmissionCategory||49||varchar|||| 577 ||!CarotidBruits||50||varchar|||| 578 ||!LeftOrRightHeartCatheterisation||51||varchar|||| 579 579 ||EjectionFractionValue_ifKnown||52||int|||| 580 || DateAndTimeOfOperation||53||varchar||||581 || NumberOfPreviousHeartOperations||54||int||||582 || ResponsibleConsultantSurgeon||55||varchar||||583 || FirstOperator||56||varchar||||584 || FirstAssistant||57||varchar||||585 || FirstAssistantGrade||58||varchar||||580 ||!DateAndTimeOfOperation||53||varchar|||| 581 ||!NumberOfPreviousHeartOperations||54||int|||| 582 ||!ResponsibleConsultantSurgeon||55||varchar|||| 583 ||!FirstOperator||56||varchar|||| 584 ||!FirstAssistant||57||varchar|||| 585 ||!FirstAssistantGrade||58||varchar|||| 586 586 ||FirstAssistant_CalmanYearOfTrainee||59||varchar|||| 587 || ResponsibleConsultantAnaesthetist||60||varchar||||588 || OperationFindings||61||varchar||||589 || ReferringCardiologist||62||varchar||||590 || DateOfReferral||63||datetime||||591 || DrugsOnAdmission||64||varchar||||587 ||!ResponsibleConsultantAnaesthetist||60||varchar|||| 588 ||!OperationFindings||61||varchar|||| 589 ||!ReferringCardiologist||62||varchar|||| 590 ||~~!DateOfReferral~~||63||datetime||IGNORED|| 591 ||!DrugsOnAdmission||64||varchar|||| 592 592 ||Allergies||65||varchar|||| 593 || AllOtherAssistants||66||varchar||||594 || WaitingListStatusUpdated||67||varchar||||595 || SprCases||68||varchar||||596 || DateOfCurrentStatus||69||datetime||||597 || DateOfEndStatus||70||datetime||||598 || DateTimeRecordCreated||71||datetime||||599 || DateTimeRecordLastChanged||72||datetime||||600 || EnteredByTag||73||varchar||||601 || EntryCurrentStatus||74||varchar||||602 || EntryEndStatus||75||varchar||||603 || HospitalTag||76||varchar||||593 ||!AllOtherAssistants||66||varchar|||| 594 ||!WaitingListStatusUpdated||67||varchar|||| 595 ||!SprCases||68||varchar|||| 596 ||~~!DateOfCurrentStatus~~||69||datetime||IGNORED|| 597 ||~~!DateOfEndStatus~~||70||datetime||IGNORED|| 598 ||~~!DateTimeRecordCreated~~||71||datetime||IGNORED|| 599 ||~~!DateTimeRecordLastChanged~~||72||datetime||IGNORED|| 600 ||!EnteredByTag||73||varchar|||| 601 ||!EntryCurrentStatus||74||varchar|||| 602 ||!EntryEndStatus||75||varchar|||| 603 ||!HospitalTag||76||varchar|||| 604 604 ||WHO_RESPONSIBLE_CONSULTANT_SURGEON||77||varchar|||| 605 605 ||WHO_AGE_AT_OPERATION||78||int||||
