Skip to end of metadata
Go to start of metadata

You are viewing an old version of this content. View the current version.

Compare with Current View Version History

« Previous Version 10 Next »

Overview

QA Bin Definitions

Parameters :terminology (e.g. NCIMTH) and :version (e.g. latest) are allowed in the queries.\

TODO:

  1. Look up definitions of bins (e.g. logically what do they do, we'll need descriptions too
  2. Write up description
  3. Write and test query (with :terminology/:version interpolations)

REQUIRED bins

  • nci_merge: Merged SCUI current version NCI atoms

    select a.id clusterId, a.id conceptId 
from concepts a, concepts_atoms b, atoms c
where a.terminology = :terminology
  and a.id = b.concepts_id and b.atoms_id = c.id
  and c.terminology='NCI'
group by a.id having count(distinct c.conceptId)>1

  • nci_sub_split: Split SCUI current version NCI (or sub-source) atoms

    TBD: 
select a.id clusterId, a.id conceptId 
from concepts a, concepts_atoms b, atoms c
where a.terminology = :terminology
  and a.id = b.concepts_id and b.atoms_id = c.id 
  and c.terminology in (select terminology from root_terminologies where family = 'NCI' and terminology != 'NCI')
group by a.id having count(distinct c.conceptId)>1

  • sct_sepfnpt: SNOMED concept clusters where the FN and PT terms are separated

  • cdsty_coc: Find concepts with Clinical Drug STY and any other STY

    SELECT 
    c.id conceptId
FROM
    concepts c
WHERE
    c.id IN (SELECT 
            c1.id
        FROM
            concepts c1,
            concepts_semantic_type_components cs,
            semantic_type_components s
        WHERE
            c1.id = cs.concepts_id
                AND cs.semanticTypes_id = s.id
                AND s.semanticType = 'Clinical Drug')
GROUP BY c.id
HAVING COUNT(c.id) > 1;

  • multsty: concepts with more than 3 STYs|

     SELECT
    c.id
FROM
    concepts c,
    concepts_semantic_type_components cs,
    semantic_type_components s
WHERE
	c.id = cs.concepts_id AND
    cs.semanticTypes_id = s.id
GROUP BY c.id
HAVING count(c.id)>3

  • styisa: One STY is an ancestor of another in the STY isa hierarchy
     

  • sfo_lfo: Short form in one concept, long form in another
     

  • deleted_cui: CUIs that are going away - will need bequeathal rel

NON-required bins

  • rxnorm_merge: RXCUI Merges
    • Same as nci_merge but with RXNORM

  • cbo_merge: Merged SCUI current version CBO atoms
    • Same as nci_merge but with CBO
  • mdr_merge: Merged SDUI current version MDR atoms
  • pdq_merge: Merged SDUI current version PDQ atoms
  • sct_sepfnpt: SNOMED concept clusters where the FN and PT terms are separated

  • rxnorm_split: RXCUI splits

    see split query above



  • nci_pdq_merge: Concepts containing current version NCI and current version PDQ atoms

  • nci_sct_merge: Concepts containing current version NCI and current version SNOMEDCT atoms

  • ambig_no_ncimth_pn: Ambiguous concepts where at least one has no PN (sepstring)

  • ambig_no_mth_pn: Ambiguous concepts where at least one has no PN (sepstring)

  • ambig_no_rel: Ambiguous concepts where at least one pair lacks an approved REL

  • pn_pn_ambig: Identical (same SUI) PN's in multiple concepts

  • multiple_pn: Concepts with multiple MTH/PN atoms

  • pn_no_ambig: Concept has MTH/PN atom but no ambiguous string

  • ambig_pn: MTH/PN atom is ambiguous but has no matching ambiguous string

  • pn_orphan: MTH/PNs on their own

  • nosty: No STY

  • missing_sty: Reviewed concepts without releasable Semantic Types

  • cbo_chem: Current version CBO concepts with CHEM STYs

  • -- to find chemical semantic types
(select distinct semanticTypeCategoryMap sty
from projects a, ProjectJpa_semanticTypeCategoryMap b
where a.id = b.ProjectJpa_id
  and semanticTypeCategoryMap_KEY = 'chemical'
  and a.terminology = :terminology);
 
 



  • go_chem: Current version GO concepts with CHEM STYs

  • mdr_chem: Current version MDR concepts with CHEM STYs

  • true_orphan: Concepts with no releaseable relationships to any other concept

  • deleted_cui_split: Complex split/merge case CUIs that are going away - will need bequeathal

  • split_demotions: Demotions overlapping with a bad merge that was split
  • nci_pt_mrg: Merged current version NCI/PT atoms
  • mxsuppr: Concepts with identical LUI atoms that have mixed suppressibility

.~ Mixed status concepts 196 Sat Jan 7 09:19:47 2017
~ Suppressible preferred name (level 0,9) 0 Sat Jan 7 09:19:58 2017

  • No labels