Skip to main content
Proceedings of the AMIA Annual Fall Symposium logoLink to Proceedings of the AMIA Annual Fall Symposium
. 1997:22–26.

Generic database design for patient management information.

S B Johnson 1, T Paul 1, A Khenina 1
PMCID: PMC2233478  PMID: 9357581

Abstract

Patient management information tracks general facts about the location of the patient and the providers assigned to care for the patient. The Clinical Data Repository at Columbia Presbyterian Medical Center employs a generic schema to record patient management events. The schema is extremely simple, yet can support several different views of patient information, as required by different applications: a longitudinal view of patient visits, including both inpatient and outpatient encounters; a visit-oriented view, to record facts related to a current encounter; a location-based view to provide a census of a nursing ward; and a provider-based view to give a list of the patients currently being cared for by a given clinician. All of these views can be supported in a highly efficient manner by the use of appropriate indexes.

Full text

PDF
22

Selected References

These references are in PubMed. This may not be the complete list of references from this article.

  1. Dolin R. H. A high-level object-oriented model for representing relationships in an electronic medical record. Proc Annu Symp Comput Appl Med Care. 1994:514–518. [PMC free article] [PubMed] [Google Scholar]

Articles from Proceedings of the AMIA Annual Fall Symposium are provided here courtesy of American Medical Informatics Association

RESOURCES