TMS – Tidsbanken

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.

Planday is used as sample for Tung to complete

#PMI data element (target)DescriptionMandatory / OptionalData transformation/load rulesPlanday data element (source)Comment
1Property IDID of the property (hotel, restaurant)MExists but not used. See Property Name belowPortalId
2Property NameName of the property (hotel, restaurant)MDirectly mapped to source equivalentPortalName
3Department IDID of the department within the propertyMExists but not used. See Department Name belowDepartmentId
4Department NameName of the department within the propertyMDirectly mapped to source equivalentDepartmentName
5DateWorking date (timesheet)MDerived from date and time stringStart
6TimeCategory IDID of the time categoryMExists but not used. See TimeCategory Name belowTimesheetTypeID
7TimeCategory NameName of the time category (e.g. Fixed Salary, Absence)MMapped to PMI equivalentTimesheetTypeNameThis is needed to separate productive and non-productive hours
8JobCategory IDID of the job categoryOExists but not used. See JobCategory Name belowEmployeeGroupID
9JobCategory NameName of the job category (e.g. Servers, Managers)ODirectly mapped to source equivalentEmployeeGroupName
10Staff IDID of the staff (employee)MExists but not usedEmployeeIDNot presented at staff level, but at job category and date level
11HoursNumber of hours (on the timesheet)MExists in minutes. Transformation rule: minutes divided by 60 to get number of hours in PMIMinutes
12ApprovedIf the hours are approved or notMApproved and to-be-approved hours exist. Loading rule: only import approved hoursTimeSheetApprovedAll hours included in the file are approved in Planday

Download an example of the source file format:

Was this article helpful?

Related Articles