wiki:i2b2 - UHL clinical informatics system integration PATS CS SubProcedure Combined

Version 3 (modified by Richard Bramley, 12 years ago) ( diff )

--

back

Tables

Table Date Range Start Date Field Records
CS_SubProcedure?Taken from parent16610
CS2003F_SubProcedure?Taken from parent19599
CS2010F_SubProcedure?Taken from parent4069

Columns

Column CS_SubProcedure CS2003F_SubProcedure CS2010F_SubProcedure
AccessToMitralValve Y
Anastomosis Y
AorticArchType Y
AorticPathologyYYY
AorticProcedureYYY
AorticProceduresY
AorticRootEnlargementY
Aortotomy Y
AssessmentAndRepair Y
AtrialClosure Y
Bi_CavalCannulation Y
ClosureOfAortotomy Y
ConcommitantCarotidEndarterectomyY
DateTimeRecordCreated YY
DateTimeRecordLastChanged YY
De_AiringOfHeart Y
De_AiringOfHeart_mitral Y
DecalcificationOfAnnulus Y
DistalAnastamosisConstructedBy Y
DistalAnastomosisY
EnteredByTag YY
EntryCurrentStatusY
EntryEndStatusY
EntryIdYYY
EntryStatusYYY
ExcisionOfValve Y
ExcisionOfValveAndAnnularDebridement Y
ExplantValveTypeYY
GraftAnastomosis Y
GraftConduitYYY
GraftSite Y
HaemodynamicPathologyYY
HospitalTag YY
ImplantationOfMitralValve Y
ImplantationOfValve Y
ImplantedValveProsthesisY
ImplantProsthesis_hvrCode Y
ImplantProsthesisName Y
ImplantType Y
ImplantValveTypeY
Lima Y
LocalProceduresY
Lsv Y
NativeValveOtherPathology Y
NativeValvePathology YY
OtherArtery Y
OtherNativeValvePathology_freeText Y
OtherReasonForRepeatValveReplacement Y
OtherReasonForRepeatValveSurgery_freeText Y
OtherVein Y
ParentEntryIdYYY
PatientIdYYY
PreservationOfSubvalvularApparatusY
ProcedureSiteYYY
ProcedureStatusY
ProstheticValveExplantY
ProximalAnastamosisConstructedBy Y
ProximalAnastomosisY
Radial Y
ReasonForRepeatValveReplacement Y
ReasonForRepeatValveSurgery Y
RepairOfValve Y
Rima Y
Ring Y
Ssv Y
TimeOfEntryY
Valve_ringSerialNumberY
ValveExplantType Y
ValveHaemodynamicPathology Y
ValveImplantName Y
ValveImplantType Y
ValveOrRingModelNumber YY
ValveOrRingSerialNumber YY
ValveOrRingSize Y
ValveOrRingSizeInMm Y
ValvePathologyY
ValveProcedureYYY
ValveRepairY
ValveSize_mmY
WHO_POSSIBLE_DUPLICATE Y
WHO_REGISTRY_INDICATOR Y
Note: See TracWiki for help on using the wiki.