wiki:i2b2 - UHL clinical informatics system integration PATS GGHPACEICD_GGHPACEICDINIALVW

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

--

back

Start Date Field: DateOfProcedure_Implant

Field NameColumn IDTypeComments
EntryId1intIgnored For Field Name
PatientId2intIgnored For Field Name
DateOfProcedure_Implant3dateIgnored For Datatype
TimeOfProcedure_Implant4timeIgnored For Datatype
EntryStatus5varchar
PreviousEntry6intIgnored For Field Name
NextEntry7intIgnored For Field Name
HospitalIdentifierCcad8varchar
PatientGenderCcad9varchar
PatientEthnicGroupCcad10varchar
PatientAdminStatusCcad11varchar
AuditTrail12textIgnored For Datatype
AgeAtProcedure13int
DateOfAdmission14dateIgnored For Datatype
DateOfFirstImplantCcad15dateIgnored For Datatype
PredeviceAetiologyCcad16varcharIgnored For No Enum
Predevice_eps_ablationPresentingSymptomCcad17varcharIgnored For No Enum
PredeviceEcgCcad18varcharIgnored For No Enum
NyhaDyspnoeaStatus_pre_ProcedureStableOnly_Ccad19varchar
LvFunctionAssessmentCcad20varchar
Lvef_30_Nice21varchar
IcdIndicationCcad22varchar
Predevice_ablationQrsDuration_ms_Ccad23float
DateAndTimeProcedureStart24varcharIgnored For No Enum
DateAndTimeProcedureEnd25varcharIgnored For No Enum
TotalTimeOfProcedure26int
InterventionCcad27varchar
ConsultantResponsibleForProcedureCcad28varchar
PrimaryOperatorCcadOldData29varcharIgnored For No Enum
GeneratorPacingModeCcad30varchar
GeneratorManufacturerCcad31varchar
GeneratorModelCcad32varcharIgnored For No Enum
GeneratorSerialNumberCcad33varcharIgnored For No Enum
GeneratorSiteOfImplantCcad34varchar
DateGeneratorChangedCcad35dateIgnored For Datatype
WhyThisGeneratorEventuallyExplantedCcad36varchar
VentricularLeadManufacturerCcad37varchar
VentricularLeadModelCcad38varcharIgnored For No Enum
VentricularLeadSerialNumberCcad39varcharIgnored For No Enum
VentricularLeadImplantApproachCcad40varchar
DateVentricularLeadChangedCcad41dateIgnored For Datatype
!WhyThisVLeadEventuallyExplantedCcad42varchar
AtrialLeadManufacturerCcad43varchar
AtrialLeadModelCcad44varcharIgnored For No Enum
AtrialLeadSerialNumberCcad45varcharIgnored For No Enum
AtrialLeadImplantApproachCcad46varchar
DateAtrialLeadChangedCcad47dateIgnored For Datatype
!WhyThisALeadEventuallyExplantedCcad48varchar
VentricularLead2ManufacturerCcad49varchar
VentricularLead2ModelCcad50varcharIgnored For No Enum
VentricularLead2SerialNumberCcad51varcharIgnored For No Enum
VentricularLead2ImplantApproachCcad52varchar
DateVentricularLead2ChangedCcad53dateIgnored For Datatype
WhyThisVLead2EventuallyExplantedCcad54varchar
AtrialLead2ManufacturerCcad55varchar
AtrialLead2ModelCcad56varchar
AtrialLead2SerialNumberCcad57varchar
AtrialLead2ImplantApproachCcad58varchar
DateAtrialLead2ChangedCcad59dateIgnored For Datatype
WhyThisALead2EventuallyExplantedCcad60varchar
IcdFunctionCcad61varchar
BivFunctionCcad62varchar
DefbrillatorLeadSiteCcad63varchar
PacingProcedureComplicationsCcad64varchar
BradycardiaPacingOn_Ccad65varchar
BradycardiaPacingModeCcad66varchar
PacingRate_low_Ccad67float
Anti_TachycardiaPacingOn_Ccad68varchar
VtShockTherapyOn_Ccad69varchar
VfShockTherapyOn_Ccad70varchar
BiventricularPacingOn_Ccad71varchar
AvDelay_sensed_Ccad72int
AvDelay_paced73int
BiventricularDelay_paced74int
BiventricularPacingWhichChamberPacedFirst_Ccad75varchar
LeadExtractedCcad76varchar
DateOfFileClosureCcad77dateIgnored For Datatype
DeviceFileClosureCcad78varchar
EpsTestedNice79varchar
TypeOfProcedure80varchar
Ccso81varcharIgnored For No Enum
DateOfVentricularLeadImplant82dateIgnored For Datatype
TypeOfVentricularLeadProcedure83varchar
TemporaryWire84varchar
PolarityOfVentricularLead85varchar
ConnectorAtrialLead86varchar
ConnectorVentricularLead87varchar
VentricularLeadCurrent_5v_0_5ms88float
VentricularLeadImpedance_ohms89float
VentricularLeadRWave_mv90float
VentricularLeadThreshold_0_5ms91float
VentricularLeadStability_1v92varchar
VentricularLeadTwitch_10v93varchar
VentricularLeadThresholdProblems94varchar
VentricularLeadConfirmCorrectConnection95varchar
ConfirmPacingVentricularLead96varchar
DateOfAtrialLeadImplant97dateIgnored For Datatype
TypeOfAtrialLeadProcedure98varchar
PolarityOfAtrialLead99varchar
AtrialLeadCurrent_5v_0_5ms100float
AtrialLeadImpedance_ohms101float
AtrialLeadPWave_mv102float
AtrialLeadThreshold_0_5ms103float
AtrialLeadStability_1v104varchar
AtrialLeadTwitch_10v105varchar
AtrialLeadThresholdProblems106varchar
AtrialLeadConfirmCorrectConnection107varchar
DateOfVentricularLead2Implant108dateIgnored For Datatype
TypeOfVentricularLead2Procedure109varchar
PolarityOfVentricularLead2110varchar
ConnectorVentricularLead2111varchar
VentricularLead2Current_5v_0_5ms112float
VentricularLead2Impedance_ohms113float
VentricularLead2RWave_mv114float
VentricularLead2Threshold_0_5ms115float
VentricularLead2Stability_1v116varchar
VentricularLead2Twitch_10v117varchar
VentricularLead2ThresholdProblems118varchar
VentricularLead2ConfirmCorrectConnection119varchar
ConfirmPacingVentricularLead2120varchar
DateOfAtrialLead2Implant121dateIgnored For Datatype
TypeOfAtrialLead2Procedure122varchar
PolarityOfAtrialLead2123varchar
ConnectorAtrialLead2124varchar
AtrialLead2Current_5v_0_5ms125float
AtrialLead2Impedance_ohms126float
AtrialLead2RWave_mv127float
ConfirmPacingAtrialLead128varchar
AtrialLeas2Threshold_0_5ms129float
AtrialLead2Stability_1v130float
AtrialLead2Twitch_10v131float
AtrialLead2ThresholdProblems132varchar
AtrialLead2ConfirmCorrectConnection133varchar
ConfirmPacingAtrialLead2134varchar
DateVentricularLeadCut_cappedAndBuried135dateIgnored For Datatype
DateAtrialLeadCut_cappedAndBuried136dateIgnored For Datatype
DateVentricularLead2Cut_cappedAndBuried137dateIgnored For Datatype
DateAtrialLead2Cut_cappedAndBuried138dateIgnored For Datatype
ProcedureReport139varcharIgnored For No Enum
GpAtTimeOfProcedure140varcharIgnored For No Enum
NameOfGp141varcharIgnored For No Enum
GpPracticeCode142varcharIgnored For No Enum
Pct143varcharIgnored For No Enum
MedicalRecordNumber144varcharIgnored For No Enum
NumberOfDaysDeviceImplanted145int
DateOfExplant146dateIgnored For Datatype
DateOfDischarge147dateIgnored For Datatype
ComplicationsBeforeDischarge148varchar
DateOfComplication149dateIgnored For Datatype
TypeOfComplication150varchar
IfOtherComplicationPleaseState151varchar
DischargeDelayedDueToComplication152varchar
PacemakerChecksTransferred153varchar
TransferredTo154varchar
DateOfTransfer155dateIgnored For Datatype
ProcedureUrgency156varchar
OtherOperatorsOldData157varchar
SideUsed158varchar
Ward159varcharIgnored For No Enum
PrimaryOperatorCcad160varcharIgnored For No Enum
OtherOperators161varcharIgnored For No Enum
TotalDaysInHospital162float
LvPortPlugged163varchar
ClinicalGuidance164varchar
PrimaryReplacementAppropriateTherapy165varchar
NumberOfDaysDischargeDelayed166float
Height167float
Weight168float
Bmi169float
ScreeningTime170float
ScreeningDose171float
ExceededDrl172varchar
Radiographer173varchar
ReasonForExceedingDrl174varchar
SickNoteGiven175varchar
DurationOfSickNoteInDays176int
ChangesToCurrentMedication177varchar
NameOfDischargingDoctor178varchar
Grade179varchar
PagerNumber180varchar
DischargeWard181varchar
DischargeDestination182varchar
DrugSensitivity183varchar
Drug1184varchar
Route1185varchar
NumberOfDays1186int
Continue1187varchar
Drug2188varchar
Route2189varchar
NumberOfDays2190int
Continue2191varchar
Drug3192varchar
Route3193varchar
NumberOfDays3194int
Continue3195varchar
Drug4196varchar
Route4197varchar
NumberOfDays4198int
Continue4199varchar
Drug5200varchar
Route5201varchar
NumberOfDays5202int
Continue5203varchar
Drug6204varchar
Route6205varchar
NumberOfDays6206int
Continue6207varchar
Drug7208varchar
Route7209varchar
NumberOfDays7210int
Continue7211varchar
Drug8212varchar
Route8213varchar
NumberOfDays8214int
Continue8215varchar
Drug9216varchar
Route9217varchar
NumberOfDays9218int
Continue9219varchar
Drug10220varchar
Route10221varchar
NumberOfDays10222int
Continue10223varchar
Drug11224varchar
Route11225varchar
NumberOfDays11226int
Continue11227varchar
Drug12228varchar
Route12229varchar
NumberOfDays12230int
Continue12231varchar
Drug13232varchar
Route13233varchar
NumberOfDays13234int
Continue13235varchar
Drug14236varchar
Route14237varchar
NumberOfDays14238int
Continue14239varchar
Drug15240varchar
Route15241varchar
NumberOfDays15242int
Continue15243varchar
Drug16244varchar
Route16245varchar
NumberOfDays16246int
Continue16247varchar
Drug17248varchar
Route17249varchar
NumberOfDays17250int
Continue17251varchar
Drug18252varchar
Route18253varchar
NumberOfDays18254int
Continue18255varchar
Note: See TracWiki for help on using the wiki.