wiki:i2b2 - UHL clinical informatics system integration PATS GGHMINAPNEW

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

--

back

Start Date Field: DateofAdmissiontoCCU

Field NameColumn IDTypeComments
EntryId1intIgnored For Field Name
PatientId2intIgnored For Field Name
!DateofAdmissiontoCCU3datetimeIgnored For Datatype
!TimeofAdmissiontoCCU4datetimeIgnored For Datatype
EntryStatus5varchar
PreviousEntry6intIgnored For Field Name
NextEntry7intIgnored For Field Name
OnsetOfSymptomsCcad8varcharIgnored For No Enum
MethodOfAdmissionCcad9varchar
CallForHelpCcad10varcharIgnored For No Enum
ArrivalOfEmergencyServiceCcad11varcharIgnored For No Enum
ArrivalAtHospitalCcad12varcharIgnored For No Enum
DateAndTimeOfReperfusionTreatmentCcad13varcharIgnored For No Enum
FirstCardiacArrestCcad14varcharIgnored For No Enum
CardiacArrestLocationCcad15varchar
ArrestPresentingRhythmCcad16varchar
OutcomeOfArrestCcad17varchar
InitialDiagnosisCcad18varchar
EcgDeterminingTreatmentCcad19varchar
AdditionalReperfusionTreatmentCcad20varchar
WhereWasInitialReperfusionTreatmentGiven_Ccad21varchar
WhoTookTheInitialDecisionToAttemptReperfusion_Ccad22varchar
ReasonReperfusionTreatmentNotGivenCcad23varchar
Age24int
WhereWasAspirin_otherAntiplateletGivenCcad25varchar
AdmissionWardCcad26varchar
AdmittingConsultantCcad27varchar
DischargeDiagnosisCcad28varchar
DeathInHospitalCcad29varchar
DateOfDischargeOrDeathCcad30datetimeIgnored For Datatype
DischargedOnBetaBlockerCcad31varchar
AceInhibitorCcad32varchar
DischargedOnStatinCcad33varchar
DischargedOnAspirinOrOtherPlateletDrugCcad34varchar
CardiacRehabilitationCcad35varchar
ExerciseTestPerformedCcad36varchar
EchocardiographyCcad37varchar
RadionuclideStudyCcad38varchar
CoronaryAngiographyCcad39varchar
CoronaryInterventionCcad40varchar
GenderCcad41varchar
DelayBeforeTreatmentCcad42varchar
DaysInHospital43int
DelayFromOnsetOfSymptomsToCallForHelp44float
DelayFromCallForHelpToArrivalOfEmergencyServices45float
DelayFromCallForHelpToArrivalInHospital46float
DelayFromArrivalInHospitalToReperfusionTreatment47float
DelayFromCallForHelpToReperfusionTreatment48float
DelayFromOnsetOfSymptomsToReperfusionTreatment49float
AmbulanceJobNumberCcad50varcharIgnored For No Enum
PeakCreatinineKinase_ck_Ccad51float
PeakTroponinCcad52float
TroponinAssayCcad53varchar
TroponinReferenceValue54varchar
PatientAdminStatusCcad55varchar
PreviousAmiCcad56varchar
PreviousAnginaCcad57varchar
HypertensionCcad58varchar
HypercholesterolaemiaCcad59varchar
PeripheralVascularDiseaseCcad60varchar
CerebrovascularDiseaseCcad61varchar
AsthmaOrCopdCcad62varchar
ChronicRenalFailureCcad63varchar
HeartFailureCcad64varchar
CardiacEnzymes_markersRaisedCcad65varchar
SerumCholesterolCcad66float
SmokingStatusCcad67varchar
DiabetesCcad68varchar
PreviousPciCcad69varchar
PreviousCabgCcad70varchar
SystolicBpCcad71int
HeartRateCcad72int
ArrivalOfFirstProfessionalHelpCcad73varcharIgnored For No Enum
UnfractionatedHeparinCcad74varchar
LowMolecularWeightHeparinCcad75varchar
ThienopyridinePlateletInhibitorCcad76varchar
OtherOralAntiplateletAgentCcad77varchar
Iv2b_3aAgentCcad78varchar
IvBetaBlockerCcad79varchar
CalciumChannelBlockerCcad80varchar
IvNitrateCcad81varchar
OralNitratesCcad82varchar
PotassiumChannelModulatorCcad83varchar
WarfarinCcad84varchar
AngiotensinIiBlocker_arb_Ccad85varchar
ThiazideDiureticCcad86varchar
LoopDiureticCcad87varchar
SpironolactoneCcad88varchar
ThrombolyticDrugCcad89varchar
BleedingComplicationsCcad90varchar
DischargeDestinationCcad91varchar
DateOfReferralForInvestigation_intervention92datetimeIgnored For Datatype
DaycaseTransferDateCcad93datetimeIgnored For Datatype
LocalAngioDateCcad94datetimeIgnored For Datatype
LocalInterventionDateCcad95datetimeIgnored For Datatype
InterventionalCentreCodeCcad96varchar
OtherAdmissionDiagnosis97varchar
OtherDischargeDiagnosis98varchar
DischargedFromCcuDestination99varchar
Gp_pctCodeCcad100varcharIgnored For No Enum
DelayFromReferralForInvestigation_interventionToTr101float
PctCode102varcharIgnored For No Enum
MedicalRecordNumberAtTimeOfEntryCcad103varcharIgnored For No Enum
SerumGlucoseCcad104float
DiabeticTherapyAtDischargeCcad105varchar
AuditTrail106varchar
PlaceFirst12LeadEcgPerformedCcad107varchar
BetaBlockerUseCcad108varchar
Ace1OrArbUseCcad109varchar
StatinUseCcad110varchar
ClopidogrelUseCcad111varchar
HeightCcad112float
WeightCcad113float
LeftVentricularEjectionFractionCcad114varchar
FamilyHistoryOfChdCcad115varchar
FollowedUpByCcad116varchar
ReinfarctionCcad117varchar
DischargedOnClopidogrelCcad118varchar
ReferringHospitalCodeCcad119varchar
PatientCaseRecordNumberAtReferringHospitalCcad120varcharIgnored For No Enum
AmbulanceDriver121varchar
AmbulanceAttendant122varchar
AmbulanceResponder123varchar
Comments124varchar
PreAlertCall125varchar
PickUpPostCode126varcharIgnored For No Enum
CardiacNurseInAttendance127varchar
Cox_2InhibitorUse128varchar
NsaidUse129varchar
NitrateUse130varchar
CalciumChannelBlockerUse131varchar
Spironolactone132varchar
Eplerenone133varchar
Nitrates134varchar
Warfarin135varchar
Other136varchar
TimeLeftScene137varcharIgnored For No Enum
HospitalCentreCode138varchar
TotalTimeOnScene139float
DateAndTimeOfFirstDiagnosticEcg140varcharIgnored For No Enum
CardiologicalCareDuringAdmissionCcad141varchar
CreatinineCcad142float
HaemoglobinCcad143float
SiteOfInfarctionCcad144varchar
FondaparinuxCcad145varchar
InitialReperfusionTreatmentCcad146varchar
InPatientManagementOfHyperglycaemia_diabetesCcad147varchar
DateOfReturnToReferringHospital148datetimeIgnored For Datatype
DelayForCallToFrv149float
DelayFrvToFullCrew150float
DelayCallToDepart151float
PatientEthnicGroup152varchar
IncludeInD2n153varchar
OtherComments154varcharIgnored For No Enum
CathLabArrivalTime155varchar
BalloonTime156varchar
DelayCcuToLab157float
DelayCallToBalloon158float
DelayDoorToBalloon159float
DelayLabToBalloon160float
IncludeInCallToNeedle161varchar
HospitalRefferedFrom162varchar
FirstMustafa1163int
SecondMustafa2164int
DaysFromAdmissionToDeath165int
DateOfCurrentStatus166datetimeIgnored For Datatype
DateOfEndStatus167datetimeIgnored For Datatype
DateTimeRecordCreated168datetimeIgnored For Datatype
DateTimeRecordLastChanged169datetimeIgnored For Datatype
EnteredByTag170varchar
EntryCurrentStatus171varchar
EntryEndStatus172varchar
HospitalTag173varchar
Note: See TracWiki for help on using the wiki.