Preparing and Running the Employee Survey Report
These topics provide an overview of the French Employee Survey reporting requirements and discuss the Employee Survey report.
Page Name |
Definition Name |
Usage |
---|---|---|
RUNCTL_EMSURVEY |
Set up the Compute Employee Survey process. |
|
RUNCTL_EMSURVEY2 |
Create a list of pay groups to refine the results of the Compute Employee Survey process. |
|
EDIT_SHEET_FRA |
Review, and modify if needed, the calculation results run by the Compute Employee Survey process on each of the indicators. |
|
RUNCTL_SOC001 |
Run the Employee Survey report (SOC001). This report gives an annual snapshot of a company based on the calculation of several indicators, such as the number of employees in the organization and their average salary. |
The Employee Survey report (le Bilan Social) is an annual regulatory report that the French government requires from employers with more than 300 employees. The report is communicated to both labor unions and the government and provides an analysis of the company over the past three years for nearly 200 indicators.
There are three types of employee surveys for the three main types of industries. PeopleSoft delivers the most common type of employee survey—the one for the trade and services industry.
Indicators in that report include:
The number of employees in the organization.
The number of hires with an unlimited contract during a given year.
The number of work accidents.
These indicators fall within seven groups set up by the French government: Employment, Compensation, Health and Safety, Work Conditions, Training, Professional Relations, and Others.
Here are the steps to prepare and run the Employee Survey report:
(Optional) Set up or modify the updating groups.
(Optional) Set up or modify the Employee Survey Indicators and link them with the application engines.
Run the Employee Survey process (HR_EMSURVEY) calculation for all indicators.
(Optional) Review the results of the process calculations.
Run the Employee Survey report to print the results of the process calculations, or export the data to a file.
Use the Employee Survey Parameters page (RUNCTL_EMSURVEY) to set up the Compute Employee Survey process.
Navigation:
This example illustrates the fields and controls on the Employee Survey Parameters page. You can find definitions for the fields and controls later on this page.

Field or Control |
Description |
---|---|
As of Date and Years Number |
Enter the date for which you want to process the Employee Survey report. The report processes the calculation by civil years. For instance, to report on the year 2002, enter any date in 2002 and 1 in theYears Number field. To report on 2002, 2003 and 2004, enter any date in 2002 and 3 in the Years Number field. The maximum reporting period is three years. |
Employee Survey |
Select the type of survey to run. |
Company |
Select from the list of prompt values. |
Establishment ID |
Select from the list of prompt values. To run the calculation processes for all of the establishments in the company, leave this field blank. |
Indicator Group and Indicator |
To run one indicator, enter the indicator group and the indicator number. To run all of the indicators for an indicator group, specify the indicator group and leave the Indicator field blank. To run all of the calculation processes for the Employee Survey report, leave both the Indicator Group and Indicator fields blank. |
Use the Employee Survey Paygroups page (RUNCTL_EMSURVEY2) to create a list of pay groups to refine the results of the Compute Employee Survey process.
Navigation:
This example illustrates the fields and controls on the Employee Survey Paygroups page. You can find definitions for the fields and controls later on this page.

See the product documentation for PeopleTools: Process Scheduler.
Use the Edit Employee Survey page (EDIT_SHEET_FRA) to review, and modify if needed, the calculation results run by the Compute Employee Survey process on each of the indicators.
Navigation:
This example illustrates the fields and controls on the Edit Employee Survey page. You can find definitions for the fields and controls later on this page.

