...
- rxnorm_merge: RXCUI Merges
- Same as nci_merge but with RXNORM
- 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
Code Block 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
Code Block -- 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
...