PMI Knowledge base

Back to 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
Print

TMS – Kronos

Updated
ByAndreas Engkvist
Views641
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.
Because the Time interfaces are still maintained in the old import structure, their name starts with: ‘I_T7_DD_’.

Interface name incl. version
I_T7_DD_KRONOS_TIME_V002
Comment
File name pattern: Kronos_pmitime*
Columns
1
2
3
4
5
6
7
8
9
10
11
Name
LABORLEVELNAME1
LABORLEVELDSC1
LABORLEVELNAME2
LABORLEVELDSC2
APPLYDATE
PAYCODEID
PAYCODENAME
LABORLEVELNAME3
LABORLEVELDSC3
PERSONNUM
TIMEINSECONDS
1
2
3
4
5
6
7
8
PMI data element (target)
Property Name
Department Name
Date
TimeCategory
JobCategory
Staff ID
Hours
Approved
Description
Name of the property (hotel, restaurant)
Name of the department within the property
Working date (timesheet)
Name of the time category
Name of the job/task category
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
Data transformation/load rules
Directly mapped from source file
Directly mapped from source file
Directly mapped from source file
Directly mapped from source file
Directly mapped from source file
Directly mapped from source file
Directly mapped from source file
Approved and to-be-approved hours exist. Loading rule: only import approved hours
Data element (source)
LABORLEVELDSC1
LABORLEVELDSC2
APPLYDATE
PAYCODENAME
LABORLEVELDSC3
PERSONNUM
TIMEINSECONDS
Not in source file
Comment
Property name is used to validate if the row needs to be imported (hard coded).
Original header: sum( cast( [TIMEINSECONDS] as decimal ) / 3600 )
All hours included in the file are approved
Download an example of the source file format: File:I T7 DD KRONOS TIME V002.zip
Tags: