ADISP2023PSMCustom products

PSM - All Employees Database (BTS) - 2017-2023

Machine translation

Some metadata is not available in this language. The original text is shown and flagged.

Summary

The All Employees Databases are annual statistical files of individual data covering all employees, produced from employers' administrative nominative social declarations (DSN). Each annual data year N has an All Employees Database containing information for years N and N-1. These databases describe the type of employment and remuneration received by each employee. They support structural statistics on wages and employment and analysis according to the nature of the job (duration, employment conditions, qualification and remuneration), employee characteristics (sex, age and department of residence) and characteristics of the employing establishment (industry, location and size). The All Employees Databases cover all employees in the private and public sectors and employees of individual employers. Each database contains four files: - “Jobs”: one row represents one employee in one establishment; for example, an employee who works in two separate establishments during the year appears on two rows. It contains data on the job (wages, working time, etc.) and the establishment (industry, size, etc.). - “Employees”: one row represents one employee. It contains the characteristics of the employee's “main job”, defined by the highest wage or longest duration, and totals of wages and paid hours across all of the employee's jobs. - “Establishments” (disseminated since the 2018 data year): contains indicators on the number of jobs at establishment level according to various criteria such as age and socio-occupational category. - “Enterprises” (also disseminated since 2018): contains indicators on the number of jobs at enterprise level, for example by type of employment or at the beginning and end of the year. The Custom Product (PSM) service provides made-to-order tables built on request from INSEE detailed files that are not included in the Progedo catalogue. Tables are supplied as files in which columns correspond to the selected variables and rows to the different combinations of variable categories. A final “result” column gives the number of observations in the original file satisfying each combination of categories. In other words, each row corresponds to a cell in a table crossing all selected variables, and the final column gives its value. Statistical indicators such as means and medians can also be calculated for numeric variables.

Machine translation

French title

PSM - Base Tous Salariés (BTS) - 2017-2023

Keywords

  • Wages
  • Employment
  • Working conditions
  • Businesses
  • Public sector

Bibliographic citation

doi:10.13144/psm-0048 PSM - Base Tous Salariés (BTS) - 2017-2023, INSEE (producteur), PROGEDO-ADISP (diffuseur).

Series

Produits Sur Mesure (PSM)

The Produits Sur Mesure (PSM) are tables built on request from Insee sources not available in the catalogue (Adisp does not hold these files), or for particular sub-populations, or according to classifications different from those used in the standard offer. The tables take the form of files whose columns correspond to the selected variables and whose rows correspond to the different combinations of categories of these variables. There is a last column containing the "result", i.e. the number of observations in the original file that satisfy each combination of categories. In other words, each row corresponds to a cell of a table cross-tabulating all the selected variables, and the last column gives its content. It is also possible to calculate statistical indicators, such as the mean, median, etc., on numerical variables. Given the time needed to build and produce PSMs, check that the standard "detailed files" or "production and research" files (FPR) available, for some sources, in the Quetelet-Progedo catalogue cannot meet your needs. For each of the files open to PSMs, you will find a presentation of the source, the lists of existing variables and the confidentiality restrictions. This information, available on the Insee website, will help you prepare the construction of the tables you need. Note that the available variables change over time; those on the Insee website relate to the latest data year.

Record production date

2023

Producers

  • Institut National de la Statistique et des Études Économiques (INSEE)

Distributor

Time period

  • 2017 Start
  • 2023 End

Record version

Version 1 (02/03/2026): creation of an XML file for the PSM.

Version date : Mar 2, 2026

Notes

Statistical confidentiality: no disseminated table may permit the direct or indirect identification of an employee or establishment. For tables by place of residence: - no cell may contain fewer than five employees; - no employee may account for more than 80% of the wage bill in the cell. For tables by place of work, in addition to the two preceding criteria: - no cell may relate to fewer than three establishments or enterprises; - no establishment or enterprise may account for more than 85% of the quantity measured in the cell.

Details

Parallel titles

  • PSM - All Employees Database (BTS) - 2017-2023

