Changes between Version 5 and Version 6 of i2b2 - UHL clinical informatics system integration PATS v2

Timestamp:

09/29/16 10:50:08 (8 years ago)

Author:

dan.lawday

Comment:

--

i2b2 - UHL clinical informatics system integration PATS v2

@@ -43 +43 @@
 \\ \\**Step 3.** 
 \\Find the @OntologyID using SELECT * FROM [i2b2ClinDataIntegration].[dbo].[Ontology]
-\\ Find @ParentID using SELECT *  FROM [i2b2ClinDataIntegration].[dbo].[OntologyCode]
-  where OntologyID = ## and [OntologyNodeTypeCode] = 'c'
-  order by [Name]
+\\ Find @ParentID using
+\\
+  SELECT *  FROM [i2b2ClinDataIntegration].[dbo].[!OntologyCode] \\where OntologyID = ## and [!OntologyNodeTypeCode] = 'c' \\ order by [Name]
 \\@Name, what ever you think is a better, more obvious name than the one given 
 \\@!SourceSystem, you'll find this in the proc [CBRU_ETL_CreateObservations_DWPATS_XXXXXXX] that you have just created.
-\\and the @!SourceCode is the FieldName again found in the proc you have just created.
+\\ and finally the @!SourceCode is the !FieldName again found in the proc you have just created.
 
 \\ \\**Step 4.** As per summary.