[Top][All Lists]

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

[Gnumed-devel] Orgs and providers was Re: GNUmed status 0.9.6 going forw

From: Jim Busser
Subject: [Gnumed-devel] Orgs and providers was Re: GNUmed status 0.9.6 going forward
Date: Wed, 29 Jun 2011 17:57:56 -0700

On 2011-06-29, at 2:19 PM, Karsten Hilbert wrote:

Org handling is one of the two things I would like to
sufficiently finish for the next release. The other is data

add support to designate the out-of-praxis providers

other general practitioners
(say the patient lives in 2 places)

Needs orgs.

I would like us to define a table


Following is a comma-limited set of columns sourced for doctor information in BC.CA:


We can see that the above is non-normalized, providing per-doctor for
- multiple (up to 5) specialty statuses and
- multiple (up to 3) full "locations" (complete address, phone, fax)

So… should


adopt a similar (non-normalized) structure? Or would we fold it back on itself and instead:

- repeat one provider possibly multiple (up to 3 times) when they have more than one location, making each unique on
external_org_id + external_id_code + Address line 1 (Addr1)

but normalizing-out the qualifications?

- or normalizing out the address and phone channels?

-- Jim

reply via email to

[Prev in Thread] Current Thread [Next in Thread]