BIRO Data Standards


Download BIRO Definitions as a pdf Document (S.Cunningham) September
2011

1. The BIRO Common Dataset


Ref.BIRO NameDescriptionData TypeEnumerated Values/
Measurement Units
BIRO001PAT_IDPatient IDString(12)
BIRO002DS_IDData Source IDString(10)
BIRO003TYPE_DMType Of DiabetesEnumerated1=Type 1
2=Type 2
3=Other
BIRO004SEXSexEnumerated1=Male
2=Female
BIRO005DOBDate of BirthDate/Time
BIRO006DT_DIAGDate of DiagnosisDate/Time
BIRO007EPI_DATEEpisode DateDate/Time
BIRO008SMOK_STATSmoking StatusEnumerated1=Current Smoker
2=Non-Smoker
3=Ex-smoker
BIRO009CIGS_DAYCigarettes per dayInteger
BIRO010ALCOHOLAlcohol IntakeIntegerg/week
g/day
BIRO011WEIGHTWeightRealKg
BIRO012HEIGHTHeightRealm
cm
BIRO013BMIBody Mass IndexReal
BIRO014SBPSystolic Blood PressureIntegermmHg
BIRO015DBPDiastolic Blood PressureIntegermmHg
BIRO016HBA1CHbA1cReal%
BIRO017CREATCreatinineIntegerµmol/l
mg/dl
BIRO018MA_TESTMicroalbuminEnumerated1=MA Normal
2=MA Abnormal
0=No MA Test Recorded
BIRO019CHOLTotal CholesterolIntegermmol/L
mg/dl
BIRO020HDLHDLIntegermmol/L
mg/dl
BIRO021TGTriglyceridesIntegermmol/L
mg/dl
BIRO022EYE_EXAMEye ExaminationEnumerated1=Yes
0=No
BIRO023RETINARetinopathy StatusEnumerated1=No Retinopathy
2=Background Retin.
3=Referable Retin.
BIRO024MACULAMaculopathy StatusEnumerated1=No Maculopathy
2=Referable Macul.
BIRO025FOOT_EXAMFoot ExaminationEnumerated1=Yes
0=No
BIRO026PULSESFoot PulsesEnumerated1=Present
0=Absent
BIRO027FTSENSFoot SensationEnumerated1=Normal
0=Abn.
BIRO028ESRFEnd Stage Renal TherapyEnumerated1=Yes
0=No
BIRO029DIALYSISRenal DialysisEnumerated1=Yes
0=No
BIRO030TRANSPLANTRenal TransplantEnumerated1=Yes
0=No
BIRO031STROKEStrokeEnumerated1=Yes
0=No
BIRO032ULCERActive Foot UlcerEnumerated1=Yes
0=No
BIRO033MIMyocardial InfarctionEnumerated1=Yes
0=No
BIRO034LASERLaserEnumerated1=Yes
0=No
BIRO035HYPERTENSIONHypertensionEnumerated1=Yes
0=No
BIRO036BLINDBlindnessEnumerated1=Yes
0=No
BIRO037AMPUTAmputationEnumerated1=Yes
0=No
BIRO038HYPERT_MEDAntihypertensive MedicationEnumerated1=Yes
0=No
BIRO039DRUG_THERAPYHypoglycemic Drug TherapyEnumerated1=Insulin Only
2=Tablet Only
3=Insulin+Tablets
4=None (Diet)
BIRO040ORAL_THERAPYOral Drug TherapyEnumerated1=Sulphonilureas
2=Biguanides
3=Glucos. Inhib.
4=Glitazones
5=Glinides
BIRO041PUMP_THERAPYPump TherapyEnumerated1=Yes
0=No
BIRO042NASAL_THERAPYNasal TherapyEnumerated1=Yes
0=No
BIRO043INJECTIONSAverage InjectionsEnumerated1=Yes
0=No
BIRO044SELF_MONSelf MonitoringEnumerated1=Urine
2=Blood Glucose
3=Both
BIRO045EDUCATIONDiabetes Specific EducationEnumerated1=Yes
0=No
BIRO046LIPID_THERAPYLipid Lowering TherapyEnumerated1=Yes
0=No
BIRO047ANTIPLATELET_ THERAPYAnti-platelet TherapyEnumerated1=Yes
0=No
BIRO048DMP_ENROLPatient Enrolment in DMP for DiabetesEnumerated1=Yes
0=No

2. The BIRO Activity Table


ReferenceBIRO NameParameterData TypeEnumerated Values
BIRO001PAT_IDPatient IDString(12)
BIRO049START_DATEStart dateDate/Time
BIRO050START_REASONStart reasonEnumerated1=birth
2=diagnosis
3=transferred in
BIRO051END_DATEEnd dateDate/Time
BIRO052END_REASONEnd reasonEnumerated1=death
2=transferred out
3=lost to follow up

3. The BIRO Population table


ReferenceBIRO NameParameterData TypeEnumerated Values
BIRO053YEARYearDate/Year
BIRO054POP_MTotal Male PopulationInteger
BIRO055POP_FTotal Female PopulationInteger
BIRO056DEATHS_MTotal Deaths in Male PopulationInteger
BIRO057DEATHS_FTotal Deaths in Female PopulationInteger

