Changes between Version 20 and Version 21 of i2b2 HowTo Create an Ontology


Ignore:
Timestamp:
06/12/19 11:08:12 (5 years ago)
Author:
dan.lawday
Comment:

--

Legend:

Unmodified
Added
Removed
Modified
  • i2b2 HowTo Create an Ontology

    v20 v21  
    1414  - `@OntologyDescription` is a short description of the ontology, e.g., 'EMIS Primary Care Data from GEM'
    15153. Create records in the table `OntologyUsage` in the `i2b2ClinDataIntegration` database for each study that will use the ontology.  The `StudyName` is the unique portion of the i2b2 database names, for example `i2b2_app03_{studyName}_data`.
    16 4. Run the command `EXECUTE [i2b2ClinDataIntegration].[dbo].[UpdateOntologyConceptCodes];`
    17 5. and finally and very importantly add the ontology to the **!OntologyUsage** table (''you mean, like what step 3 tells you to do?'')
     164. Run the command   `EXECUTE [i2b2ClinDataIntegration].[dbo].[dbo.UpdateOntologyConceptCodesInStudy] @StudyName='GENVASC', @Ontology=##;`[[BR]] Or update the whole lot however that take around 20 minute, which can be done with `EXECUTE [i2b2ClinDataIntegration].[dbo].[UpdateOntologyConceptCodes];`
     17
    1818
    1919[[BackLinks]]