#235: insufficient data to exclude prior cancer diagnoses
-------------------------------------------------+-------------------------
Reporter: bchrischilles | Owner: tmcmahon
Type: problem | Status: new
Priority: major | Milestone: bc-survey-
Component: data-stds | cohort-def
Keywords: data-quality breast-cancer-cohort | Resolution:
bc-research-team | Blocked By: 204
Blocking: 227 |
-------------------------------------------------+-------------------------
Comment (by dconnolly):
Phillip R. points out that 0380 is missing from EXTRACT_EAV.
Indeed, the HERON code seem to "eat" the 0380 data, treating it as an
internal uniqueness key rather than a data element. :-/
Phillip suggests adding the following to the EXTRACT_EAV:
{{{
union all
select "Accession Number--Hosp", "Sequence Number--Hospital",
560 as ItemNbr,
'Sequence Number--Hospital' as ItemName,
"Sequence Number--Hospital" as value
from "NAACCR"."EXTRACT"
}}}
That will work, but that code is generated; the original culprit is in
`heron_staging/naaccr_explore.py`:
{{{
def eav_view_ddl(spec, table, view, schema):
yield 'create or replace view "%s"."%s" as \n' % (schema, view)
for item in spec:
if (item.length < 1
or item.name in ('Accession Number--Hosp',
'Sequence Number--Hospital')
or not item.num):
continue
}}}
--
Ticket URL:
<http://informatics.gpcnetwork.org/trac/Project/ticket/235#comment:2>
gpc-informatics <http://informatics.gpcnetwork.org/>
Greater Plains Network - Informatics
_______________________________________________
Gpc-dev mailing list
[email protected]
http://listserv.kumc.edu/mailman/listinfo/gpc-dev
