Angiogram Study – Data Dictionary
All variables are coded as integers or ISO dates (YYYY-MM-DD). No free text is stored.
Convention: 9 = Not applicable / Unknown across the entire dataset.
Study_ID
Auto-assigned sequential integer starting at 1. Primary key.
DOB
Date of birth. Format: YYYY-MM-DD (ISO 8601).
Note: Sex and Procedure_Date are not collected in this tool; they can be added later to the exported dataset (e.g. in Excel) matched by Study_ID.
Setting
| Code | Meaning |
|---|
| 0 | Outpatient |
| 1 | Inpatient |
Rules driven by Setting:
- If Outpatient (0): Troponin_Positive is set to
9 (N/A). NSTEMI is not available as an Indication_Type. OP_Referral_Route is asked.
- If Inpatient (1): Troponin_Positive must be 0 or 1. OP_Referral_Route / Non_Invasive_Test fields are set to
9 (N/A).
Troponin_Positive
Definition: Positive = any troponin value above the upper reference limit in the admission period before the angiogram. Thresholds: >14 ng/L (women), >35 ng/L (men).
| Code | Meaning |
|---|
| 0 | No |
| 1 | Yes |
| 9 | N/A (auto-set when Setting = 0 Outpatient) |
OP_Referral_Route (Outpatient only)
| Code | Meaning |
|---|
| 1 | Direct referral |
| 2 | After non-invasive testing |
| 9 | N/A (auto-set when Setting = 1 Inpatient) |
If After non-invasive testing (2): Non_Invasive_Test_Type and Non_Invasive_Test_Result are asked.
If Direct (1) or Inpatient: both test fields are set to 9.
Non_Invasive_Test_Type (OP + after testing)
| Code | Meaning |
|---|
| 1 | CTCA |
| 2 | DSE (Dobutamine Stress Echo) |
| 3 | Exercise Echo |
| 4 | MPS (Myocardial Perfusion Scan) |
| 5 | Cardiac MRI |
| 9 | N/A (Inpatient, or direct OP referral) |
Non_Invasive_Test_Result (OP + after testing)
| Code | Meaning |
|---|
| 1 | Positive / Abnormal |
| 2 | Negative / Normal |
| 3 | Equivocal / Inconclusive |
| 9 | N/A (Inpatient, or direct OP referral) |
Indication_Type
| Code | Meaning |
|---|
| 1 | Stable chest pain |
| 2 | NSTEMI (Inpatient, troponin positive only) |
| 3 | Unstable angina |
| 4 | LV dysfunction / cardiomyopathy |
| 5 | Pre-op / valve work-up |
| 6 | Other |
NSTEMI (2) is not available when Setting = 0 (Outpatient) or when Troponin_Positive = 0 (No). Codes run 1–6 only.
Hypertension
Definition: Positive = documented diagnosis of hypertension and/or on antihypertensive therapy prior to admission/procedure.
| Code | Meaning |
|---|
| 0 | No |
| 1 | Yes |
| 9 | Unknown |
Diabetes
Definition: Positive = documented diagnosis of diabetes and/or on glucose-lowering therapy prior to admission/procedure.
| Code | Meaning |
|---|
| 0 | No |
| 1 | Yes |
| 9 | Unknown |
Hyperlipidaemia
Definition: Positive = documented diagnosis of hyperlipidaemia/dyslipidaemia and/or on lipid-lowering therapy (e.g. statin, ezetimibe, PCSK9 inhibitor) prior to admission/procedure. If neither is documented, a common fallback is total cholesterol ≥200 mg/dL (≈5.18 mmol/L) or LDL-C ≥130 mg/dL (≈3.37 mmol/L).
| Code | Meaning |
|---|
| 0 | No |
| 1 | Yes |
| 9 | Unknown |
Smoking_Status
| Code | Meaning |
|---|
| 0 | Never |
| 1 | Ex-smoker |
| 2 | Current |
| 9 | Unknown |
Family_Hx_Premature_CAD
Definition: Positive = first-degree relative (parent, sibling, or child) with MI, angina, sudden cardiac death and/or coronary revascularisation (PCI or CABG) occurring before 55 years in male relatives or 65 years in female relatives.
| Code | Meaning |
|---|
| 0 | No |
| 1 | Yes |
| 9 | Unknown |
Hx_CAD
Prior history of coronary artery disease (MI, PCI, or CABG).
| Code | Meaning |
|---|
| 0 | No |
| 1 | Yes |
| 9 | Unknown |
Angio_Outcome
| Code | Meaning |
|---|
| 0 | Normal (<50%) |
| 1 | Non-obstructive (50–69%) |
| 2 | Obstructive (≥70% or LM ≥50%) |
Management_Strategy
| Code | Meaning |
|---|
| 1 | Medical therapy only |
| 2 | PCI referral |
| 3 | CABG referral |
| 4 | Further investigation required |
| 5 | Diagnostic only / no change |
If PCI referral (2): PCI_Outcome is asked.
Otherwise PCI_Outcome is set to 9 (N/A).
PCI_Outcome (PCI referral only)
| Code | Meaning |
|---|
| 1 | Stented |
| 2 | Not stented (PCI done, no stent placed) |
| 3 | Not done |
| 9 | N/A (Management_Strategy ≠ 2) |
created_by_user
Username of the collector who created the case. Used for Study_ID range assignment and audit. Not exported in CSV.
Coding Convention Summary
| Code | Meaning | Used In |
|---|
| 9 | Not applicable / Unknown | All conditional & yes/no/unknown fields |
| 0 | No (or Outpatient, or Normal) | Binary fields, Setting, Angio_Outcome |
| 1 | Yes (or first option) | All coded fields |
| 2+ | Additional categories | See individual field tables above |
No cell in the dataset is ever empty. Every field always contains a coded integer or an ISO date.
Conditional Logic Summary
| Condition | Fields affected | Action |
|---|
| Setting = 0 (OP) | Troponin_Positive | Auto-set to 9 |
| Setting = 0 (OP) | Indication_Type | NSTEMI (2) hidden |
| Troponin_Positive = 0 (No) | Indication_Type | NSTEMI (2) hidden |
| Setting = 1 (IP) | OP_Referral_Route, Non_Invasive_Test_Type, Non_Invasive_Test_Result | Auto-set to 9 |
| OP_Referral_Route = 1 (Direct) | Non_Invasive_Test_Type, Non_Invasive_Test_Result | Auto-set to 9 |
| Management_Strategy ≠ 2 | PCI_Outcome | Auto-set to 9 |