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