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

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

--

back

Tables

Table Description Start Date Field
GGHMINAPNEWGlenfield MINAP between 2007-2010DateofAdmissiontoCCU
LRIMINAPNEWRoyal MINAP between 2007-2010DateofAdmissiontoCCU
GGHMINAP_GGHMINAPGlenfield MINAP 2000-2007DateofHospitalAdmission (Although it has a column DateofAdmissiontoCCU, some of these values are null)
LRIMINAPNEW_LRIMINAPNEWINITIALVWRoyal MINAP 2007-2011DateofAdmissiontoCCU
GGHMINAPNEW_GGHMINAPINIVWGlenfield MINAP 2007-2011DateofAdmissiontoCCU
MINAPGGH_MINAPGGHINIVWGlenfield MINAP 2011-DateofAdmissiontoCCU

Columns

Column Name Column Type GGHMINAP_GGHMINAP GGHMINAPNEW GGHMINAPNEW_GGHMINAPINIVW LRIMINAPNEW LRIMINAPNEW_LRIMINAPNEWINITIALVW MINAPGGH_MINAPGGHINIVW
Ace1OrArbUseCcadvarcharYYYYYY
AceInhibitorCcadvarcharYYYYY
ACSauditAdmittedfromvarchar Y Y
AcsAuditAdmittesFromvarchar Y
AcsAuditCardiologicalOpinionRequestedDuringAdmissivarchar Y YY
ACSauditcommentstext Y YY
AcsAuditCommentsvarchar Y YY
AcsAuditDateAndTimeOfAngiographyvarchar Y YY
ACSauditDateandtimeofECHOvarchar Y YY
AcsAuditDateAndTimeOfEttvarchar Y YY
AcsAuditDateAndTimeOfPci_Cabgvarchar Y Y
ACSauditDateandtimeofPCICABGvarchar Y
ACSauditdischargedonsublingualGTNvarchar Y YY
AcsAuditHowManyDosesOfLmwhint Y YY
ACSauditriskstrarificationvarchar Y Y
AcsAuditRiskStratificationvarchar Y
AcsAuditSitevarchar Y YY
ACSauditTIMIscorevarchar Y YY
AcsAuditWardvarchar Y YY
AdditionalreperfusiontreatmentCCADvarchar YYYYY
AdmissionPlasmaGlucoseCcadfloatY
AdmissionWardCcadvarcharYYYYYY
AdmittingconsultantCCADvarcharYYYYYY
AgeintYYYYYY
AldosteroneAntagonistCcadvarchar Y YY
AmbulanceAttendantvarcharYYYYYY
AmbulanceDrivervarcharYYYYYY
AmbulanceJobNumberCcadvarcharYYYYYY
AmbulanceRespondervarcharYYYYYY
Angiotensiconvertingenzymeinhibitororangiotensinrevarchar Y
Angiotensinconvertingenzymeinhibitororangiotensinrvarchar Y
AngiotensinIiBlocker_arb_CcadvarcharYYYYY
ArrestPresentingRhythmCcadvarcharYYYYYY
ArrivalatHospitalCCADvarcharYYYYYY
ArrivalofambulanceCCADvarchar Y
ArrivalOfEmergencyServiceCcadvarcharYYYYY
ArrivalOfFirstProfessionalHelpCcadvarcharYYYYY
ArrivaloffirstresponderCCADvarchar Y
ASComments2varchar Y
AssessmentAtInterventionalCentreCcadvarchar Y YY
AssessmentatnoninterventionalhospitalCCADvarchar Y YY
AsthmaOrCopdCcadvarcharYYYYYY
AudittrailtextYYYYYY
AuditTrailvarcharYYYYYY
BallonTimevarchar YY
BalloonTimevarchar YY Y
BetaBlockerUseCcadvarcharYYYYYY
BleedingComplicationsCcadvarcharYYYYYY
CalciumChannelBlockerCcadvarcharYYYYYY
CalciumChannelBlockerUsevarcharYYYYYY
CallForHelpCcadvarcharYYYYYY
CardiacArrestCcadvarcharY
CardiacArrestLocationCcadvarchar YYYYY
CardiacEnzymes_markersRaisedCcadvarcharYYYYY
CardiacMarkersRaisedCCADvarchar Y
CardiacnurseinattendancevarcharYYYYYY
CardiacRehabilitationCcadvarcharYYYYYY
CardiologicalcareduringadmissionCCADvarchar YYYYY
CathLabArrivalTimevarchar YYYYY
CerebrovascularDiseaseCCADvarcharYYYYYY
ChronicRenalFailureCcadvarcharYYYYYY
ClopidogrelUseCcadvarcharYYYYY
CommentstextYYYYYY
CommentsvarcharYYYYYY
Comments2varchar Y
CoronaryAngiographyAtThisAdmissionCcadvarcharY
CoronaryAngiographyCcadvarchar YYYYY
CoronaryInterventionCcadvarchar YYYYY
CoronaryInterventionPerformedAtThisAdmissionCcadvarcharY
Cox_2InhibitorUsevarcharYYYYY
Cox2inhibitorusevarchar Y
CreatinineCCADfloat YYYYY
Datasetvarchar Y
DateandtimearrivalatnoninterventionalhospitalCCADvarchar Y YY
DateAndTimeOfFirstDiagnosticEcgvarcharYYYYYY
DateAndTimeOfReperfusionTreatmentCcadvarchar YYYYY
DateofAdmissiontoCCUdateYYYYYY
DateofAdmissiontoCCUdatetimeYYYYYY
DateOfAngioPerformedLocallyCcaddatetimeY
DateOfCurrentStatusdateYYYYYY
DateOfCurrentStatusdatetimeYYYYYY
DateOfDischargeFromCcudatetimeY
DateOfDischargeOrDeathCcaddateYYYYYY
DateOfDischargeOrDeathCcaddatetimeYYYYYY
DateOfEndStatusdateYYYYYY
DateOfEndStatusdatetimeYYYYYY
DateOfFirstInterventionOrSurgeryPerformedLocallyCcdatetimeY
DateofHospitalAdmissiondatetimeY
DateOfReferralForInvestigation_interventiondateYYYYY
DateOfReferralForInvestigation_interventiondatetimeYYYYY
DateofreferralforInvestigationInterventiondate Y
Dateofreturntoreferringhospitaldate YYYYY
DateOfReturnToReferringHospitaldatetime YYYYY
DateOfTransferForDayCaseInvestigationCcaddatetimeY
DateTimeRecordCreateddatetimeYYYYYY
DateTimeRecordCreatedvarcharYYYYYY
DateTimeRecordLastChangeddatetimeYYYYYY
DateTimeRecordLastChangedvarcharYYYYYY
DaycaseTransferDateCcaddate YYYYY
DaycaseTransferDateCcaddatetime YYYYY
DaysFromAdmissionToDeathintYYYYY
Daysfromdischargetodeathint Y
DaysInCcuintY
DaysInHospitalintYYYYYY
DeathInHospitalCcadvarcharYYYYYY
DelayBeforeTreatmentCcadvarcharYYYYYY
DelayCallToBalloonfloat YYYYY
DelayCallToDepartfloat YYYYY
DelayCcuToLabfloat YYYYY
DelayDoorToBalloonfloat YYYYY
DelayForCallToFrvfloat YYYYY
DelayFromArrivalInHospitalToReperfusionTreatmentfloatYYYYYY
DelayFromCallForHelpToArrivalInHospitalfloatYYYYYY
DelayFromCallForHelpToArrivalOfEmergencyServicesfloatYYYYYY
DelayFromCallForHelpToReperfusionTreatmentfloatYYYYYY
DelayFromOnsetOfSymptomsToCallForHelpfloatYYYYYY
DelayFromOnsetOfSymptomsToReperfusionTreatmentfloatYYYYYY
DelayFromReferralForInvestigation_interventionToTrfloatYYYYY
DelayfromreferralforinvestigationInterventiontotrafloat Y
DelayFRVtofullcrewfloat YYYYY
DelayLabToBalloonfloat YYYYY
DiabetesCCADvarcharYYYYYY
DiabeticTherapyAtDischargeCcadvarchar YYYYY
DiagamiCcadvarcharY
DietaryadvicegivenduringthisadmissionCCADvarchar Y YY
DirectAdmissionvarcharY
DischargeDestinationCcadvarchar YYYYY
DischargedfromCCUdestinationvarcharYYYYYY
DischargeDiagnosisCcadvarcharYYYYYY
DischargedOnAnAldosteroneAntagonistCcadvarchar Y YY
DischargedonAspirinCCADvarchar Y
DischargedOnAspirinOrOtherPlateletDrugCcadvarcharYYYYY
DischargedonathienopyridineinhibitorCCADvarchar Y
DischargedonbetablockerCCADvarcharYYYYYY
DischargedOnClopidogrelCcadvarcharYYYYY
DischargedOnStatinCcadvarcharYYYYYY
DischargedOnTheinopyridineInhibitorCcadvarchar Y
DischargedOnThienopyridineInhibitorCcadvarchar Y
DONOTUSEDischargedonthienopyridineinhibitorCCADvarchar Y
ECGdeterminingtreatmentCCADvarcharYYYYYY
EcgQrsComplexDurationCcadvarchar Y YY
EchocardiographyCCADvarcharYYYYYY
EnteredByTagvarcharYYYYYY
EntryCurrentStatusvarcharYYYYYY
EntryEndStatusvarcharYYYYYY
EntryIdintYYYYYY
EntryStatusvarcharYYYYYY
EplerenonevarcharYYYYYY
EthnicOriginCcadvarcharY
ExerciseTestPerformedCcadvarcharYYYYYY
FamilyhistoryofCHDCCADvarcharYYYYYY
FirstCardiacArrestCcadvarcharYYYYYY
FirstMustafa1int YY Y
FollowedUpByCcadvarcharYYYYYY
FondaparinuxCcadvarchar YYYYY
GenderCcadvarcharYYYYYY
Gp_pctCodeCcadvarchar YYYY
GPPCTcodeCCADvarchar Y
GpPracticeCodeCcadvarcharY
HaemoglobinCcadfloat YYYYY
HeartFailureCcadvarcharYYYYYY
HeartRateCcadintYYYYYY
HeightCcadfloatYYYYYY
HospitalCentreCodevarcharYYYYYY
HospitalRefferedFromvarchar YY YY
HospitalTagvarcharYYYYYY
HypercholesterolaemiaCcadvarcharYYYYYY
HypertensionCcadvarcharYYYYYY
ImportLinkIdint Y YY
ImportLinkIdvarchar Y YY
IncludeC2nvarchar YY
IncludeInCallToNeedlevarchar YY Y
IncludeinD2Nvarchar YYYYY
InitialDiagnosisCcadvarcharYYYYYY
InitialreperfusiontreatmentCCADvarchar YYYYY
InPatientManagementOfHyperglycaemia_diabetesCcadvarchar YYYY
InpatientmanagementofhyperglycaemiadiabetesCCADvarchar Y
IntendedreprofusionprocedureCCADvarchar Y YY
InterventionalCentreCodeCcadvarchar YYYYY
Iv2b_3aAgentCcadvarcharYYYYY
IV2b3aAgentCCADvarchar Y
IVbetablockerCCADvarcharYYYYYY
IvNitrateCcadvarcharYYYYYY
KillipClassvarchar Y
LeftventricularejectionfractionCCADvarcharYYYYYY
LocalAngioDateCcaddate YYYYY
LocalAngioDateCcaddatetime YYYYY
LocalinterventiondateCCADdate YYYYY
LocalInterventionDateCcaddatetime YYYYY
LoopDiureticCcadvarcharYYYYYY
LowmolecularweightheparinCCADvarcharYYYYYY
MedicalRecordNumberAtTimeOfEntryCcadvarcharYYYYYY
MethodofAdmissionCCADvarcharYYYYYY
ModeOfDischargeCcadvarcharY
Mustafa1int YY
Mustafa2int YY
NextEntryintYYYYYY
NHSNumberVerificationStatusvarchar Y
NitratesvarcharYYYYYY
NitrateUsevarcharYYYYYY
NSAIDusevarcharYYYYYY
OnsetOfSymptomsCcadvarcharYYYYYY
OralBetaBlockerCcadvarchar Y YY
OralNitratesCcadvarcharYYYYYY
OthervarcharYYYYYY
OtherAdmissionDiagnosisvarcharYYYYYY
OtherCommentsvarchar YY Y
OtherDischargeDiagnosisvarcharYYYYYY
OtherOralAntiplateletAgentCcadvarcharYYYYY
OtheroralantiplateletagentOLDvarchar Y
OutcomeofArrestCCADvarcharYYYYYY
PatientAdminStatusCcadvarcharYYYYYY
PatientCaseRecordNumberAtReferralCentreCcadvarcharY
PatientCaseRecordNumberAtReferringHospitalCcadvarchar YYYYY
PatientEthnicGroupvarchar YYYYY
PatientIdintYYYYYY
PatientLocationAtTimeOfStemiOnsetvarchar Y YY
PCTcodevarcharYYYYYY
PeakCreatinineKinase_ck_CcadfloatYYYYY
PeakCreatinineKinaseCKOLDfloat Y
PeakTroponinCCADfloatYYYYYY
PeripheralVascularDiseaseCcadvarcharYYYYYY
PickuppostcodevarcharYYYYYY
PlaceFirst12LeadEcgPerformedCcadvarcharYYYYYY
PotassiumChannelModulatorCCADvarcharYYYYYY
PreAlertCallvarcharYYYYYY
PreviousAMICCADvarcharYYYYYY
PreviousAnginaCcadvarcharYYYYYY
PreviousCABGCCADvarcharYYYYYY
PreviousEntryintYYYYYY
PreviousPCICCADvarcharYYYYYY
ProcedurePerformedCcadvarchar Y YY
RadionuclidestudyCCADvarcharYYYYYY
ReasonReperfusionTreatmentNotGivenCcadvarchar YYYYY
ReasonThrombolyticTreatmentNotGivenCcadvarcharY
RecommendedTherapyAtDischargeCcadvarcharY
ReferralCentreCcadvarcharY
ReferringHospitalCcadvarcharY
ReferringHospitalCodeCcadvarchar YYYYY
ReinfarctionCcadvarcharYYYYYY
SecondMustafa2int YY Y
SerumCholesterolCCADfloatYYYYYY
SerumGlucoseCcadfloat YYYYY
SiteofinfarctionCCADvarchar YYYYY
SmokingCessationAdviceGivenCcadvarchar Y YY
SmokingStatusCCADvarcharYYYYYY
SpironolactonevarcharYYYYYY
SpironolactoneCcadvarcharYYYYY
SpironolactoneOLDvarchar Y
StartOfReperfusionTreatmentCcadvarcharY
StatinUseCcadvarcharYYYYYY
SystolicBpCcadintYYYYYY
ThiazideDiureticCcadvarcharYYYYYY
ThienopyridinePlateletInhibitorCcadvarcharYYYYYY
ThienopyridineuseCCADvarchar Y
ThrombolyticDrugCCADvarcharYYYYYY
TimeFromAdmissionToFirstEcgfloat Y YY
TimeleftscenevarcharYYYYYY
TimeofAdmissiontoCCUdatetime YYYY
TimeofAdmissiontoCCUtime YYYY
TimeOfEntrytime Y
TimeofHospitalAdmissiondatetimeY
TotalTimeOnScenefloatYYYYYY
TroponinAssayCcadvarcharYYYYYY
TroponinReferenceValuevarcharYYYYYY
UnfractionatedHeparinCcadvarcharYYYYYY
WarfarinvarcharYYYYYY
WarfarinCcadvarcharYYYYYY
WasReperfusionAttempted_CcadvarcharY
WeightCcadfloatYYYYYY
WhatProcedureWasPerformedAtTheInterventionalHospitvarchar Y YY
WhereWasAspirin_otherAntiplateletGivenCcadvarcharYYYYY
WherewasAspirinotherantiplateletgivenCCADvarchar Y
WhereWasInitialReperfusionTreatmentGiven_CcadvarcharYYYYY
WherewasinitialreperfusiontreatmentgivenCCADvarchar Y
WhoTookTheInitialDecisionToAttemptReperfusion_CcadvarcharYYYYY
WhotooktheinitialdecisiontoattemptreperfusionOLDvarchar Y
WhyWasNoAngiogramPerformed_Ccadvarchar Y Y
WhywasnoangiogramperformedCCADvarchar Y
WhywasnointerventionperformedCCADvarchar Y YY
Note: See TracWiki for help on using the wiki.