Human Resource Software And Payroll Interfaces Defined
- Date: 2008-08-24 - Word Count: 922
Share This!
During your search and evaluations of HRIS systems or HRMS software applications, you will hear a great deal about interfaces. The purpose of this article is to explain in detail how they are typically used. If you are looking at purchasing an HRIS system, HRMS system or HR software application and plan to tie it to an existing payroll application, this article will prove very helpful. The vast majority of HRIS systems and Payroll applications will offer some type of capability for transferring data from one system to another.
First, it's important to point out the difference between integration and an interface. With an integrated system, you have two products sharing the same data or you have an automatic real time transfer and update of data from one system to another. With HR and Payroll software applications, this is rare unless you are working with the same company for both systems. If that's not the case, then you are going to be dealing with interfaces.
With an interface you will have to either manually, or via an automated process, transfer data from either payroll to hr or vice versa. In many cases, this is a fairly manual process to setup but easy to maintain. If you want to transfer data from Payroll to HR, you will create a file from the payroll system and import this into the HR product using some type of software. The problems with this type of process are that if it's not automated, you will have to frequently perform the transfer of data because, in this example, your data in HR is only as up to date as the last transfer of information from your payroll application. There is no reason to not accept using interfaces since it's still the standard for getting two unique products to share data.
How a Payroll HRIS Interface works
If you are using a well known payroll product, such as ADP, almost all, if not all, HRIS systems will provide some type of interfacing capability between your HRIS system and your payroll product. If not, your HRIS system and payroll system will offer some type of import and export program.
System interfaces are also defined as data mapping. Once you determine which system will push the data, a report will be run from that system containing the data needed to import into your import application. Once the report is run, it is typically converted to either Excel or a text file for importing. Now you need to make sure both systems are speaking the same language. This is called data mapping. If in one system the field name for first name is "fnam", and in the system you are mapping to the field name is "first name," you simply direct the "fnam" data in product to populate the "first name" field. .
The same process is repeated for each and every field contained in both systems. The good news is that after you set up the data mapping, you won't have to repeat this process. The next time you need to transfer data, you will spend only a few minutes to do so.
The challenge with the setup occurs when the fields are in different formats or lengths. In these cases, the data can be brought into Excel and any needed modifications can be made there before importing the data. In some cases, the actual interface software will provide the ability to alter the information.
Populating your HRIS system database
Let's say you have just purchased a new HRIS system. By some means or another you are going to want to easily pull as much information from other sources as possible into your new system. If you have another HR product, you may create a file from that system and transfer this data over to your new HRIS system. If you don't, then most likely you will be pulling data from your payroll system to HR. It's important to note that your payroll system will not contain all the information of your HRIS system. So there are only so many fields you will be able to update. Typically, this information is going to include demographic data and data related to pay that will be tracked in your HRIS system. I have seen what rarely transfers from one system to another are benefits data and history. Make sure to ask about the transfer of this data while you are reviewing systems.
Payroll to HRIS or HRIS to Payroll
Going forward, you will have to determine which direction you want to push data and in what system your core input for new hires, terminations, and employee changes will happen. Whichever direction you decide to go, payroll to HR or HR to payroll, it's important to realize that whichever system is accepting the data will have the interface for that import of data. This is not always the case but in most circumstances it will be.
Remember the data in the system being updated is only as up to date as when the last interface data transfer was performed. This can create problems. Let's say, for example, that you are pushing data from your payroll system to your HRIS product and the last time you performed an update was two weeks ago. If you run a termination or new hire log from your HRIS system, the data you are relying on is two weeks old. You may have to go through the process of updating your data before running the report. As you have seen, interfaces are not a perfect world but they are a necessity.
First, it's important to point out the difference between integration and an interface. With an integrated system, you have two products sharing the same data or you have an automatic real time transfer and update of data from one system to another. With HR and Payroll software applications, this is rare unless you are working with the same company for both systems. If that's not the case, then you are going to be dealing with interfaces.
With an interface you will have to either manually, or via an automated process, transfer data from either payroll to hr or vice versa. In many cases, this is a fairly manual process to setup but easy to maintain. If you want to transfer data from Payroll to HR, you will create a file from the payroll system and import this into the HR product using some type of software. The problems with this type of process are that if it's not automated, you will have to frequently perform the transfer of data because, in this example, your data in HR is only as up to date as the last transfer of information from your payroll application. There is no reason to not accept using interfaces since it's still the standard for getting two unique products to share data.
How a Payroll HRIS Interface works
If you are using a well known payroll product, such as ADP, almost all, if not all, HRIS systems will provide some type of interfacing capability between your HRIS system and your payroll product. If not, your HRIS system and payroll system will offer some type of import and export program.
System interfaces are also defined as data mapping. Once you determine which system will push the data, a report will be run from that system containing the data needed to import into your import application. Once the report is run, it is typically converted to either Excel or a text file for importing. Now you need to make sure both systems are speaking the same language. This is called data mapping. If in one system the field name for first name is "fnam", and in the system you are mapping to the field name is "first name," you simply direct the "fnam" data in product to populate the "first name" field. .
The same process is repeated for each and every field contained in both systems. The good news is that after you set up the data mapping, you won't have to repeat this process. The next time you need to transfer data, you will spend only a few minutes to do so.
The challenge with the setup occurs when the fields are in different formats or lengths. In these cases, the data can be brought into Excel and any needed modifications can be made there before importing the data. In some cases, the actual interface software will provide the ability to alter the information.
Populating your HRIS system database
Let's say you have just purchased a new HRIS system. By some means or another you are going to want to easily pull as much information from other sources as possible into your new system. If you have another HR product, you may create a file from that system and transfer this data over to your new HRIS system. If you don't, then most likely you will be pulling data from your payroll system to HR. It's important to note that your payroll system will not contain all the information of your HRIS system. So there are only so many fields you will be able to update. Typically, this information is going to include demographic data and data related to pay that will be tracked in your HRIS system. I have seen what rarely transfers from one system to another are benefits data and history. Make sure to ask about the transfer of this data while you are reviewing systems.
Payroll to HRIS or HRIS to Payroll
Going forward, you will have to determine which direction you want to push data and in what system your core input for new hires, terminations, and employee changes will happen. Whichever direction you decide to go, payroll to HR or HR to payroll, it's important to realize that whichever system is accepting the data will have the interface for that import of data. This is not always the case but in most circumstances it will be.
Remember the data in the system being updated is only as up to date as when the last interface data transfer was performed. This can create problems. Let's say, for example, that you are pushing data from your payroll system to your HRIS product and the last time you performed an update was two weeks ago. If you run a termination or new hire log from your HRIS system, the data you are relying on is two weeks old. You may have to go through the process of updating your data before running the report. As you have seen, interfaces are not a perfect world but they are a necessity.
Related Tags: hr software, hris, hrms, human resource software, personnel software, employee software
Clay Scorggin has worked in the human resource software industry for 15 years. The newest venture is CompareHRIS.com. We offer a great tool to assist you with your HR software search and selection process, our HR Software Selector Tool is easy to use and free. Your Article Search Directory : Find in Articles
Recent articles in this category:
- Improper Way Of Marketing Reflects Poorly On A Company.
New business, product or service everything requires visibility, awareness in order to come into the - Replacing Paper Prints With Online Versions
Nowadays saving out on resources and being additionally informative are both aspects that are in. In - Stop Smoking Effectively
If I told you of a way that you could stop smoking harmful tobacco would you believe it? Most people - What Is Runtime Error 182? And How To Fix It
Are you finding an effective way to fix runtime error 182? Do you think fixing runtime error 182 is - Do You Know How To Fix Runtime Error 87 In Minutes?
Are you finding an effective way to fix runtime error 87? Do you think fixing runtime error 87 is to - Knowledge About Avi, Avi Player, Avi Converter On Mac
Knowledge about AVI, AVI player, AVI Converter on MacWhat is an AVI?AVI, an acronym for Audio Video - Buy Your Highly Successful Email Survey Software Today
Email Survey Software- Boost Your Business and Increase ProfitsAn email survey software could be one - Xrm - The Anything Relationship Management Solution
I recently attended the Microsoft Dynamics West Region FY11 Sales Planning Retreat. This year's meet - What Are The Benefits Of Working With Electronic Medical Records
Recording medical information is a vital part of health care services. These records are necessary f - Basic Factor To Make Website Business Oriented
Internet is home for millions of websites. The online business is becoming more and more competitive
Most viewed articles in this category:
- Parental Control Software
Parental control software is software that can help parents protect their children when they are onl - Digital Asset Management Software
Managing and organizing your organization's documents is a critical component to your business's suc - AdobeRGB vs. sRGB
Understanding color spaces I'll try to explain it very simplified, but understandable for everyone - Confessions of a Prankster
I wanted to get a jump on April Fool's Day, partially because of the long, cold winter blues, and pa - Malicious Thoughts About The Spyware Ills Of My PC
Who would think I was capable of such revengeful thoughts about the parties responsible for inflicti - Recover File and Recover Deleted File Tools
Data recovery software is a very effective way of retrieving data from a worn or damaged hard disk d - Life without Windows
Ubuntu, a user-friendly version of Linux, has been running so nicely on my home PC that I decided to - What Benefit Does an Online Software Download Site Offer You?
Are you having a problem that where you find a good softeware when you consider to have a try or wan - Maintaining A Website
There was an era when people were talking about how to create a website using html coding or some ea - Benefits Of Proper Time Tracking
Have you ever written down time when you have started and finished your work? Maybe you have had mul