Changes between Version 5 and Version 6 of i2b2 Data Import Pathology Procedure v2


Ignore:
Timestamp:
04/11/13 14:20:07 (11 years ago)
Author:
Richard Bramley
Comment:

--

Legend:

Unmodified
Added
Removed
Modified

  • i2b2 Data Import Pathology Procedure v2

    v5 v6  
    3232The package contains the following steps:
    3333
    34 1 Recreate Ontology in the i2b2 meta database.
    35  1 Delete existing ontology records in the PATHOLOGY table.
    36  1 Insert the new ontology hierarchy records created from the PathologyCodes table and PathologyHierarchyRecursed view in the i2b2ClinDataIntegration database into the PATHOLOGY table of the i2b2 meta database.
    37 1 Recreate the concept codes in the i2b2 data database.
    38  1 Delete existing concept records from the concept_dimension table in i2b2 data database.
    39  1 Isert the new concept records created from the PathologyCodes table and PathologyHierarchyRecursed view in the i2b2ClinDataIntegration database into the concept_dimension table of the i2b2 meta database.
     341. Recreate Ontology in the i2b2 meta database.
     35 1. Delete existing ontology records in the PATHOLOGY table.
     36 1. Insert the new ontology hierarchy records created from the PathologyCodes table and PathologyHierarchyRecursed view in the i2b2ClinDataIntegration database into the PATHOLOGY table of the i2b2 meta database.
     371. Recreate the concept codes in the i2b2 data database.
     38 1. Delete existing concept records from the concept_dimension table in i2b2 data database.
     39 1. Insert the new concept records created from the PathologyCodes table and PathologyHierarchyRecursed view in the i2b2ClinDataIntegration database into the concept_dimension table of the i2b2 meta database.
    4040