IT_REA (IT - Identification Number)

From CDQ Wiki
DataModel:CDQ/Business Partner/Identifier/IT REA
Jump to navigation Jump to search
Property Value
A technical identifier, unique in a certain context. Technical key IT_REA
The country a linked concept is active or generally relevant for. Country scope IT (Italy)
Language-specific name. Monolingual name Repertorio delle notizie Economiche e Amministrative (it), The Economic and Administrative Index (en)
Language-specific short name. Monolingual short name IT - Identification Number (en)
Informal and comprehensive human-readable definition of a concept. Description The REA number, from Repertorio delle notizie Economiche e Amministrative, is the entry number in the economic and administrative index that the Italian chambers of commerce keep alongside the business register. It records legal form, status and activities of a business and is used to verify those details and for regulatory purposes.
Category of business identifiers. Identifier category Identification Number

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/IT REA/format Specifies the allowed format for the REA number (Italy): the two-letter code of the province whose Chamber of Commerce holds the entry, followed by the progressive registration number. The province code is checked against the 107 current Italian provinces and metropolitan cities, plus the codes CI, OG, OT and VS of the four Sardinian provinces abolished in 2016, which entries registered before then still carry. The progressive number is assigned in registration order and is therefore short for early entries, up to 7 digits are accepted. A space, dot or hyphen between the province code and the number is tolerated. The REA number carries no check digit, so no checksum validation is possible. IDENTIFIER_FORMAT
^(AG|AL|AN|AO|AP|AQ|AR|AT|AV|BA|BG|BI|BL|BN|BO|BR|BS|BT|BZ|CA|CB|CE|CH|CI|CL|CN|CO|CR|CS|CT|CZ|EN|FC|FE|FG|FI|FM|FR|GE|GO|GR|IM|IS|KR|LC|LE|LI|LO|LT|LU|MB|MC|ME|MI|MN|MO|MS|MT|NA|NO|NU|OG|OR|OT|PA|PC|PD|PE|PG|PI|PN|PO|PR|PT|PU|PV|PZ|RA|RC|RE|RG|RI|RM|RN|RO|SA|SI|SO|SP|SR|SS|SU|SV|TA|TE|TN|TO|TP|TR|TS|TV|UD|VA|VB|VC|VE|VI|VR|VS|VT|VV)[\s.-]?\d{1,7}$

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 invalid (REA number (Italy))
REPRESENTATIONAL_CONSISTENCY
IT (Italy) This rule reports values held as REA number (Italy) whose format is not a valid Chamber of Commerce entry reference. The REA number identifies an entry in the Repertorio delle notizie Economiche e Amministrative, the register kept by the provincial Chambers of Commerce alongside the Registro delle Imprese.

The value consists of the two-letter code of the province whose Chamber of Commerce holds the entry, followed by the progressive registration number. The province code is checked against the 107 current Italian provinces and metropolitan cities, together with the codes CI, OG, OT and VS of the four Sardinian provinces abolished in 2016, because entries registered before then still carry them. The progressive number is assigned in registration order and is therefore short for early entries, so any length up to 7 digits is accepted. A space, dot or hyphen between the province code and the number is tolerated.

Because the number is province-scoped it is unique only within its province, and the province code is therefore part of the identifier rather than optional context. A value consisting of digits alone cannot be validated and is reported by this rule.

The REA number carries no check digit, so there is no checksum rule for this identifier, confirming that an entry actually exists requires a lookup against the Chamber of Commerce register.

ERROR HYPERCARE