THE IMPROVEMENT STUDY OF THE EXISTING ERP SYSTEM IN THE COMPANY ACORD-92 D.O.O.

Diplomsko delo opisuje uporabnost in pomembnost celovitih informacijskih sistemov v podjetju, kar je v diplomski nalogi opisano na primeru podjetja Acord-92 d.o.o.. V prvem delu diplome so opisanni poslovni procesi v podjetju Acord-92 d.o.o.. Prikazana je tudi povezanost poslovnih procesov z informacijskim sistemom Navision 3.56A, ki ga v podjetju uporabljajo. Prav tako so opisane vse prednosti in slabosti obstoječega ERP sistema. Prva opisana rešitev je nadgradnja z ERP sistemom Microsoft Dynamics NAV 2009, druga pa je uvedba odprtokodne rešitve OpenERP. Omenjenji rešitvi sta v diplomski nalogi primerjani s SWOT analizo in na podlagi le te smo v diplomski nalogi ugotavljali katera rešitev je za podjetje Acord-92 d.o.o. primernejša.The respective diploma thesis describes the employability and importance of holistic information systems in companies, which is represented here in the exemplary caompany Acord-92 d.o.o.. The first part of the thesis describes the business processes of the company Acord-92 d.o.o. as well as it represents the connection between these processes and the information system Navision 3.56A, which has been useed in the respective company. The thesis also discusses all the advantages and disadvantages of the existing ERP system. The second part of the thesis offers two possible solutions for the improvement of the existing ERP system. The first offered solution is an upgrade with the ERP system Microsoft Dynamics NAV 2009 and the second one is the introduction of the open-code solution OpenERP. In this thesis, the two solutions in question are beeing compared to SWOT analysis, on the basis of which we try to assess which of the two goven solutions is more appropriate for the company Acord-92 d.o.o.

Multinational characterization of neurological phenotypes in patients hospitalized with COVID-19

International audienceAbstract Neurological complications worsen outcomes in COVID-19. To define the prevalence of neurological conditions among hospitalized patients with a positive SARS-CoV-2 reverse transcription polymerase chain reaction test in geographically diverse multinational populations during early pandemic, we used electronic health records (EHR) from 338 participating hospitals across 6 countries and 3 continents (January–September 2020) for a cross-sectional analysis. We assessed the frequency of International Classification of Disease code of neurological conditions by countries, healthcare systems, time before and after admission for COVID-19 and COVID-19 severity. Among 35,177 hospitalized patients with SARS-CoV-2 infection, there was an increase in the proportion with disorders of consciousness (5.8%, 95% confidence interval [CI] 3.7–7.8%, p FDR < 0.001) and unspecified disorders of the brain (8.1%, 5.7–10.5%, p FDR < 0.001) when compared to the pre-admission proportion. During hospitalization, the relative risk of disorders of consciousness (22%, 19–25%), cerebrovascular diseases (24%, 13–35%), nontraumatic intracranial hemorrhage (34%, 20–50%), encephalitis and/or myelitis (37%, 17–60%) and myopathy (72%, 67–77%) were higher for patients with severe COVID-19 when compared to those who never experienced severe COVID-19. Leveraging a multinational network to capture standardized EHR data, we highlighted the increased prevalence of central and peripheral neurological phenotypes in patients hospitalized with COVID-19, particularly among those with severe disease

International Analysis of Electronic Health Records of Children and Youth Hospitalized With COVID-19 Infection in 6 Countries

International audienceAdditional sources of pediatric epidemiological and clinical data are needed to efficiently study COVID-19 in children and youth and inform infection prevention and clinical treatment of pediatric patients

Evolving phenotypes of non-hospitalized patients that indicate long COVID

