wiki:i2b2 - UHL clinical informatics system integration PATS CS2010F_PostProcedure

back

Start Date Field: DateOfDischargeOrDeath

Field NameColumn IDTypeComments
EntryId1intIgnored For Field Name
PatientId2intIgnored For Field Name
PreOperativeStayInDays3int
PostOperativeStayInDays4int
TotalStayInDays5int
ParsonnetScoreFromHardData6int
CardiopulmonaryBypass7varchar
ParsonnetScoreWithCatastrophicStatesAndRareConditi8int
PredominantMethodOfMyocardialProtection9varchar
Parsonnet_AdditionsForCatastrophicStates10int
Parsonnet_AdditionsForRareConditions11int
AdditiveEuroscore12int
SctsComplexCabgBayesScore13float
LogisticEuroscore14float
Cardioplegia_Solution15varchar
Cardioplegia_Temperature16varchar
Cardioplegia_Timing17varchar
Non_CardioplegicMyocardialProtection18varchar
IntraAorticBalloonPumpUsed19varchar
ReasonForIntra_OperativeIntra_AorticBalloonPumpUse20varchar
HeightInCm21int
WeightInKg22float
CumulativeBypassTime23int
CumulativeCrossClampTime24int
TotalCirculatoryArrestTime25int
NewPost_OperativeNeurologicalDysfunction26varchar
NewHaemofiltrationOrDialysis27varchar
DischargeDestinationFromCardiothoracicWard28varchar
DateOfDischargeOrDeath29dateIgnored For Datatype
BodySurfaceArea30float
BodyMassIndex31float
Cardioplegia_InfusionMode32varchar
EuroscoreMinumumDatasetCheck33varchar
ParsonnetMinumumDatasetCheck34varchar
NameOfGpAtTimeOfSurgery35varchar
GpPracticeCodeAtTimeOfSurgery36varchar
PctAtTimeOfSurgery37varchar
NameOfReferringGpAtTimeOfSurgeryType838varcharIgnored For No Enum
ToePerformed39varchar
Sonographer40varchar
Sonographist41varchar
PrimaryPerfusionist42varchar
PcuPatient_pcu43varchar
DoesPatientMeetInterOperativeCriteria_pcu44varchar
AreaPatientAdmittedTo_pcu45varchar
AdmissionTimeToRecovery_cicu_pcu46varchar
ExtubationDateAndTime_pcu47varchar
WhatO2SystemWasUsed_pcu48varchar
TotalBloodLostOnDischargeFromRecovery_pcu49varchar
WereClottingProductsUsed_pcu50varchar
WhatProductsWereUsed_pcu51varchar
HowMuchColloidUsedInRecovery_pcu52varchar
TypeOfColloidUsed_pcu53varchar
PainScoreOnWaking_pcu54varchar
AnalgesiaUsedPcu55varchar
TotalMorphineDoseUsedIncludingBolus_pcu56varchar
InotropesUsed_pcu57varchar
Dosage_pcu58varchar
WereThereAnyArrhythmias_pcu59varchar
PleaseStateArrhythmias_pcu60varchar
TreatmentOfArrhythmias_pcu61varchar
PotassiumUsed_pcu62varchar
PotassiumDoseInMmols_pcu63varchar
TemperatureOnAdmission_pcu64float
BairhuggerWithPatient_pcu65varchar
TimeOfDischarge_pcu66varchar
PlaceOfDischarge_pcu67varchar
DoesPatientMeetDischargeCriteria_pcu68varchar
WasPatientDischargedFromPcuToHdu_pcu69varchar
LowUrineOutput_pcu70varchar
IfNoStateWhy_pcu71varchar
IfNoWhy_pcu72varchar
AmountOfTimeIntubated_pcu73float
AmountOfTimeInRecovery_cicu_pcu74float
OverallComments_sa75textIgnored For Datatype
TeachingOfOtherStaffComments_sa76varchar
TeachingOfOtherStaffCommentsMade_sa77varchar
TeachingOfOtherStaffBySa_sa78varchar
IabpRemovalComments_sa79textIgnored For Datatype
IabpRemovalCommentsMade_sa80varchar
IabpRemovalBySa_sa81varchar
IabpInsertionComments_sa82textIgnored For Datatype
IabpInsertionCommentsMade_sa83varchar
IabpInsertionBySa_sa84varchar
SternotomyClosureComments_sa85textIgnored For Datatype
SternotomyClosureCommentsMade_sa86varchar
SternotomyClosureBySa_sa87varchar
SternotomyComments_sa88varchar
SternotomyCommentsMade_sa89varchar
SternotomyPerformedBySa_sa90varchar
ThirdSiteComments_sa91varchar
ThirdSiteCommentsMade_sa92varchar
ThirdSiteConduit_location_sa93varchar
SecondSiteComments_sa94varchar
SecondSiteCommentsMade_sa95varchar
SecondSiteConduit_location_sa96varchar
FirstSiteComments_sa97varchar
FirstSiteCommentsMade_sa98varchar
FirstSiteConduei_location_sa99varchar
ThirdAssistant_sa100varchar
SecondAssistant_sa101varchar
FirstAssistant_sa102varchar
SurgicalAssistant_sa103varchar
ReferralToOperation_days104float
Arrhythmia_S105varchar
LowCardiacOutput106varchar
Ventilation107varchar
PulmonaryComplications108varchar
RenalComplications109varchar
GastrointestinalComplications110varchar
InfectiveComplications111varchar
CauseOfDeath112varchar
AdmittedFrom_hospitalNameOrWard113varchar
AdmittedToCardiacSurgery114dateIgnored For Datatype
DischargedFromCardiacSurgery115dateIgnored For Datatype
TotalCardiacSurgeryLosDays116float
DateOfFollowUp117dateIgnored For Datatype
BloodUsed118varchar
MutisystemFailure119varchar
DateFirstAdmittedToCicu120dateIgnored For Datatype
DateFirstDischargedFromCicu121dateIgnored For Datatype
TotalFirstStayOnCicu122float
ReAdmittedToCicu123varchar
DateOfSecondAdmissionToCicu124dateIgnored For Datatype
DateOfSecondDischargeFromCicu125dateIgnored For Datatype
SecondAdmissionTotalStay_nignts126float
DateOfThirdAdmissionToCicu127dateIgnored For Datatype
DateOfThirdDischargeFromCicu128dateIgnored For Datatype
ThirdAdmissionToCicuTotalStay_nights129float
InsertionOfPacemakerWiresViaVatsProcedure130varchar
IntubationTimeInHours131int
AuditTrail132textIgnored For Datatype
NameOfDoctorCompletingBooklet133varchar
SecondPrimaryPerfusionist134varchar
SecondBypass135varchar
SecondMyocardialProtection136varchar
SecondCardioplegiaSolution137varchar
SecondCardioplegiaInfusion138varchar
SecondCardioplegiaTemperature139varchar
SecondCardioplegiaTiming140varchar
SecondNon_CardioplegiaMyocardialProtection141varchar
!DoesPatientNeedAFollowUpAppiontment142varchar
Comments143varcharIgnored For No Enum
MedicalRecordNumber144varchar
DateAddedToW_l145dateIgnored For Datatype
AddedToW_l146varchar
DateOfFourthAdmissionToCicu147dateIgnored For Datatype
DateOfFourthDischargeFromCicu148dateIgnored For Datatype
DateOfFifthAdmissionToCicu149dateIgnored For Datatype
DateOfFifthDischargeFromCicu150dateIgnored For Datatype
CumulativeStayFirstAndSecondAdmissionToCicu151float
Cumulative1st2ndAnd3rdStayInCicu152float
FourthAdmissionToCicuTotalStay_nights153float
Cumulative1st2nd3rd4thStayInCicu154float
FifthAdmissionToCicuTotalStay_nights155float
Cumulative1sr2nd3rd4th5thStayInCicu156float
PatientIdentifiedForSamedayAdmission157varchar
ProposedDateOfAdmission158dateIgnored For Datatype
SecondBypassTotal159int
SecondCrossClampTotal160int
SecondCiculatoryArrestTotal161int
CouncilCase162varchar
InitialConsultantInJointCase163varchar
ArrhythmiaOtherComplicationFreeText164textIgnored For Datatype
LowCardiacOutputOtherComplicationFreeText165textIgnored For Datatype
PulmonaryOtherComplicationFreeText166textIgnored For Datatype
RenalOtherComplicationFreeText167textIgnored For Datatype
GastrointestinalOtherComplicationFreeText168textIgnored For Datatype
InfectiveOtherComplicationFreeText169varchar
SickNoteOffered170varchar
IfSickNoteOfferedDurationInDays171int
AdviceToGp172varcharIgnored For No Enum
NameOfDischargingDoctor173varchar
GradeOfDischargingDoctor174varchar
PagerNumber175varchar
DrugSensitivity176varcharIgnored For No Enum
Drug1177varcharIgnored For No Enum
DrugRoute1178varchar
NumberOfDays1179int
Continue1180varchar
Drug2181varcharIgnored For No Enum
DrugRoute2182varchar
NumberOfDays2183int
Continue2184varchar
Drug3185varcharIgnored For No Enum
DrugRoute3186varchar
NumberOfDays3187int
Continue3188varchar
Drug4189varcharIgnored For No Enum
DrugRoute4190varchar
NumberOfDays4191int
Continue4192varchar
Drug5193varcharIgnored For No Enum
DrugRoute5194varchar
NumberOfDays5195int
Continue5196varchar
Drug6197varcharIgnored For No Enum
DrugRoute6198varchar
NumberOfDays6199int
Continue6200varchar
Drug7201varcharIgnored For No Enum
DrugRoute7202varchar
NumberOfDays7203int
Continue7204varchar
Drug8205varcharIgnored For No Enum
DrugRoute8206varchar
NumberOfDays8207int
Continue8208varchar
Drug9209varcharIgnored For No Enum
DrugRoute9210varchar
NumberOfDays9211int
Continue9212varchar
Drug10213varcharIgnored For No Enum
DrugRoute10214varchar
NumberOfDays10215int
Continue10216varchar
Drug11217varchar
DrugRoute11218varchar
NumberOfDays11219int
Continue11220varchar
Drug12221varchar
DrugRoute12222varchar
NumberOfDays12223int
Continue12224varchar
Drug13225varchar
DrugRoute13226varchar
NumberOfDays13227int
Continue13228varchar
Drug14229varchar
DrugRoute14230varchar
NumberOfDays14231int
Continue14232varchar
Drug15233varchar
DrugRoute15234varchar
NumberOfDays15235int
Continue15236varchar
Drug16237varchar
DrugRoute16238varchar
NumberOfDays16239int
Continue16240varchar
Drug17241varchar
DrugRoute17242varchar
NumberOfDays17243int
Continue17244varchar
Drug18245varchar
DrugRoute18246varchar
NumberOfDays18247int
Continue18248varchar
DrugNameAndStrength19249varcharIgnored For No Enum
DrugForm19250varchar
DrugDose19251varcharIgnored For No Enum
DrugRoute19252varchar
DrugFrequency19253varchar
NumberOfDays19254int
Continue19255varchar
DrugNameAndStrength20256varcharIgnored For No Enum
DrugForm20257varchar
DrugDose20258varcharIgnored For No Enum
DrugRoute20259varchar
DrugFrequency20260varchar
NumberOfDays20261int
Continue20262varchar
DrugNameAndStrength21263varchar
DrugForm21264varchar
DrugDose21265varchar
DrugRoute21266varchar
DrugFrequency21267varchar
NumberOfDays21268int
Continue21269varchar
DrugNameAndStrength22270varchar
DrugForm22271varchar
DrugDose22272varchar
DrugRoute22273varchar
DrugFrequency22274varchar
NumberOfDays22275int
Continue22276varchar
DrugNameAndStrength23277varchar
DrugForm23278varchar
DrugDose23279varchar
DrugRoute23280varchar
DrugFrequency23281varchar
NumberOfDays23282int
Continue23283varchar
DrugNameAndStrength24284varchar
DrugForm24285varchar
DrugDose24286varchar
DrugRoute24287varchar
DrugFrequency24288varchar
NumberOfDays24289int
Continue24290varchar
DischargeWard291varchar
Pharmacist292varchar
ManagementPlan293varcharIgnored For No Enum
FollowUpRequired294varchar
FollowUpTimeInWeeks_months295varchar
MedicationChangedByPharmacist296varchar
StatePharmacistChanges297textIgnored For Datatype
InformationGivenToPatient298varcharIgnored For No Enum
DateTimeRecordCreated299varcharIgnored For No Enum
DateTimeRecordLastChanged300varcharIgnored For No Enum
EnteredByTag301varchar
HospitalTag302varchar
Last modified 10 years ago Last modified on 03/15/13 08:52:48
Note: See TracWiki for help on using the wiki.