Labor Cost report is an overview of employee salary costs organized by packages with the detail of wage types per employee and day. With this report we are able to reproduce an employee payslip.
Data is available after each payroll run (day 8 of each month). Meaning, you need to select in the initial prompt the previous month corresponding to the payroll run.
Warning: If you are using the Labor Cost query on the first 5 business days of the current month and the time period you've selected is this same month, no data is available to display because this query only retrieves data of a given month 5 business days after the end of the payroll month.
Key user profiles:
HR - Payroll & Related Services Design
VERSION | DATE | MODIFIED BY | DESCRIPTION |
0.01 | 26.10.2023 | Emma Glasson | Initial draft |
| Data Product Type |
|
| Technologies |
|
Data Sources Note: list of all applications and various environment |
|
2.0 Business Process
3.0 Application Feature Overview
| Reports | Definition | Prompts | BW Workbook Query | Query Technical Name |
|---|---|---|---|---|
| Labor Costs | Labor Cost report is an overview of employee salary costs organized by packages with the detail of wage types per employee and day. With this report we are able to reproduce an employee payslip. Warning: only countries that are part of the corporate payroll are available in this report. | Functional Roles Calendar Year/Month
| n.a | BW_QRY_CPHRPY002_0002 |
4.0 Functional Specification
4.1.1 General Data/Calculations
Please find bellow general dimension, commun to all BW HR reports:
| Dimension | Definition |
Company Code | Company code to which an employee belongs on the time period selected in the report |
Country of the company | Country of company where the employee has his employment contract |
Calendar | Time dimensions available: Day, Month, Year, Year/Month |
Division (Entity) | Division (former entity) to which an employee belongs on the time period selected in the report |
Employee NR (NS) Employee PERN | Employee payroll number |
Employee status | Active, Active Leave, Inactive Leave Dormant, reported No Show Terminated, Inactive |
Employment status | Valid for historical data - the period before 1 November 2020. Equivalent to the current dimension Employee status |
Employee sub-group grouping (Gr) | Identification of employee by:
The employee sub-group grouping is a grouping definition of the employment type. |
Location Grp (Site) | Employee’s site |
Person ID | Unique identifier code for an employee. EC number. (person name available in the text option for this dimension) |
User Name | User account name (to access system/tool) |
4.1.2 Specific dimensions:
Please find bellow specifics dimensions, commun to all HR Payroll Labor costs report:
| Dimension | Definition |
Pay Grade | Pay grade structure points to the reference salary for a certain group of jobs |
Pay Scale Area (SAP) | The pay scale structure covers pay aspects which are dependent (industrial-specific, regional, collective agreements, etc) |
Wage Type | Wage types are used to assign payments and deductions in the payroll system. |
4.2 Process Detail
4.2.1. Report/Process Definition
| Domain | Human Resources (HR) |
|---|---|
| Application | BW Payroll |
| Provider | CPHRPY00 |
| Existing Documentation |
4.2.2. KPI's/Calculations/Indicators
Indicators available:
Indicatores/KPI's | Definition | Calculation/Extraction of data |
|---|---|---|
| Base Salary (local) | Monthly amount before benefits, bonuses, or compensation is added in local currency | |
| Base Salary (EUR) | Monthly amount before benefits, bonuses, or compensation is added in EUR | |
| Shifts & premiums (local) | All paid allowances linked to shifts such as night/weekend/shift supervising allowances or standby on duty; All paid amount linked to : call back shift changes & special premium linked to work conditions (as duty or heavy work) in local currency | |
| Shifts & premiums (EUR) | All paid allowances linked to shifts such as night/weekend/shift supervising allowances or standby on duty; All paid amount linked to : call back shift changes & special premium linked to work conditions (as duty or heavy work) in EUR. | |
| Overtime (local) | All amounts paid on generated overtime hours in local currency. | |
| Overtime (EUR) | All amounts paid on generated overtime hours in EUR. | |
| Bonus & Premium PSU (local) | Amounts paid for : Individual Bonus, R.O.E. Bonus, Merit Bonus, performance Bonus; no segregation cadre/non-cadre in local currency. | |
| Bonus & Premium PSU (EUR) | Amounts paid for : Individual Bonus, R.O.E. Bonus, Merit Bonus, performance Bonus; no segregation cadre/non-cadre in EUR. | |
| Other Benefits (local) | Others : meal vouchers, seniority premium, innovation premium, representative fees, car allowance, internet, electricity, créche, etc- Note: in some countries, seniority premium may be considered Base Salary: Portugal (legal) in local currency (Country currency). | |
| Other Benefits (EUR) | Others : meal vouchers, seniority premium, innovation premium, representative fees, car allowance, internet, electricity, créche, etc- Note: in some countries, seniority premium may be considered Base Salary: Portugal (legal) in EUR. | |
| Expatriation Costs (local) | All costs related to expatriated employee Eg: Mobility premium; expat allowance, moving-in-expenses | |
| Expatriation Costs (EUR) | All costs related to expatriated employee Eg: Mobility premium; expat allowance, moving-in-expenses | |
| Health & Life Insurance ( (local) | Health plans,Insurance programs : life, disability (Country currency). | |
| Health & Life Insurance (EUR) | Health plans,Insurance programs : life, disability (EUR) | |
| Social contributions (local) | Social security contribution (Country currency). | |
| Social contributions (EUR) | Social security contribution | |
| Pension (local) | Saving plans & pensions, Participation to Company results | |
| Pension (EUR) | Saving plans & pensions, Participation to Company results | |
| Termination Costs (local) | Costs of termination of work for internal employee (restructuring and other, excl. outplacement): ex: severance | |
| Termination Costs (EUR) | Costs of termination of work for internal employee (restructuring and other, excl. outplacement): ex: severance | |
| Holiday pay (local) | Vacation and Christmas allowance. Eg: "thirteenth salary" | |
| Holiday pay (EUR) | Vacation and Christmas allowance. Eg: "thirteenth salary" | |
| Headcount Payroll ( Cumulated Headcount ) | ||
| Total gross earnings | Monthly amount with extra hours included | |
| Total gross earnings (EUR) | Monthly amount with extra hours included | |
| Cost per HC | Total monthly cost to the company, without considering holidays costs. | |
| Cost per HC (EUR) | Total monthly cost to the company, without considering holidays costs. | |
| Amount (Local) | Measure that gives the amount for all wage types. Note: do not use this measure to make totals. | |
| Amount (EUR) | Measure that gives the amount for all wage types. Note: do not use this measure to make totals. | |
| Quantity | Dynamic value dependent on the wage type. Example: For extra hours wage types the quantity will display the number of hours; for ticket meals wage type the quantity will display the number of days considered to the ticket meals. |
5.0 Non-functional Descriptions
5.1 Usability
as per standards
5.2 Regulatory Compliance
GDPR compliant. Report that contain sensitive data.
5.3 Security
- Only authorised Users be able to access data.
- Data are not yet split between SCO or ECO. The report contains both companies data.
5.4 Performance
as per standards
5.5 Reliability
as per standards
5.6 Scalability
Historical report, no small enhancements will be performed and no new access except for new joiners in HR domain.
5.7 Compatibility
as per standards
5.8 Availability
as per standards
5.9 Refresh of the Data
Monthly refresh, at 03:00 CET, Following month 5th working day.