Changes between Initial Version and Version 1 of CiviCRM Module HSCIC Importer Planning


Ignore:
Timestamp:
10/01/13 13:37:57 (11 years ago)
Author:
Richard Bramley
Comment:

--

Legend:

Unmodified
Added
Removed
Modified

  • CiviCRM Module HSCIC Importer Planning

    v1 v1  
     1= CiviCRM GP/Practice Update Process
     2
     3A proposed process to automatically import and update GP and GP Practice details.
     4
     5== Options
     61. Import data from HSCIC web site.
     72. Import the data from the UHL data warehouse.
     8
     9== 1. HSCIC
     10
     11The data files are downloadable from the following page: http://systems.hscic.gov.uk/data/ods/datadownloads/gppractice.
     12
     13New files are release quarterly, but update files are released monthly (http://systems.hscic.gov.uk/data/ods/datadownloads/monthamend/index_html)
     14
     15== 2. UHL Data Warehouse
     16
     17The data is stored in the {{{DWREPO_BASE}}} database.  The tables are:
     18
     19* MF_GP_OCS (GPs)
     20* MF_GP_PRACTICE_OCS (Practices)
     21
     22There are other tables with similar names, but I don't know how they differ from the ones above.
     23
     24It may be possible to use the SHA codes of the GPs to filter the details for the Leicestershire area.
     25
     26These tables are recreated from scratch on a weekly basis, but the source from which they are created is the quarterly file above.