| Version 1 (modified by , 11 years ago) ( diff ) |
|---|
CiviCRM GP/Practice Update Process
A proposed process to automatically import and update GP and GP Practice details.
Options
- Import data from HSCIC web site.
- Import the data from the UHL data warehouse.
1. HSCIC
The data files are downloadable from the following page: http://systems.hscic.gov.uk/data/ods/datadownloads/gppractice.
New files are release quarterly, but update files are released monthly (http://systems.hscic.gov.uk/data/ods/datadownloads/monthamend/index_html)
2. UHL Data Warehouse
The data is stored in the DWREPO_BASE database. The tables are:
- MF_GP_OCS (GPs)
- MF_GP_PRACTICE_OCS (Practices)
There are other tables with similar names, but I don't know how they differ from the ones above.
It may be possible to use the SHA codes of the GPs to filter the details for the Leicestershire area.
These tables are recreated from scratch on a weekly basis, but the source from which they are created is the quarterly file above.
