Changes between Version 1 and Version 2 of i2b2 Data Import Pathology Procedure v1


Ignore:
Timestamp:
03/12/13 10:11:33 (12 years ago)
Author:
Richard Bramley
Comment:

--

Legend:

Unmodified
Added
Removed
Modified

  • i2b2 Data Import Pathology Procedure v1

    v1 v2  
    2323Runs the stored procedure USP_DWH_DELETE_PATHOLOGY_FROM_I2B2 in the i2b2ClinDataIntegration database, which deletes all pathology data from the Observation_Fact table of the destination i2b2 database.  These are identified as all records where the concept_cd begins with 'PAT:'.
    2424
    25 === 3.
     25=== 3. Insert Pathology into I2B2
     26
     27Runs the stored procedure USP_DWH_INSERT_PATHOLOGY_I2B2 in the i2b2ClinDataIntegration database, which loads data into the destination i2b2 database from the view UVW_BRICCS_PATHOLOGY_RESULTS in the DWBRICCS database on the UHL data warehouse as a linked server.