Documents
Resources
Learning Center
Upload
Plans & pricing Sign in
Sign Out
Your Federal Quarterly Tax Payments are due April 15th Get Help Now >>

ods_to_sds.xls - NHS Connecting for Health — NHS Connecting for Health

VIEWS: 65 PAGES: 7

									Version     Description                                       Author       Date
          1 Draft for discussion at SDS Forum November 2007   Danny Ruttle  11/1/2007
          2 Internal review December 2008                     Danny Ruttle  12/9/2008
          3 Internal review September 2010                    Danny Ruttle  9/10/2010
                             83562786-79e6-4667-a232-7085869c10bc.xls


Report Name      Description
default          Default Codes used in legacy systems
eabeydispgp      Abeyance and dispersal
eamendam         Monthly amended records for main ODS orgs (zip file containing
                 separate csvs for different org types).
eamendaq         Quarterly amended records for main ODS orgs (zip file containing
                 separate csvs for different org types).
earchive         Archived organisations

eauth            Strategic Health Authorities, Regional Offices




ebranchs         GP Branch Surgeries
ecare            Care Trusts and Sites

Ecarehomehq      Care Home HQs
Ecarehomesite    Care Home Sites
Ecarehomesucc    Care Home Successors
econcur          Hospital Consultants (England)
ect              Care Trusts
ectsite          Care Trust Sites
edconcur         Dental Consultants
edispensary      Dispensaries
educate          Education Establishments
educationtype    Education Type (Type of school look up table)
egdp             General Dental Practitioners
egdpprac         General Dental Practices
egdpprac_close   Final March 2006 Dental Practice file
egdppracmem      General Dental Practice Membership
egpam            General Medical Practitioners AND GP Practices (amalgamated monthly
                 amendment version of egpcur and epraccur)

egpaq            General Medical Practitioners AND GP Practices (amalgamated
                 quarterly amendment version of egpcur and epraccur)

egparc           General Medical Practitioners (archived)
egpcur           General Medical Practitioners (current)
egpcur1          General Medical Practitioners (current - split of egpcur)
egpcur2          General Medical Practitioners (current - split of egpcur)
egpmemam         GP - GP Practice AND GP Practice - PCT Membership (monthly
                 amendment version of epcmem and epracmem amalgamated)


egpmemaq         GP - GP Practice AND GP Practice - PCT Membership (quarterly
                 amendment version of epcmem and epracmem amalgamated)


ehospice         Hospices
eiom             Isle of Man Data
enonnhs          Non NHS Organisations
ensa             NHS Support Agencies
ENURSE           Nurse Practitioners
eopthq           Optical HQs




                                                 Page 2
                          83562786-79e6-4667-a232-7085869c10bc.xls


eoptsite      Optical Sites
eother        Military Hospitals and misc org types




epcdp         Private Controlled Drug Prescribers
epcdpan       Private Controlled Drug Prescribers (monthly amendment version of
              epcdp)
epcdpaq       Private Controlled Drug Prescribers (quarterly amendment version of
              epcdp)
epcmem        GP Practice - Primary Care Trust Membership
epctcur       Primary Care Trusts
epctsite      Primary Care Trust Sites, Assets and Units
epharmacyhq   Pharmacy HQs
ephp          Independent Sector Healthcare Provider
ephpsite      Independent Sector Healthcare Provider Site
eplab         Pathology Laboratories
epracarc      GP Practices (archived)

epraccur      GP Practices (current)
epracmem      GP Practitioner - Practice Membership



eprison       Prisons in England and Wales
eschool       Schools, Colleges and Universities

espha         Special Health Authorities
etr           NHS Trusts
etreat        Treatment Centres in England and Wales

etrust        NHS Trusts and Trust Sites

ets           NHS Trust Sites and Assests
gridall       Extended ONS postcode data for the whole UK
gridoth       Extended ONS postcode data for Channel Islands, Isle of Man,
              unallocated postcodes and pseudo codes
gridwsn       Extended ONS postcode data for Wales, and Postcode and HB
              Allocation for Scotland and Northern Ireland
gridy51       Extended ONS postcode data for NMEPFIT
gridy52       Extended ONS postcode data for SPFIT
gridy53       Extended ONS postcode data for LPFIT
ngpcur        Northern Ireland General Medical Practitioners
nhsces        Communal Establishment File
niarchive     Northern Ireland Archive
NIorg         Northern Ireland Boards, Trusts and Local Health and Social Care
              Groups
NLHSCGPR      Northern Ireland GP - LHSCG Mapping
NPRACCUR      Northern Ireland GP Practices
pcodeall      Postcode, Strategic Health Authority and Primary Care Trust/Care Trust
              allocations for the whole UK




                                              Page 3
                       83562786-79e6-4667-a232-7085869c10bc.xls


pcodeoth   Postcode, Strategic Health Authority and Primary Care Trust/Care Trust
           allocations for Channel Islands, Isle of Man, unallocated postcodes and
           pseudo codes
pcodewsn   Postcode, HA and LHG/LHB Allocations for Wales, and Postcode and
           HB Allocation for Scotland and Northern Ireland
pcodey51   Postcode, Strategic Health Authority and Primary Care Trust/Care Trust
           allocations for NMEPFIT
pcodey52   Postcode, Strategic Health Authority and Primary Care Trust/Care Trust
           allocations for SPFIT
pcodey53   Postcode, Strategic Health Authority and Primary Care Trust/Care Trust
           allocations for LPFIT
safe       Safe Havens in England and Wales
scotgp     GPs in Scotland
scotprov   Provider Organisations in Scotland
scotpur    Purchaser Organisations in Scotland
Scsafe     Safe Havens in Scotland
succ       Successors for organisations of current interest
succarc    Successors for organisations closed for over a year

Wconcur    Welsh Hospital Consultants (csv file)
whbs       Welsh Local Health Boards and Sites

wlhb       Welsh Local Health Boards
wlhbsite   Welsh Local Health Board Sites




                                          Page 4
                            83562786-79e6-4667-a232-7085869c10bc.xls


Type          SDS Status
Reference     No
Reference     No
Orgs          Yes - amendments can be derived from SDS using
              modify timestamp attribute
Orgs          Yes - amendments can be derived from SDS using
              modify timestamp attribute
Orgs          Yes - subset of these matched in SDS (closed
              orgs since 2004)
Orgs          SHAs yes. W00 and W01 yes. PAN SHAs (these
              were swapped out for the IT Clusters at transition)
              yes.
              Also in the file are GORs, W01HC (Health
              Commission Wales) and old IT Clusters which are
              not on SDS at present.
Orgs          Yes
Orgs          Yes (also covered by ect and ectsite - this file is an
              amalgamation of both)
Orgs          Yes
Orgs          No
Orgs          No
People        Yes - subset of these matched in SDS
Orgs          Yes
Orgs          Yes
People        No - not currently in scope for Spine activity.
Orgs          Yes
Orgs          Yes
Reference     No
People        No - not currently in scope for Spine activity
Orgs          Yes
Orgs          No
Reference     No
People/Orgs   Yes - subset of these matched in SDS (all
              practices, some people, but taken from individual
              files, egpcur and epraccur)
People/Orgs   Yes - subset of these matched in SDS (all
              practices, some people, but taken from individual
              files, egpcur and epraccur)
People        Yes - a subset of these matched in SDS
People        Yes - a subset of these matched in SDS
People        Yes - a subset of these matched in SDS
People        Yes - a subset of these matched in SDS
People/Orgs   Yes - a subset are in SDS (GNC-to-Practice
              membership can be derived from SDS but only for
              those GPs whose GNC has been matched and
              loaded)
People/Orgs   Yes - a subset are in SDS (GNC-to-Practice
              membership can be derived from SDS but only for
              those GPs whose GNC has been matched and
              loaded)
Orgs          Yes
Orgs          Yes
Orgs          Yes
Orgs          Yes
People        No
Orgs          Yes




                                                 Page 5
                            83562786-79e6-4667-a232-7085869c10bc.xls


Orgs          Yes
Orgs          Yes - including: LSP and LSP Sites, Cancer
              Networks, SHA Sites, Special HA Sites, Other
              Statutory Authorities, Exec Agencies, Exec
              Agency Programmes, Exec Agency Programme
              Departments, Exec Agency Sites, Government
              Departments, Governemnt Department Sites, MoD
              Hospitals, Public Health Observatories, Cancer
              Registries, Clinical Networks, NASPs, ASPs

People        No
People        No

People        No

Reference     Yes
Orgs          Yes
Orgs          Yes
Orgs          Yes
Orgs          Yes
Orgs          Yes
Orgs          Yes
Orgs          Yes - a subset of these matched in SDS (practices
              closed since 2004)
Orgs          Yes
People/Orgs   Yes - a subset are in SDS (GNC-to-Practice
              member ship can be derived from SDS but only for
              those GPs whose GNC has been matched and
              loaded)
Orgs          Yes
Orgs          No - but the initial load is planned within 12
              months.
Orgs          Yes
Orgs          Yes
Orgs          Yes - Trusts and ISHPs are subtyped as required.

Orgs          Yes (also covered by etr and ets - this file is an
              amalgamation of both)
Orgs          Yes
Reference     No
Reference     No

Reference     No

Reference     No
Reference     No
Reference     No
People        No
Reference     No
Orgs          No
Orgs          No

Reference     No
Orgs          No
Reference     No




                                                 Page 6
                          83562786-79e6-4667-a232-7085869c10bc.xls


Reference   No


Reference   No

Reference   No

Reference   No

Reference   No

Reference   No
People      No
Orgs        No
Orgs        No
Reference   No
Orgs        Yes
Orgs        Yes - a subset of these matched in SDS (practices
            closed since 2004)
People      No
Orgs        Yes (also covered by wlhb and wlhbsite - this file is
            an amalgamation of both)
Orgs        Yes
Orgs        Yes




                                              Page 7

								
To top