(FRA) Meeting Regulatory Requirements for France

This chapter provides an overview of French regulatory requirements and discusses how to:

Set up French regulatory reports.
Run the Disability report.
Manage elections and run the Election report.
Prepare and run the Employee Survey report.
Run workforce reporting statutory reports.
Prepare and run the Training 2483 report.

Understanding French Regulatory Requirements

Human Resources provides resources for managing and reporting on various types of data that are required by French government regulations.

PeopleSoft provides the following French regulatory reports:

Disability (DIS001).
Election (ELE001).
Employee Survey (SOC001).
Monthly Workforce (REG001FR).
Personal Register (REG002FR).
Training 2483 (TRN029).
Workforce by Nationality (REG003FR).
Single Hiring Statement (HRSHSFRA).
BIAF report (Bordereau Individuel d'Accès à la Formation report) (REG004FR).

Prerequisites

Set up control tables using the following pages before running French regulatory reports:

Control Table Page	Description
APE Table (activite principale exercee table)	Classify the company’s primary industry, such as software, banking, or insurance. The APE codes are mandated by French law.
External Variables	Enter information related to salaries and social security ceilings that are established by the French government each year, and enter the disability rates for the Disability report.
INSEE Table FRA (National Institute For Statistical And Economical Studies table France)	Input the INSEE codes for the company’s job codes. Then map the company’s job codes to one of the INSEE codes.
FRA Pension/Cont. Funds Table - Institution Type and FRA Pension/Cont. Funds Table - Institution Add.	Enter address and location details about the institutions that provide pensions to the employees.
URSSAF Code (Union de Recouvrement de la Sécurité Sociale et des Allocations Familiales code)	Store the codes of the local URSSAF offices. This government agency collects employee and employer contributions made for illness and work accidents.
Trn 2483 Parameters (training 2483 parameters)	Enter data required for the 2483 report. Much of the information required for the 2483 report is stored in the Human Resources system and payroll system.

In addition to setting up the control tables, you must set up Training 2483 report groups and indicators.

Setting Up French Regulatory Reports

To set up the French regulatory reports tables, use the Contract Type Group (CNTRCT_TYPE_GRP), Action Group (ACTION_GRP_FRA), Country Group (COUNTRY_GRP), Employee Survey Group (GROUP_SHEETTBL_FRA), Employee Survey Indicator (INDIC_SHEETTBL_FRA), Election Group (ELECTION_GR_TBL), Election Roll (ELECTION_RL_TBL), Mandatory Base Scheme (BSE_SCH_FRA_TBL), Kind of Contract (CTC_KND_FRA_TBL), Category Status (CTG_STS_FRA_TBL), Covered Population (CVD_POP_FRA_TBL), Job Category (JOB_CTG_FRA_TBL), Previous Employment Situation (WRK_EXP_FRA_TBL), Medical Organization (MED_ORG_FRA_TBL), Population Category (POP_CTG_FRA_TBL), and Professional Status (PRF_STS_FRA_TBL) components.

This section provides an overview of pages with system-populated fields and discusses how to:

Group contract types.
Update groups.
Update indicators.

Understanding Pages with System-Populated Fields

The following pages are populated with system data:

Mandatory Base Scheme.
Kind of Contract.
Category Status.
Covered Population.
Job Category.
Medical Organization.
Population Category.
Professional Status.

On these pages, you can modify, delete, and add new codes. As legislative changes occur, you can easily update this data to comply with French legislation that applies to your organization. In some cases, not all the system data is populated, because only a few parts of this information may be relevant to your organization.

Pages Used to Set Up French Regulatory Reports

Page Name	Object Name	Navigation	Usage
Contract Type Group	CNTRCT_TYPE_GRP	Set Up HRMS, Product Related, Workforce Monitoring, Regulatory Requirements FRA, Contract Type Group	Group contract types together. Before using this page, set up the Contract Type table.
Action Group	ACTION_GRP_FRA	Workforce Monitoring, Meet Regulatory Requirements FRA, Action Groups	Define action groups used by processes.
Country Group	COUNTRY_GRP	Set Up HRMS, Product Related, Workforce Monitoring, Regulatory Requirements FRA, Country Group	Modify country groupings. Before using this page, set up the Country table.
Employee Survey Group	GROUP_SHEETTBL_FRA	Set Up HRMS, Product Related, Workforce Monitoring, Regulatory Requirements FRA, Define Emply Survey Indicators, Employee Survey Group	Update the seven main groups defined by the French government.
Employee Survey Indicator	INDIC_SHEETTBL_FRA	Set Up HRMS, Product Related, Workforce Monitoring, Regulatory Requirements FRA, Define Emply Survey Indicators, Employee Survey Indicator	Update the indicators and link the indicators with the relevant application engine section.
Election Group	ELECTION_GR_TBL	Set Up HRMS, Product Related, Workforce Monitoring, Regulatory Requirements FRA, Election Group	Define the various groups that are active in the company.
Election Roll	ELECTION_RL_TBL	Set Up HRMS, Product Related, Workforce Monitoring, Regulatory Requirements FRA, Election Roll	Define the election rolls or candidacies.
Mandatory Base Scheme	BSE_SCH_FRA_TBL	Set Up HRMS, Product Related, Workforce Administration, Workforce Data FRA, Base Scheme, Mandatory Base Scheme	Define the base scheme necessary for DADS, a French payroll report.
Kind of Contract	CTC_KND_FRA_TBL	Set Up HRMS, Product Related, Workforce Administration, Workforce Data FRA, Kind of Contract	Define the kind of contracts needed for DADS.
Category Status	CTG_STS_FRA_TBL	Set Up HRMS, Product Related, Workforce Administration, Workforce Data FRA, Category Status	Define the category status needed for French payroll and DADS.
Covered Population	CVD_POP_FRA_TBL	Set Up HRMS, Product Related, Workforce Administration, Workforce Data FRA, Covered Population	Define the covered population needed for DADS.
Job Category	JOB_CTG_FRA_TBL	Set Up HRMS, Product Related, Workforce Monitoring, Regulatory Requirements FRA, Job Category	Define the job categories used in the company. This information is required for the Single Hiring Statement report.
Previous Employment Situation	WRK_EXP_FRA_TBL	Set Up HRMS, Product Related, Workforce Administration, Workforce Data FRA, Previous Employment Situations, Previous Employment Situation	Review and update the previous employment codes used for the Single Hiring Statement report.
Medical Organization	MED_ORG_FRA_TBL	Set Up HRMS, Product Related, Workforce Monitoring, Regulatory Requirements FRA, Medical Organization	Define the medical organizations used in the company. This information is required for the Single Hiring Statement report.
Population Category	POP_CTG_FRA_TBL	Set Up HRMS, Product Related, Workforce Administration, Workforce Data FRA, Population Category	Define the population categories used by your company. Needed for DUCS, a French payroll report.
Professional Status	PRF_STS_FRA_TBL	Set Up HRMS, Product Related, Workforce Administration, Workforce Data FRA, Professional Status	Define the professional status used in the company; this information is required for DADS.

Grouping Contract Types

Access the Contract Type Group page.

SetID and Contract Type

Enter or look up a setID and a contract type to associate with this group name.

Updating Groups

Access the Employee Survey Group page.

Note. All groups and nearly all indicators that you must prepare for the Employee Survey report already exist in the Employee Survey Group table and the Employee Survey Indicator table as system data; however, the Employee Survey process does not determine all indicators. The system determines about half of the indicators. Use the Employee Survey Group page and the Employee Survey Indicator page to modify these groups and indicators, if necessary.

Number of Columns

Enter the number of columns on the Employee Survey report. When you change the number of columns, a corresponding number of Descr. (description) fields appear on the page.

The columns (number and value) are used as defaults when you add a new indicator. The report displays only the columns defined on the Employee Survey Indicator page.

Updating Indicators

Access the Employee Survey Indicator page.

Number of Columns

Displays the total number of columns and the corresponding column descriptions that are entered on the Employee Survey Group page. The number of Descr. (description) fields that appear at the bottom of the page is linked to the value that you enter in the Number of Columns field.

The descriptions that you enter are the headings for the categories, or columns, on the report. In this example, the Employment group displays the following columns in the report: Executive, Act Exec, Worker, and Total.

Application Engine

More than 60 PeopleSoft Application Engine processes are built into Human Resources for the majority of the indicators.

Section

Enter the section of the employee survey that PeopleSoft Application Engine should calculate for the given indicator.

Note. When the value is set to NO, it means that there is no PeopleSoft Application Engine process for the indicator. Changing this value without modifying the Application Engine results in an error and stops the overall process.

Payroll Related

Select to calculate this indicator.

Note. When the columns are changed, the related indicator in PeopleSoft Application Engine should be modified to fill the columns properly. You must make these changes to the process manually.

See Also

Enterprise PeopleTools 8.45 PeopleBook: PeopleSoft Application Engine

Running the Disability Report

This section provides an overview of French disability reporting, lists common elements and discusses how to run the Disability report.

Understanding French Disability Reporting

French legislation of 1987 requires firms with more than 20 employees to hire qualified disabled people. Before hiring the disabled person, the employer is required to notify the proposed employee’s social security commission, COTOREP (Commission Technique d’Orientation et de Reclassement Professionnel), in an effort to combat fraud.

When you run the Disability report, it calculates the theoretical number of disabled employees that your company should hire by multiplying the disability rate by the number of people in the calculation population. The system determines the calculation population by subtracting those people who have special job codes that are defined by the INSEE (National Institute for Statistical and Economical Studies) or who are external consultants or trainees from the total population of your organization. The report also lists all the disabled employees employed by your company. Based on this report, the French government determines if your company complies with the law.

To prepare this report, ensure that you enter the correct codes in the INSEE table and have the correct Disability Rate code in the External Variables table.

Common Elements Used in This Section

Company Total Population	Displays the total company population. Each Human Resources French job code is linked to a four-digit INSEE socio-professional category description (classification par categorie socio-professionnelle [PCS]) code. The first table of the report lists all the PCS codes corresponding to a job code within your company, their description, and the number of men or women in each category.
Jobs Requiring Special Abilities	Displays exempt job codes and the number of men or women in the company's population who must be excluded from the calculation population. Exempt job codes define jobs that require capabilities incompatible with any kind of disability.
Reference Population	Displays the total population minus consultants and trainees but including the excluded jobs.
Calculation Population	Displays the total population minus the consultants, trainees, and excluded jobs.
Calculated Number of Disabled Employees	Displays the calculated, theoretical number of disabled employees whom the company should hire to comply with the law.

Page Used to Run the Disability Report

Page Name	Object Name	Navigation	Usage
Disability Report	RUNCTL_DIS001_FRA	Workforce Monitoring, Meet Regulatory Rqmts FRA, Required Reports, Disability, Disability Report	Run the Disability report. This report calculates the theoretical number of disabled employees who should work for the company and lists the disabled employees, excluding temporary workers, trainees, and apprentices.

Running the Disability Report

Access the Disability Report page.

Before running this report, enter the correct codes in the INSEE table and the correct disability rate code in the External Variables table.

Managing Elections and Running the Election Report

This section provides an overview of French professional elections reporting and discusses how to:

Define an election.
Record candidacies for election groups.
Enter voting results.
Validate election results.
Determine elected candidates.

Understanding French Professional Elections Reporting

Human Resources enables you to monitor professional elections for personnel representatives (delegues du personnel) and members of the work council (comite d'enterprise) in your organization if you are doing business in France.

Companies with more than 11 employees must elect personnel representatives to represent all of the employees before management. Companies with more than 50 employees must elect a work council to represent the employees in negotiations with management. Normally, the elections are every two years and follow stringent procedures.

Once you enter the election data, run the Election report to show the results of the elections to the employees and management.

Pages Used to Manage Elections and Run the Election Report

Page Name	Object Name	Navigation	Usage
Maintain Election Data - Group	ELECTION_GROUP	Workforce Monitoring, Meet Regulatory Rqmts FRA, Election Monitoring, Maintain Election Data, Group	Define the characteristics of an election.
Maintain Election Data - Roll	ELECTION_ROLL	Workforce Monitoring, Meet Regulatory Rqmts FRA, Election Monitoring, Maintain Election Data, Roll	Record candidacies for the groups in the election. Each trade union in the company delivers a list of candidates (incumbents and substitutes) for the election that you enter on this page.
Maintain Election Data - Votes	ELECTION_VOTES	Workforce Monitoring, Meet Regulatory Rqmts FRA, Election Monitoring, Maintain Election Data, Votes	Enter voting results.
Maintain Election Data - Results	ELECTION_RESULTS	Workforce Monitoring, Meet Regulatory Rqmts FRA, Election Monitoring, Maintain Election Data, Results	Validate the election results by viewing the results for each roll in a group and the calculation of the number of seats obtained for each roll. You can modify the calculated results.
Maintain Election Data - Seats	ELECTION_SEATS	Workforce Monitoring, Meet Regulatory Rqmts FRA, Election Monitoring, Maintain Election Data, Seats	Determine which candidates are declared elected for each roll. Generally, the candidate display-order entered on this page is more important than the actual number of votes each candidate received.
Runctl Ele001	RUNCTL_ELE001	Workforce Monitoring, Meet Regulatory Rqmts FRA, Election Monitoring, Election Report, Runctl Ele001	Run the Election report, which provides the results of the staff representative elections for employees and management.

Defining an Election

Access the Maintain Election Data - Group page.

Group

Select the groups that are present from the list of prompt values. To enter more than one group, insert additional data rows.

Voters

Enter the number of employee voters registered for this group.

Incumbent and Substitute

Enter the number of incumbents and substitutes affected by the election. The incumbent number is copied into the Substitute field, but you can overwrite this value.

Recording Candidacies for Election Groups

Access the Maintain Election Data - Roll page.

Roll

Enter rolls for each group by selecting them from the list of prompt values. To enter more than one roll for a group, insert additional rows.

Number of Candidates

Displays the number of candidates. By default, this number corresponds to the numbers of incumbents to be elected in the group. You can override this value.

Note. If you change the number of candidates at the roll level on the Roll page, the system inserts or deletes rows on the Votes page. The number of Candidate rows on the Votes page is synchronized with the number of candidates that is defined at the roll level on the Roll page.

Entering Voting Results

Access Maintain Election Data - Votes page.

This page shows three levels of the Reserved for Monitor French Elections group box.

Group

For the election in question, enter the number of Invalid, Blank, Altered, and Regular votes for each group.

Roll

Displays the roll as you entered it on the Roll page and the average number of Inc. (incumbent) and Sub. (substitute) votes.

Enter the number of altered votes and the number of regular votes for each roll.

Candidate

If you enter the number of incumbent votes and substitute votes at the candidate level, the system displays the average number of votes for the incumbents and substitutes at the roll level.

If you enter no votes at the candidate level, the number of regular votes entered at the roll level appears by default as 0 in both the Incumbent Votes and Substitute Votes fields at the candidate level.

Validating Election Results

Access the Maintain Election Data - Results page.

Group

For the election in question and for each group, displays a summary of Invalid, Blank, Altered, and Regular votes.

Turnout

Displays the turnout for the roll, which is a ratio calculated by adding the invalid, blank, and regular votes at the group level and dividing this number by the number of voters defined on the Group page.

Quorum

Selected by default if voter turnout for the group is greater than 50 percent. That is, the number of votes for a group (invalid, blank, and regular) is greater than the number of voters defined on the Group page divided by two.

Seat Value

Displays the seat value (electoral quotient), which is calculated at the group level by dividing the number of regular votes by the number of incumbents defined on the Group page. The seat value must be the same for all rolls in a group.

Election Validated

Select to validate the election.

Roll

Displays the number of incumbent votes and substitute votes entered on the Votes page at the roll level for a particular group.

Seats

Displays the number of seats to be allocated for the roll. This number is equal to the number of incumbent and substitute votes at the roll level divided by the seat value.

Indicator

Displays the number that is calculated by dividing the number of incumbent and substitute votes by the number in the Incumbent Results field and the Substitute Results field plus one.

Result

By default, displays the results from the calculation of the seats. You can change the results.

Determining Elected Candidates

Access the Maintain Election Data - Seats page.

Group

Displays a summary from the Results page for each group, indicating the turnout and seat value and whether a quorum was reached.

Roll

Displays the number of incumbent and substitute seats obtained for each roll. This is the value entered in the Results field on the Results page.

10% Rule (10 percent rule)

For each roll, select to indicate whether the decision to declare the candidates elected is made by applying the 10 percent rule.

Candidate

Displays the candidate number.

For each incumbent or substitute candidate, indicate the final order on the roll and whether the candidate was elected.

Preparing and Running the Employee Survey Report

This section provides an overview of the French Employee Survey reporting requirements and discusses how to:

Set up the Compute Employee Survey process.
Review calculation results.
Viewing predefined employee survey indicators for the Employee Survey report.

Understanding French Employee Survey Reporting Requirements

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.

Pages Used to Prepare and Run the Employee Survey Report

Page Name	Object Name	Navigation	Usage
Employee Survey Parameters	RUNCTL_EMSURVEY	Workforce Monitoring, Meet Regulatory Rqmts FRA, Employee Survey, Compute Employee Survey, Employee Survey Parameters	Set up the Compute Employee Survey process.
Employee Survey Paygroups	RUNCTL_EMSURVEY2	Workforce Monitoring, Meet Regulatory Rqmts FRA, Employee Survey, Compute Employee Survey, Employee Survey Parameters, Employee Survey Paygroups	Create a list of paygroups to refine the results of the Compute Employee Survey process.
Edit Employee Survey	EDIT_SHEET_FRA	Workforce Monitoring, Meet Regulatory Rqmts FRA, Employee Survey, Edit Employee Survey	Review, and modify if needed, the calculation results run by the Compute Employee Survey process on each of the indicators.
Employee Survey Report	RUNCTL_SOC001	Workforce Monitoring, Meet Regulatory Rqmts FRA, Employee Survey, Employee Survey Report	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.

Setting Up the Compute Employee Survey Process

Access the Employee Survey Parameters page.

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 the Years 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.

Access the Employee Survey Paygroups page to refine payroll results for the employee survey .

See Also

Enterprise PeopleTools 8.45 PeopleBook: PeopleSoft Process Scheduler

Reviewing Calculation Results

Access the Edit Employee Survey page.

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.

Viewing Predefined Employee Survey Indicators for the 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 lay off 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 10⁶ 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 nonemployee 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

Running Workforce Reporting Statutory Reports

The section provides prerequisites for the single hiring statement and discusses how to:

Run the Monthly Workforce report.
Run the Workforce by Nationality report.
Run the Personal Register report.
Run the Single Hiring Statement report.
Run the BIAF report.

Prerequisites for the Single Hiring Statement

The Single Hiring Statement retrieves information for new employees from your employee, company, and establishment tables. The following table lists the information that is required and the page where the information is entered for the employee.

Information	Page
Employee name Prefix	Workforce Administration, Personal Information, Biographical, Update Personal Information, Name History
Employee address	Workforce Administration, Personal Information, Biographical, Update Personal Information, Addresss History
Gender	Workforce Administration, Personal Information, Biographical, Update Personal Information, Personal History
Social security number Date of birth Nationality Previous work situation	Workforce Administration, Personal Information, Biographical, Update Personal Information, Identity/Diversity
Hire date	Workforce Administration, Hire Employee, Job Information, Work Location
SIRET number APE code Establishment address Establishment phone and fax number Establishment activity Medical organization code and address Company name Company/establishment point of contact	Define the employee's company and establishment on the following page: Workforce Administration, Increase Workforce, Hire Employee, Job Data, Work Location or, Workforce Administration, Job Information, Job Data, Work Location The system retrieves the company and establishment details from the Company table and Establishment table.
Job category Working hours	Workforce Administration, Job Information, Job Data, Job Information The system retrieves job category information from the Job Code table.
Contract end date	Workforce Administration, Job Information, Contract Administration, Update Contracts, Contract Status/Content
Contract type	Workforce Administration, Job Information, Contract Administration, Update Contracts, Contract Type/Clauses
Probation date	Workforce Administration, Job Information, Contract Administration, Update Contracts, Signature/Probation Info
Monthly gross salary	Workforce Administration, Job Information, Job Data, Compensation

Pages Used to Run the Workforce Reporting Statutory Reports

Page Name	Object Name	Navigation	Usage
Monthly Workforce Report	RUNCTL_REG001_FRA	Workforce Monitoring, Meet Regulatory Rqmts FRA, Required Reports, Monthly Workforce, Monthly Workforce Report	Run the Monthly Workforce report.
Workforce By Nationality	RUNCTL_REG003_FRA	Workforce Monitoring, Meet Regulatory Rqmts FRA, Required Reports, Workforce by Nationality	Run the Workforce by Nationality report.
Personal Register	RUNCTL_REG002_FRA	Workforce Monitoring, Meet Regulatory Rqmts FRA, Required Reports, Personal Register	Run the Personal Register report.
Single Hiring Statement	SHS_FRA_RUN_CTL	Workforce Monitoring, Meet Regulatory Rqmts FRA, Required Reports, Single Hiring Statement	Run the Single Hiring Statement report, which is a statutory report that is filed at the time of hiring new employees. The system uses information from your employee, company, and establishment tables to generate the report.
BIAF Report (Bordereau Individuel d'Accès à la Formation report)	RUNCTL_BIAF_FRA	Workforce Monitoring, Meet Regulatory Rqmts FRA, Required Reports, BIAF, BIAF Report	Run the BIAF report.

Running the Monthly Workforce Report

Access the Monthly Workforce Report page.

This report lists the monthly personnel changes for a given establishment of a company. This report is required for all organizations that employ 50 or more employees.

Before running this report, define which contract types to include in the report using the Contract Type Group page.

Running the Workforce by Nationality Report

Access the Workforce By Nationality page.

This report provides a comprehensive analysis of the foreign workforce employed in a company.

Running the Personal Register Report

Access the Personal Register Report page.

This report lists employees for a given establishment of a company. Run the report for a specific establishment within an organization or for all establishments of an organization.

Running the Single Hiring Statement Report

Access the Single Hiring Statement page.

You can automate the production of this report using workflow supplied by PeopleSoft. If you enable workflow, when an employee is hired, workflow adds an entry to the HR administrator’s task list for the Single Hiring Statement.

Employee Selection Criteria

There are three ways to select the employees whom you want to include in the report. Depending on the method that you select, the system hides or displays fields.

By Hire Date	Select to generate the Single Hiring Statement report for all employees hired within a specified period. Enter the date range in the Employee Hired Between group box.
By Employee ID	Select to run the report for selected employee IDs. Use this option if you know the new employee IDs. Select the employees in the Employee List group box.
By Group	Select to generate the report for employees in a group. The system displays the Group ID field when you select this option.
Refresh	When you have defined the selection criteria, click this button to populate the Employee List group box with new employees who meet the criteria.
Clear	Click to clear the Employee List. The system removes all employees listed.

Employees Hired Between

This group box appears if you select By Hire Date only. Select the start and end dates for the report. The system searches for employees who were hired between these dates.

Start Date

The default start date is the end date entered the last time that the Single Hiring Statement was run.

Employee List

When you click the Refresh button, the system populates this group box with new employees who meet the criteria that you selected. You can also add employees to the list.

For each employee listed, complete the Estimates Hire Time field and select the Exemption if First Hired and the Exemption if Part-Time check boxes, if necessary. This information is printed on the report.

Running the BIAF Report

Access the BIAF Report page.

This report is for employees on fixed-term contracts and details the employee's training entitlement. French employers are required to contribute towards employee training through payments to official training organizations. The BIAF report includes information about the training organization that receives the employer's contributions and the terms and conditions of the training entitlement. You can print this report at any time during the employee's contract period.

You can run the BIAF report for:

Individual employees, by adding employees to the List of Employee(s) group box.
A group of employees, by selecting a group in the Group ID field.

Note. You must complete the From Date and Thru Date fields, whether you run the report for selected employees or for a group of employees.

Contract Type	Select the type of fixed term contract from the following options: Limited Contract, Fixed Term Adaptation Contract, or Fixed Term Emp. Init Contract. The report includes only employees with the selected contract type. If you leave this field blank, the report includes employees with any of these contract types.
From Date and Thru Date	Select the hiring period for the report. The system searches for employees on fixed-term contracts whose hiring date is between the dates you specify.
Group ID	Select the group of employees to include in the report. The system searches the group for employees who meet the criteria defined in the Contract Type and From/Thru Date fields.
List of Employee(s)	To run the BIAF report for certain employees, add the employees to this group box.

Preparing and Running the Training 2483 Report

This section provides overviews of the Training 2483 reporting requirements, classification of Training 2483 report indicators, and calculation of report indicators.

(FRA) Meet Regulatory Requirements Reports for France

Enterprise PeopleTools 8.45 PeopleBook: PeopleSoft Application Engine

Understanding the Training 2483 Reporting Requirements

The Training 2483 (also called the Declaration 2483 report) is a French regulatory report that compiles information about the amount of money that a company has spent on employee vocational training. PeopleSoft delivers the definition of the legal groups and indicators with the system.

To prepare the Training 2483 report:

Set up training report groups.
Set up training report indicators.
Enter training report parameters.
Run the Compute Training Report 2483 (DEC2483) process calculation for all indicators.
(Optional) Review and edit the results of the process calculations.
Run the Training Report 2483 (TRN029) to print (or export to a file) the results of the process calculations.

Understanding Classification of Training 2483 Report Indicators

This section contains information about the indicators that PeopleSoft provides for the Training 2483 report, and it discusses how these indicators are used. The indicators are classified by group and designated by letters B through M. Each letter represents a particular description. For example, B represents general information while C represents costs summary information. Indicators are either delivered by application process (calculated) or manually compiled.

List of PeopleSoft Indicators Classified by Group

The following table lists the indicators by group:

Group ID	Indicator ID	Indicator Description	Comments	Delivery
B	1	General Information		Calculated
B	2	Male		Calculated
B	3	Female		Calculated
B	4	Male + Female		Calculated
B	8	Apprentice Contracts		Calculated
B	9	Back to Work Contracts		Calculated
B	10	Adap. Qual. Contracts		Calculated
B	11	Number of Establishments		Calculated
C	1	Internal Training Cost		Calculated
C	2	Equipment Cost		Manually entered
C	3	Competency Checks, Experience Validation, Annual Agreements, and Multi-Annual Agreements		Calculated
C	4	Salary Costs for Regular Courses, Experience Validation, and Competency Checks		Calculated
C	5	Lodging and Transportation Costs		Calculated
C	6	Training Requirement Estimat.		Manually entered
C	7	EDDF Cost		Calculated
C	8	OPCA - Training Plan Payment		Manually entered
C	9	OPCA - Trn Saving Acc. Payment		Manually entered
C	10	OPCA - Training Leave Payment		Manually entered
C	11	Part-Time Course Financing	This indicator is equal to indicator G–14.	Calculated
C	12	Other Financing, Cost		Manually entered
C	13	Total	This indicator is the sum of indicators C1 to C12.	Calculated
C	14	Subsidy		Manually entered
C	15	Chargeable Cost	This indicator is equal to indicator C13 minus indicator C14.	Calculated
D	1	Trn Plan & Trn Saving Account		Manually Entered
D	2	Part-Time Training		Manually Entered
D	3	Training Leave		Manually Entered
E	1,2,3,4,5,6	Carry-Forward Surplus		Manually entered
F	1	Total Annual Salaries	May be retrieved from DADS1 reporting if PeopleSoft Global Payroll is installed.	Manually entered
F	2	Employer Participation	Depends on whether or not the company is a temporary employment agency.	Calculated
F	3	Participation with Reduction		Calculated
F	4	Total Training Cost	Equals indicator C15	Calculated
F	5	Expense Surplus	This indicator is equal to indicator F4 minus indicator F3. If the result is less than zero, this indicator is set to zero.	Calculated
F	6	Expense Insufficiency	This indicator is equal to indicator F–2 or indicator F–3 minus indicator F–4	Calculated
F	7	Training Tax Credit	This indicator is equal to the sum of indicators E1, E2, and E3	Calculated
F	8	Indicator 6 - Indicator 7.	This indicator is equal to indicator F6 minus indicator F7. If the result is less than zero, this indicator is set to zero.	Calculated
G	9	Employer Obligation	The percentage depends on whether or not the company is liable for the earning year's taxed apprentissage.	Calculated
G	10	Obligation with Reduction		Calculated
G	11	OPCA Payments		Manually entered
G	12	Employer Fixed Expense		Manually entered
G	13	Indicator 10 - (11 + 12)	G10 − (G11 + G12)	Calculated
G	14	Total 11 to 13	G11 + G12 + G13	Calculated
H	15	Employer Obligation	Percentage depends whether or not the company hires only temporary workers.	Calculated
H	16	Obligation with Reduction		Calculated
H	17	OPCA Payments - Part Time		Manually entered
H	18	OPCA Payments - Train. Leave		Manually entered
H	19	Indicator 16 - (17+18)	G16 − (G17 + G18)	Calculated
J	20	CDD Total Annual Salariess		Manually entered
J	21	Employer Obligation		Calculated
J	22	OCPA CIF Payments		Manually entered
J	23	Indicator 21 - 22		Calculated
K	24	Training Cost Insufficiency	This indicator is equal to indicator F8.	Calculated
K	25	Regularization Payment		Manually entered
K	26	Payment/Company Work Council	The amount of the regularization payment is (F2 or F3)/2.	Manually entered
K	27	CIF Insufficiency	This indicator is equal to indicator H19.	Calculated
K	28	CIF/CDD Insufficiency	This indicator is equal to indicator J23.	Calculated
K	29	Part-Time Insufficiency	This indicator is equal to indicator G13.	Calculated
K	30	Total Contribution	K24 + K25+ K26 + K27 +K28+ K29	Calculated
L	2	Male students paid by company		Calculated
L	3	Female students paid by cmpny		Calculated
L	4	Total students paid by company		Calculated
L	5	Students paid by training fund		Calculated
L	6	Total hours paid by company		Calculated
L	7	Total hours paid by trng fund		Calculated
L	8	Number of competency checks		Calculated
L	9	Stdnts exclusively paid by cmp		Calculated
L	10	Stdnts paid by financing body		Calculated
L	11	Number of Competency Check		Calculated
L	12			Calculated
L	13			Calculated
L	14			Calculated
M	1	Male Students		Calculated
M	2	Female Students		Calculated

Understanding Calculation of the Report Indicators

This section is for implementers of the Training 2483 report. Some indicators are calculated based on the data existing in the Administer Training business process in Human Resources. Others are calculated based on parameters that you input into the system through the Trn 2483 Parameters Setup (Training 2483 parameters setup) page.

Training costs are obtained from the Maintain Student Cost page, employee and instructor salary costs are obtained from the Trainees Salary Costs page, and the company costs are obtained from the Trn 2483 Parameters Setup page.

The Training 2483 report is complex. For some indicators, several conditions must be fulfilled for the indicators to be correctly calculated:

The session start and end dates must be within a single calendar year.

Sessions that start in December and end in January will not be processed and must be split into two sessions to assign the costs to the correct declaring year.
Costs are only obtained from departments that are part of the declaring company.

The chargeable costs and the chargeability criteria are computed by the Compute Student Costs process. The 2483 process computes the total compensation and expense aggregation.

This section lists records and fields to be completed in order to retrieve values for the indicators that are calculated based on data tracked in the Administer Training business process. These fields are used in SQL joins. Note that the order of the fields displayed in these tables doesn’t necessarily match the order of the keys in the related records.

Calculation of Group B Indicators

The selection for all group B indicators works in the same manner. It is based on the 2483–B-nn contract type group, where n is the indicator number.

To calculate group B indicators:

Set up an employee contract on the Contract Type Table page and link the employee to a collective agreement on the Job Data - Job Labor page.
Set the employee status to Active, Leave of Absence, or Leave With Pay.
Set up the 2483 Professional Category field as CAD, OQU, EMP, AGM or ONQ on the Employee Categorization page.

PS_JOB A	PS_PERSONAL_ DATA B	PS_EMPL_CTG_L1 C	PS_CONTRACT_DATA D
A.EMPLID	B.EMPLID	C.CATEGORY_2483_FRA	D.EMPLID
A.EMPL_RCD	B.SEX	C.EMPL_CTG	D.CONTRACT_NUM
A.EFFDT		C.LABOR_AGREEMENT
A.EFFSEQ
A.EMPL_STATUS
A.EMPL_CTG
A.LABOR_AGREEMENT

Calculation of Indicator C1 - Internal Training Cost: Instructor Expenses

The calculation rules for the indicator C1 - Internal Training Cost: Instructor Expenses are based on the following costs:

Internal instructor costs are defined on the Course Session Costs component and the Instructors pages.
Non-Instructor Employee Expense Costs are defined on the Course Session Costs component and according to the 2483 indicator on the Tuition Expense Type Table page.
Non-Instructor Session Expense Costs are defined on the Course Session Costs component and according to the 2483 indicator on the Tuition Expense Type Table page.
Furniture Employee Expense Costs are defined on the Course Session Costs component and according to the 2483 indicator on the Tuition Expense Type Table page.

To calculate indicator C1 - Internal Training Cost: Instructor Expenses:

Set up the employee status as Active, Leave of Absence, or Leave With Pay.
Terminate the training session in which the employees were enrolled.
Organize the training session by the company (SESSN_ORGANIZER = Y).

PS_JOB A	CRSE_SESS_INSTR (not system maintained) TRN_EE_SAL_COST (system maintained) Note. For external instructors, the process obtains costs from the instructor setup table. Non-full time instructors are included in this indicator.	PS_CRSE_SESSN_TBL C
A.EMPLID	B.CHARGEABLE_CST_FRA	C.COURSE
A.EMPL_RCD	B.COURSE	C.COURSE_END_DT
A.EFFDT	B.CURRENCY_CD	C.COURSE_START_DT
A.EFFSEQ	B.EMPLID	C.SESSION_NBR
A.EMPL_STATUS	B.SESSION_NBR	C.SESSION_STATUS
		C.SESSN_ORGANIZER

Calculation of Indicator C1 - Internal Training Cost: Non-instructor Personnel Expenses

The following training costs are considered for this indicator:

Furniture and equipment expenses.

This cost category includes equipment and furniture required for the training.
Other expenses.

This cost category includes all of the expenses that do not fall into the previous categories and are chargeable for the 2483 report. For example:
- Facility rental, cleaning, heating, and electricity.
- Expense related to the training organization, such as book rental, furniture rental, and document duplication.
- Magazine subscriptions.
- Administrative organization, which would include stamps, envelopes, telephones, and others.
- Costs related to training demand evaluation and Training Plan elaboration.
- Transport and lodging for instructors.

To calculate indicator C1 - Internal Training Cost: Non-instructor Personnel Expenses:

Set up the employee status to Active, Leave of Absence, or Leave With Pay.
Terminate the training session in which the employees were enrolled.
Organize the training session by the company (SESSN_ORGANIZER = Y).
Set the tuition expense type for 2483 as NIN on the Tuition Expense Type Table page.

PS_JOB A	PS_TRN_SSEXPN_COST B TRN_EEEXPN_COST	PS_CRSE_SESSN_TBL C	PS_TUIT_EXPEN_TBL D
A.EMPLID	B.CHARGEABLE_CST_FRA	C.COURSE	D.EFFDT
A.EMPL_RCD	B.COURSE	C.COURSE_END_DT	D.TUIT_EXPENSE_TYPE
A.EFFDT	B.CURRENCY_CD	C.COURSE_START_DT	D.TYPE_2483_FRA
A.EFFSEQ	B.EMPLID	C.SESSION_NBR
A.EMPL_ STATUS	B.EXPENSE_TYPE	C.SESSION_STATUS
	B.SESSION_NBR	C.SESSN_ORGANIZER

Indicator C1 is the sum of the instructor expenses, non-instructor personnel expenses, and furniture expenses.

Note. Record TRN_EEEXPN_COST is updated manually in the Track Student Costs component.

Calculation of Indicator C3 - Competency Checks, Experience Validation, Annual Agreements, and Multi-Annual Agreements

To calculate indicator C3 - Competency Checks, Experience Validation, Annual Agreements, and Multi-Annual Agreements:

Set up the employee status to Active, Leave of Absence, or Leave With Pay.
Terminate the training session in which the employees were enrolled.
Set the course type to Competency Check in the Course Table report.
The vendor type must be annual or multi-annual.
Ensure that the vendor is chargeable, certified, billed and the date of the bill is filled. Set these values in the Course Session Cost - Vendor page.

PS_JOB A	PS_TRN_EEPROV_COST B	PS_COURSE_TBL C	PS_CRSE_SESSN_ TBL D
A.EMPLID	B.CHARGEABLE_CST_FRA	C.COURSE	D.COURSE
A.EMPL_RCD	B.COURSE	C.COURSE_TYPE	D.COURSE_END_DT
A.EFFDT	B.COURSE		D.COURSE_START_ DT
A.EFFSEQ	B.CURRENCY_CD		D.SESSION_NBR
A.EMPL_STATUS	B.EMPLID		D.SESSION_STATUS
	B.SESSION_NBR

Calculation of Indicator C4 - Salary Costs for Regular Courses, Experience Validation, and Competency Checks

This indicator includes employee salary costs that are entered on the Maintain Student Costs page.

There are three possible methods to compute salary costs:

Paid Salary.

The employee's salary is prorated for each session, then the sum of all sessions is calculated.
Theoretical.

The process calculates the employee's total annual compensation, and the total duration of all sessions. Then the process calculates the total compensation multiplied by the number of paid hours, divided by the duration of all sessions.
Median.

This is calculated in the same manner as the theoretical method, however, the process uses the average salary of the employee, rather than loading a value from Global Payroll.

To calculate indicator C4 - Salary Costs for Regular Courses, Experience Validation, and Competency Checks:

Set up the employee status to Active, Leave of Absence, or Leave With Pay.
Terminate the training session in which the employees were enrolled.

PS_JOB A	PS_TRN_EESAL_COST B	PS_CRSE_SESSN_TBL C
A.EMPLID	B.CHARGEABLE_CST_FRA	C.COURSE
A.EMPL_RCD	B.COURSE	C.COURSE_END_DT
A.EFFDT	B.CURRENCY_CD	C.COURSE_START_DT
A.EFFSEQ	B.EMPLID	C.SESSION_NBR
A.EMPL_STATUS	B.SESSION_NBR	C.SESSION_STATUS

Calculation of Indicator C5 - Transportation and Lodging Costs

To calculate indicator C5 - Transportation and Lodging Costs:

Set up the employee status to Active, Leave of Absence, or Leave With Pay.
Terminate the training session in which the employees were enrolled.
Organize the training session by the company (SESSN_ORGANIZER = Y).
Set the tuition expense type for 2483 as LAT or RESon the Tuition Expense Type Table page.

PS_JOB A	PS_TRN_SSEXPN_COST B TRN_EEEXPN_COST	PS_CRSE_SESSN_TBL C	PS_TUIT_EXPEN_TBL D
A.EMPLID	B.CHARGEABLE_CST_FRA	C.COURSE	D.EFFDT
A.EMPL_RCD	B.COURSE	C.COURSE_END_DT	D.TUIT_EXPENSE_TYPE
A.EFFDT	B.CURRENCY_CD	C.COURSE_START_DT	D.TYPE_2483_ FRA
A.EFFSEQ	B.EMPLID	C.SESSION_NBR
A.EMPL_STATUS	B.EXPENSE_TYPE	C.SESSION_STATUS
	B.SESSION_NBR

Calculation of Indicator C7 - Professional Training Development

This indicator regroups all of the costs generated by courses that are related to an EDDF agreement.

The 2483 process reports on this indicator all the session costs related to EDDF courses. Session costs include salary costs, vendor costs, facility costs, instructor costs, equipment costs, session and employee expense costs. Unlike the cost computation done for Group C – line 1, this indicator includes financed amounts as well. This is not the computed chargeable cost, but the entered costs.

Because full-time instructors and external instructors are fully chargeable, the costs related to full-time instructors and external instructors are already included in indicator C – line 1. So, only non-full time internal instructors are included in this indicator. If an external instructor has to be charged for an EFFDT session and should appear in this indicator, you must specify a vendor type of Instructor.

To calculate indicator C7 - Professional Training Development:

Calculation of Indicators L2, L3, and L4 − Male, Female, and Total Students Paid by the Company

The following criteria are necessary to include a student in this indicator:

Students with company costs and no financing amount.
Students must have begun or completed a session during the year that the 2483 is based upon.

(session attendance = ‘C’=Complete or ‘I’=Incomplete).
The training session must be chargeable.
Training leave sessions and part time sessions are not reported in this indicator.
Students that have an Apprentice contract type are not included.
Students enrolled multiple times are reported only once.
The competency check course type is not included in this indicator.

To calculate indicators L2, L3, and L4 - Male, Female, and Total Students Paid by the Company:

Set up the employee status to Active, Leave of Absence, or Leave with Pay.
Ensure that employees are not on a training leave (TRAINING_LEAVE_FRA = N).
Ensure that the course is not a part time course (PART_TIME_CRSE_FRA = N).

PS_JOB A	PS_TRAINING B	PS_TRN_EESAL_COST C	PS_PERSONAL_ DATA D
A.EMPLID	B.COURSE	C.COURSE	D.EMPLID
A.EMPL_RCD	B.COURSE_END_DT	C.EMPLID	D.SEX
A.EFFDT	B.COURSE_START_ DT	C.FINANCING_FUND_FRA
A.EFFSEQ	B.EMPLID	C.SESSION_NBR
A.EMPL_STATUS	B.PART_TIME_CRSE_ FRA
A.EMPL_CTG	B.SESSION_NBR
A.LABOR_AGREEMENT	B.TRAINING_LEAVE_ FRA

PS_EMPL_CTG_L1 E	PS_TRN_EEEXPN_COST G	PS_TRN_SSEXPN_COST H	PS_TRN_EEPROV_COST J
E.CATEGORY_2483_FRA	G.COURSE	H.COURSE	J.COURSE
E.EMPL_CTG	G.EMPLID	H.EMPLID	J.EMPLID
E.LABOR_AGREEMENT	G.FINANCING_FUND_FRA	H.FINANCING_FUND_FRA	J.FINANCING_FUND_FRA
	G.SESSION_NBR	H.SESSION_NBR	J.SESSION_NBR

Calculation of Indicator L5 - Students Paid by Training Fund

The following criteria are necessary to include a student in this indicator:

Students must have at least one chargeable cost with OPCA as a financing organization.
Students must have begun or completed a session during the year that the 2483 is based upon.

(session attendance = ‘C’=Complete or ‘I’=Incomplete).
The training session must be chargeable.
Training leave sessions and part time sessions are not reported in this indicator.
Students that have an Apprentice contract type are not included.
Students enrolled multiple times are reported only once.
The competency check course type is not included in this indicator.

To calculate indicator L5 - Students Paid Partially or Totally By a Registered Body:

Set up the employee status to Active, Leave of Absence, or Leave with Pay.
Ensure that employees are not on a training leave (TRAINING_LEAVE_FRA = N).
Ensure that the course is not a part time course (PART_TIME_CRSE_FRA = N).

PS_JOB A	PS_TRAINING B	PS_TRN_EESAL_ COST C	PS_PERSONAL_ DATA D
A.EMPLID	B.COURSE	C.COURSE	D.EMPLID
A.EMPL_RCD	B.COURSE_END_DT	C.EMPLID	D.SEX
A.EFFDT	B.COURSE_START_DT	C.FINANCED_COST_ FRA
A.EFFSEQ	B.EMPLID	C.FINANCING_FUND_ FRA
A.EMPL_STATUS	B.PART_TIME_CRSE_ FRA	C.SESSION_NBR
A.EMPL_CTG	B.SESSION_NBR
A.LABOR_AGREEMENT	B.TRAINING_LEAVE_FRA

PS_EMPL_CTG_L1 E	PS_TRN_EEEXPN_COST F	PS_TRN_SSEXPN_COST G	PS_TRN_EEPROV_ COST J
E.CATEGY_2483_FRA	F.COURSE	G.COURSE	J.COURSE
E.EMPL_CTG	F.EMPLID	G.EMPLID	J.EMPLID
E.LAB_AGREEMNT_ FRA	F.FINANCED_COST_FRA	G.FINANCED_COST_FRA	J.FINANCED_COST_ FRA
	F.FINANCING_FUND_FRA	G.FINANCING_FUND_ FRA	J.FINANCING_FUND_ FRA
	F.SESSION_NBR	G.SESSION_NBR	J.SESSION_NBR

Calculation of Indicator L6 - Total Hours Paid by the Company

The following criteria are necessary to compute session duration for this indicator:

Students must have company costs and no financing amount.
Students must have begun or completed a session during the year that the 2483 is based upon.

(session attendance = ‘C’=Complete or ‘I’=Incomplete).
The training session must be chargeable.
Training leave sessions and part time sessions are not reported in this indicator.
Students that have an Apprentice contract type are not included.
Students enrolled multiple times are reported only once.
All session durations will be included for students enrolled multiple times.

When the attendance status is C, the session duration is obtained from the Session Setup page. If the attendance status is I, the duration is obtained from the Time Spent at Training field on the Course Session Enrollment page.
The competency check course type is not included in this indicator.

To calculate indicator L6 - Total Hours Paid by the Company:

Set up the employee status to Active, Leave of Absence, or Leave With Pay.
Ensure that employees are not on a training leave (TRAINING_LEAVE_FRA = N).
Ensure that the course is not a sandwich course (PART_TIME_CRSE_FRA = N).
Ensure that the trainees have the appropriate attendance status.
Complete the training session.

PS_JOB A	PS_TRAINING B	PS_TRN_EEEXPN_COST C	PS_PERSONAL_ DATA D
A.EFFDT	B.ATTENDANCE	C.COURSE	D.EMPLID
A.EFFSEQ	B.COURSE	C.EMPLID	D.SEX
A.EMPL_RCD	B.COURSE_END_DT	C.FINANCING_FUND_FRA
A.EMPL_STATUS	B.COURSE_START_DT	C.SESSION_NBR
A.EMPLID	B.EMPLID
A.EMPL_CTG	B.PART_TIME_CRSE_FRA
A. LABOR_AGREEMENT	B.SESSION_NBR
	B.TRAINING_LEAVE_FRA

PS_EMPL_CTG_L1 E	PS_TRN_EESAL_COST G	PS_TRN_SSEXPN_ COST J	PS_TRN_EEPROV_ COST K	PS_CRSE_SESSN_TBL L
E.CATEGORY_2483_FRA	G.COURSE	J.COURSE	K.COURSE	L.COURSE
E.EMPL_CTG	G.FINANCING_FUND_FRA	J.FINANCING_FUND_ FRA	K.EMPLID	L.DURATION_CONVERTED
E.LABOR_AGREEMENT	G.SESSION_NBR	J.SESSION_NBR	K.FINANCING_ FUND_FRA	L.SESSION_NBR
			K.SESSION_NBR	L.SESSION_STATUS

Calculation of Indicator L7 - Total Hours Paid by Training Fund

The following criteria are necessary to compute session duration in this indicator:

Students must have at least one chargeable cost with OPCA as a financing organization.
Students must have begun or completed a session during the year that the 2483 is based upon.

(session attendance = ‘C’=Complete or ‘I’=Incomplete).
The training session must be chargeable.
Training leave sessions and part time sessions are not reported in this indicator.
Students that have an Apprentice contract type are not included.
Students enrolled multiple times are reported only once.
All session durations will be included for students enrolled multiple times.

When the attendance status is C, the session duration is obtained from the Session Setup page. If the attendance status is I, the duration is obtained from the Time Spent at Training field on the Course Session Enrollment page.
The competency check course type is not included into this indicator.

To calculate indicator L7 - Total Hours Paid by a Registered Body:

Set up the employee status to Active, Leave of Absence, or Leave With Pay.
Ensure that employees are not on a training leave (TRAINING_LEAVE_FRA = N).
Ensure that the course is not a sandwich course (PART_TIME_CRSE_FRA = N).
Ensure that the trainees have the appropriate attendance status.

If attendance status is C, the system uses the total number of hours. If attendance status is I, the system extracts the total number of hours considered from the Time Spent at Training field on the Course Session Enrollment page.
Complete the training session.

PS_JOB A	PS_TRAINING B	PS_TRN_EEEXPN_COST C	PS_PERSONAL_ DATA D
A.EFFDT	B.ATTENDANCE	C.COURSE	D.EMPLID
A.EFFSEQ	B.COURSE	C.EMPLID	D.SEX
A.EMPL_RCD	B.COURSE_END_DT	C.FINANCED_COST_FRA
	B.COURSE_START_DT	C.FINANCING_FUND_FRA
A.EMPL_STATUS	B.EMPLID	C.SESSION_NBR
A.EMPLID	B.PART_TIME_CRSE_FRA
A. EMPL_CTG	B.SESSION_NBR
A. LABOR_AGREEMENT	B.TRAINING_LEAVE_FRA

PS_EMPL_CTG_L1 E	PS_TRN_EESAL_COST G	PS_TRN_SSEXPN_COST J	PS_TRN_EEPROV_ COST K	PS_CRSE_SESSN_TBL L
E.CATEGORY_2483_FRA	G.COURSE	J.COURSE	K.COURSE	L.COURSE
E.EMPL_CTG	G.EMPLID	J.EMPLID	K.EMPLID	L.DURATION_CONVERTED
E.LABOR_AGREEMENT	G.FINANCED_COST_ FRA	J.FINANCED_COST_FRA	K.FINANCED_COST_FRA	L.SESSION_NBR
	G.FINANCING_FUND_ FRA	J.FINANCING_FUND_FRA	K.FINANCING_ FUND_FRA	L.SESSION_STATUS
	G.SESSION_NBR	J.SESSION_NBR	K.SESSION_NBR

Calculation of Indicator L8 - Number of Competency Checks

The following criteria are necessary to count competency check courses in this indicator:

Students must be enrolled in a competency check course.
Students must have company costs and no financing amount.
Students must have begun or completed a session during the year that the 2483 is based upon.

(session attendance = ‘C’=Complete or ‘I’=Incomplete).
The training session must be chargeable.
Training leave sessions and part time sessions are not reported in this indicator.
Students that have an Apprentice contract type are not included.
Students enrolled multiple times are reported only once.
All session durations will be included for students enrolled multiple times.

When the attendance status is C, the session duration is obtained from the Session Setup page. If the attendance status is I, the duration is obtained from the Time Spent at Training field on the Course Session Enrollment page.
The competency check course type is included into this indicator.

To calculate indicator L8 - Number of Competency Checks:

Set up the employee status to Active, Leave of Absence, or Leave With Pay.
Ensure that employees are not on a training leave (TRAINING_LEAVE_FRA = N).
Ensure that the course is not a sandwich course (PART_TIME_CRSE_FRA = N).
Set up the course type as Competency Check in the Course Table Report component.

PS_JOB A	PS_TRAINING B	PS_TRN_EESAL_COST C	PS_PERSONAL_ DATA D
A.EFFDT	B.COURSE	C.COURSE	D.EMPLID
A.EFFSEQ	B.COURSE_END_DT	C.EMPLID	D.SEX
A.EMPL_RCD	B.COURSE_START_DT	C.FINANCED_COST_FRA
A.EMPL_STATUS	B.EMPLID	C.SESSION_NBR
A.EMPLID	B.PART_TIME_CRSE_FRA
A. EMPL_CTG	B.SESSION_NBR
A. LABOR_AGREEMENT	B.TRAINING_LEAVE_FRA

PS_EMPL_CTG_L1 E	PS_COURSE_TBL F	PS_TRN_EEEXPN_COST G	PS_TRN_SSEXPN_ COST H	PS_TRN_EEPROV_COST K
E.CATEGORY_2483_FRA	F.COURSE	G.COURSE	H.COURSE	K.COURSE
E.EMPL_CTG	F.COURSE_TYPE	G.EMPLID	H.EMPLID	K.EMPLID
E.LABOR_AGREEMENT		G.FINANCED_COST_FRA	H.FINANCED_COST_FRA	K.FINANCED_COST_FRA
		G.SESSION_NBR	H.SESSION_NBR	K.SESSION_NBR

Calculation of Indicator L10 - Students Exclusively Paid by the Company

The following criteria are necessary to include a student in this indicator:

Students must have company costs and no financing amount.
Students must have begun or completed a session during the year that the 2483 is based upon.

(session attendance = ‘C’=Complete or ‘I’=Incomplete).
The training session must be chargeable.
Only training leave sessions are reported in this indicator.
Students that have an Apprentice contract type are not included.
Students enrolled multiple times are reported only once.
The competency check course type is not included in this indicator.

To calculate indicator L10 - Students Exclusively Paid by the Company:

Set up the employee status to Active, Leave of Absence, or Leave With Pay.
Ensure that employees are on a training leave (TRAINING_LEAVE_FRA = Y).
Ensure that no financing fund is involved in the financing of this type of course (FINANCING_FUND_FRA = <blank>).

PS_JOB A	PS_TRAINING B	PS_TRN_EEEXPN_COST C	PS_PERSONAL_ DATA D
A.EFFDT	B.COURSE	C.COURSE	D.EMPLID
A.EFFSEQ	B.COURSE_END_DT	C.EMPLID	D.SEX
A.EMPL_RCD	B.COURSE_START_DT	C.FINANCING_FUND_FRA
A.EMPL_STATUS	B.EMPLID	C.SESSION_NBR
A.EMPLID	B.SESSION_NBR
A. EMPL_CTG	B.TRAINING_LEAVE_FRA
A. LABOR_AGREEMENT

PS_EMPL_CTG_L1 E	PS_TRN_EESAL_COST G	PS_TRN_SSEXPN_COST J	PS_TRN_EEPROV_COST K
E.CATEGORY_2483_FRA	G.COURSE	J.COURSE	K.COURSE
E.EMPL_CTG	G.EMPLID	J.EMPLID	K.EMPLID
E.LABOR_AGREEMENT	G.FINANCING_FUND_ FRA	J.FINANCING_FUND_ FRA	K.FINANCING_ FUND_FRA
	G.SESSION_NBR	J.SESSION_NBR	K.SESSION_NBR

Calculation of Indicator L11 - Students Paid by Financing Body

This indicator is similar to indicator L –10 except that the 2483 process computes the number of students who have at least one chargeable cost with OPCA as a financing organization. In addition, the OPCA should have an OPACIF financing type.

The following criteria are necessary to include a student in this indicator:

Students must have at least one chargeable cost with OPCA as a financing organization.
Students must have begun or completed a session during the year that the 2483 is based upon.

(session attendance = ‘C’=Complete or ‘I’=Incomplete).
The training session must be chargeable.
Only training leave sessions are reported in this indicator.
Students that have an Apprentice contract type are not included.
Students enrolled multiple times are reported only once.
The competency check course type is not included in this indicator.

To calculate indicator L11 - Students Paid by Financing Body:

Set up the employee status to Active, Leave of Absence, or Leave With Pay.
Ensure that employees are on a training leave (TRAINING_LEAVE_FRA = Y).

PS_JOB A	PS_TRAINING B	PS_TRN_EEEXPN _ COST C	PS_ PERSONAL _ DATA D
A.EFFDT	B.COURSE	C.COURSE	D.EMPLID
A.EFFSEQ	B.COURSE_END_DT	C.EMPLID	D.SEX
A.EMPL_RCD	B.COURSE_START_ DT	C.FINANCED_COST_ FRA
A.EMPL_STATUS	B.EMPLID	C.FINANCING_FUND_ FRA
A.EMPLID	B.SESSION_NBR	C.SESSION_NBR
A. EMPL_CTG	B.TRAINING_LEAVE_ FRA
A. LABOR_AGREEMENT

PS_EMPL_CTB_L1 E	PS_TRN_EESAL _ COST G	PS_TRN_SSEXPN _COST J	PS_TRN_EEPROV _COST K
E.CATEGORY_2483_FRA	G.COURSE	J.COURSE	K.COURSE
E.EMPL_CTG	G.EMPLID	J.EMPLID	K.EMPLID
E.LABOR_AGREEMENT	G.FINANCED_COST_ FRA	J.FINANCED_COST_FRA	K.FINANCED_ COST_FRA
	G.FINANCING_FUND_FRA	J.FINANCING_FUND_FRA	K.FINANCING_ FUND_FRA
	G.SESSION_NBR	J.SESSION_NBR	K.SESSION_NBR

Calculation of Indicator L12 - Competency Checks

This indicator is similar to indicator L –11 except that only competency check course types are included.

The following criteria are necessary to include a student in this indicator:

Students must have at least one chargeable cost with OPCA as a financing organization.

The OPCA should have an OPACIF financing type.
Students must have begun or completed a session during the year that the 2483 is based upon.

(session attendance = ‘C’=Complete or ‘I’=Incomplete).
The training session must be chargeable.
Only training leave sessions are reported in this indicator.
Students that have an Apprentice contract type are not included.
Students enrolled multiple times are reported only once.
Only the competency check course type is included in this indicator.

To calculate indicator L12 - Competency Checks:

Set up the employee status to Active, Leave of Absence, or Leave With Pay.
Ensure that employees are on a training leave (TRAINING_LEAVE_FRA = Y).
Set the course type to Competency Check (COURSE_TYPE = O) in the Course Table Report component.

PS_JOB A	PS_TRAINING B	PS_TRN_EEEXPN _COST C	PS_PERSONAL _ DATA D
A.EFFDT	B.COURSE	C.COURSE	D.EMPLID
A.EFFSEQ	B.COURSE_END_DT	C.EMPLID	D.SEX
A.EMPL_RCD	B.COURSE_START_DT	C.FINANCED_COST_FRA
A.EMPL_STATUS	B.EMPLID	C.FINANCING_FUND_FRA
A.EMPLID	B.SESSION_NBR	C.SESSION_NBR
A. EMPL_CTG	B.TRAINING_LEAVE_ FRA
A. LABOR_AGREEMENT

PS_EMPL_CTG_L1 E	PS_COURSE_TBL F	PS_TRN_EESAL_COST G	PS_TRN_SSEXPN_ COST J	PS_TRN_EEPROV_COST K
E.CATEGORY_2483_FRA	F.COURSE	G.COURSE	J.COURSE	K.COURSE
E.EMPL_CTG	F.COURSE_TYPE	G.EMPLID	J.EMPLID	K.EMPLID
E.LABOR_AGREEMENT		G.FINANCED_COST_FRA	J.FINANCED_ COST_FRA	K.FINANCED_COST_FRA
		G.FINANCING_FUND_FRA	J.FINANCING_ FUND_FRA	K.FINANCING_FUND_FRA
		G.SESSION_NBR	J.SESSION_NBR	K.SESSION_NBR

Calculation of Indicator L14 - Total of Hours Paid by the Company: Training Leaves and Competency Checks

The following criteria are necessary to compute session duration for this indicator:

Students must have company costs and no financing amount.
Students must have begun or completed a session during the year that the 2483 is based upon.

(session attendance = ‘C’=Complete or ‘I’=Incomplete).
The training session must be chargeable.
Only training leave sessions are reported in this indicator.
Students that have an Apprentice contract type are not included.
Students enrolled multiple times are reported only once.
All session durations will be included for students enrolled multiple times.

When the attendance status is C, the session duration is obtained from the Session Setup page. If the attendance status is I, the duration is obtained from the Time Spent at Training field on the Course Session Enrollment page.
Only the competency check course type is included in this indicator.

To calculate indicator L14 - Total of Hours Paid by the Company: Training Leaves and Competency Checks:

Set up the employee status to Active, Leave of Absence, or Leave With Pay.
Ensure that employees are not on a training leave (TRAINING_LEAVE_FRA = N).
Ensure that the course is not a sandwich course (PART_TIME_CRSE_FRA = N).
Ensure that the trainees have the appropriate attendance status.

If attendance status is C, the system uses the total number of hours. If attendance status is I, the system extracts the total number of hours considered from the Time Spent at Training field on the Course Session Enrollment page.
Complete the training session.

PS_JOB A	PS_TRAINING B	PS_TRN_EEEXPN _COST C	PS_PERSONAL _ DATA D
A.EFFDT	B.ATTENDANCE	C.COURSE	D.EMPLID
A.EFFSEQ	B.COURSE	C.EMPLID	D.SEX
A.EMPL_RCD	B.COURSE_END_DT	C.SESSION_NBR
	B.COURSE_START_DT
A.EMPL_STATUS	B.EMPLID
A.EMPLID	B.SESSION_NBR
A. EMPL_CTG	B.TRAINING_LEAVE_ FRA
A. LABOR_AGREEMENT

PS_EMPL_CTG_L1 E	PS_TRN_EESAL _ COST G	PS_TRN_SSEXPN _COST J	PS_TRN_EEPROV _COST K	PS_CRSE_SESSN_TBL
E.CATEGORY_2483_ FRA	G.COURSE	J.COURSE	K.COURSE	L.COURSE
E.EMPL_CTG	G.EMPLID	J.EMPLID	K.EMPLID	L.DURATION_CONVERTED
E.LABOR_AGREEMENT	G.SESSION_NBR	J.SESSION_NBR	K.SESSION_NBR	L.SESSION_NBR
				L.SESSION_STATUS

Calculation of Indicator L15 - Number of Qualification or Orientation Contracts

The following criteria are necessary to calculate the number of students for this indicator:

Students must have begun or completed a session during the year that the 2483 is based upon.

(session attendance = ‘C’=Complete or ‘I’=Incomplete).
The training session must be chargeable.
Only part time sessions are reported in this indicator.
Students that have an Apprentice contract type are not included.
Students enrolled multiple times are reported only once.
The competency check course type is not included in this indicator.
Students must have been hired with the following contract types:
- FRA-QUA: Qualification Contract.
- FRA-ADA: Adaptation Contract.
- FRA-ORI: Orientation Contract.
- FRA-ADD: Fixed Term Adaptation Contract.
- Any customized contracts added to the system.

To calculate indicator L15 - Number of Qualification or Orientation Contracts:

Set up an employee contract on the Contract Data - Contract Status/Content page, and link the employee to a collective agreement on the Job Data - Job Labor page.
Set up the employee status to Active, Leave of Absence, or Leave With Pay.
Ensure that the course is a sandwich course (PART_TIME_CRSE_FRA = Y).
Set the contract type to Qualification, Adaptation, or Orientation (CONTRACT_TYPE = QUA, ADA or ORI).

PS_JOB A	PS_TRAINING B	PS_PERSONAL_DATA D	PS_EMPL_CTG_L1 E	PS_CONTRACT_DATA F
A.EFFDT	B.COURSE_END_DT	D.EMPLID	E.CATEGORY_2483_ FRA	F.CONTRACT_TYPE
A.EFFSEQ	B.COURSE_START_DT	D.SEX	E.EMPL_CTG	F.EMPL_NUM
A.EMPL_RCD	B.EMPLID		E.LABOR_ AGREEMENT	F.EMPLID
A.EMPL_STATUS	B.PART_TIME_CRSE_FRA
A.EMPLID
A. EMPL_CTG
A. LABOR_AGREEMENT

Calculation of Indicator L16 - Total of Hours for Qualification, Adaptation, and Orientation Contracts

The following criteria are necessary to compute session duration for this indicator:

Students must have begun or completed a session during the year that the 2483 is based upon.

(session attendance = ‘C’=Complete or ‘I’=Incomplete).
The training session must be chargeable.
Only part time sessions are reported in this indicator.
Students that have an Apprentice contract type are not included.
Students enrolled multiple times are reported only once.
All session durations will be included for students enrolled multiple times.

When the attendance status is C, the session duration is obtained from the Session Setup page. If the attendance status is I, the duration is obtained from the Time Spent at Training field on the Course Session Enrollment page.
The competency check course type is not included in this indicator.
Students must have been hired with the following contract types:
- FRA-QUA: Qualification Contract.
- FRA-ADA: Adaptation Contract.
- FRA-ORI: Orientation Contract.
- FRA-ADD: Fixed Term Adaptation Contract.
- Any customized contracts added to the system.

To calculate indicator L16 - Total of Hours for Qualification, Adaptation, and Orientation Contracts:

Set up an employee contract on the Contract Data - Contract Status/Content page, and link the employee to a collective agreement on the Job Data - Job Labor page.
Set up the employee status to Active, Leave of Absence, or Leave With Pay.
Ensure that the course is a sandwich course (PART_TIME_CRSE_FRA = Y).
Set the contract type to Qualification, Adaptation, or Orientation (CONTRACT_TYPE = QUA, ADA or ORI).
Ensure that the trainees have the appropriate attendance status.

If attendance status is C, the system uses the total number of hours. If attendance status is I, the system extracts the total number of hours considered from the Time Spent at Training field on the Course Session Enrollment page.
Complete the training session.

PS_JOB A	PS_TRAINING B	PS_PERSONAL_DATA D	PS_EMPL_CTG_L1 E
A.EFFDT	B.ATTENDANCE	D.EMPLID	E.CATEGORY_2483_ FRA
A.EFFSEQ	B.COURSE	D.SEX	E.EMPL_CTG
A.EMPL_RCD	B.COURSE_END_DT		E.LABOR_ AGREEMENT
A.EMPL_STATUS	B.COURSE_START_DT
A.EMPLID	B.DURATION_CONVERTED
A. EMPL_CTG	B.EMPLID
A. LABOR_AGREEMENT	B.PART_TIME_CRSE_FRA
	B.SESSION_NBR

PS_CONTRACT_DATA F	PS_CRSE_SESSN_TBL L
F.CONTRACT_TYPE IN	L.COURSE
F.EMPL_NUM	L.DURATION_CONVERTED
F.EMPLID	L.SESSION_NBR
	L.SESSION_STATUS

Calculation of Group M Indicators - Sharing of Trainees by Age and Gender

To calculate group M Indicators - Sharing of Trainees by Age and Gender:

Set up an employee contract on the Contract Data - Contract Status/Content page, and link the employee to a collective agreement on the Job Data - Job Labor page.
Set up the employee status to Active, Leave of Absence, or Leave With Pay.

PS_JOB A	PS_PERSONAL_DATA B	PS_EMPL_CTG_L1 C	PS_TRAINING D
A.EFFDT	B.BIRTHDATE	C.CATEGORY_2483_FRA	D.COURSE_END_ DT
A.EFFSEQ	B.EMPLID	C.EMPL_CTG	D.COURSE_START _DT
A.EMPL_RCD	B.SEX	C.LABOR_AGREEMENT	D.EMPLID
A.EMPL_STATUS
A.EMPLID
A. EMPL_CTG
A. LABOR_AGREEMENT

Group	Select the groups that are present from the list of prompt values. To enter more than one group, insert additional data rows.
Voters	Enter the number of employee voters registered for this group.
Incumbent and Substitute	Enter the number of incumbents and substitutes affected by the election. The incumbent number is copied into the Substitute field, but you can overwrite this value.

Group	For the election in question and for each group, displays a summary of Invalid, Blank, Altered, and Regular votes.
Turnout	Displays the turnout for the roll, which is a ratio calculated by adding the invalid, blank, and regular votes at the group level and dividing this number by the number of voters defined on the Group page.
Quorum	Selected by default if voter turnout for the group is greater than 50 percent. That is, the number of votes for a group (invalid, blank, and regular) is greater than the number of voters defined on the Group page divided by two.
Seat Value	Displays the seat value (electoral quotient), which is calculated at the group level by dividing the number of regular votes by the number of incumbents defined on the Group page. The seat value must be the same for all rolls in a group.
Election Validated	Select to validate the election.
Roll	Displays the number of incumbent votes and substitute votes entered on the Votes page at the roll level for a particular group.
Seats	Displays the number of seats to be allocated for the roll. This number is equal to the number of incumbent and substitute votes at the roll level divided by the seat value.
Indicator	Displays the number that is calculated by dividing the number of incumbent and substitute votes by the number in the Incumbent Results field and the Substitute Results field plus one.
Result	By default, displays the results from the calculation of the seats. You can change the results.

Group	Displays a summary from the Results page for each group, indicating the turnout and seat value and whether a quorum was reached.
Roll	Displays the number of incumbent and substitute seats obtained for each roll. This is the value entered in the Results field on the Results page.
10% Rule (10 percent rule)	For each roll, select to indicate whether the decision to declare the candidates elected is made by applying the 10 percent rule.
Candidate	Displays the candidate number. For each incumbent or substitute candidate, indicate the final order on the roll and whether the candidate was elected.

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 the Years 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.

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.