ID_CRN (ID - Company Reg. number)

From CDQ Wiki
DataModel:CDQ/Business Partner/Identifier/ID CRN
Jump to navigation Jump to search
Property Value
A technical identifier, unique in a certain context. Technical key ID_CRN
The country a linked concept is active or generally relevant for. Country scope GB (United Kingdom of Great Britain and Northern Ireland)
Language-specific name. Monolingual name Company registration number (en)
Language-specific short name. Monolingual short name ID - Company Reg. number (en)
Informal and comprehensive human-readable definition of a concept. Description The Company registration number (CRN), also called the Companies House number, is issued by Companies House in the United Kingdom when a limited company or limited liability partnership is incorporated. It must be shown on business letters and invoices and is the key for looking a British company up in the public register.
Category of business identifiers. Identifier category Tax Number
Legacy property. A technical SAP code. SAP mapping STCD1

Formal definition

Details Informal and comprehensive human-readable definition of a concept. Description The type in terms of a categorization of regular expressions. Regular expression type TThe formal expression of a regular expression. Regular expression
Regular expression/ID CRN/format Validates the format of the British company registration number, issued by Companies House when a limited company or limited liability partnership is incorporated. The pattern accepts eight characters made up of a two-character prefix for the register or jurisdiction and six digits, as well as the plain seven or eight digit numbers in use. IDENTIFIER_FORMAT
(^((0[0-9])|AC|FC|GE|GN|GS|IC|IP|LP|NA|NF|NI|NL|NO|NP|NR|NZ|OC|(R[0-9])|RC|SA|SC|SF|SI|SL|SO|SP|SR|SZ|ZC)(\s*?\.*?-*?)(\d\s*\.*-*){6}$)|^[0-9]{7,8}$

Data quality rules

Data quality rule The country a linked concept is active or generally relevant for. Country scope Informal and comprehensive human-readable definition of a concept. Description Criticality<br/>Specifies how critical of the violation of a data quality rule.<br/>ERROR: Indicates a critical data quality rule violation that requires correction.<br/>WARNING: Indicates a potential data quality issue that should be reviewed.<br/>INFO: Indicates an informational finding with no immediate impact on data quality. Criticality Rule release status<br/>The release status in terms of development progress or maturity of a data quality rule.<br/>IDEA: Initial rule definition that documents a business requirement but is not yet active in services.<br/>PLANNED: Rule is specified and scheduled for implementation, but not yet active in services.<br/>DRAFT: Rule concept is being prepared or refined but is not yet finalized for implementation or execution.<br/>HYPERCARE: Rule is newly released and under increased observation to ensure stable behaviour and correct results.<br/>RELEASED: Rule has passed verification and is actively executed in productive CDQ services.<br/>DEACTIVATED: Rule is temporarily removed from the active rule set because it needs correction or clarification before re release.<br/>BLOCKED: Rule cannot be released because something it depends on is missing, for example a data source or a clarification.<br/>ARCHIVED: Rule is permanently retired and no longer maintained or intended for future activation. Rule release status
Identifier format inaccurate (Company registration number (United Kingdom))
REPRESENTATIONAL_CONSISTENCY
GB (United Kingdom of Great Britain and Northern Ireland) This rule checks the syntax of the company registration number of the United Kingdom, requiring either exactly eight digits or a prefix followed by six or seven digits.