International audienceAbstract Background For some SARS-CoV-2 survivors, recovery from the acute phase of the infection has been grueling with lingering effects. Many of the symptoms characterized as the post-acute sequelae of COVID-19 (PASC) could have multiple causes or are similarly seen in non-COVID patients. Accurate identification of PASC phenotypes will be important to guide future research and help the healthcare system focus its efforts and resources on adequately controlled age- and gender-specific sequelae of a COVID-19 infection. Methods In this retrospective electronic health record (EHR) cohort study, we applied a computational framework for knowledge discovery from clinical data, MLHO, to identify phenotypes that positively associate with a past positive reverse transcription-polymerase chain reaction (RT-PCR) test for COVID-19. We evaluated the post-test phenotypes in two temporal windows at 3–6 and 6–9 months after the test and by age and gender. Data from longitudinal diagnosis records stored in EHRs from Mass General Brigham in the Boston Metropolitan Area was used for the analyses. Statistical analyses were performed on data from March 2020 to June 2021. Study participants included over 96 thousand patients who had tested positive or negative for COVID-19 and were not hospitalized. Results We identified 33 phenotypes among different age/gender cohorts or time windows that were positively associated with past SARS-CoV-2 infection. All identified phenotypes were newly recorded in patients’ medical records 2 months or longer after a COVID-19 RT-PCR test in non-hospitalized patients regardless of the test result. Among these phenotypes, a new diagnosis record for anosmia and dysgeusia (OR 2.60, 95% CI [1.94–3.46]), alopecia (OR 3.09, 95% CI [2.53–3.76]), chest pain (OR 1.27, 95% CI [1.09–1.48]), chronic fatigue syndrome (OR 2.60, 95% CI [1.22–2.10]), shortness of breath (OR 1.41, 95% CI [1.22–1.64]), pneumonia (OR 1.66, 95% CI [1.28–2.16]), and type 2 diabetes mellitus (OR 1.41, 95% CI [1.22–1.64]) is one of the most significant indicators of a past COVID-19 infection. Additionally, more new phenotypes were found with increased confidence among the cohorts who were younger than 65. Conclusions The findings of this study confirm many of the post-COVID-19 symptoms and suggest that a variety of new diagnoses, including new diabetes mellitus and neurological disorder diagnoses, are more common among those with a history of COVID-19 than those without the infection. Additionally, more than 63% of PASC phenotypes were observed in patients under 65 years of age, pointing out the importance of vaccination to minimize the risk of debilitating post-acute sequelae of COVID-19 among younger adults

International comparisons of laboratory values from the 4CE collaborative to predict COVID-19 mortality

International audienceAbstract Given the growing number of prediction algorithms developed to predict COVID-19 mortality, we evaluated the transportability of a mortality prediction algorithm using a multi-national network of healthcare systems. We predicted COVID-19 mortality using baseline commonly measured laboratory values and standard demographic and clinical covariates across healthcare systems, countries, and continents. Specifically, we trained a Cox regression model with nine measured laboratory test values, standard demographics at admission, and comorbidity burden pre-admission. These models were compared at site, country, and continent level. Of the 39,969 hospitalized patients with COVID-19 (68.6% male), 5717 (14.3%) died. In the Cox model, age, albumin, AST, creatine, CRP, and white blood cell count are most predictive of mortality. The baseline covariates are more predictive of mortality during the early days of COVID-19 hospitalization. Models trained at healthcare systems with larger cohort size largely retain good transportability performance when porting to different sites. The combination of routine laboratory test values at admission along with basic demographic features can predict mortality in patients hospitalized with COVID-19. Importantly, this potentially deployable model differs from prior work by demonstrating not only consistent performance but also reliable transportability across healthcare systems in the US and Europe, highlighting the generalizability of this model and the overall approach

Characterization of long COVID temporal sub-phenotypes by distributed representation learning from electronic health record data: a cohort studyResearch in Context

