IT_FISC_ID (IT - Tax Identification Number)

From CDQ Wiki
DataModel:CDQ/Business Partner/Identifier/IT FISC ID
Jump to navigation Jump to search
Property Value
A technical identifier, unique in a certain context. Technical key IT_FISC_ID
The country a linked concept is active or generally relevant for. Country scope IT (Italy)
Language-specific name. Monolingual name Codice Fiscale. (it), Tax Identification Number (en)
Language-specific short name. Monolingual short name IT - Tax Identification Number (en)
Informal and comprehensive human-readable definition of a concept. Description The codice fiscale is the Italian tax identification number, made up of sixteen characters for natural persons and freelancers, derived from name, date and place of birth, while entities normally carry an eleven-digit number that is identical to their VAT number. It is required for employment, contracts, invoices and any dealing with the Italian authorities.
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/IT FISC ID/format Validates the format of the Italian fiscal code (codice fiscale), the tax identifier of natural persons that encodes name, date of birth and place of birth, and of the eleven-digit fiscal number used by companies. The pattern accepts both the sixteen-character personal code and the eleven-digit company number. IDENTIFIER_FORMAT
^([A-Z]\s*\.*-*){6}([0-9LMNPQRSTUV]\s*\.*-*){2}([ABCDEHLMPRST]\s*\.*-*)([0-9LMNPQRSTUV]\s*\.*-*){2}([A-Z]\s*\.*-*)([0-9LMNPQRSTUV]\s*\.*-*){3}[A-Z]$|^(\d[\s.-]*){10}\d$

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 (Fiscal code (Italy))
REPRESENTATIONAL_CONSISTENCY
IT (Italy) In Italy the tax number can take one of two forms: eleven digits for legal entities, which are the Italian European VAT identifier without its IT prefix, or sixteen alphanumeric characters for freelancers and natural persons.

The sixteen-character form is known as the Codice Fiscale and follows a fixed structure. The first three characters are letters derived from the last name and the next three are letters derived from the first name. Positions seven and eight are digits for the year of birth, position nine is a letter for the month of birth, and positions ten and eleven are digits encoding the day of birth and the sex. Positions twelve to fifteen are one letter followed by three digits identifying the Italian town or the foreign country of birth, and the sixteenth character is a checksum character that serves a supervisory function. This rule flags a fiscal code that does not follow this structure.

ERROR RELEASED(2020-01-01)
Identifier format inaccurate (Fiscal code (Italy))
REPRESENTATIONAL_CONSISTENCY
IT (Italy) In Italy the tax number can take one of two forms: eleven digits for legal entities, which are the Italian European VAT identifier without its IT prefix, or sixteen alphanumeric characters for freelancers and natural persons.

The fiscal code proper consists of sixteen characters. This rule checks whether the value is written exactly in the reference format of the fiscal code and flags any whitespace, dot or hyphen it contains.

INFO IDEA
Identifier missing (Fiscal code (Italy))
COMPLETENESS
IT (Italy) A business partner in Italy requires a fiscal code, and this rule reports records in which it has not been maintained. INFO RELEASED(2024-04-16)
Invalid checksum of Fiscal code (Italy)
ACCURACY
IT (Italy) This rule checks the checkdigit of the Fiscal code (Italy). This checksum rule should be applied only for the identifier which is 16 characters long. In case of 11 digits the same logic as here shoule be applied: https://meta.cdq.ch/Invalid_checksum_of_EU_VAT_ID_IT_(Italy) for checking the checksum.

The checksum is done in the following way. Starting from the preceding 15 characters, a check digit is determined as follows:

  • the eight odd characters (1st, 3rd, 5th, etc.) are set apart, the remainder (Modulo) will give the last character, according to the following table:, same thing for the seven even ones (2nd, 4th, 6th, etc.).
  • after that, each single character is converted into a numeric value as show in the tables below:
  • after that, all of the values are to be added up, and the final result has to be divided by 26
ERROR HYPERCARE
Mandatory identifier not maintained (Italy)
COMPLETENESS
IT (Italy) A business partner in Italy should carry at least one of two identifiers: the Italian European value added tax identifier or the Italian fiscal code. If neither is available, the record is invalid. ERROR RELEASED(2024-04-16)