FR_SIREN (FR - National Business ID)

From CDQ Wiki
DataModel:CDQ/Business Partner/Identifier/FR SIREN
Jump to navigation Jump to search
Property Value
A technical identifier, unique in a certain context. Technical key FR_SIREN
The country a linked concept is active or generally relevant for. Country scope FR (France)
Language-specific name. Monolingual name Système d'identification du répertoire des entreprises (fr), National business identifier (en)
Language-specific short name. Monolingual short name FR - National Business ID (en)
Informal and comprehensive human-readable definition of a concept. Description The SIREN number, from Système d'identification du répertoire des entreprises, is the nine-digit French business identifier issued by the statistics institute INSEE when a business is entered in the national business register. Every French authority asks for it, since it proves that a partner is a fully registered French business, and it is quoted on invoices and contracts.
Category of business identifiers. Identifier category Tax Number
Legacy property. A technical SAP code. SAP mapping STCD2

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/FR SIREN/format Validates the format of the French SIREN number, the unique nine-digit business identifier that every French authority asks for as proof that a business partner is registered. The pattern accepts nine digits, which may be written with spaces, dots or hyphens between them. IDENTIFIER_FORMAT
^(\d\s*\.*-*){9}$

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 (SIREN number (France))
REPRESENTATIONAL_CONSISTENCY
FR (France) The French SIREN number consists of exactly nine numerical digits. This rule checks whether the value is written exactly in that reference format and flags any whitespace, hyphen or dot it contains. INFO IDEA(2020-01-01)
Identifier format invalid (SIREN (France))
REPRESENTATIONAL_CONSISTENCY
FR (France) The French SIREN number consists of exactly nine numerical digits. This rule checks that exactly nine digits are present, disregarding any whitespaces, hyphens or dots in the value. A value with fewer or more digits, or with non-numeric characters, violates the rule. ERROR RELEASED(2020-01-01)
Identifier missing (SIREN number (France))
COMPLETENESS
FR (France) Every legal entity in France is expected to hold a SIREN number. This rule reports records for which the identifier has not been maintained. WARNING RELEASED(2020-05-07)
Identifier unknown (SIREN number (France))
ACCURACY
FR (France) This rule validates the French SIREN number against the French register of companies. The SIREN number counts as valid when it is available in that register, and is flagged when it is not. ERROR RELEASED(2024-04-16)
Inconsistency between SIREN and EU VAT ID (France)
CONSISTENCY
FR (France) The SIREN number is the French company register identifier and consists of nine digits. The French VAT number is built from it as the prefix FR, two calculated digits and then exactly the nine digits of the SIREN.

This rule checks that both a SIREN number and a French European VAT number are present and that the last nine digits of the VAT number are identical to the SIREN. If they are not, either the SIREN or the VAT identifier is wrong.

ERROR RELEASED(2020-12-28)
Inconsistency between SIREN and SIRET number (France)
CONSISTENCY
FR (France) The French SIRET number consists of fourteen digits whose first nine are the SIREN number. This rule checks that the SIREN number matches the first nine digits of the SIRET, and any difference results in a rule violation. ERROR RELEASED(2020-01-01)
Invalid checksum of FR SIREN (France)
ACCURACY
FR (France) This rule verifies the check digit of the French SIREN. The ninth digit of the SIREN is the check digit and it is validated with a modulus 10 calculation. A SIREN whose check digit does not match is flagged. ERROR RELEASED(2020-10-12)