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

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

--

back

Start Date Field: DateofHospitalAdmission

ColumnNameColumnTypeGGHMINAP_GGHMINAPGGHMINAPNEWGGHMINAPNEW_GGHMINAPINIVWLRIMINAPNEWLRIMINAPNEW_LRIMINAPNEWINITIALVWMINAPGGH_MINAPGGHINIVW
Ace1OrArbUseCcadvarcharYYYYYY
AceInhibitorCcadvarcharYYYYYn
ACSauditAdmittedfromvarcharnnYnnY
AcsAuditAdmittesFromvarcharnnnnYn
AcsAuditCardiologicalOpinionRequestedDuringAdmissivarcharnnYnYY
ACSauditcommentstextnnYnYY
AcsAuditCommentsvarcharnnYnYY
AcsAuditDateAndTimeOfAngiographyvarcharnnYnYY
ACSauditDateandtimeofECHOvarcharnnYnYY
AcsAuditDateAndTimeOfEttvarcharnnYnYY
AcsAuditDateAndTimeOfPci_CabgvarcharnnYnYn
ACSauditDateandtimeofPCICABGvarcharnnnnnY
ACSauditdischargedonsublingualGTNvarcharnnYnYY
AcsAuditHowManyDosesOfLmwhintnnYnYY
ACSauditriskstrarificationvarcharnnYnnY
AcsAuditRiskStratificationvarcharnnnnYn
AcsAuditSitevarcharnnYnYY
ACSauditTIMIscorevarcharnnYnYY
AcsAuditWardvarcharnnYnYY
AdditionalreperfusiontreatmentCCADvarcharnYYYYY
AdmissionPlasmaGlucoseCcadfloatYnnnnn
AdmissionWardCcadvarcharYYYYYY
AdmittingconsultantCCADvarcharYYYYYY
AgeintYYYYYY
AldosteroneAntagonistCcadvarcharnnYnYY
AmbulanceAttendantvarcharYYYYYY
AmbulanceDrivervarcharYYYYYY
AmbulanceJobNumberCcadvarcharYYYYYY
AmbulanceRespondervarcharYYYYYY
AngiotensiconvertingenzymeinhibitororangiotensinrevarcharnnnnnY
AngiotensinconvertingenzymeinhibitororangiotensinrvarcharnnnnnY
AngiotensinIiBlocker_arb_CcadvarcharYYYYYn
ArrestPresentingRhythmCcadvarcharYYYYYY
ArrivalatHospitalCCADvarcharYYYYYY
ArrivalofambulanceCCADvarcharnnnnnY
ArrivalOfEmergencyServiceCcadvarcharYYYYYn
ArrivalOfFirstProfessionalHelpCcadvarcharYYYYYn
ArrivaloffirstresponderCCADvarcharnnnnnY
ASComments2varcharnnnnYn
AssessmentAtInterventionalCentreCcadvarcharnnYnYY
AssessmentatnoninterventionalhospitalCCADvarcharnnYnYY
AsthmaOrCopdCcadvarcharYYYYYY
AudittrailtextYYYYYY
AuditTrailvarcharYYYYYY
BallonTimevarcharnnnYYn
BalloonTimevarcharnYYnnY
BetaBlockerUseCcadvarcharYYYYYY
BleedingComplicationsCcadvarcharYYYYYY
CalciumChannelBlockerCcadvarcharYYYYYY
CalciumChannelBlockerUsevarcharYYYYYY
CallForHelpCcadvarcharYYYYYY
CardiacArrestCcadvarcharYnnnnn
CardiacArrestLocationCcadvarcharnYYYYY
CardiacEnzymes_markersRaisedCcadvarcharYYYYYn
CardiacMarkersRaisedCCADvarcharnnnnnY
CardiacnurseinattendancevarcharYYYYYY
CardiacRehabilitationCcadvarcharYYYYYY
CardiologicalcareduringadmissionCCADvarcharnYYYYY
CathLabArrivalTimevarcharnYYYYY
CerebrovascularDiseaseCCADvarcharYYYYYY
ChronicRenalFailureCcadvarcharYYYYYY
ClopidogrelUseCcadvarcharYYYYYn
CommentstextYYYYYY
CommentsvarcharYYYYYY
Comments2varcharnnnYnn
CoronaryAngiographyAtThisAdmissionCcadvarcharYnnnnn
CoronaryAngiographyCcadvarcharnYYYYY
CoronaryInterventionCcadvarcharnYYYYY
CoronaryInterventionPerformedAtThisAdmissionCcadvarcharYnnnnn
Cox_2InhibitorUsevarcharYYYYYn
Cox2inhibitorusevarcharnnnnnY
CreatinineCCADfloatnYYYYY
DatasetvarcharnnnnnY
DateandtimearrivalatnoninterventionalhospitalCCADvarcharnnYnYY
DateAndTimeOfFirstDiagnosticEcgvarcharYYYYYY
DateAndTimeOfReperfusionTreatmentCcadvarcharnYYYYY
DateofAdmissiontoCCUdateYYYYYY
DateofAdmissiontoCCUdatetimeYYYYYY
DateOfAngioPerformedLocallyCcaddatetimeYnnnnn
DateOfCurrentStatusdateYYYYYY
DateOfCurrentStatusdatetimeYYYYYY
DateOfDischargeFromCcudatetimeYnnnnn
DateOfDischargeOrDeathCcaddateYYYYYY
DateOfDischargeOrDeathCcaddatetimeYYYYYY
DateOfEndStatusdateYYYYYY
DateOfEndStatusdatetimeYYYYYY
DateOfFirstInterventionOrSurgeryPerformedLocallyCcdatetimeYnnnnn
DateofHospitalAdmissiondatetimeYnnnnn
DateOfReferralForInvestigation_interventiondateYYYYYn
DateOfReferralForInvestigation_interventiondatetimeYYYYYn
DateofreferralforInvestigationInterventiondatennnnnY
DateofreturntoreferringhospitaldatenYYYYY
DateOfReturnToReferringHospitaldatetimenYYYYY
DateOfTransferForDayCaseInvestigationCcaddatetimeYnnnnn
DateTimeRecordCreateddatetimeYYYYYY
DateTimeRecordCreatedvarcharYYYYYY
DateTimeRecordLastChangeddatetimeYYYYYY
DateTimeRecordLastChangedvarcharYYYYYY
DaycaseTransferDateCcaddatenYYYYY
DaycaseTransferDateCcaddatetimenYYYYY
DaysFromAdmissionToDeathintYYYYYn
DaysfromdischargetodeathintnnnnnY
DaysInCcuintYnnnnn
DaysInHospitalintYYYYYY
DeathInHospitalCcadvarcharYYYYYY
DelayBeforeTreatmentCcadvarcharYYYYYY
DelayCallToBalloonfloatnYYYYY
DelayCallToDepartfloatnYYYYY
DelayCcuToLabfloatnYYYYY
DelayDoorToBalloonfloatnYYYYY
DelayForCallToFrvfloatnYYYYY
DelayFromArrivalInHospitalToReperfusionTreatmentfloatYYYYYY
DelayFromCallForHelpToArrivalInHospitalfloatYYYYYY
DelayFromCallForHelpToArrivalOfEmergencyServicesfloatYYYYYY
DelayFromCallForHelpToReperfusionTreatmentfloatYYYYYY
DelayFromOnsetOfSymptomsToCallForHelpfloatYYYYYY
DelayFromOnsetOfSymptomsToReperfusionTreatmentfloatYYYYYY
DelayFromReferralForInvestigation_interventionToTrfloatYYYYYn
DelayfromreferralforinvestigationInterventiontotrafloatnnnnnY
DelayFRVtofullcrewfloatnYYYYY
DelayLabToBalloonfloatnYYYYY
DiabetesCCADvarcharYYYYYY
DiabeticTherapyAtDischargeCcadvarcharnYYYYY
DiagamiCcadvarcharYnnnnn
DietaryadvicegivenduringthisadmissionCCADvarcharnnYnYY
DirectAdmissionvarcharYnnnnn
DischargeDestinationCcadvarcharnYYYYY
DischargedfromCCUdestinationvarcharYYYYYY
DischargeDiagnosisCcadvarcharYYYYYY
DischargedOnAnAldosteroneAntagonistCcadvarcharnnYnYY
DischargedonAspirinCCADvarcharnnnnnY
DischargedOnAspirinOrOtherPlateletDrugCcadvarcharYYYYYn
DischargedonathienopyridineinhibitorCCADvarcharnnnnnY
DischargedonbetablockerCCADvarcharYYYYYY
DischargedOnClopidogrelCcadvarcharYYYYYn
DischargedOnStatinCcadvarcharYYYYYY
DischargedOnTheinopyridineInhibitorCcadvarcharnnnnYn
DischargedOnThienopyridineInhibitorCcadvarcharnnYnnn
DONOTUSEDischargedonthienopyridineinhibitorCCADvarcharnnnnnY
ECGdeterminingtreatmentCCADvarcharYYYYYY
EcgQrsComplexDurationCcadvarcharnnYnYY
EchocardiographyCCADvarcharYYYYYY
EnteredByTagvarcharYYYYYY
EntryCurrentStatusvarcharYYYYYY
EntryEndStatusvarcharYYYYYY
EntryIdintYYYYYY
EntryStatusvarcharYYYYYY
EplerenonevarcharYYYYYY
EthnicOriginCcadvarcharYnnnnn
ExerciseTestPerformedCcadvarcharYYYYYY
FamilyhistoryofCHDCCADvarcharYYYYYY
FirstCardiacArrestCcadvarcharYYYYYY
FirstMustafa1intnYYnnY
FollowedUpByCcadvarcharYYYYYY
FondaparinuxCcadvarcharnYYYYY
GenderCcadvarcharYYYYYY
Gp_pctCodeCcadvarcharnYYYYn
GPPCTcodeCCADvarcharnnnnnY
GpPracticeCodeCcadvarcharYnnnnn
HaemoglobinCcadfloatnYYYYY
HeartFailureCcadvarcharYYYYYY
HeartRateCcadintYYYYYY
HeightCcadfloatYYYYYY
HospitalCentreCodevarcharYYYYYY
HospitalRefferedFromvarcharnYYnYY
HospitalTagvarcharYYYYYY
HypercholesterolaemiaCcadvarcharYYYYYY
HypertensionCcadvarcharYYYYYY
ImportLinkIdintnnYnYY
ImportLinkIdvarcharnnYnYY
IncludeC2nvarcharnnnYYn
IncludeInCallToNeedlevarcharnYYnnY
IncludeinD2NvarcharnYYYYY
InitialDiagnosisCcadvarcharYYYYYY
InitialreperfusiontreatmentCCADvarcharnYYYYY
InPatientManagementOfHyperglycaemia_diabetesCcadvarcharnYYYYn
InpatientmanagementofhyperglycaemiadiabetesCCADvarcharnnnnnY
IntendedreprofusionprocedureCCADvarcharnnYnYY
InterventionalCentreCodeCcadvarcharnYYYYY
Iv2b_3aAgentCcadvarcharYYYYYn
IV2b3aAgentCCADvarcharnnnnnY
IVbetablockerCCADvarcharYYYYYY
IvNitrateCcadvarcharYYYYYY
KillipClassvarcharnnnnnY
LeftventricularejectionfractionCCADvarcharYYYYYY
LocalAngioDateCcaddatenYYYYY
LocalAngioDateCcaddatetimenYYYYY
LocalinterventiondateCCADdatenYYYYY
LocalInterventionDateCcaddatetimenYYYYY
LoopDiureticCcadvarcharYYYYYY
LowmolecularweightheparinCCADvarcharYYYYYY
MedicalRecordNumberAtTimeOfEntryCcadvarcharYYYYYY
MethodofAdmissionCCADvarcharYYYYYY
ModeOfDischargeCcadvarcharYnnnnn
Mustafa1intnnnYYn
Mustafa2intnnnYYn
NextEntryintYYYYYY
NHSNumberVerificationStatusvarcharnnnnnY
NitratesvarcharYYYYYY
NitrateUsevarcharYYYYYY
NSAIDusevarcharYYYYYY
OnsetOfSymptomsCcadvarcharYYYYYY
OralBetaBlockerCcadvarcharnnYnYY
OralNitratesCcadvarcharYYYYYY
OthervarcharYYYYYY
OtherAdmissionDiagnosisvarcharYYYYYY
OtherCommentsvarcharnYYnnY
OtherDischargeDiagnosisvarcharYYYYYY
OtherOralAntiplateletAgentCcadvarcharYYYYYn
OtheroralantiplateletagentOLDvarcharnnnnnY
OutcomeofArrestCCADvarcharYYYYYY
PatientAdminStatusCcadvarcharYYYYYY
PatientCaseRecordNumberAtReferralCentreCcadvarcharYnnnnn
PatientCaseRecordNumberAtReferringHospitalCcadvarcharnYYYYY
PatientEthnicGroupvarcharnYYYYY
PatientIdintYYYYYY
PatientLocationAtTimeOfStemiOnsetvarcharnnYnYY
PCTcodevarcharYYYYYY
PeakCreatinineKinase_ck_CcadfloatYYYYYn
PeakCreatinineKinaseCKOLDfloatnnnnnY
PeakTroponinCCADfloatYYYYYY
PeripheralVascularDiseaseCcadvarcharYYYYYY
PickuppostcodevarcharYYYYYY
PlaceFirst12LeadEcgPerformedCcadvarcharYYYYYY
PotassiumChannelModulatorCCADvarcharYYYYYY
PreAlertCallvarcharYYYYYY
PreviousAMICCADvarcharYYYYYY
PreviousAnginaCcadvarcharYYYYYY
PreviousCABGCCADvarcharYYYYYY
PreviousEntryintYYYYYY
PreviousPCICCADvarcharYYYYYY
ProcedurePerformedCcadvarcharnnYnYY
RadionuclidestudyCCADvarcharYYYYYY
ReasonReperfusionTreatmentNotGivenCcadvarcharnYYYYY
ReasonThrombolyticTreatmentNotGivenCcadvarcharYnnnnn
RecommendedTherapyAtDischargeCcadvarcharYnnnnn
ReferralCentreCcadvarcharYnnnnn
ReferringHospitalCcadvarcharYnnnnn
ReferringHospitalCodeCcadvarcharnYYYYY
ReinfarctionCcadvarcharYYYYYY
SecondMustafa2intnYYnnY
SerumCholesterolCCADfloatYYYYYY
SerumGlucoseCcadfloatnYYYYY
SiteofinfarctionCCADvarcharnYYYYY
SmokingCessationAdviceGivenCcadvarcharnnYnYY
SmokingStatusCCADvarcharYYYYYY
SpironolactonevarcharYYYYYY
SpironolactoneCcadvarcharYYYYYn
SpironolactoneOLDvarcharnnnnnY
StartOfReperfusionTreatmentCcadvarcharYnnnnn
StatinUseCcadvarcharYYYYYY
SystolicBpCcadintYYYYYY
ThiazideDiureticCcadvarcharYYYYYY
ThienopyridinePlateletInhibitorCcadvarcharYYYYYY
ThienopyridineuseCCADvarcharnnnnnY
ThrombolyticDrugCCADvarcharYYYYYY
TimeFromAdmissionToFirstEcgfloatnnYnYY
TimeleftscenevarcharYYYYYY
TimeofAdmissiontoCCUdatetimenYYYYn
TimeofAdmissiontoCCUtimenYYYYn
TimeOfEntrytimennnnnY
TimeofHospitalAdmissiondatetimeYnnnnn
TotalTimeOnScenefloatYYYYYY
TroponinAssayCcadvarcharYYYYYY
TroponinReferenceValuevarcharYYYYYY
UnfractionatedHeparinCcadvarcharYYYYYY
WarfarinvarcharYYYYYY
WarfarinCcadvarcharYYYYYY
WasReperfusionAttempted_CcadvarcharYnnnnn
WeightCcadfloatYYYYYY
WhatProcedureWasPerformedAtTheInterventionalHospitvarcharnnYnYY
WhereWasAspirin_otherAntiplateletGivenCcadvarcharYYYYYn
WherewasAspirinotherantiplateletgivenCCADvarcharnnnnnY
WhereWasInitialReperfusionTreatmentGiven_CcadvarcharYYYYYn
WherewasinitialreperfusiontreatmentgivenCCADvarcharnnnnnY
WhoTookTheInitialDecisionToAttemptReperfusion_CcadvarcharYYYYYn
WhotooktheinitialdecisiontoattemptreperfusionOLDvarcharnnnnnY
WhyWasNoAngiogramPerformed_CcadvarcharnnYnYn
WhywasnoangiogramperformedCCADvarcharnnnnnY
WhywasnointerventionperformedCCADvarcharnnYnYY
Note: See TracWiki for help on using the wiki.