ES_NIE (ES - Tax Identification Number)

From CDQ Wiki
DataModel:CDQ/Business Partner/Identifier/ES NIE
Jump to navigation Jump to search
Property Value
A technical identifier, unique in a certain context. Technical key ES_NIE
The country a linked concept is active or generally relevant for. Country scope ES (Spain)
Language-specific name. Monolingual name Numero de Identificacion de Extranjero (es), Tax Identification Number (en)
Language-specific short name. Monolingual short name ES - Tax Identification Number (en)
Informal and comprehensive human-readable definition of a concept. Description The Número de Identificación de Extranjero (NIE) is the Spanish identification number for natural persons without Spanish nationality, made up of a leading letter, seven digits and a check letter. The tax administration and the police issue it, and it is required for any transaction with tax relevance in Spain, such as employment, property purchase or company participation.
Category of business identifiers. Identifier category Personal 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/ES NIE/format Validates the format of the Spanish NIE, the foreigner identification number that serves as the tax number of natural persons without Spanish nationality who take part in transactions subject to Spanish taxation. The pattern accepts a leading X, Y or Z, seven digits and a final check letter. IDENTIFIER_FORMAT
^(X|Y|X)\d{7}\w{1}$

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 inaccurate (Numero de Identificacion de Extranjero (Spain))
REPRESENTATIONAL_CONSISTENCY
ES (Spain) The Spanish Numero de Identificacion de Extranjero consists of a letter followed by seven digits and one checksum letter. This rule checks whether the value is written exactly in that reference format and flags any whitespace, hyphen or dot that the format does not provide for. INFO IDEA(2020-01-01)
Identifier format invalid (Numero de Identificacion de Extranjero (Spain))
REPRESENTATIONAL_CONSISTENCY
ES (Spain) The Spanish NIE is the equivalent of the NIF for foreigners and has the format of one letter, seven digits and one further letter. This rule checks that exactly nine characters matching that pattern are present. ERROR RELEASED(2020-01-01)
Invalid checksum of Numero de Identificacion de Extranjero (Spain)
ACCURACY
ES (Spain) This rule verifies the checksum letter of the Spanish Numero de Identificacion de Extranjero. The leading letter is first replaced by a digit, with X becoming 0, Y becoming 1 and Z becoming 2. The resulting eight-digit number is divided by 23 and the remainder is translated into a letter according to the reference table defined for the identifier. A value whose letter does not match is flagged. ERROR RELEASED(2021-09-10)