Changes between Version 1 and Version 2 of i2b2 HowTo Create an Ontology

Timestamp:

07/19/13 13:58:53 (11 years ago)

Author:

Richard Bramley

Comment:

--

i2b2 HowTo Create an Ontology

@@ -60 +60 @@
 }}}
 
+4. Create ontology hierarchy and Concept codes
 
+This is beyond the scope of this page.  In order to stop the UI from giving an error when you click on the root note, you can create the root node in the ontology table.
+
+{{{#!sql
+
+INSERT INTO {Ontology Name from [1]}
+           ([C_HLEVEL]
+           ,[C_FULLNAME]
+           ,[C_NAME]
+           ,[C_SYNONYM_CD]
+           ,[C_VISUALATTRIBUTES]
+           ,[C_TOTALNUM]
+           ,[C_BASECODE]
+           ,[C_METADATAXML]
+           ,[C_FACTTABLECOLUMN]
+           ,[C_TABLENAME]
+           ,[C_COLUMNNAME]
+           ,[C_COLUMNDATATYPE]
+           ,[C_OPERATOR]
+           ,[C_DIMCODE]
+           ,[C_COMMENT]
+           ,[C_TOOLTIP]
+           ,[UPDATE_DATE]
+           ,[DOWNLOAD_DATE]
+           ,[IMPORT_DATE]
+           ,[SOURCESYSTEM_CD]
+           ,[VALUETYPE_CD])
+     VALUES
+           (0
+           ,'{Base path for ontology [4]}'
+           ,'{Descriptive name for ontology [3]}'
+           ,'N'
+           ,'CA'
+           ,NULL
+           ,NULL
+           ,NULL
+           ,'concept_cd'
+           ,'concept_dimension'
+           ,'concept_path'
+           ,'N'
+           ,'LIKE'
+           ,'{Base path for ontology [4]}'
+           ,NULL
+           ,'{Descriptive name for ontology [3]}'
+           ,GETDATE()
+           ,NULL
+           ,NULL
+           ,'{A suitable source perhaps Ontology description from [3]}'
+           ,NULL)
+GO
+
+}}}