BR_ID_AT (AT - Business register ID)

From CDQ Wiki
DataModel:CDQ/Business Partner/Identifier/BR ID AT
Jump to navigation Jump to search
Property Value
A technical identifier, unique in a certain context. Technical key BR_ID_AT
The country a linked concept is active or generally relevant for. Country scope AT (Austria)
Language-specific name. Monolingual name Firmenbuchnummer (de), Business register identifier (en)
Language-specific short name. Monolingual short name AT - Business register ID (en)
Category of business identifiers. Identifier category Identification Number
Registration authority Austrian Business Register

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_0048 Specifies the allowed formats for the National business register identifier (Austria). For head offices up to 7 characters: up to 6 digits + last character is a letter (not case sensitive), In case of registered branches: Up to 10 characters: up to 6 digits + 1 letter (not case sensitive) + up to 3 digits IDENTIFIER_FORMAT ^(FN)?\s?\d{1,6}[A-Za-z]\d{0,3}$

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 Qualification (National business register identifier (Austria), Data source:AT.CR) This data quality rule checks the congruency of the given identifier against the identifier maintained as reference for the National business register identifier (Austria) LIVE INFO
Identifier checkdigit invalid (National business register identifier (Austria)) This rule checks the checkdigit of National business register identifier (Austria) according to the following the logic:
  • 1) apply the weight number to each identifier's number,
  • 2) calculate a sumproduct of the identifier's number and respectful weight digit

,

  • 3) sum up the result

,

  • 4) apply modulo 17 the summed up result

,

  • 5) lookup the rest number of the modulo 17 in a reference table ---> checksum letter.

Any difference result in a rule violation.

LIVE ERROR
Identifier format inaccurate (National business register identifier (Austria)) National business register identifier (Austria) consists of 7 characters: max 6 letters and 1 checksum letter. No any dots/hyphens/white spaces are expected. This rule checks possible whitespaces, hyphens or dots that might be comprised in the identifier value. If there are any whitespaces, dots or hyphens then the rule is violated.

This rule checks the syntax, i.e. format of the National business register identifier (Austria) with respect to the reference format. Any deviation (i.e. white spaces where they are not specified) result in a violation.

IDEA INFO
Identifier format invalid (National business register identifier (Austria)) National business register identifier (Austria), respectively the Firmenbuchnummer consists of 7 characters: max 6 digits and 1 checksum letter for head offices (i.e. the legal entity). When number of the digits is < 6, then leading zeros should be added. In case of registered branches the format consists of up to 10 characters: up to 6 digits + 1 letter (not case sensitive) + up to 3 digits. The rule allows for maintaining an optional prefix consisting of the two letters "FN" and an optional whitespace.

Violation of the format restrictions without considering possible whitespaces, hyphens or dots that might be comprised in the identifier value result in a violation.

LIVE ERROR
Identifier unknown (National business register identifier (Austria)) This rule checks whether the National business register identifier (Austria) is a really existing one by checking whether it can be found in the business register. If it is not available, the identifier will be treated as invalid and the data quality rule is violated. LIVE ERROR
Invalid checksum of National business register identifier (Austria) This rule checks the checksum of the National business register identifier (Austria) following the logic:
  • 1) apply the weight number to each identifier's number,
  • 2) calculate a sumproduct of the identifier's number and respectful weight digit

,

  • 3) sum up the result

,

  • 4) apply modulo 17 the summed up result

,

  • 5) lookup the rest number of the modulo 17 in a reference table ---> checksum letter.

Any difference result in a rule violation.

ERROR
Locality Qualification (National business register identifier (Austria), Data source:AT.CR) This data quality rule checks the congruency of the given city against the city maintained as reference for the National business register identifier (Austria) LIVE INFO
Name Qualification (National business register identifier (Austria), Data source:AT.CR) This data quality rule checks the congruency of the given name against the name maintained as reference for the National business register identifier (Austria) LIVE INFO
Post code Qualification (National business register identifier (Austria), Data source:AT.CR) This data quality rule checks the congruency of the given post code against the post code maintained as reference for the National business register identifier (Austria) LIVE INFO
Thoroughfare Qualification (National business register identifier (Austria), Data source:AT.CR) This data quality rule checks the congruency of the given street against the street maintained as reference for the National business register identifier (Austria) LIVE INFO