BTS-Etablissements : All employees databases - establishment data - 2021

---

Data description

The All employees database makes it possible to describe all employees in a given year according to their characteristics and those of the establishments employing them. The database includes 4 files:

• the << Jobs>> file in which a line represents an employee in an establishment (for example, if an employee works in two different establishments during the year, two lines will be present in the jobs file). It contains data on the job (wages, working time, etc.) and on the establishment (sector, size, etc.).

• the<< Employees>> file, in which one line represents an employee. It contains the characteristics of his or her "main job" (highest salary or longest working hours) and the cumulative salaries and hours worked across all the employee's jobs.

• the << Establishment >> file , published since the 2018 vintage. It contains indicators on number of jobs at the establishment level, by different criteria (age, job categories, etc.).

• the << Enterprise>> file, published since the 2018 vintage. It contains indicators on number of jobs at the enterprise level, by different criteria (age, job categories, etc.).

The 2021 vintage is in line with the 2020 vintage. Just as 2020, the data for this year have been impacted by the health crisis, with a still significant recourse to partial unemployment (or partial activity) in some sectors.

The 2021 vintage contains, as in previous years, the data for the year N-1, which have been updated to take account of the latest methodological developments.

• Wages in the private sector in 2021 : Changes still impacted by the health crisis (fr)

Sector coverage

The All employees databases cover all employees in the private and public sectors and employees of individual employers.

Statistical population

The 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 on all employees, produced from administrative declarations by their employers: nominative social declarations (DSN), which are gradually replacing the annual social data declarations (DADS), the payroll files of government employees, and the salary declarations of Private Individuals' Employees.

---

The All Employees database is built from an computer processing chain called PIRENES. It was developed to take into account the specificities linked to the arrival of the DSN but also to preserve, as far as possible, the methodology of the processing carried out on the DADS.

The PIRENES chain is based on a complete processing of each DSN from its reception:

• a process of validating the SIRETs from the Sirus repository or, failing that, by querying the Sirene directory

• a phase of coding the socio-professional category (PCS) on 4 positions according to the PCS-ESE nomenclature, the first two positions of the PCS (Profession and Socioprofessional Category) making it possible to reduce to the CS.

• a coding phase for the commune of residence, based on the postcode declared in the DSN

• a phase of internal consistency in the DSN between the variables relating to the elements of remuneration once the 12 months of declarations have been aggregated.

• a phase of calculation of gross and net salaries reconstructed from the various remuneration elements available in the social declarations.

Data on employees of the three branches of the public service from the SIASP application and data on employees of private individuals are integrated into the PIRENES chain at the end of processing and benefit from the adjustments specific to their original application.

Data from SIASP are subject to the same types of statistical processing as those carried out on the private sector.

---

2021 : https://doi.org/10.34724/CASD.34.5099.V1