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 (TOC)
Print

TMS – PPE

Please Share Your Feedback
How Can We Improve This Article?
The table below shows the data relationship between PMI data elements/fields (target) and corresponding source data elements/fields (source).

You will find the transformation/load rules meant to explain any programmatic manipulation and calculation applied in the adapter to get the desired data format and/or result in the PMI staging table where such have been applicable.

An example of the source file data, format and structure is also attached below the table.

This table will be updated whenever the source file or the adapter in question are changed throughout the interface life-cycle.

1
2
3
4
5
6
7
8
9
10
11
12
PMI data element (target)
Property ID
Property Name
Department ID
Department Name
Date
TimeCategory ID
TimeCategory Name
JobCategory ID
JobCategory Name
Staff ID
Hours
Approved
Description
ID of the property (hotel, restaurant)
Name of the property (hotel, restaurant)
ID of the department within the property
Name of the department within the property
Working date (timesheet)
ID of the time category
Name of the time category (e.g. Fixed Salary, Absence)
ID of the job category
Name of the job category (e.g. Servers, Managers)
ID of the staff (employee)
Number of hours (on the timesheet)
If the hours are approved or not
Mandatory / Optional
Mandatory
Mandatory
Mandatory
Mandatory
Mandatory
Mandatory
Mandatory
Optional
Optional
Mandatory
Mandatory
Mandatory
Data transformation/load rules
Directly mapped to source equivalent
Directly mapped to source equivalent
Directly mapped to source equivalent
Directly mapped to source equivalent
Directly mapped to source equivalent
Directly mapped to source equivalent
Directly mapped to source equivalent
Directly mapped to source equivalent
Directly mapped to source equivalent
Directly mapped to source equivalent
Exists in minutes. Transformation rule: minutes divided by 60 to get number of hours in PMI
Approved and to-be-approved hours exist. Loading rule: only import approved hours
PPE data element (source)
Not in use
Property Name
Not in use
Department Name
Date
Not in use
Type
Not in use
Cost Center Name
Staff ID
Hours
Approved
Comment
/ AZ, eventuelle über Weekly
Type This is needed to separate productive and non-productive hours
Not presented at staff level, but at job category and date level
All hours included in the file are approved in PPE
Tags: