Organisation Data Service : Welsh Local Health Boards and Sites

Data Description

Local Health Boards (LHBs) are responsible for the planning and provision of health care services within their area at all levels. ODS publish data re Welsh LHBs and their sites.

How Data is Maintained

Local Health Boards in Wales are statutory organisations. As such, any establishment, dissolution or changes to the name of LHBs are published in a Statutory Instrument, which is released on to the Government website of the Office for Public Sector Information. The ODS check this website daily and implement any changes required.  Information on LHB sites and other minor changes to the parent organisations are relayed to ODS by Digital Health and Care Wales (DHCW).

ODS also work closely with DHCW with regards to Welsh organisations. DHCW perform a similar function to ODS within Wales and have input over development of Welsh organisation data.

Note that Primary RoleID RO142 LOCAL HEALTH BOARD and RO148 LOCAL HEALTH BOARD SITE are the contemporary/correct codes. Codes published under Primary Role ID RO144 Welsh Local Health Board and RO149 Welsh Local Health Board Site are all closed/should not be used.


Data Quality Assessment

For further information re the: ODS Data Quality Assessment Framework



Data Quality Dimension
Last updated:

 

12345ODS mastered or 3rd party data6789

OVERALLFrequency of UpdateData Collection MethodFit for PurposeCoverage / CompletenessReliability / AccuracyData Agreement3rd Party Escalation RoutesSystem Application / Downstream System FeedbackFuture Refinement / Improvement Plan
Welsh Local Health Boards and SitesGREENGreenGreenGreenGreenGreenODSn/an/aGreenGreen

Ad Hoc, driven by DHCW policy changesODS mastered on behalf on DHCW, we liaise closely with them to maintain LHB data and sites.

Codes created to meet demand

Complete

ODS are regularly  informed of necessary updates by DHCW


n/an/aNo known issuesNot required


Welsh Local Health Boards

Key Information - Roles, Code Formats and Data Source

Key Information
Geographic coverage
  • Wales
Primary Role IDRO142Primary Role NameLOCAL HEALTH BOARD
Non Primary Role ID
N/ANon Primary Role Name
N/A
Raw Data SourceGovernment Website of the Office for Public Sector InformationUpdate FrequencyAd-hoc
Code Format
Character Positions
12345
6,7A-9A-Y, 0-9

Permitted Relationships

Permitted Relationships - 'Local Health Board' can be linked to (upward):

Source Primary Role ID

Relationship Type IdRelationship Type NameTarget Primary Role IDTarget Primary Role Name

RO142

RE5IS LOCATED IN THE GEOGRAPHY OFRO185REGIONAL OFFICE (RO)

Legacy .csv Field Mapping

Click here for an explanation of the baseline data differences between legacy csv files and ODS Data Search and Export and the ODS APIs.

wlhb.csv

Primary Role / OrgTypeID – RO142

Col

Data Item

Report Alias (legacy csv)

Notes

1

[OrganisationCode]

Organisation Code


2

[OrgName]

Name


3

NULL

National Grouping

Change from legacy csv: Previously populated with the default code W00, but now blank as not applicable

4

NULL

High Level Health Geography

Change from legacy csv: Previously populated with the default code Q99, but now blank as not applicable

5

[Address1]

Address Line 1


6

[Address2] 

Address Line 2


7

[Address3] 

Address Line 3


8

[Town]

Address Line 4


9

[County] 

Address Line 5

Change from legacy csv: As this is a legacy field, not populated for new addresses since 2018, this field within the ODS Data Search & Export tool (including pre defined reports) will not be populated.

Note that the value (where populated) is available via the FHIR Organization Resource in the address.district property.

10

[Postcode] 

Postcode


11

[LegalStartDate] 

Open Date


12

[LegalEndDate] 

Close Date


13

NULL

Column 13


14

NULL

Column 14


15

NULL

Column 15


16

NULL

Column 16


17

NULL

Column 17


18

NULL

Contact Telephone Number

Change from legacy csv: Although a field within the legacy csv report, no data was available to populate this field. Therefore, it is being withjdrawn from the ODS DSE Pre Defined report.

19

NULL

Column 19


20

NULL

Column 20


21

NULL

Column 21


22

‘1’

Amended Record Indicator

Set to 1 for Report

23

NULL

Column 23


24

NULL

Column 24


25

NULL

Column 25


26

NULL

Column 26


27

NULL

Column 27



Welsh Local Health Board Sites

Key Information - Roles, Code Formats and Data Source

Key Information
Geographic coverage
  • Wales
Primary Role IDRO149Primary Role NameWELSH LOCAL HEALTH BOARD SITE
Non Primary Role ID
N/ANon Primary Role Name
N/A
Raw Data SourceDigital Health and Care Wales (DHCW)Update FrequencyAd-hoc
Code Format
Character Positions
6,7A-9A-Y, 0-9A-9A-9

Permitted Relationships

Permitted Relationships - 'Welsh Local Health Board Site' can be linked to (upward):

Source Primary Role ID

Relationship Type IdRelationship Type NameTarget Primary Role IDTarget Primary Role Name

RO148

RE6IS OPERATED BYRO142LOCAL HEALTH BOARD

Legacy .csv Field Mapping

Click here for an explanation of the baseline data differences between legacy csv files and ODS Data Search and Export and the ODS APIs.

wlhbsite.csv

Primary Role / OrgTypeID – RO148

Col

Data Item

Report Alias (legacy csv)

Notes

1

[OrganisationCode]

Organisation Code


2

[OrgName]

Name


3

NULL

National Grouping

Change from legacy csv: Previously populated with the default code W00, but now blank as not applicable

4

NULL

High Level Health Geography

Change from legacy csv: Previously populated with the default code Q99, but now blank as not applicable

5

[Address1]

Address Line 1


6

[Address2] 

Address Line 2


7

[Address3] 

Address Line 3


8

[Town]

Address Line 4


9

[County] 

Address Line 5

Change from legacy csv: As this is a legacy field, not populated for new addresses since 2018, this field within the ODS Data Search & Export tool (including pre defined reports) will not be populated.

Note that the value (where populated) is available via the FHIR Organization Resource in the address.district property.

10

[Postcode] 

Postcode


11

[LegalStartDate] 

Open Date


12

[LegalEndDate] 

Close Date


13

NULL

Column 13


14

NULL

Column 14


15

NULL

Column 15


16

NULL

Column 16


17

NULL

Column 17


18

NULL

Contact Telephone Number

Change from legacy csv: Although a field within the legacy csv report, no data was available to populate this field. Therefore, it is being withjdrawn from the ODS DSE Pre Defined report.

19

NULL

Column 19


20

NULL

Column 20


21

NULL

Column 21


22

‘1’

Amended Record Indicator

Set to 1 for Report

23

NULL

Column 23


24

 NULL

Column 24


25

 NULL

Column 25


26

 NULL

Column 26


27

 NULL

Column 27


whbs.csv

This legacy csv file has been deprecated because it is no longer fit for purpose since the introduction of the ANANA code frame. Previously, WHB Site codes included the parent code in their first 3 characters which enabled the parent org to be derived. This is no longer the case with ANANA codes, and so from this legacy report, there is no way of mapping the site to the parent org. As WHB and WHB Site data are available via separate pre defined reports, the decision has been made to withdraw this file from publication.