Changes between Version 2 and Version 3 of i2b2 HowTo Create Concept Codes in an Ontology

Timestamp:

08/30/16 14:39:56 (8 years ago)

Author:

dan.lawday

Comment:

--

i2b2 HowTo Create Concept Codes in an Ontology

@@ -3 +3 @@
 Once you have created an Ontology you can create the codes (which go in the concept_cd column in the facts table).
 To do this you run the following code (I'll detail the input in a mo).
+\\ \\ **execute dbo.CreateOntologyCode @OntologyID = 99, @ParentID = 7777777, @Name = 'ethnicity',@SourceSystem = 'DREAM_RedCap',@SourceCode = 'ethnicity';** \\ \\
+
+
+- @OntologyID, this is 1 for GenvascCiviCRM, 27 for Gem BRICCS REDCap, the full list can be found by using:
+SELECT *  FROM [i2b2ClinDataIntegration].[dbo].Ontology;
+
+
+- @ParentID, this needs must be a container node (top level is possible however if there is a hierarchy then don't add all the codes to the top level, instead create the child container nodes as needed and then add the codes to them).\\ Note that all the codes will be Leaf nodes, this indicates that is will be containing data and that no other codes will hang off them.
+the ParentID can be found by using the following code: 
+\\ \\ ** SELECT *  FROM [i2b2ClinDataIntegration].[dbo].OntologyCode                                    where [OntologyID] = 99;** \\ \\
+replace 99 with your ontology (49 for example is Dream).
+
+- @Name, this is what you are going to be calling the code by from now on
 \\
+- @SourceSystem
 \\
-**execute dbo.CreateOntologyCode @OntologyID = 99, @ParentID = 7777777, @Name = 'ethnicity',@SourceSystem = 'DREAM_RedCap',@SourceCode = 'ethnicity';**
-\\
-- OntologyID, this is 1 for GenvascCiviCRM, 27 for Gem BRICCS REDCap, the full list can be found by using:
-SELECT *  FROM [i2b2ClinDataIntegration].[dbo].Ontology;
-- ParentID, this needs must be a container node (top level is possible however if there is a hierarchy then don't add all the codes to the top level, instead create the child container nodes as needed and then add the codes to them).\\ Note that all the codes will be Leaf nodes, this indicates that is will be containing data and that no other codes will hang off them.
-the ParentID can be found by using the following code: \\
-SELECT *  FROM [i2b2ClinDataIntegration].[dbo].OntologyCode                                     where [OntologyID] = 99;
-replace 99 with your ontology (49 for example is Dream).
+- @SourceCode, this is what the incomming field name is in the source system database (and may not be a helpfully named field, which is why we have the @Name field which gives us a chance to change it to something better.
 
 Below is a abstract for the dream ontology as way of example:\\