Click here for an overview of Terminology


Foreword

It happens from time to time that a Customer terminates contract with HRMTS, and wants to export their data from the databases. For this purpose, HRMTS offers a Standard Export.


Background

Although all HR systems share some common traits, they differ a lot, especially under the hood. This difference are most obvious in the way these systems organize and store their data in the databases. Therefore, it is always a challenge to migrate all data from one system to another. For one system to read data from another system, it must establish mappings (so called connections) between data fields. E.g. for system A to read first name of a user from system B, it needs to know where and how the first name is stored in system B. The system B might be storing this information in a way that makes sense to system B, but not to system A.


Except for some basic data, it is rarely possible to map all data fields from one system to another. To make the matters worse, even though the functionality of a system may be well documented for its end-users, the databases are almost never documented on a detailed level - at least not in way that can be shared with other systems. Without such information, it is extremely difficult to create the required mappings to migrate data from one system to another.


Facts


Solution

There exist many opinions on how data can and should be migrated from one system to another. And nevertheless, there are strong advocates for these opinions. Needless to say, they all present valid arguments too. Over the years, HRMTS has collaborated closely with Customers, both joining and leaving HRMTS, and concluded that an export based on HR-XML has worked best for the most.


Standard Export

The standard end-of-contract export includes following:

  1. Each candidate’s data in HR-XML format (version 2.5), along with attachments. (See hropenstandards.org for more information.)
  2. Excel file showing the mappings between departments, users, projects, candidates and applications.


Variations of Standard Export

Each candidate in the System has a global profile. This is where the candidate maintains her latest information. Whenever the candidate starts applying for a new position, a copy of the global profile is used to create an application. From this point, the candidate can change the information in the application according to the position's requirement without modifying the global profile. Based on this, each candidate has exactly one global profile in the System, but may have more than one applications. Hence, the standard export is offered in two variations:

  1. Export global profile of each candidate.
    1. Exports only global profiles of the candidates.
    2. Does not export applications.
  2. Export applications of each candidate.
    1. Exports applications submitted by the candidates.
    2. Does not export global profile.
    3. For each application, an additional PDF is created with project specific information.


Procedure

The standard export is a quite heavy job, and can take quite some time to complete. It is normally executed in the weekends. Once the job is complete, both random and systematic checks are performed to ensure that the data is exported properly. The results are then packed into a ZIP file, and uploaded to the SFTP provided by the Customer.


Cost

The standard export has a fixed cost. (Please consult your regional office for the price.) The Customer is free to choose one of the variations above (1 or 2). If they want both, then they must pay double.


Exporting Additional Information

If the Customer wants any additional information than what the scope of standard export includes, then it must be considered as a custom order. This job will be estimated separately based on the criteria specified by the Customer.


Attention!


Sample Exports