Please check the following setting method and cooperate.
※Note
With PCA salary, you can change the item name and the rules associated with the item (such as changing the premium rate from x1.5 to x0.25), but this article describes the default settings.
Functional overview
You can link by outputting attendance information as CSV data from KING OF TIME and importing it into PCA salary. Payroll can be calculated based on the linked information.
Advance preparation
To output from KING OF TIME, create an output layout that includes linked items.
1. KING OF TIME Login ＞ Frequently used menu “Export / Import” ＞ Monthly data “Create output layout” ＞ Click “New”.
2. Set any name such as the layout name "PCA Payroll DX Linkage".
3. Select the output item in "Display item".
Select the item in the "KING OF TIME" column of the "Linkage item" below and click [Register].
* Items and order to be imported into PCA salary are specified. Please select the same items and order.
* Select the same number of "--blank--".
Linkage item
| PCA salary | Premium rate | KING OF TIME |
Remark |
|---|---|---|---|
| Employee code | Employee code | ||
| Number of working days required | Fixed (days) | ||
| Working hours required | Contract working hours per day (employee) | ||
| Number of working days | Total clock-in days | ||
| Attendance time | Fixed (hrs) | ||
| Accident absentee days | Absence days | ||
| Illness absentee days | --Blank-- | ||
| Number of special holidays | Substitute time-off days | ||
| Time-off clock-in (days) on holiday | Legal time-off clock-in (days) | ||
| Number of days of paid holidays | --Blank-- | ||
| Number of days remaining | --Blank-- | ||
| Overtime weekdays normal | 125％ | Overtime hours (+ overtime) |
Unspecified premium rate If different, term Please separate your eyes. (※1） |
| Overtime work weekdays midnight | 150％ | Midnight overtime (+ midnight non-scheduled) |
Midnight extra charge If the rates are different Separate items Sai. (※2） |
| Overtime holiday normal | 125％ |
Non-legal time-off overtime + Non-statutory holidays + Non-statutory holidays Non-scheduled |
"Monthly data cas Tom item function Use and one term Add up as eyes Please give me. (※3） |
| Overtime holiday midnight | 150％ |
Non-Legal time-off late night overtime (hrs) + Non-statutory holiday midnight prescribed + Non-statutory holiday Midnight non-scheduled |
"Monthly data cas Tom item function Use and one term Add up as eyes Please give me. (※3） |
| Overtime legal holiday | 135％ | Legal time-off overtime (hrs) + Legal holidays + Not specified on legal holidays |
"Monthly data cas Tom item function Use and one term Add up as eyes Please give me. (※3） |
| Overtime legal midnight | 160％ | Legal time-off late night overtime (hrs) + Legal holiday midnight scheduled time + Legal holiday midnight overtime |
"Monthly data cas Tom item function Use and one term Add up as eyes Please give me. (※3） |
| Late-in/early-out (count) | Late-in/early-out (count) | ||
| Late-in/early-out (hrs) | Late-in/early-out (hrs) | ||
| Number of holidays | Number of leave days taken | ||
| Paid time digestion | Paid holiday acquisition time | ||
| Remaining number of holidays | Number of days remaining | ||
| Remaining paid holidays | Remaining vacation time | ||
| Available holidays | --Blank-- | ||
| Overtime work weekdays normally under 45 | 125％ | --Blank-- | |
| Overtime Weekdays Normal over 45 | 125％ | Extra overtime hours | |
| Overtime Weekdays Normal over 60 | 150％ | Bonus wage overtime 2 (hrs) | |
| Overtime weekdays regular holidays | 125％ | --Blank-- | |
| Overtime work weekdays under 45 midnight | 150％ | --Blank-- | |
| Overtime Weekdays over 45 midnight | 150％ | Extra midnight overtime hours | |
| Overtime Weekdays over 60 midnight | 175％ | Bonus wage late night overtime 2 (hrs) | |
| Overtime Weekday midnight holiday | 150％ | --Blank-- | |
| Overtime holidays usually under 45 | --Blank-- | ||
| Overtime holidays over 45 | 125％ | --Blank-- | |
| Overtime holidays usually over 60 | 150％ | --Blank-- | |
| Overtime holidays Regular holidays | 125％ | --Blank-- | |
| Overtime holiday under midnight 45 | --Blank-- | ||
| Overtime holiday over 45 midnight | 150％ | --Blank-- | |
| Overtime holiday over 60 midnight | 175％ | --Blank-- | |
| Overtime holiday Midnight holiday | 150％ | --Blank-- | |
| Attendance free time 1-10 | --Blank-- | ||
| Attendance free number 1-10 | --Blank-- | ||
| Number of times 1 to 30 | --Blank-- |
※1
If the "non-scheduled" premium rate is 125%, add up the "overtime hours", and if the premium rate is 100%, add up the "prescribed hours" and output. When calculating salary separately from "overtime hours" and "prescribed hours", output in the order that matches the import items on the PCA salary side, such as "Attendance free time 1 to 10".
※2
If the premium rate for "Midnight overtime" is 150%, add it to "Midnight overtime" and output. When calculating salary separately from "Midnight overtime hours", output in the order that matches the import items on the PCA salary side, such as "Attendance free time 1 to 10".
※1～※3
Please refer to here for the total method.
Cooperation method
1. KING OF TIME Login ＞ Frequently used menu “Export / Import” ＞ Click [Monthly Data Output].
2. Select the output target date, output layout, and output target employee, and click [Data Output] on the [Data Output]> Confirmation screen.
On the monthly data output confirmation screen, select ": Colon" for "Time delimiter" and click [Data output].
For the output layout, select the layout created in "Preparation".
Notice
If you change the time delimiter to ": (colon)" and open the output CSV file in Excel, the time display format may change depending on the Excel specifications. When checking / editing the data output with a colon, it is recommended to open the output CSV file with "Notepad" and edit it. The format of the time item of PCA Payroll DX is "99:59". When editing with Excel, if "[h]: mm: ss" is displayed up to the number of seconds due to cell formatting, an error will occur if you import it as it is. Be sure to delete the seconds part.
3. Click PCA Payroll DX> Main Category "Anytime"> [Accept General Purpose Data].
4. Select the CSV data to be imported and the payroll month.
(1) Select "Distributed data".
(2) Select "Salary attendance data".
(3) Select the CSV data output from KING OF TIME.
(4) Select the payment month corresponding to the payment month.
(5) After selecting the above four, click [Execute].
5. Two pop-up confirmation screens will be displayed. Click [Yes].
6. The "Transfer General Data" screen will be displayed. Click [Transfer].
7. Click Close when the transfer is complete.