CH_UID (CH - Business ID Num.)

From CDQ Wiki
DataModel:CDQ/Business Partner/Identifier/CH UID
Jump to navigation Jump to search
Property Value
A technical identifier, unique in a certain context. Technical key CH_UID
The country a linked concept is active or generally relevant for. Country scope CH (Switzerland)
Language-specific name. Monolingual name Numéro d’identification des entreprises (fr), Numero d’identificazione delle imprese (it), Unternehmens-Identifikationsnummer (de), Business identification number (en)
Language-specific short name. Monolingual short name CH - Business ID Num. (en)
Informal and comprehensive human-readable definition of a concept. Description The Unternehmens-Identifikationsnummer (UID), in French numéro d'identification des entreprises and in Italian numero d'identificazione delle imprese, is assigned by the Swiss Federal Statistical Office to every business operating in Switzerland. Made up of the prefix CHE and nine digits, it is the single key for the commercial register, value added tax and customs and is quoted on business documents.
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/CH UID/format Validates the format of the Swiss business identification number (UID), assigned to every business operating in Switzerland. The pattern accepts the prefix CHE followed by nine digits and an optional register suffix such as MWST, HR or RC that shows in which register the number is entered. IDENTIFIER_FORMAT
^(\s*?\.*?-*?)CHE(-*?\s*?\.*?)(\d-*?\s*\.*-*){9}\s*(MWST\/HR|HR|HR\/MWST|RC|RC\/IVA|RC\/TVA)?$
Regular expression/CH UID/reference schema Defines the reference format in which the Swiss business identification number (UID) is stored, namely CHE, a hyphen and the nine digits in groups of three separated by dots, followed by the register suffix. The suffix MWST/HR is used when the business identification number is at the same time the Swiss VAT registration number. IDENTIFIER_SCHEMA
^(\w{3}-)(\d{3}\.)(\d{3}\.)(\d{3}\s)((\w{2})|(\w{4}\/\w{2})|(\w{2}\/\w{4}))$

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 Qualification (Company identification number (Switzerland), Data source:CH.UIDR)
ACCURACY
CH (Switzerland) This rule compares the Swiss company identification number in the business partner record with the identifier held as reference in the Swiss UID register. A value that does not match the reference is flagged. INFO RELEASED(2025-06-25)
Identifier checkdigit invalid (Company identification number (Switzerland))
ACCURACY
CH (Switzerland) The last digit of the Swiss company identification number is a MOD11 checksum digit calculated with the weighting pattern 5, 4, 3, 2, 7, 6, 5, 4. This rule recomputes that digit and flags a value that does not match. It accepts any correctly formatted Swiss UID, if the format itself is invalid, which the separate rule on the format of the Swiss company identification number covers, this rule fails immediately. ERROR RELEASED(2020-01-01)
Identifier format inaccurate (Company identification number (Switzerland))
REPRESENTATIONAL_CONSISTENCY
CH (Switzerland) This rule checks whether the Swiss company identification number is written exactly in its reference format, any deviation, such as a whitespace where none is specified, results in a violation.

For better readability a hyphen is placed between the prefix and the numerical part of the UID number, and the numerical part is likewise split into three blocks of three digits separated by dots. A UID number therefore has the shape CHE-999.999.999 followed by HR, RC, HR/MWST, RC/TVA or RC/IVA. Which extension applies depends on the part of Switzerland concerned: MWST in the German-speaking part, TVA in the French-speaking part and IVA in the Italian-speaking part.

INFO IDEA(2020-01-01)
Identifier format invalid (Company identification number (Switzerland))
REPRESENTATIONAL_CONSISTENCY
CH (Switzerland) The Swiss company identification number consists of the prefix CHE followed by nine digits and, optionally, HR or RC, so that a UID number has the shape CHE-999.999.999 HR. Where the identification number is also used as a VAT number, the suffix may in addition carry the abbreviations MWST, TVA or IVA in any combination with HR and RC, for example HR/MWST, RC/TVA or RC/IVA.

This rule checks that the prefix and exactly nine 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-12-28)
Identifier missing (Company identification number (Switzerland))
COMPLETENESS
CH (Switzerland) A business partner in Switzerland must have a national identifier. This rule reports records for which none has been maintained. ERROR RELEASED(2020-05-07)
Identifier unknown (Company identification number (Switzerland))
ACCURACY
CH (Switzerland) This rule checks the existence of the Swiss company identification number against the Swiss UID register, the data source CH.UIDR. A number that cannot be found there is flagged. ERROR RELEASED(2024-04-16)
Locality Qualification (Company identification number (Switzerland), Data source:CH.UIDR)
ACCURACY
CH (Switzerland) This rule compares the city of a Swiss business partner with the city that the Swiss UID register holds as reference for its company identification number. A deviating city is flagged. INFO RELEASED(2024-04-16)
Name Qualification (Company identification number (Switzerland), Data source:CH.UIDR)
ACCURACY
CH (Switzerland) This rule compares the name of a Swiss business partner with the name that the Swiss UID register holds as reference for its company identification number. A deviating name is flagged. INFO RELEASED(2024-04-16)
Post code Qualification (Company identification number (Switzerland), Data source:CH.UIDR)
ACCURACY
CH (Switzerland) This rule compares the post code of a Swiss business partner with the post code that the Swiss UID register holds as reference for its company identification number. A deviating post code is flagged. INFO RELEASED(2024-04-16)
Thoroughfare Qualification (Company identification number (Switzerland), Data source:CH.UIDR)
ACCURACY
CH (Switzerland) This rule compares the street of a Swiss business partner with the street that the Swiss UID register holds as reference for its company identification number. A deviating street is flagged. INFO RELEASED(2024-04-16)