Add DDL for concept tables to Vocab download package?

[donohara]

Can we add the DDL for the concept tables to the download zip file, so that the file is self-describing?. I downloaded the latest vocabulary data, and found out that my DDL for DRUG_STRENGTH was missing the new field just added (box_size), and that the VOCABULARY file does not contain the vocabulary_category field.

I can check the column headers of the data files, but having the DDL or some description of the tables would let me check for differences upfront (since I didn’t keep up with the latest notices about table changes on the forum).

Thanks,
Don

[Vimala_Jacob]

Hello,

I think that Don’s suggestion is a really good idea as that would allow for consistency across the DDL and the vocabulary content.

We encountered the exact same scenario as Don. Recently we had requested for vocabulary content from the ATHENA website and noticed that the “drug_strength” csv file contained an extra column “box_size”. However the SQL script we had used to create the table did not include that column. So I would like to know how do implementers check for a given version of the SQL scripts, what is the corresponding vocabulary content?

When we setup our OMOP databases, we would like to lock in a particular version of both sets of files. This would enable consistent restoration of the entire OMOP database, both in terms of structure and vocabulary content.

Regards,
Vimala