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

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 import uses the HIDXXX folder structure and the hard coded “siteId” to determine the property. This means that the property needs to be defined in the TimeSystem_Properties_External table.

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)
n/a
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
n/a
n/a
n/a
Directly mapped to source equivalent
Directly mapped to source equivalent
n/a
n/a
Directly mapped to source equivalent but is numeric
n/a
Exists in minutes. Transformation rule: minutes divided by 60 to get number of hours in PMI
n/a
Timeplan data element (source)
Costcenter
Date
Account
Balance
Everything is treated as approved.