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

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

--

back

Start Date Field: DateofHospitalAdmission

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