wiki:i2b2 - UHL clinical informatics system integration PATS LRIMINAPNEW

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
OtherAdmissionDiagnosis96varchar
OtherDischargeDiagnosis97varchar
DischargedFromCcuDestination98varchar
Gp_pctCodeCcad99varcharIgnored For No Enum
DelayFromReferralForInvestigation_interventionToTr100float
PctCode101varchar
MedicalRecordNumberAtTimeOfEntryCcad102varcharIgnored For No Enum
SerumGlucoseCcad103float
DiabeticTherapyAtDischargeCcad104varchar
AuditTrail105varchar
PlaceFirst12LeadEcgPerformedCcad106varchar
BetaBlockerUseCcad107varchar
Ace1OrArbUseCcad108varchar
StatinUseCcad109varchar
ClopidogrelUseCcad110varchar
HeightCcad111float
WeightCcad112float
LeftVentricularEjectionFractionCcad113varchar
FamilyHistoryOfChdCcad114varchar
FollowedUpByCcad115varchar
ReinfarctionCcad116varchar
DischargedOnClopidogrelCcad117varchar
PatientCaseRecordNumberAtReferringHospitalCcad118varcharIgnored For No Enum
AmbulanceDriver119varchar
AmbulanceAttendant120varchar
AmbulanceResponder121varchar
Comments122varchar
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
DateOfReturnToReferringHospital146datetimeIgnored For Datatype
DelayForCallToFrv147float
DelayFrvToFullCrew148float
DelayCallToDepart149float
PatientEthnicGroup150varchar
IncludeInD2n151varchar
Comments2152varcharIgnored For No Enum
CathLabArrivalTime153varchar
BallonTime154varchar
DelayCcuToLab155float
DelayCallToBalloon156float
DelayDoorToBalloon157float
DelayLabToBalloon158float
IncludeC2n159varchar
InterventionalCentreCodeCcad160varchar
ReferringHospitalCodeCcad161varchar
Mustafa1162int
Mustafa2163int
DaysFromAdmissionToDeath164int
DateOfCurrentStatus165datetimeIgnored For Datatype
DateOfEndStatus166datetimeIgnored For Datatype
DateTimeRecordCreated167datetimeIgnored For Datatype
DateTimeRecordLastChanged168datetimeIgnored For Datatype
EnteredByTag169varchar
EntryCurrentStatus170varchar
EntryEndStatus171varchar
HospitalTag172varchar
Last modified 12 years ago Last modified on 03/15/13 09:04:33
Note: See TracWiki for help on using the wiki.