Please check the following items before setting up the link.
Table of contents
Functional overview
You can link by outputting attendance information as CSV data from KING OF TIME and importing it into the TKC Strategic Salary Information System PX2 (hereinafter referred to as PX2). Payroll can be calculated based on the linked information.
Advance preparation
Create an output layout for outputting linked items from KING OF TIME.
1. Log in to the KING OF TIME management screen and click [Export/Import] > [Monthly data [CSV]] in the frequently used menu [Create output layout] > [Create new] on the right side.
2. Enter an arbitrary name such as "For TKC_PX2 linkage" in the layout name.
3. Match the time display format to PX2.
*On the PX2, you can select decimal or hexadecimal numbers.
4. Select the output items in "Display items". Select the items in the "KING OF TIME" column in the "Linked items " table below and add them to "Selected items". Click Register when you have finished adding all the required items.
point
You can easily find the item you need by copying the item name on the KING OF TIME side in the "Linking items" table and searching for words on the screen ([CTRL] + [F] on the keyboard).
Linked item
Please note
1. The items to be imported into PX2 and their order are predetermined. Please check the table below and select the same items in the same order.
2. Even if there are no corresponding items on the KING OF TIME side and on the PX2 side, select "--Blank--" and align the number of items on the KING OF TIME side and the PX2 side.
3. In PX2, you can arbitrarily change the item name of "overtime allowance hours A to H" and the associated premium rate, but this article describes the default value. The default values are as follows.
- Overtime allowance time A: legal 100%
- Overtime allowance time B: 125% on weekdays
- Overtime allowance time C: 150% late at night on weekdays
- Overtime allowance time D: 135% on holidays
- Overtime allowance time E: 160% late at night on holidays
- Overtime allowance time F: (Both name and premium rate are not set)
- Overtime allowance time G: (Both name and premium rate are not set)
- Overtime allowance H: 25% over 60h
| TKC Strategic Salary Information System PX2 |
premium rate | KING OF TIME | remarks |
|---|---|---|---|
| Employee number (required) | employee code | ||
| Employee name (template item) | name | ||
| work on weekdays | Working days on weekdays | ||
| Holiday work | Number of days worked on non-statutory holidays + Number of days worked on legal holidays | Click here for calculation method | |
| Commencement time | total hours worked | ||
| behind time | Number of times late | If you have changed the attribute to time on the PX2 side, select late time. | |
| leaving early | Number of times leaving early | If you have changed the attribute to time on the PX2 side, select early leave time. | |
| Number of paid holidays | Number of days of paid leave taken | ||
| day in lieu | Compensatory days taken | ||
| Public holiday | Public holidays taken | ||
| Other holidays | --blank-- | ||
| Menstrual leave | --blank-- | ||
| Leave of absence days | --blank-- | ||
| Absent days | Absence days taken | ||
| Working days for daily table | --blank-- | ||
| deduction days | --blank-- | ||
| deduction time | --blank-- | ||
| Overtime allowance time A | 100% | Overtime | |
| Overtime allowance time B | 125% | overtime hours | |
| Overtime allowance time C | 150% | late night overtime | |
| Overtime allowance time D | 135% | Overtime hours on legal holidays + specified legal holidays + non-fixed legal holidays | Click here for calculation method |
| Overtime allowance time E | 160% | Legal holiday late night overtime hours + Legal holiday late night fixed hours + Legal holiday late night overtime hours | Click here for calculation method |
| Overtime allowance time F | --blank-- | ||
| Overtime allowance time G | --blank-- | ||
| Number of times allowance number of times I | --blank-- | ||
| Number of times allowance number II | --blank-- | ||
| Number of times allowance number III | --blank-- | ||
| Number of times allowance IV | --blank-- | ||
| Number of times allowance Ⅴ | --blank-- | ||
| Work days required | --blank-- | It is not a calculation item on the PX2 side. | |
| Attendance required | --blank-- | It is not a calculation item on the PX2 side. | |
| Prescribed working days | --blank-- | Select "Predetermined days" only if you have set the prescribed working days and hours for each individual in PX2. It is used for automatic calculation of the following. (1) Overtime allowance (extra wage) (2) Salary deduction |
|
| prescribed working hours | --blank-- | ||
| Number of paid holidays left over | --blank-- | ||
| Number of paid holidays remaining for the current year | --blank-- | ||
| Paid holiday hours | Paid vacation hours | ||
| Overtime allowance time H | twenty five% | Extra overtime hours 2 | Click here for related articles |
| Hours of paid leave per day | --blank-- | ||
| Remaining paid vacation carry-over | --blank-- | ||
| Paid vacation time balance for the current year | --blank-- | ||
| alternative leave | --blank-- | ||
| More than 60 overtime hours in the current month | --blank-- | In PX2, there are items related to alternative leave (Article 37, Paragraph 3 of the Labor Standards Act). You can also create and assign a value by subtracting 60 hours from "Premium overtime hours 2". Click here for how to create the above custom item . Fixed value: Create with [-60]. *Please also check the supplement below the table. |
|
| conversion rate | --blank-- | ||
| Remaining substitute vacation time in the previous month | --blank-- | ||
| Remaining substitute vacation time two months ago | --blank-- | ||
| Number of substitute leave hours used in the current month | --blank-- | ||
| of which hourly | --blank-- |
supplement
If the total overtime hours in a month exceeds 60 hours, there is a system to give paid leave (substitute leave) instead of the extra wage for the increase, and this system can also handle it. If you want to use it , please ask the support center to add the "alternative leave grant function".
Data linkage between systems
1. Log in to the KING OF TIME management screen and click the frequently used menu [Export/Import] > [Monthly data [CSV]].
2. Select the target date, output layout, and target employee. For the output layout, select the layout created for PX2. [Data Output] > Click [Data Output] on the confirmation screen.
3. Start PX2 and click the Payroll tab > [Employer-specific data entry/calculation].
4. Click [Read data from CSV file (F5)].
5. Click [Select Layout], select [All Attendance Items (Fixed Layout)], and click [F4 Select].
6. Click [Select file] and select the CSV data output from KING OF TIME. Click [Start reading].
7. When the loading is successfully completed, a file loading completion message and a selection screen asking "Are you sure you want to check the loaded data?" will be displayed. Click [Yes].
8. In "Input method settings", specify "Input method settings" and "Input content settings", and click [OK].
9. You will be able to check the target person on the attendance entry screen of PX2.
please note
If a read error occurs in step 7, or for operations after step 8, please refer to PX2 help "Cheat Sheet" 5. [Employer-specific data entry/calculation].