wiki:i2b2 - UHL clinical informatics system integration PATS CS2003F_PostProcedure

back

Start Date Field: DateOfDischargeOrDeath

Field NameColumn IDTypeComments
EntryId1intIgnored For Field Name
PatientId2intIgnored For Field Name
Pre_OperativeStayInDays3int
Post_OperativeStayInDays4int
TotalStayInDays5int
ParsonnetScoreFromHardData6int
CardiopulmonaryBypass7varchar
ParsonnetScoreWithCatastrophicStatesAndRareConditi8int
PredominantMyocardialProtection9varchar
Parsonnet_AdditionsForCatastrophicStates10int
Parsonnet_AdditionsForRareConditions11int
Euroscore12int
Cs1999ComplexCabgBayesScore13float
LogisticEuroscore14float
Cardioplegia_Solution15varchar
Cardioplegia_Temperature16varchar
Cardioplegia_Timing17varchar
Non_CardioplegiaMyocardialProtection18varchar
Intra_AorticBalloonPumpUsed19varchar
ReaonForIabpUse20varchar
HeightInCm21int
WeightInKg22float
CumulativeBypassTimeInMin23int
CumulativeCrossClampTimeInMin24int
TotalCirculatoryArrestTimeInMin25int
Re_Operation26varchar
NewPost_OperativeStroke27varchar
NewHaemofiltration_DialysisPost_Operatively28varchar
DischargeDestination_FromCardiothoracicWard29varchar
DateOfDischargeOrDeath30datetimeIgnored For Datatype
BodySurfaceArea31float
BodyMassIndex32float
Cardioplegia_Infusion33varchar
EuroscoreMinumumDatasetCheck34varchar
ParsonnetMinumumDatasetCheck35varchar
NameOfGpAtTimeOfSurgery36varcharIgnored For No Enum
GpPracticeCodeAtTimeOfSurgery37varcharIgnored For No Enum
PctAtTimeOfSurgery38varcharIgnored For No Enum
NameOfReferringGpAtTimeOfSurgeryType839varcharIgnored For No Enum
ToePerformed40varchar
Sonographer41varchar
Sonographist42varchar
PrimaryPerfusionist43varcharIgnored For No Enum
PcuPatient_pcu44varchar
DoesPatientMeetInterOperativeCriteria_pcu45varchar
AreaPatientAdmittedTo_pcu46varchar
AdmissionTimeToRecovery_cicu_pcu47varchar
ExtubationDateAndTime_pcu48varchar
WhatO2SystemWasUsed_pcu49varchar
TotalBloodLostOnDischargeFromRecovery_pcu50varchar
WereClottingProductsUsed_pcu51varchar
WhatProductsWereUsed_pcu52varchar
HowMuchColloidUsedInRecovery_pcu53varchar
TypeOfColloidUsed_pcu54varchar
PainScoreOnWaking_pcu55varchar
AnalgesiaUsedPcu56varchar
TotalMorphineDoseUsedIncludingBolus_pcu57varchar
InotropesUsed_pcu58varchar
Dosage_pcu59varchar
WereThereAnyArrhythmias_pcu60varchar
PleaseStateArrhythmias_pcu61varchar
TreatmentOfArrhythmias_pcu62varchar
PotassiumUsed_pcu63varchar
PotassiumDoseInMmols_pcu64varchar
TemperatureOnAdmission_pcu65float
BairhuggerWithPatient_pcu66varchar
TimeOfDischarge_pcu67varchar
PlaceOfDischarge_pcu68varchar
DoesPatientMeetDischargeCriteria_pcu69varchar
WasPatientDischargedFromPcuToHdu_pcu70varchar
LowUrineOutput_pcu71varchar
IfNoStateWhy_pcu72varchar
IfNoWhy_pcu73varchar
AmountOfTimeIntubated_pcu74float
AmountOfTimeInRecovery_cicu_pcu75float
OverallComments_sa76varcharIgnored For No Enum
TeachingOfOtherStaffComments_sa77varchar
TeachingOfOtherStaffCommentsMade_sa78varchar
TeachingOfOtherStaffBySa_sa79varchar
IabpRemovalComments_sa80varchar
IabpRemovalCommentsMade_sa81varchar
IabpRemovalBySa_sa82varchar
IabpInsertionComments_sa83varchar
IabpInsertionCommentsMade_sa84varchar
IabpInsertionBySa_sa85varchar
SternotomyClosureComments_sa86varchar
SternotomyClosureCommentsMade_sa87varchar
SternotomyClosureBySa_sa88varchar
SternotomyComments_sa89varchar
SternotomyCommentsMade_sa90varchar
SternotomyPerformedBySa_sa91varchar
ThirdSiteComments_sa92varchar
ThirdSiteCommentsMade_sa93varchar
ThirdSiteConduit_location_sa94varchar
SecondSiteComments_sa95varcharIgnored For No Enum
SecondSiteCommentsMade_sa96varchar
SecondSiteConduit_location_sa97varchar
FirstSiteComments_sa98varcharIgnored For No Enum
FirstSiteCommentsMade_sa99varchar
FirstSiteConduei_location_sa100varchar
ThirdAssistant_sa101varchar
SecondAssistant_sa102varchar
FirstAssistant_sa103varchar
SurgicalAssistant_sa104varchar
ReferralToOperation_days105float
Arrhythmia_S106varcharIgnored For No Enum
LowCardiacOutput107varchar
Ventilation108varchar
PulmonaryComplications109varcharIgnored For No Enum
RenalComplications110varchar
GastrointestinalComplications111varchar
InfectiveComplications112varchar
CauseOfDeath113varchar
AdmittedFrom_hospitalNameOrWard114varchar
AdmittedToCardiacSurgery115datetimeIgnored For Datatype
DischargedFromCardiacSurgery116datetimeIgnored For Datatype
TotalCardiacSurgeryLosDays117float
DateOfFollowUp118datetimeIgnored For Datatype
BloodUsed119varchar
MutisystemFailure120varchar
DateFirstAdmittedToCicu121datetimeIgnored For Datatype
DateFirstDischargedFromCicu122datetimeIgnored For Datatype
TotalFirstStayOnCicu123float
ReAdmittedToCicu124varchar
DateOfSecondAdmissionToCicu125datetimeIgnored For Datatype
DateOfSecondDischargeFromCicu126datetimeIgnored For Datatype
SecondAdmissionTotalStay_nignts127float
DateOfThirdAdmissionToCicu128datetimeIgnored For Datatype
DateOfThirdDischargeFromCicu129datetimeIgnored For Datatype
ThirdAdmissionToCicuTotalStay_nights130float
InsertionOfPacemakerWiresViaVatsProcedure131varchar
IntubationTimeInHours132int
AuditTrail133varchar
NameOfDoctorCompletingBooklet134varcharIgnored For No Enum
SecondPrimaryPerfusionist135varchar
SecondBypass136varchar
SecondMyocardialProtection137varchar
SecondCardioplegiaSolution138varchar
SecondCardioplegiaInfusion139varchar
SecondCardioplegiaTemperature140varchar
SecondCardioplegiaTiming141varchar
SecondNon_CardioplegiaMyocardialProtection142varchar
!DoesPatientNeedAFollowUpAppiontment143varchar
Comments144varcharIgnored For No Enum
MedicalRecordNumber145varcharIgnored For No Enum
DateAddedToW_l146datetimeIgnored For Datatype
AddedToW_l147varchar
DateOfFourthAdmissionToCicu148datetimeIgnored For Datatype
DateOfFourthDischargeFromCicu149datetimeIgnored For Datatype
DateOfFifthAdmissionToCicu150datetimeIgnored For Datatype
DateOfFifthDischargeFromCicu151datetimeIgnored For Datatype
CumulativeStayFirstAndSecondAdmissionToCicu152float
Cumulative1st2ndAnd3rdStayInCicu153float
FourthAdmissionToCicuTotalStay_nights154float
Cumulative1st2nd3rd4thStayInCicu155float
FifthAdmissionToCicuTotalStay_nights156float
Cumulative1sr2nd3rd4th5thStayInCicu157float
PatientIdentifiedForSamedayAdmission158varchar
ProposedDateOfAdmission159datetimeIgnored For Datatype
IfNotOperatedOnSamedayGiveReason160varchar
SecondBypassTotal161int
SecondCrossClampTotal162int
SecondCiculatoryArrestTotal163int
CouncilCase164varchar
InitialConsultantInJointCase165varchar
ArrhythmiaOtherComplicationFreeText166varchar
LowCardiacOutputOtherComplicationFreeText167varchar
PulmonaryOtherComplicationFreeText168varchar
RenalOtherComplicationFreeText169varchar
GastrointestinalOtherComplicationFreeText170varchar
InfectiveOtherComplicationFreeText171varcharIgnored For No Enum
SickNoteOffered172varchar
IfSickNoteOfferedDurationInDays173int
AdviceToGpAndAnyMedicationChangedOrStopped174varcharIgnored For No Enum
NameOfDischargingDoctor175varcharIgnored For No Enum
GradeOfDischargingDoctor176varcharIgnored For No Enum
PagerNumber177varcharIgnored For No Enum
DrugSensitivity178varcharIgnored For No Enum
Drug1179varcharIgnored For No Enum
DrugRoute1180varchar
NumberOfDays1181int
Continue1182varchar
Drug2183varcharIgnored For No Enum
DrugRoute2184varchar
NumberOfDays2185int
Continue2186varchar
Drug3187varcharIgnored For No Enum
DrugRoute3188varchar
NumberOfDays3189int
Continue3190varchar
Drug4191varcharIgnored For No Enum
DrugRoute4192varchar
NumberOfDays4193int
Continue4194varchar
Drug5195varcharIgnored For No Enum
DrugRoute5196varchar
NumberOfDays5197int
Continue5198varchar
Drug6199varcharIgnored For No Enum
DrugRoute6200varchar
NumberOfDays6201int
Continue6202varchar
Drug7203varcharIgnored For No Enum
DrugRoute7204varchar
NumberOfDays7205int
Continue7206varchar
Drug8207varcharIgnored For No Enum
DrugRoute8208varchar
NumberOfDays8209int
Continue8210varchar
Drug9211varcharIgnored For No Enum
DrugRoute9212varchar
NumberOfDays9213int
Continue9214varchar
Drug10215varcharIgnored For No Enum
DrugRoute10216varchar
NumberOfDays10217int
Continue10218varchar
Drug11219varcharIgnored For No Enum
DrugRoute11220varchar
NumberOfDays11221int
Continue11222varchar
Drug12223varcharIgnored For No Enum
DrugRoute12224varchar
NumberOfDays12225int
Continue12226varchar
Drug13227varchar
DrugRoute13228varchar
NumberOfDays13229int
Continue13230varchar
Drug14231varchar
DrugRoute14232varchar
NumberOfDays14233int
Continue14234varchar
Drug15235varchar
DrugRoute15236varchar
NumberOfDays15237int
Continue15238varchar
Drug16239varchar
DrugRoute16240varchar
NumberOfDays16241int
Continue16242varchar
Drug17243varchar
DrugRoute17244varchar
NumberOfDays17245int
Continue17246varchar
Drug18247varchar
DrugRoute18248varchar
NumberOfDays18249int
Continue18250varchar
DrugNameAndStrength19251varcharIgnored For No Enum
DrugForm19252varchar
DrugDose19253varcharIgnored For No Enum
DrugRoute19254varchar
DrugFrequency19255varchar
NumberOfDays19256int
Continue19257varchar
DrugNameAndStrength20258varcharIgnored For No Enum
DrugForm20259varchar
DrugDose20260varcharIgnored For No Enum
DrugRoute20261varchar
DrugFrequency20262varchar
NumberOfDays20263int
Continue20264varchar
DrugNameAndStrength21265varcharIgnored For No Enum
DrugForm21266varchar
DrugDose21267varcharIgnored For No Enum
DrugRoute21268varchar
DrugFrequency21269varchar
NumberOfDays21270int
Continue21271varchar
DrugNameAndStrength22272varcharIgnored For No Enum
DrugForm22273varchar
DrugDose22274varcharIgnored For No Enum
DrugRoute22275varchar
DrugFrequency22276varchar
NumberOfDays22277int
Continue22278varchar
DrugNameAndStrength23279varcharIgnored For No Enum
DrugForm23280varchar
DrugDose23281varcharIgnored For No Enum
DrugRoute23282varchar
DrugFrequency23283varchar
NumberOfDays23284int
Continue23285varchar
DrugNameAndStrength24286varchar
DrugForm24287varchar
DrugDose24288varchar
DrugRoute24289varchar
DrugFrequency24290varchar
NumberOfDays24291int
Continue24292varchar
DischargeWard293varchar
Pharmacist294varchar
ManagementPlan295varcharIgnored For No Enum
FollowUpRequired296varchar
FollowUpTimeInWeeks_months297varcharIgnored For No Enum
MedicationChangedByPharmacist298varchar
StatePharmacistChanges299varchar
InformationGivenToPatient300varcharIgnored For No Enum
DateTimeRecordCreated301datetimeIgnored For Datatype
DateTimeRecordLastChanged302datetimeIgnored For Datatype
EnteredByTag303varchar
HospitalTag304varchar
WHO_REGISTRY_INDICATOR305varchar
WHO_POSSIBLE_DUPLICATE306charIgnored For Datatype
Last modified 11 years ago Last modified on 03/15/13 08:49:53
Note: See TracWiki for help on using the wiki.