Back

The PATS mappings are split into text and numeric fields.

Text Fields

Text fields are mapped to the i2b2 Observation Fact table like this

i2b2 Field	Source
Encounter_Num	i2b2 Patient ID
Patient_Num	i2b2 PatientID
Concept_Cd	Enum lookup value (see below)
Provider_Id	"@"
Start_Date	The source table observation date field (see below)
Modifier_Cd	"@"
ValType_Cd	"T" (text)
Units_Cd	"@"
Location_Cd	"@"
Update_Date	The current date using the GETDATE() Function
SourceSystem_Cd	"BRICCS"
Upload_Id	"1"

SOMETIME (RB): Convert Update_Date to use a date parameter. It's just a little quicker.

SOMETIME (RB): Should the SourceSystem_Cd not be "PATS"? Or maybe "MINAP" or whatever.

SOMETIME (RB): The Upload_Id is presumably always one because everything is reloaded each time. Might be nice to change this to something more meaningful.

Enum Lookup Value

The Concept Code to use is found in the table DATA_DICTIONARY_ENUM_VALUES in the DWBRICCS database on UHLDWH server. This table contains records for concept code keyed on source table name, column name and column value. NULL column values may be mapped to the field '(empty)'.

ACTION (RB): Check if all possible values of column value contain a mapping in the DATA_DICTIONARY_ENUM_VALUES table.

Source Table Observation Date Field

For each source table in the there is a single field that is used as the start date for all columns from that field. The observation date field to use for each table is stored in the pats_tables table in the DWBRICS on the UHLDWH server.

Numeric Fields

Numeric fields are mapped to the i2b2 Observation Fact table like this

i2b2 Field	Source
Encounter_Num	i2b2 Patient ID
Patient_Num	i2b2 PatientID
Concept_Cd	"PTS:{TABLE_NAME}_{COLUMN_ID}"
Provider_Id	"@"
Start_Date	The source table observation date field (see above)
Modifier_Cd	"@"
ValType_Cd	"N" (numeric)
TVal_Char	"E" (see below)
Units_Cd	Value calculated by ufn_get_units function (see below)
Location_Cd	"@"
Update_Date	The current date using the GETDATE() Function
SourceSystem_Cd	"BRICCS"
Upload_Id	"1"

TVal_Char

The TVal_Char describes the meaning of the value contained in the NVal_Num field.

For all values currently the value of TVal_Char is set to "E", which means equals. That is, the value in the NVal_Num field is the result of the test. All possible values of TVal_Char are:

Value	Meaning
E	Equals
NE	Not Equal
L	Less Than
LE	Less Than or Equals
G	Greater Than
GE	Greater Than or Equals

From a casual look at the data, I think that a value of less than X, or greater than Y is sometimes used for Pathology data.

ufn_get_units Function

The function ufn_get_units in the DWBRICCS database is called with parameters of table_name and field_name to determine the units.

ACTION (RB): Work out what this function actually does. The function just selects the units column from the Data_Dictionary table in the DWBRICCS database. If the result is an empty string, it returns 'units' instead. Don't know why it would do that.

ACTION (RB): Rewrite numeric data extract to do the same, but with a join. Or it could be moved into the query that copies all the numeric fields into the recordset for looping with the for each. Either really.

Tables

The PATS i2b2 data integration load maps source table types to either Text or Numeric. All other types are ignored. The mapping is as follows.

Source Type	i2b2 Type
VARCHAR	Text
INT or FLOAT	Numeric
All other types	NOT LOADED

In addition, all fields with certain names are also ignored.

Ignored Field Names

• PatientId
• EntryId
• PreviousEntry
• NextEntry

Comments about data:

COMMENT (RB): Which fields should be removed?

COMMENT (RB): All date fields are ignored, but could they be converted into numeric fields. For example, length of stay, time between stays, etc. This may already be being done.

COMMENT (RB): There are quite a few denormalised fields. For example: drug1, drug2 - could these be normalised into one concept code. Or: readmittedDate1, readmittedDate2 - could these be different encounters? Are these already being recorded?

COMMENT (RB): Some dates are recorded as varchars and so presumably are being imported

COMMENT (RB): Are some text fields also being ignored because they don't have entries in the enum data dictionary? Yes they are ignored.

ACTION (RB): Rewrite extracting of varchar fields to check that there are any entries in the ENUM Data Dictionary for that field. This should reduce the number of queries that need to be run in the for each and speed things up quite a bit.

CATH_CATHINITIALVW

Start Date Field: DateofCatheter

Field Name	Column ID	Type	Comments
EntryId	1	int	Ignored For Field Name
PatientId	2	int	Ignored For Field Name
DateofCatheter	3	date	Ignored For Datatype
TimeofCatheter	4	time	Ignored For Datatype
EntryStatus	5	varchar
PreviousEntry	6	int	Ignored For Field Name
NextEntry	7	int	Ignored For Field Name
DateOfAdmission	8	date	Ignored For Datatype
AgeAtCatheter	9	int
DoneInMobileLab	10	varchar
Consultant	11	varchar	Ignored For No Enum
Operator	12	varchar	Ignored For No Enum
SecondOperator	13	varchar	Ignored For No Enum
Technician	14	varchar	Ignored For No Enum
PatientType	15	varchar
WasThePatientCatheterised	16	varchar
ProcedureType	17	varchar
GeneralAnaesthetics	18	varchar
ProcedureSite	19	varchar	Ignored For No Enum
BiopsyTaken	20	varchar
BiopsySite	21	varchar
OtherProcedure	22	varchar	Ignored For No Enum
Arterial_1	23	varchar
Vessel_1_Arterial	24	varchar
Complicated_1_Arterial	25	varchar
Arterial_2	26	varchar
Vessel_2_Arterial	27	varchar
Complicated2Arterial	28	varchar
Arterial_3	29	varchar
Vessel_3_Arterial	30	varchar
Complicated_3_Arterial	31	varchar
Venous_1	32	varchar
Vessel_1_Venous	33	varchar
Complicated_1_Venous	34	varchar
Venous_2	35	varchar
Vessel_2_Venous	36	varchar
Complicated_2_Venous	37	varchar
Venous_3	38	varchar
Vessel_3_Venous	39	varchar
Complicated_3_Venous	40	varchar
Vessels	41	varchar	Ignored For No Enum
ReturnedTo	42	varchar
FurtherProcedure	43	varchar
ImmediateComplications	44	varchar
ProcedureAbandoned	45	varchar
ReasonForAbandoningProcedure	46	varchar
OtherComplications	47	varchar	Ignored For No Enum
DiedInCathLab	48	varchar
CoronaryDisease	49	varchar
SignificantValveDisease	50	varchar
SignificantLvDisease	51	varchar
Outcome	52	varchar
ReturnToCathLab	53	varchar
EmbolicSequelae	54	varchar
NonEmergencySurgery	55	varchar
GroinComplication	56	varchar
Death	57	varchar
DischargeComplications	58	varchar
OutcomeOfCatheter	59	varchar
DateOfDischarge	60	date	Ignored For Datatype
DateOfDeath	61	date	Ignored For Datatype
DischargeTo	62	varchar
PreopStay_days	63	int
PostOpStay_days	64	int
TotalHospitalStay	65	int
IhdScore_cardwl	66	int
NihdScore_cardwl	67	int
OtherComplicationsPreDischarge	68	varchar
DateOfDeathPostDischarge	69	date	Ignored For Datatype
PostProcedureDeathInterval_days	70	int
FormsVerified	71	varchar
Contract	72	varchar	Ignored For No Enum
Pcg	73	varchar	Ignored For No Enum
AuditLoopClosed	74	varchar
DateAuditLoopClosed	75	date	Ignored For Datatype
ReasonAuditLoopClosed	76	varchar
IntervalBetweenProc_LoopClosed_days	77	int
DateOnWaitingList	78	date	Ignored For Datatype
DaysOnList	79	int
GpPracticeCode	80	varchar	Ignored For No Enum
Pct	81	varchar	Ignored For No Enum
MedicalRecordNumber	82	varchar	Ignored For No Enum
AdministrativeCategory	83	varchar
AuditTrail	84	text	Ignored For Datatype
DateAndTimeOfProcedure	85	varchar	Ignored For No Enum
IsThisAcs	86	varchar
Sub_Xiphoid	87	varchar
PreDischargeComplications	88	varchar
IfOtherPreDischargeComplicationsPleaseState	89	varchar
Height	90	float
Weight	91	float
Bmi	92	float
ScreeningTime	93	float
ScreeningDose	94	float
ExceededDrl	95	varchar
Radiographer	96	varchar
ReasonForExceedingDrl	97	varchar
CatheterProcedureReport	98	varchar	Ignored For No Enum
ConsultantCode	99	varchar	Ignored For No Enum
OperatorCode	100	varchar	Ignored For No Enum
SecondOperatorCode	101	varchar	Ignored For No Enum
TroponinPositive	102	varchar
DateOfCurrentStatus	103	date	Ignored For Datatype
DateOfEndStatus	104	date	Ignored For Datatype
DateTimeRecordCreated	105	varchar	Ignored For No Enum
DateTimeRecordLastChanged	106	varchar	Ignored For No Enum
EnteredByTag	107	varchar
EntryCurrentStatus	108	varchar
EntryEndStatus	109	varchar
HospitalTag	110	varchar
ImportLinkId	111	int

CS2003F_PostProcedure

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

CS2003F_PreProcedure

Start Date Field: !DateOfOperation_ccad

Field Name	Column ID	Type	Comments
EntryId	1	int	Ignored For Field Name
PatientId	2	int	Ignored For Field Name
DateOfOperation_ccad	3	datetime	Ignored For Datatype
TimeOfOperation_ccad	4	datetime	Ignored For Datatype
EntryStatus	5	varchar
PreviousEntry	6	int	Ignored For Field Name
NextEntry	7	int	Ignored For Field Name
AgeAtSurgery	8	int
Gender	9	varchar
DateOfAdmission	10	datetime	Ignored For Datatype
AnginaStatusPre_Surgery	11	varchar
DyspnoeaStatusPre_Surgery	12	varchar
NumberOfPreviousMis	13	varchar
IntervalBetweenOperationAndLastMi	14	varchar
PreviousPci	15	varchar
DateOfLastPci	16	datetime	Ignored For Datatype
PreviousCardiac_VascularOrThoracicSurgicalInterven	17	varchar
DateOfLastCardiacOperation	18	datetime	Ignored For Datatype
DiabetesManagement	19	varchar
Hypertension	20	varchar
CigaretteSmokingHistory	21	varchar
RenalDiseaseAtTheTimeOfSurgery	22	varchar
HistoryOfPulmonaryDisease	23	varchar
HistoryOfNeurologicalDisease	24	varchar
Pre_OperativeHeartRhythm	25	varchar
DateOfCatheterisation	26	datetime	Ignored For Datatype
PaSystolic_ifKnown	27	int
AvGradient_ifKnown	28	int
Lvedp_ifKnown	29	int
MeanPawp_la_ifKnown	30	int
IvNitrates_HeparinOfAnyKind	31	varchar
IvInotropesPriorToAnaesthesia	32	varchar
Ventilated	33	varchar
CardiogenicShock	34	varchar
OperativePriority	35	varchar
FirstOperatorGrade	36	varchar
FirstOperator_CalmanYearOfTrainee	37	varchar
CardiacProcedures	38	varchar
NumberOfDistalCoronaryAnastomoses	39	int
NumberOfValvesReplaced_Repaired	40	int
NumberOfSegmentsOfTheAorta	41	int
OtherCardiacProcedures	42	varchar
OtherThoracicAndVascularProcedures	43	varchar
NeurologicalDysfunction_euroscore	44	varchar
LeftMainStemDisease	45	varchar
ExtentOfCoronaryArteryDisease	46	varchar
ExtracardiacArteriopathy	47	varchar
EjectionFractionCategory	48	varchar
AdmissionCategory	49	varchar
CarotidBruits	50	varchar
LeftOrRightHeartCatheterisation	51	varchar
EjectionFractionValue_ifKnown	52	int
DateAndTimeOfOperation	53	varchar	Ignored For No Enum
NumberOfPreviousHeartOperations	54	int
ResponsibleConsultantSurgeon	55	varchar
FirstOperator	56	varchar	Ignored For No Enum
FirstAssistant	57	varchar	Ignored For No Enum
FirstAssistantGrade	58	varchar
FirstAssistant_CalmanYearOfTrainee	59	varchar
ResponsibleConsultantAnaesthetist	60	varchar	Ignored For No Enum
OperationFindings	61	varchar	Ignored For No Enum
ReferringCardiologist	62	varchar	Ignored For No Enum
DateOfReferral	63	datetime	Ignored For Datatype
DrugsOnAdmission	64	varchar	Ignored For No Enum
Allergies	65	varchar	Ignored For No Enum
AllOtherAssistants	66	varchar	Ignored For No Enum
WaitingListStatusUpdated	67	varchar
SprCases	68	varchar
DateOfCurrentStatus	69	datetime	Ignored For Datatype
DateOfEndStatus	70	datetime	Ignored For Datatype
DateTimeRecordCreated	71	datetime	Ignored For Datatype
DateTimeRecordLastChanged	72	datetime	Ignored For Datatype
EnteredByTag	73	varchar
EntryCurrentStatus	74	varchar
EntryEndStatus	75	varchar
HospitalTag	76	varchar
WHO_RESPONSIBLE_CONSULTANT_SURGEON	77	varchar
WHO_AGE_AT_OPERATION	78	int
WHO_REGISTRY_INDICATOR	79	varchar
WHO_POSSIBLE_DUPLICATE	80	char	Ignored For Datatype

