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

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

--

back

Start Date Field: DateofHospitalAdmission

EntryIdintIgnored For Field NameY
PatientIdintIgnored For Field NameY
DateofHospitalAdmissiondatetimeIgnored For DatatypeY
TimeofHospitalAdmissiondatetimeIgnored For DatatypeY
EntryStatusvarchar Y
PreviousEntryintIgnored For Field NameY
NextEntryintIgnored For Field NameY
Ageint Y
DateOfAdmissionToCcudatetimeIgnored For DatatypeY
DirectAdmissionvarchar Y
GenderCcadvarchar Y
EthnicOriginCcadvarchar Y
PatientAdminStatusCcadvarchar Y
HospitalCentreCodevarchar Y
GpPracticeCodeCcadvarcharIgnored For No EnumY
InitialDiagnosisCcadvarchar Y
OtherAdmissionDiagnosisvarchar Y
MethodOfAdmissionCcadvarchar Y
EcgDeterminingTreatmentCcadvarchar Y
WhereWasAspirin_otherAntiplateletGivenCcadvarchar Y
PreviousAmiCcadvarchar Y
PreviousAnginaCcadvarchar Y
HypertensionCcadvarchar Y
HypercholesterolaemiaCcadvarchar Y
PeripheralVascularDiseaseCcadvarchar Y
CerebrovascularDiseaseCcadvarchar Y
AsthmaOrCopdCcadvarchar Y
ChronicRenalFailureCcadvarchar Y
HeartFailureCcadvarchar Y
CardiacEnzymes_markersRaisedCcadvarchar Y
SerumCholesterolCcadfloat Y
SmokingStatusCcadvarchar Y
DiabetesCcadvarchar Y
PreviousPciCcadvarchar Y
PreviousCabgCcadvarchar Y
SystolicBpCcadint Y
HeartRateCcadint Y
AdmittingConsultantCcadvarchar Y
PlaceFirst12LeadEcgPerformedCcadvarchar Y
BetaBlockerUseCcadvarchar Y
Ace1OrArbUseCcadvarchar Y
StatinUseCcadvarchar Y
ClopidogrelUseCcadvarchar Y
HeightCcadfloat Y
WeightCcadfloat Y
LeftVentricularEjectionFractionCcadvarchar Y
FamilyHistoryOfChdCcadvarchar Y
AmbulanceDrivervarchar Y
AmbulanceAttendantvarchar Y
AmbulanceRespondervarchar Y
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_Ccadvarchar Y
ReasonThrombolyticTreatmentNotGivenCcadvarchar Y
StartOfReperfusionTreatmentCcadvarcharIgnored For No EnumY
DelayBeforeTreatmentCcadvarchar Y
WhereWasInitialReperfusionTreatmentGiven_Ccadvarchar Y
WhoTookTheInitialDecisionToAttemptReperfusion_Ccadvarchar Y
FirstCardiacArrestCcadvarcharIgnored For No EnumY
CardiacArrestCcadvarchar Y
ArrestPresentingRhythmCcadvarchar Y
OutcomeOfArrestCcadvarchar Y
AdmissionWardCcadvarchar Y
PeakCreatinineKinase_ck_Ccadfloat Y
PeakTroponinCcadfloat Y
TroponinAssayCcadvarchar Y
TroponinReferenceValuevarchar Y
UnfractionatedHeparinCcadvarchar Y
LowMolecularWeightHeparinCcadvarchar Y
ThienopyridinePlateletInhibitorCcadvarchar Y
OtherOralAntiplateletAgentCcadvarchar Y
Iv2b_3aAgentCcadvarchar Y
IvBetaBlockerCcadvarchar Y
CalciumChannelBlockerCcadvarchar Y
IvNitrateCcadvarchar Y
OralNitratesCcadvarchar Y
PotassiumChannelModulatorCcadvarchar Y
WarfarinCcadvarchar Y
AngiotensinIiBlocker_arb_Ccadvarchar Y
ThiazideDiureticCcadvarchar Y
AdmissionPlasmaGlucoseCcadfloat Y
LoopDiureticCcadvarchar Y
SpironolactoneCcadvarchar Y
ThrombolyticDrugCcadvarchar Y
DateOfDischargeOrDeathCcaddatetimeIgnored For DatatypeY
DateOfDischargeFromCcudatetimeIgnored For DatatypeY
DischargedFromCcuDestinationvarchar Y
DischargeDiagnosisCcadvarchar Y
OtherDischargeDiagnosisvarchar Y
DiagamiCcadvarchar Y
RecommendedTherapyAtDischargeCcadvarchar Y
DaysInHospitalint Y
DaysInCcuint Y
BleedingComplicationsCcadvarchar Y
DeathInHospitalCcadvarchar Y
DischargedOnBetaBlockerCcadvarchar Y
AceInhibitorCcadvarchar Y
DischargedOnStatinCcadvarchar Y
DischargedOnAspirinOrOtherPlateletDrugCcadvarchar Y
CardiacRehabilitationCcadvarchar Y
ExerciseTestPerformedCcadvarchar Y
EchocardiographyCcadvarchar Y
RadionuclideStudyCcadvarchar Y
CoronaryAngiographyAtThisAdmissionCcadvarchar Y
CoronaryInterventionPerformedAtThisAdmissionCcadvarchar Y
DateOfReferralForInvestigation_interventiondatetimeIgnored For DatatypeY
ModeOfDischargeCcadvarchar Y
DateOfTransferForDayCaseInvestigationCcaddatetimeIgnored For DatatypeY
DateOfAngioPerformedLocallyCcaddatetimeIgnored For DatatypeY
DateOfFirstInterventionOrSurgeryPerformedLocallyCcdatetimeIgnored For DatatypeY
ReferralCentreCcadvarchar Y
ReferringHospitalCcadvarchar Y
PatientCaseRecordNumberAtReferralCentreCcadvarcharIgnored For No EnumY
FollowedUpByCcadvarchar Y
ReinfarctionCcadvarchar Y
DischargedOnClopidogrelCcadvarchar Y
DelayFromOnsetOfSymptomsToCallForHelpfloat Y
DelayFromCallForHelpToArrivalOfEmergencyServicesfloat Y
DelayFromCallForHelpToArrivalInHospitalfloat Y
DelayFromArrivalInHospitalToReperfusionTreatmentfloat Y
DelayFromCallForHelpToReperfusionTreatmentfloat Y
DelayFromOnsetOfSymptomsToReperfusionTreatmentfloat Y
TotalTimeOnScenefloat Y
DelayFromReferralForInvestigation_interventionToTrfloat Y
PctCodevarcharIgnored For No EnumY
MedicalRecordNumberAtTimeOfEntryCcadvarcharIgnored For No EnumY
CommentsvarcharIgnored For No EnumY
PreAlertCallvarchar Y
PickUpPostCodevarcharIgnored For No EnumY
CardiacNurseInAttendancevarchar Y
Cox_2InhibitorUsevarchar Y
NsaidUsevarchar Y
NitrateUsevarchar Y
CalciumChannelBlockerUsevarchar Y
Spironolactonevarchar Y
Eplerenonevarchar Y
Nitratesvarchar Y
Warfarinvarchar Y
Othervarchar Y
DateAndTimeOfFirstDiagnosticEcgvarchar Y
AuditTrailvarchar Y
DaysFromAdmissionToDeathint Y
DateOfCurrentStatusdatetimeIgnored For DatatypeY
DateOfEndStatusdatetimeIgnored For DatatypeY
DateTimeRecordCreateddatetimeIgnored For DatatypeY
DateTimeRecordLastChangeddatetimeIgnored For DatatypeY
EnteredByTagvarchar Y
EntryCurrentStatusvarchar Y
EntryEndStatusvarchar Y
HospitalTagvarchar Y
Note: See TracWiki for help on using the wiki.