PMI Knowledge base

Generic filters
Exact matches only
Search in title
Search in content
Search in excerpt
Filter by Custom Post Type
PMI Knowledge Base
Article contents

Data elements required from TKS

Please Share Your Feedback
How Can We Improve This Article?

PMI is a Productivity Management Tool. The tool is looking at productivity per department in the hotel. PMI calculates productivity by looking at the Cost Driver for the department, normally revenue, room nights or covers. PMI is then taking the cost driver and dividing it with the amount of hours used for a specific day or planned for a specific day in the future.

Out of this PMI can suggest a planning for future days as well as analyse history days.

The hours used or planned for a specific department is the information PMI is looking for from a Time Keeping System.

Integration with an external TKS is all about importing used hours per department as well as planned hours per department for future days.

What data do we need from your Time Keeping System (TKS)?

The purpose of recording hours in PMI is to keep track of paid hours incurred and paid hours planned/scheduled to be incurred per department/operational unit (e.g. Housekeeping, Front Office, Breakfast etc.).

The data need to be extracted daily. Each extract need to encompass yesterday including 30 days back in time and schedule hours today including minimum 45 days ahead (preferably more if that exists).

Extra information for PMI Planning

If you also wish to integrate the salary from the TKS, or a salary system, into the Planning module in PMI we also need this additional data in a separate export on a monthly basis:

Key clarification on the use of TKS

The following questions will be addressed during the discussion on how the integration should be set up.

  1. If a staff belonging in one department and performing a task for another department, will the hours be recorded accordingly in TKS, i.e against two separate departments codes?
  2. What time categories will be extracted? Examples? (See point 6 above)
  3. What job categories will be extracted? Examples? (See point 8 above)
  4. In PMI we need all hours recorded imported everyday. Does your extract support this, or is it restricted to only “approved” hours?
  5. In PMI we need to also separate future/planned/schedule hours between productive and non productive (e.g vacation, training) “tasks”. Does your system support such separation?
  6. If the data cannot be provided trough Webservice or API, the extract should be divided into two files; one with Actual (yesterday minus 30 days) and the other with Scheduled/Planned (today plus 45 days).

For more details on data transfer methods, please see the article How to transfer data to PMI