CS2010F_PostProcedure

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

CS2010F_PreProcedure

Start Date Field: DateOfOperation

Field Name	Column ID	Type	Comments
EntryId	1	int	Ignored For Field Name
PatientId	2	int	Ignored For Field Name
DateOfOperation	3	date	Ignored For Datatype
TimeOfEntry	4	time	Ignored For Datatype
EntryStatus	5	varchar
PreviousEntry	6	int	Ignored For Field Name
NextEntry	7	int	Ignored For Field Name
AgeAtOperation	8	int
Gender	9	varchar
DateOfAdmission	10	date	Ignored For Datatype
AnginaStatusPre_Surgery	11	varchar
DyspnoeaStatusPre_Surgery	12	varchar
NumberOfPreviousMis	13	varchar
IntervalBetweenSurgeryAndLastMi	14	varchar
PreviousPci	15	varchar
PreviousCardiacSurgery	16	varchar
DateOfLastCardiacOperation	17	date	Ignored For Datatype
DiabetesManagement	18	varchar
HistoryOfHypertension	19	varchar
CigaretteSmokingHistory	20	varchar
HistoryOfPulmonaryDisease	21	varchar
HistoryOfNeurologicalDisease	22	varchar
Pre_OperativeHeartRhythm	23	varchar
DateOfLastCatheterisation	24	date	Ignored For Datatype
PaSystolic	25	int
IntravenousNitratesOrAnyHeparin	26	varchar
IntravenousInotropesPriorToAnaesthesia	27	varchar
VentilatedPreOperation	28	varchar
CardiogenicShock_pre_Operation	29	varchar
OperativeUrgency	30	varchar
FirstOperatorGrade	31	varchar
FirstOperator_CalmanYearOfTrainee	32	varchar
CardiacProcedures	33	varchar
OtherCardiacProcedures	34	varchar
OtherThoracicAndVascularProcedures	35	varchar
LeftMainStemDisease	36	varchar
ExtentOfCoronaryVesselDisease	37	varchar
ExtracardiacArteriopathy	38	varchar
EjectionFractionCategory	39	varchar
AdministrativeCategory	40	varchar
DateAndTimeOfOperation	41	varchar	Ignored For No Enum
NumberOfPreviousHeartOperations	42	int
ResponsibleConsultantSurgeon	43	varchar
FirstOperator	44	varchar
FirstAssistant	45	varchar
FirstAssistantGrade	46	varchar
FirstAssistant_CalmanYearOfTrainee	47	varchar
ResponsibleConsultantAnaesthetist	48	varchar
OperationFindings	49	varchar	Ignored For No Enum
ReferringCardiologist	50	varchar
DateOfReferral	51	date	Ignored For Datatype
DrugsOnAdmission	52	varchar
Allergies	53	varchar
AllOtherAssistants	54	varchar
WaitingListStatusUpdated	55	varchar
SprCases	56	varchar
DateOfCurrentStatus	57	date	Ignored For Datatype
DateOfEndStatus	58	date	Ignored For Datatype
DateTimeRecordCreated	59	varchar	Ignored For No Enum
DateTimeRecordLastChanged	60	varchar	Ignored For No Enum
EnteredByTag	61	varchar
EntryCurrentStatus	62	varchar
EntryEndStatus	63	varchar
HospitalTag	64	varchar

EPS_EPSINIVW

Start Date Field: DateOfAdmission

Field Name	Column ID	Type	Comments
EntryId	1	int	Ignored For Field Name
PatientId	2	int	Ignored For Field Name
DateOfEntry	3	date	Ignored For Datatype
!TimeofEPSRFA	4	time	Ignored For Datatype
EntryStatus	5	varchar
PreviousEntry	6	int	Ignored For Field Name
NextEntry	7	int	Ignored For Field Name
DateOfAdmission	8	date	Ignored For Datatype
DateOfDischarge	9	date	Ignored For Datatype
DateAddedToWaitingList	10	date	Ignored For Datatype
HospitalIdentifier	11	varchar
PatientGender	12	varchar
AgeAtOperation	13	int
PatientEthnicGroup	14	varchar
PatientAdminStatus	15	varchar
IsThisARe_Do	16	varchar
Preeps_ablationAetiology2	17	varchar
Preeps_ablationEcg	18	varchar
Prepacing_eps_ablationPresentingSymptom	19	varchar	Ignored For No Enum
GeneratorPacingMode	20	varchar
Preeps_ablationPreviousIntervention	21	varchar
Preeps_ablationArrhythmia	22	varchar
Eps_ablationIndicationForIntervention	23	varchar
Preicd_ablationQrsDuration	24	int
Date_timeOfProcedure	25	varchar	Ignored For No Enum
ProcedureUrgency	26	varchar
OperativeUrgency	27	varchar
PrimaryOperator	28	varchar	Ignored For No Enum
FirstOperatorStatus	29	varchar
SecondOperator	30	varchar	Ignored For No Enum
SecondOperatorStatus	31	varchar
ThirdOperator	32	varchar
ThirdOperatorStatus	33	varchar
Ccso	34	varchar	Ignored For No Enum
AblationProcedure_s	35	varchar	Ignored For No Enum
AccessoryPathway	36	varchar	Ignored For No Enum
NumberOfElectrodeCatheters	37	int
MappingTechnique	38	varchar
TransseptalApproach	39	varchar
Anticoagulation	40	varchar
HeparinDose_iu	41	int
TotalFluoroscopyTime	42	float
ProcedureStartTime	43	varchar	Ignored For No Enum
ProcedureEndTime	44	varchar	Ignored For No Enum
ProcedureDuration	45	int
AblationAttempted	46	varchar
WaitingTime	47	int
WhyAblationNotAttempted	48	varchar
NumberOfEnergyApplications	49	int
TotalTimeOfEnergyApplication	50	int
AblationEnergySource	51	varchar
Catheter	52	varchar	Ignored For No Enum
CatheterReach	53	varchar	Ignored For No Enum
Ga	54	varchar
WhichPulmonaryVeinsAblated	55	varchar
Success	56	varchar
TransientHeartBlock	57	varchar
AblationComplications	58	varchar
AvBlock	59	varchar
DeviceImplanted	60	varchar
IntraopDrugs2	61	varchar	Ignored For No Enum
ProcedureReport_comment	62	varchar	Ignored For No Enum
Early_24hrs_Recurrence	63	varchar
ChestDrain	64	varchar
PericardialTap	65	varchar
ArterialRepair	66	varchar
DeathOnSameAdmission	67	varchar
LateRecurrenceOfArrhythmia	68	varchar
TimeToRecurrence_months	69	int
DateLastFollow_Up	70	date	Ignored For Datatype
PreOpStay	71	int
PostOpStay	72	int
TotalHospitalStay	73	int
TotalTimeOnWaitingList	74	int
ReferringGpOrDentist	75	varchar	Ignored For No Enum
NameOfReferringGpOrDentist	76	varchar	Ignored For No Enum
GpPracticeCode	77	varchar	Ignored For No Enum
Pct	78	varchar	Ignored For No Enum
MedicalRecordNumberAtTimeOfEntry	79	varchar	Ignored For No Enum
AuditTrail	80	varchar
CatheterCcad	81	varchar	Ignored For No Enum
CatheterReachCcad	82	varchar
AfAblationStrategies	83	varchar	Ignored For No Enum
Score	84	int
Tvac_pvac	85	varchar
Height	86	float
Weight	87	float
Bmi	88	float
ScreeningDose	89	float
ExceededDrl	90	varchar
Radiographer	91	varchar
ReasonForExceedingDrl	92	varchar
DateOfCurrentStatus	93	date	Ignored For Datatype
DateOfEndStatus	94	date	Ignored For Datatype
DateTimeRecordCreated	95	varchar	Ignored For No Enum
DateTimeRecordLastChanged	96	varchar	Ignored For No Enum
EnteredByTag	97	varchar
EntryCurrentStatus	98	varchar
EntryEndStatus	99	varchar
HospitalTag	100	varchar
ImportLinkId	101	int

GGHMINAP_GGHMINAP

Start Date Field: DateofHospitalAdmission