Summary: Background: Characterizing Post-Acute Sequelae of COVID (SARS-CoV-2 Infection), or PASC has been challenging due to the multitude of sub-phenotypes, temporal attributes, and definitions. Scalable characterization of PASC sub-phenotypes can enhance screening capacities, disease management, and treatment planning. Methods: We conducted a retrospective multi-centre observational cohort study, leveraging longitudinal electronic health record (EHR) data of 30,422 patients from three healthcare systems in the Consortium for the Clinical Characterization of COVID-19 by EHR (4CE). From the total cohort, we applied a deductive approach on 12,424 individuals with follow-up data and developed a distributed representation learning process for providing augmented definitions for PASC sub-phenotypes. Findings: Our framework characterized seven PASC sub-phenotypes. We estimated that on average 15.7% of the hospitalized COVID-19 patients were likely to suffer from at least one PASC symptom and almost 5.98%, on average, had multiple symptoms. Joint pain and dyspnea had the highest prevalence, with an average prevalence of 5.45% and 4.53%, respectively. Interpretation: We provided a scalable framework to every participating healthcare system for estimating PASC sub-phenotypes prevalence and temporal attributes, thus developing a unified model that characterizes augmented sub-phenotypes across the different systems. Funding: Authors are supported by National Institute of Allergy and Infectious Diseases, National Institute on Aging, National Center for Advancing Translational Sciences, National Medical Research Council, National Institute of Neurological Disorders and Stroke, European Union, National Institutes of Health, National Center for Advancing Translational Sciences

Clinical phenotypes and outcomes in children with multisystem inflammatory syndrome across SARS-CoV-2 variant eras: a multinational study from the 4CE consortiumResearch in context

Summary: Background: Multisystem inflammatory syndrome in children (MIS-C) is a severe complication of SARS-CoV-2 infection. It remains unclear how MIS-C phenotypes vary across SARS-CoV-2 variants. We aimed to investigate clinical characteristics and outcomes of MIS-C across SARS-CoV-2 eras. Methods: We performed a multicentre observational retrospective study including seven paediatric hospitals in four countries (France, Spain, U.K., and U.S.). All consecutive confirmed patients with MIS-C hospitalised between February 1st, 2020, and May 31st, 2022, were included. Electronic Health Records (EHR) data were used to calculate pooled risk differences (RD) and effect sizes (ES) at site level, using Alpha as reference. Meta-analysis was used to pool data across sites. Findings: Of 598 patients with MIS-C (61% male, 39% female; mean age 9.7 years [SD 4.5]), 383 (64%) were admitted in the Alpha era, 111 (19%) in the Delta era, and 104 (17%) in the Omicron era. Compared with patients admitted in the Alpha era, those admitted in the Delta era were younger (ES −1.18 years [95% CI −2.05, −0.32]), had fewer respiratory symptoms (RD −0.15 [95% CI −0.33, −0.04]), less frequent non-cardiogenic shock or systemic inflammatory response syndrome (SIRS) (RD −0.35 [95% CI −0.64, −0.07]), lower lymphocyte count (ES −0.16 × 109/uL [95% CI −0.30, −0.01]), lower C-reactive protein (ES −28.5 mg/L [95% CI −46.3, −10.7]), and lower troponin (ES −0.14 ng/mL [95% CI −0.26, −0.03]). Patients admitted in the Omicron versus Alpha eras were younger (ES −1.6 years [95% CI −2.5, −0.8]), had less frequent SIRS (RD −0.18 [95% CI −0.30, −0.05]), lower lymphocyte count (ES −0.39 × 109/uL [95% CI −0.52, −0.25]), lower troponin (ES −0.16 ng/mL [95% CI −0.30, −0.01]) and less frequently received anticoagulation therapy (RD −0.19 [95% CI −0.37, −0.04]). Length of hospitalization was shorter in the Delta versus Alpha eras (−1.3 days [95% CI −2.3, −0.4]). Interpretation: Our study suggested that MIS-C clinical phenotypes varied across SARS-CoV-2 eras, with patients in Delta and Omicron eras being younger and less sick. EHR data can be effectively leveraged to identify rare complications of pandemic diseases and their variation over time. Funding: None