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.
| # | PMI data element (target) | Description | Mandatory / Optional | Data transformation/load rules | Mirus data element (source) | Comment |
|---|---|---|---|---|---|---|
| 1 | Property ID | ID of the property (hotel, restaurant) | M | Does not exist in file. ID provided by local PMI agent | N/A | |
| 2 | Property Name | Name of the property (hotel, restaurant) | M | Does not exist in file. ID provided by local PMI agent | N/A | |
| 3 | Department ID | ID of the department within the property | M | 3rd column (from left in the file) | 3rd column | |
| 4 | Department Name | Name of the department within the property | M | Does not exist in file | N/A | |
| 5 | Date | Working date (timesheet) | M | 1st column (from left in the file) | 1st column | |
| 6 | TimeCategory ID | ID of the time category | M | 4th column (from left in the file) | 4th column | |
| 7 | TimeCategory Name | Name of the time category (e.g. Fixed Salary, Absence) | M | Does not exist in the file | N/A | |
| 8 | JobCategory ID | ID of the job category | O | Does not exist in the file | N/A | |
| 9 | JobCategory Name | Name of the job category (e.g. Servers, Managers) | O | Does not exist in the file | N/A | |
| 10 | Staff ID | ID of the staff (employee) | M | 2nd column (from left in the file) | 2nd | |
| 11 | Hours | Number of hours (on the timesheet) | M | 5th column (from left in the file) | 5th column | |
| 12 | Approved | If the hours are approved or not | M | Does not exist | N/A | All hours in the file are approved hours. Non-approved hours are excluded in the export setting in Mirus. |
Download an example of the source file format: File:EXPORT MIRUS.zip