Field Name	Column ID	Type	Comments
EntryId	1	int	Ignored For Field Name
PatientId	2	int	Ignored For Field Name
DateofHospitalAdmission	3	datetime	Ignored For Datatype
TimeofHospitalAdmission	4	datetime	Ignored For Datatype
EntryStatus	5	varchar
PreviousEntry	6	int	Ignored For Field Name
NextEntry	7	int	Ignored For Field Name
Age	8	int
DateOfAdmissionToCcu	9	datetime	Ignored For Datatype
DirectAdmission	10	varchar
GenderCcad	11	varchar
EthnicOriginCcad	12	varchar
PatientAdminStatusCcad	13	varchar
HospitalCentreCode	14	varchar
GpPracticeCodeCcad	15	varchar	Ignored For No Enum
InitialDiagnosisCcad	16	varchar
OtherAdmissionDiagnosis	17	varchar
MethodOfAdmissionCcad	18	varchar
EcgDeterminingTreatmentCcad	19	varchar
WhereWasAspirin_otherAntiplateletGivenCcad	20	varchar
PreviousAmiCcad	21	varchar
PreviousAnginaCcad	22	varchar
HypertensionCcad	23	varchar
HypercholesterolaemiaCcad	24	varchar
PeripheralVascularDiseaseCcad	25	varchar
CerebrovascularDiseaseCcad	26	varchar
AsthmaOrCopdCcad	27	varchar
ChronicRenalFailureCcad	28	varchar
HeartFailureCcad	29	varchar
CardiacEnzymes_markersRaisedCcad	30	varchar
SerumCholesterolCcad	31	float
SmokingStatusCcad	32	varchar
DiabetesCcad	33	varchar
PreviousPciCcad	34	varchar
PreviousCabgCcad	35	varchar
SystolicBpCcad	36	int
HeartRateCcad	37	int
AdmittingConsultantCcad	38	varchar
PlaceFirst12LeadEcgPerformedCcad	39	varchar
BetaBlockerUseCcad	40	varchar
Ace1OrArbUseCcad	41	varchar
StatinUseCcad	42	varchar
ClopidogrelUseCcad	43	varchar
HeightCcad	44	float
WeightCcad	45	float
LeftVentricularEjectionFractionCcad	46	varchar
FamilyHistoryOfChdCcad	47	varchar
AmbulanceDriver	48	varchar
AmbulanceAttendant	49	varchar
AmbulanceResponder	50	varchar
TimeLeftScene	51	varchar	Ignored For No Enum
OnsetOfSymptomsCcad	52	varchar	Ignored For No Enum
CallForHelpCcad	53	varchar	Ignored For No Enum
ArrivalOfFirstProfessionalHelpCcad	54	varchar	Ignored For No Enum
ArrivalOfEmergencyServiceCcad	55	varchar	Ignored For No Enum
AmbulanceJobNumberCcad	56	varchar	Ignored For No Enum
ArrivalAtHospitalCcad	57	varchar	Ignored For No Enum
WasReperfusionAttempted_Ccad	58	varchar
ReasonThrombolyticTreatmentNotGivenCcad	59	varchar
StartOfReperfusionTreatmentCcad	60	varchar	Ignored For No Enum
DelayBeforeTreatmentCcad	61	varchar
WhereWasInitialReperfusionTreatmentGiven_Ccad	62	varchar
WhoTookTheInitialDecisionToAttemptReperfusion_Ccad	63	varchar
FirstCardiacArrestCcad	64	varchar	Ignored For No Enum
CardiacArrestCcad	65	varchar
ArrestPresentingRhythmCcad	66	varchar
OutcomeOfArrestCcad	67	varchar
AdmissionWardCcad	68	varchar
PeakCreatinineKinase_ck_Ccad	69	float
PeakTroponinCcad	70	float
TroponinAssayCcad	71	varchar
TroponinReferenceValue	72	varchar
UnfractionatedHeparinCcad	73	varchar
LowMolecularWeightHeparinCcad	74	varchar
ThienopyridinePlateletInhibitorCcad	75	varchar
OtherOralAntiplateletAgentCcad	76	varchar
Iv2b_3aAgentCcad	77	varchar
IvBetaBlockerCcad	78	varchar
CalciumChannelBlockerCcad	79	varchar
IvNitrateCcad	80	varchar
OralNitratesCcad	81	varchar
PotassiumChannelModulatorCcad	82	varchar
WarfarinCcad	83	varchar
AngiotensinIiBlocker_arb_Ccad	84	varchar
ThiazideDiureticCcad	85	varchar
AdmissionPlasmaGlucoseCcad	86	float
LoopDiureticCcad	87	varchar
SpironolactoneCcad	88	varchar
ThrombolyticDrugCcad	89	varchar
DateOfDischargeOrDeathCcad	90	datetime	Ignored For Datatype
DateOfDischargeFromCcu	91	datetime	Ignored For Datatype
DischargedFromCcuDestination	92	varchar
DischargeDiagnosisCcad	93	varchar
OtherDischargeDiagnosis	94	varchar
DiagamiCcad	95	varchar
RecommendedTherapyAtDischargeCcad	96	varchar
DaysInHospital	97	int
DaysInCcu	98	int
BleedingComplicationsCcad	99	varchar
DeathInHospitalCcad	100	varchar
DischargedOnBetaBlockerCcad	101	varchar
AceInhibitorCcad	102	varchar
DischargedOnStatinCcad	103	varchar
DischargedOnAspirinOrOtherPlateletDrugCcad	104	varchar
CardiacRehabilitationCcad	105	varchar
ExerciseTestPerformedCcad	106	varchar
EchocardiographyCcad	107	varchar
RadionuclideStudyCcad	108	varchar
CoronaryAngiographyAtThisAdmissionCcad	109	varchar
CoronaryInterventionPerformedAtThisAdmissionCcad	110	varchar
DateOfReferralForInvestigation_intervention	111	datetime	Ignored For Datatype
ModeOfDischargeCcad	112	varchar
DateOfTransferForDayCaseInvestigationCcad	113	datetime	Ignored For Datatype
DateOfAngioPerformedLocallyCcad	114	datetime	Ignored For Datatype
DateOfFirstInterventionOrSurgeryPerformedLocallyCc	115	datetime	Ignored For Datatype
ReferralCentreCcad	116	varchar
ReferringHospitalCcad	117	varchar
PatientCaseRecordNumberAtReferralCentreCcad	118	varchar	Ignored For No Enum
FollowedUpByCcad	119	varchar
ReinfarctionCcad	120	varchar
DischargedOnClopidogrelCcad	121	varchar
DelayFromOnsetOfSymptomsToCallForHelp	122	float
DelayFromCallForHelpToArrivalOfEmergencyServices	123	float
DelayFromCallForHelpToArrivalInHospital	124	float
DelayFromArrivalInHospitalToReperfusionTreatment	125	float
DelayFromCallForHelpToReperfusionTreatment	126	float
DelayFromOnsetOfSymptomsToReperfusionTreatment	127	float
TotalTimeOnScene	128	float
DelayFromReferralForInvestigation_interventionToTr	129	float
PctCode	130	varchar	Ignored For No Enum
MedicalRecordNumberAtTimeOfEntryCcad	131	varchar	Ignored For No Enum
Comments	132	varchar	Ignored For No Enum
PreAlertCall	133	varchar
PickUpPostCode	134	varchar	Ignored For No Enum
CardiacNurseInAttendance	135	varchar
Cox_2InhibitorUse	136	varchar
NsaidUse	137	varchar
NitrateUse	138	varchar
CalciumChannelBlockerUse	139	varchar
Spironolactone	140	varchar
Eplerenone	141	varchar
Nitrates	142	varchar
Warfarin	143	varchar
Other	144	varchar
DateAndTimeOfFirstDiagnosticEcg	145	varchar
AuditTrail	146	varchar
DaysFromAdmissionToDeath	147	int
DateOfCurrentStatus	148	datetime	Ignored For Datatype
DateOfEndStatus	149	datetime	Ignored For Datatype
DateTimeRecordCreated	150	datetime	Ignored For Datatype
DateTimeRecordLastChanged	151	datetime	Ignored For Datatype
EnteredByTag	152	varchar
EntryCurrentStatus	153	varchar
EntryEndStatus	154	varchar
HospitalTag	155	varchar

GGHMINAPNEW

Start Date Field: !DateofAdmissiontoCCU

Field Name	Column ID	Type	Comments
EntryId	1	int	Ignored For Field Name
PatientId	2	int	Ignored For Field Name
!DateofAdmissiontoCCU	3	datetime	Ignored For Datatype
!TimeofAdmissiontoCCU	4	datetime	Ignored For Datatype
EntryStatus	5	varchar
PreviousEntry	6	int	Ignored For Field Name
NextEntry	7	int	Ignored For Field Name
OnsetOfSymptomsCcad	8	varchar	Ignored For No Enum
MethodOfAdmissionCcad	9	varchar
CallForHelpCcad	10	varchar	Ignored For No Enum
ArrivalOfEmergencyServiceCcad	11	varchar	Ignored For No Enum
ArrivalAtHospitalCcad	12	varchar	Ignored For No Enum
DateAndTimeOfReperfusionTreatmentCcad	13	varchar	Ignored For No Enum
FirstCardiacArrestCcad	14	varchar	Ignored For No Enum
CardiacArrestLocationCcad	15	varchar
ArrestPresentingRhythmCcad	16	varchar
OutcomeOfArrestCcad	17	varchar
InitialDiagnosisCcad	18	varchar
EcgDeterminingTreatmentCcad	19	varchar
AdditionalReperfusionTreatmentCcad	20	varchar
WhereWasInitialReperfusionTreatmentGiven_Ccad	21	varchar
WhoTookTheInitialDecisionToAttemptReperfusion_Ccad	22	varchar
ReasonReperfusionTreatmentNotGivenCcad	23	varchar
Age	24	int
WhereWasAspirin_otherAntiplateletGivenCcad	25	varchar
AdmissionWardCcad	26	varchar
AdmittingConsultantCcad	27	varchar
DischargeDiagnosisCcad	28	varchar
DeathInHospitalCcad	29	varchar
DateOfDischargeOrDeathCcad	30	datetime	Ignored For Datatype
DischargedOnBetaBlockerCcad	31	varchar
AceInhibitorCcad	32	varchar
DischargedOnStatinCcad	33	varchar
DischargedOnAspirinOrOtherPlateletDrugCcad	34	varchar
CardiacRehabilitationCcad	35	varchar
ExerciseTestPerformedCcad	36	varchar
EchocardiographyCcad	37	varchar
RadionuclideStudyCcad	38	varchar
CoronaryAngiographyCcad	39	varchar
CoronaryInterventionCcad	40	varchar
GenderCcad	41	varchar
DelayBeforeTreatmentCcad	42	varchar
DaysInHospital	43	int
DelayFromOnsetOfSymptomsToCallForHelp	44	float
DelayFromCallForHelpToArrivalOfEmergencyServices	45	float
DelayFromCallForHelpToArrivalInHospital	46	float
DelayFromArrivalInHospitalToReperfusionTreatment	47	float
DelayFromCallForHelpToReperfusionTreatment	48	float
DelayFromOnsetOfSymptomsToReperfusionTreatment	49	float
AmbulanceJobNumberCcad	50	varchar	Ignored For No Enum
PeakCreatinineKinase_ck_Ccad	51	float
PeakTroponinCcad	52	float
TroponinAssayCcad	53	varchar
TroponinReferenceValue	54	varchar
PatientAdminStatusCcad	55	varchar
PreviousAmiCcad	56	varchar
PreviousAnginaCcad	57	varchar
HypertensionCcad	58	varchar
HypercholesterolaemiaCcad	59	varchar
PeripheralVascularDiseaseCcad	60	varchar
CerebrovascularDiseaseCcad	61	varchar
AsthmaOrCopdCcad	62	varchar
ChronicRenalFailureCcad	63	varchar
HeartFailureCcad	64	varchar
CardiacEnzymes_markersRaisedCcad	65	varchar
SerumCholesterolCcad	66	float
SmokingStatusCcad	67	varchar
DiabetesCcad	68	varchar
PreviousPciCcad	69	varchar
PreviousCabgCcad	70	varchar
SystolicBpCcad	71	int
HeartRateCcad	72	int
ArrivalOfFirstProfessionalHelpCcad	73	varchar	Ignored For No Enum
UnfractionatedHeparinCcad	74	varchar
LowMolecularWeightHeparinCcad	75	varchar
ThienopyridinePlateletInhibitorCcad	76	varchar
OtherOralAntiplateletAgentCcad	77	varchar
Iv2b_3aAgentCcad	78	varchar
IvBetaBlockerCcad	79	varchar
CalciumChannelBlockerCcad	80	varchar
IvNitrateCcad	81	varchar
OralNitratesCcad	82	varchar
PotassiumChannelModulatorCcad	83	varchar
WarfarinCcad	84	varchar
AngiotensinIiBlocker_arb_Ccad	85	varchar
ThiazideDiureticCcad	86	varchar
LoopDiureticCcad	87	varchar
SpironolactoneCcad	88	varchar
ThrombolyticDrugCcad	89	varchar
BleedingComplicationsCcad	90	varchar
DischargeDestinationCcad	91	varchar
DateOfReferralForInvestigation_intervention	92	datetime	Ignored For Datatype
DaycaseTransferDateCcad	93	datetime	Ignored For Datatype
LocalAngioDateCcad	94	datetime	Ignored For Datatype
LocalInterventionDateCcad	95	datetime	Ignored For Datatype
InterventionalCentreCodeCcad	96	varchar
OtherAdmissionDiagnosis	97	varchar
OtherDischargeDiagnosis	98	varchar
DischargedFromCcuDestination	99	varchar
Gp_pctCodeCcad	100	varchar	Ignored For No Enum
DelayFromReferralForInvestigation_interventionToTr	101	float
PctCode	102	varchar	Ignored For No Enum
MedicalRecordNumberAtTimeOfEntryCcad	103	varchar	Ignored For No Enum
SerumGlucoseCcad	104	float
DiabeticTherapyAtDischargeCcad	105	varchar
AuditTrail	106	varchar
PlaceFirst12LeadEcgPerformedCcad	107	varchar
BetaBlockerUseCcad	108	varchar
Ace1OrArbUseCcad	109	varchar
StatinUseCcad	110	varchar
ClopidogrelUseCcad	111	varchar
HeightCcad	112	float
WeightCcad	113	float
LeftVentricularEjectionFractionCcad	114	varchar
FamilyHistoryOfChdCcad	115	varchar
FollowedUpByCcad	116	varchar
ReinfarctionCcad	117	varchar
DischargedOnClopidogrelCcad	118	varchar
ReferringHospitalCodeCcad	119	varchar
PatientCaseRecordNumberAtReferringHospitalCcad	120	varchar	Ignored For No Enum
AmbulanceDriver	121	varchar
AmbulanceAttendant	122	varchar
AmbulanceResponder	123	varchar
Comments	124	varchar
PreAlertCall	125	varchar
PickUpPostCode	126	varchar	Ignored For No Enum
CardiacNurseInAttendance	127	varchar
Cox_2InhibitorUse	128	varchar
NsaidUse	129	varchar
NitrateUse	130	varchar
CalciumChannelBlockerUse	131	varchar
Spironolactone	132	varchar
Eplerenone	133	varchar
Nitrates	134	varchar
Warfarin	135	varchar
Other	136	varchar
TimeLeftScene	137	varchar	Ignored For No Enum
HospitalCentreCode	138	varchar
TotalTimeOnScene	139	float
DateAndTimeOfFirstDiagnosticEcg	140	varchar	Ignored For No Enum
CardiologicalCareDuringAdmissionCcad	141	varchar
CreatinineCcad	142	float
HaemoglobinCcad	143	float
SiteOfInfarctionCcad	144	varchar
FondaparinuxCcad	145	varchar
InitialReperfusionTreatmentCcad	146	varchar
InPatientManagementOfHyperglycaemia_diabetesCcad	147	varchar
DateOfReturnToReferringHospital	148	datetime	Ignored For Datatype
DelayForCallToFrv	149	float
DelayFrvToFullCrew	150	float
DelayCallToDepart	151	float
PatientEthnicGroup	152	varchar
IncludeInD2n	153	varchar
OtherComments	154	varchar	Ignored For No Enum
CathLabArrivalTime	155	varchar
BalloonTime	156	varchar
DelayCcuToLab	157	float
DelayCallToBalloon	158	float
DelayDoorToBalloon	159	float
DelayLabToBalloon	160	float
IncludeInCallToNeedle	161	varchar
HospitalRefferedFrom	162	varchar
FirstMustafa1	163	int
SecondMustafa2	164	int
DaysFromAdmissionToDeath	165	int
DateOfCurrentStatus	166	datetime	Ignored For Datatype
DateOfEndStatus	167	datetime	Ignored For Datatype
DateTimeRecordCreated	168	datetime	Ignored For Datatype
DateTimeRecordLastChanged	169	datetime	Ignored For Datatype
EnteredByTag	170	varchar
EntryCurrentStatus	171	varchar
EntryEndStatus	172	varchar
HospitalTag	173	varchar

