wiki:i2b2 - UHL clinical informatics system integration PATS CATH_CATHINITIALVW

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

--

back

Start Date Field: DateofCatheter

Field NameColumn IDTypeComments
EntryId1intIgnored For Field Name
PatientId2intIgnored For Field Name
DateofCatheter3dateIgnored For Datatype
TimeofCatheter4timeIgnored For Datatype
EntryStatus5varchar
PreviousEntry6intIgnored For Field Name
NextEntry7intIgnored For Field Name
DateOfAdmission8dateIgnored For Datatype
AgeAtCatheter9int
DoneInMobileLab10varchar
Consultant11varcharIgnored For No Enum
Operator12varcharIgnored For No Enum
SecondOperator13varcharIgnored For No Enum
Technician14varcharIgnored For No Enum
PatientType15varchar
WasThePatientCatheterised16varchar
ProcedureType17varchar
GeneralAnaesthetics18varchar
ProcedureSite19varcharIgnored For No Enum
BiopsyTaken20varchar
BiopsySite21varchar
OtherProcedure22varcharIgnored For No Enum
Arterial_123varchar
Vessel_1_Arterial24varchar
Complicated_1_Arterial25varchar
Arterial_226varchar
Vessel_2_Arterial27varchar
Complicated2Arterial28varchar
Arterial_329varchar
Vessel_3_Arterial30varchar
Complicated_3_Arterial31varchar
Venous_132varchar
Vessel_1_Venous33varchar
Complicated_1_Venous34varchar
Venous_235varchar
Vessel_2_Venous36varchar
Complicated_2_Venous37varchar
Venous_338varchar
Vessel_3_Venous39varchar
Complicated_3_Venous40varchar
Vessels41varcharIgnored For No Enum
ReturnedTo42varchar
FurtherProcedure43varchar
ImmediateComplications44varchar
ProcedureAbandoned45varchar
ReasonForAbandoningProcedure46varchar
OtherComplications47varcharIgnored For No Enum
DiedInCathLab48varchar
CoronaryDisease49varchar
SignificantValveDisease50varchar
SignificantLvDisease51varchar
Outcome52varchar
ReturnToCathLab53varchar
EmbolicSequelae54varchar
NonEmergencySurgery55varchar
GroinComplication56varchar
Death57varchar
DischargeComplications58varchar
OutcomeOfCatheter59varchar
DateOfDischarge60dateIgnored For Datatype
DateOfDeath61dateIgnored For Datatype
DischargeTo62varchar
PreopStay_days63int
PostOpStay_days64int
TotalHospitalStay65int
IhdScore_cardwl66int
NihdScore_cardwl67int
OtherComplicationsPreDischarge68varchar
DateOfDeathPostDischarge69dateIgnored For Datatype
PostProcedureDeathInterval_days70int
FormsVerified71varchar
Contract72varcharIgnored For No Enum
Pcg73varcharIgnored For No Enum
AuditLoopClosed74varchar
DateAuditLoopClosed75dateIgnored For Datatype
ReasonAuditLoopClosed76varchar
IntervalBetweenProc_LoopClosed_days77int
DateOnWaitingList78dateIgnored For Datatype
DaysOnList79int
GpPracticeCode80varcharIgnored For No Enum
Pct81varcharIgnored For No Enum
MedicalRecordNumber82varcharIgnored For No Enum
AdministrativeCategory83varchar
AuditTrail84textIgnored For Datatype
DateAndTimeOfProcedure85varcharIgnored For No Enum
IsThisAcs86varchar
Sub_Xiphoid87varchar
PreDischargeComplications88varchar
IfOtherPreDischargeComplicationsPleaseState89varchar
Height90float
Weight91float
Bmi92float
ScreeningTime93float
ScreeningDose94float
ExceededDrl95varchar
Radiographer96varchar
ReasonForExceedingDrl97varchar
CatheterProcedureReport98varcharIgnored For No Enum
ConsultantCode99varcharIgnored For No Enum
OperatorCode100varcharIgnored For No Enum
SecondOperatorCode101varcharIgnored For No Enum
TroponinPositive102varchar
DateOfCurrentStatus103dateIgnored For Datatype
DateOfEndStatus104dateIgnored For Datatype
DateTimeRecordCreated105varcharIgnored For No Enum
DateTimeRecordLastChanged106varcharIgnored For No Enum
EnteredByTag107varchar
EntryCurrentStatus108varchar
EntryEndStatus109varchar
HospitalTag110varchar
ImportLinkId111int
Note: See TracWiki for help on using the wiki.