Changes between Version 12 and Version 13 of i2b2 HowTo Upgrade to Version 1.6

Timestamp:

08/28/13 10:17:29 (11 years ago)

Author:

Richard Bramley

Comment:

--

i2b2 HowTo Upgrade to Version 1.6

@@ -74 +74 @@
 14. Copy the file {{{i2b2_config_data.js}}} from the backed up web client folder to the new web client folder.
 15. Copy plugins from the backed up web client folder to the new web client folder.
+16. Because modifiers are now being used, the Instance_Num column of the Observation_Fact table becomes very important.  Therefore we need to create instance numbers for observation facts that didn't have them before using this script:
+
+{{{#!sql
+BEGIN TRANSACTION
+
+UPDATE o
+SET INSTANCE_NUM = a.rnum
+FROM Observation_Fact o
+JOIN (
+        SELECT  row_number() OVER(PARTITION BY encounter_num, patient_num, concept_cd, provider_id, start_date, modifier_cd ORDER BY encounter_num, patient_num, concept_cd, provider_id, start_date, modifier_cd ) as rnum,
+                        obf.*
+        FROM    Observation_Fact obf
+        ) a ON  a.Encounter_Num = o.Encounter_Num
+                AND a.Concept_Cd = o.Concept_Cd
+                AND a.Provider_Id = o.Provider_Id
+                AND a.Start_Date = o.Start_Date
+                AND     a.Modifier_Cd = o.Modifier_Cd
+
+-- COMMIT
+}}}