Generic database design for patient management information. Academic Article uri icon

Overview

MeSH

  • Hospital Information Systems
  • Humans
  • Outpatient Clinics, Hospital

MeSH Major

  • Databases as Topic
  • Medical Records Systems, Computerized
  • Patient Care Management

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.

publication date

  • 1997

has subject area

  • Databases as Topic
  • Hospital Information Systems
  • Humans
  • Medical Records Systems, Computerized
  • Outpatient Clinics, Hospital
  • Patient Care Management

Research

keywords

  • Journal Article

Identity

Language

  • eng

PubMed Central ID

  • PMC2233478

PubMed ID

  • 9357581

Additional Document Info

start page

  • 22

end page

  • 26