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