Re: [Gnumed-devel] How within GNUmed to use coding e.g. capturing the fact and state of current pregnancies (?)

[Karsten Hilbert]

On Sun, Sep 25, 2011 at 05:26:22PM -0700, Jim Busser wrote:

> I seem to recall some discussion of being able to use only
> a single coding system (at any one time) within any one
> GNUmed praxis?

No.

> So far in v16 database, I have found the appended.
> 
> Questions arising:
> 
> 1. At the moment (ATM), searching within the Notes plugin
> (field Purpose Codes) will search only among LOINC but I
> cannot tell if that is because it is only the LOINC which
> have been pre-loaded into my GNUmed

yes

> or whether --- even after I might import ICD9 or ICD10 ---
> only one coding system will be searched, and how related
> settings or configuration should be done in GNUmed.

Making the Purpose code search in LOINC only would be
exceptionally stupid.

> 2. For the table ref.coding_system_root, do the non-null
> values (and even the .comment value) get created
> automatically (i.e. do they auto-propagate) as a consequence
> of creating any rows in any inheriting tables (ICD9 etc)?

yes

> 3. When (in future) building queries to look for various
> patients characterized by various codes, is there any
> importance (or even value) to incorporating columns from the
> root table into the queries?

That depends on what the query is to return.

> 4. In the course of developing 'data packs' to import /
> create rows into (say) ICD9 or ICD10, is it sufficient to
> check existence of codes inside the respective tables or is
> there a need to reference the root table in the data pack
> queries?

The latter.

Karsten
-- 
GPG key ID E4071346 @ gpg-keyserver.de
E167 67FD A291 2BEA 73BD  4537 78B9 A9F9 E407 1346