back

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