| Literature DB >> 31861310 |
Edlira Skrami1, Flavia Carle1, Simona Villani2, Paola Borrelli2, Antonella Zambon3, Giovanni Corrao3, Paolo Trerotoli4, Vincenzo Guardabasso5, Rosaria Gesuita1.
Abstract
The purpose of the study was to map and describe the healthcare utilization databases (HUDs) available in Italy's 19 regions and two autonomous provinces and develop a tool to navigate through them. A census of the HUDs covering the population of a single region/province and recording local-level data was conducted between January 2014 and October 2016. The characteristics of each HUD regarding the start year, data type and completeness, data management system (DMS), data protection procedures, and data quality control adopted were collected through interviews with the database managers using a standard questionnaire or directly from the website of the regional body managing them. Overall, 352 HUDs met the study criteria. The DMSs, anonymization procedures of personal identification data, and frequency of data quality control were fairly homogeneous within regions, whereas the number of HUDs, data availability, type of identification code, and anonymization procedures were considerably heterogeneous across regions. The study provides an updated inventory of the available regional HUDs in Italy and highlights the need for greater homogeneity across regions to improve comparability of health data from secondary sources. It could represent a reference model for other countries to provide information on the available HUDs and their features, enhancing epidemiological studies across countries.Entities:
Keywords: Italy; epidemiology; healthcare utilization databases; population based
Mesh:
Year: 2019 PMID: 31861310 PMCID: PMC6982131 DOI: 10.3390/ijerph17010008
Source DB: PubMed Journal: Int J Environ Res Public Health ISSN: 1660-4601 Impact factor: 3.390
Figure 1Flow chart of the survey process.
Regional healthcare utilization databases (HUDs) identified in Italy grouped by region and HUD category.
| Geographical | Regions | Population Covered * | HUD Categories | Total | ||
|---|---|---|---|---|---|---|
| Healthcare | Conditions, Diseases, | Other | ||||
| North | Piemonte | 4422 | 10 (37; 5.6) | 11 (40.7; 11.7) | 6 (22.2; 7.7) | 27 (7.7) |
| Valle d’Aosta | 128 | 9 (42.9; 5) | 7 (33.3; 7.4) | 5 (23.8; 6.4) | 21 (6) | |
| Liguria | 1582 | 11 (73.3; 6.1) | 1 (6.7; 1.1) | 3 (20; 3.8) | 15 (4.3) | |
| Lombardia | 9995 | 6 (42.9; 3.3) | 2 (14.3; 2.1) | 6 (42.9; 7.7) | 14 (4) | |
| Province of Trento | 537 | 15 (38.5; 8.3) | 17 (43.6; 18.1) | 7 (17.9; 9) | 39 (11.1) | |
| Province of Bolzano | 518 | 6 (66.7; 3.3) | 1 (11.1; 1.1) | 2 (22.2; 2.6) | 9 (2.6) | |
| Veneto | 4923 | 12 (52.2; 6.7) | 6 (26.1; 6.4) | 5 (21.7; 6.4) | 23 (6.5) | |
| Friuli Venezia Giulia | 1226 | 7 (46.7; 3.9) | 4 (26.7; 4.3) | 4 (26.7; 5.1) | 15 (4.3) | |
| Emilia-Romagna | 4448 | 14 (77.8; 7.8) | 2 (11.1; 2.1) | 2 (11.1; 2.6) | 18 (5.1) | |
| Center | Marche | 1549 | 11 (40.7; 6.1) | 10 (37; 10.6) | 6 (22.2; 7.7) | 27 (7.7) |
| Toscana | 3749 | 10 (50; 5.6) | 4 (20; 4.3) | 6 (30; 7.7) | 20 (5.7) | |
| Umbria | 894 | 7 (58.3; 3.9) | 3 (25; 3.2) | 2 (16.7; 2.6) | 12 (3.4) | |
| Lazio | 5884 | 6 (50; 3.3) | 4 (33.3; 4.3) | 2 (16.7; 2.6) | 12 (3.4) | |
| South and Islands | Campania | 5861 | 6 (66.7; 3.3) | - | 3 (33.3; 3.8) | 9 (2.6) |
| Abruzzo | 1331 | 7 (63.6; 3.9) | 2 (18.2; 2.1) | 2 (18.2; 2.6) | 11 (3.1) | |
| Molise | 313 | 4 (40; 2.2) | 4 (40; 4.3) | 2 (20; 2.6) | 10 (2.8) | |
| Puglia | 4086 | 4 (36.4; 2.2) | 4 (36.4; 4.3) | 3 (27.3; 3.8) | 11 (3.1) | |
| Basilicata | 576 | 15 (75; 8.3) | 1 (5; 1.1) | 4 (20; 5.1) | 20 (5.7) | |
| Calabria | 1976 | 5 (35.7; 2.8) | 7 (50; 7.4) | 2 (14.3; 2.6) | 14 (4) | |
| Sardegna | 1662 | 4 (66.7; 2.2) | 1 (16.7; 1.1) | 1 (16.7; 1.3) | 6 (1.7) | |
| Sicilia | 5087 | 11 (57.9; 6.1) | 3 (15.8; 3.2) | 5 (26.3; 6.4) | 19 (5.4) | |
| Total | 60,748 | 180 (51.1) | 94 (26.7) | 78 (22.2) | 352 (100) |
Unless otherwise indicated, data are reported as absolute frequency (row percentage; column percentage). * Mean of regional population, as thousands of residents between 2014 and 2016 according to the Italian National Institute of Statistics.
HUD start year by HUD category.
| HUD Categories | Start Year | Total | |||
|---|---|---|---|---|---|
| <2000 | 2000–2006 | ≥2006 | Not Reported | ||
| Healthcare services | 37 (19.9; 39.8) | 31 (16.7; 40.3) | 97 (52.2; 65.5) | 21 (11.3; 61.8) | 186 (52.8) |
| Conditions, diseases, other events | 42 (44.7; 45.2) | 28 (29.8; 36.4) | 19 (20.2; 12.8) | 5 (5.3; 14.7) | 94 (26.7) |
| Other databases | 14 (19.4; 15.1) | 18 (25; 23.4) | 32 (44.4; 21.6) | 8 (11.1; 23.5) | 72 (20.5) |
| Total | 93 (26.4) | 77 (21.9) | 148 (42) | 34 (9.7) | 352 (100) |
Data are reported as absolute frequency (row percentage; column percentage).
Data management system (DMS) used in the HUDs according to HUD category.
| DMS | HUD Categories | Total | ||
|---|---|---|---|---|
| Healthcare Services | Conditions, Diseases, Other Events | Other Databases | ||
| Oracle | 37 (48.7; 20.6) | 24 (31.6; 25.5) | 15 (19.7; 19.2) | 76 (21.6) |
| SQL | 35 (53; 19.4) | 11 (16.7; 11.7) | 20 (30.3; 25.6) | 66 (18.8) |
| SAS § | 22 (57.9; 12.2) | 9 (23.7; 9.6) | 7 (18.4; 9) | 38 (10.8) |
| Other # | 17 (34; 9.4) | 24 (48; 25.5) | 9 (18; 11.5) | 50 (14.2) |
| More than one | 25 (62.5; 13.9) | 5 (12.5; 5.3) | 10 (25; 12.8) | 40 (11.4) |
| Not reported | 44 (53.7; 24.4) | 21 (25.6; 22.3) | 17 (20.7; 21.8) | 82 (23.3) |
| Total | 180 (51.1) | 94 (26.7) | 78 (22.2) | 352 (100) |
Data are reported as absolute frequency (row percentage; column percentage); § Statistical Analysis System # Java, Excel, Access, Sequential archive, Ippocrate, Netezza (a platform of the Ministry of Health), or not specified.
Type of personal identification code used in the HUDs according to HUD category.
| Type of Identification Code | HUD Categories | Total | ||
|---|---|---|---|---|
| Healthcare Services | Conditions, Diseases, Other Events | Other | ||
| Unique identification code § | 90 (55.2; 50) | 39 (23.9; 41.5) | 34 (20.9; 43.6) | 163 (46.3) |
| Fiscal code # | 49 (52.7; 27.2) | 20 (21.5; 21.3) | 24 (25.8; 30.8) | 93 (26.4) |
| No code | 38 (50.7; 21.1) | 20 (26.7; 21.3) | 17 (22.7; 21.8) | 21 (6) |
| Not reported | 3 (14.3; 1.7) | 15 (71.4; 16) | 3 (14.3; 3.8) | 75 (21.3) |
| Total | 180 (51.1) | 94 (26.7) | 78 (22.2) | 352 (100) |
Data are reported as absolute frequency (row percentage; column percentage). § Unique identification code: a sequential number assigned to the observation unit in the database according to the order of registration. # Fiscal code: in Italy, the tax code, which identifies each subject in their dealings with the public administration and in dealings between the public administration and other public or private entities. It consists of letters and numbers based on the subject’s first name, family name, and date and place of birth.
Method used to anonymize personal data by HUD category.
| Anonymization Method | HUD Categories | Total | ||
|---|---|---|---|---|
| Healthcare Services | Conditions, Diseases, Other Events | Other | ||
| Separation | 54 (64.3; 30) | 15 (17.9; 16) | 15 (17.9; 19.2) | 84 (23.9) |
| Pseudonymization | 16 (57.1; 8.9) | 8 (28.6; 8.5) | 4 (14.3; 5.1) | 28 (8.0) |
| Internal procedure | 38 (48.1; 21.1) | 18 (22.8; 19.1) | 23 (29.1; 29.5) | 79 (22.4) |
| Encryption | 15 (57.7; 8.3) | 5 (19.2; 5.3) | 6 (23.1; 7.7) | 26 (7.4) |
| No anonymization | 8 (20; 4.4) | 24 (60; 25.5) | 8 (20; 10.3) | 40 (11.4) |
| Not reported | 49 (51.6; 27.2) | 24 (25.3; 25.5) | 22 (23.2; 28.2) | 95 (27.0) |
| Total | 180 (51.1) | 94 (26.7) | 78 (22.2) | 352 (100) |
Data are reported as absolute frequency (row percentage; column percentage).
Types of coding systems used in HUD categories.
| Classification Systems | HUD Categories | Total | ||
|---|---|---|---|---|
| Healthcare Services | Condition, Diseases, Other Events | Other Databases | ||
| ICD9/10 CM | 97 (64.2; 53.9) | 48 (31.8; 51.1) | 6 (4; 7.7) | 151 (42.9) |
| ATC/AIC § | 0 | 0 | 21 (100; 26.9) | 21 (6.0) |
| Other * | 2 (10.5; 1.1) | 9 (47.4; 9.6) | 8 (42.1; 10.3) | 19 (5.4) |
| No codes | 4 (21.1; 2.2) | 10 (52.6; 10.6) | 5 (26.3; 6.4) | 19 (5.4) |
| Not Reported | 77 (54.2; 42.8) | 27 (19; 28.7) | 38 (26.8; 48.7) | 142 (40.3) |
| Total | 180 (51.1) | 94 (26.7) | 78 (22.2) | 352 (100) |
Data are reported as absolute frequency (row percentage; column percentage). § Anatomical Therapeutic Chemical classification/ Italian authorisation number for medicines; * Other includes (1) Italian National Institute of Statistics to code province, region, and country of residence and birth; (2) co-payment exemption code provided by the Italian Ministry of Health (Ministero della Salute (1999). Decreto 28 maggio 1999, n. 329. http://www.trovanorme.salute.gov.it/norme/dettaglioAtto?id=18796. Accessed on 11 March 2019); (3) Systematized Nomenclature of Medicine (SNOMED, https://www.snomed.org/ Accessed on 4 April 2019); (4) International Classification of Primary Care (ICPC, http://www.globalfamilydoctor.com/groups/WorkingParties/wicc.aspx. Accessed on 4 April 2019); (5) morphologic codes (International Classification of Diseases for Oncology, 3rd Edition, ICD-O 3, http://www.who.int/classifications/icd/adaptations/oncology/en/ Accessed on 19 February 2019); (6) the classification system of malignant tumors, TNM (https://www.uicc.org/resources/tnm. Accessed on 4 February 2019).
Frequency of the data quality control in HUD categories.
| Data Quality Control | HUD Categories | Total | ||
|---|---|---|---|---|
| Healthcare Services | Condition, Diseases, Other Events | Other Databases | ||
| At the time of data recording | 80 (56.3; 44.4) | 32 (22.5; 34) | 30 (21.1; 38.5) | 142 (40.3) |
| ≤1 month | 45 (52.9; 25) | 13 (15.3; 13.8) | 27 (31.8; 34.6) | 85 (24.1) |
| 3 ≤ months ≤ 12 | 37 (53.6; 20.6) | 24 (34.8; 25.5) | 8 (11.6; 10.3) | 69 (19.6) |
| No control | 0 | 6 (100; 6.4) | 0 | 6 (1.7) |
| Not reported | 18 (36; 10) | 19 (38; 20.2) | 13 (26; 16.7) | 50 (14.2) |
| Total | 180 (51.1) | 94 (26.7) | 78 (22.2) | 352 (100) |
Data are reported as absolute frequency (row percentage; column percentage).
Frequency of data transmission in the HUD categories.
| Data Transmission | HUD Categories | Total | ||
|---|---|---|---|---|
| Healthcare Services | Condition, Diseases, Other Events | Other Databases | ||
| At the time of data recording | 8 (21.1; 4.4) | 23 (60.5; 24.5) | 7 (18.4; 9) | 38 (10.8) |
| <1 month | 95 (55.2; 52.8) | 25 (14.5; 26.6) | 52 (30.2; 66.7) | 172 (48.9) |
| 3 ≤ months ≤ 12 | 52 (57.8; 28.9) | 29 (32.2; 30.9) | 9 (10; 11.5) | 90 (25.6) |
| Not defined | 5 (41.7; 2.8) | 6 (50; 6.4) | 1 (8.3; 1.3) | 12 (3.4) |
| Not reported | 20 (50; 11.1) | 11 (27.5; 11.7) | 9 (22.5; 11.5) | 40 (11.4) |
| Total | 180 (51.1) | 94 (26.7) | 78 (22.2) | 352 (100) |
Data are reported as absolute frequency (row percentage; column percentage).