Field or Control |
Description |
---|---|
Type of Employee Survey |
Displays the survey type. |
As Of Date |
Displays the date that you ran the Compute Employee Survey process. Use the outer scroll bar to navigate between processes that are run with different as of dates. |
Indicator Group and Indicator |
Displays the indicator and group. For each As Of Date process batch, you can review the results for each indicator group and each indicator for which you have run the Compute Employee Survey process. Use the middle scroll arrow to navigate between indicator groups and the inner scroll arrow to navigate between indicators. For each indicator, you can modify the data calculated by the process. |
Use the Employee Survey Report page (RUNCTL_SOC001) to run the Employee Survey report (SOC001).
This report gives an annual snapshot of a company based on the calculation of several indicators, such as the number of employees in the organization and their average salary.
Navigation:
Legally, the Employee Survey report can be administered by company or by establishment. The following table lists the delivered indicators for the establishment and company employee surveys using the trade and services model.
Indicator |
Description |
AE Section |
Employee Survey |
Long Description |
---|---|---|---|---|
111 |
Total Workforce |
IND111 |
Establishment and Company |
Total workforce as of December 31. Part-time workers are taken into account; non-employees are not retrieved. |
112 |
Full Time Workforce |
IND112 |
Establishment and Company |
Full-time workers with an unlimited contract who were hired more than one year ago (as of December 31 of each year). |
113 |
Limited Contract |
IND113 |
Establishment and Company |
All limited contractors are retrieved. |
114 |
Workforce per Month |
IND114 |
Establishment and Company |
Monthly average headcount for a given year. |
115A |
Total Workforce: Male |
IND115A |
Establishment and Company |
Distribution by gender of the total workforce as of December 31. |
115B |
Total Workforce: Female |
IND115B |
Establishment and Company |
Distribution by gender of the total workforce as of December 31. |
115C |
Total Workforce: Unknown |
IND115C |
Establishment and Company |
Distribution by gender of the total workforce as of December 31 when sex is unknown. |
116A |
< 25 Years Old |
IND116A |
Establishment and Company |
Distribution by age of the total workforce as of December 31. |
116B |
< 30 Years Old |
IND116B |
Establishment and Company |
Distribution by age of the total workforce as of December 31. |
116C |
< 35 Years Old |
IND116C |
Establishment and Company |
Distribution by age of the total workforce as of December 31. |
116D |
< 40 Years Old |
IND116D |
Establishment and Company |
Distribution by age of the total workforce as of December 31. |
116E |
>= 40 Years Old |
IND116E |
Establishment and Company |
Distribution by age of the total workforce as of December 31. |
117A |
< 1 Year of Service |
IND117A |
Establishment and Company |
Distribution by company seniority date as of December 31. |
117B |
< 3 Years of Service |
IND117B |
Establishment and Company |
Distribution by company seniority date as of December 31. |
117C |
< 5 Years of Service |
IND117C |
Establishment and Company |
Distribution by company seniority date as of December 31. |
117D |
< 10 Years of Service |
IND117D |
Establishment and Company |
Distribution by company seniority date as of December 31. |
117E |
>= 10 Years of Service |
IND117E |
Establishment and Company |
Distribution by company seniority date as of December 31. |
118A |
French Employees |
IND118A |
Establishment and Company |
Total workforce by nationality as of December 31 (French). |
118B |
Foreigner Employees |
IND118B |
Establishment and Company |
Total workforce by nationality as of December 31: other. |
119 |
Workforce Distribution |
IND119 |
Establishment and Company |
Workforce distribution by employee categorization as of December 31. |
121 |
External Workforce |
IND121 |
Establishment and Company |
Non-employee workers as of December 31. |
122 |
Student |
IND122 |
Establishment and Company |
Internship as of December 31. |
123 |
Temporary Workforce |
IND123 |
Establishment and Company |
Monthly average number of leased workers for a given year. |
124 |
Limited Contract Duration |
Not delivered |
Establishment and Company |
|
131 |
Unlimited Contract Hire |
IND131 |
Establishment and Company |
Number of employees hired with an unlimited duration contract during the given year. |
132 |
Limited Contract Recruitment |
IND132 |
Establishment and Company |
Number of employees recruited with a limited duration contract during a given year. |
133 |
Seasonal Contract Hire |
IND133 |
Establishment and Company |
Number of employees recruited with a seasonal contract during a given year. |
134 |
Under 25 Years Old Hired |
IND134 |
Establishment and Company |
Number of hired employees who are less then 25 years old during a given year. |
141 |
Total Departure |
IND141 |
Establishment and Company |
Number of permanent departures during a given year. |
142 |
Resignation |
IND142 |
Establishment and Company |
Number of permanent departures due to resignations during a given year. |
143 |
Discharge - Redundancy |
IND143 |
Establishment and Company |
Number of permanent departures due to redundancy during a given year. |
144 |
Discharge - Other |
IND144 |
Establishment and Company |
Number of permanent departures due to other reasons during a given year. |
145 |
End of Limited Contracts |
IND145 |
Establishment and Company |
Number of end of limited contract during a given year. |
146 |
End While Qualification |
IND146 |
Establishment and Company |
Number of departures due to end while qualification during a given year. |
147 |
Move to another Establishment |
IND147 |
Establishment |
Number of moves to another establishment during a given year. |
148 |
Retirement - Early Retirement |
IND148 |
Establishment and Company |
Number of departures due to retirement or early retirement during a given year. |
149 |
Death |
IND149 |
Establishment and Company |
Number of deaths during a given year. |
151 |
Promotion |
IND151 |
Establishment and Company |
Number of employees who changed employee categorization during a given year. |
161 |
Employees Lay Off |
IND161 |
Establishment and Company |
Number of employees having at least one layoff during a given year. |
162A |
Employees Lay Off With Pay |
IND162A |
Establishment and Company |
Number of employee layoff pay hours during a given year. |
162B |
Employee Lay Off Without Pay |
IND162B |
Establishment and Company |
Number of employee layoff hours without pay during a given year. |
171 |
Disability |
IND171 |
Establishment and Company |
Number of disabled workers as of March 31. |
172 |
Disability Due to Work Accidents |
IND172 |
Establishment and Company |
Number of disabled workers due to a work accident in the present company as of March 31. |
181 |
Leave of Absence |
IND181A |
Company |
Number of leaves of absence during a given year— public holidays and annual holidays excluded. |
181A |
Leave of Absence |
IND181A Note: WA AE Section = PAYABSNO and WA AE Field = GPFR_ES_LOA_DAY |
Establishment |
Number of leaves of absence during a given year— public holidays and annual holidays excluded. |
181B |
Theoretical Worked Days |
Not Delivered Note: WA AE Section = PAYABSNO and WA AE Field = GPFR_ES_WRK_DAY |
Establishment |
Theoretical Worked Days during a given year. |
181C |
Leave of Absence Rate |
IND181C |
Establishment |
Ratio between Leave of Absence Days and Theoretical Worked Days. |
182 |
Leave of Absence - Sick |
IND182 Note: WA AE Section = PAYABSNO and WA AE Field = GPFR_ES_LOA_DAYSCK |
Establishment and Company |
Number of leave of absence days due to sickness during a given year. |
183A |
Leave of Absence - Sick : < 8 Days |
IND183A Note: WA AE Section = PAYABSNO and WA AE Field = GPFR_ES_LOA_COUNT1 |
Establishment and Company |
Number of leave of absence days due to sickness that started during a given year—distribution by duration. |
183B |
Leave of Absence - Sick : < 30 Days |
IND183B Note: WA AE Section = PAYABSNO and WA AE Field = GPFR_ES_LOA_COUNT2 |
Establishment and Company |
Number of leave of absence days due to sickness that started during a given year—distribution by duration. |
183C |
Leave of Absence - Sick : >= 30 Days |
IND183C Note: WA AE Section = PAYABSNO and WA AE Field = GPFR_ES_LOA_COUNT3 |
Establishment and Company |
Number of leave of absence days due to sickness that started during a given year—distribution by duration. |
184 |
Leave of Absence - Accident |
IND184 Note: WA AE Section = PAYABSNO and WA AE Field = GPFR_ES_LOA_DAYACC |
Establishment and Company |
Number of leave of absence days due to work accident, work illness, or accident when commuting during a given year. |
185 |
Leave of Absence - Maternity |
IND185 Note: WA AE Section = PAYABSNO and WA AE Field = GPFR_ES_LOA_DAYMAT |
Establishment and Company |
Number of leave of absence days due to maternity during a given year. |
186 |
Leave of Absence - Vacation |
IND186 Note: WA AE Section = PAYABSNO and WA AE Field = GPFR_ES_LOA_DAYVAC |
Establishment and Company |
Number of authorized leave of absence days for vacation during a given year. |
187 |
Leave of Absence - Other |
IND187 Note: WA AE Section = PAYABSNO and WA AE Field = GPFR_ES_LOA_DAYOTH |
Establishment and Company |
Number of unauthorized leaves of absence during a given year. |
211 |
Annual Salary by Empl |
Not delivered |
Establishment and Company |
|
211A |
Annual Total Compensation / Monthly Average Headcount – Male |
Not Delivered Note: WA AE Section = IND211A and WA AE Field = GPFR_ES_TOTAL_COMP |
Establishment and Company |
|
211B |
Annual Total Compensation / Monthly Average Headcount – Female |
Not Delivered Note: WA AE Section = IND211B and WA AE Field = GPFR_ES_TOTAL_COMP |
Establishment and Company |
|
211C |
Annual Total Compensation / Monthly Average Headcount – Unknown |
Not Delivered Note: WA AE Section = IND211C and WA AE Field = GPFR_ES_TOTAL_COMP |
Establishment and Company |
|
211BA |
Average Monthly Salary – Male |
Not Delivered Note: WA AE Section = IND211BA and WA AE Field = GPFR_ES_TOTAL_COMP |
Establishment and Company |
|
211BB |
Average Monthly Salary – Female |
Not Delivered Note: WA AE Section = IND211BB and WA AE Field = GPFR_ES_TOTAL_COMP |
Establishment and Company |
|
211BC |
Average Monthly Salary – Unknown |
Not Delivered Note: WA AE Section = IND211BC and WA AE Field = GPFR_ES_TOTAL_COMP |
Establishment and Company |
|
212A |
December Average Compensation w/o Non-monthly Bonus for Permanent Full Time Employee – Male |
Not Delivered Note: WA AE Section = IND212A and WA AE Field = GPFR_ES_DEC_COMP |
Establishment and Company |
|
212B |
December Average Compensation w/o Non-monthly Bonus for Permanent Full Time Employee – Female |
Not Delivered Note: WA AE Section = IND212B and WA AE Field = GPFR_ES_DEC_COMP |
Establishment and Company |
|
212C |
December Average Compensation w/o Non-monthly Bonus for Permanent Full Time Employee – Unknown |
Not Delivered Note: WA AE Section = IND212C and WA AE Field = GPFR_ES_DEC_COMP |
Establishment and Company |
|
212BA |
Non-monthly Bonus Percentage in Compensation Declaration – Male |
Not Delivered Note: WA AE Section = IND212BA and WA AE Field = GPFR_ES_NMTH_BONUS |
Establishment and Company |
|
212BB |
Non-monthly Bonus Percentage in Compensation Declaration – Female |
Not Delivered Note: WA AE Section = IND212BB and WA AE Field = GPFR_ES_NMTH_BONUS |
Establishment and Company |
|
212BC |
Non-monthly Bonus Percentage in Compensation Declaration – Unknown |
Not Delivered Note: WA AE Section = IND212BC and WA AE Field = GPFR_ES_NMTH_BONUS |
Establishment and Company |
|
213 |
Salary Scale |
Not delivered |
Establishment and Company |
|
221 |
Rate between Average Compensation of the 10% Highest Compensation and Average Compensation of the 10% Lowest Compensation |
IND221 |
Establishment and Company |
|
221AA |
Average Compensation of the 10% Highest Compensation |
Not Delivered Note: WA AE Section = IND221AA and WA AE Field = GPFR_ES_TOTAL_COMP |
Establishment and Company |
10% Highest Average Compensation. |
221AB |
Average Compensation of the 10% Lowest Compensation |
Not Delivered Note: WA AE Section = IND221AB and WA AE Field = GPFR_ES_TOTAL_COMP |
Establishment and Company |
10% Lowest Average Compensation. |
221B |
Rate between Average Compensation of the Executive Employees and Average Compensation of the Qualified Workers |
IND221B |
Establishment and Company |
Ratio between average compensation of the executive employees and average compensation of the qualified workers. |
221BA |
Average Compensation of the Executive Employees |
Not Delivered Note: WA AE Section = IND221BA and WA AE Field = GPFR_ES_TOTAL_COMP |
Establishment and Company |
|
221BB |
Average Compensation of the Qualified Workers |
Not Delivered Note: WA AE Section = IND221BB and WA AE Field = GPFR_ES_TOTAL_COMP |
Establishment and Company |
|
222 |
Top 10 Highest Compensation Amount |
Not Delivered Note: WA AE Section = IND222 and WA AE Field = GPFR_ES_TOTAL_COMP |
Company |
|
231 |
Performance-Related |
Not delivered |
Establishment and Company |
|
232 |
Hourly Wage Percentage |
Not delivered |
Establishment and Company |
|
241 |
Perks |
Not delivered |
Establishment |
|
242A |
Expense for External Temporary |
Not delivered |
Establishment and Company |
|
242B |
Expense for External Others |
Not delivered |
Establishment and Company |
|
251 |
Total Compensation |
Not delivered |
Company |
|
261 |
Profit-Sharing Global Amount |
IND261 |
Company |
|
262 |
Profit-Sharing Average Amount |
IND262 |
Company |
|
263 |
Stock Percent |
Not delivered |
Company |
|
311A |
Work Accident |
IND311A |
Establishment and Company |
Number of work accidents that result in leave of absence days during a given year. |
311B |
Theoretical Worked Hours |
Not Delivered Note: WA AE Section = PAYABSNO and WA AE Field = GPFR_ES_WRK_HOURS |
Establishment |
|
311C |
Work Accident Frequency |
IND311C |
Establishment |
|
312A |
Lost Days |
IND312A |
Establishment and Company |
Lost days due to work accidents during a given year. |
312B |
Theoretical Worked Hours |
Not Delivered Note: WA AE Section = PAYABSNO and WA AE Field = GPFR_ES_WRK_HOURS |
Establishment |
|
312 |
Lost Days |
IND312A |
Company |
Lost days due to work accidents during a given year. |
312C |
Accident Severity Rate |
IND312C |
Establishment |
The work accident severity equals the lost days due to work accidents times 106 divided by the theoretical worked hours. |
313 |
Permanent Disability |
IND313 |
Company |
Number of permanent disabilities that are notified to the company during a given year. |
313A |
Permanent Disability: French |
IND313A |
Establishment |
Number of permanent disabilities that are notified to the company during a given year. |
313B |
Permanent Disability: Foreigners |
IND313B |
Establishment |
Number of permanent disabilities that are notified to the company during a given year. |
314A |
Fatal Accident at Work |
IND314A |
Establishment and Company |
Number of fatal accidents at work during a given year. |
314B |
Fatal Accident: Commuting |
IND314B |
Establishment and Company |
Number of fatal accidents during commuting during a given year. |
315 |
Stop Work Due to Accident |
IND315 |
Establishment and Company |
Number of accidents resulting in a stoppage of work during a given year. |
316 |
Accident - Temporary |
IND316 |
Establishment and Company |
Number of non-employee accidents at work during a given year. |
317A |
Social Security Contribution for Work Accident Rate |
Not Delivered Note: WA AE Section = IND317A and WA AE Field = GPFR_ES_ACC_RATE |
Establishment |
Social Security Contribution for Work Accident Rate during a given year. |
317B |
Social Security Contribution for Work Accident Amount |
Not Delivered Note: WA AE Section = IND317B and WA AE Field = GPFR_ES_ACC_AMNT |
Establishment |
Social Security Contribution for Work Accident Amount during a given year. |
321 |
Accident - High Risk |
IND321 |
Establishment and Company |
Number of accidents linked to existing high risk during a given year. |
322 |
Accident - Due to a Fall |
IND322 |
Establishment and Company |
Number of accidents classified as due to a fall during a given year. |
323 |
Accident - Caused by a Machine |
IND323 |
Establishment and Company |
Number of accidents classified as caused by a machine during a given year. |
324 |
Road Accident |
IND324 |
Establishment and Company |
Number of accidents classified as road accident during a given year. |
325 |
Accident - Caused by an Object |
IND325 |
Establishment and Company |
Number of accidents classified as caused by an object during a given year. |
326 |
Accident - Others |
IND326 |
Establishment and Company |
Number of accidents classified as other during a given year. |
331 |
Occupational Disease |
Not delivered |
Establishment and Company |
|
332 |
Disease Due to Work |
Not delivered |
Establishment and Company |
|
333 |
Jobs Can Cause Diseases |
Not delivered |
Establishment and Company |
|
341 |
Number of Security Meetings |
Not delivered |
Establishment and Company |
|
351 |
Security Training |
Not delivered |
Establishment and Company |
|
352 |
Security Budget |
Not delivered |
Establishment and Company |
|
353 |
Percentage Done |
Not delivered |
Establishment |
|
411 |
Worked Hours |
Not delivered |
Establishment and Company |
|
412A |
Time Off in Lieu: Legal |
IND412A |
Establishment and Company |
Number of employees who received legal time off during the given year. |
412B |
Time Off in Lieu: Conventional |
IND412B |
Establishment and Company |
Number of employees who received conventional time off during the given year. |
413 |
Flextime |
IND413 |
Establishment and Company |
Number of employees with flextime as of December 31. |
414A |
Part-time: 20 -30 hrs a Week |
IND414A |
Establishment and Company |
Number of employees working between 20 and 30 hours a week as of December 31. |
414B |
Part-time: Others |
IND414B |
Establishment and Company |
Number of employees working part-time other than 20 to 30 hours a week as of December 31. |
415 |
2 Days Time Off |
Not delivered |
Establishment and Company |
|
416 |
Annual Holidays - Average |
IND416 |
Establishment and Company |
Average number of annual holidays during the given year (time off in lieu not included). |
417 |
Public Holidays Paid |
Not delivered |
Establishment and Company |
|
421 |
Alternate Hours |
IND421 |
Establishment and Company |
Number of employees with alternate hours as of December 31. |
431 |
Noise >= 85 Db |
Not delivered |
Establishment and Company |
|
432 |
Toxic Products Analyses |
Not delivered |
Establishment and Company |
|
441 |
Working Environment Improvement |
Not delivered |
Establishment and Company |
|
451 |
Improvement Program Expenses |
Not delivered |
Establishment and Company |
|
452 |
Percentage Done |
Not delivered |
Establishment |
|
461 |
Medical Exam |
IND461 |
Establishment |
Number of medical exam as of December 31. |
461A |
Medical Exam: Supervised Work |
Not delivered |
Establishment |
|
461B |
Medical Exam: Others |
Not delivered |
Establishment |
|
462 |
Additional Medical Exam |
IND462 |
Establishment |
Number of additional medical exams given during the year. |
462A |
Additional Medical Exam: Supervised |
Not delivered |
Establishment |
|
462B |
Additional Medical Exam: Others |
Not delivered |
Establishment |
|
463 |
Medical Intervention |
Not delivered |
Establishment |
|
471 |
Employees Unfit for Work |
IND471 |
Establishment |
Number of employees declared unfit for work by the work doctor during a given year. |
472 |
Employees Regraded |
IND472 |
Establishment |
Number of regraded employees due to an incapacity during a given year. |
511 |
Training Total Payroll |
Not delivered |
Establishment and Company |
|
512 |
Training Budget |
Not delivered |
Establishment and Company |
|
513 |
Trainees |
Not delivered |
Establishment and Company |
|
514A |
Trainees Hours Paid |
Not delivered |
Establishment and Company |
|
514B |
Trainees Hours Unpaid |
Not delivered |
Establishment and Company |
|
515 |
Training Categories |
Not delivered |
Establishment and Company |
|
521 |
Training With Pay |
IND521 |
Establishment and Company |
Number of employees with a paid training leave during a given year. |
522 |
Training Without Pay |
IND522 |
Establishment and Company |
Number of employees with an unpaid training leave during the given year. |
523 |
Training Demand Reject |
Not delivered |
Establishment and Company |
|
531 |
Apprenticeship Contr |
Not delivered |
Establishment and Company |
|
611 |
Turnout at Elections |
Not delivered |
Establishment and Company |
|
612 |
Time Allowed Used |
Not delivered |
Establishment and Company |
|
613 |
Union Representative Meetings |
Not delivered |
Establishment and Company |
|
614 |
Agreement |
Not delivered |
Company |
|
615 |
Leave of Working Education |
Not delivered |
Company |
|
621 |
Hours for Meetings |
Not delivered |
Establishment and Company |
|
622 |
Reception Procedure |
Not delivered |
Establishment and Company |
|
623 |
Information Procedure |
Not delivered |
Establishment and Company |
|
624 |
Individual Interview |
Not delivered |
Establishment and Company |
|
631 |
Non Judicial Action |
Not delivered |
Establishment and Company |
|
632 |
Judicial Inquiry |
Not delivered |
Establishment and Company |
|
633 |
Labor Inspector Notification |
Not delivered |
Establishment and Company |
|
711 |
Expense |
Not delivered |
Establishment and Company |
|
712 |
Payment to Works Council |
Not delivered |
Establishment and Company |
|
721 |
Mutual Insurance: Health and Life |
Not delivered |
Company |
|
722 |
Mutual Insurance: Retirement |
Not delivered |
Company |