[[i2b2 - UHL clinical informatics system integration PATS Mappings v1|back]

Start Date Field: DateOfDischargeOrDeath

Field Name	Column ID	Type	Comments
EntryId	1	int	Ignored For Field Name
PatientId	2	int	Ignored For Field Name
Pre_OperativeStayInDays	3	int
Post_OperativeStayInDays	4	int
TotalStayInDays	5	int
ParsonnetScoreFromHardData	6	int
CardiopulmonaryBypass	7	varchar
ParsonnetScoreWithCatastrophicStatesAndRareConditi	8	int
PredominantMyocardialProtection	9	varchar
Parsonnet_AdditionsForCatastrophicStates	10	int
Parsonnet_AdditionsForRareConditions	11	int
Euroscore	12	int
Cs1999ComplexCabgBayesScore	13	float
LogisticEuroscore	14	float
Cardioplegia_Solution	15	varchar
Cardioplegia_Temperature	16	varchar
Cardioplegia_Timing	17	varchar
Non_CardioplegiaMyocardialProtection	18	varchar
Intra_AorticBalloonPumpUsed	19	varchar
ReaonForIabpUse	20	varchar
HeightInCm	21	int
WeightInKg	22	float
CumulativeBypassTimeInMin	23	int
CumulativeCrossClampTimeInMin	24	int
TotalCirculatoryArrestTimeInMin	25	int
Re_Operation	26	varchar
NewPost_OperativeStroke	27	varchar
NewHaemofiltration_DialysisPost_Operatively	28	varchar
DischargeDestination_FromCardiothoracicWard	29	varchar
DateOfDischargeOrDeath	30	datetime	Ignored For Datatype
BodySurfaceArea	31	float
BodyMassIndex	32	float
Cardioplegia_Infusion	33	varchar
EuroscoreMinumumDatasetCheck	34	varchar
ParsonnetMinumumDatasetCheck	35	varchar
NameOfGpAtTimeOfSurgery	36	varchar	Ignored For No Enum
GpPracticeCodeAtTimeOfSurgery	37	varchar	Ignored For No Enum
PctAtTimeOfSurgery	38	varchar	Ignored For No Enum
NameOfReferringGpAtTimeOfSurgeryType8	39	varchar	Ignored For No Enum
ToePerformed	40	varchar
Sonographer	41	varchar
Sonographist	42	varchar
PrimaryPerfusionist	43	varchar	Ignored For No Enum
PcuPatient_pcu	44	varchar
DoesPatientMeetInterOperativeCriteria_pcu	45	varchar
AreaPatientAdmittedTo_pcu	46	varchar
AdmissionTimeToRecovery_cicu_pcu	47	varchar
ExtubationDateAndTime_pcu	48	varchar
WhatO2SystemWasUsed_pcu	49	varchar
TotalBloodLostOnDischargeFromRecovery_pcu	50	varchar
WereClottingProductsUsed_pcu	51	varchar
WhatProductsWereUsed_pcu	52	varchar
HowMuchColloidUsedInRecovery_pcu	53	varchar
TypeOfColloidUsed_pcu	54	varchar
PainScoreOnWaking_pcu	55	varchar
AnalgesiaUsedPcu	56	varchar
TotalMorphineDoseUsedIncludingBolus_pcu	57	varchar
InotropesUsed_pcu	58	varchar
Dosage_pcu	59	varchar
WereThereAnyArrhythmias_pcu	60	varchar
PleaseStateArrhythmias_pcu	61	varchar
TreatmentOfArrhythmias_pcu	62	varchar
PotassiumUsed_pcu	63	varchar
PotassiumDoseInMmols_pcu	64	varchar
TemperatureOnAdmission_pcu	65	float
BairhuggerWithPatient_pcu	66	varchar
TimeOfDischarge_pcu	67	varchar
PlaceOfDischarge_pcu	68	varchar
DoesPatientMeetDischargeCriteria_pcu	69	varchar
WasPatientDischargedFromPcuToHdu_pcu	70	varchar
LowUrineOutput_pcu	71	varchar
IfNoStateWhy_pcu	72	varchar
IfNoWhy_pcu	73	varchar
AmountOfTimeIntubated_pcu	74	float
AmountOfTimeInRecovery_cicu_pcu	75	float
OverallComments_sa	76	varchar	Ignored For No Enum
TeachingOfOtherStaffComments_sa	77	varchar
TeachingOfOtherStaffCommentsMade_sa	78	varchar
TeachingOfOtherStaffBySa_sa	79	varchar
IabpRemovalComments_sa	80	varchar
IabpRemovalCommentsMade_sa	81	varchar
IabpRemovalBySa_sa	82	varchar
IabpInsertionComments_sa	83	varchar
IabpInsertionCommentsMade_sa	84	varchar
IabpInsertionBySa_sa	85	varchar
SternotomyClosureComments_sa	86	varchar
SternotomyClosureCommentsMade_sa	87	varchar
SternotomyClosureBySa_sa	88	varchar
SternotomyComments_sa	89	varchar
SternotomyCommentsMade_sa	90	varchar
SternotomyPerformedBySa_sa	91	varchar
ThirdSiteComments_sa	92	varchar
ThirdSiteCommentsMade_sa	93	varchar
ThirdSiteConduit_location_sa	94	varchar
SecondSiteComments_sa	95	varchar	Ignored For No Enum
SecondSiteCommentsMade_sa	96	varchar
SecondSiteConduit_location_sa	97	varchar
FirstSiteComments_sa	98	varchar	Ignored For No Enum
FirstSiteCommentsMade_sa	99	varchar
FirstSiteConduei_location_sa	100	varchar
ThirdAssistant_sa	101	varchar
SecondAssistant_sa	102	varchar
FirstAssistant_sa	103	varchar
SurgicalAssistant_sa	104	varchar
ReferralToOperation_days	105	float
Arrhythmia_S	106	varchar	Ignored For No Enum
LowCardiacOutput	107	varchar
Ventilation	108	varchar
PulmonaryComplications	109	varchar	Ignored For No Enum
RenalComplications	110	varchar
GastrointestinalComplications	111	varchar
InfectiveComplications	112	varchar
CauseOfDeath	113	varchar
AdmittedFrom_hospitalNameOrWard	114	varchar
AdmittedToCardiacSurgery	115	datetime	Ignored For Datatype
DischargedFromCardiacSurgery	116	datetime	Ignored For Datatype
TotalCardiacSurgeryLosDays	117	float
DateOfFollowUp	118	datetime	Ignored For Datatype
BloodUsed	119	varchar
MutisystemFailure	120	varchar
DateFirstAdmittedToCicu	121	datetime	Ignored For Datatype
DateFirstDischargedFromCicu	122	datetime	Ignored For Datatype
TotalFirstStayOnCicu	123	float
ReAdmittedToCicu	124	varchar
DateOfSecondAdmissionToCicu	125	datetime	Ignored For Datatype
DateOfSecondDischargeFromCicu	126	datetime	Ignored For Datatype
SecondAdmissionTotalStay_nignts	127	float
DateOfThirdAdmissionToCicu	128	datetime	Ignored For Datatype
DateOfThirdDischargeFromCicu	129	datetime	Ignored For Datatype
ThirdAdmissionToCicuTotalStay_nights	130	float
InsertionOfPacemakerWiresViaVatsProcedure	131	varchar
IntubationTimeInHours	132	int
AuditTrail	133	varchar
NameOfDoctorCompletingBooklet	134	varchar	Ignored For No Enum
SecondPrimaryPerfusionist	135	varchar
SecondBypass	136	varchar
SecondMyocardialProtection	137	varchar
SecondCardioplegiaSolution	138	varchar
SecondCardioplegiaInfusion	139	varchar
SecondCardioplegiaTemperature	140	varchar
SecondCardioplegiaTiming	141	varchar
SecondNon_CardioplegiaMyocardialProtection	142	varchar
!DoesPatientNeedAFollowUpAppiontment	143	varchar
Comments	144	varchar	Ignored For No Enum
MedicalRecordNumber	145	varchar	Ignored For No Enum
DateAddedToW_l	146	datetime	Ignored For Datatype
AddedToW_l	147	varchar
DateOfFourthAdmissionToCicu	148	datetime	Ignored For Datatype
DateOfFourthDischargeFromCicu	149	datetime	Ignored For Datatype
DateOfFifthAdmissionToCicu	150	datetime	Ignored For Datatype
DateOfFifthDischargeFromCicu	151	datetime	Ignored For Datatype
CumulativeStayFirstAndSecondAdmissionToCicu	152	float
Cumulative1st2ndAnd3rdStayInCicu	153	float
FourthAdmissionToCicuTotalStay_nights	154	float
Cumulative1st2nd3rd4thStayInCicu	155	float
FifthAdmissionToCicuTotalStay_nights	156	float
Cumulative1sr2nd3rd4th5thStayInCicu	157	float
PatientIdentifiedForSamedayAdmission	158	varchar
ProposedDateOfAdmission	159	datetime	Ignored For Datatype
IfNotOperatedOnSamedayGiveReason	160	varchar
SecondBypassTotal	161	int
SecondCrossClampTotal	162	int
SecondCiculatoryArrestTotal	163	int
CouncilCase	164	varchar
InitialConsultantInJointCase	165	varchar
ArrhythmiaOtherComplicationFreeText	166	varchar
LowCardiacOutputOtherComplicationFreeText	167	varchar
PulmonaryOtherComplicationFreeText	168	varchar
RenalOtherComplicationFreeText	169	varchar
GastrointestinalOtherComplicationFreeText	170	varchar
InfectiveOtherComplicationFreeText	171	varchar	Ignored For No Enum
SickNoteOffered	172	varchar
IfSickNoteOfferedDurationInDays	173	int
AdviceToGpAndAnyMedicationChangedOrStopped	174	varchar	Ignored For No Enum
NameOfDischargingDoctor	175	varchar	Ignored For No Enum
GradeOfDischargingDoctor	176	varchar	Ignored For No Enum
PagerNumber	177	varchar	Ignored For No Enum
DrugSensitivity	178	varchar	Ignored For No Enum
Drug1	179	varchar	Ignored For No Enum
DrugRoute1	180	varchar
NumberOfDays1	181	int
Continue1	182	varchar
Drug2	183	varchar	Ignored For No Enum
DrugRoute2	184	varchar
NumberOfDays2	185	int
Continue2	186	varchar
Drug3	187	varchar	Ignored For No Enum
DrugRoute3	188	varchar
NumberOfDays3	189	int
Continue3	190	varchar
Drug4	191	varchar	Ignored For No Enum
DrugRoute4	192	varchar
NumberOfDays4	193	int
Continue4	194	varchar
Drug5	195	varchar	Ignored For No Enum
DrugRoute5	196	varchar
NumberOfDays5	197	int
Continue5	198	varchar
Drug6	199	varchar	Ignored For No Enum
DrugRoute6	200	varchar
NumberOfDays6	201	int
Continue6	202	varchar
Drug7	203	varchar	Ignored For No Enum
DrugRoute7	204	varchar
NumberOfDays7	205	int
Continue7	206	varchar
Drug8	207	varchar	Ignored For No Enum
DrugRoute8	208	varchar
NumberOfDays8	209	int
Continue8	210	varchar
Drug9	211	varchar	Ignored For No Enum
DrugRoute9	212	varchar
NumberOfDays9	213	int
Continue9	214	varchar
Drug10	215	varchar	Ignored For No Enum
DrugRoute10	216	varchar
NumberOfDays10	217	int
Continue10	218	varchar
Drug11	219	varchar	Ignored For No Enum
DrugRoute11	220	varchar
NumberOfDays11	221	int
Continue11	222	varchar
Drug12	223	varchar	Ignored For No Enum
DrugRoute12	224	varchar
NumberOfDays12	225	int
Continue12	226	varchar
Drug13	227	varchar
DrugRoute13	228	varchar
NumberOfDays13	229	int
Continue13	230	varchar
Drug14	231	varchar
DrugRoute14	232	varchar
NumberOfDays14	233	int
Continue14	234	varchar
Drug15	235	varchar
DrugRoute15	236	varchar
NumberOfDays15	237	int
Continue15	238	varchar
Drug16	239	varchar
DrugRoute16	240	varchar
NumberOfDays16	241	int
Continue16	242	varchar
Drug17	243	varchar
DrugRoute17	244	varchar
NumberOfDays17	245	int
Continue17	246	varchar
Drug18	247	varchar
DrugRoute18	248	varchar
NumberOfDays18	249	int
Continue18	250	varchar
DrugNameAndStrength19	251	varchar	Ignored For No Enum
DrugForm19	252	varchar
DrugDose19	253	varchar	Ignored For No Enum
DrugRoute19	254	varchar
DrugFrequency19	255	varchar
NumberOfDays19	256	int
Continue19	257	varchar
DrugNameAndStrength20	258	varchar	Ignored For No Enum
DrugForm20	259	varchar
DrugDose20	260	varchar	Ignored For No Enum
DrugRoute20	261	varchar
DrugFrequency20	262	varchar
NumberOfDays20	263	int
Continue20	264	varchar
DrugNameAndStrength21	265	varchar	Ignored For No Enum
DrugForm21	266	varchar
DrugDose21	267	varchar	Ignored For No Enum
DrugRoute21	268	varchar
DrugFrequency21	269	varchar
NumberOfDays21	270	int
Continue21	271	varchar
DrugNameAndStrength22	272	varchar	Ignored For No Enum
DrugForm22	273	varchar
DrugDose22	274	varchar	Ignored For No Enum
DrugRoute22	275	varchar
DrugFrequency22	276	varchar
NumberOfDays22	277	int
Continue22	278	varchar
DrugNameAndStrength23	279	varchar	Ignored For No Enum
DrugForm23	280	varchar
DrugDose23	281	varchar	Ignored For No Enum
DrugRoute23	282	varchar
DrugFrequency23	283	varchar
NumberOfDays23	284	int
Continue23	285	varchar
DrugNameAndStrength24	286	varchar
DrugForm24	287	varchar
DrugDose24	288	varchar
DrugRoute24	289	varchar
DrugFrequency24	290	varchar
NumberOfDays24	291	int
Continue24	292	varchar
DischargeWard	293	varchar
Pharmacist	294	varchar
ManagementPlan	295	varchar	Ignored For No Enum
FollowUpRequired	296	varchar
FollowUpTimeInWeeks_months	297	varchar	Ignored For No Enum
MedicationChangedByPharmacist	298	varchar
StatePharmacistChanges	299	varchar
InformationGivenToPatient	300	varchar	Ignored For No Enum
DateTimeRecordCreated	301	datetime	Ignored For Datatype
DateTimeRecordLastChanged	302	datetime	Ignored For Datatype
EnteredByTag	303	varchar
HospitalTag	304	varchar
WHO_REGISTRY_INDICATOR	305	varchar
WHO_POSSIBLE_DUPLICATE	306	char	Ignored For Datatype