PSC BODS User guide #public

PSC mapping to BODS 0.4 user guide

Last updated: 6 Mar 2025

This user guide explains how we've transformed publicly available company data from Companies House, including information on People with Significant Control (PSCs) and registered overseas entities, into BODS 0.4 format. Our goal was to maintain the integrity of the original data throughout the conversion process. This guide details key modeling decisions made during the PSC data mapping to BODS 0.4 and provides field mapping information to facilitate data use and analysis. Please report any suspected mapping errors (as opposed to issues present in the source data) by raising an issue in the associated GitHub repository.

Sources

Bulk PSC download | Free company data | API

Modelling decisions

To note when using the data:

Due to limitations in the source data, trusts are not modeled according to the BODS 0.4 specification.
Where discrepancies exist between free company data and PSC data for entity details (e.g., business name or address), the free company data is prioritised. Conflicting information will be published as alternate names and additional addresses.
The bulk free company data does not contain historical statements (including information about dissolved entities). Although historical statements may be implied (for example, because the latest statement about a company is recent, but its founding date is decades ago), they have not been re-created.
While the data suggests person addresses are service addresses, this cannot be guaranteed. Therefore, person addresses are presented as service addresses, but this may not be accurate.
The statement date reflects the data retrieval date. The Companies House notification date is captured as the startDate within the relationship statement.
There are a number of known data quality issues in the source data, see the related GitHub issue for more information.
Due to the current absence of unique identifiers in the source data, people cannot be automatically disambiguated. Data collation for individuals will require matching based on name and date of birth.
Overseas entities will always have a `recordStatus` of 'new' or 'updated' because we lack data on their dissolution.

Fields mapping

Full mapping - BODS 0.4 PSC simple mapping

Key fields

Field	BODS Entity (Free company data)	BODS Entity (PSC data entity)	BODS Person	BODS Relationship
recordId	‘CompanyNumber’ with Org-ID prefix added. e.g. GB-COH-00653103 or GB-COH-OE005784	If has recognised identifier and scheme in data/identification then the Org-ID scheme and will be combined with the registration_number e.g. BE-BCE_KBO-0441.642.780or CH-FDJP-Che-105.884.494 Otherwise the GB-COH-ENT-<linked UK company number>-<last part of data/links/self>	GB-COH-PER-<linked UK company number>-<last part of data/links/self>	GB-COH-REL-<linked UK company number>-<last part of data/links/self>
recordType	entity	entity If PSC contains an ‘identifier’ block, the PSC is an entity.	person Where fields such as ‘date of birth’, ‘‘nationality’ and ‘country of residence’ exist in PSC.	relationship
statementId	Generated	Generated	Generated	Generated
recordStatus	new or updated (delta) or closed (if company has DissolutionDate)	new or updated (delta) or closed (if data contains data/ceased_on)	new or updated (delta) or closed (if data contains data/ceased_on)	new or updated (delta) or closed (if data contains data/ceased_on)
statementDate	ConfStmtLastMadeUpDate E.g. 2024-04-07	notified_on until we detect change	notified_on until we detect change	notified_on until we detect change
publicationDate	date on bulk download file https://download.companieshouse.gov.uk/en_pscdata.html

Reporting exceptions

Exception statement code	Companies House description	BODS 0.4 mapping
no-individual-or-entity-with-signficant-control	"The company knows or has reasonable cause to believe that there is no registrable person or registrable relevant legal entity in relation to the company"	noBeneficialOwners
all-beneficial-owners-identified	"All beneficial owners have been identified and all required information can be provided"	new lifecycle statement, same recordId with notified on date updated, latest info will be the same
steps-to-find-psc-not-yet-completed	"The company has not yet completed taking reasonable steps to find out if there is anyone who is a registrable person or a registrable relevant legal entity in relation to the company"	subjectUnableToConfirmOrIdentifyBeneficialOwner
psc-exists-but-not-identified	"The company knows or has reasonable cause to believe that there is a registrable person in relation to the company but it has not identified the registrable person"	subjectUnableToConfirmOrIdentifyBeneficialOwner
psc-details-not-confirmed	"The company has identified a registrable person in relation to the company but all the required particulars of that person have not been confirmed"	subjectUnableToConfirmOrIdentifyBeneficialOwner
nobody-has-become-or-ceased-to-be-a-beneficial-owner	"Nobody has become or ceased to be a beneficial owner during the update period"	new lifecycle statement, same recordId with notified on date updated, latest info will be the same
steps-to-find-psc-not-yet-completed-partnership	"The partnership has not yet completed taking reasonable steps to find out if there is anyone who is a registrable person or a registrable relevant legal entity in relation to the partnership"	subjectUnableToConfirmOrIdentifyBeneficialOwner
no-beneficial-owner-identified	"No beneficial owners have been identified"	noBeneficialOwners
psc-contacted-but-no-response	"The company has given a notice under section 790D of the Act which has not been complied with"	interestedPartyHasNotProvidedInformation
no-individual-or-entity-with-signficant-control-partnership	"The partnership knows or has reasonable cause to believe that there is no registrable person or registrable relevant legal entity in relation to the partnership"	noBeneficialOwners
somebody-has-become-or-ceased-to-be-a-beneficial-owner	"Somebody has become or ceased to be a beneficial owner during the update period"	unknown
psc-details-not-confirmed-partnership	"The partnership has identified a registrable person in relation to the partnership but all the required particulars of that person have not been confirmed"	subjectUnableToConfirmOrIdentifyBeneficialOwner
psc-exists-but-not-identified-partnership	"The partnership knows or has reasonable cause to believe that there is a registrable person in relation to the partnership but it has not identified the registrable person"	subjectUnableToConfirmOrIdentifyBeneficialOwner
at-least-one-beneficial-owner-unidentified	"Some beneficial owners have been identified and all required information can be provided"	unknown
restrictions-notice-issued-to-psc	"The company has issued a restrictions notice under paragraph 1 of Schedule 1B to the Act"	subjectExemptFromDisclosure
psc-has-failed-to-confirm-changed-details	"{linked_psc_name} has failed to comply with a notice given by the company under section 790E of the Act"	interestedPartyHasNotProvidedInformation
at-least-one-beneficial-owner-unidentified-and-information-not-provided-for-at-least-one-beneficial-owner	"Some beneficial owners have been identified and only some required information can be provided"	unknown
psc-contacted-but-no-response-partnership	"The partnership has given a notice under Regulation 10 of The Scottish Partnerships (Register of People with Significant Control) Regulations 2017 which has not been complied with"	interestedPartyHasNotProvidedInformation
information-not-provided-for-at-least-one-beneficial-owner	"All beneficial owners have been identified but only some required information can be provided"	unknown
psc-has-failed-to-confirm-changed-details-partnership	"The partnership has given a notice under Regulation 11 of The Scottish Partnerships (Register of People with Significant Control) Regulations 2017 which has not been complied with"	subjectUnableToConfirmOrIdentifyBeneficialOwner
restrictions-notice-issued-to-psc-partnership	"The partnership has issued a restrictions notice under paragraph 1 of Schedule 2 to The Scottish Partnerships (Register of People with Significant Control) Regulations 2017"	subjectExemptFromDisclosure