Data source FR.RC
From CDQ
Data source/FR.RC /
Jump to navigation
Jump to search
| Name | ALEI prefix The ALEI prefix element is the ISO 3166-2 code for country and subdivision if applicable followed by the stop character ‘.’ This is followed by an acronym representing the register maintained by the administrative agency for the governing body of a nation, state, or community that assigned the identifier element. The prefix is assigned by ECCMA: FR.RC, Full name (en) English name of a concept.: France Register of Companies, Short name Defines the name of a concept. Consits of “Country or Subdivision” + “Registry name”: France Company Register, Local name Defines the name of a concept in a local language.: Répertoire administratif SIRENE
|
|---|---|
| Technical key Defines a unique key by which e.g. data model concepts can be referenced in a technical integration context. These keys are unique in the CDL context. | FR_RC
|
| Short description Informal and short human-readable definition of a concept. | Commercial register of France. |
| Description Informal and comprehensive human-readable definition of a concept. | Allows to verify the validity of French business identifiers (SIREN number (France), SIRET number (France)) and gather additional information about the company status, registered address, and names. |
| Credential type(s) | n/a |
| Country scope Defines a address/country a given concept is used in (or valid in, or relevant for etc.), i.e. the country-specific scope of a concept. | FR (Frankreich, France, France, 法国) |
| Provider Provider or authority of a data source. | Institut national de la statistique et des études économiques, Search type Describes how data can be searched in the data source: By address and name attributes (FUZZY) or just identifier based (IDENTIFIER).: FUZZY, website, manual search
|
| Release status The release status in terms of development progress or maturity of a product feature or a business capability.<br/><code>EMPTY</code> (0): No feature considered yet, just rough idea for capability.<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; nonetheless, we continue to offer the most recent available data. | LIVE , Integration type Documents how a data source is integrated into the CDL with respect to data gathering:* <code>REMOTE ACCESS</code>: Data is not stored on CDL side but queried ad-hoc from the data source (e.g. webservices)* <code>COPY</code>: Data is replicated on CDL side (usually already transformed into the target CDL data model)* <code>UNDEFINED</code>: not yet known: COPY
|
| Content and data model | Category Specifies the category of a data source. The following categories are defined:<br/><code>BUSINESS_PARTNER</code>: The data source provides master data about companies.<br/><code>ADDRESS</code>: The data source provides address reference data.<br/><code>SANCTION_AND_WATCHLIST</code>: A data source that provides sanctioned or watched companies or persons.<br/><code>BANK_ACCOUNT</code>: The data source provides bank and bank account reference data.<br/><code>CERTIFICATE</code>: The data source provides information about business partner certifications.<br/><code>BENEFICIAL_OWNER</code>: The data source provides information about beneficial owners of companies.<br/><code>INSOLVENCY</code>: The data source provides information about insolvencies.<br/><code>HEALTHCARE_PROFESSIONAL</code>: The data source provides information about HCPs.<br/><code>HEALTHCARE_ORGANIZATION</code>: The data source provides information about HCOs.<br/>: BUSINESS_PARTNER, Number of records Counts the number of company records available in the data source: 41,263,740 records (last update The last date when copied data from a data source was updated.: 2025-05-04), 71 concepts, 263 values, 73 mappings, 1 transformations
|
| Linkage strategy Describes how business partners are linked to this data source, e.g. for activating update monitoring. Typically just a primary identifier of the data source is used such as a business register id. However, in some cases the linkage strategy might be much more complex. | SIRET number (France) |
| Managed concepts Concepts of the CDQ Data Model which are mapped to concepts provided by this data source "Data source/FR.RC". | Expand
See mapped concepts
|
| Managed identifier(s) identifiers of the CDQ Data Model which are mapped to identifier information provided by this data source, (FR.RC). | Expand
See mapped identifiers
|
| Augmented records This data source may be used to compile augmented records. | Expand
See how data source is used
Primary data source The primary data source is the main data source used for augmented records. If a primary data source is defined, all values of a corresponding match are taken over into the augmented record.: Preferred data source Preferred data sources (one could also say "secondary data sources") are the data sources from which values of augmented records are taken over when </br>* a) there is no primary data source defined or </br>* b) there is no matching record in the primary data source (rare case and should not happen) or </br>* c) there are values that are not provided by the primary data source.</br>If there are several matches from different preferred data sources then </br>* a) the best match of all preferred data sources is taken, then the second, etc. </br>* b) the first data source is taken by coincidence, then a second one by coincidence etc.: n/a Other data source The "other" data sources contain valuable and enrichable information like identifiers, however should not be considered as a “base record” when creating golden records.: n/a Unallowed data source Augmented records do not make use of matches of unallowed data sources.: n/a |
| Quota This data source may be subject to quota limitations. | Expand
See which default quota limits apply
|
| Update monitoringThis data source may be subject to update monitoring. | Expand
See details of update monitoring
|
| Classification Framework to classify external data sources according to legal limitations and/or obligations due to integration and use of these data sources in CDQ's Cloud Services. | Data ownership Categorizes legal right-holding by the type of the data owner, e.g. a private organization or a governmental authority.: GOVERNMENTALData source is owned by a governmental body, e.g., a federal, state, or municipal authority., Data provision Categorizes restriction of data access, i.e., whether data sources provide "open" data or require registration.: OPENData is provided for free and unlimited access without registration or subscription., Terms type A client or CDQ accepts the terms of use of a particular data source and the compliant use of its data.: CDQ_CONTRACTEDCDQ accepts the terms of a particular data source and the compliant use of its data., legal approval: 2020-01-01, legal approval level: 2024-09-19
Licence URL URL that provides information on the licence of the target: https://www.etalab.gouv.fr/wp-content/uploads/2018/11/open-licence.pdf |
Concepts
| Concept | Parent | Description |
|---|---|---|
| activitePrincipaleEtablissement (FR.RC) | etablissementValue () | |
| activitePrincipaleRegistreMetiersEtablissement (FR.RC) | etablissementValue () | |
| activitePrincipaleUniteLegale (FR.RC) | uniteLegale (FR.RC) | Main business activity of the entity. INSEE assigns a so-called "APE" code to any entity on the basis of the description of the main activity made by the entity.This code can be modified during the life of the legal unit according to the declarations. For each legal unit, there is at a given moment a single “APEN” code. |
| anneeCategorieEntreprise (FR.RC) | uniteLegale (FR.RC) | The year from which the company has been valid in a given business category |
| anneeEffectifsEtablissement (FR.RC) | etablissementValue () | |
| anneeEffectifsUniteLegale (FR.RC) | uniteLegale (FR.RC) | |
| caractereEmployeurEtablissement (FR.RC) | etablissementValue () | Employer character of the legal unit. If there are no employees it will be N, it there are it will be O
O: employer establishment N: non-employer establishment null: not applicable |
| caractereEmployeurUniteLegale (FR.RC) | uniteLegale (FR.RC) | During business etablishment, the declarant indicates whether or not the legal unit will have employees
O employing legal unit N non-employing legal unit |
| categorieEntreprise (FR.RC) | uniteLegale (FR.RC) | Business category type
|
| categorieJuridiqueUniteLegale (FR.RC) | uniteLegale (FR.RC) | It's a code which indicates legal form of business entity |
| codeCedexEtablissement (FR.RC) | etablissementValue () | |
| codeCommune2Etablissement (FR.RC) | etablissementValue () | Code of the locality where the establishment is located, excluding the foreign address, line 2 |
| codeCommuneEtablissement (FR.RC) | etablissementValue () | Code of the locality where the establishment is located, excluding the foreign address. |
| codePaysEtrangerEtablissement (FR.RC) | etablissementValue () | |
| codePostal2Etablissement (FR.RC) | etablissementValue () | Postal Code, line 2 |
| codePostalEtablissement (FR.RC) | etablissementValue () | Postal Code |
| complementAdresseEtablissement (FR.RC) | etablissementValue () | |
| dateCreationEtablissement () | Date of entity establishment | |
| dateCreationUniteLegale (FR.RC) | uniteLegale (FR.RC) | Creation date of Legal Entity |
| dateDebut (FR.RC) | etablissementValue () | |
| dateDebut (FR.RC) | uniteLegale (FR.RC) | Start date of the period during which business entity data remain unchanged. |
| dateDernierTraitementEtablissement (FR.RC) | etablissementValue () | Date of the last updates of data in the Siren register |
| dateDernierTraitementUniteLegale (FR.RC) | uniteLegale (FR.RC) | Last changes date |
| denominationUniteLegale (FR.RC) | uniteLegale (FR.RC) | |
| denominationUsuelle1UniteLegale (FR.RC) | uniteLegale (FR.RC) | Name by which the company is known to the general public. |
| denominationUsuelleEtablissement (FR.RC) | etablissementValue () | |
| distributionSpecialeEtablissement (FR.RC) | etablissementValue () | |
| economieSocialeSolidaireUniteLegale (FR.RC) | uniteLegale (FR.RC) | |
| enseigne2Etablissement (FR.RC) | etablissementValue () | Entity Name line 2 |
| entity (FR.RC) | Entity container | |
| etablissementSiege (FR.RC) | etablissementValue () | Boolean value that indicates whether or not the establishment is the headquarters of the legal unit. |
| etablissementValue () | Container for entity establishment | |
| etatAdministratifEtablissement (FR.RC) | etablissementValue () | |
| etatAdministratifUniteLegale (FR.RC) | uniteLegale (FR.RC) | The administrative status of an entity establishment
|
| identifiantAssociationUniteLegale (FR.RC) | uniteLegale (FR.RC) | National Register of Associations Identifier |
| indiceRepetitionEtablissement (FR.RC) | etablissementValue () | |
| libelleCedexEtablissement (FR.RC) | etablissementValue () | |
| libelleCommune2Etablissement (FR.RC) | etablissementValue () | Locality name, line 2 |
| libelleCommuneEtablissement (FR.RC) | etablissementValue () | Locality name |
| libelleCommuneEtrangerEtablissement (FR.RC) | etablissementValue () | |
| libellePaysEtrangerEtablissement (FR.RC) | etablissementValue () | |
| libelleVoie2Etablissement () | Street, line 2 | |
| libelleVoieEtablissement (FR.RC) | etablissementValue () | Street |
| nic (FR.RC) | etablissementValue () | The internal classification number makes it possible to distinguish the establishments of the same company. It is composed of 5 digits. Associated with the Siren, it forms the establishment's Siret |
| nicSiegeUniteLegale (FR.RC) | uniteLegale (FR.RC) | The internal classification number makes it possible to distinguish the establishments of the same company. It is composed of 5 digits. Associated with the Siren, it forms the establishment's Siret |
| nomUniteLegale (FR.RC) | uniteLegale (FR.RC) | Natural person name. Variable is null for legal persons. |
| nomUsageUniteLegale (FR.RC) | uniteLegale (FR.RC) | |
| nombrePeriodesEtablissement (FR.RC) | etablissementValue () | Number of periods of establishment ([startDate, endDate] of the establishment) Each period corresponds to the time interval during which establishment have not changed. |
| nombrePeriodesUniteLegale (FR.RC) | uniteLegale (FR.RC) | Number of periods of legal unit |
| nomenclatureActivitePrincipaleEtablissement (FR.RC) | etablissementValue () | Activity classification. This variable indicates the nomenclature of activity corresponding to the variable activityPrincipaleEstablishment
Codes: NAFRev2 NAFRev1 NAF1993 NAP |
| nomenclatureActivitePrincipaleUniteLegale (FR.RC) | uniteLegale (FR.RC) | This variable indicates business activity corresponding to the activitePrincipaleUniteLegale variable. |
| numeroVoie2Etablissement () | Number of Street, line 2 | |
| numeroVoieEtablissement (FR.RC) | etablissementValue () | Number of Street |
| prenom1UniteLegale (FR.RC) | uniteLegale (FR.RC) | First name declared for a natural person. |
| prenom2UniteLegale (FR.RC) | uniteLegale (FR.RC) | Second name declared for a natural person. |
| prenom3UniteLegale (FR.RC) | uniteLegale (FR.RC) | Third name declared for a natural person. |
| prenom4UniteLegale (FR.RC) | uniteLegale (FR.RC) | Forth name declared for a natural person. |
| prenomUsuelUniteLegale (FR.RC) | uniteLegale (FR.RC) | First name by which a person chooses to be called in everyday life. It corresponds usually with the prenom1UniteLegale. This variable is null for legal persons. |
| sexeUniteLegale (FR.RC) | uniteLegale (FR.RC) | Female or male character of the natural person.If it's legal form then field will be empty |
| sigleUniteLegale (FR.RC) | uniteLegale (FR.RC) | |
| siren (FR.RC) | etablissementValue () | |
| siren (FR.RC) | uniteLegale (FR.RC) | The SIREN number is the unique business identifier in France. This 9 digit number will be requested by all French administration dealing with the business partner, as it is a proof that the business partner is a fully registered French business, listed on the national business directory |
| siret (FR.RC) | etablissementValue () | The SIRET number is issued once a business partner registers the business in the Chambre de Commerce (RCS) for trade, Chambre de Metiers for crafts and manual work or with URSSAF for intellectual services such as translator or website designer. SIRET is a 14 digit number referring to each business location (SIREN + 5 digits). |
| statutDiffusionEtablissement (FR.RC) | etablissementValue () | Status of the entity establishment.
Codes:
|
| statutDiffusionUniteLegale (FR.RC) | uniteLegale (FR.RC) | Variable indicating the dissemination status of the legal unit.
Only legal units that can be disseminated are accessible (statusDiffusionUniteLegale = O). Legal units that cannot be disseminated (statusDiffusionUniteLegale = N) are identifiable by the siren service. |
| trancheEffectifsEtablissement (FR.RC) | etablissementValue () | Number of Employes:
NN - no employees 00: 0 Employees (Not having employees at last day of year, but during the year there was someone employeed) 01: 1 or 2 employees 02: 3 to 5 employees 03: 6 to 9 employees 11: 10 to 19 employees 12: 20 to 49 employees 21: 50 to 99 employees 22: 100 to 199 employees 31: 200 to 249 employees 32: 250 to 499 employees 41: 500 to 999 employees 42: 1,000 to 1,999 employees 51: 2,000 to 4,999 employees 52: 5,000 to 9,999 employees 53: 10,000 employees and more |
| trancheEffectifsUniteLegale (FR.RC) | uniteLegale (FR.RC) | Number of Employes:
NN - no employees 00: 0 Employees (Not having employees at last day of year, but during the year there was someone employeed) 01: 1 or 2 employees 02: 3 to 5 employees 03: 6 to 9 employees 11: 10 to 19 employees 12: 20 to 49 employees 21: 50 to 99 employees 22: 100 to 199 employees 31: 200 to 249 employees 32: 250 to 499 employees 41: 500 to 999 employees 42: 1,000 to 1,999 employees 51: 2,000 to 4,999 employees 52: 5,000 to 9,999 employees 53: 10,000 employees and more |
| typeVoie2Etablissement (FR.RC) | etablissementValue () | Street type, line 2:
ALL: Driveway AV: Avenue BD: Boulevard CAR: Carrefour CHE: Path CHS: Road CITE: City COR: Cornice CRS: Course DOM: Domain DSC: Descent ECA: Difference ESP: Esplanade FG: Suburb GR: Grande Rue HAM: Hamlet HLE: Hall IMP: Dead end LD: Place says LOT: Allotment TUE: Market MTE: Climb PAS: Passage PL: Place PLN: Plain PLT: Tray PRO: Walk PRV: Parvis QUA: Neighborhood QUAY: Quay RES: Residence RLE: Alley ROC: Ring road RPT: Roundabout RTE: Road STREET: Street SEN: Sente - Path SQ: Square TPL: Plot TRA: Traverse VLA: Villa VLGE: Village |
| typeVoieEtablissement (FR.RC) | etablissementValue () | Street type:
ALL: Driveway AV: Avenue BD: Boulevard CAR: Carrefour CHE: Path CHS: Road CITE: City COR: Cornice CRS: Course DOM: Domain DSC: Descent ECA: Difference ESP: Esplanade FG: Suburb GR: Grande Rue HAM: Hamlet HLE: Hall IMP: Dead end LD: Place says LOT: Allotment TUE: Market MTE: Climb PAS: Passage PL: Place PLN: Plain PLT: Tray PRO: Walk PRV: Parvis QUA: Neighborhood QUAY: Quay RES: Residence RLE: Alley ROC: Ring road RPT: Roundabout RTE: Road STREET: Street SEN: Sente - Path SQ: Square TPL: Plot TRA: Traverse VLA: Villa VLGE: Village |
| uniteLegale (FR.RC) | entity (FR.RC) | Container for entity establishment |
| unitePurgeeUniteLegale (FR.RC) | uniteLegale (FR.RC) |
Concept mappings
Values
Value mappings
Transformations
Retrieved from "https://meta.cdq.com/index.php?title=Data_source/FR.RC&oldid=714383"