wiki:i2b2 - UHL clinical informatics system integration PATS GGHMINAP_GGHMINAP

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

--

back

Start Date Field: DateofHospitalAdmission

Field NameColumn IDTypeComments
EntryId1intIgnored For Field Name
PatientId2intIgnored For Field Name
DateofHospitalAdmission3datetimeIgnored For Datatype
TimeofHospitalAdmission4datetimeIgnored For Datatype
EntryStatus5varchar
PreviousEntry6intIgnored For Field Name
NextEntry7intIgnored For Field Name
Age8int
DateOfAdmissionToCcu9datetimeIgnored For Datatype
DirectAdmission10varchar
GenderCcad11varchar
EthnicOriginCcad12varchar
PatientAdminStatusCcad13varchar
HospitalCentreCode14varchar
GpPracticeCodeCcad15varcharIgnored For No Enum
InitialDiagnosisCcad16varchar
OtherAdmissionDiagnosis17varchar
MethodOfAdmissionCcad18varchar
EcgDeterminingTreatmentCcad19varchar
WhereWasAspirin_otherAntiplateletGivenCcad20varchar
PreviousAmiCcad21varchar
PreviousAnginaCcad22varchar
HypertensionCcad23varchar
HypercholesterolaemiaCcad24varchar
PeripheralVascularDiseaseCcad25varchar
CerebrovascularDiseaseCcad26varchar
AsthmaOrCopdCcad27varchar
ChronicRenalFailureCcad28varchar
HeartFailureCcad29varchar
CardiacEnzymes_markersRaisedCcad30varchar
SerumCholesterolCcad31float
SmokingStatusCcad32varchar
DiabetesCcad33varchar
PreviousPciCcad34varchar
PreviousCabgCcad35varchar
SystolicBpCcad36int
HeartRateCcad37int
AdmittingConsultantCcad38varchar
PlaceFirst12LeadEcgPerformedCcad39varchar
BetaBlockerUseCcad40varchar
Ace1OrArbUseCcad41varchar
StatinUseCcad42varchar
ClopidogrelUseCcad43varchar
HeightCcad44float
WeightCcad45float
LeftVentricularEjectionFractionCcad46varchar
FamilyHistoryOfChdCcad47varchar
AmbulanceDriver48varchar
AmbulanceAttendant49varchar
AmbulanceResponder50varchar
TimeLeftScene51varcharIgnored For No Enum
OnsetOfSymptomsCcad52varcharIgnored For No Enum
CallForHelpCcad53varcharIgnored For No Enum
ArrivalOfFirstProfessionalHelpCcad54varcharIgnored For No Enum
ArrivalOfEmergencyServiceCcad55varcharIgnored For No Enum
AmbulanceJobNumberCcad56varcharIgnored For No Enum
ArrivalAtHospitalCcad57varcharIgnored For No Enum
WasReperfusionAttempted_Ccad58varchar
ReasonThrombolyticTreatmentNotGivenCcad59varchar
StartOfReperfusionTreatmentCcad60varcharIgnored For No Enum
DelayBeforeTreatmentCcad61varchar
WhereWasInitialReperfusionTreatmentGiven_Ccad62varchar
WhoTookTheInitialDecisionToAttemptReperfusion_Ccad63varchar
FirstCardiacArrestCcad64varcharIgnored For No Enum
CardiacArrestCcad65varchar
ArrestPresentingRhythmCcad66varchar
OutcomeOfArrestCcad67varchar
AdmissionWardCcad68varchar
PeakCreatinineKinase_ck_Ccad69float
PeakTroponinCcad70float
TroponinAssayCcad71varchar
TroponinReferenceValue72varchar
UnfractionatedHeparinCcad73varchar
LowMolecularWeightHeparinCcad74varchar
ThienopyridinePlateletInhibitorCcad75varchar
OtherOralAntiplateletAgentCcad76varchar
Iv2b_3aAgentCcad77varchar
IvBetaBlockerCcad78varchar
CalciumChannelBlockerCcad79varchar
IvNitrateCcad80varchar
OralNitratesCcad81varchar
PotassiumChannelModulatorCcad82varchar
WarfarinCcad83varchar
AngiotensinIiBlocker_arb_Ccad84varchar
ThiazideDiureticCcad85varchar
AdmissionPlasmaGlucoseCcad86float
LoopDiureticCcad87varchar
SpironolactoneCcad88varchar
ThrombolyticDrugCcad89varchar
DateOfDischargeOrDeathCcad90datetimeIgnored For Datatype
DateOfDischargeFromCcu91datetimeIgnored For Datatype
DischargedFromCcuDestination92varchar
DischargeDiagnosisCcad93varchar
OtherDischargeDiagnosis94varchar
DiagamiCcad95varchar
RecommendedTherapyAtDischargeCcad96varchar
DaysInHospital97int
DaysInCcu98int
BleedingComplicationsCcad99varchar
DeathInHospitalCcad100varchar
DischargedOnBetaBlockerCcad101varchar
AceInhibitorCcad102varchar
DischargedOnStatinCcad103varchar
DischargedOnAspirinOrOtherPlateletDrugCcad104varchar
CardiacRehabilitationCcad105varchar
ExerciseTestPerformedCcad106varchar
EchocardiographyCcad107varchar
RadionuclideStudyCcad108varchar
CoronaryAngiographyAtThisAdmissionCcad109varchar
CoronaryInterventionPerformedAtThisAdmissionCcad110varchar
DateOfReferralForInvestigation_intervention111datetimeIgnored For Datatype
ModeOfDischargeCcad112varchar
DateOfTransferForDayCaseInvestigationCcad113datetimeIgnored For Datatype
DateOfAngioPerformedLocallyCcad114datetimeIgnored For Datatype
DateOfFirstInterventionOrSurgeryPerformedLocallyCc115datetimeIgnored For Datatype
ReferralCentreCcad116varchar
ReferringHospitalCcad117varchar
PatientCaseRecordNumberAtReferralCentreCcad118varcharIgnored For No Enum
FollowedUpByCcad119varchar
ReinfarctionCcad120varchar
DischargedOnClopidogrelCcad121varchar
DelayFromOnsetOfSymptomsToCallForHelp122float
DelayFromCallForHelpToArrivalOfEmergencyServices123float
DelayFromCallForHelpToArrivalInHospital124float
DelayFromArrivalInHospitalToReperfusionTreatment125float
DelayFromCallForHelpToReperfusionTreatment126float
DelayFromOnsetOfSymptomsToReperfusionTreatment127float
TotalTimeOnScene128float
DelayFromReferralForInvestigation_interventionToTr129float
PctCode130varcharIgnored For No Enum
MedicalRecordNumberAtTimeOfEntryCcad131varcharIgnored For No Enum
Comments132varcharIgnored For No Enum
PreAlertCall133varchar
PickUpPostCode134varcharIgnored For No Enum
CardiacNurseInAttendance135varchar
Cox_2InhibitorUse136varchar
NsaidUse137varchar
NitrateUse138varchar
CalciumChannelBlockerUse139varchar
Spironolactone140varchar
Eplerenone141varchar
Nitrates142varchar
Warfarin143varchar
Other144varchar
DateAndTimeOfFirstDiagnosticEcg145varchar
AuditTrail146varchar
DaysFromAdmissionToDeath147int
DateOfCurrentStatus148datetimeIgnored For Datatype
DateOfEndStatus149datetimeIgnored For Datatype
DateTimeRecordCreated150datetimeIgnored For Datatype
DateTimeRecordLastChanged151datetimeIgnored For Datatype
EnteredByTag152varchar
EntryCurrentStatus153varchar
EntryEndStatus154varchar
HospitalTag155varchar
Note: See TracWiki for help on using the wiki.