Changes between Version 2 and Version 3 of DataIntegration GENVASC Primary Care Data to GENVASC i2b2


Ignore:
Timestamp:
11/03/15 11:29:56 (10 years ago)
Author:
Richard Bramley
Comment:

--

Legend:

Unmodified
Added
Removed
Modified

  • DataIntegration GENVASC Primary Care Data to GENVASC i2b2

    v2 v3  
    1 = DataIntegration GENVASC Primary Care Data to GENVASC i2b2
     1= DataIntegration GENVASC CiviCRM to GENVASC i2b2
    22
    33Tags: [[DataIntegrationJob]]   
    … …  
    77- **Destination**: [[DataIntegration Destination GENVASC i2b2]]
    88- **Class**: [[DataIntegrationClass GEM Primary Care to i2b2]]
    9 - **Technology**: [[i2b2 Mapped Importer]]
     9- **Technology**: [[SSIS]]
     10
     11== Status
     12
     13- **First Import**: March 2014
     14- **Last Import**: June 2014
     15- **Data Points**: 557118
     16
     17== Data Requested
     18
     19- **Number of Participants**: 12973
     20- **Number of Codes**: 36500 (Including duplicates and different formats)
     21- **SystemOne**: Read CTV3
     22- **EMIS**: Read v2
     23
     24=== Categories
     25
     26==== QRisk Score and Parameters
     27
     28- **QRisk & Framingham Scores**: Requested
     29- **Health Check Template**: Requested
     30- **ClinRisk QRisk parameters**: Requested (originally Read v2, also translated into Read CTV3)
     31
     32==== Outcomes
     33
     34- **Disorder of Kidney**: Requested (orginally Read CTV3, also translated into Read v2)
     35- **Disorder of Glucose Regulation**: Requested (orginally Read CTV3, also translated into Read v2)
     36- **Cardiovascular Disorder**: Requested (orginally Read CTV3, also translated into Read v2)
     37- **Death Indicator**: Requested
     38
     39==== Prescribing
     40
     41- **Read CTV3: Drug groups primarily affecting the cardiovascular system**: Requested
     42- **Dictionary of Medicines and Devices / Snomed (DM+D) - All codes in 'Cardiovascular drug (product)'**: Requested
     43- **Read v2 Drug and Appliance Dictionary (DAAD) - 'Cardiovascular drugs'**: Requested
     44- **ATC**: Requested (translated from DAAD)
     45- **BNF**: Requested (translated from DAAD)
     46
     47
     48== Data Flow
     49
     50=== Participants
     51
     52==== Data
     53
     541. NHS Number
     551. Date of Birth (needs adding for validation)
     56
     57==== Step 1
     58
     59 Source DB:: [[DataIntegration Source GENVASC i2b2]]
     60 Source Tables:: {{{Participant_Mapping}}} {{{Observation_Fact}}}
     61 Destination DB:: [[DataIntegration Destination UHL DWBRICCS]]
     62 Destination Table:: {{{I2B2_Project_Patients}}}
     63
     64==== Step 2
     65
     66 Source DB:: [[DataIntegration Source UHL DWBRICCS]]
     67 Source Table:: {{{UVW_GENVASC_PATIENTS_GEM}}}
     68 Destination DB:: [[DataIntegration Destination UHL-GEM Shared Database]]
     69 Destination Table:: {{{UHLDBSQLCORP02.LLR_CSS.dbo.BRICCS_GENVASC_PATIENTS}}}
     70
     71=== Requested Codes
     72
     73==== Data
     74
     751. Code
     761. Coding System
     771. Description
     78
     79==== Step 1
     80
     81 Source DB:: [[DataIntegration Source i2b2ClinIntegration]]
     82 Source Tables:: {{{OntologyCode}}} {{{GenvascGemRequestedPrescibingCodes}}}
     83 Destination DB:: [[DataIntegration Destination UHL DWBRICCS]]
     84 Destination Table:: {{{Genvasc_GEM_Requested_Codes}}}
     85
     86==== Step 2
     87 Source DB:: [[DataIntegration Source UHL DWBRICCS]]
     88 Source Table:: {{{Genvasc_GEM_Requested_Codes}}}
     89 Destination DB:: [[DataIntegration Destination UHL-GEM Shared Database]]
     90 Destination Table:: {{{UHLDBSQLCORP02.LLR_CSS.Genvasc_GEM_Requested_Codes}}}
     91
     92=== Primary Care Data
     93
     94==== Data
     95
     961. NHS Number
     971. Code
     981. Coding System (needs adding)
     991. Event Date
     1001. Value
     1011. Units
     102
     103==== Step 1
     104
     105 Source DB:: [[DataIntegration Source UHL-GEM Shared Database]]
     106 Source Table:: {{{UHLDBSQLCORP02.LLR_CSS.dbo.Genvasc_Clinical_ReadCode}}}
     107 Destination DB:: [[DataIntegration Destination UHL DWBRICCS]]
     108 Destination Table:: {{{Genvasc_Clinical_ReadCode}}}
     109
     110==== Step 2
     111 Source DB:: [[DataIntegration Source UHL DWBRICCS]]
     112 Source Table:: {{{Genvasc_Clinical_ReadCode}}}
     113 Destination DB:: [[DataIntegration Destination GENVASC i2b2]]
     114 Destination Table:: {{{Observation_Fact}}}
     115
    10116
    11117[[BackLinks]]