Changes between Version 9 and Version 10 of i2b2 HowTo Create an Ontology

Timestamp:

07/22/14 16:12:14 (10 years ago)

Author:

Richard Bramley

Comment:

--

i2b2 HowTo Create an Ontology

@@ -126 +126 @@
                 @DataDatabaseName VARCHAR(50) -- The name of the Data Database in which to create the Ontology, e.g. 'i2b2_b1_data'
                 
-SET @OntologyName = 'PrimaryCareData' -- Must not contain spaces
-SET @Prefix = 'PCD'
-SET @OntologyDescription = 'Primary Care Data from GEM'
-SET @OntologyBaseNode = 'PrimaryCareData'
+SET @OntologyName = 'EMISPrimaryCareData' -- Must not contain spaces
+SET @Prefix = 'EMISPCD'
+SET @OntologyDescription = 'EMIS Primary Care Data from GEM'
+SET @OntologyBaseNode = 'EMISPrimaryCareData'
 SET @SourceSystem = 'Gem Risk Stratification'
 SET @MetaDatabaseName = 'i2b2_app03_genvasc_MetaData'
@@ -178 +178 @@
 
 SET @UpgradeOntology1_6A = '
+   USE ' + @MetaDatabaseName + '; 
+
     ALTER TABLE ' + @OntologyName + '
         ADD m_applied_path varchar(700) NULL
@@ -196 +198 @@
 
 SET @UpgradeOntology1_6B = '
+   USE ' + @MetaDatabaseName + '; 
+
     UPDATE ' + @OntologyName + '
     SET m_applied_path = ''@''