Changes between Initial Version and Version 1 of DataIntegration GRAPHIC2 UHLDWH Pathology Extract


Ignore:
Timestamp:
11/20/15 13:15:02 (8 years ago)
Author:
Richard Bramley
Comment:

--

Legend:

Unmodified
Added
Removed
Modified

  • DataIntegration GRAPHIC2 UHLDWH Pathology Extract

    v1 v1  
     1= DataIntegration GRAPHIC2 UHLDWH Pathology Extract
     2
     3Tags: [[DataIntegrationJob]]
     4
     5- **Status**: [[StatusCompleted]]
     6- **Source**: [[DataSource UHL Data Warehouse]]
     7- **Destination**: `V:\GRAPHIC2\Chris Nelson\PathologyBlood_20150512.xls`
     8- **Class**: [[DataIntegrationClass Device Extract]]
     9- **Technology**: SQL (see below)
     10- **Study**: [[GRAPHIC2 Study]]
     11
     12== To Extract the Data
     13
     141. Log into the BRICCS database on the UHLDWH server.
     152. 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.
     163. The export data is then found in the table `Graphic2_PathologyMissingValues`
     17
     18[[BackLinks]]