Companies formed in England and Wales have numbers beginning with a zero. The possible prefixes are AC for an assurance company in England and Wales, FC for a foreign company in England and Wales, GE for a European Economic Interest Grouping in England and Wales, GN for an EEIG in Northern Ireland, GS for an EEIG in Scotland, IC for an investment company with variable capital in England and Wales, IP for an industrial and provident society in England and Wales, LP for a limited partnership in England and Wales, NA for an assurance company in Northern Ireland, NF for a foreign company in Northern Ireland, NI for a Northern Ireland company, NL for a limited partnership in Northern Ireland, which does not apply to corporation tax and should not be used, NO for other Northern Ireland, NP for an industrial and provident society in Northern Ireland, NR for a royal charter in Northern Ireland, NZ for not Companies Act Northern Ireland, OC for other England and Wales, used only for limited liability partnership cases in liquidation, R for a Northern Ireland company registered before the partition of Ireland in 1922, RC for a royal charter in England and Wales, SA for an assurance company in Scotland, SC for a Scottish company, SF for a foreign company in Scotland, SI for an investment company with variable capital in Scotland, SL for a limited partnership in Scotland, whose companies are not liable to corporation tax and must not be set up on COTAX, SO for other Scotland, used only for limited liability partnership cases in liquidation, SP for an industrial or provident society in Scotland, SR for a royal charter in Scotland, SZ for not Companies Act Scotland and ZC for not Companies Act England and Wales.

INFO ARCHIVED
Identifier format invalid (Company registration number (United Kingdom))
REPRESENTATIONAL_CONSISTENCY
GB (United Kingdom of Great Britain and Northern Ireland) The company registration number in the United Kingdom consists either of eight digits, for English and Welsh companies, or of a one or two character alphabetic prefix followed by digits, for companies registered in Scotland and Northern Ireland and for those registered by the Financial Services Authority.

Companies formed in England and Wales have numbers beginning with a zero. The possible prefixes are AC for an assurance company in England and Wales, FC for a foreign company in England and Wales, GE for a European Economic Interest Grouping in England and Wales, GN for an EEIG in Northern Ireland, GS for an EEIG in Scotland, IC for an investment company with variable capital in England and Wales, IP for an industrial and provident society in England and Wales, LP for a limited partnership in England and Wales, NA for an assurance company in Northern Ireland, NF for a foreign company in Northern Ireland, NI for a Northern Ireland company, NL for a limited partnership in Northern Ireland, which does not apply to corporation tax and should not be used, NO for other Northern Ireland, NP for an industrial and provident society in Northern Ireland, NR for a royal charter in Northern Ireland, NZ for not Companies Act Northern Ireland, OC for other England and Wales, which is used only for limited liability partnership cases in liquidation, R for a Northern Ireland company registered before the partition of Ireland in 1922, RC for a royal charter in England and Wales, SA for an assurance company in Scotland, SC for a Scottish company, SF for a foreign company in Scotland, SI for an investment company with variable capital in Scotland, SL for a limited partnership in Scotland, whose companies are not liable to corporation tax and must not be set up on COTAX, SO for other Scotland, which must only be used for limited liability partnership cases in liquidation, SP for an industrial or provident society in Scotland, SR for a royal charter in Scotland, SZ for not Companies Act Scotland and ZC for not Companies Act England and Wales.

This rule checks that either exactly eight digits, or a prefix followed by six or seven digits, are present, disregarding any whitespaces, hyphens or dots in the value. A value with too few, too many or misplaced digits or letters, or one that lacks the prefix, violates the rule.

ERROR RELEASED(2020-01-01)
Identifier missing (Company registration number (United Kingdom))
COMPLETENESS
GB (United Kingdom of Great Britain and Northern Ireland) Every legal entity in the United Kingdom is expected to hold a company registration number, and this rule flags records in which it is missing. INFO RELEASED(2021-07-01)
Identifier unknown (Company registration number (United Kingdom))
ACCURACY
GB (United Kingdom of Great Britain and Northern Ireland) This rule validates the company registration number of the United Kingdom against Companies House. The registration number counts as valid when it is available in the company register, otherwise it is flagged. ERROR RELEASED(2024-04-16)
Mandatory identifier not maintained (United Kingdom)
COMPLETENESS
GB (United Kingdom of Great Britain and Northern Ireland) A business partner in the United Kingdom should carry at least one of three identifiers: the British European value added tax identifier, which is still supported for now, the British VAT registration number or the British company registration number. If none of the three is available, the record is invalid. ERROR RELEASED(2024-04-16)