GGHMINAPNEW_GGHMINAPINIVW

Start Date Field: DateofAdmissiontoCCU

Field Name	Column ID	Type	Comments
EntryId	1	int	Ignored For Field Name
PatientId	2	int	Ignored For Field Name
!DateofAdmissiontoCCU	3	date	Ignored For Datatype
!TimeofAdmissiontoCCU	4	time	Ignored For Datatype
EntryStatus	5	varchar
PreviousEntry	6	int	Ignored For Field Name
NextEntry	7	int	Ignored For Field Name
OnsetOfSymptomsCcad	8	varchar	Ignored For No Enum
MethodOfAdmissionCcad	9	varchar
CallForHelpCcad	10	varchar	Ignored For No Enum
ArrivalOfEmergencyServiceCcad	11	varchar	Ignored For No Enum
ArrivalAtHospitalCcad	12	varchar	Ignored For No Enum
DateAndTimeOfReperfusionTreatmentCcad	13	varchar	Ignored For No Enum
FirstCardiacArrestCcad	14	varchar	Ignored For No Enum
CardiacArrestLocationCcad	15	varchar
ArrestPresentingRhythmCcad	16	varchar
OutcomeOfArrestCcad	17	varchar
InitialDiagnosisCcad	18	varchar
EcgDeterminingTreatmentCcad	19	varchar
AdditionalReperfusionTreatmentCcad	20	varchar
WhereWasInitialReperfusionTreatmentGiven_Ccad	21	varchar
WhoTookTheInitialDecisionToAttemptReperfusion_Ccad	22	varchar
ReasonReperfusionTreatmentNotGivenCcad	23	varchar
Age	24	int
WhereWasAspirin_otherAntiplateletGivenCcad	25	varchar
AdmissionWardCcad	26	varchar
AdmittingConsultantCcad	27	varchar
DischargeDiagnosisCcad	28	varchar
DeathInHospitalCcad	29	varchar
DateOfDischargeOrDeathCcad	30	date	Ignored For Datatype
DischargedOnBetaBlockerCcad	31	varchar
AceInhibitorCcad	32	varchar
DischargedOnStatinCcad	33	varchar
DischargedOnAspirinOrOtherPlateletDrugCcad	34	varchar
CardiacRehabilitationCcad	35	varchar
ExerciseTestPerformedCcad	36	varchar
EchocardiographyCcad	37	varchar
RadionuclideStudyCcad	38	varchar
CoronaryAngiographyCcad	39	varchar
CoronaryInterventionCcad	40	varchar
GenderCcad	41	varchar
DelayBeforeTreatmentCcad	42	varchar
DaysInHospital	43	int
DelayFromOnsetOfSymptomsToCallForHelp	44	float
DelayFromCallForHelpToArrivalOfEmergencyServices	45	float
DelayFromCallForHelpToArrivalInHospital	46	float
DelayFromArrivalInHospitalToReperfusionTreatment	47	float
DelayFromCallForHelpToReperfusionTreatment	48	float
DelayFromOnsetOfSymptomsToReperfusionTreatment	49	float
AmbulanceJobNumberCcad	50	varchar	Ignored For No Enum
PeakCreatinineKinase_ck_Ccad	51	float
PeakTroponinCcad	52	float
TroponinAssayCcad	53	varchar
TroponinReferenceValue	54	varchar
PatientAdminStatusCcad	55	varchar
PreviousAmiCcad	56	varchar
PreviousAnginaCcad	57	varchar
HypertensionCcad	58	varchar
HypercholesterolaemiaCcad	59	varchar
PeripheralVascularDiseaseCcad	60	varchar
CerebrovascularDiseaseCcad	61	varchar
AsthmaOrCopdCcad	62	varchar
ChronicRenalFailureCcad	63	varchar
HeartFailureCcad	64	varchar
CardiacEnzymes_markersRaisedCcad	65	varchar
SerumCholesterolCcad	66	float
SmokingStatusCcad	67	varchar
DiabetesCcad	68	varchar
PreviousPciCcad	69	varchar
PreviousCabgCcad	70	varchar
SystolicBpCcad	71	int
HeartRateCcad	72	int
ArrivalOfFirstProfessionalHelpCcad	73	varchar	Ignored For No Enum
UnfractionatedHeparinCcad	74	varchar
LowMolecularWeightHeparinCcad	75	varchar
ThienopyridinePlateletInhibitorCcad	76	varchar
OtherOralAntiplateletAgentCcad	77	varchar
Iv2b_3aAgentCcad	78	varchar
IvBetaBlockerCcad	79	varchar
CalciumChannelBlockerCcad	80	varchar
IvNitrateCcad	81	varchar
OralNitratesCcad	82	varchar
PotassiumChannelModulatorCcad	83	varchar
WarfarinCcad	84	varchar
AngiotensinIiBlocker_arb_Ccad	85	varchar
ThiazideDiureticCcad	86	varchar
LoopDiureticCcad	87	varchar
SpironolactoneCcad	88	varchar
ThrombolyticDrugCcad	89	varchar
BleedingComplicationsCcad	90	varchar
DischargeDestinationCcad	91	varchar
DateOfReferralForInvestigation_intervention	92	date	Ignored For Datatype
DaycaseTransferDateCcad	93	date	Ignored For Datatype
LocalAngioDateCcad	94	date	Ignored For Datatype
LocalInterventionDateCcad	95	date	Ignored For Datatype
OtherAdmissionDiagnosis	96	varchar
OtherDischargeDiagnosis	97	varchar
DischargedFromCcuDestination	98	varchar
Gp_pctCodeCcad	99	varchar	Ignored For No Enum
DelayFromReferralForInvestigation_interventionToTr	100	float
PctCode	101	varchar	Ignored For No Enum
MedicalRecordNumberAtTimeOfEntryCcad	102	varchar	Ignored For No Enum
SerumGlucoseCcad	103	float
DiabeticTherapyAtDischargeCcad	104	varchar
AuditTrail	105	text	Ignored For Datatype
PlaceFirst12LeadEcgPerformedCcad	106	varchar
BetaBlockerUseCcad	107	varchar
Ace1OrArbUseCcad	108	varchar
StatinUseCcad	109	varchar
ClopidogrelUseCcad	110	varchar
HeightCcad	111	float
WeightCcad	112	float
LeftVentricularEjectionFractionCcad	113	varchar
FamilyHistoryOfChdCcad	114	varchar
FollowedUpByCcad	115	varchar
ReinfarctionCcad	116	varchar
DischargedOnClopidogrelCcad	117	varchar
PatientCaseRecordNumberAtReferringHospitalCcad	118	varchar	Ignored For No Enum
AmbulanceDriver	119	varchar
AmbulanceAttendant	120	varchar
AmbulanceResponder	121	varchar
Comments	122	text	Ignored For Datatype
PreAlertCall	123	varchar
PickUpPostCode	124	varchar	Ignored For No Enum
CardiacNurseInAttendance	125	varchar
Cox_2InhibitorUse	126	varchar
NsaidUse	127	varchar
NitrateUse	128	varchar
CalciumChannelBlockerUse	129	varchar
Spironolactone	130	varchar
Eplerenone	131	varchar
Nitrates	132	varchar
Warfarin	133	varchar
Other	134	varchar
TimeLeftScene	135	varchar	Ignored For No Enum
HospitalCentreCode	136	varchar
TotalTimeOnScene	137	float
DateAndTimeOfFirstDiagnosticEcg	138	varchar	Ignored For No Enum
CardiologicalCareDuringAdmissionCcad	139	varchar
CreatinineCcad	140	float
HaemoglobinCcad	141	float
SiteOfInfarctionCcad	142	varchar
FondaparinuxCcad	143	varchar
InitialReperfusionTreatmentCcad	144	varchar
InPatientManagementOfHyperglycaemia_diabetesCcad	145	varchar
DateOfReturnToReferringHospital	146	date	Ignored For Datatype
DelayForCallToFrv	147	float
DelayFrvToFullCrew	148	float
DelayCallToDepart	149	float
PatientEthnicGroup	150	varchar
IncludeInD2n	151	varchar
OtherComments	152	varchar	Ignored For No Enum
CathLabArrivalTime	153	varchar
BalloonTime	154	varchar
DelayCcuToLab	155	float
DelayCallToBalloon	156	float
DelayDoorToBalloon	157	float
DelayLabToBalloon	158	float
IncludeInCallToNeedle	159	varchar
HospitalRefferedFrom	160	varchar
FirstMustafa1	161	int
SecondMustafa2	162	int
DaysFromAdmissionToDeath	163	int
InterventionalCentreCodeCcad	164	varchar
ReferringHospitalCodeCcad	165	varchar
TimeFromAdmissionToFirstEcg	166	float
EcgQrsComplexDurationCcad	167	varchar
AldosteroneAntagonistCcad	168	varchar
DischargedOnThienopyridineInhibitorCcad	169	varchar
DischargedOnAnAldosteroneAntagonistCcad	170	varchar
WhatProcedureWasPerformedAtTheInterventionalHospit	171	varchar
SmokingCessationAdviceGivenCcad	172	varchar
DietaryAdviceGivenDuringThisAdmissionCcad	173	varchar
OralBetaBlockerCcad	174	varchar
DateAndTimeArrivalAtNonInterventionalHospitalCcad	175	varchar	Ignored For No Enum
AssessmentAtNonInterventionalHospitalCcad	176	varchar
AssessmentAtInterventionalCentreCcad	177	varchar
IntendedReprofusionProcedureCcad	178	varchar
ProcedurePerformedCcad	179	varchar
WhyWasNoAngiogramPerformed_Ccad	180	varchar
WhyWasNoInterventionPerformedCcad	181	varchar
PatientLocationAtTimeOfStemiOnset	182	varchar
AcsAuditSite	183	varchar
AcsAuditWard	184	varchar
AcsAuditHowManyDosesOfLmwh	185	int
AcsAuditCardiologicalOpinionRequestedDuringAdmissi	186	varchar
AcsAuditAdmittedFrom	187	varchar
AcsAuditTimiScore	188	varchar
AcsAuditRiskStrarification	189	varchar
AcsAuditDateAndTimeOfEtt	190	varchar
AcsAuditDateAndTimeOfEcho	191	varchar
AcsAuditDateAndTimeOfAngiography	192	varchar
AcsAuditDateAndTimeOfPci_Cabg	193	varchar
AcsAuditDischargedOnSublingualGtn	194	varchar
AcsAuditComments	195	text	Ignored For Datatype
DateOfCurrentStatus	196	date	Ignored For Datatype
DateOfEndStatus	197	date	Ignored For Datatype
DateTimeRecordCreated	198	varchar	Ignored For No Enum
DateTimeRecordLastChanged	199	varchar	Ignored For No Enum
EnteredByTag	200	varchar
EntryCurrentStatus	201	varchar
EntryEndStatus	202	varchar
HospitalTag	203	varchar
ImportLinkId	204	int

GGHPACEICD_GGHPACEICDINIALVW

Start Date Field: DateOfProcedure_Implant

