wiki:i2b2 - UHL clinical informatics system integration PATS CATH Combined

Version 4 (modified by Richard Bramley, 11 years ago) ( diff )

--

back

Tables

Table Date Range Start Date Field Records
CATH_CATH2000-2007DateOfCatheter31150
CATH_CATHINITIALVW1899(sic)-2013DateOfCatheter51325

Columns

Column CATH_CATH CATH_CATHINITIALVW
AdministrativeCategoryYY
AgeAtCatheterYY
Arterial_1YY
Arterial_2YY
Arterial_3YY
AuditLoopClosedYY
AuditTrailYY
BiopsySiteYY
BiopsyTakenYY
Bmi Y
CatheterProcedureReport Y
Complicated_1_ArterialYY
Complicated_1_VenousYY
Complicated_2_VenousYY
Complicated_3_ArterialYY
Complicated_3_VenousYY
Complicated2ArterialYY
ConsultantYY
ConsultantCode Y
ContractYY
CoronaryDiseaseYY
DateAndTimeOfProcedureYY
DateAuditLoopClosedYY
DateOfAdmissionYY
DateofCatheterYY
DateOfCurrentStatusYY
DateOfDeathYY
DateOfDeathPostDischargeYY
DateOfDischargeYY
DateOfEndStatusYY
DateOnWaitingListYY
DateTimeRecordCreatedYY
DateTimeRecordLastChangedYY
DaysOnListYY
DeathYY
DiedInCathLabYY
DischargeComplicationsYY
DischargeToYY
DoneInMobileLabYY
EmbolicSequelaeYY
EnteredByTagYY
EntryCurrentStatusYY
EntryEndStatusYY
EntryIdYY
EntryStatusYY
ExceededDrl Y
FormsVerifiedYY
FurtherProcedureYY
GeneralAnaestheticsYY
GpPracticeCodeYY
GroinComplicationYY
Height Y
HospitalTagYY
IfOtherPreDischargeComplicationsPleaseState Y
IhdScore_cardwlYY
ImmediateComplicationsYY
ImportLinkId Y
IntervalBetweenProc_LoopClosed_daysYY
IsThisAcs Y
MedicalRecordNumberYY
NextEntryYY
NihdScore_cardwlYY
NonEmergencySurgeryYY
OperatorYY
OperatorCode Y
OtherComplicationsYY
OtherComplicationsPreDischargeYY
OtherProcedureYY
OutcomeYY
OutcomeOfCatheterYY
PatientIdYY
PatientTypeYY
PcgYY
PctYY
PostOpStay_daysYY
PostProcedureDeathInterval_daysYY
PreDischargeComplications Y
PreopStay_daysYY
PreviousEntryYY
ProcedureAbandonedYY
ProcedureSiteYY
ProcedureTypeYY
Radiographer Y
ReasonAuditLoopClosedYY
ReasonForAbandoningProcedureYY
ReasonForExceedingDrl Y
ReturnedToYY
ReturnToCathLabYY
ScreeningDose Y
ScreeningTime Y
SecondOperatorYY
SecondOperatorCode Y
Shunt_baffleY
SignificantLvDiseaseYY
SignificantValveDiseaseYY
Sub_Xiphoid Y
TechnicianYY
TimeofCatheterYY
TotalHospitalStayYY
TroponinPositive Y
Venous_1YY
Venous_2YY
Venous_3YY
Vessel_1_ArterialYY
Vessel_1_VenousYY
Vessel_2_ArterialYY
Vessel_2_VenousYY
Vessel_3_ArterialYY
Vessel_3_VenousYY
VesselsYY
WasThePatientCatheterisedYY
Weight Y
Note: See TracWiki for help on using the wiki.