FR.RC (data source)
DataSource:FR.RC
| Property | Value |
|---|---|
| Identifiers | FR.RC (The ALEI prefix element is the ISO 3166-2 code for country and subdivision if applicable followed by the stop character <code>.</code>. 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 ALEI prefix), FR_RC (A technical identifier, unique in a certain context. Technical key)
|
| Language-specific short name. Monolingual short name | France Company Register (en) |
| Language-specific name. Monolingual name | France Register of Companies (en), Répertoire administratif SIRENE (fr) |
| An informal and short human-readable definition of a concept, in terms of a 'one-liner'. Short description | France Register of Companies is a data source that helps CDQ customers validate and enrich business partner master data for compliance and data quality. |
| The country a linked concept is active or generally relevant for. Country scope | FR (France) |
| Data access | Institut national de la statistique et des études économiques (Provider or authority of a data source. Provider), website (URL that provides more information for a given concept. URL), FUZZY (Search type (data sources)<br/>Describes how data can be searched in a data source.<br/><code>FUZZY</code>: Data can be searched by address and name attributes.<br/><code>IDENTIFIER</code>: Data can be searched by business identifiers.<br/><code>INDEX</code>: Data can be searched by business identifiers. Search type)
|
| nonetheless, we continue to offer the most recent available data., The release status in terms of development progress or maturity.<br/><code>EMPTY</code> (0): No feature considered yet, just a rough idea.<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 Release status | LIVE, COPY (Documents how a data source is integrated into the CDL with respect to data gathering:<br/><code>REMOTE ACCESS</code>: Data is not stored on CDL side but queried ad-hoc from the data source (e.g. webservices)<br/><code>COPY</code>: Data is replicated on CDL side (usually already transformed into the target CDL data model)<br/><code>UNDEFINED</code>: not yet known Integration type)
|
| Content | BUSINESS_PARTNER (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. Data source category), 42,301,722 (Counts the number of company records available in the data source. Number of records) , 72 concepts, 258 terms
|
| Legal classification | 2020-01-01 (Date when a legal classification was approved (the last time). Legal approval), GOVERNMENTAL (Data ownership<br/>Categorizes legal right-holding by the type of the data owner, e.g. a private organization or a governmental authority.<br/><code>GOVERNMENTAL</code>: The data source is owned by a governmental body, e.g., a federal, state, or municipal authority.<br/><code>PRIVATE</code>: The data source is owned by a private body, e.g., a company or an association. Data ownership), OPEN (Data provision<br/>Categorizes restriction of data access, i.e., whether a data source provides "open" data or requires registration.<br/><code>COMMERCIAL</code>: Data is not provided for free, but users of the data source have to pay for downloading, querying, or using the data according to a commercial contract.<br/><code>FREE</code>: Data is provided for free, but the data source requires registration, i.e., authentication when data is downloaded or queried.<br/><code>OPEN</code>: Data is provided for free and unlimited access without registration or subscription. Data provision), CDQ_CONTRACTED (Terms type<br/>A client or CDQ accepts the terms of use of a particular data source and the compliant use of its data.<br/><code>CDQ_CONTRACTED</code>: CDQ accepts the terms of a particular data source and the compliant use of its data.<br/><code>CLIENT_CONTRACTED</code>: A client (i.e., the data end user) accepts the terms of a particular data source and the compliant use of its data.<br/><code>EU_PRIVATE</code>: The data source is provided by a private organization under EU law, i.e., from "within" a EU member country.<br/><code>EU_PUBLIC</code>: The data source is provided by a governmental organization under EU law, i.e., from "within" a EU member country.<br/><code>NO_TERMS</code>: No specific terms of use are provided for a data source.<br/><code>STANDARD_LICENCE</code>: A standard licence is used, further details are provided by license type information of the data source. Terms type), https://www.etalab.gouv.fr/wp-content/uploads/2018/11/open-licence.pdf (URL that provides more information on a license, e.g., of a data source. License URL)
|
| Quota | 250,000 (The default maximum quota for a data source. Maximum Quota (default)), MONTH (Quota reset<br/>The default reset period of a defined quota for a data source.<br/><code>DAY</code>: The quota of the data source is reset daily.<br/><code>MONTH</code>: The quota of the data source is reset monthly.<br/><code>WEEK</code>: The quota of the data source is reset weekly.<br/><code>YEAR</code>: The quota of the data source is reset yearly. Quota reset (default)), CDQ (Quota control<br/>The control of changing the maximum quota and reset period for a data source.<br/><code>CDQ</code>: The quota of the data source can be higher than set by CDQ.<br/><code>CLIENT</code>: The quota of the data source can be set higher than the default.<br/><code>CREDENTIAL_DEPENDENT</code>: If a customer uses CDQ credentials to assess the data source then the quota can't be higher than the default, but if customers use their own credentials, then the quota can be increased. Quota control), NO (Quota enablement<br/>whether the quota management is turned on for a specific data source.<br/><code>NO</code>: The data source does not have an enabled quota.<br/><code>YES</code>: A quota is enabled for the data source. Quota enabled)
|
| Linkage strategy | Linkage strategy for data source FR.RC and country FR |
| Update monitoring | YES (Update monitor enablement<br/>whether the update monitoring is turned on for a specific data source.<br/><code>NO</code>: For the data source, no update monitor is enabled.<br/><code>YES</code>: An update monitor is enabled for the data source. Update monitoring enabled), Every 10th day of the month (Date and time when a data source is checked to find updates. Update frequency)
|
Managed business identifiers
| Identifier | Technical name | Parent | Description | CDQ mapping |
|---|---|---|---|---|
| identifiantAssociationUniteLegale (FR.RC) | uniteLegale_identifiantAssociationUniteLegale | uniteLegale (FR.RC) | National Register of Associations Identifier | Value (CDQ) |
| siren (FR.RC) | etablissementValue_siren | etablissementValue (FR.RC) | Value (CDQ) |
Data model concepts
| Concept | Technical name | Parent | Description | CDQ mapping |
|---|---|---|---|---|
| activitePrincipaleEtablissement (FR.RC) | etablissementValue_activitePrincipaleEtablissement | etablissementValue (FR.RC) | ||
| activitePrincipaleRegistreMetiersEtablissement (FR.RC) | etablissementValue_activitePrincipaleRegistreMetiersEtablissement | etablissementValue (FR.RC) | ||
| activitePrincipaleUniteLegale (FR.RC) | uniteLegale_activitePrincipaleUniteLegale | 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_anneeCategorieEntreprise | uniteLegale (FR.RC) | The year from which the company has been valid in a given business category | |
| anneeEffectifsEtablissement (FR.RC) | etablissementValue_anneeEffectifsEtablissement | etablissementValue (FR.RC) | ||
| anneeEffectifsUniteLegale (FR.RC) | uniteLegale_anneeEffectifsUniteLegale | uniteLegale (FR.RC) | ||
| caractereEmployeurEtablissement (FR.RC) | etablissementValue_caractereEmployeurEtablissement | etablissementValue (FR.RC) | 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_caractereEmployeurUniteLegale | 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_categorieEntreprise | uniteLegale (FR.RC) | Business category type
| |
| categorieJuridiqueUniteLegale (FR.RC) | uniteLegale_categorieJuridiqueUniteLegale | uniteLegale (FR.RC) | It's a code which indicates legal form of business entity | Legal Form (CDQ) |
| codeCedexEtablissement (FR.RC) | etablissementValue_codeCedexEtablissement | etablissementValue (FR.RC) | ||
| codeCommune2Etablissement (FR.RC) | etablissementValue_codeCommune2Etablissement | etablissementValue (FR.RC) | Code of the locality where the establishment is located, excluding the foreign address, line 2 | |
| codeCommuneEtablissement (FR.RC) | etablissementValue_codeCommuneEtablissement | etablissementValue (FR.RC) | Code of the locality where the establishment is located, excluding the foreign address. | |
| codePaysEtrangerEtablissement (FR.RC) | etablissementValue_codePaysEtrangerEtablissement | etablissementValue (FR.RC) | Value (CDQ) | |
| codePostal2Etablissement (FR.RC) | etablissementValue_codePostal2Etablissement | etablissementValue (FR.RC) | Postal Code, line 2 | |
| codePostalEtablissement (FR.RC) | etablissementValue_codePostalEtablissement | etablissementValue (FR.RC) | Postal Code | Value (CDQ) |
| complementAdresseEtablissement (FR.RC) | etablissementValue_complementAdresseEtablissement | etablissementValue (FR.RC) | Value (CDQ) | |
| dateCreationEtablissement (FR.RC) | etablissementValue_dateCreationEtablissement | etablissementValue (FR.RC) | Date of entity establishment | |
| dateCreationUniteLegale (FR.RC) | uniteLegale_dateCreationUniteLegale | uniteLegale (FR.RC) | Creation date of Legal Entity | |
| dateDebut (FR.RC) | etablissementValue_dateDebut | etablissementValue (FR.RC) | ||
| dateDebut (FR.RC) | uniteLegale_dateDebut | uniteLegale (FR.RC) | Start date of the period during which business entity data remain unchanged. | |
| dateDernierTraitementEtablissement (FR.RC) | etablissementValue_dateDernierTraitementEtablissement | etablissementValue (FR.RC) | Date of the last updates of data in the Siren register | Ended At (CDQ) |
| dateDernierTraitementUniteLegale (FR.RC) | uniteLegale_dateDernierTraitementUniteLegale | uniteLegale (FR.RC) | Last changes date | |
| denominationUniteLegale (FR.RC) | uniteLegale_denominationUniteLegale | uniteLegale (FR.RC) | Value (CDQ) | |
| denominationUsuelle1UniteLegale (FR.RC) | uniteLegale_denominationUsuelle1UniteLegale | uniteLegale (FR.RC) | Name by which the company is known to the general public. | |
| denominationUsuelleEtablissement (FR.RC) | etablissementValue_denominationUsuelleEtablissement | etablissementValue (FR.RC) | ||
| distributionSpecialeEtablissement (FR.RC) | etablissementValue_distributionSpecialeEtablissement | etablissementValue (FR.RC) | ||
| economieSocialeSolidaireUniteLegale (FR.RC) | uniteLegale_economieSocialeSolidaireUniteLegale | uniteLegale (FR.RC) | ||
| enseigne1Etablissement (FR.RC) | etablissementValue_enseigne1Etablissement | etablissementValue (FR.RC) | Entity Name line 1 | |
| enseigne2Etablissement (FR.RC) | etablissementValue_enseigne2Etablissement | etablissementValue (FR.RC) | Entity Name line 2 | |
| entity (FR.RC) | entity | Entity container | ||
| etablissementSiege (FR.RC) | etablissementValue_etablissementSiege | etablissementValue (FR.RC) | Boolean value that indicates whether or not the establishment is the headquarters of the legal unit. | Business Partner Type Technical Key Param (CDQ) |
| etablissementValue (FR.RC) | etablissementValue | entity (FR.RC) | Container for entity establishment | |
| etatAdministratifEtablissement (FR.RC) | etablissementValue_etatAdministratifEtablissement | etablissementValue (FR.RC) | The administrative status of a legal entity
| |
| etatAdministratifUniteLegale (FR.RC) | uniteLegale_etatAdministratifUniteLegale | uniteLegale (FR.RC) | The administrative status of an entity establishment
| |
| identifiantAssociationUniteLegale (FR.RC) | uniteLegale_identifiantAssociationUniteLegale | uniteLegale (FR.RC) | National Register of Associations Identifier | Value (CDQ) |
| indiceRepetitionEtablissement (FR.RC) | etablissementValue_indiceRepetitionEtablissement | etablissementValue (FR.RC) | ||
| libelleCedexEtablissement (FR.RC) | etablissementValue_libelleCedexEtablissement | etablissementValue (FR.RC) | ||
| libelleCommune2Etablissement (FR.RC) | etablissementValue_libelleCommune2Etablissement | etablissementValue (FR.RC) | Locality name, line 2 | |
| libelleCommuneEtablissement (FR.RC) | etablissementValue_libelleCommuneEtablissement | etablissementValue (FR.RC) | Locality name | Value (CDQ) |
| libelleCommuneEtrangerEtablissement (FR.RC) | etablissementValue_libelleCommuneEtrangerEtablissement | etablissementValue (FR.RC) | ||
| libellePaysEtrangerEtablissement (FR.RC) | etablissementValue_libellePaysEtrangerEtablissement | etablissementValue (FR.RC) | ||
| libelleVoie2Etablissement (FR.RC) | etablissementValue_libelleVoie2Etablissement | etablissementValue (FR.RC) | Street, line 2 | |
| libelleVoieEtablissement (FR.RC) | etablissementValue_libelleVoieEtablissement | etablissementValue (FR.RC) | Street | |
| nic (FR.RC) | etablissementValue_nic | etablissementValue (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 | |
| nicSiegeUniteLegale (FR.RC) | uniteLegale_nicSiegeUniteLegale | 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_nomUniteLegale | uniteLegale (FR.RC) | Natural person name. Variable is null for legal persons. | |
| nomUsageUniteLegale (FR.RC) | uniteLegale_nomUsageUniteLegale | uniteLegale (FR.RC) | ||
| nombrePeriodesEtablissement (FR.RC) | etablissementValue_nombrePeriodesEtablissement | etablissementValue (FR.RC) | 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_nombrePeriodesUniteLegale | uniteLegale (FR.RC) | Number of periods of legal unit | |
| nomenclatureActivitePrincipaleEtablissement (FR.RC) | etablissementValue_nomenclatureActivitePrincipaleEtablissement | etablissementValue (FR.RC) | Activity classification. This variable indicates the nomenclature of activity corresponding to the variable activityPrincipaleEstablishment
Codes: NAFRev2 NAFRev1 NAF1993 NAP | |
| nomenclatureActivitePrincipaleUniteLegale (FR.RC) | uniteLegale_nomenclatureActivitePrincipaleUniteLegale | uniteLegale (FR.RC) | This variable indicates business activity corresponding to the activitePrincipaleUniteLegale variable. | |
| numeroVoie2Etablissement (FR.RC) | etablissementValue_numeroVoie2Etablissement | etablissementValue (FR.RC) | Number of Street, line 2 | |
| numeroVoieEtablissement (FR.RC) | etablissementValue_numeroVoieEtablissement | etablissementValue (FR.RC) | Number of Street | |
| prenom1UniteLegale (FR.RC) | uniteLegale_prenom1UniteLegale | uniteLegale (FR.RC) | First name declared for a natural person. | |
| prenom2UniteLegale (FR.RC) | uniteLegale_prenom2UniteLegale | uniteLegale (FR.RC) | Second name declared for a natural person. | |
| prenom3UniteLegale (FR.RC) | uniteLegale_prenom3UniteLegale | uniteLegale (FR.RC) | Third name declared for a natural person. | |
| prenom4UniteLegale (FR.RC) | uniteLegale_prenom4UniteLegale | uniteLegale (FR.RC) | Forth name declared for a natural person. | |
| prenomUsuelUniteLegale (FR.RC) | uniteLegale_prenomUsuelUniteLegale | 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_sexeUniteLegale | 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_sigleUniteLegale | uniteLegale (FR.RC) | Value (CDQ) | |
| siren (FR.RC) | etablissementValue_siren | etablissementValue (FR.RC) | Value (CDQ) | |
| siren (FR.RC) | uniteLegale_siren | 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_siret | etablissementValue (FR.RC) | 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). | Type (CDQ) |
| statutDiffusionEtablissement (FR.RC) | etablissementValue_statutDiffusionEtablissement | etablissementValue (FR.RC) | Status of the entity establishment.
Codes:
| |
| statutDiffusionUniteLegale (FR.RC) | uniteLegale_statutDiffusionUniteLegale | 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_trancheEffectifsEtablissement | etablissementValue (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 | |
| trancheEffectifsUniteLegale (FR.RC) | uniteLegale_trancheEffectifsUniteLegale | 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_typeVoie2Etablissement | etablissementValue (FR.RC) | 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_typeVoieEtablissement | etablissementValue (FR.RC) | 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 | Type (CDQ) |
| uniteLegale (FR.RC) | uniteLegale | entity (FR.RC) | Container for entity establishment | |
| unitePurgeeUniteLegale (FR.RC) | uniteLegale_unitePurgeeUniteLegale | uniteLegale (FR.RC) |