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


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

--

Legend:

Unmodified
Added
Removed
Modified

  • i2b2 Data Import Pathology Procedure v2

    v4 v5  
    2323||  Failed_Observation_Fact  || Log file showing Observation_Fact records that could not be loaded into the Observation_Fact table, when they were loaded and what the error message was. ||
    2424
     25It also contains the following views
     26
     27||= View =||= Description =||
     28||  PathologyHierarchyRecursed  || Recurses the PathologyHierarchy table to produce a tree structure ||
     29
     30== i2b2BuildPathologyOntoloy SSIS Package
     31
     32The package contains the following steps:
     33
     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 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.
     40