4. The BIRO Diabetic population table


ReferenceBIRO NameParameterData TypeEnumerated Values
BIRO053YEARYearDate/Year
BIRO058AGEBANDAge bandEnumerated1=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+
BIRO003TYPE_DMType of DiabetesEnumerated1=Type 1
2=Type 2
3=Other
BIRO059POPD_MTotal Diabetic in Male PopulationInteger
BIRO060POPD_FTotal Diabetic in Female PopulationInteger

5. The BIRO Site header dataset


Ref.Field NameParameterData TypeEnumerated Values
BIRO101DS_COUNTRYCountry
of Origin
String(25)
BIRO102DS_TYPEData 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
BIRO103DS_NAMEData Source
Name
String(25)
BIRO104DS_DENOMData Source
Denominator
Integer
BIRO105DS_AREAGeographical AreaInteger
BIRO106DS_WEBSITEWebsite AddressString(50)
BIRO107DS_ADDRESS_1Mailing Address
Field 1
String(25)
BIRO108DS_ADDRESS_2Mailing Address
Field 2
String(25)
BIRO109DS_ADDRESS_3Mailing Address
Field 3
String(25)
BIRO110DS_ADDRESS_4Mailing Address
Field 4
String(25)
BIRO111DS_POST_CODEPost Code of
Data Source
String(25)
BIRO112DS_C_CONTACTClinical ContactString(25)
BIRO113DS_C_EMAILClinical Contact
Email Address
String(50)
BIRO114DS_T_CONTACTTechnical ContactString(25)
BIRO115DS_T_EMAILTechnical Contact
Email Address
String(50)

6. The BIRO Site Profile Dataset


Ref.Field NameParameterData Type
BIRO116DS_BEDSHospital BedsInteger
BIRO117DS_PHYSICIANSPhysiciansInteger
BIRO118DS_DIABETOLOGISTSDiabetes Specialist ConsultantsInteger
BIRO119DS_DOCTORSDoctorsInteger
BIRO120DS_DSNSpecialist Diabetes NursesInteger
BIRO121DS_PROGSDisease Management ProgrammesInteger
BIRO122DS_DMP_PHYSICIANSPhysicians Offering DMP's for DiabetesInteger

7. The BIRO Geographical References dataset


Ref.Field NameParameterData Type
BIRO200ContinentContinent (BIRO Custom Level)string
BIRO201CountryCountry (NUTS Level 0)string
BIRO202MacroRegionSub-National Area (NUTS Level 1)string
BIRO203RegionRegion (NUTS Level 2)string
BIRO204HealthAuthorityLocal Health Authority (BIRO Custom Level)string
BIRO205ProvinceProvince (NUTS-3)string
BIRO206DistrictUnitDistrict Health Unit (BIRO Custom Level)string
BIRO207PostCodePost Code (BIRO Custom Level)string

8. The BIRO Indicators


