[Gnumed-devel] Idea for Demographics "Web of care" tab

[Jim Busser]

The kinds of things not yet easily tracked in GNUmed include

- the organizations at which a patient may get care

        pharmacies
        path labs
        other orgs / facilities

- the providers / clinicians from whom the patients may get care…

        doctors (general physicians)
        specialists
        subspecialists

        non-doctors e.g.
        physiotherapists
        psychologists

**************************************************************************************
I was thinking that it might be a helpful design to create a Web of care tab and

- move (within Demographics)

        in-praxis primary --> Web of care

- add (within Web of care)

        additional in-praxis support
        - e.g. to designate an absence-covering doctor
        (this would be global, across the praxis
                and so perhaps columns in the staff table)

        org support

        provider support

In the sketch below, not all associated records would be shown in every case. 
If a user clicked Organization then only those records which were organizations 
would show, and the most helpful columns to display would be the

        org name
        org branch name
        address
        comment

whereas a click on Disciplines or Names would list the same content (just 
providers) but the click would determine the column sequence and the sort 
order. Among providers, it is possible that the patient
        - continues to see them ("Active")
                --> maybe needing to be communicated-with
        - or, no longer sees them ("Inactive")
        - or -- if needing a re-assessment --
                --> would better, in cases of past "Conflict", see a new 
provider

whichever "kind" of row that it is, I would suggest that

1) a double-click would display the full available reference information
        e.g. phone numbers

2) privacy considerations should cause regular staff Demographics to be 
filtered so as to not display is_confidential items for example sexual or 
mental health relationships

We already have in the schema

        dem

a set of "org" tables but we maybe need in schema "ref" a "provider" or 
"providers" table ? Simplest would be a table whose records were 
non-normalized, for example permitting the doctor to have a row per address 
(where they maintained more than one office location). A more-normalized design 
might better allow the providers table to link to

        ref.disciplines

which might allow each provider to be linked to more than one skill area, for 
example among Cardiologists some may specialize in Congenital heart disease, 
others in Dysrhythmias and among General surgeons, some (but not all) may do 
laparoscopic adrenalectomy.

I agree that we would not normally copy these individuals into

        identity
        names

unless we would be wanting to add information not contained in the reference 
data (for example, the provider's cel phone number, if trusted to us)

-- Jim

GNUmed Web of care tab.pdf
Description: Adobe PDF document