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)
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
REGEXP_0217 Specifies the allowed formats for the Company registration number (United Kingdom) IDENTIFIER_FORMAT (^((0[0-9])

Data quality rules

Rule Informal and comprehensive human-readable definition of a concept. Description nonetheless, we continue to offer the most recent available data., The release status in terms of development progress or maturity.<br/><code>EMPTY</code> (0): No feature considered yet, just a rough idea.<br/><code>IDEA</code> (1): Just an idea, not yet designed in detail.<br/><code>DESIGN</code> (2): Software design ready, development not yet started.<br/><code>DEVELOPMENT</code> (3): Software development in progress.<br/><code>ALPHA</code> (4): First functional release, in terms of a Minimal Viable Product (MVP).<br/><code>BETA</code> (5): Tested by selected users.<br/><code>RC</code> (6): Release candidate, fully tested, not yet used in production by many customers.<br/><code>LIVE</code> (7): Used in production by customers, fully monitored and supported.<br/><code>DEPRECATED</code> (-1): End of life planned, but still available.<br/><code>EOL</code> (-2): End of life, historic service, no longer available.<br/><code>BROKEN</code> (-3): Service was used in production but is currently not available. However, CDQ tries to repair or reactivate it.<br/><code>DISCONTINUED</code> (-4): The data source has ceased providing updates Release status Specifies how critical of the violation of a data quality rule. The following levels are defined:<br/><code>ERROR</code>: The violation (e.g. missing information) puts a process at risk or hinders regular processing of data.<br/><code>WARNING</code>: The violation does not hinder regular processing of data but represents semantically defective data.<br/><code>INFO</code>: The data quality rule has not uncovered a data defect, but some information is available that might be interesting for the user.<br/> Criticality
Identifier format inaccurate (Company registration number (United Kingdom)) This rule checks the syntax, i.e. Company registration number (United Kingdom) The first 2 characters can be:
  • Companies formed in England and Wales have CRNs beginning with 0 (zero),
  • AC - Assurance Company England and Wales

,

  • FC - Foreign Company England and Wales

,

  • GE - European Economic Interest Grouping (EEIG) England and Wales

,

  • GN - EEIG Northern Ireland

,

  • GS - EEIG Scotland

,

  • IC - Investment Company with Variable Capital (ICVC) England and Wales

,

  • IP - Industrial and Provident England and Wales

,

  • LP - Limited Partnership England and Wales

,

  • NA - Assurance Company Northern Ireland

,

  • NF - Foreign Company Northern Ireland

,

  • NI - Northern Ireland Company

,

  • NL - Limited Partnership Northern Ireland (This prefix is not applicable to CT and should not be used)

,

  • NO - Other Northern Ireland

,

  • NP - Industrial and Provident Northern Ireland

,

  • NR - Royal Charter Northern Ireland

,

  • NZ - Not Companies Act Northern Ireland

,

  • OC - Other England and Wales (This prefix is only used for LLP cases in liquidation)

,

  • R - Northern Ireland Company registered before the partition of Ireland in 1922

,

  • RC - Royal Charter England and Wales
  • SA - Assurance Company Scotland

,

  • SC - Scottish Company

,

  • SF - Foreign Company Scotland

,

  • SI - Investment Company with Variable Capital (ICVC) Scotland

,

  • SL - Limited Partnership Scotland (Companies registered under this prefix are not liable to Corporation Tax and must not be set up on COTAX)

,

  • SO - Other Scotland (This prefix must only be used for LLP cases in liquidation)

,

  • SP - Industrial / Provident Scotland

,

  • SR - Royal Charter Scotland

,

  • SZ - Not Companies Act Scotland

,

  • ZC - Not Companies Act England and Wales.

This rule checks presence of exactly 8 digits or prefix and 6 or 7 digits.

INFO
Identifier format invalid (Company registration number (United Kingdom)) Company registration number in United Kingdom consists of either 8 digits (English and Welsh companies) or have 1 or 2 character alphabetic prefix (Companies registered in Scotland and Northern Ireland and those registered by the Financial Services Authority). The following are possible values for the prefix.
  • Companies formed in England and Wales have CRNs beginning with 0 (zero),
  • AC - Assurance Company England and Wales

,

  • FC - Foreign Company England and Wales

,

  • GE - European Economic Interest Grouping (EEIG) England and Wales

,

  • GN - EEIG Northern Ireland

,

  • GS - EEIG Scotland

,

  • IC - Investment Company with Variable Capital (ICVC) England and Wales

,

  • IP - Industrial and Provident England and Wales

,

  • LP - Limited Partnership England and Wales

,

  • NA - Assurance Company Northern Ireland

,

  • NF - Foreign Company Northern Ireland

,

  • NI - Northern Ireland Company

,

  • NL - Limited Partnership Northern Ireland (This prefix is not applicable to CT and should not be used)

,

  • NO - Other Northern Ireland

,

  • NP - Industrial and Provident Northern Ireland

,

  • NR - Royal Charter Northern Ireland

,

  • NZ - Not Companies Act Northern Ireland

,

  • OC - Other England and Wales (This prefix is only used for LLP cases in liquidation)

,

  • R - Northern Ireland Company registered before the partition of Ireland in 1922

,

  • RC - Royal Charter England and Wales
  • SA - Assurance Company Scotland

,

  • SC - Scottish Company

,

  • SF - Foreign Company Scotland

,

  • SI - Investment Company with Variable Capital (ICVC) Scotland

,

  • SL - Limited Partnership Scotland (Companies registered under this prefix are not liable to Corporation Tax and must not be set up on COTAX)

,

  • SO - Other Scotland (This prefix must only be used for LLP cases in liquidation)

,

  • SP - Industrial / Provident Scotland

,

  • SR - Royal Charter Scotland

,

  • SZ - Not Companies Act Scotland

,

  • ZC - Not Companies Act England and Wales.

This rule checks presence of exactly 8 digits or prefix and 6 or 7 digits without considering possible whitespaces, hyphens or dots that might be comprised in the identifier value. If there are less/more or wrong placed digits/letters or the prexis is missing then the rule is violated.

LIVE ERROR
Identifier missing (Company registration number (United Kingdom)) Each legal entity in the United Kingdom should have a Company registration number. LIVE INFO
Identifier unknown (Company registration number (United Kingdom)) This business rule checks the validity of the Company registration number against Companies House. The registration valid number number is valid, when it is available in the company register . LIVE ERROR