= DataIntegration GENVASC CiviCRM to GENVASC i2b2

Tags: [[DataIntegrationJob]] [[GENVASC Study]]

- **Status**: [[StatusPartial]]
- **Source**: [[DataSource GEM Primary Care]]
- **Destination**: [[DataIntegration Destination GENVASC i2b2]]
- **Class**: [[DataIntegrationClass GEM Primary Care to i2b2]]
- **Technology**: [[SSIS]]

== Contacts

=== David Pithouse
 Email:: david.pithouse@nhs.net
 Tel:: 07867 810106

== Status

- **First Import**: March 2014
- **Last Import**: June 2014
- **Data Points**: 557118

== Data Requested

- **Number of Participants**: 12973
- **Number of Codes**: 36500 (Including duplicates and different formats)
- **SystemOne**: Read CTV3
- **EMIS**: Read v2

=== Categories

 Requested Codes:: [[DataIntegration GENVASC Primary Care Data Request Codes]]

==== QRisk Score and Parameters

- **QRisk & Framingham Scores**: Requested
- **Health Check Template**: Requested
- **ClinRisk QRisk parameters**: Requested (originally Read v2, also translated into Read CTV3)

==== Outcomes

- **Disorder of Kidney**: Requested (orginally Read CTV3, also translated into Read v2)
- **Disorder of Glucose Regulation**: Requested (orginally Read CTV3, also translated into Read v2)
- **Cardiovascular Disorder**: Requested (orginally Read CTV3, also translated into Read v2)
- **Death Indicator**: Requested

==== Prescribing

- **Read CTV3: Drug groups primarily affecting the cardiovascular system**: Requested
- **Dictionary of Medicines and Devices / Snomed (DM+D) - All codes in 'Cardiovascular drug (product)'**: Requested
- **Read v2 Drug and Appliance Dictionary (DAAD) - 'Cardiovascular drugs'**: Requested
- **ATC**: Requested (translated from DAAD)
- **BNF**: Requested (translated from DAAD)


== Data Flow

=== Participants

==== Data

1. NHS Number
1. Date of Birth (needs adding for validation)

==== Step 1

 Source DB:: [[DataSource GENVASC i2b2]]
 Source Tables:: {{{Participant_Mapping}}} {{{Observation_Fact}}} 
 Destination DB:: [[DataIntegration Destination UHL DWBRICCS]]
 Destination Table:: {{{I2B2_Project_Patients}}}

==== Step 2

 Source DB:: [[DataSource UHL DWBRICCS]]
 Source Table:: {{{UVW_GENVASC_PATIENTS_GEM}}}
 Destination DB:: [[DataIntegration Destination UHL-GEM Shared Database]]
 Destination Table:: {{{UHLDBSQLCORP02.LLR_CSS.dbo.BRICCS_GENVASC_PATIENTS}}}

=== Requested Codes

==== Data

1. Code
1. Coding System
1. Description

==== Step 1

 Source DB:: [[DataSource i2b2ClinIntegration]]
 Source Tables:: {{{OntologyCode}}} {{{GenvascGemRequestedPrescibingCodes}}}
 Destination DB:: [[DataIntegration Destination UHL DWBRICCS]]
 Destination Table:: {{{Genvasc_GEM_Requested_Codes}}}

==== Step 2
 Source DB:: [[DataSource UHL DWBRICCS]]
 Source Table:: {{{Genvasc_GEM_Requested_Codes}}}
 Destination DB:: [[DataIntegration Destination UHL-GEM Shared Database]]
 Destination Table:: {{{UHLDBSQLCORP02.LLR_CSS.Genvasc_GEM_Requested_Codes}}}

=== Primary Care Data

==== Data

1. NHS Number
1. Code
1. Coding System (needs adding)
1. Event Date
1. Value
1. Units

==== Step 1

 Source DB:: [[DataSource UHL-GEM Shared Database]]
 Source Table:: {{{UHLDBSQLCORP02.LLR_CSS.dbo.Genvasc_Clinical_ReadCode}}}
 Destination DB:: [[DataIntegration Destination UHL DWBRICCS]]
 Destination Table:: {{{Genvasc_Clinical_ReadCode}}}

==== Step 2
 Source DB:: [[DataSource UHL DWBRICCS]]
 Source Table:: {{{Genvasc_Clinical_ReadCode}}}
 Destination DB:: [[DataIntegration Destination GENVASC i2b2]]
 Destination Table:: {{{Observation_Fact}}}


[[BackLinks]]