Spreadsheet: ccb0d83d-b2bf-4184-afe7-0fe198ed398f
Sheet: Sheet1

PACEMAKER / ICD NATIONAL DATASET | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6
 | Version: | 2.21 | Fields:
 | Spreadsheet created on: | 2011-12-05 00:00:00 | 72
Sequence | Field Description | Short Code | Long Code | Field Type | Encryption | Optional Help
1.01 | Hospital identifier | ACH | ACH. [NAME] ... ZZZ. St Elsewhere's | Text (single value) | N | The identifier allocated to the hospital by CCAD. Used for the identification and analysis of the individual centre data. Valid Hospital Identifiers are listed in a separate file. The software should set this field without any user involvement.
1.02 | Patient Case Record Number |  | Free text | Text (single value) | N | The permanent number for identifying the patient across all departments within the hospital. The CCAD Hospital identifier and this field are used to link records from the same hospital for the same patient. Separate episodes for the same patient will not be linked correctly unless the permanent identifier for the patient is used.
1.03 | NHS Number |  | 10 digit (no spaces) valid NHS Number | Text (single value) | Y | Unique national identifier for patient. If the NHS Number is not included in the record, CCAD will attempt to obtain it from the National Strategic Tracing Service (NSTS) using the patient's name, date of birth and postcode. CCAD uses the NHS number for (1) regular enquiries on the patient's status, and in particular, to obtain the patient's date of death and (2) to link records for the same patient from different hospitals.
1.04 | Patient Surname |  | Free text | Text (single value) | Y
1.05 | Patient Forename |  | Free text | Text (single value) | Y
1.06 | Patient Date of Birth |  | Valid date >1880 and <=Today | Date (dd/mm/yyyy) | Y
1.07 | Patient Gender |  | 0. Not known 1. Male 2. Female 9. Not specified | Text (single value) | N
1.08 | Patient Ethnic Group |  | 1. Caucasian 2. Black 3. Asian 4. Oriental 8. Other 9. Unknown | Text (single value) | N
1.09 | Patient Admin status |  | 1. NHS 2. Private 3. Amenity 5. Visitor 9. Unknown | Text (single value) | N
1.1 | Patient Post Code |  | Valid Post Code | Text (single value) | Y | The NHS standard requires the use of the full post code
2.01 | Date of 1st Implant |  | Valid date >1957 and <Today | Date (dd/mm/yyyy) | N
2.02 | PreDevice Aetiology |  | A1. Unspecified B1. Unknown B2. Conduction Tissue Fibrosis B3. Apparently [NAME] C1. Ischaemic C1A. Transient Ischaemia C2. Post Infarction C3. Post MI - 1 vessel CAD C4. Post MI - 2 vessel CAD C5. Post MI - 3 vessel CAD C6. Post MI C7. Post multiple MI - 1 vessel CAD C8. Post multiple MI - 2 vessel CAD C9. Post multiple MI - 3 vessel CAD C10. Post multiple MI - coronary anatomy unknown C11. No MI - 1 vessel CAD C12. No MI - 2 vessel CAD C13. No MI - 3 vessel CAD C14. Ischaemic D1. Congenital Unspecified D1A. Congenital Conduction Defect Only D1B. Congenital Structural And Conduction Defect E1. Surgical Complication E2. Surgical Therapeutic (Ablation) E3. Catheter Ablation - unspecified E3A. Catheter Ablation - complication E3B. Catheter Ablation - therapeutic E4. Drug Induced F1. Carotid Sinus Syndrome F2. Vasovagal Syndrome F3. Orthostatic Hypotension G1. Cardiomyopathy - unspecified [NAME] [NAME] - dilated [NAME] dysplasia G2. Myocarditis G3. Valvular heart disease G6. Endocarditis G7. Heart Transplant G8. Ionising Radiation H1. Idiopathic H2. Long QT syndrome H3. Other H4. Hypertensive heart disease H5. Brugada syndrome | Text (multivalue ; separated) | N
2.03 | PreDevice/EPS/Ablation Symptom |  | A1. Unspecified A2. Unknown A3. Other B1. Syncope B2. [NAME]. Bradycardia B4. Cardiac Arrest C1. Tachycardia C1B. Palpitations D1. None/Prophylactic D2. Heart Failure/Dyspnoea D3. Cerebral Dysfunction D4. Chest Pain D5. Aborted [NAME] | Text (multivalue ; separated) | N
2.04 | PreDevice ECG |  | A1. Unspecified A2. Unknown A3. No arrhythmia documented B1. Normal Sinus Rhythm B2. Normal Sinus Rhythm + Abnormal EPS C1. 1' Heart Block C2. 2' Heart Block - Unspecified C3. 2' Heart Block - Wenkebach C4. 2' Heart Block - Mobitz C5. CHB - QRS Unspecified C6. CHB - Narrow QRS C7. CHB - Wide QRS C8. Chronic Atrial Fibrillation + Complete AV Block D1. BBB - Unspecified D2. RBBB - Incomplete D3. RBBB - Complete D4. LBBB - Complete D5. LAHB D6. LPHB D7. RBBB + LAHB + Normal PR D8. RBBB + [NAME]. RBBB + LAHB + Long PR D10. RBBB + [NAME]. LBBB + Long PR D12. LBBB/RBBB Alternans E1. SSS - Unspecified E2. SSS - SA Exit Block E3. SSS - SA Arrest E4. SSS - Bradycardia E5. SSS - Brady-Tachy E6. Chronic A Flutter/Fib + Bradycardia E7. Interatrial Block E8. Chronotropic Incompetence F1. Atrial Tachycardia Unspecified F2. AV Reentrant Tachycardia F3. AV Nodal Tachycardia G1. [NAME]. Non-Sustained VT/VF G3. Sustained VT/VF G4. [NAME]. Other | Text (multivalue ; separated) | N
2.05 | NYHA Dyspnoea Status (Pre-procedure; Stable only) |  | 1. No limitation of physical activity 2. Slight limitation of ordinary physical activity 3. Marked limitation of ordinary physical activity 4. Symptoms at rest or minimal activity 9. Unknown | Text (single value) | N | Patients with cardiac disease but without limitation of physical activity.  Ordinary physical activity does not cause undue fatigue, palpitation or dyspnoea.  Asymptomatic patients should be classified as Class 1.
2.06 | LV Function assessment |  | 1. Good (LVEF > 50%) 2. Moderate (LVEF 35-50%) 3. Poor (LVEF < 35%) 9. Unknown | Text (single value) | N
2.07 | ICD Indication |  | 1. Primary prevention 2. Secondary prevention 8. Other indication 9. Unknown | Text (single value) | N
2.08 | PreDevice/Ablation QRS duration |  | ms | Numeric (integer) | N
3.01 | Procedure Date |  | Valid DateTime | DateTime (dd/mm/yyyy hh:[NAME]) | N
3.02 | Intervention |  | ALD. Atrial Lead Replacement APOS. Atrial Lead Repair/Reposition AREM. Atrial Lead Removal BiV. Upgrade to biventricular DREM. Dual Lead Removal DREP. Dual Lead Repair/Reposition GEXP. [NAME]. Generator Replacement GNXLD. Upgrade From Single To Dual Chamber GN+LD. [NAME]. Upgrade to ICD LD. Lead Replacement LOOP. [NAME]. Generator Reposition SEXP. System Explant VLD. [NAME] VPOS. Ventricular Lead Repair/Reposition VREM. [NAME] WREV. Wound Revision | Text (single value) | N
3.03 | Operation report/comment |  | Free text or attached files | Text (single value) | N
3.04 | Consultant Responsible for Procedure |  | Local Consultant responsible (eg L.Smith) | Text (single value) | Y
3.05 | First operator |  | Primary operator [preferred format - Initial.Surname (eg A.Smith)] | Text (single value) | Y
3.06 | Generator pacing mode at discharge |  | AAI AAIR AAIR<=>DDDR AAIR>DDDR AAIsafeR AAI<=>DDD DDD DDDR DDI DDIR DDR DVI OOO VAT VDD VDDR VOO VVI VVIR | Text (single value) | N
3.07 | Generator manufacturer |  | APC. APC Medical  BSI. Boston Scientific BTC. Biotec BTK. Biotronik COR. Cordis CPI. Guidant CRT. Coratomic ELA. ELA IMP. Implantronik INT. Intermedics LEM. LEM MCR. Medcor MDI. Medico Italia MED. Medtronic PAL. Paladin PAS. Pacesetter [NAME] PRE. Precimed SOR. Sorin OSP. Osypka TEL. Telectronics VIT. [NAME] | Text (single value) | N | Code for generator manufacturer. Note: does not cover all historical manufacturers - those with < 100 implants have been excluded. For a full list please contact the Pacemaker Database office.
3.08 | Generator model |  | Valid model designation from relevant manufacturer | Text (single value) | N
3.09 | Generator serial number |  | Free Text | Text (single value) | N
3.10 | Generator site of implantation |  | ABDSC. Abdominal - Subcutaneous ABDSM. [NAME] AXIL. Axillary EXT. External PECSC. Pectoral - Subcutaneous PECSCR. Pectoral - Subcutaneous right side PECSCL. Pectoral - Subcutaneous left side PECSM. Pectoral - Submuscular REC. Sub-rectus RECL. Sub-rectus left side RECR. Sub-rectus right side SUPR. Supra-rectus OTH. Other THOR. Intra-thoracic ?. Unspecified | Text (single value) | N
3.11 | Date Generator changed |  | Explant date for the generator implanted during this procedure (if any) | Date (dd/mm/yyyy) | N
3.12 | Why this generator eventually explanted |  | A1. Unspecified A2. Unknown B1. Elective B2. Recall B3. System Change - Elective B4. System Change - Pacer Syndrome B4A. System Change - Upgrade to DDD B4B. System Change - Upgrade to BiV B5. System Change - Palpitations B6. System Change - Electrode Problem B7. [NAME]. [NAME]. Mechanical Protrusion C2. Erosion C3. Infection C4. [NAME]. Other surgical D1. Minor Failure - Unspecified D2. Minor Failure - Undersensing D3. Minor Failure - Oversensing D4. Minor Failure - Magnetic Switch D5. Minor Failure - Programming E1. Major Failure - Unspecified E2. Major Failure - No Output E3. Major Failure - Low Output E4. Major [NAME]. Major Failure - Fast Rate E6. Major Failure - Connector E7. Major Failure - Encapsulation E8. Unneccessary shocks E9. Other Failure F1. Battery Failure - Normal Eol F2. Battery Failure - Premature Eol F3. Battery Failure - Other G1. Other | Text (single value) | N
3.13 | Ventricular lead manufacturer |  | APC. APC Medical BSI. Boston Scientific BTC. Biotec BTK. Biotronik COR. Cordis CPI. Guidant CRT. Coratomic ELA. ELA IMP. Implantronik INT. Intermedics LEM. LEM MCR. Medcor MDI. Medico Italia MED. Medtronic OSP. Osypka PAL. Paladin PAS. Pacesetter [NAME] PRE. Precimed SOR. Sorin TEL. Telectronics VIT. [NAME] | Text (single value) | N
3.14 | Ventricular lead model |  | Valid model designation from relevant manufacturer | Text (single value) | N
3.15 | Ventricular lead serial number |  | Free Text | Text (single value) | N
3.16 | Ventricular lead implant approach |  | CEPRV. Cephalic - RV ENDCV. Endocardial To Coronary Vein ENDO. Endocardial unsepcified ENDRV. Endocardial To RV EXTRV. External Jugular To RV FEMRV. Femoral To Right Ventricle INTRV. Internal Jugular To RV SRTRV. Sternotomy To RV SUBRV. Subclavian To RV SUBXY. Subxyphoid SUCRV. Subcostal To RV THRRV. Thoracotomy To RV AXILRV. Axillary vein to RV ?. Unspecified | Text (single value) | N
3.17 | Date [NAME] lead changed |  | If this intervention involves a new V lead refers to date when new lead eventually explanted | Date (dd/mm/yyyy) | N
3.18 | Why this V lead eventually replaced/explanted |  | A1. Unspecified A2. Unknown B1. Elective B2. Displacement B3. [NAME]. [NAME]. [NAME]. Perforation B7. Undersensing B8. Recall B9. Patch crumpling B10. Other elective C1. Infection - Ulceration C2. Erosion C3. Other surgical D1. Connector Failure D2. Insulation Break D3. [NAME]D3A. Conductor Break - Shock D3B. Conductor Break - Pace/Sense D4. Other failure | Text (single value) | N
3.19 | Atrial lead manufacturer |  | APC. APC Medical BSI. Boston Scientifc BTC. Biotec BTK. Biotronik COR. Cordis CPI. Guidant CRT. Coratomic ELA. ELA IMP. Implantronik INT. Intermedics LEM. LEM MCR. Medcor MDI. Medico Italia MED. Medtronic OSP. Osypka PAL. Paladin PAS. Pacesetter [NAME] PRE. Precimed SOR. Sorin TEL. Telectronics VIT. [NAME] | Text (single value) | N
3.2 | Atrial lead model |  | Valid model designation from relevant manufacturer | Text (single value) | N
3.21 | Atrial lead serial number |  | Free Text | Text (single value) | N
3.22 | Atrial lead implant approach |  | CEPRA. [NAME] ENDCS. Endocardial To Coronary Sinus ENDO. Endocardial unspecified ENDRA. Endocardial To RA EPI. [NAME]EPILA. Epicardial To LA EPIRA. Epicardial To RA FEMRA. Femoral To Right Atrium SUBRA. [NAME] AXILRA. Axillary vein to right atrium AXILCS. Axillary vein to coronary sinus ?. Unspecified | Text (single value) | N
3.23 | Date Atrial lead changed |  | If this intervention involves a new A lead refers to date when new lead eventually explanted | Date (dd/mm/yyyy) | N
3.24 | Why this A lead eventually replaced/explanted |  | A1. Unspecified A2. Unknown B1. Elective B2. Displacement B3. [NAME]. [NAME]. [NAME]. Perforation B7. Undersensing B8. Recall B9. Patch crumpling B10. Other elective C1. Infection - Ulceration C2. Erosion C3. Other surgical D1. Connector Failure D2. Insulation Break D3. [NAME]D3A. Conductor Break - Shock D3B. Conductor Break - Pace/Sense D4. Other failure | Text (single value) | N
3.25 | Ventricular lead2 manufacturer |  | APC. APC Medical BSI . Boston Scientific BTC. Biotec BTK. Biotronik COR. Cordis CPI. Guidant CRT. Coratomic ELA. ELA IMP. Implantronik INT. Intermedics LEM. LEM MCR. Medcor MDI. Medico Italia MED. Medtronic PAL. Paladin PAS. Pacesetter [NAME] PRE. Precimed OSP. Osypka SOR. Sorin TEL. Telectronics VIT. [NAME] | Text (single value) | N
3.26 | Ventricular lead2 model |  | Valid model designation from relevant manufacturer | Text (single value) | N
3.27 | Ventricular lead2 serial number |  | Free Text | Text (single value) | N
3.28 | Ventricular lead2 implant approach |  | CEPRV. Cephalic - RV ENDCV. Endocardial To Coronary Vein ENDO. Endocardial unsepcified ENDRV. Endocardial To RV EXTRV. External Jugular To RV FEMRV. Femoral To Right Ventricle INTRV. Internal Jugular To RV SRTRV. Sternotomy To RV SUBRV. Subclavian To RV SUBXY. Subxyphoid SUCRV. Subcostal To RV THRRV. Thoracotomy To RV AXILRV. Axillary vein to RV ?. Unspecified | Text (single value) | N
3.29 | Date [NAME] lead2 changed |  | If this intervention involves a new V lead refers to date when new lead eventually explanted | Date (dd/mm/yyyy) | N
3.30 | Why this V lead2 eventually replaced/explanted |  | A1. Unspecified A2. Unknown B1. Elective B2. Displacement B3. [NAME]. [NAME]. [NAME]. Perforation B7. Undersensing B8. Recall B9. Patch crumpling B10. Other elective C1. Infection - Ulceration C2. Erosion C3. Other surgical D1. Connector Failure D2. Insulation Break D3. [NAME]D3A. Conductor Break - Shock D3B. Conductor Break - Pace/Sense D4. Other failure | Text (single value) | N
3.31 | Atrial lead2 manufacturer |  | APC. APC Medical BSI. Boston Scientific BTC. Biotec BTK. Biotronik COR. Cordis CPI. Guidant CRT. Coratomic ELA. ELA IMP. Implantronik INT. Intermedics LEM. LEM MCR. Medcor MDI. Medico Italia MED. Medtronic OSP. Osypka PAL. Paladin PAS. Pacesetter [NAME] PRE. Precimed SOR. Sorin TEL. Telectronics VIT. [NAME] | Text (single value) | N
3.32 | Atrial lead2 model |  | Valid model designation from relevant manufacturer | Text (single value) | N
3.33 | Atrial lead2 serial number |  | Free Text | Text (single value) | N
3.34 | Atrial lead2 implant approach |  | CEPRA. [NAME] ENDCS. Endocardial To Coronary Sinus ENDO. Endocardial unspecified ENDRA. Endocardial To RA EPI. [NAME]EPILA. Epicardial To LA EPIRA. Epicardial To RA FEMRA. Femoral To Right Atrium SUBRA. [NAME] AXILRA. Axillary vein to right atrium AXILCS. Axillary vein to coronary sinus ?. Unspecified | Text (single value) | N
3.35 | Date Atrial lead2 changed |  | If this intervention involves a new A lead refers to date when new lead eventually explanted | Date (dd/mm/yyyy) | N
3.36 | Why this A lead2 eventually replaced/explanted |  | A1. Unspecified A2. Unknown B1. Elective B2. Displacement B3. [NAME]. [NAME]. [NAME]. Perforation B7. Undersensing B8. Recall B9. Patch crumpling B10. Other elective C1. Infection - Ulceration C2. Erosion C3. Other surgical D1. Connector Failure D2. Insulation Break D3. [NAME]D3A. Conductor Break - Shock D3B. Conductor Break - Pace/Sense D4. Other failure | Text (single value) | N
3.37 | ICD function |  | 0. No 1. Yes | Text (single value) | N
3.38 | BiV function |  | 0. No 1. Yes | Text (single value) | N
3.39 | Defibrillator Lead site |  | A1. None A2. Unknown C1. [NAME] C2. [NAME] [NAME]. Other patch - epicardial C4. Patch - subcutaneous C5. Array - subcutaneous C6. RA/SVC coil - endocardial C7. Coronary sinus coil - endocardial C8. RV coil - endocardial C9. RV coil + RA/SVC coil - endocardial C10. Other defib [+/- Pace/Sense] lead | Text (single value) | N
4.01 | Pacing Procedure Complications |  | 0. None 1. Pneumothorax 2. Pneumothorax requiring aspiration 3. Chest drain inserted 4. Haematoma 5. Haematoma exploration 7. Lead displacement requiring reposition 7A. Lead displacement (right atrium) requiring reposition 7R. Lead displacement (right ventricle) requiring reposition 7L. Lead displacement (left ventricle) requiring reposition 8. Pericardial effusion 8A. Pericardial effusion - no intervention 8B. Pericardial effusion requiring drainage 9. Infection - unspecified 9A. Infection - superficial 9B. Infection - pocket/systemic 10. Mortality 10A. Mortality - procedure related 10B. Mortality - other or unknown cause 99. Unlisted | Text (multivalue ; separated) | N | New short list of acute/semi-acute (within 3 months) complications to be added as part of the implant record.
4.02 | Bradycardia pacing on? |  | 0. No 1. Yes | Text (single value) | N
4.03 | Bradycardia pacing mode (at end of procedure) |  | AAI AAIR AAIR<=>DDDR AAIR>DDDR AAIsafeR AAI<=>DDD DDD DDDR DDI DDIR DVI OOO VAT VDD VDDR VOO VVI VVIR | Text (single value) | N
4.04 | Pacing rate (low) |  |  | Numeric (integer) | N
4.05 | Anti-tachycardia pacing on? |  | 0. No 1. Yes | Text (single value) | N
4.06 | VT shock therapy on? |  | 0. No 1. Yes | Text (single value) | N
4.07 | VF shock therapy on? |  | 0. No 1. Yes | Text (single value) | N
4.08 | BiVentricular pacing on? |  | 0. No 1. Yes | Text (single value) | N
4.09 | AV delay (sensed) |  |  | Numeric (integer) | N
4.1 | AV delay (paced) |  |  | Numeric (integer) | N
4.11 | BiVentricular delay (paced) |  |  | Numeric (integer) | N
4.12 | BiVentricular pacing which chamber paced first? |  | 0. Simultaneous 1. LV 2. RV | Text (single value) | N
4.13 | Lead extracted |  | 0. No 1. Yes | Text (single value) | N
5.01 | Date of file closure |  | Valid DateTime | Date (dd/mm/yyyy) | N
5.02 | Device File Closure |  | A1. Unspecified B1. Death Unrelated To Pacemaker B2. [NAME] B3. [NAME]. Death - Cause Unknown B5. Death - Lead Related B6. Non Cardiac Death B7. Cardiac Death Unrelated To ICD And Not Sudden B8. Death - Arrhythmic - ICD System Functioning B9. Operative Death B10. Other Death C1. Lost To Follow-Up C2. [NAME]. Pacemaker Removed C4. Cardiac Transplant C5. Other Follow-Up C6. ICD Programmed Off | Text (single value) | N