DataIntegration GENVASC CiviCRM to GENVASC i2b2

Tags: DataIntegrationJob

• Status: StatusPartial
• Source: DataSource GEM Primary Care
• Destination: DataIntegration Destination GENVASC i2b2
• Class: DataIntegrationClass GEM Primary Care to i2b2
• Technology: SSIS

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
2. 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
2. Coding System
3. 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
2. Code
3. Coding System (needs adding)
4. Event Date
5. Value
6. 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

Error: Macro BackLinks(None) failed

'Environment' object has no attribute 'get_db_cnx'