wiki:i2b2 - UHL clinical informatics system integration PATS GGHMINAPNEW_GGHMINAPINIVW

back

Start Date Field: DateofAdmissiontoCCU

Field NameColumn IDTypeComments
EntryId1intIgnored For Field Name
PatientId2intIgnored For Field Name
!DateofAdmissiontoCCU3dateIgnored For Datatype
!TimeofAdmissiontoCCU4timeIgnored 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
DateOfDischargeOrDeathCcad30dateIgnored 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_intervention92dateIgnored For Datatype
DaycaseTransferDateCcad93dateIgnored For Datatype
LocalAngioDateCcad94dateIgnored For Datatype
LocalInterventionDateCcad95dateIgnored For Datatype
OtherAdmissionDiagnosis96varchar
OtherDischargeDiagnosis97varchar
DischargedFromCcuDestination98varchar
Gp_pctCodeCcad99varcharIgnored For No Enum
DelayFromReferralForInvestigation_interventionToTr100float
PctCode101varcharIgnored For No Enum
MedicalRecordNumberAtTimeOfEntryCcad102varcharIgnored For No Enum
SerumGlucoseCcad103float
DiabeticTherapyAtDischargeCcad104varchar
AuditTrail105textIgnored For Datatype
PlaceFirst12LeadEcgPerformedCcad106varchar
BetaBlockerUseCcad107varchar
Ace1OrArbUseCcad108varchar
StatinUseCcad109varchar
ClopidogrelUseCcad110varchar
HeightCcad111float
WeightCcad112float
LeftVentricularEjectionFractionCcad113varchar
FamilyHistoryOfChdCcad114varchar
FollowedUpByCcad115varchar
ReinfarctionCcad116varchar
DischargedOnClopidogrelCcad117varchar
PatientCaseRecordNumberAtReferringHospitalCcad118varcharIgnored For No Enum
AmbulanceDriver119varchar
AmbulanceAttendant120varchar
AmbulanceResponder121varchar
Comments122textIgnored For Datatype
PreAlertCall123varchar
PickUpPostCode124varcharIgnored For No Enum
CardiacNurseInAttendance125varchar
Cox_2InhibitorUse126varchar
NsaidUse127varchar
NitrateUse128varchar
CalciumChannelBlockerUse129varchar
Spironolactone130varchar
Eplerenone131varchar
Nitrates132varchar
Warfarin133varchar
Other134varchar
TimeLeftScene135varcharIgnored For No Enum
HospitalCentreCode136varchar
TotalTimeOnScene137float
DateAndTimeOfFirstDiagnosticEcg138varcharIgnored For No Enum
CardiologicalCareDuringAdmissionCcad139varchar
CreatinineCcad140float
HaemoglobinCcad141float
SiteOfInfarctionCcad142varchar
FondaparinuxCcad143varchar
InitialReperfusionTreatmentCcad144varchar
InPatientManagementOfHyperglycaemia_diabetesCcad145varchar
DateOfReturnToReferringHospital146dateIgnored For Datatype
DelayForCallToFrv147float
DelayFrvToFullCrew148float
DelayCallToDepart149float
PatientEthnicGroup150varchar
IncludeInD2n151varchar
OtherComments152varcharIgnored For No Enum
CathLabArrivalTime153varchar
BalloonTime154varchar
DelayCcuToLab155float
DelayCallToBalloon156float
DelayDoorToBalloon157float
DelayLabToBalloon158float
IncludeInCallToNeedle159varchar
HospitalRefferedFrom160varchar
FirstMustafa1161int
SecondMustafa2162int
DaysFromAdmissionToDeath163int
InterventionalCentreCodeCcad164varchar
ReferringHospitalCodeCcad165varchar
TimeFromAdmissionToFirstEcg166float
EcgQrsComplexDurationCcad167varchar
AldosteroneAntagonistCcad168varchar
DischargedOnThienopyridineInhibitorCcad169varchar
DischargedOnAnAldosteroneAntagonistCcad170varchar
WhatProcedureWasPerformedAtTheInterventionalHospit171varchar
SmokingCessationAdviceGivenCcad172varchar
DietaryAdviceGivenDuringThisAdmissionCcad173varchar
OralBetaBlockerCcad174varchar
DateAndTimeArrivalAtNonInterventionalHospitalCcad175varcharIgnored For No Enum
AssessmentAtNonInterventionalHospitalCcad176varchar
AssessmentAtInterventionalCentreCcad177varchar
IntendedReprofusionProcedureCcad178varchar
ProcedurePerformedCcad179varchar
WhyWasNoAngiogramPerformed_Ccad180varchar
WhyWasNoInterventionPerformedCcad181varchar
PatientLocationAtTimeOfStemiOnset182varchar
AcsAuditSite183varchar
AcsAuditWard184varchar
AcsAuditHowManyDosesOfLmwh185int
AcsAuditCardiologicalOpinionRequestedDuringAdmissi186varchar
AcsAuditAdmittedFrom187varchar
AcsAuditTimiScore188varchar
AcsAuditRiskStrarification189varchar
AcsAuditDateAndTimeOfEtt190varchar
AcsAuditDateAndTimeOfEcho191varchar
AcsAuditDateAndTimeOfAngiography192varchar
AcsAuditDateAndTimeOfPci_Cabg193varchar
AcsAuditDischargedOnSublingualGtn194varchar
AcsAuditComments195textIgnored For Datatype
DateOfCurrentStatus196dateIgnored For Datatype
DateOfEndStatus197dateIgnored For Datatype
DateTimeRecordCreated198varcharIgnored For No Enum
DateTimeRecordLastChanged199varcharIgnored For No Enum
EnteredByTag200varchar
EntryCurrentStatus201varchar
EntryEndStatus202varchar
HospitalTag203varchar
ImportLinkId204int
Last modified 11 years ago Last modified on 03/15/13 08:59:39
Note: See TracWiki for help on using the wiki.