Modelo dimensional de servicios asistenciales para Dependencias de Salud de Universidades Públicas

Abstract

Introduction: Most public higher education institutions in Colombia offer healthcare services to students through a dependency, which needs to characterize the population, relying on databases, to generate welfare policies. However, most of them do not have a repository that integrates information from healthcare services, allows analyzing the data, and generates programs of promotion and prevention in accordance with the characteristics of the population.

Objective: Propose a trio of dimensional models for healthcare services in general medicine, dentistry and psychology, specifying the identified design techniques.

Method: In the elaboration of the dimensional models and the data warehouse prototype, the methodology for the development of data warehouses for small and medium-sized enterprises was used, bearing in mind that it is aimed at small workgroups and the use of few roles and artifacts.

Results: The evaluation of Utility based on the ISO/IEC 25022 standard that was carried out on the prototype of the data warehouse for the general medicine service of the Universidad del Cauca, it showed that the degree of user satisfaction was Very satisfactory.

Conclusions: The proposed dimensional models allow obtaining statistics requested by government entities, which is described in the design techniques identified, allowing these models to be adapted in the design of similar health services in public universities in the country.