BTS-Etablissements : All employees databases - establishment data - 2022
Data description
The All employees database allows to describe all employees on a given year by their characteristics and those of their employing establishments. The database includes 4 files:
-
The "Postes" (Jobs) file, in which each line stands for a given employee in a given establishment (for example, if an employee works in two different establishments during the year, two lines will appear in the Jobs file). It contains data about the job (wages, working time, etc.) and about the establishment (sector, size, etc.) ;
-
The "Salariés" (Employees) file, in which each line stands for an employee. It contains the characteristics of his or her "main job" (the one with the highest salary or the longest duration) and the cumulative salaries and labor hours of all the employee's jobs ;
-
The "Etablissements" (Establishments) file. It contains job counts at the establishment level, based on different criteria (age, job category, etc.) ;
-
The "Entreprise" (Enterprises) file. It contains job counts at the enterprise level, based on different criteria (type of employment, time of the year, etc.).
The 2022 vintage is a continuation of the 2021 vintage. It contains, as for the previous years, the year N-1 data, updated with the latest methodological developments.
Sector coverage
All employees databases cover all employees of the business sector, civil service, and individual employers (household employees).
Statistical population
All employees databases cover all employees in the private and public sectors, and employees of individual employers.
Reference area
France hors Mayotte
The All employees database is a statistical database about all employees, produced from administrative declarations of their employers : the « Déclaration Sociale Nominative » (DSN) form which has replaced the « Déclaration Annuelle de Données Sociales » (DADS) form, and forms filled by Individuals Employers (of household employees).
The All Employees database is built from a computer processing chain named PIRENES. It is designed to integrate the specificities of the DSN but also to preserve, as far as possible, the methodology of the process carried out on the DADS.
The PIRENES chain is based on a complete processing of each DSN from its reception :
-
A SIRET validation step, based on the SIRUS repository or, failing that, by querying the SIRENE directory ;
-
An occupation and socio-professional category (PCS) 4-digits coding step, according to the PCS-ESE nomenclature. The first two digits match the socio-professional category ;
-
A city of residence coding step, based on DSN-declared zipcode ;
-
A DSN internal consistency step, between the variables relating to the remunerationitems, once the 12 months of declarations have been aggregated ;
-
A gross and net salaries calculation step, reconstructed from the various remuneration items available in the social declarations.
From 2022, the social declarations of the Civil Service are almost entirely DSNs, processed within the PIRENES chain. The statistical process is therefore identical for both business and public sector data.