NIH BTRIS warehouse has data on participants in the ClinSeq study. So we have some experience with designing a Cognos prompt page for a genomic report, having a data model, and responding to users of the query page.
We only planned to put yes/no flag to the OMOP CDM structure.
I requested SNOMED CT procedural code for ‘exome sequencing’ (so that I can record yes/no flag) in procedures_occurence. They rejected the request and deferred me to request it from LOINC. 
(so the LOINC request is filed and pending getting into LOINC. SNOMED CT has nice concept request tracking with link, but LOINC does not have a similar feature))
See the details here:
https://uscrs.nlm.nih.gov/request/newconcept/view.xhtml?id=271026&returnUrl=%2Frequest%2FsearchRequests.xhtml (link may require UMLS login)
old link to video demo of our query prompt is in this 2 year old post now