Ref.IndicatorStrata
1. Demographic characteristics
1.1 Age (Classes)Gender
1.2 GenderAge
2. Clinical characteristics
2.1 Diabetes status
2.1.1 Type of diabetesAge
2.1.2 Duration of diabetesType of diabetes
Gender
Hba1c
2.2 Risk factors for diabetes complications
2.2.1 Obesity
2.2.1.1 WeightGender
Age
Type of diabetes
2.2.1.2 BMIGender
Age
Type of diabetes
2.2.2 Lifestyle
2.2.2.1 Smoking statusGender
Age
Type of diabetes
2.2.3 Clinical measurements
2.2.3.1 Systolic BPGender
Age
Type of diabetes
2.2.3.2 Diastolic BPGender
Age
Type of diabetes
2.2.3.3 Total cholesterolGender
Age
Type of diabetes
2.2.3.4 HDL-cholesterolGender
Age
Type of diabetes
2.2.3.5 CreatinineGender
Age
Type of diabetes
2.2.3.6 HbA1cGender
Age
Type of diabetes
2.3 Diabetes complications
2.3.1 RetinopathyDiabetes duration
2.3.2 End stage renal failureDiabetes duration
2.3.3 Foot ulcerDiabetes duration
2.3.4 Lower etremity amputationDiabetes duration
2.3.5 StrokeDiabetes duration
2.3.6 Myocardial infarctionDiabetes duration
2.3.7 HypertensionDiabetes duration
3. Health system
3.1 Structure (provider level)
3.1.1 Type of provider
3.1.2 Average diabetes population per centreGender
Age
Type of diabetes
3.2 Structural quality
3.2.1 Hospital beds per 100,000 populationRegion
3.2.2 Physicians employed per 100,000 populationRegion
3.3 Processes
3.3.1 Foot eamination
3.3.1.1 DoneAge
Type of diabetes
3.3.2 Eye eamination
3.3.2.1 DoneAge
Type of diabetes
3.3.3 Measurement done
3.3.3.1 BP doneAge
Type of diabetes
3.3.3.2 Lipids doneAge
Type of diabetes
3.3.3.3 Microalbumin doneAge
Type of diabetes
3.3.3.4 HbA1c doneAge
Type of diabetes
3.3.4 Treatment
3.3.4.1 Antihypertensive medicationAge
Type of diabetes
3.3.4.2 Lipid lowering treatmentAge
Type of diabetes
3.3.4.3 ASA treatment (Aspirin)Age
Type of diabetes
3.3.4.4 Glucose lowering treatment
3.3.4.4.1 Diet onlyAge
Type of diabetes
3.3.4.4.2 Tablets: 1. Sulphonyureas, 2. Biguanides, 3. Glucosidase Inhibitors,4. Glitazones, 5. Glinides, 6. OtherAge Type of diabetes
3.3.4.4.3 Insulin onlyAge
Type of diabetes
3.3.4.4.4 Insulin and tabletsAge
Type of diabetes
3.3.4.4.5 Insulin pumpAge
Type of diabetes
3.3.5 Management
3.3.5.1 Self-monitoringAge
Type of diabetes
3.3.5.2 Visit frequencyAge
Type of diabetes
4. Population
4.1 Area level
4.1.1 Total populationAge
Gender
4.1.2 Life expectancyAge
Gender
4.1.3 Mortality dataAge
Gender
5. Risk adjusted indicators
5.1 Epidemiology
5.1.1 Prevalence of diabetes mellitus per 1,000Region
Type of diabetes
5.1.2 Age at diagnosis by 10 year age bands (incidence)Region
Type of diabetes
5.2 Process quality
5.2.1 % of persons with diabetes with one or more HbA1c tests during the last 12 monthsRegion
Gender
Age
Type of diabetes
5.2.2 % of persons with diabetes with at least one test for microalbuminuria during the last 12 monthsRegion
Gender
Age
Type of diabetes
5.2.3 % of persons with diabetes who received a dilated eye examination or evaluation of retinal photography by a trained caregiver within the last 12 monthsRegion
Gender
Age
Type of diabetes
5.2.4 % of persons with diabetes receiving at least one examination of the feet within the last 12 monthsRegion
Gender
Age
Type of diabetes
5.2.5 % of persons with diabetes whose smoking status was ascertained and documented within the last 12 monthsRegion
Gender
Age
Type of diabetes
5.2.6 % with serum creatinine tested in last 12 monthsRegion
Gender
Age
Type of diabetes
5.2.7 % of persons with diabetes and one or more blood pressure measurements within the last 12 monthsRegion
Gender
Age
Type of diabetes
5.2.8 % of persons with diabetes with hypertension who receive antihypertensive medicationRegion
Gender
Age
Type of diabetes
5.2.9 Type of oral therapy (distribution of agents) in persons with diabetes type 2Country
Gender
Age
5.2.10 % of persons treated with insulin among persons with diabetesRegion
Gender
Age
Type of diabetes
5.2.11 % of persons treated with insulin in combination with OADs among persons with diabetesCountry
Gender
Age
5.2.12 % of insulin treated persons with diabetes with insulinpump therapyRegion
Gender
Age
Type of diabetes
5.2.13 % of persons with diabetes with anti hypertensive treatmentRegion
Gender
Age
Type of diabetes
5.2.14 % of persons with diabetes with lipid lowering treatmentRegion
Gender
Age
Type of diabetes
5.2.15 % of persons with diabetes with ASA treatmentRegion
Gender
Age
Type of diabetes
5.2.16 % of persons with diabetes performing self-monitoring of blood glucoseRegion
Gender
Age
Type of diabetes
5.3 Outcome quality-intermediate outcomes
5.3.1 % of persons with diabetes with most recent HbA1c level >9.0%Region
Gender
Age
Type of diabetes
5.3.2 % of persons with diabetes with most recent HbA1c level >7,5%Region
Gender
Age
Type of diabetes
5.3.3 % of persons with diabetes with most recent blood pressure less than 140/90 mmHgRegion
Gender
Age
Type of diabetes
5.3.4 % of persons with diabetes with BMI = 30Region
Gender
Age
Type of diabetes
5.3.5 % of persons with diabetes with microalbuminuria in last 12 months (among those who have been tested)Region
Gender
Age
Type of diabetes
5.3.6 % of persons with diabetes who currently smoke among persons with diabetesRegion
Gender
Age
Type of diabetes
5.3.7 % of persons with diabetes with former or current foot ulcerationRegion
Gender
Age
Type of diabetes
5.4 Outcome Quality - Terminal outcomes
5.4.1 Annual incidence of dialysis and/or transplantation (renal replacement therapy) per 100,000 populations in persons with diabetesRegion
Gender
Age
Type of diabetes
5.4.2 % of persons with diabetes with ESRDRegion
Gender
Age
Type of diabetes
5.4.3 Annual death rate per 100,000 populations in the general population from all causes, adjusted for standard European population. Annual death rate per 100,000 populations in persons, who have as primary or secondary cause of death, diabetes mellitus, adjusted for standard European populationRegion