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
Topics
Keywords
Bibliographic citation
doi:10.13144/psm-0048 PSM - Base Tous Salariés (BTS) - 2017-2023, INSEE (producteur), PROGEDO-ADISP (diffuseur).
Series
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
- Archives de Données Issues de la Statistique Publique (ADISP) (Progedo-Adisp)Quetelet-Progedohttp://www.progedo-adisp.fr
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.