Data elements required from TMS2018-09-10T11:33:00+00:00

Data Elements required from TKS

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

# PMI data element (target) Description Mandatory / Optional Comment
1 Property Name Name of the property (hotel, restaurant) M The name of the hotel/property.
2 Property ID ID of the property (hotel, restaurant) O This is an ID that uniquely identify your property within a chain or group.
3 Department Name Name of the department within the property M Functional area with the operations where staff is assigned, i.e. where hours can incur. It is also commonly called cost center or profit center.
4 Department ID ID of the department within the property O This is an ID that uniquely identify your department within the hotel/property.
5 Date Working date (timesheet) M On which the hours incur or scheduled to incur.
6 TimeCategory Name Name of the time category (e.g. Fixed Salary, Absence) M

In PMI, we are only concerned with hours that are paid for.

These hours will be categorised as productive or non-productive hours. Productive time is hours spent as part of normal operations, while non-productive time is hours spent on other things. e.g., sick leave, training, etc.

7 TimeCategory ID ID of the time category M This could be a system generated unique ID for the different Categories Names above.
8 JobCategory Name Name of the job category (e.g. Servers, Managers) O In a department there is often different roles. e.g in Housekeeping you typically have Housekeeping Manager, Assistant Manager, Cleaner etc, whereas in Front Office you typically have Front Office Manager, Service Manager, Supervisors, Receptionists etc.
9 JobCategory ID
ID of the job category
O This could be a system generated unique ID for the different Job Categories/roles above.
10 Staff FirstName First name of the staff (employee) O Not required (hours are imported at aggregated level, not individual staff level).
11 Staff LastName Last name of the staff (employee) O Not required (hours are imported at aggregated level, not individual staff level).
12 Staff ID ID of the staff (employee) O Not required (hours are imported at aggregated level, not individual staff level).
13 Hours Number of worked hours (on the timesheet) M Number of incurred or scheduled hours, considering all the descriptions above. E.g. if a normal working day consists of 8,5 hours with 30 minutes lunch break we are only interested in 8 hours.
14 Approved If the hours are approved or not O All paid hours need to be include with “Approved” and “Not Approved” flag included.
15 Employment Type Distinguishing hours between fixed and non-fixed employment M

Fixed hours = permanent full time + permanent part time* + temporary

Non-fixed = casual + permanent part time *Fixed hours represent monthly fixed salary cost, while non-fixed hours represent variable cost (varies from month to month).

There are basically three options in the following preferred order:

  1. Webservices/API. If your system offers such service, please provide access information/credentials.
  2. SFTP client. You upload the daily extract to d2o server. Credentials will be provided by d2o.
  3. FTP/SFTP server. If your systems offer such service, please provide access information/credentials.

If the options above cannot be accommodated, we could discuss other methods.

How Can We Help?

Hands-on exploration!

Hands-on exploration!

Explore first-hand what PMI can do for your business. Contact us now to book a webcast demo of the PMI suite or get your own login so you can play around and familiarize yourself with PMI.

Contact

Talk to our Experts!

Talk to our Experts!

Our Benefits Realization Enablement (BRE) team is there to answer your questions and make sure you get the most out of the powerful solutions PMI has to offer. Reach out today and we’ll set a date to create a custom approach with you.

Contact

Face to face!

Face to face!

Ready to embark on a journey to soaring productivity and profitability levels with PMI? A d2o representative will meet with you in person to help set you up, train you and your team and make sure you’re off on the right track.

Contact

Need more proof?

Need more proof?

Does that all sound way too good to be true? We don’t expect you to take our word for it. That’s why we’ve put together a case study about our client Pandox Hotels and the amazing results they’ve gotten from PMI.

View Case Study

 

Infographics

PMI - The technology that enables you to tune for better business performance

 

PMI Cruise and Resorts Infographic

 

PMI Hotels and Restaurants Infographic

 

PMI Plus Infographic