Changes between Version 13 and Version 14 of DAPS

Timestamp:

07/21/16 08:58:49 (8 years ago)

Author:

Richard Bramley

Comment:

--

DAPS

@@ -1 @@
-= DAPS (Demographics Authentication Processing System)
+= DAPS
 
 Tags: [[Lcbru Software Category]]
 
-DAPS (Digital Audit of Patients Submission) takes a sub-set of patient details and validates them against UHL PMI and the Spine [[Demographics Batch Service]]
+DAPS takes a sub-set of patient details and validates them against UHL PMI and the Spine [[Demographics Batch Service]]
 
-To submit a file for processing with DAPS (Data Analysis and Partitioning with Spine), copy a CSV file with the correct columns into the folder {{{\\uhldwh\BRICCS_DBS_IN}}}.
+To submit a file for processing with DAPS, copy a CSV file with the correct columns (see below) into the folder {{{\\uhldwh\BRICCS_DBS_IN}}}.
 
-When processing is complete DAPS (Death date, Address and Phone number Supplementation) will place 3 files for each submitted CSV in the folder {{{V:\Study specific recruitment projects\IT returned files\}}}
+When processing is complete DAPS place 4 files for each submitted CSV in the folder {{{V:\Study specific recruitment projects\IT returned files\}}}
 
 I think that the files returned from the spine are in the folder {{{\\uhlieaae01\DBSClient\Data\OUTBOX\DBS\RWE\Processed-Auto}}}.  Maybe we could process them from there!
@@ -18 +18 @@
 ||FORENAMES|| ||
 ||SURNAME|| ||
-||DOB|| ||
-||SEX|| ||
+||DOB||YYYY-MM-DD||
+||SEX||Female or Male||
 ||POSTCODE|| ||
 ||NHS_NUMBER|| ||
@@ -114 +114 @@
 
 
-== Specific Runs
-
-=== Graphic 2 Extract of S Numbers
-
-{{{#!sql
-WITH demo AS (
-SELECT 
-        [SYSTEM_NUMBER_CURRENT]
-    ,[FORENAMES]
-    ,[SURNAME]
-    ,[POSTCODE]
-    ,[GENDER]
-    ,[DATE OF BIRTH]
-    ,[BATCH_ID]
-    ,[MATCH_DEMOGRAPHIC_LEVEL]
-  FROM [DWPATMATCH].[dbo].[DBS_TRACING]
-)
-
-SELECT
-        male.FORENAMES
-        ,male.SURNAME
-        ,male.[DATE OF BIRTH]
-        ,ISNULL(postcode.POSTCODE, '') [PostCode]
-        ,ISNULL(male.SYSTEM_NUMBER_CURRENT, '') [Male_S_Number]
-        ,ISNULL(female.SYSTEM_NUMBER_CURRENT, '') [Female_S_Number]
-        ,ISNULL(postcode.SYSTEM_NUMBER_CURRENT, '') [Postcode_S_Number]
-    ,COALESCE(male.SYSTEM_NUMBER_CURRENT, female.SYSTEM_NUMBER_CURRENT, postcode.SYSTEM_NUMBER_CURRENT, '') [S Number]
-    ,CASE WHEN (male.SYSTEM_NUMBER_CURRENT <> female.SYSTEM_NUMBER_CURRENT)
-                        OR (male.SYSTEM_NUMBER_CURRENT <> postcode.SYSTEM_NUMBER_CURRENT)
-                        OR (female.SYSTEM_NUMBER_CURRENT <> postcode.SYSTEM_NUMBER_CURRENT)
-                        THEN 'Yes' ELSE '' END Mismatch
-FROM    demo male
-LEFT JOIN       demo female ON female.SURNAME = male.SURNAME
-                                                and female.FORENAMES = male.FORENAMES
-                                                and female.[DATE OF BIRTH] = male.[DATE OF BIRTH]
-                                                and female.BATCH_ID = 10930 and female.GENDER = 'f'
-LEFT JOIN       demo postcode ON postcode.SURNAME = male.SURNAME
-                                                and postcode.FORENAMES = male.FORENAMES
-                                                and postcode.[DATE OF BIRTH] = male.[DATE OF BIRTH]
-                                                and postcode.BATCH_ID = 10929
-WHERE   male.BATCH_ID = 10930 and male.GENDER = 'm'
-
-}}}
-
 [[BackLinks]]