Changes between Version 2 and Version 3 of DAPS


Ignore:
Timestamp:
08/29/13 10:25:01 (11 years ago)
Author:
Richard Bramley
Comment:

--

Legend:

Unmodified
Added
Removed
Modified

  • DAPS

    v2 v3  
    1818Main database is the DWPATMATCH database on the data warehouse server.
    1919
    20 1. Copy values from the CSV file in the !\\uhldwh\BRICCS_DBS_IN directory to the DBS_TRACING table with a batch ID
     201. Copy values from the CSV file in the !\\uhldwh\BRICCS_DBS_IN directory to the {{{DBS_TRACING}}} table with a batch ID
    2121
    2222'''The two following steps take place ''concurrently''.  I think this is an error, but it may only be the case in my (RaB) copy and not the live copy'''
    … …  
    25253. Export patient details to the file to be sent to the Spine
    2626
     27==== Patient Matching
     28
     291. Copy the values from the {{{DBS_TRACING}}} table to the {{{PMI_DEMOGRAPHICS}}} table.
     302. Run the script {{{USP_UPDATE_MATCH_FIELDS}}}.  This script runs various matching scripts if successful they update the S Number on the {{{DBS_TRACING}}} table and assign the record a matching code (the code from the start of the script name).  If all these fail, the record is given a code of '6 - NO MATCH'
     31 a. {{{USP_UPDATE_MATCH_1A_NHS_NO_MATCH_WITH_SURNAME_AND_DOB}}}
     32 a. {{{USP_UPDATE_MATCH_1A_S_NUMBER_MATCH_WITH_SURNAME_AND_DOB}}}
     33 a. {{{USP_UPDATE_MATCH_1A_IPN_MATCH_WITH_SURNAME_AND_DOB}}}
     34 a. {{{USP_UPDATE_MATCH_1B_CASENOTE_NUMBER_MATCH_WITH_SURNAME_AND_DOB}}}
     35 a. {{{USP_UPDATE_MATCH_1C_S_NUMBER_MATCH_WITH_PREV_SURNAME_AND_DOB}}}
     36 a. {{{USP_UPDATE_MATCH_1C_S_NUMBER_MATCH_WITH_PREV_SURNAME_AND_DOB}}}
     37 a. {{{USP_UPDATE_MATCH_1D_CASENOTE_NUMBER_MATCH_WITH_PREV_SURNAME_AND_DOB}}}
     38 a. {{{USP_UPDATE_MATCH_1E_NHS_NO_MATCH_DOB}}}
     39 a. {{{USP_UPDATE_MATCH_2A_S_NUMBER_MATCH_WITH_SURNAME_AND_YEAR_OF_BIRTH}}}
     40 a. {{{USP_UPDATE_MATCH_2A_IPN_MATCH_WITH_SURNAME_AND_YEAR_OF_BIRTH}}}
     41 a. {{{USP_UPDATE_MATCH_2B_S_NUMBER_MATCH_WITH_DOB_AND_FIRST_3_CHAR_OF_SURNAME}}}
     42 a. {{{USP_UPDATE_MATCH_2B_S_NUMBER_MATCH_WITH_DOB_AND_FIRST_3_CHAR_OF_SURNAME}}}
     43 a. {{{USP_UPDATE_MATCH_2C_CASENOTE_NUMBER_MATCH_WITH_SURNAME_AND_YEAR_OF_BIRTH}}}
     44 a. {{{USP_UPDATE_MATCH_2D_CASENOTE_NUMBER_MATCH_WITH_DOB_AND_FIRST_3_CHAR_OF_SURNAME}}}
     45 a. {{{USP_UPDATE_MATCH_2E_S_NUMBER_MATCH_WITH_PREV_SURNAME_AND_YEAR_OF_BIRTH}}}
     46 a. {{{USP_UPDATE_MATCH_2E_IPN_MATCH_WITH_PREV_SURNAME_AND_YEAR_OF_BIRTH}}}
     47 a. {{{USP_UPDATE_MATCH_2F_CASENOTE_NUMBER_MATCH_WITH_PREV_SURNAME_AND_YEAR_OF_BIRTH}}}
     48 a. {{{USP_UPDATE_MATCH_3A_S_NUMBER_MATCH_WITH_SURNAME}}}
     49 a. {{{USP_UPDATE_MATCH_3A_IPN_MATCH_WITH_SURNAME}}}
     50 a. {{{USP_UPDATE_MATCH_3B_S_NUMBER_MATCH_WITH_DOB}}}
     51 a. {{{USP_UPDATE_MATCH_3B_IPN_MATCH_WITH_DOB}}}
     52 a. {{{USP_UPDATE_MATCH_3C_CASENOTE_NUMBER_MATCH_WITH_SURNAME}}}
     53 a. {{{USP_UPDATE_MATCH_3D_CASENOTE_NUMBER_MATCH_WITH_DOB}}}
     54 a. {{{USP_UPDATE_MATCH_3E_S_NUMBER_MATCH_WITH_PREV_SURNAME}}}
     55 a. {{{USP_UPDATE_MATCH_3E_IPN_MATCH_WITH_PREV_SURNAME}}}
     56 a. {{{USP_UPDATE_MATCH_3F_CASENOTE_NUMBER_MATCH_WITH_PREV_SURNAME}}}
     57 a. {{{USP_UPDATE_MATCH_4A_DEMOGRAPHIC_SURNAME_FORENAME_3_CHAR_SEX_DOB_POSTCODE_OR_ADDR_5_CHAR}}}
     58 a. {{{USP_UPDATE_MATCH_4B_DEMOGRAPHIC_SURNAME_FORENAME_3_CHAR_SEX_DOB}}}
     59 a. {{{USP_UPDATE_MATCH_4C_DEMOGRAPHIC_SURNAME_FORENAME_3_CHAR_SEX_POSTCODE_OR_ADDR_5_CHAR}}}
     60 a. {{{USP_UPDATE_MATCH_4D_DEMOGRAPHIC_SURNAME_FORENAME_3_CHAR_DOB_POSTCODE_OR_ADDR_5_CHAR}}}
     61 a. {{{USP_UPDATE_MATCH_4E_DEMOGRAPHIC_SURNAME_CHAR_SEX_DOB_POSTCODE_OR_ADDR_5_CHAR}}}
     62 a. {{{USP_UPDATE_MATCH_4F_DEMOGRAPHIC_FORENAME_3_CHAR_SEX_DOB_POSTCODE_OR_ADDR_5_CHAR}}}
     63 a. {{{USP_UPDATE_MATCH_5A_S_NUMBER_MATCH}}}
     64 a. {{{USP_UPDATE_MATCH_5A_NHS_NO_MATCH}}}
     65 a. {{{USP_UPDATE_MATCH_5B_CASENOTE_NUMBER_MATCH}}}