wiki:DataIntegration GENVASC Primary Care Data to GENVASC i2b2

Version 4 (modified by Richard Bramley, 9 years ago) ( diff )

--

DataIntegration GENVASC CiviCRM to GENVASC i2b2

Tags: DataIntegrationJob

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

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
DataIntegration Source GENVASC i2b2
Source Tables
Participant_Mapping Observation_Fact
Destination DB
DataIntegration Destination UHL DWBRICCS
Destination Table
I2B2_Project_Patients

Step 2

Source DB
DataIntegration Source 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
DataIntegration Source i2b2ClinIntegration
Source Tables
OntologyCode GenvascGemRequestedPrescibingCodes
Destination DB
DataIntegration Destination UHL DWBRICCS
Destination Table
Genvasc_GEM_Requested_Codes

Step 2

Source DB
DataIntegration Source 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
DataIntegration Source 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
DataIntegration Source 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'

Note: See TracWiki for help on using the wiki.