Field Name	Column ID	Type	Comments
EntryId	1	int	Ignored For Field Name
PatientId	2	int	Ignored For Field Name
DateOfProcedure_Implant	3	date	Ignored For Datatype
TimeOfProcedure_Implant	4	time	Ignored For Datatype
EntryStatus	5	varchar
PreviousEntry	6	int	Ignored For Field Name
NextEntry	7	int	Ignored For Field Name
HospitalIdentifierCcad	8	varchar
PatientGenderCcad	9	varchar
PatientEthnicGroupCcad	10	varchar
PatientAdminStatusCcad	11	varchar
AuditTrail	12	text	Ignored For Datatype
AgeAtProcedure	13	int
DateOfAdmission	14	date	Ignored For Datatype
DateOfFirstImplantCcad	15	date	Ignored For Datatype
PredeviceAetiologyCcad	16	varchar	Ignored For No Enum
Predevice_eps_ablationPresentingSymptomCcad	17	varchar	Ignored For No Enum
PredeviceEcgCcad	18	varchar	Ignored For No Enum
NyhaDyspnoeaStatus_pre_ProcedureStableOnly_Ccad	19	varchar
LvFunctionAssessmentCcad	20	varchar
Lvef_30_Nice	21	varchar
IcdIndicationCcad	22	varchar
Predevice_ablationQrsDuration_ms_Ccad	23	float
DateAndTimeProcedureStart	24	varchar	Ignored For No Enum
DateAndTimeProcedureEnd	25	varchar	Ignored For No Enum
TotalTimeOfProcedure	26	int
InterventionCcad	27	varchar
ConsultantResponsibleForProcedureCcad	28	varchar
PrimaryOperatorCcadOldData	29	varchar	Ignored For No Enum
GeneratorPacingModeCcad	30	varchar
GeneratorManufacturerCcad	31	varchar
GeneratorModelCcad	32	varchar	Ignored For No Enum
GeneratorSerialNumberCcad	33	varchar	Ignored For No Enum
GeneratorSiteOfImplantCcad	34	varchar
DateGeneratorChangedCcad	35	date	Ignored For Datatype
WhyThisGeneratorEventuallyExplantedCcad	36	varchar
VentricularLeadManufacturerCcad	37	varchar
VentricularLeadModelCcad	38	varchar	Ignored For No Enum
VentricularLeadSerialNumberCcad	39	varchar	Ignored For No Enum
VentricularLeadImplantApproachCcad	40	varchar
DateVentricularLeadChangedCcad	41	date	Ignored For Datatype
!WhyThisVLeadEventuallyExplantedCcad	42	varchar
AtrialLeadManufacturerCcad	43	varchar
AtrialLeadModelCcad	44	varchar	Ignored For No Enum
AtrialLeadSerialNumberCcad	45	varchar	Ignored For No Enum
AtrialLeadImplantApproachCcad	46	varchar
DateAtrialLeadChangedCcad	47	date	Ignored For Datatype
!WhyThisALeadEventuallyExplantedCcad	48	varchar
VentricularLead2ManufacturerCcad	49	varchar
VentricularLead2ModelCcad	50	varchar	Ignored For No Enum
VentricularLead2SerialNumberCcad	51	varchar	Ignored For No Enum
VentricularLead2ImplantApproachCcad	52	varchar
DateVentricularLead2ChangedCcad	53	date	Ignored For Datatype
WhyThisVLead2EventuallyExplantedCcad	54	varchar
AtrialLead2ManufacturerCcad	55	varchar
AtrialLead2ModelCcad	56	varchar
AtrialLead2SerialNumberCcad	57	varchar
AtrialLead2ImplantApproachCcad	58	varchar
DateAtrialLead2ChangedCcad	59	date	Ignored For Datatype
WhyThisALead2EventuallyExplantedCcad	60	varchar
IcdFunctionCcad	61	varchar
BivFunctionCcad	62	varchar
DefbrillatorLeadSiteCcad	63	varchar
PacingProcedureComplicationsCcad	64	varchar
BradycardiaPacingOn_Ccad	65	varchar
BradycardiaPacingModeCcad	66	varchar
PacingRate_low_Ccad	67	float
Anti_TachycardiaPacingOn_Ccad	68	varchar
VtShockTherapyOn_Ccad	69	varchar
VfShockTherapyOn_Ccad	70	varchar
BiventricularPacingOn_Ccad	71	varchar
AvDelay_sensed_Ccad	72	int
AvDelay_paced	73	int
BiventricularDelay_paced	74	int
BiventricularPacingWhichChamberPacedFirst_Ccad	75	varchar
LeadExtractedCcad	76	varchar
DateOfFileClosureCcad	77	date	Ignored For Datatype
DeviceFileClosureCcad	78	varchar
EpsTestedNice	79	varchar
TypeOfProcedure	80	varchar
Ccso	81	varchar	Ignored For No Enum
DateOfVentricularLeadImplant	82	date	Ignored For Datatype
TypeOfVentricularLeadProcedure	83	varchar
TemporaryWire	84	varchar
PolarityOfVentricularLead	85	varchar
ConnectorAtrialLead	86	varchar
ConnectorVentricularLead	87	varchar
VentricularLeadCurrent_5v_0_5ms	88	float
VentricularLeadImpedance_ohms	89	float
VentricularLeadRWave_mv	90	float
VentricularLeadThreshold_0_5ms	91	float
VentricularLeadStability_1v	92	varchar
VentricularLeadTwitch_10v	93	varchar
VentricularLeadThresholdProblems	94	varchar
VentricularLeadConfirmCorrectConnection	95	varchar
ConfirmPacingVentricularLead	96	varchar
DateOfAtrialLeadImplant	97	date	Ignored For Datatype
TypeOfAtrialLeadProcedure	98	varchar
PolarityOfAtrialLead	99	varchar
AtrialLeadCurrent_5v_0_5ms	100	float
AtrialLeadImpedance_ohms	101	float
AtrialLeadPWave_mv	102	float
AtrialLeadThreshold_0_5ms	103	float
AtrialLeadStability_1v	104	varchar
AtrialLeadTwitch_10v	105	varchar
AtrialLeadThresholdProblems	106	varchar
AtrialLeadConfirmCorrectConnection	107	varchar
DateOfVentricularLead2Implant	108	date	Ignored For Datatype
TypeOfVentricularLead2Procedure	109	varchar
PolarityOfVentricularLead2	110	varchar
ConnectorVentricularLead2	111	varchar
VentricularLead2Current_5v_0_5ms	112	float
VentricularLead2Impedance_ohms	113	float
VentricularLead2RWave_mv	114	float
VentricularLead2Threshold_0_5ms	115	float
VentricularLead2Stability_1v	116	varchar
VentricularLead2Twitch_10v	117	varchar
VentricularLead2ThresholdProblems	118	varchar
VentricularLead2ConfirmCorrectConnection	119	varchar
ConfirmPacingVentricularLead2	120	varchar
DateOfAtrialLead2Implant	121	date	Ignored For Datatype
TypeOfAtrialLead2Procedure	122	varchar
PolarityOfAtrialLead2	123	varchar
ConnectorAtrialLead2	124	varchar
AtrialLead2Current_5v_0_5ms	125	float
AtrialLead2Impedance_ohms	126	float
AtrialLead2RWave_mv	127	float
ConfirmPacingAtrialLead	128	varchar
AtrialLeas2Threshold_0_5ms	129	float
AtrialLead2Stability_1v	130	float
AtrialLead2Twitch_10v	131	float
AtrialLead2ThresholdProblems	132	varchar
AtrialLead2ConfirmCorrectConnection	133	varchar
ConfirmPacingAtrialLead2	134	varchar
DateVentricularLeadCut_cappedAndBuried	135	date	Ignored For Datatype
DateAtrialLeadCut_cappedAndBuried	136	date	Ignored For Datatype
DateVentricularLead2Cut_cappedAndBuried	137	date	Ignored For Datatype
DateAtrialLead2Cut_cappedAndBuried	138	date	Ignored For Datatype
ProcedureReport	139	varchar	Ignored For No Enum
GpAtTimeOfProcedure	140	varchar	Ignored For No Enum
NameOfGp	141	varchar	Ignored For No Enum
GpPracticeCode	142	varchar	Ignored For No Enum
Pct	143	varchar	Ignored For No Enum
MedicalRecordNumber	144	varchar	Ignored For No Enum
NumberOfDaysDeviceImplanted	145	int
DateOfExplant	146	date	Ignored For Datatype
DateOfDischarge	147	date	Ignored For Datatype
ComplicationsBeforeDischarge	148	varchar
DateOfComplication	149	date	Ignored For Datatype
TypeOfComplication	150	varchar
IfOtherComplicationPleaseState	151	varchar
DischargeDelayedDueToComplication	152	varchar
PacemakerChecksTransferred	153	varchar
TransferredTo	154	varchar
DateOfTransfer	155	date	Ignored For Datatype
ProcedureUrgency	156	varchar
OtherOperatorsOldData	157	varchar
SideUsed	158	varchar
Ward	159	varchar	Ignored For No Enum
PrimaryOperatorCcad	160	varchar	Ignored For No Enum
OtherOperators	161	varchar	Ignored For No Enum
TotalDaysInHospital	162	float
LvPortPlugged	163	varchar
ClinicalGuidance	164	varchar
PrimaryReplacementAppropriateTherapy	165	varchar
NumberOfDaysDischargeDelayed	166	float
Height	167	float
Weight	168	float
Bmi	169	float
ScreeningTime	170	float
ScreeningDose	171	float
ExceededDrl	172	varchar
Radiographer	173	varchar
ReasonForExceedingDrl	174	varchar
SickNoteGiven	175	varchar
DurationOfSickNoteInDays	176	int
ChangesToCurrentMedication	177	varchar
NameOfDischargingDoctor	178	varchar
Grade	179	varchar
PagerNumber	180	varchar
DischargeWard	181	varchar
DischargeDestination	182	varchar
DrugSensitivity	183	varchar
Drug1	184	varchar
Route1	185	varchar
NumberOfDays1	186	int
Continue1	187	varchar
Drug2	188	varchar
Route2	189	varchar
NumberOfDays2	190	int
Continue2	191	varchar
Drug3	192	varchar
Route3	193	varchar
NumberOfDays3	194	int
Continue3	195	varchar
Drug4	196	varchar
Route4	197	varchar
NumberOfDays4	198	int
Continue4	199	varchar
Drug5	200	varchar
Route5	201	varchar
NumberOfDays5	202	int
Continue5	203	varchar
Drug6	204	varchar
Route6	205	varchar
NumberOfDays6	206	int
Continue6	207	varchar
Drug7	208	varchar
Route7	209	varchar
NumberOfDays7	210	int
Continue7	211	varchar
Drug8	212	varchar
Route8	213	varchar
NumberOfDays8	214	int
Continue8	215	varchar
Drug9	216	varchar
Route9	217	varchar
NumberOfDays9	218	int
Continue9	219	varchar
Drug10	220	varchar
Route10	221	varchar
NumberOfDays10	222	int
Continue10	223	varchar
Drug11	224	varchar
Route11	225	varchar
NumberOfDays11	226	int
Continue11	227	varchar
Drug12	228	varchar
Route12	229	varchar
NumberOfDays12	230	int
Continue12	231	varchar
Drug13	232	varchar
Route13	233	varchar
NumberOfDays13	234	int
Continue13	235	varchar
Drug14	236	varchar
Route14	237	varchar
NumberOfDays14	238	int
Continue14	239	varchar
Drug15	240	varchar
Route15	241	varchar
NumberOfDays15	242	int
Continue15	243	varchar
Drug16	244	varchar
Route16	245	varchar
NumberOfDays16	246	int
Continue16	247	varchar
Drug17	248	varchar
Route17	249	varchar
NumberOfDays17	250	int
Continue17	251	varchar
Drug18	252	varchar
Route18	253	varchar
NumberOfDays18	254	int
Continue18	255	varchar

GGHPCI_FLWGGHPCIVIEW

Start Date Field: DateOfFollowup

Field Name	Column ID	Type	Comments
FlwId	1	int
PatientId	2	int	Ignored For Field Name
EntryId	3	int	Ignored For Field Name
DateOfFollowup	4	date	Ignored For Datatype
TimeOfFollowup	5	time	Ignored For Datatype
EntryStatus	6	varchar
DateOfLastFollowup	7	date	Ignored For Datatype
DateTimeRecordCreated	8	varchar	Ignored For No Enum
DateTimeRecordLastChanged	9	varchar	Ignored For No Enum
EnteredByTag	10	varchar
HospitalTag	11	varchar
IsPrimaryFlw	12	bit	Ignored For Datatype
TimeOfLastFollowup	13	time	Ignored For Datatype

