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

Version 4 (modified by Richard Bramley, 11 years ago) ( diff )

--

back

Start Date Field: DateofHospitalAdmission

Field NameTypeCommentsGGHMINAP_GGHMINAP
EntryIdintIgnored For Field NameY
PatientIdintIgnored For Field NameY
DateofHospitalAdmissiondatetimeIgnored For DatatypeY
TimeofHospitalAdmissiondatetimeIgnored For DatatypeY
EntryStatusvarcharY
PreviousEntryintIgnored For Field NameY
NextEntryintIgnored For Field NameY
AgeintY
DateOfAdmissionToCcudatetimeIgnored For DatatypeY
DirectAdmissionvarcharY
GenderCcadvarcharY
EthnicOriginCcadvarcharY
PatientAdminStatusCcadvarcharY
HospitalCentreCodevarcharY
GpPracticeCodeCcadvarcharIgnored For No EnumY
InitialDiagnosisCcadvarcharY
OtherAdmissionDiagnosisvarcharY
MethodOfAdmissionCcadvarcharY
EcgDeterminingTreatmentCcadvarcharY
WhereWasAspirin_otherAntiplateletGivenCcadvarcharY
PreviousAmiCcadvarcharY
PreviousAnginaCcadvarcharY
HypertensionCcadvarcharY
HypercholesterolaemiaCcadvarcharY
PeripheralVascularDiseaseCcadvarcharY
CerebrovascularDiseaseCcadvarcharY
AsthmaOrCopdCcadvarcharY
ChronicRenalFailureCcadvarcharY
HeartFailureCcadvarcharY
CardiacEnzymes_markersRaisedCcadvarcharY
SerumCholesterolCcadfloatY
SmokingStatusCcadvarcharY
DiabetesCcadvarcharY
PreviousPciCcadvarcharY
PreviousCabgCcadvarcharY
SystolicBpCcadintY
HeartRateCcadintY
AdmittingConsultantCcadvarcharY
PlaceFirst12LeadEcgPerformedCcadvarcharY
BetaBlockerUseCcadvarcharY
Ace1OrArbUseCcadvarcharY
StatinUseCcadvarcharY
ClopidogrelUseCcadvarcharY
HeightCcadfloatY
WeightCcadfloatY
LeftVentricularEjectionFractionCcadvarcharY
FamilyHistoryOfChdCcadvarcharY
AmbulanceDrivervarcharY
AmbulanceAttendantvarcharY
AmbulanceRespondervarcharY
TimeLeftScenevarcharIgnored For No EnumY
OnsetOfSymptomsCcadvarcharIgnored For No EnumY
CallForHelpCcadvarcharIgnored For No EnumY
ArrivalOfFirstProfessionalHelpCcadvarcharIgnored For No EnumY
ArrivalOfEmergencyServiceCcadvarcharIgnored For No EnumY
AmbulanceJobNumberCcadvarcharIgnored For No EnumY
ArrivalAtHospitalCcadvarcharIgnored For No EnumY
WasReperfusionAttempted_CcadvarcharY
ReasonThrombolyticTreatmentNotGivenCcadvarcharY
StartOfReperfusionTreatmentCcadvarcharIgnored For No EnumY
DelayBeforeTreatmentCcadvarcharY
WhereWasInitialReperfusionTreatmentGiven_CcadvarcharY
WhoTookTheInitialDecisionToAttemptReperfusion_CcadvarcharY
FirstCardiacArrestCcadvarcharIgnored For No EnumY
CardiacArrestCcadvarcharY
ArrestPresentingRhythmCcadvarcharY
OutcomeOfArrestCcadvarcharY
AdmissionWardCcadvarcharY
PeakCreatinineKinase_ck_CcadfloatY
PeakTroponinCcadfloatY
TroponinAssayCcadvarcharY
TroponinReferenceValuevarcharY
UnfractionatedHeparinCcadvarcharY
LowMolecularWeightHeparinCcadvarcharY
ThienopyridinePlateletInhibitorCcadvarcharY
OtherOralAntiplateletAgentCcadvarcharY
Iv2b_3aAgentCcadvarcharY
IvBetaBlockerCcadvarcharY
CalciumChannelBlockerCcadvarcharY
IvNitrateCcadvarcharY
OralNitratesCcadvarcharY
PotassiumChannelModulatorCcadvarcharY
WarfarinCcadvarcharY
AngiotensinIiBlocker_arb_CcadvarcharY
ThiazideDiureticCcadvarcharY
AdmissionPlasmaGlucoseCcadfloatY
LoopDiureticCcadvarcharY
SpironolactoneCcadvarcharY
ThrombolyticDrugCcadvarcharY
DateOfDischargeOrDeathCcaddatetimeIgnored For DatatypeY
DateOfDischargeFromCcudatetimeIgnored For DatatypeY
DischargedFromCcuDestinationvarcharY
DischargeDiagnosisCcadvarcharY
OtherDischargeDiagnosisvarcharY
DiagamiCcadvarcharY
RecommendedTherapyAtDischargeCcadvarcharY
DaysInHospitalintY
DaysInCcuintY
BleedingComplicationsCcadvarcharY
DeathInHospitalCcadvarcharY
DischargedOnBetaBlockerCcadvarcharY
AceInhibitorCcadvarcharY
DischargedOnStatinCcadvarcharY
DischargedOnAspirinOrOtherPlateletDrugCcadvarcharY
CardiacRehabilitationCcadvarcharY
ExerciseTestPerformedCcadvarcharY
EchocardiographyCcadvarcharY
RadionuclideStudyCcadvarcharY
CoronaryAngiographyAtThisAdmissionCcadvarcharY
CoronaryInterventionPerformedAtThisAdmissionCcadvarcharY
DateOfReferralForInvestigation_interventiondatetimeIgnored For DatatypeY
ModeOfDischargeCcadvarcharY
DateOfTransferForDayCaseInvestigationCcaddatetimeIgnored For DatatypeY
DateOfAngioPerformedLocallyCcaddatetimeIgnored For DatatypeY
DateOfFirstInterventionOrSurgeryPerformedLocallyCcdatetimeIgnored For DatatypeY
ReferralCentreCcadvarcharY
ReferringHospitalCcadvarcharY
PatientCaseRecordNumberAtReferralCentreCcadvarcharIgnored For No EnumY
FollowedUpByCcadvarcharY
ReinfarctionCcadvarcharY
DischargedOnClopidogrelCcadvarcharY
DelayFromOnsetOfSymptomsToCallForHelpfloatY
DelayFromCallForHelpToArrivalOfEmergencyServicesfloatY
DelayFromCallForHelpToArrivalInHospitalfloatY
DelayFromArrivalInHospitalToReperfusionTreatmentfloatY
DelayFromCallForHelpToReperfusionTreatmentfloatY
DelayFromOnsetOfSymptomsToReperfusionTreatmentfloatY
TotalTimeOnScenefloatY
DelayFromReferralForInvestigation_interventionToTrfloatY
PctCodevarcharIgnored For No EnumY
MedicalRecordNumberAtTimeOfEntryCcadvarcharIgnored For No EnumY
CommentsvarcharIgnored For No EnumY
PreAlertCallvarcharY
PickUpPostCodevarcharIgnored For No EnumY
CardiacNurseInAttendancevarcharY
Cox_2InhibitorUsevarcharY
NsaidUsevarcharY
NitrateUsevarcharY
CalciumChannelBlockerUsevarcharY
SpironolactonevarcharY
EplerenonevarcharY
NitratesvarcharY
WarfarinvarcharY
OthervarcharY
DateAndTimeOfFirstDiagnosticEcgvarcharY
AuditTrailvarcharY
DaysFromAdmissionToDeathintY
DateOfCurrentStatusdatetimeIgnored For DatatypeY
DateOfEndStatusdatetimeIgnored For DatatypeY
DateTimeRecordCreateddatetimeIgnored For DatatypeY
DateTimeRecordLastChangeddatetimeIgnored For DatatypeY
EnteredByTagvarcharY
EntryCurrentStatusvarcharY
EntryEndStatusvarcharY
HospitalTagvarcharY
Note: See TracWiki for help on using the wiki.