wiki:i2b2 - UHL clinical informatics system integration PATS VERTED_VERTEDINIALVW

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

--

back

Start Date Field: DateOfCardioversion

Field NameColumn IDTypeComments
EntryId1intIgnored For Field Name
PatientId2intIgnored For Field Name
DateOfCardioversion3dateIgnored For Datatype
TimeOfCardioversion4timeIgnored For Datatype
EntryStatus5varchar
PreviousEntry6intIgnored For Field Name
NextEntry7intIgnored For Field Name
DateOnWaitingList8dateIgnored For Datatype
AgeAtCardioversion9int
BloodPressure10varcharIgnored For No Enum
Height11varcharIgnored For No Enum
Rhythm12varchar
DrugsOnAdmission13varcharIgnored For No Enum
DateOfEcho14dateIgnored For Datatype
Pacemaker15varchar
Weight16float
Inr17float
JoulesDelivered_118int
Rhythm_119varcharIgnored For No Enum
JoulesDelivered_220int
Rhythm_221varcharIgnored For No Enum
JoulesDelivered_322int
Rhythm_323varchar
JoulesDelivered_424int
Rhythm_425varchar
JoulesDelivered_526int
Rhythm_527varchar
JoulesDelivered_628int
Rhythm_629varchar
InternalCardioversion30varchar
ExternalCardioversion31varchar
OutcomeSucces32varchar
Death33varchar
CardioversionCancelled34varchar
Reason35varcharIgnored For No Enum
DateOfDischarge36dateIgnored For Datatype
DateOfAdmission37dateIgnored For Datatype
RhythmAfterCardioversion38varchar
AdmissionType39varchar
DateOfFollowUp40dateIgnored For Datatype
Ap_241varchar
Ap_342varchar
Ap_443varchar
Ap_544varchar
Ap_645varchar
Consultant46varchar
ContractDetails47varchar
Pcg48varchar
MedicationOnDischarge149varcharIgnored For No Enum
MedicationOnDischarge250varcharIgnored For No Enum
MedicationOnDischarge351varcharIgnored For No Enum
MedicationOnDischarge452varcharIgnored For No Enum
MedicationOnDischarge553varcharIgnored For No Enum
MedicationOnDischarge654varcharIgnored For No Enum
MedicationOnDischarge755varcharIgnored For No Enum
MedicationOnDischarge856varcharIgnored For No Enum
MedicationOnDischarge957varcharIgnored For No Enum
AuditLoopClosed58varchar
DateAuditLoopClosed59dateIgnored For Datatype
ReasonAuditLoopClosed60varchar
DateOfDeathPostDischarge61dateIgnored For Datatype
PostDischargeDeathInterval_days62int
ReasonForCancellation63varchar
IntervalBetweenProc_LoopClosed_days64int
PreOpStay_days65int
PostOpStay_days66int
TotalLos_days67int
ReferralToOp_days68int
DischargeToFollow_Up_days69int
EchoPerformed70varchar
ImmeadiateReinitiationOfAf_iraf71varchar
PacemakerMode72varchar
EcgResultAt1Week73varchar
EcgResultAt1Month74varchar
ReCardiovert75varchar
ReasonWhyYesOrNo76varchar
Anaesthetic_sedation77varchar
IfSedationDose78varcharIgnored For No Enum
Reversal79varchar
ComplicationsPreDischarge80varchar
DoseOfFlumazenil81varchar
TypeOfDefibUsed82varchar
DoesPatientRememberShocks83varchar
WasProcedureUnpleasant84varchar
AnyOtherComments85varcharIgnored For No Enum
BurnMarks86varchar
HeartRate_priorToDischarge87varcharIgnored For No Enum
Anaesthetist88varchar
MedicalAssistant89varchar
UnderlyingCardiacDiagnosisForAf90varcharIgnored For No Enum
DrugListOnDischarge91varcharIgnored For No Enum
FreeThyroxine92float
ThyroidStimulatingHormone93float
Operator94varcharIgnored For No Enum
DoctorReading1WeekEcg95varchar
DoctorReading1MonthEcg96varchar
PadsOrPaddles97varchar
IfRevertsToAf98varchar
AnyUntowardsEvents99varcharIgnored For No Enum
DurationOfAf100varchar
FollowUpAt_Hospital101varchar
TotalDoseOfSedation102varchar
TotalJulesDelivered103float
NumberOfPreviousCardioversion104varchar
GpPracticeCode105varcharIgnored For No Enum
Pct106varchar
TotalNumberOfShocks107int
MedicalRecordNumber108varcharIgnored For No Enum
HasPatientHadPreviousCardioversion109varchar
DateOfLastCardioversion110dateIgnored For Datatype
IsProcedureForRecuurrenceOfAfOfFailure111varchar
MedicationOnDischarge10112varcharIgnored For No Enum
MedicationOnDischarge11113varcharIgnored For No Enum
MedicationOnDischarge12114varcharIgnored For No Enum
MedicationOnDischarge13115varchar
DateAndTimeOfCardioversion116varcharIgnored For No Enum
UnderlyingCardiacDiagnosis2117varcharIgnored For No Enum
UnderlyingCardiacDiagnosis3118varcharIgnored For No Enum
UnderlyingCardiacDiagnosis4119varcharIgnored For No Enum
UnderlyingCardiacDiagnosis5120varcharIgnored For No Enum
UnderlyingCardiacDiagnosis6121varchar
ConsultantTitle122varchar
ConsultantsHospitalBase123varchar
SickNoteOfferedToPatient124varchar
IfAccepted_DurationInDays125int
ManagementPlan126varchar
DoctorSigningLetter127varchar
TitleOfDoctorSigning128varchar
DateOfCurrentStatus129dateIgnored For Datatype
DateOfEndStatus130dateIgnored For Datatype
DateTimeRecordCreated131varchar
DateTimeRecordLastChanged132varchar
EnteredByTag133varchar
EntryCurrentStatus134varchar
EntryEndStatus135varchar
HospitalTag136varchar
ImportLinkId137int
Note: See TracWiki for help on using the wiki.