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

Employee Survey Parameters Page

RUNCTL_EMSURVEY

Set up the Compute Employee Survey process.

Employee Survey Paygroups Page

RUNCTL_EMSURVEY2

Create a list of pay groups to refine the results of the Compute Employee Survey process.

Edit Employee Survey Page

EDIT_SHEET_FRA

Review, and modify if needed, the calculation results run by the Compute Employee Survey process on each of the indicators.

Employee Survey Report Page

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:

  1. (Optional) Set up or modify the updating groups.

  2. (Optional) Set up or modify the Employee Survey Indicators and link them with the application engines.

  3. Run the Employee Survey process (HR_EMSURVEY) calculation for all indicators.

  4. (Optional) Review the results of the process calculations.

  5. 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:

Workforce Monitoring > Meet Regulatory Rqmts FRA > Employee Survey > Compute Employee Survey > Employee Survey Parameters

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.

Employee Survey Parameters 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:

Workforce Monitoring > Meet Regulatory Rqmts FRA > Employee Survey > Compute Employee Survey > Employee Survey Parameters > Employee Survey Paygroups

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.

Employee Survey Paygroups 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:

Workforce Monitoring > Meet Regulatory Rqmts FRA > Employee Survey > Edit Employee Survey

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.

Edit Employee Survey 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:

Workforce Monitoring > Meet Regulatory Rqmts FRA > Employee Survey > Employee Survey Report

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