Country

  • France (FR)
  • Guadeloupe (GP)
  • Martinique (MQ)
  • French Guiana (GF)
  • Réunion (RE)

Geographic coverage

  • Metropolitan France
  • Guadeloupe
  • Martinique
  • French Guiana
  • Réunion

Data type

  • Aggregate administrative data

Study population

All employees in the private and public sectors, together with employees of individual employers.

Methodology

Time method of the data collection

  • Each All Employees Database file covers two consecutive years, N-1 and N.

Frequency of the data collection : Annual

Data collector : Département de l'emploi et des revenus d'activité

Characteristics of the data collection situation : The 2017 data year was the first to rely primarily on data from nominative social declarations (DSN) for the private sector. This new source is gradually replacing most social declarations, particularly the annual declarations of social data (DADS). DSN covered 75% of private enterprises in the 2017 data year and 99% in 2018; the source is now called the All Employees Database (BTS). For the 2017 and 2018 data years, only the “Jobs” and “Employees” tables are disseminated, while the “Establishments” and “Enterprises” tables are no longer available as custom products. From the 2019 data year onward, the “Establishments” and “Enterprises” tables are again available as custom products.

Variables

Not provided

Data

No data file is described in the record.

Documentation

Documents

No attached document in the record.

Downloadable resources (questionnaires, codebooks, etc.)

Data access

PSM Custom products

PSM : Les produits sur mesure (PSM) sont des données anonymisées accessibles aux demandeurs qui appartiennent à la communauté scientifique (cf. section "Restrictions").

Request portal

  • Quetelet-Progedo data request portal

Contact

  • Adisp team

Archive originally storing the data

ADISP - Archives de Données Issues de la Statistique Publique

Confidentiality agreement

To obtain the data, the user must first submit a request using the Quetelet-Progedo-Diffusion data request portal; approval is subject to the user's status, as well as the presence of an institutional e-mail address and a research project. If a request is approved, an individualised agreement with ADISP (and in the case of FPR, a confidentiality agreement with the Statistical Confidentiality Committee) must be signed. Such agreements will require the user to adhere to the following conditions: -To use the data exclusively for research purposes; -Not to transfer the data, in any form whatsoever, to a third party, whether free of charge or for a fee; -To process these data in accordance with rules of art and statistical secrecy; -To mention the data source in their communications, publications, etc., according to the citation to be used whenever re-using the data (see below); -To inform the data distributor of any communications, publications, etc. they produce and to send the data distributor the references; -To inform the data distributor of any findings related to data quality or difficulties in re-use; -To inform the data distributor of any data re-use for research other than what was specified above; -To destroy the data files once the research has been completed; -To respect the regulations on the protection of personal data.

Restrictions

Files disseminated via Quetelet-Progedo-Diffusion are accessible to French and international researchers, doctoral students, post-doctoral students, and master's students for the purposes of research, scientific production and in some cases teaching. Any commercial use is prohibited. The term, "for the purposes of research," is defined as any scientific production or reproduction that validates new general knowledge. The results must be made public and free to disseminate.

Terms of use

The user must submit a request using the Quetelet-Progedo-Diffusion data request portal; approval is subject to the user's status, as well as the presence of an institutional e-mail address and a research project. If a request is approved, an individualised agreement with ADISP (and in the case of FPR, a confidentiality agreement with the Statistical Confidentiality Committee) must be signed. If the data are to be analysed by a team, all members of the research team must apply for access.

Required citation

doi:10.13144/psm-0048 PSM - Base Tous Salariés (BTS) - 2017-2023, INSEE (producteur), PROGEDO-ADISP (diffuseur).

Publication deposit

In order to provide the data producer(s) with essential information concerning how their data is being re-used, data users are required to notify ADISP (diffusion.adisp@cnrs.fr) of any publication produced as a result of exploiting the survey data, by sending, whenever possible electronically, the bibliographic reference and abstract.

Disclaimer

The data producer and data distributor cannot be held responsible for any interpretations or conclusions resulting from the re-use of the data.

Export the DDI

← Back to catalogue