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

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
Does not exist in file. ID provided by local PMI agent
Does not exist in file. ID provided by local PMI agent
3rd column (from left in the file)
Does not exist in file
1st column (from left in the file)
4th column (from left in the file)
Does not exist in the file
Does not exist in the file
Does not exist in the file
2nd column (from left in the file)
5th column (from left in the file)
Does not exist
Mirus data element (source)
N/A
N/A
3rd column
N/A
1st column
4th column
N/A
N/A
N/A
2nd
5th column
N/A
Comment
All hours in the file are approved hours. Non-approved hours are excluded in the export setting in Mirus.