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

Version 1 (modified by Richard Bramley, 11 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

ColumnCS_SubProcedureCS2003F_SubProcedureCS2010F_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.