Changes between Version 2 and Version 3 of i2b2 Data Import Pathology Procedure v2


Ignore:
Timestamp:
04/10/13 15:56:33 (12 years ago)
Author:
Richard Bramley
Comment:

--

Legend:

Unmodified
Added
Removed
Modified

  • i2b2 Data Import Pathology Procedure v2

    v2 v3  
    771. Move the SSIS packages onto the BRICCS SQL Server so that we can control their running and updating.
    881. Be configurable so that the source and destination databases can be changed more easily.
     9
     10= Implementation
     11
     12Version 2 of the i2b2 pathology data integration load is written as the SQL Server Integration Services (SSIS) packages i2b2ImportPathologyObservations.dtsx and i2b2BuildPathologyOntoloy.dtsx.  The mapping, ontology and logging data is stored in the i2b2ClinDataIntegration database on the UHLSQLBRICCSDB\UHLBRICCSDB server.
     13
     14== i2b2ClinDataIntegration Database
     15
     16The database contains the following tables used by the two pathology integration packages:
     17
     18||= Table =||= Description =||
     19||  PathologyHierarchy  || The hierarchy nodes used to build the tree structure in the pathology ontology ||
     20||  PathologyCodes  || The relevant LOINC codes used in the pathology ontology, linked to their place in the hierarchy ||
     21||  PathologyMapping  || The mapping of LOINC codes to iLab codes.  Each LOINC code can be mapped to more than one iLab code, but each iLab Code can only be mapped to one LOINC code. ||
     22||  ETLHistory  || Log file showing when each job was last run for each destination database. ||
     23||  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. ||
     24