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 – Protime

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.

NB. This export lacks property name and therefore needs to have each property defined in [TimeSystem_Properties_External] with the “Property ID” (from the source file).

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
Protime data element (source)
PropertyID
Property Name
Not in use
DepartmentName
Date
Not in use
Type
Not in use
PayCodeName
StaffID
Hours
Approbation
Comment
Not always reliable.
Empty = true