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 Unique identifier that is assigned to each business which operates in Switzerland.
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
00000000008XJ79EJQEQCD4264 The suffix MWST/HR is to be used when the company identification number equals the Swiss VAT number IDENTIFIER_SCHEMA
^(\w{3}-)(\d{3}\.)(\d{3}\.)(\d{3}\h)((\w{2})|(\w{4}\/\w{2})|(\w{2}\/\w{4}))$
0000000000TX28X08FZDHX2H13 Specifies the allowed formats for the Company identification number (Switzerland) IDENTIFIER_FORMAT
^(\s*?\.*?-*?)CHE(-*?\s*?\.*?)(\d-*?\s*\.*-*){9}\s*(MWST\/HR|HR|HR\/MWST|RC|RC\/IVA|RC\/TVA)?$

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 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
Identifier Qualification (Company identification number (Switzerland), Data source:CH.UIDR) This data quality rule checks the congruency of the given identifier against the identifier maintained as reference for the Company identification number (Switzerland) RELEASED INFO
Identifier checkdigit invalid (Company identification number (Switzerland)) The last digit is a MOD11 checksum digit build with weighting pattern: 5,4,3,2,7,6,5,4. The rule allows for any valid formatted CH UID, in case of an invalid format (see Identifier format invalid (Company identification number (Switzerland))) the rule will fail directly. RELEASED ERROR
Identifier format inaccurate (Company identification number (Switzerland)) This rule checks the syntax, i.e. format of the Company identification number (Switzerland) with respect to the reference format. Any deviation (i.e. white spaces where they are not specified) result in a violation.

For better readability, a hyphen is put between the prefix and the digital part of the UID-number. Analogous to the prefix, the numerical part is split into three blocks of three numbers, each block being separated from the other by a dot. The structure of a UID-number can be modelled as follows: CHE-999.999.999 HR or RC or HR/MWST or RC/TVA or RC/IVA

Depending on which part of Switzerland this extension will change as follows: German part: MWST French part: TVA Italian part: IVA

IDEA INFO
Identifier format invalid (Company identification number (Switzerland)) Company identification number (Switzerland) consists of prefix "CHE" followed by 9 digits and "HR" or "RC" (optional). The structure of a UID-number can be modelled as follows: CHE-999.999.999 HR. Depending on whether the identification number is additionally used as VAT number the suffix allows also for the additional abbreviations: MWST, TVA or IVA in any combination with HR and RC, e.g. HR/MWST, RC/TVA or RC/IVA

This rule checks presence of exactly 9 digits and prefix 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 prefix is missing then the rule is violated.

RELEASED ERROR
Identifier missing (Company identification number (Switzerland)) In Switzerland, a business partner must have a national identifier. RELEASED ERROR
Identifier unknown (Company identification number (Switzerland)) This business rule checks the existence of the given Company identification number (Switzerland) against the Data source/CH.UIDR RELEASED ERROR
Locality Qualification (Company identification number (Switzerland), Data source:CH.UIDR) This data quality rule checks the congruency of the given city against the city maintained as reference for the Company identification number (Switzerland) RELEASED INFO
Name Qualification (Company identification number (Switzerland), Data source:CH.UIDR) This data quality rule checks the congruency of the given name against the name maintained as reference for the Company identification number (Switzerland) RELEASED INFO
Post code Qualification (Company identification number (Switzerland), Data source:CH.UIDR) This data quality rule checks the congruency of the given post code against the post code maintained as reference for the Company identification number (Switzerland) RELEASED INFO
Thoroughfare Qualification (Company identification number (Switzerland), Data source:CH.UIDR) This data quality rule checks the congruency of the given street against the street maintained as reference for the Company identification number (Switzerland) RELEASED INFO