GGHPCI_INITIALGGHPCIVIEW

Start Date Field: DateofProcedureCCAD

Field Name	Column ID	Type	Comments
EntryId	1	int	Ignored For Field Name
PatientId	2	int	Ignored For Field Name
!DateofProcedureCCAD	3	date	Ignored For Datatype
!TimeofProcedureCCAD	4	time	Ignored For Datatype
EntryStatus	5	varchar
PreviousEntry	6	int	Ignored For Field Name
NextEntry	7	int	Ignored For Field Name
PatientGenderCcad	8	varchar
PatientEthnicGroupCcad	9	varchar
AdministrativeCategoryCcad	10	varchar
HospitalIdentifierCcad	11	varchar
ClinicalSyndromeCcad	12	varchar
IndicationForInterventionCcad	13	varchar
ProcedureUrgencyCcad	14	varchar
CardiogenicShockPre_Anaesthesia_pre_Pci_Ccad	15	varchar
CcsClassificationForStableAnginaCcad	16	varchar
NyhaDyspnoeaStatus_pre_Procedure_StableOnly_Ccad	17	varchar
DateAndTimeOfSymptomOnset_acs_Ccad	18	varchar	Ignored For No Enum
DateAndTimeArrivalAtHospital_acsOnly_ccad	19	varchar	Ignored For No Enum
AdmissionRoute_acs_Ccad	20	varchar
PresentingEcg_acsOnly_Ccad	21	varchar
RecentLysis_acs_Ccad	22	varchar
CardiacEnzymes_markersRaisedCcad	23	varchar
PreviousMiCcad	24	varchar
PreviousCabgCcad	25	varchar
PreviousPciCcad	26	varchar
DiabetesCcad	27	varchar
Height_cm_Ccad	28	int
Weight_kg_Ccad	29	float
LvEjectionFractionCategoryCcad	30	varchar
LvEjectionFractionCcad	31	int
NumberGraftsPresent_pre_Operation_Ccad	32	int
NumberGraftsPatent_pre_Operation_Ccad	33	int
LeftMainStemStenosis_pre_Pci_Ccad	34	varchar
LadProximalStenosis_pre_Pci_Ccad	35	varchar
LadOtherStenosis_pre_Pci_Ccad	36	varchar
RcaStenosis_pre_Pci_Ccad	37	varchar
CxStenosis_pre_Pci_Ccad	38	varchar
OtherStenosis_prePci	39	varchar
FlowInIraPreop_acs_Ccad	40	varchar
DateAndTimeOfOperation	41	varchar	Ignored For No Enum
ConsultantResponsibleForProcedureCcad	42	varchar
FirstOperatorCcad	43	varchar	Ignored For No Enum
PrimaryOperatorStatusCcad	44	varchar
SecondOperatorCcad	45	varchar	Ignored For No Enum
SecondOperatorStatusCcad	46	varchar
ThirdOperatorCcad	47	varchar	Ignored For No Enum
ThirdOperatorStatusCcad	48	varchar
VesselsAttemptedCcad	49	varchar	Ignored For No Enum
NumberOfVesselsAttempted_notEpicardialTerritories_	50	int
NumberOfLesionsAttemptedCcad	51	int
NumberOfChronicOcclusionsAttemptedCcad	52	int
NumberRestenosesAttemptedCcad	53	int
NumberInstentStenosesAttemptedCcad	54	int
NumberStentsUsedCcad	55	int
NumberDrug_ElutingStentsUsedCcad	56	int
Drug_s_ElutedByStent_s_Ccad	57	varchar	Ignored For No Enum
GpIib_iiiaDrug_s_UsedDuringProcedureCcad	58	varchar
DiagnosticDevice_s_UsedDuringProcedureCcad	59	varchar
ProceduralDevice_s_UsedCcad	60	varchar
Athero_ThrombusRemovalDevice_s_UsedCcad	61	varchar
BrachytherapyDevice_s_UsedCcad	62	varchar
EmboliProtectionDevice_s_UsedCcad	63	varchar
CirculatorySupportCcad	64	varchar
ArterialManagementCcad	65	varchar
Date_timeOfFirstBalloonInflation_pci_Ccad	66	varchar	Ignored For No Enum
LeftMainStemStenosis_postPci_Ccad	67	varchar
LadProximalStenosis_postPci_Ccad	68	varchar
LadOtherStenosis_postPci_Ccad	69	varchar
RcaStenosis_postPci_Ccad	70	varchar
CxStenosis_postPci_Ccad	71	varchar
OtherStenosis_postPci	72	varchar
NumberLesionsSuccessfulCcad	73	int
NumberCoronaryGraftsPatentPostopCcad	74	int
FlowInIraPostop_acs_Ccad	75	varchar
ProcedureReport_commentCcad	76	varchar	Ignored For No Enum
DeviceFailureCcad	77	varchar
PciHospitalOutcomeCcad	78	varchar	Ignored For No Enum
EnzymesPostopCcad	79	varchar
StatusAtDischargeCcad	80	varchar
DischargeDateCcad	81	date	Ignored For Datatype
LocalProcedureIdentifierCcad	82	varchar
CholesterolCcad	83	float
SmokingStatusCcad	84	varchar
FamilyHistoryOfCadCcad	85	varchar
MedicalHistoryCcad	86	varchar
HistoryOfRenalDiseaseCcad	87	varchar
VentilatedPreopCcad	88	varchar
!QWaveOnEcgCcad	89	varchar
EcgIschaemiaCcad	90	varchar
DrugTherapyPreopCcad	91	varchar	Ignored For No Enum
FollowOn_adhoc_ProcedureCcad	92	varchar
TrainingProcedureCcad	93	varchar
ResearchProcedureCcad	94	varchar
ResearchTitleCcad	95	varchar	Ignored For No Enum
ArterialAccessCcad	96	varchar
LargestBalloon_stentUsedCcad	97	float
LongestStented_TreatedSegmentCcad	98	int
ProceduralComplicationCcad	99	varchar	Ignored For No Enum
ArterialComplicationsCcad	100	varchar
TimeToBypassCcad	101	int
PatientStatusDuringTransferToTheatreCcad	102	varchar
WhyNoIib_iiiaDuringProcedureCcad	103	varchar
IndicationForStentCcad	104	varchar
SurgicalCoverCcad	105	varchar
LeftMainStemProtectedCcad	106	varchar
LmsQuestion1	107	varchar
LmsQuestion2	108	varchar
LmsQuestion3	109	varchar
BifurcationQuestion1	110	varchar
BifurcationQuestion2	111	varchar
ChronicTotalOcclusion	112	varchar
VesselWithChronicTotalOcclusion	113	varchar
TypeOfOcclusion	114	varchar
OcclusionSuccess	115	varchar
InstentRestenosisDecribe	116	varchar
BmsSize	117	varchar	Ignored For No Enum
DesSize	118	varchar	Ignored For No Enum
InstentRestenosisType	119	varchar
GraftType	120	varchar
TypeOfLesionLeftMainStem	121	varchar
TypeOfLesionLadProximal	122	varchar
TypeOfLesionLadOther	123	varchar
TypeOfLesionRca	124	varchar
TypeOfLesionCx	125	varchar
TypeOfLesionOther	126	varchar
TypeOfLesionIra	127	varchar
Restenosis	128	varchar
Ccco	129	varchar	Ignored For No Enum
MedicalRecordNumberAtTimeOfEntry	130	varchar	Ignored For No Enum
NameOfReferringGp	131	varchar	Ignored For No Enum
Gp	132	varchar	Ignored For No Enum
Pct	133	varchar	Ignored For No Enum
PracticeCode	134	varchar	Ignored For No Enum
DateOfDeathPostProcedure	135	date	Ignored For Datatype
IntervalBetweenProcedureAndDeath	136	int
AuditTrail	137	text	Ignored For Datatype
DateOfAdmission	138	date	Ignored For Datatype
TotalInpatientStay	139	float
ArrivalInPciHospital_acs_Ccad	140	varchar	Ignored For No Enum
DateAndTimeOfCallForHelp_stemiOnly_Ccad	141	varchar	Ignored For No Enum
ReferringHospitalCcad	142	varchar
DateAndTimeOfEcgTriggeringPpciPathwayCcad	143	varchar	Ignored For No Enum
PatientLocationAtTimeOfStemiOnset_forPatientsTreat	144	varchar
ConsultantResponsibleForProcedureGmcNumberCcad	145	varchar
PrimaryOperatorGmcNumberCcad	146	varchar
SecondOperatorGmcNumberCcad	147	varchar
ThirdOperatorGmcNumberCcad	148	varchar
Creatinine	149	float
WardConsultant	150	varchar
PinkClerkingForm	151	varchar
BlueCathLabForm	152	varchar	Ignored For No Enum
WhiteHospitalOutcome	153	varchar
AngioNumber	154	int
TimeOfArrivalInLab	155	varchar	Ignored For No Enum
TimeOnTable	156	varchar	Ignored For No Enum
TimeOfSheathInsertion	157	varchar	Ignored For No Enum
TimeOfWireAcrossFirstLesion	158	varchar	Ignored For No Enum
TimeOffTable	159	varchar	Ignored For No Enum
DateAndTimeOfStemiAlert_stemiOnly	160	varchar	Ignored For No Enum
NameOfDoctorResponsibleForCompletingForm	161	varchar
ReasonForDelaysInLab	162	varchar	Ignored For No Enum
DateOfCholesterolResult	163	date	Ignored For Datatype
WasPatientPre_LoadedWithClopidogrel	164	varchar
ClopidogrelDose	165	varchar
DiagnosticDeviceUsedDuringProcedure	166	varchar
NameOfInfarctRelatedArtery_ira	167	varchar	Ignored For No Enum
MedinaClassification	168	float
ApproachToCto	169	varchar
IfAntegradeWereRetrogradeInjectionsUsed	170	varchar
Bmi	171	float
ScreeningTime	172	float
ScreeningDose	173	float
ExceededDrl	174	varchar
Radiographer	175	varchar
FollowOnFromCatheterAtSameTime	176	varchar
ReasonFoExceedingDrl	177	varchar
DateOfCurrentStatus	178	date	Ignored For Datatype
DateOfEndStatus	179	date	Ignored For Datatype
DateTimeRecordCreated	180	varchar	Ignored For No Enum
DateTimeRecordLastChanged	181	varchar	Ignored For No Enum
EnteredByTag	182	varchar
EntryCurrentStatus	183	varchar
EntryEndStatus	184	varchar
HospitalTag	185	varchar
ImportLinkId	186	int

LRIMINAPNEW

Start Date Field: DateofAdmissiontoCCU

