The BIRO/EUBIROD data standards are reproduced from the authoritative legacy specification. The September 2011 Master Data Dictionary v1.1 supersedes previous BIRO/EUBIROD Common Dataset and Data Dictionary versions.
Master Data Dictionary v1.1 (PDF) ↗
1. BIRO Common Dataset2. Activity Table3. Population Table4. Diabetic Population Table5. Site Header Dataset6. Site Profile Dataset7. Geographical References8. BIRO Indicators
1. The BIRO Common Dataset
| Ref. | BIRO Name | Description / Parameter | Data Type | Enumerated values / Units |
|---|---|---|---|---|
| BIRO001 | PAT_ID | Patient ID | String(12) | |
| BIRO002 | DS_ID | Data Source ID | String(10) | |
| BIRO003 | TYPE_DM | Type Of Diabetes | Enumerated | 1=Type 1; 2=Type 2; 3=Other |
| BIRO004 | SEX | Sex | Enumerated | 1=Male; 2=Female |
| BIRO005 | DOB | Date of Birth | Date/Time | |
| BIRO006 | DT_DIAG | Date of Diagnosis | Date/Time | |
| BIRO007 | EPI_DATE | Episode Date | Date/Time | |
| BIRO008 | SMOK_STAT | Smoking Status | Enumerated | 1=Current Smoker; 2=Non-Smoker; 3=Ex-smoker |
| BIRO009 | CIGS_DAY | Cigarettes per day | Integer | |
| BIRO010 | ALCOHOL | Alcohol Intake | Integer | g/week; g/day |
| BIRO011 | WEIGHT | Weight | Real | Kg |
| BIRO012 | HEIGHT | Height | Real | m; cm |
| BIRO013 | BMI | Body Mass Index | Real | |
| BIRO014 | SBP | Systolic Blood Pressure | Integer | mmHg |
| BIRO015 | DBP | Diastolic Blood Pressure | Integer | mmHg |
| BIRO016 | HBA1C | HbA1c | Real | % |
| BIRO017 | CREAT | Creatinine | Integer | µmol/l; mg/dl |
| BIRO018 | MA_TEST | Microalbumin | Enumerated | 1=MA Normal; 2=MA Abnormal; 0=No MA Test Recorded |
| BIRO019 | CHOL | Total Cholesterol | Integer | mmol/L; mg/dl |
| BIRO020 | HDL | HDL | Integer | mmol/L; mg/dl |
| BIRO021 | TG | Triglycerides | Integer | mmol/L; mg/dl |
| BIRO022 | EYE_EXAM | Eye Examination | Enumerated | 1=Yes; 0=No |
| BIRO023 | RETINA | Retinopathy Status | Enumerated | 1=No Retinopathy; 2=Background Retin.; 3=Referable Retin. |
| BIRO024 | MACULA | Maculopathy Status | Enumerated | 1=No Maculopathy; 2=Referable Macul. |
| BIRO025 | FOOT_EXAM | Foot Examination | Enumerated | 1=Yes; 0=No |
| BIRO026 | PULSES | Foot Pulses | Enumerated | 1=Present; 0=Absent |
| BIRO027 | FTSENS | Foot Sensation | Enumerated | 1=Normal; 0=Abn. |
| BIRO028 | ESRF | End Stage Renal Therapy | Enumerated | 1=Yes; 0=No |
| BIRO029 | DIALYSIS | Renal Dialysis | Enumerated | 1=Yes; 0=No |
| BIRO030 | TRANSPLANT | Renal Transplant | Enumerated | 1=Yes; 0=No |
| BIRO031 | STROKE | Stroke | Enumerated | 1=Yes; 0=No |
| BIRO032 | ULCER | Active Foot Ulcer | Enumerated | 1=Yes; 0=No |
| BIRO033 | MI | Myocardial Infarction | Enumerated | 1=Yes; 0=No |
| BIRO034 | LASER | Laser | Enumerated | 1=Yes; 0=No |
| BIRO035 | HYPERTENSION | Hypertension | Enumerated | 1=Yes; 0=No |
| BIRO036 | BLIND | Blindness | Enumerated | 1=Yes; 0=No |
| BIRO037 | AMPUT | Amputation | Enumerated | 1=Yes; 0=No |
| BIRO038 | HYPERT_MED | Antihypertensive Medication | Enumerated | 1=Yes; 0=No |
| BIRO039 | DRUG_THERAPY | Hypoglycemic Drug Therapy | Enumerated | 1=Insulin Only; 2=Tablet Only; 3=Insulin+Tablets; 4=None (Diet) |
| BIRO040 | ORAL_THERAPY | Oral Drug Therapy | Enumerated | 1=Sulphonilureas; 2=Biguanides; 3=Glucos. Inhib.; 4=Glitazones; 5=Glinides |
| BIRO041 | PUMP_THERAPY | Pump Therapy | Enumerated | 1=Yes; 0=No |
| BIRO042 | NASAL_THERAPY | Nasal Therapy | Enumerated | 1=Yes; 0=No |
| BIRO043 | INJECTIONS | Average Injections | Enumerated | 1=Yes; 0=No |
| BIRO044 | SELF_MON | Self Monitoring | Enumerated | 1=Urine; 2=Blood Glucose; 3=Both |
| BIRO045 | EDUCATION | Diabetes Specific Education | Enumerated | 1=Yes; 0=No |
| BIRO046 | LIPID_THERAPY | Lipid Lowering Therapy | Enumerated | 1=Yes; 0=No |
| BIRO047 | ANTIPLATELET_THERAPY | Anti-platelet Therapy | Enumerated | 1=Yes; 0=No |
| BIRO048 | DMP_ENROL | Patient Enrolment in DMP for Diabetes | Enumerated | 1=Yes; 0=No |
2. The BIRO Activity Table
| Ref. | BIRO Name | Description / Parameter | Data Type | Enumerated values / Units |
|---|---|---|---|---|
| BIRO001 | PAT_ID | Patient ID | String(12) | |
| BIRO049 | START_DATE | Start date | Date/Time | |
| BIRO050 | START_REASON | Start reason | Enumerated | 1=birth; 2=diagnosis; 3=transferred in |
| BIRO051 | END_DATE | End date | Date/Time | |
| BIRO052 | END_REASON | End reason | Enumerated | 1=death; 2=transferred out; 3=lost to follow up |
3. The BIRO Population Table
| Ref. | BIRO Name | Description / Parameter | Data Type | Enumerated values / Units |
|---|---|---|---|---|
| BIRO053 | YEAR | Year | Date/Year | |
| BIRO054 | POP_M | Total Male Population | Integer | |
| BIRO055 | POP_F | Total Female Population | Integer | |
| BIRO056 | DEATHS_M | Total Deaths in Male Population | Integer | |
| BIRO057 | DEATHS_F | Total Deaths in Female Population | Integer |
4. The BIRO Diabetic Population Table
| Ref. | BIRO Name | Description / Parameter | Data Type | Enumerated values / Units |
|---|---|---|---|---|
| BIRO053 | YEAR | Year | Date/Year | |
| BIRO058 | AGEBAND | Age band | Enumerated | 1=0–14; 2=15–24; 3=25–34; 4=35–44; 5=45–54; 6=55–64; 7=65–74; 8=75–84; 9=85+ |
| BIRO003 | TYPE_DM | Type of Diabetes | Enumerated | 1=Type 1; 2=Type 2; 3=Other |
| BIRO059 | POPD_M | Total Diabetic in Male Population | Integer | |
| BIRO060 | POPD_F | Total Diabetic in Female Population | Integer |
5. The BIRO Site Header Dataset
| Ref. | BIRO Name | Description / Parameter | Data Type | Enumerated values / Units |
|---|---|---|---|---|
| BIRO101 | DS_COUNTRY | Country of Origin | String(25) | |
| BIRO102 | DS_TYPE | Data Source Type | Enumerated | 1=GP; 2=Hospital Clinic (Int. Medicine); 3=Hospital Clinic (Diabetes); 4=Regional Shared-data Register; 5=Regional Primary Care Project; 6=Disease Management Prog.; 7=Hospital Discharge Information; 8=Insurance Programme; 9=Retinal Screening Programme; 10=Diabetes Specialist Nurse Clinic; 11=Complete National Data; 12=Sample National Data; 13=Sample Regional Data |
| BIRO103 | DS_NAME | Data Source Name | String(25) | |
| BIRO104 | DS_DENOM | Data Source Denominator | Integer | |
| BIRO105 | DS_AREA | Geographical Area | Integer | |
| BIRO106 | DS_WEBSITE | Website Address | String(50) | |
| BIRO107 | DS_ADDRESS_1 | Mailing Address Field 1 | String(25) | |
| BIRO108 | DS_ADDRESS_2 | Mailing Address Field 2 | String(25) | |
| BIRO109 | DS_ADDRESS_3 | Mailing Address Field 3 | String(25) | |
| BIRO110 | DS_ADDRESS_4 | Mailing Address Field 4 | String(25) | |
| BIRO111 | DS_POST_CODE | Post Code of Data Source | String(25) | |
| BIRO112 | DS_C_CONTACT | Clinical Contact | String(25) | |
| BIRO113 | DS_C_EMAIL | Clinical Contact Email Address | String(50) | |
| BIRO114 | DS_T_CONTACT | Technical Contact | String(25) | |
| BIRO115 | DS_T_EMAIL | Technical Contact Email Address | String(50) |
6. The BIRO Site Profile Dataset
| Ref. | BIRO Name | Description / Parameter | Data Type | Enumerated values / Units |
|---|---|---|---|---|
| BIRO116 | DS_BEDS | Hospital Beds | Integer | |
| BIRO117 | DS_PHYSICIANS | Physicians | Integer | |
| BIRO118 | DS_DIABETOLOGISTS | Diabetes Specialist Consultants | Integer | |
| BIRO119 | DS_DOCTORS | Doctors | Integer | |
| BIRO120 | DS_DSN | Specialist Diabetes Nurses | Integer | |
| BIRO121 | DS_PROGS | Disease Management Programmes | Integer | |
| BIRO122 | DS_DMP_PHYSICIANS | Physicians Offering DMP's for Diabetes | Integer |
7. The BIRO Geographical References Dataset
| Ref. | BIRO Name | Description / Parameter | Data Type | Enumerated values / Units |
|---|---|---|---|---|
| BIRO200 | Continent | Continent (BIRO Custom Level) | string | |
| BIRO201 | Country | Country (NUTS Level 0) | string | |
| BIRO202 | MacroRegion | Sub-National Area (NUTS Level 1) | string | |
| BIRO203 | Region | Region (NUTS Level 2) | string | |
| BIRO204 | HealthAuthority | Local Health Authority (BIRO Custom Level) | string | |
| BIRO205 | Province | Province (NUTS-3) | string | |
| BIRO206 | DistrictUnit | District Health Unit (BIRO Custom Level) | string | |
| BIRO207 | PostCode | Post Code (BIRO Custom Level) | string |
8. The BIRO Indicators
1. Demographic characteristics — Age (classes); Gender
2. Clinical characteristics — Type and duration of diabetes; obesity (weight, BMI); smoking; systolic/diastolic BP; total and HDL cholesterol; creatinine; HbA1c
2.3 Diabetes complications — Retinopathy; end stage renal failure; foot ulcer; lower extremity amputation; stroke; myocardial infarction; hypertension
3. Health system — Provider type; average diabetes population; hospital beds and physicians per 100,000 population
3.3 Processes — Foot examination; eye examination; BP, lipids, microalbumin and HbA1c measurement; antihypertensive, lipid-lowering, ASA and glucose-lowering treatment; self-monitoring; visit frequency
4. Population — Total population; life expectancy; mortality data
5.1 Epidemiology — Diabetes prevalence per 1,000; age at diagnosis by 10-year bands
5.2 Process quality — 16 specified measures covering HbA1c, microalbumin, eye/foot examination, smoking, creatinine, BP and treatment/management
5.3 Intermediate outcomes — HbA1c >9.0%; HbA1c >7.5%; BP <140/90; BMI ≥30; microalbuminuria; smoking; foot ulceration
5.4 Terminal outcomes — renal replacement therapy/ESRD and mortality measures
Complete indicator definitions and reporting groupings (PDF) ↗