Abstract：
OBJECTIVE:To describe the development of an information system that connects data from multiple health records to improve assistance to patients, health services administration, management, evaluation, and inspection, as well as public health and research. METHOD:Deterministic connection of pseudonymized data from a population of 8.5 million inhabitants provided by: a users database, DIRAYA electronic medical records, minimum basic data sets (inpatients, outpatient mayor surgery, hospital emergencies and medical day hospital), mental health information systems, analytical and image tests, vaccines, renal patients, and pharmacy. An automatic coder was used to code clinical diagnoses and 80 chronic pathologies were identified to follow-up. The architecture of the information system consisted of three layers: data (Oracle Database 11g), applications (MicroStrategy BI) and presentation (MicroStrategy Web, JavaScript libraries, HTML 5 and CSS style sheets). Measures for the governance of the system were implemented. RESULTS:Data from 12.5 million health system users between 2001 and 2017 were gathered, including 435.5 million diagnoses, 88.7% of which were generated by the automatic coder. Data can be accessed through predefined reports or dynamic queries, both exportable to CSV files for processing outside the system. Expert analysts can directly access the databases and perform queries using SQL or directly treat the data with external tools. CONCLUSION:The work has shown that the connection of health records opens new possibilities for data analysis.
journal_name
Gac Sanitjournal_title
Gaceta sanitariaauthors
Muñoyerro-Muñiz D,Goicoechea-Salazar JA,García-León FJ,Laguna-Téllez A,Larrocha-Mata D,Cardero-Rivas Mdoi
10.1016/j.gaceta.2019.03.003subject
Has Abstractpub_date
2020-01-01 00:00:00pages
105-113issue
2eissn
0213-9111issn
1578-1283pii
S0213-9111(19)30107-4journal_volume
34pub_type
杂志文章相关文献
Gaceta Sanitaria文献大全abstract：OBJECTIVE:To ascertain the survival by stage of cervical cancer in Mallorca (Spain), to explore factors collected by the Mallorcan Cancer Registry associated with survival, and to determine the distribution of cervical cases by stage. METHOD:Retrospective follow-up study of cases diagnosed with cervical cancer between...
journal_title：Gaceta sanitaria
pub_type： 杂志文章
doi：10.1016/j.gaceta.2019.04.007
更新日期：2020-01-01 00:00:00
abstract：OBJECTIVE:To measure the usefulness of multiple correspondence analysis (MCA) and cluster analysis applied to the epidemiological research of HIV infection. The specific are to explore the relationships between the different variables that characterize the users of the AIDS Information and Prevention Center (CIPS) and ...
journal_title：Gaceta sanitaria
pub_type： 杂志文章
doi：10.1016/s0213-9111(99)71334-8
更新日期：1999-03-01 00:00:00
abstract：:This study aims to validate a frequency questionnaire for categorically ranking people according to recent physical activity (PA) (previous two weeks), applicable to both sexes. Seven one-day PA records were collected for 30 males and 32 females during two weeks. After, the frequency questionnaire was administered cov...
journal_title：Gaceta sanitaria
pub_type： 杂志文章
doi：
更新日期：1995-05-01 00:00:00
abstract：:This article offers a brief summary of the factors that the author believes should be considered when analyzing the multiple interrelations between the economic crisis and its effects on public finances, social spending, and the health and welfare of Spaniards. For the sake of brevity, a linear argument is followed, w...
journal_title：Gaceta sanitaria
pub_type： 杂志文章
doi：10.1016/j.gaceta.2014.02.020
更新日期：2014-06-01 00:00:00
abstract：OBJECTIVE:To compare the morbidity burden of immigrants and natives residing in Aragón, Spain, based on patient registries in primary care, which represents individuals' first contact with the health system. METHODS:A retrospective observational study was carried out, based on linking electronic primary care medical r...
journal_title：Gaceta sanitaria
pub_type： 杂志文章
doi：10.1016/j.gaceta.2014.07.007
更新日期：2015-01-01 00:00:00
abstract：:It is obvious how important is the role of the physicians on drugs consumption. On account of their intermediary in the procurement and consumption of medicines, the prescriber is the main focus of manufacturers' promotional activities aiming at increasing sales and profits although these activities often are disguise...
journal_title：Gaceta sanitaria
pub_type： 杂志文章
doi：10.1016/s0213-9111(96)71880-0
更新日期：1996-03-01 00:00:00
abstract：OBJECTIVE:We estimated the effect that a smoking cessation intervention in the Spanish population of smokers would have on smoking-related morbidity, mortality and health care costs. METHODS:We adopted the model Health and Economic Consequences of Smoking sponsored by the WHO Health Organization and developed by the T...
journal_title：Gaceta sanitaria
pub_type： 杂志文章
doi：10.1016/s0213-9111(02)71929-8
更新日期：2002-07-01 00:00:00
abstract：OBJECTIVE:To evaluate the association between nosocomial infections (NI) and the mortality of Intensive Care Unit (ICU) patients, adjusting for the effect on mortality of other predictive variables. METHODS:Prospective study on 944 concurrent patients admitted for at least 24 hours in the ICU of a tertiary level hospi...
journal_title：Gaceta sanitaria
pub_type： 杂志文章
doi：10.1016/s0213-9111(98)76439-8
更新日期：1998-01-01 00:00:00
abstract：OBJECTIVES:A new index the adequacy of prenatal care utilization (APNCU) index, has been proposed to provide a more accurate and comprehensive measure of antenatal care use than the widely used Kessner index. To better understand the value of the two above mentioned indexes as predictors of preterm delivery, we examine...
journal_title：Gaceta sanitaria
pub_type： 杂志文章
doi：10.1016/s0213-9111(97)71289-5
更新日期：1997-05-01 00:00:00
abstract：BACKGROUND:Smoking is a major cause of mortality in Spain. Tobacco smoking by health care workers has a negative influence on the general population. In Spain, the prevalence of smoking is high and is increasing among women. The aim of this study was to identify tobacco consumption among female physicians and nurses in...
journal_title：Gaceta sanitaria
pub_type： 杂志文章
doi：10.1016/s0213-9111(03)71685-9
更新日期：2003-01-01 00:00:00
abstract：OBJECTIVE:It has been established in the literature that workers within public organisations are intrinsically motivated. This paper is an empirical study of the healthcare sector using methods of qualitative analysis research, which aims to answer the following hypotheses: 1) doctors are intrinsically motivated; 2) ec...
journal_title：Gaceta sanitaria
pub_type： 杂志文章
doi：10.1016/j.gaceta.2016.04.013
更新日期：2016-01-01 00:00:00
abstract：OBJECTIVE:To describe socioeconomic inequalities in the provision and uptake of prenatal care among women in Barcelona (Spain) between 1994 and 2003. METHODS:Cross-sectional study of women in Barcelona who delivered a child without birth defects. Information was obtained from hospital medical records and a personal in...
journal_title：Gaceta sanitaria
pub_type： 杂志文章
doi：10.1157/13084124
更新日期：2006-01-01 00:00:00
abstract：:The conditions of death are studied in a sample of oncological patients who died at home. By interviewing people, relatives or not, who assumed the main responsibility for the patient's care, information was gathered about different aspects of the patient's life in its terminal period. In this study, information was c...
journal_title：Gaceta sanitaria
pub_type： 杂志文章
doi：10.1016/s0213-9111(90)70999-5
更新日期：1990-03-01 00:00:00
abstract：:We explore gender, class and geographical inequalities in health of the population aged over 65 years in Spain. We gathered data from the 1997 National Health Survey, 1999 hospital discharge data, 1998 mortality data from vital statistics, and from the 1999 National Survey on Disabilities. Health related behaviors (to...
journal_title：Gaceta sanitaria
pub_type： 杂志文章
doi：10.1157/13062253
更新日期：2004-05-01 00:00:00
abstract：OBJECTIVE:To analyze the trend in socioeconomic inequalities in all-cause mortality in Barcelona from 1983 to 2004. METHODS:We performed an ecological study of trends over 4 cross-sections (1983-1988, 1989-1994, 1995-1999 and 2000-2004), with the basic health area (BHA) as the unit of analysis. The study population co...
journal_title：Gaceta sanitaria
pub_type： 杂志文章
doi：10.1016/j.gaceta.2009.05.015
更新日期：2010-01-01 00:00:00
abstract：OBJECTIVE:The aim of this study was to design and validate a health services access survey for households in Colombia to provide a methodological tool that allows the country to accumulate evidence of real-life access conditions experienced by the Colombian population. METHODS:A validation study with experts and a pil...
journal_title：Gaceta sanitaria
pub_type： 杂志文章
doi：10.1016/j.gaceta.2016.05.008
更新日期：2016-01-01 00:00:00
abstract：OBJECTIVE:To analyse the Spanish primary care professionals' readiness to respond to intimate partner violence (IPV) in primary care and identify possible determinants that could facilitate a better response. METHOD:A cross-sectional study with a non-probabilistic sampling by convenience was performed among healthcare...
journal_title：Gaceta sanitaria
pub_type： 杂志文章
doi：10.1016/j.gaceta.2017.03.003
更新日期：2018-01-01 00:00:00
abstract：:Foreign migration in Spain is at present a priority in the social and demographic context the country. At a worldwide level, trends in the evolution of population and social, political and economical indicators, appear to maintain for the coming years, the present trends on migrations from poor countries to the rich o...
journal_title：Gaceta sanitaria
pub_type： 杂志文章
doi：10.1157/13086021
更新日期：2006-03-01 00:00:00
abstract：OBJECTIVE:To determine whether negative mood states constitute a risk factor for daily smoking during adolescence, and to specify the role of familial factors in the association between the two variables. METHODS:Cross-sectional study of a representative sample (second wave, Panel of Families and Childhood) of Catalan...
journal_title：Gaceta sanitaria
pub_type： 杂志文章
doi：10.1016/j.gaceta.2011.09.030
更新日期：2012-09-01 00:00:00
abstract：OBJECTIVE:To determine health-related quality of life (HRQoL) measured with the 36-item Short-Form (SF-36) questionnaire in women workers in the fishing industry, compared with norm-based values in the reference population and other similar samples of persons with musculoskeletal disorders. METHOD:A cross-sectional st...
journal_title：Gaceta sanitaria
pub_type： 杂志文章
doi：10.1016/j.gaceta.2013.01.011
更新日期：2013-09-01 00:00:00
abstract：OBJECTIVE:The results of several studies suggest that there is a critical timeframe during development in which experiences of maltreatment and sexual abuse may lead to permanent or long-lasting neurobiological changes that particularly affect the hypothalamus-pituitary-adrenal axis response. The aim of the present stu...
journal_title：Gaceta sanitaria
pub_type： 杂志文章
doi：10.1016/j.gaceta.2010.12.004
更新日期：2011-05-01 00:00:00
abstract：OBJECTIVE:To assess the effectiveness of a proactive and integrated care programme to adjust the use of health resources by chronic complex patients (CCP) identified as potential high consumers according to a predictive model based on prior use and morbidity. METHODS:Randomized controlled clinical trial with three par...
journal_title：Gaceta sanitaria
pub_type： 杂志文章,随机对照试验
doi：10.1016/j.gaceta.2016.07.014
更新日期：2018-01-01 00:00:00
abstract：OBJECTIVE:To explore the applicability of the Consensus Document on School Food Programmes in Educational Centres (DCSECE) to evaluate the adaptation of school menus to healthy eating recommendations. METHOD:Transversal study that analyzes monthly school menus from 28 early-childhood education and primary education ce...
journal_title：Gaceta sanitaria
pub_type： 杂志文章
doi：10.1016/j.gaceta.2019.08.009
更新日期：2021-01-01 00:00:00
abstract：OBJECTIVES:To describe leisure-time physical activity at the levels considered more beneficial for health and to analyze the association with sociodemographic variables and other health behaviors, among the population older than 14 years in Barcelona, Spain. METHODS:A sample of 4,171 adults answered the Health Intervi...
journal_title：Gaceta sanitaria
pub_type： 杂志文章
doi：
更新日期：1998-05-01 00:00:00
abstract：OBJECTIVE:The presence of trihalomethanes in the water systems of several Spanish cities has been demonstrated. The aim of this study was to analyze trihalomethane concentrations in the water provided for human consumption in the city of Barcelona. METHODS:We analyzed 151 water samples collected in 1998. The analyses ...
journal_title：Gaceta sanitaria
pub_type： 杂志文章
doi：10.1016/s0213-9111(02)71668-3
更新日期：2002-05-01 00:00:00
abstract：:The interest of epidemiology in the environmental effects has grown up in recent years. The present paper discusses the role of environmental epidemiology based on a revision of the medical literature appeared in 1989, and on a review of the strategy in setting up standards. Different aspects of the exposure measure, ...
journal_title：Gaceta sanitaria
pub_type： 杂志文章
doi：10.1016/s0213-9111(90)71018-7
更新日期：1990-07-01 00:00:00
abstract：:The reasons and rationale for state intervention in the pharmaceutical industry are discussed with emphasis on two of the most frequent perspectives: the health-focused view and the income-centered approach; these perspectives tend to be ignored, to come into conflict, or to be confused in Spain. The growing impact of...
journal_title：Gaceta sanitaria
pub_type： 杂志文章
doi：10.1016/s0213-9111(08)76082-5
更新日期：2008-04-01 00:00:00
abstract：:Sexual and reproductive health (SRH) is protected by the public authorities to ensure that people enjoy a free, satisfying, and safe sexual life. Despite the approval of the National Sexual and Reproductive Health Strategy in 2011, the progress achieved may be jeopardized by recent proposals for legislative changes af...
journal_title：Gaceta sanitaria
pub_type： 杂志文章
doi：10.1016/j.gaceta.2014.03.007
更新日期：2014-06-01 00:00:00
abstract：OBJECTIVE:To analyze whether the effectiveness of combined antiretroviral therapy in delaying progression to AIDS and death is affected by social inequities in a cohort of HIV-positive injecting drug users (IDUs). METHODS:A cohort of 3,122 HIV-positive IDUs identified in the AIDS Information and Prevention Centers of ...
journal_title：Gaceta sanitaria
pub_type： 杂志文章
doi：10.1016/s0213-9111(08)75352-4
更新日期：2008-11-01 00:00:00
abstract：OBJECTIVE:To describe life and work conditions, practices associated with HIV transmission, self-informed HIV status and HIV test coverage in a group of male transgender street prostitutes. METHODS:Case descriptive study of male transgender street prostitutes who attended a mobile unit of a harm reduction programme in...
journal_title：Gaceta sanitaria
pub_type： 杂志文章
doi：10.1016/s0213-9111(00)71490-7
更新日期：2000-09-01 00:00:00
