Re: [Gnumed-devel] Problems pulling soap note rows via placeholders

[Karsten Hilbert]

On Mon, Aug 26, 2013 at 11:36:29PM +0000, Jim Busser wrote:

> and so I can imagine that my placeholder needed to start with (e.g.)
> 
>       $<soap_by_issue::soapu//%d %b %Y//

That's right.

> but I am unclear on how to finish it … it still needs <template> and then >$
> 
> Therefore …
> 
> 1) can an example be provided of what a relatively fully-formatted 
> $<soap_by_issue …>$ might look like?

The gmMacro.py contains examples at the bottom (within the
test code). Many of them work.

        $<soap_by_issue::soapu //%Y %b %d//%(narrative)s::1000>$
        $<soap_by_episode::soapu //%Y %b %d//%(narrative)s::1000>$

> 2) observing that the emr_journal template happened to consist of
> 
>       {\footnotesize %(date)s } & {\tiny %(modified_by)s} & {\tiny 
> %(soap_cat)s} & {\small %(narrative)s} \tabularnewline
> 
> does the above define the extent of the 'somethings' available to be 
> selected-from and included in <template>,

Not fully. soap_by_issue and soap_by_episode feed from

        gmMacro.py::__get_variant_soap_by_issue_or_episode()

which feeds from

        gmNarrativeWidgets.py::select_narrative_by_episode() (_or issue)

which feed from

        gmClinicalRecord.py::cClinicalRecord.get_clin_narrative()

which, eventually, feeds from

        clin.v_(pat)_narrative

all fields of which + .soap_rank are available.

> wherein …
> 
>       date <-- is this last modified, or clin_when?

yes

>       modified_by <-- the user (provider) who had last modified this narrative

v18: yes, called .provider
v19: likely to be renamed to .modified_by for consistency

>       soap_cat <-- the letter for the SOAP category {soapu }

yes

>       narrative <-- the soap narrative

yes

> … are there more?

                Sicht »clin.v_pat_narrative«
       Spalte        |           Typ            | Attribute 
---------------------+--------------------------+-----------
 pk_patient          | integer                  | 
 date                | timestamp with time zone | 
 provider            | text                     | 
 soap_cat            | text                     | 
 narrative           | text                     | 
 pk_item             | integer                  | 
 pk_narrative        | integer                  | 
 pk_health_issue     | integer                  | 
 pk_episode          | integer                  | 
 pk_encounter        | integer                  | 
 xmin_clin_narrative | xid                      | 
 modified_when       | timestamp with time zone | 
 row_version         | integer                  | 
 pk_generic_codes    | integer[]                | 

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