= DataIntegration GRAPHIC2 UHLDWH Pathology Extract

Tags: [[DataIntegrationJob]]

- **Status**: [[StatusCompleted]]
- **Source**: [[DataSource UHL Data Warehouse]]
- **Destination**: `V:\GRAPHIC2\Chris Nelson\PathologyBlood_20150512.xls`
- **Class**: [[DataIntegrationClass Device Extract]]
- **Technology**: SQL (see below)
- **Study**: [[GRAPHIC2 Study]]

== To Extract the Data

1. Log into the BRICCS database on the UHLDWH server.
2. Run the stored procedure `Graphic2_RecreatePathologyFull`.  This will recreate the export table by copying data from the pathology data warehouse.  It runs the other `Graphic2...` stored procedures in the correct order.
3. The export data is then found in the table `Graphic2_PathologyMissingValues`

[[BackLinks]]