| Version 3 (modified by , 9 years ago) ( diff ) |
|---|
DataIntegration GENVASC CiviCRM to GENVASC i2b2
Tags: DataIntegrationJob
- Status: DataIntegration Status Partial
- Source: DataIntegration Source 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
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
- NHS Number
- Date of Birth (needs adding for validation)
Step 1
- Source DB
- DataIntegration Source GENVASC i2b2
- Source Tables
Participant_MappingObservation_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
- Code
- Coding System
- Description
Step 1
- Source DB
- DataIntegration Source i2b2ClinIntegration
- Source Tables
OntologyCodeGenvascGemRequestedPrescibingCodes- 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
- NHS Number
- Code
- Coding System (needs adding)
- Event Date
- Value
- 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
Note:
See TracWiki
for help on using the wiki.