Field Name	Column ID	Type	Comments
EntryId	1	int	Ignored For Field Name
PatientId	2	int	Ignored For Field Name
!DateofAdmissiontoCCU	3	datetime	Ignored For Datatype
!TimeofAdmissiontoCCU	4	datetime	Ignored For Datatype
EntryStatus	5	varchar
PreviousEntry	6	int	Ignored For Field Name
NextEntry	7	int	Ignored For Field Name
OnsetOfSymptomsCcad	8	varchar	Ignored For No Enum
MethodOfAdmissionCcad	9	varchar
CallForHelpCcad	10	varchar	Ignored For No Enum
ArrivalOfEmergencyServiceCcad	11	varchar	Ignored For No Enum
ArrivalAtHospitalCcad	12	varchar	Ignored For No Enum
DateAndTimeOfReperfusionTreatmentCcad	13	varchar	Ignored For No Enum
FirstCardiacArrestCcad	14	varchar	Ignored For No Enum
CardiacArrestLocationCcad	15	varchar
ArrestPresentingRhythmCcad	16	varchar
OutcomeOfArrestCcad	17	varchar
InitialDiagnosisCcad	18	varchar
EcgDeterminingTreatmentCcad	19	varchar
AdditionalReperfusionTreatmentCcad	20	varchar
WhereWasInitialReperfusionTreatmentGiven_Ccad	21	varchar
WhoTookTheInitialDecisionToAttemptReperfusion_Ccad	22	varchar
ReasonReperfusionTreatmentNotGivenCcad	23	varchar
Age	24	int
WhereWasAspirin_otherAntiplateletGivenCcad	25	varchar
AdmissionWardCcad	26	varchar
AdmittingConsultantCcad	27	varchar
DischargeDiagnosisCcad	28	varchar
DeathInHospitalCcad	29	varchar
DateOfDischargeOrDeathCcad	30	datetime	Ignored For Datatype
DischargedOnBetaBlockerCcad	31	varchar
AceInhibitorCcad	32	varchar
DischargedOnStatinCcad	33	varchar
DischargedOnAspirinOrOtherPlateletDrugCcad	34	varchar
CardiacRehabilitationCcad	35	varchar
ExerciseTestPerformedCcad	36	varchar
EchocardiographyCcad	37	varchar
RadionuclideStudyCcad	38	varchar
CoronaryAngiographyCcad	39	varchar
CoronaryInterventionCcad	40	varchar
GenderCcad	41	varchar
DelayBeforeTreatmentCcad	42	varchar
DaysInHospital	43	int
DelayFromOnsetOfSymptomsToCallForHelp	44	float
DelayFromCallForHelpToArrivalOfEmergencyServices	45	float
DelayFromCallForHelpToArrivalInHospital	46	float
DelayFromArrivalInHospitalToReperfusionTreatment	47	float
DelayFromCallForHelpToReperfusionTreatment	48	float
DelayFromOnsetOfSymptomsToReperfusionTreatment	49	float
AmbulanceJobNumberCcad	50	varchar	Ignored For No Enum
PeakCreatinineKinase_ck_Ccad	51	float
PeakTroponinCcad	52	float
TroponinAssayCcad	53	varchar
TroponinReferenceValue	54	varchar
PatientAdminStatusCcad	55	varchar
PreviousAmiCcad	56	varchar
PreviousAnginaCcad	57	varchar
HypertensionCcad	58	varchar
HypercholesterolaemiaCcad	59	varchar
PeripheralVascularDiseaseCcad	60	varchar
CerebrovascularDiseaseCcad	61	varchar
AsthmaOrCopdCcad	62	varchar
ChronicRenalFailureCcad	63	varchar
HeartFailureCcad	64	varchar
CardiacEnzymes_markersRaisedCcad	65	varchar
SerumCholesterolCcad	66	float
SmokingStatusCcad	67	varchar
DiabetesCcad	68	varchar
PreviousPciCcad	69	varchar
PreviousCabgCcad	70	varchar
SystolicBpCcad	71	int
HeartRateCcad	72	int
ArrivalOfFirstProfessionalHelpCcad	73	varchar	Ignored For No Enum
UnfractionatedHeparinCcad	74	varchar
LowMolecularWeightHeparinCcad	75	varchar
ThienopyridinePlateletInhibitorCcad	76	varchar
OtherOralAntiplateletAgentCcad	77	varchar
Iv2b_3aAgentCcad	78	varchar
IvBetaBlockerCcad	79	varchar
CalciumChannelBlockerCcad	80	varchar
IvNitrateCcad	81	varchar
OralNitratesCcad	82	varchar
PotassiumChannelModulatorCcad	83	varchar
WarfarinCcad	84	varchar
AngiotensinIiBlocker_arb_Ccad	85	varchar
ThiazideDiureticCcad	86	varchar
LoopDiureticCcad	87	varchar
SpironolactoneCcad	88	varchar
ThrombolyticDrugCcad	89	varchar
BleedingComplicationsCcad	90	varchar
DischargeDestinationCcad	91	varchar
DateOfReferralForInvestigation_intervention	92	datetime	Ignored For Datatype
DaycaseTransferDateCcad	93	datetime	Ignored For Datatype
LocalAngioDateCcad	94	datetime	Ignored For Datatype
LocalInterventionDateCcad	95	datetime	Ignored For Datatype
OtherAdmissionDiagnosis	96	varchar
OtherDischargeDiagnosis	97	varchar
DischargedFromCcuDestination	98	varchar
Gp_pctCodeCcad	99	varchar	Ignored For No Enum
DelayFromReferralForInvestigation_interventionToTr	100	float
PctCode	101	varchar
MedicalRecordNumberAtTimeOfEntryCcad	102	varchar	Ignored For No Enum
SerumGlucoseCcad	103	float
DiabeticTherapyAtDischargeCcad	104	varchar
AuditTrail	105	varchar
PlaceFirst12LeadEcgPerformedCcad	106	varchar
BetaBlockerUseCcad	107	varchar
Ace1OrArbUseCcad	108	varchar
StatinUseCcad	109	varchar
ClopidogrelUseCcad	110	varchar
HeightCcad	111	float
WeightCcad	112	float
LeftVentricularEjectionFractionCcad	113	varchar
FamilyHistoryOfChdCcad	114	varchar
FollowedUpByCcad	115	varchar
ReinfarctionCcad	116	varchar
DischargedOnClopidogrelCcad	117	varchar
PatientCaseRecordNumberAtReferringHospitalCcad	118	varchar	Ignored For No Enum
AmbulanceDriver	119	varchar
AmbulanceAttendant	120	varchar
AmbulanceResponder	121	varchar
Comments	122	varchar
PreAlertCall	123	varchar
PickUpPostCode	124	varchar	Ignored For No Enum
CardiacNurseInAttendance	125	varchar
Cox_2InhibitorUse	126	varchar
NsaidUse	127	varchar
NitrateUse	128	varchar
CalciumChannelBlockerUse	129	varchar
Spironolactone	130	varchar
Eplerenone	131	varchar
Nitrates	132	varchar
Warfarin	133	varchar
Other	134	varchar
TimeLeftScene	135	varchar	Ignored For No Enum
HospitalCentreCode	136	varchar
TotalTimeOnScene	137	float
DateAndTimeOfFirstDiagnosticEcg	138	varchar	Ignored For No Enum
CardiologicalCareDuringAdmissionCcad	139	varchar
CreatinineCcad	140	float
HaemoglobinCcad	141	float
SiteOfInfarctionCcad	142	varchar
FondaparinuxCcad	143	varchar
InitialReperfusionTreatmentCcad	144	varchar
InPatientManagementOfHyperglycaemia_diabetesCcad	145	varchar
DateOfReturnToReferringHospital	146	datetime	Ignored For Datatype
DelayForCallToFrv	147	float
DelayFrvToFullCrew	148	float
DelayCallToDepart	149	float
PatientEthnicGroup	150	varchar
IncludeInD2n	151	varchar
Comments2	152	varchar	Ignored For No Enum
CathLabArrivalTime	153	varchar
BallonTime	154	varchar
DelayCcuToLab	155	float
DelayCallToBalloon	156	float
DelayDoorToBalloon	157	float
DelayLabToBalloon	158	float
IncludeC2n	159	varchar
InterventionalCentreCodeCcad	160	varchar
ReferringHospitalCodeCcad	161	varchar
Mustafa1	162	int
Mustafa2	163	int
DaysFromAdmissionToDeath	164	int
DateOfCurrentStatus	165	datetime	Ignored For Datatype
DateOfEndStatus	166	datetime	Ignored For Datatype
DateTimeRecordCreated	167	datetime	Ignored For Datatype
DateTimeRecordLastChanged	168	datetime	Ignored For Datatype
EnteredByTag	169	varchar
EntryCurrentStatus	170	varchar
EntryEndStatus	171	varchar
HospitalTag	172	varchar

LRIMINAPNEW_LRIMINAPNEWINITIALVW

Start Date Field: DateofAdmissiontoCCU

Field Name	Column ID	Type	Comments
EntryId	1	int	Ignored For Field Name
PatientId	2	int	Ignored For Field Name
!DateofAdmissiontoCCU	3	date	Ignored For Datatype
!TimeofAdmissiontoCCU	4	time	Ignored For Datatype
EntryStatus	5	varchar
PreviousEntry	6	int	Ignored For Field Name
NextEntry	7	int	Ignored For Field Name
OnsetOfSymptomsCcad	8	varchar	Ignored For No Enum
MethodOfAdmissionCcad	9	varchar
CallForHelpCcad	10	varchar	Ignored For No Enum
ArrivalOfEmergencyServiceCcad	11	varchar	Ignored For No Enum
ArrivalAtHospitalCcad	12	varchar	Ignored For No Enum
DateAndTimeOfReperfusionTreatmentCcad	13	varchar	Ignored For No Enum
FirstCardiacArrestCcad	14	varchar	Ignored For No Enum
CardiacArrestLocationCcad	15	varchar
ArrestPresentingRhythmCcad	16	varchar
OutcomeOfArrestCcad	17	varchar
InitialDiagnosisCcad	18	varchar
EcgDeterminingTreatmentCcad	19	varchar
AdditionalReperfusionTreatmentCcad	20	varchar
WhereWasInitialReperfusionTreatmentGiven_Ccad	21	varchar
WhoTookTheInitialDecisionToAttemptReperfusion_Ccad	22	varchar
ReasonReperfusionTreatmentNotGivenCcad	23	varchar
Age	24	int
WhereWasAspirin_otherAntiplateletGivenCcad	25	varchar
AdmissionWardCcad	26	varchar
AdmittingConsultantCcad	27	varchar
DischargeDiagnosisCcad	28	varchar
DeathInHospitalCcad	29	varchar
DateOfDischargeOrDeathCcad	30	date	Ignored For Datatype
DischargedOnBetaBlockerCcad	31	varchar
AceInhibitorCcad	32	varchar
DischargedOnStatinCcad	33	varchar
DischargedOnAspirinOrOtherPlateletDrugCcad	34	varchar
CardiacRehabilitationCcad	35	varchar
ExerciseTestPerformedCcad	36	varchar
EchocardiographyCcad	37	varchar
RadionuclideStudyCcad	38	varchar
CoronaryAngiographyCcad	39	varchar
CoronaryInterventionCcad	40	varchar
GenderCcad	41	varchar
DelayBeforeTreatmentCcad	42	varchar
DaysInHospital	43	int
DelayFromOnsetOfSymptomsToCallForHelp	44	float
DelayFromCallForHelpToArrivalOfEmergencyServices	45	float
DelayFromCallForHelpToArrivalInHospital	46	float
DelayFromArrivalInHospitalToReperfusionTreatment	47	float
DelayFromCallForHelpToReperfusionTreatment	48	float
DelayFromOnsetOfSymptomsToReperfusionTreatment	49	float
AmbulanceJobNumberCcad	50	varchar	Ignored For No Enum
PeakCreatinineKinase_ck_Ccad	51	float
PeakTroponinCcad	52	float
TroponinAssayCcad	53	varchar
TroponinReferenceValue	54	varchar
PatientAdminStatusCcad	55	varchar
PreviousAmiCcad	56	varchar
PreviousAnginaCcad	57	varchar
HypertensionCcad	58	varchar
HypercholesterolaemiaCcad	59	varchar
PeripheralVascularDiseaseCcad	60	varchar
CerebrovascularDiseaseCcad	61	varchar
AsthmaOrCopdCcad	62	varchar
ChronicRenalFailureCcad	63	varchar
HeartFailureCcad	64	varchar
CardiacEnzymes_markersRaisedCcad	65	varchar
SerumCholesterolCcad	66	float
SmokingStatusCcad	67	varchar
DiabetesCcad	68	varchar
PreviousPciCcad	69	varchar
PreviousCabgCcad	70	varchar
SystolicBpCcad	71	int
HeartRateCcad	72	int
ArrivalOfFirstProfessionalHelpCcad	73	varchar	Ignored For No Enum
UnfractionatedHeparinCcad	74	varchar
LowMolecularWeightHeparinCcad	75	varchar
ThienopyridinePlateletInhibitorCcad	76	varchar
OtherOralAntiplateletAgentCcad	77	varchar
Iv2b_3aAgentCcad	78	varchar
IvBetaBlockerCcad	79	varchar
CalciumChannelBlockerCcad	80	varchar
IvNitrateCcad	81	varchar
OralNitratesCcad	82	varchar
PotassiumChannelModulatorCcad	83	varchar
WarfarinCcad	84	varchar
AngiotensinIiBlocker_arb_Ccad	85	varchar
ThiazideDiureticCcad	86	varchar
LoopDiureticCcad	87	varchar
SpironolactoneCcad	88	varchar
ThrombolyticDrugCcad	89	varchar
BleedingComplicationsCcad	90	varchar
DischargeDestinationCcad	91	varchar
DateOfReferralForInvestigation_intervention	92	date	Ignored For Datatype
DaycaseTransferDateCcad	93	date	Ignored For Datatype
LocalAngioDateCcad	94	date	Ignored For Datatype
LocalInterventionDateCcad	95	date	Ignored For Datatype
OtherAdmissionDiagnosis	96	varchar
OtherDischargeDiagnosis	97	varchar
DischargedFromCcuDestination	98	varchar
Gp_pctCodeCcad	99	varchar	Ignored For No Enum
DelayFromReferralForInvestigation_interventionToTr	100	float
PctCode	101	varchar
MedicalRecordNumberAtTimeOfEntryCcad	102	varchar	Ignored For No Enum
SerumGlucoseCcad	103	float
DiabeticTherapyAtDischargeCcad	104	varchar
AuditTrail	105	text	Ignored For Datatype
PlaceFirst12LeadEcgPerformedCcad	106	varchar
BetaBlockerUseCcad	107	varchar
Ace1OrArbUseCcad	108	varchar
StatinUseCcad	109	varchar
ClopidogrelUseCcad	110	varchar
HeightCcad	111	float
WeightCcad	112	float
LeftVentricularEjectionFractionCcad	113	varchar
FamilyHistoryOfChdCcad	114	varchar
FollowedUpByCcad	115	varchar
ReinfarctionCcad	116	varchar
DischargedOnClopidogrelCcad	117	varchar
PatientCaseRecordNumberAtReferringHospitalCcad	118	varchar	Ignored For No Enum
AmbulanceDriver	119	varchar
AmbulanceAttendant	120	varchar
AmbulanceResponder	121	varchar
Comments	122	text	Ignored For Datatype
PreAlertCall	123	varchar
PickUpPostCode	124	varchar	Ignored For No Enum
CardiacNurseInAttendance	125	varchar
Cox_2InhibitorUse	126	varchar
NsaidUse	127	varchar
NitrateUse	128	varchar
CalciumChannelBlockerUse	129	varchar
Spironolactone	130	varchar
Eplerenone	131	varchar
Nitrates	132	varchar
Warfarin	133	varchar
Other	134	varchar
TimeLeftScene	135	varchar	Ignored For No Enum
HospitalCentreCode	136	varchar
TotalTimeOnScene	137	float
DateAndTimeOfFirstDiagnosticEcg	138	varchar	Ignored For No Enum
CardiologicalCareDuringAdmissionCcad	139	varchar
CreatinineCcad	140	float
HaemoglobinCcad	141	float
SiteOfInfarctionCcad	142	varchar
FondaparinuxCcad	143	varchar
InitialReperfusionTreatmentCcad	144	varchar
InPatientManagementOfHyperglycaemia_diabetesCcad	145	varchar
DateOfReturnToReferringHospital	146	date	Ignored For Datatype
DelayForCallToFrv	147	float
DelayFrvToFullCrew	148	float
DelayCallToDepart	149	float
PatientEthnicGroup	150	varchar
IncludeInD2n	151	varchar
ASComments2	152	varchar	Ignored For No Enum
CathLabArrivalTime	153	varchar
BallonTime	154	varchar
DelayCcuToLab	155	float
DelayCallToBalloon	156	float
DelayDoorToBalloon	157	float
DelayLabToBalloon	158	float
IncludeC2n	159	varchar
InterventionalCentreCodeCcad	160	varchar
ReferringHospitalCodeCcad	161	varchar
Mustafa1	162	int
Mustafa2	163	int
DaysFromAdmissionToDeath	164	int
TimeFromAdmissionToFirstEcg	165	float
HospitalRefferedFrom	166	varchar
EcgQrsComplexDurationCcad	167	varchar
AldosteroneAntagonistCcad	168	varchar
DischargedOnTheinopyridineInhibitorCcad	169	varchar
DischargedOnAnAldosteroneAntagonistCcad	170	varchar
WhatProcedureWasPerformedAtTheInterventionalHospit	171	varchar
SmokingCessationAdviceGivenCcad	172	varchar
DietaryAdviceGivenDuringThisAdmissionCcad	173	varchar
OralBetaBlockerCcad	174	varchar
DateAndTimeArrivalAtNonInterventionalHospitalCcad	175	varchar
AssessmentAtNonInterventionalHospitalCcad	176	varchar
AssessmentAtInterventionalCentreCcad	177	varchar
IntendedReprofusionProcedureCcad	178	varchar
ProcedurePerformedCcad	179	varchar
WhyWasNoAngiogramPerformed_Ccad	180	varchar
WhyWasNoInterventionPerformedCcad	181	varchar
PatientLocationAtTimeOfStemiOnset	182	varchar
AcsAuditSite	183	varchar
AcsAuditWard	184	varchar
AcsAuditHowManyDosesOfLmwh	185	int
AcsAuditCardiologicalOpinionRequestedDuringAdmissi	186	varchar
AcsAuditAdmittesFrom	187	varchar
AcsAuditTimiScore	188	varchar
AcsAuditRiskStratification	189	varchar
AcsAuditDateAndTimeOfEtt	190	varchar
AcsAuditDateAndTimeOfEcho	191	varchar
AcsAuditDateAndTimeOfAngiography	192	varchar
AcsAuditDateAndTimeOfPci_Cabg	193	varchar
AcsAuditDischargedOnSublingualGtn	194	varchar
AcsAuditComments	195	varchar
DateOfCurrentStatus	196	date	Ignored For Datatype
DateOfEndStatus	197	date	Ignored For Datatype
DateTimeRecordCreated	198	varchar	Ignored For No Enum
DateTimeRecordLastChanged	199	varchar	Ignored For No Enum
EnteredByTag	200	varchar
EntryCurrentStatus	201	varchar
EntryEndStatus	202	varchar
HospitalTag	203	varchar
ImportLinkId	204	int

