#155: correlating observations with encounters
----------------------------------+----------------------------
Reporter: lv | Owner: ngraham
Type: design-issue | Status: assigned
Priority: major | Milestone: data-domains3
Component: data-stds | Resolution:
Keywords: data-quality cdm-etl | Blocked By:
Blocking: 486 |
----------------------------------+----------------------------
Comment (by ngraham):
At KUMC, we got about 20% of all our encounters mapped to something other
than "UN" (unknown) using [https://github.com/njgraham/i2p-
transform/commit/b8cb0e0ae74769c7de902d970923d5143f248717 b8cb0e0].
Ref:
{{{
with all_enc as (
select count(*) qty from encounter
)
select et.enc_type, et.qty, round((et.qty/all_enc.qty) * 100, 2) pct from
(
select count(*) qty, enc_type
from encounter
group by enc_type
) et
cross join all_enc
;
}}}
--
Ticket URL:
<http://informatics.gpcnetwork.org/trac/Project/ticket/155#comment:18>
gpc-informatics <http://informatics.gpcnetwork.org/>
Greater Plains Network - Informatics
_______________________________________________
Gpc-dev mailing list
[email protected]
http://listserv.kumc.edu/mailman/listinfo/gpc-dev
