what is concept_numeric table and where is it established?

[tfalcs]

@rtmill and @mgurley ,

I"m working my way through the sql server etl and encountering an issue with the presence of the table 'concept_numeric'. I don't see a create table clause for this table in the etl; nor do I see this table in any other ohdsi omop db. Any help on what this table is doing and how to populate it would be appreciated.

https://github.com/OHDSI/OncologyWG/blob/06b9da6cde36dbac626148323ad4ee181e032167/etl/naaccr_etl_sqlserver.sql#L1201

[rtmill]

Hi @tfalcs

You need to go through the "installation process" to both create and populate that table.

Documentation here: https://ohdsi.github.io/OncologyWG/installation.html#Step_2:_Compile_the_Oncology_CDM_Extension_Tables

[rtmill]

Some other quick notes:

• you likely only need to "install" that specific extension table unless your measurement/observation tables are legacy
• the ethos of the concept_numeric table is to deal with... troublesome tumor dimension representations, specifically from NAACCR, where the value can either be a specific numeric value or a categorical, and chaotic, representation. Here's an example: https://athena.ohdsi.org/search-terms/terms/35922280
• I'm not sure if the concept_numeric table is likely to be used anywhere outside of the NAACCR ETL and/or if we even plan to try and make it part of the standard OMOP DDL