#267: CDM V3 Vitals.Smoking History compliance
-----------------------------------+----------------------------
Reporter: campbell | Owner: mprittie
Type: design-issue | Status: reopened
Priority: major | Milestone: data-domains3
Component: data-stds | Resolution:
Keywords: Smoking history DM V3 | Blocked By:
Blocking: 263, 486 |
-----------------------------------+----------------------------
Comment (by mprittie):
Here are some counts run against `TEMP_TOBACCO_L3`, which is the `VITAL`
table without the `TOBACCO_TYPE` column. These count are similar to the
case statements used to generate/populate the `TOBACCO_TYPE` column.
|| **Query** || **Description** || **Count** ||
|| select count(*) from TEMP_TOBACCO_L3 where tobacco in ('02','03','04')
and smoking in ('03','04'); || no tobacco* / no smoking || 1788629 ||
|| select count(*) from TEMP_TOBACCO_L3 where tobacco in ('02','03','04')
and smoking in ('01','02','07','08'); || no tobacco* / smoking || 291614
||
|| select count(*) from TEMP_TOBACCO_L3 where tobacco in ('01') and
smoking in ('03','04'); || tobacco* / no smoking || 29550 ||
|| select count(*) from TEMP_TOBACCO_L3 where tobacco in ('01') and
smoking in ('01','02','07','08'); || tobacco* / smoking || 9747 ||
***** "tobacco" appears to mean non-smoking tobacco use.
--
Ticket URL:
<http://informatics.gpcnetwork.org/trac/Project/ticket/267#comment:22>
gpc-informatics <http://informatics.gpcnetwork.org/>
Greater Plains Network - Informatics
_______________________________________________
Gpc-dev mailing list
Gpc-dev@listserv.kumc.edu
http://listserv.kumc.edu/mailman/listinfo/gpc-dev
