Subject: Data Model for an Outpatients Medical Center


Note that we have marked Entries in bold to help us create the Data Model.

Subject: Outpatient GI Center
Question: I need your help in putting together a Data Model.

Here is the scenario: The Physicians� GI Center (PGIC) is an outpatient facility in which participating
physicians can perform colonoscopies, sigmoidoscopies, endoscopies and similar procedures.

Participating physicians are independent practitioners who schedule and perform their patients� procedures
using the PGIC staff and facilities.

Gastroenterologists who wish to use deep anesthesia for a procedure may also arrange for an outside
anesthesiologist to be present.

PGIC staff include administrative personnel, prep nurses, OR nurses, recovery nurses and facilities
maintenance staff.

PGIC has no physicians on staff.

Patients are scheduled for appointments with appointment lengths set by the number and types of procedures
to be performed with the appointment broken into check-in, preparation, procedure, and recovery phases.

Procedures are performed in a limited number of procedure rooms while prep and recovery take placed in
curtained areas of two large rooms (one each for prep and recovery).

Sufficient space is available in each of these large rooms that scheduling individual beds is not needed
though patients are tracked by which bed they actually use for each phase.

Procedure rooms are scheduled in advance.

All transitions are logged.

Transitions are arrival/check-in, beginning prep, move to procedure room, procedure completion/move to recovery,
and discharge.

Temperature, pulse and blood pressure are recorded multiple times during the patient�s stay.

Medical records of the procedures are kept by the gastroenterologist (MD) and are not the business of PGIC.

PGIC schedules staff for prep and recovery and one nurse for each room in use on a particular day.

Most patients have insurance and PGIC collects payments from patients for copays at check-in and receives payments
from insurers following procedures.