1/15
Oracle HRMS for Netherlands Supplement
Contents
Title and Copyright Information
Send Us Your Comments
Preface
Organization Structures
- Organization Structures Overview
- Organization Structures
- Key Concepts for Representing Enterprises
- Representing Organizations
- Organization Classifications
- Dutch Organizations and Additional Information
- Examples of Assigning Social Insurance Types and Providers to Employees
- Methods for Deriving Social Insurance Days
- Creating an Organization
- Entering Organization Classifications
- Entering Additional Information
- Finding an Organization
- Removing and Deleting Organizations
- Entering Business Group Information
- Entering Dutch Business Group Information
- Business Groups: Entering Budget Value Defaults
- Business Groups: Selecting a PTO Balance Type
- Business Groups and HR Organizations: Entering Work Day Defaults
- Defining Benefits Defaults for a Business Group
- Business Group: Setting Up Public Sector-type Functionality
- Business Groups: Entering Recruitment Information
- Assigning ABP Pension Types to an Organization
- Assigning PGGM Pension Types to an Organization
- Entering Payslip Information
- Entering Self-Service Preference Information
- Identifying Balances for the Payslip
- Identifying Elements for the Payslip
- HR Organizations: Entering Costing Information
- Entering Reporting Information for an HR Organization or a Company Cost Center
- HR Organizations: Entering Parent Organizations
- HR Organization: Entering Social Insurance Provider Information
- HR Organization: Entering Dutch ABP Provider Information
- HR Organization: Entering ABP Pensions General Information
- HR Organizations: Entering ABP Sender Details
- HR Organization: Entering Dutch Organization Information
- HR Organization: Entering General PGGM Information
- HR Organization: Entering Wage Report Information
- HR Organization: Entering Flat Rate Taxation Information
- Adding Sickness Information
- Adding Labor Cost Arrangement Information
- Entering GL Company Cost Center Information for a Company Cost Center
- Entering Representative Body Information
- Entering Constituency Information for a Representative Body
- Entering Location Information for Constituencies
- Entering Organization Hierarchy Information for Constituencies
- Entering Organization Information for Constituencies
- Entering Grade Information for Constituencies
- Entering Bargaining Unit Information for Constituencies
- Entering Job Information for Constituencies
- Entering Collective Agreement Grade Information for Constituencies
- Entering Trade Union Information for a Bargaining Association
- Entering Additional Information for a Professional Body
- Setting up Tax, Social Insurance, and Private Health Insurance Organizations
- Dutch Private Health Insurance Organization: Entering IZA Provider Information
- Setting up Social Insurance Days
- Dutch UWV Organization: Entering Dutch SI Provider Information
- Dutch UWV Organization: Entering Social Insurance Type Information
- Entering Statement of Earnings Information
- Entering Statement of Earnings Detail Information
- Entering Related Organizations Information for an HR Organization
- Locations
- Location Extra Information Types
- Setting Up Locations
Occupational Health
- Occupational Health: Medical Assessments, Disabilities and Work Incidents
- Entering Disability Information
People Management
- People Management Overview
- People Management
- Person Extra Information Types
- Finding a Person Using the Find Person Window
- Entering a New Person (People Window)
- Entering Additional Personal Information (People Window)
- Entering Additional Sickness Details Information
- Entering Additional Absence Detail Information
- Entering Pictures
- Running the Person Synchronization Report
- Disabling Full Name Formats
- Entering a New Employee
- The Employee Assignment
- Employment Information
- Assigning Working Shift Patterns to an Employee
- Adding Further Collective Agreement Information
- Previous Year's Taxable Income
- Assignment Extra Information Types
- Entering Additional Assignment Details (Assignment window)
- Running the Dutch Reset Last Year Salary Override Process
- Contact Information Overview
- Entering Addresses (Address Window)
- Adding Telephone Information (Phone Numbers Window)
- Entering Communication Delivery Methods
- Entering Next of Kin and Other Contacts
- The Workforce Headcount Report Set
- Running the Full Personal Details Report Set
- Running the Employee Summary Report
- Running the Employee Payroll Movements Report
- Running the Worker Organization Movements Report
- Running the Assignment Status Report
- Running the Terminations Report
- Running the Conclude Placement Report
- Running the Head Count Detail Report
- Running the Workforce Count Reports
- Running the Duplicate Person Report
- Running the Full Person Details Report
- Running the Person Full History Report
- Using the People Folders
- Listing Assignments Using the Assignments Folder
- Listing Assignments Using the List Assignments Window
- Using the List People by Assignment Window
- Listing Workforce by Position
- Listing Workforce by Organization
- Listing People by Special Information
- Viewing a Worker's Assignment History
- Running the Dutch Assignment SCL Flexfield Upgrade Report
Payrolls
- Payrolls Overview
- Payrolls
- Cash Management and Oracle Payroll
- Configuring the Statement of Earnings for the Netherlands
- Setting Up Integration of Cash Management with Oracle Payroll for EFT Reconciliation
Payroll Processing and Analysis
- Post-Processing for a Payroll
- Overview of RetroPay Processing
- RetroPay Standard and Replacement Methods
- Setting Up Enhanced RetroPay with Component Usages and Element Time Spans
- Setting Up the Adjustment Component of RetroPay
- Enabling the Method of RetroPay
Payroll Statutory Deductions and Reporting
- Payroll Statutory Deductions and Reporting Overview
- Payroll Statutory Deductions and Reporting
- Dutch Tax and Social Insurance
- Multiple Assignment Processing for Social Insurance and Taxation
- IZA Upload and Reporting Overview
- Dutch Wage Reporting
- Setting up Tax and Social Insurance Deductions
- Setting Up ZW, WW, WAO/IVA/WGA, ZVW (standard en low) and UFO Contributions
- Setting Up Flat Rate Taxation
- Running the Payment Output File (Dutch)
- Running the Dutch Annual Tax Statement Archive
- Running the Dutch Annual Tax Statement for the Employee
- Setting up the Dutch Remuneration State Report
- Running the Dutch Remuneration State Report
- Setting Up the Dutch Wage Report
- Running the Dutch Wage Report Generator
- Running the Dutch Wage Report
- Running the Dutch Wage Report Data Lock Process
- Setting up the Labor Cost Arrangement Report
- Running the Dutch Labour Cost Agreement Audit Report
- Setting Up the First Day Report
- Generating the First Day Report
- Running the Dutch Element RetroPay Setup Report
- Running the Dutch ABP Report Archiver
- Running the Dutch ABP Report
- Running the Dutch ABP Retro Pension Salary Calculation
- Running the Dutch Remuneration Statement
- Setting Up Wage Tax Subsidies
- Generating the Dutch Wage Tax Subsidy Report
- Running the Dutch IZA Upload Process
- Running the Dutch IZA Upload Process Status Report
- Running the IZA Upload Process Status Purge Process
- Re-generating the IZA Upload Process Report
- Running the Dutch AOW HR Report
General Compensation Structures
- Survey of the Classifications
- Absence Tracking Reporting
- Tracking Absences
- Running the Daily Sick and Recovery Report
- Running the Absence Action List Report
- Running the Re-integration Actions Report
- Sickness Reporting
- Setting up the Dutch Digital Sickness Reports
- Running the Sickness Report
- Running the Sickness Recovery Report
- Running the WAZO Report
- Running the Long Term Sickness Report
- Running the Long Term Sickness Recovery Report
Savings and Retirements
- Savings and Retirement Overview
- Savings and Retirement
- Calculation of Pension and Savings Contributions
- Elements, Formulas, and Balances for Pensions and Savings Schemes
- Arrears Management
- Setting Up Pension and Savings Schemes
- Setting Up a Pension or Savings Plan in Standard or Advanced Benefits
- Entering ABP Salary Thresholds and Premiums That Vary By Age
- Managing Pensions and Savings Contributions
- Enrolling Employees in Pension Schemes
- Enrolling Employees in Savings Schemes
- Adjusting Pension or Savings Deductions
- Withdrawing Savings to Compensate for Unpaid Leave or for Retirement
- Notification of ABP Pensions Data
- Setting Up the ABP Notification Extract
- Running the ABP Notification Extract
- Setting Up the PGGM Notification Extract
- Running the PGGM Notification Extract
Other Payroll Earnings and Deductions
- Payroll Earnings and Deductions Overview
- Payroll Earnings and Deductions
- Formulas and Payroll Run Results
- Pay Values
- Predefined Elements
- Predefined RetroPay Elements
- Retropay Component Usages
- Element Span Usages
- Setting Up Total Compensation Elements for Payroll
- Defining Frequency Rules
- Defining Formula Processing and Result Rules
- Payroll Balances
- Netherlands Balance Dimensions
- Balance Initialization
- Netherlands Balances
- Defining Secondary Element Classifications
- Creating Balance Feeds for Individual Elements
- Creating Classes of Balance Feeds
- Defining User Balances
Using Oracle FastFormula
- Netherlands Payee Name Formulas
- Netherlands EFT Payment Override Formula
- Formulas for Netherlands Wage Tax Subsidies
- Netherlands Working Hours Formula
- Netherlands Reporting ABP Part Time Percentage
- Formulas to Enable Additional Part-Time Percentages for the Netherlands
Implementation
Additional Implementation Steps for the Netherlands
If you are implementing Oracle HR for the Netherlands, you may also need to complete the following additional implementation steps.
Additional Implementation Steps
Step 1: Configure the Title Field
If the Title field does not meet the requirements of your enterprise, you can add new values to the existing set of predefined lookup values.
See: Adding Lookup Types and Values, Oracle HRMS Configuring, Reporting, and System Administration Guide
Step 2: Configure User Tables for Default Absence Actions
To use absence tracking, you must first set up a user table to store default re-integration actions for each absence category you want to use. As a minimum you must set up one user table for the absence category of Sickness.
The re-integration actions you set up here are displayed in the Absence Tracking pages for absence records with the relevant absence category. Using the Absence Tracking pages you can use these actions and update them, add more actions to the absence record or delete the actions from the record.
Note: Only the default re-integration actions you set up for an absence category using the user tables appear for the absence records. Any actions you add, update or delete to an absence record using the Absence Tracking pages appear only for that record.
Set up the default re-integration actions user tables as follows:
-
Name each user table: NL_ABS_ACTION_(category code). The absence category code relates to the relevant lookup code in the Absence Category Lookup Type. For example, the category code for Sickness is 'S'.
-
Set the match type as Match and the key units of measure as Text.
-
Set up the following four columns and values:
ROW_NUMBER |
NA |
This column uniquely identifies the ACTION. You can enter alpha and numercial values, for example 1, 1A, 1B etc. |
ACTION |
NA |
This column describes the re-integration action, for example Progression Plan. |
TIME_PERIOD |
NA |
This column describes the number of time units. For example, for the action Progression Plan, you set up a time period of 1 and a time unit of 'M' for months, this means you have one month to perform the action for the employee from the start of the absence record. |
TIME_UNITS |
'D' for Days, 'W' for Weeks, 'M' for Months |
NA |
-
Set up row labels for each row in the Exact field, and set up the order you want the rows to appear in the table using the Sequence field. The number of rows you set up determines the number of values you can enter.
-
For every date effective row you set up in the user table, you must also set up a date effective value for each column. This is to ensure that when you use the Absence Tracking pages on a date that is on or later than the effective dates set up, then the user table displays the default actions and their values.
Note: If you use the Absence Tracking pages on a date that is earlier than the effective dates set up in the user table, an error message displays to indicate that the user table is incorrectly set up.
See: User and Extensible Lookups, Oracle HRMS Configuring, Reporting, and System Administration Guide
See: Setting Up User Tables, Columns and Rows, Oracle HRMS Configuring, Reporting, and System Administration Guide
See: Tracking Absences
Step 3: Set Up Dutch Organizations for Social Insurance and Tax
You must set up your organizations correctly to enable you to:
See: Setting up Tax, Social Insurance, and Private Health Insurance Organizations
See: Setting Up Social Insurance Days
Step 4: Set up Statutory Deductions
If you are using Oracle Payroll, you must set up your statutory tax and social insurance deductions.
See: Setting up Tax and Social Insurance Deductions
To enable flat rate taxation in Oracle Payroll, you must set up elements and balances related to flat rate tax.
See: Setting Up Flat Rate Taxation
Step 5: Set Up Pension Schemes
You can set up the pension schemes available to your employees. This enables you to process pension contributions in the payroll run. To review the functionality available, see: Savings and Retirement Overview. For the setup steps, see: Setting Up Pension and Savings Schemes
Step 6: Disable Full Name Formats Optional Step
You can disable full name formats that you do not wish to use in the User Types and Statuses window. The full name formats that you disable, do not appear in the Full Name Format field in the People window.
See: Disabling Full Name Formats
See: Entering Additional Personal Information (People Window)
Step 7: Set Up Information for the Wage Report Required Step
Some setup tasks are necessary before you can run the Dutch Wage Report.
See: Setting Up the Dutch Wage Report
Step 8: Link Predefined Elements Required Step
You must link the following predefined elements:
-
Labour Handicap Discount, which holds the calculated discount value for labor handicapped employees
-
Retro Labour Handicap Discount, which holds changes made retrospectively to the Labour Handicap Discount element
Note: You do not need to attach these elements to assignments eligible for labor handicap discount. The application checks for eligibility during SI processing and generates results for eligible elements. Ensure you link the elements for costing purposes.
You need to attach the predefined element, SI Override Days to assignments to enter override days manually. The application uses this information in case of the following:
-
For long-term unpaid leave
-
If an employee has more than three active assignments and a time gap exists between assignments, for example, the employee has one or more days between the payroll start date (or employee period of service start date if earlier than period start date) and payroll end date (or employee period of service end date if later than period start date) where no active assignment exists.
Note: You do not need to use this element if the assignments remain active throughout the payroll period and period of service.
Step 9: Set Up Information for Health and Disability Insurance Contributions Required Step
Some setup tasks are necessary before the payroll process can calculate health and disability insurance contributions.
See: Setting Up ZVW, WGA, IVA, and UFO Contributions
Step 10: Set Up First Day Report Required Step
You need to set up the first day report for enabling you to electronically send the employee information to tax authorities.
See: Setting Up the First Day Report
Step 11: Create a User Table for Each Dutch Business Group for Deriving Maximum SI Wage. Required Step
As the maximum SI wage is retrieved from a user defined table instead of deriving it from a global value, you must create a user table for each Dutch business group in the format given below and keep it updated:
-
Table : PAY_NL_MAXIMUM_SI_WAGE
-
Key Units of Measure : Text
-
Column Name : FREQUENCY
-
Exact : Day, Week, FourWeek, Month, Quarter, Year
You must ensure that a row is defined for each payroll frequency used in the business group and mandatorily specify day.
Step 12: Set up the Special and Non-tax Elements Required Step
For Savings Schemes, currently elements such as '% Standard Tax Adjustment' only feeds balance 'Standard Taxable Income'. You must ensure that the balance feed 'SI Income Standard Tax Adjustment' is also added. You must set up the Special and Non-tax elements similarly as shown below:
%Standard Tax Adjustment |
SI Income Standard Tax Adjustment |
Subtract |
%Special Tax Adjustment |
SI Income Special Tax Adjustment |
Subtract |
%Non Tax Adjustment |
SI Income Non Tax Adjustment |
Subtract |
Step 13: Set up Value for Action Parameter - Maximum Errors Allowed Required Step
Ensure that you specify the number of assignment action failures that can happen during the Magtape process. The Magtape processes, Payment Output File (Dutch) and Dutch SEPA XML File and Report, consider the Action Parameter 'Maximum Errors Allowed' for assignment level errors. The payroll process completes successfully if the number of assignment action failures do not exceed the value mentioned in the Action Parameter 'Maximum Errors Allowed'. This enables you to correct the individual assignment failures. If you do not specify any value for this action parameter, then the complete payroll process fails in case the Magtape Process encounters any single assignment action failure.
Index