6 Pillars of Leave Management: Extracting Data

DMEC Staff@Work

Extracting Data to Support Your Leave Management Efforts

By Geoffrey Simpson

Director of Sales & Marketing

Are you thinking about switching from managing leave manually to using a software system or outsourcing to a vendor? A common concern in this situation is how you can pull the data you need from your various human resource (HR) systems.

Getting this integration right will reduce duplicate data entry and provide you with a more holistic picture of your employees so that you can manage leaves with improved efficiency and compliance.

To get started, there are three types of data that you will want from other systems: basic demographic data, eligibility information, and entitlement information. These data will often need to come from multiple systems, which may include your human resources information system (HRIS), payroll, and time/attendance. Let’s break down the process of finding each type.


Typically, your HRIS system should provide a demographic file, also known as the eligibility, census, or roster file. This file includes basic demographic and eligibility information such as name, ID, work location, hours worked, date of hire, and other pieces of employee and employment service information.

Full content is available to DMEC members only. Please log in to view the complete resource.

If you are not a DMEC member, we encourage you to join. DMEC members have access to white papers, case studies, @Work magazine articles, free webinars, legislative updates, and much more. These resources will assist you in building an effective and compliant integrated absence management program, saving you time, resources, and money. Learn more.

If you are being asked to log in more than once, please refresh your browser.