VERTED_VERTEDINIALVW

Start Date Field: DateOfCardioversion

Field Name	Column ID	Type	Comments
EntryId	1	int	Ignored For Field Name
PatientId	2	int	Ignored For Field Name
DateOfCardioversion	3	date	Ignored For Datatype
TimeOfCardioversion	4	time	Ignored For Datatype
EntryStatus	5	varchar
PreviousEntry	6	int	Ignored For Field Name
NextEntry	7	int	Ignored For Field Name
DateOnWaitingList	8	date	Ignored For Datatype
AgeAtCardioversion	9	int
BloodPressure	10	varchar	Ignored For No Enum
Height	11	varchar	Ignored For No Enum
Rhythm	12	varchar
DrugsOnAdmission	13	varchar	Ignored For No Enum
DateOfEcho	14	date	Ignored For Datatype
Pacemaker	15	varchar
Weight	16	float
Inr	17	float
JoulesDelivered_1	18	int
Rhythm_1	19	varchar	Ignored For No Enum
JoulesDelivered_2	20	int
Rhythm_2	21	varchar	Ignored For No Enum
JoulesDelivered_3	22	int
Rhythm_3	23	varchar
JoulesDelivered_4	24	int
Rhythm_4	25	varchar
JoulesDelivered_5	26	int
Rhythm_5	27	varchar
JoulesDelivered_6	28	int
Rhythm_6	29	varchar
InternalCardioversion	30	varchar
ExternalCardioversion	31	varchar
OutcomeSucces	32	varchar
Death	33	varchar
CardioversionCancelled	34	varchar
Reason	35	varchar	Ignored For No Enum
DateOfDischarge	36	date	Ignored For Datatype
DateOfAdmission	37	date	Ignored For Datatype
RhythmAfterCardioversion	38	varchar
AdmissionType	39	varchar
DateOfFollowUp	40	date	Ignored For Datatype
Ap_2	41	varchar
Ap_3	42	varchar
Ap_4	43	varchar
Ap_5	44	varchar
Ap_6	45	varchar
Consultant	46	varchar
ContractDetails	47	varchar
Pcg	48	varchar
MedicationOnDischarge1	49	varchar	Ignored For No Enum
MedicationOnDischarge2	50	varchar	Ignored For No Enum
MedicationOnDischarge3	51	varchar	Ignored For No Enum
MedicationOnDischarge4	52	varchar	Ignored For No Enum
MedicationOnDischarge5	53	varchar	Ignored For No Enum
MedicationOnDischarge6	54	varchar	Ignored For No Enum
MedicationOnDischarge7	55	varchar	Ignored For No Enum
MedicationOnDischarge8	56	varchar	Ignored For No Enum
MedicationOnDischarge9	57	varchar	Ignored For No Enum
AuditLoopClosed	58	varchar
DateAuditLoopClosed	59	date	Ignored For Datatype
ReasonAuditLoopClosed	60	varchar
DateOfDeathPostDischarge	61	date	Ignored For Datatype
PostDischargeDeathInterval_days	62	int
ReasonForCancellation	63	varchar
IntervalBetweenProc_LoopClosed_days	64	int
PreOpStay_days	65	int
PostOpStay_days	66	int
TotalLos_days	67	int
ReferralToOp_days	68	int
DischargeToFollow_Up_days	69	int
EchoPerformed	70	varchar
ImmeadiateReinitiationOfAf_iraf	71	varchar
PacemakerMode	72	varchar
EcgResultAt1Week	73	varchar
EcgResultAt1Month	74	varchar
ReCardiovert	75	varchar
ReasonWhyYesOrNo	76	varchar
Anaesthetic_sedation	77	varchar
IfSedationDose	78	varchar	Ignored For No Enum
Reversal	79	varchar
ComplicationsPreDischarge	80	varchar
DoseOfFlumazenil	81	varchar
TypeOfDefibUsed	82	varchar
DoesPatientRememberShocks	83	varchar
WasProcedureUnpleasant	84	varchar
AnyOtherComments	85	varchar	Ignored For No Enum
BurnMarks	86	varchar
HeartRate_priorToDischarge	87	varchar	Ignored For No Enum
Anaesthetist	88	varchar
MedicalAssistant	89	varchar
UnderlyingCardiacDiagnosisForAf	90	varchar	Ignored For No Enum
DrugListOnDischarge	91	varchar	Ignored For No Enum
FreeThyroxine	92	float
ThyroidStimulatingHormone	93	float
Operator	94	varchar	Ignored For No Enum
DoctorReading1WeekEcg	95	varchar
DoctorReading1MonthEcg	96	varchar
PadsOrPaddles	97	varchar
IfRevertsToAf	98	varchar
AnyUntowardsEvents	99	varchar	Ignored For No Enum
DurationOfAf	100	varchar
FollowUpAt_Hospital	101	varchar
TotalDoseOfSedation	102	varchar
TotalJulesDelivered	103	float
NumberOfPreviousCardioversion	104	varchar
GpPracticeCode	105	varchar	Ignored For No Enum
Pct	106	varchar
TotalNumberOfShocks	107	int
MedicalRecordNumber	108	varchar	Ignored For No Enum
HasPatientHadPreviousCardioversion	109	varchar
DateOfLastCardioversion	110	date	Ignored For Datatype
IsProcedureForRecuurrenceOfAfOfFailure	111	varchar
MedicationOnDischarge10	112	varchar	Ignored For No Enum
MedicationOnDischarge11	113	varchar	Ignored For No Enum
MedicationOnDischarge12	114	varchar	Ignored For No Enum
MedicationOnDischarge13	115	varchar
DateAndTimeOfCardioversion	116	varchar	Ignored For No Enum
UnderlyingCardiacDiagnosis2	117	varchar	Ignored For No Enum
UnderlyingCardiacDiagnosis3	118	varchar	Ignored For No Enum
UnderlyingCardiacDiagnosis4	119	varchar	Ignored For No Enum
UnderlyingCardiacDiagnosis5	120	varchar	Ignored For No Enum
UnderlyingCardiacDiagnosis6	121	varchar
ConsultantTitle	122	varchar
ConsultantsHospitalBase	123	varchar
SickNoteOfferedToPatient	124	varchar
IfAccepted_DurationInDays	125	int
ManagementPlan	126	varchar
DoctorSigningLetter	127	varchar
TitleOfDoctorSigning	128	varchar
DateOfCurrentStatus	129	date	Ignored For Datatype
DateOfEndStatus	130	date	Ignored For Datatype
DateTimeRecordCreated	131	varchar
DateTimeRecordLastChanged	132	varchar
EnteredByTag	133	varchar
EntryCurrentStatus	134	varchar
EntryEndStatus	135	varchar
HospitalTag	136	varchar
ImportLinkId	137	int

Merging Tables

Currently all the tables are imported separately. However, some tables can probably be merged.

Potential Merges:

• LRIMINAPNEW, GGHMINAP_GGHMINAP, GGHMINAPNEW,LRIMINAPNEW_LRIMINAPNEWINITIALVW, GGHMINAPNEW_GGHMINAPINIVW

Also, the table MINAPGGH_MINAPGGHINIVW also needs mapping to the same merged view.

The table MINAPLRI_MINAPLRIINIVW only contains 2 patients, all of whose data has been moved to the MINAPGGH_MINAPGGHINIVW table.