All Menu > Export/Import > "Create Output Layout" to the right of "Monthly Data [CSV]"
I will explain the details of the output items that can be selected from the above menu.
Details of the output
Here are the details of the output item.
※Depending on the setting situation, some items may not be displayed.
About the items marked with "★"
Depending on your environment, these items may not be displayed. To display it, please request the support center to add a "working attendance item setting unification function" (Click here for specification changes when adding functions).
Item name | Explanation |
---|---|
Company code | A corporate code is a three-digit or six-digit code issued when the system is opened. IDs for administrators and employees are issued based on this code. |
Company name | The company name will be output. |
Affiliation code | The "affiliation code" of the employee belongs to will be output (not the place of work). |
Affiliation | The "affiliation name" of the employee belongs to will be output (not the place of work). |
Affiliation group code | ※It will be displayed when using the affiliated group function. The group code of your affiliation will be output. |
Name of the group | ※It will be displayed when using the affiliated group function. The group name of the belongings will be output. |
Employment classification code | The employment classification code will be output. |
Employment category | The employment category name will be output. |
Employee group code | *It is displayed when using the employee group function. The employee group code to which the employee belongs will be output. When you belong to two or more employee groups, the code of all the groups you belong to will be output. There is a single character blank space between the code and the code. |
Employee group code (::separated) | *It is displayed when using the employee group function. The employee group code to which the employee belongs will be output. When you belong to two or more employee groups, the code of all the groups you belong to will be output. The code and the code are separated by "::". |
Name of employee group | *It is displayed when using the employee group function. The name of the employee group to which the employee belongs will be output. When you belong to two or more employee groups, the names of all the groups you belong to will be output. There is a single character blank space between the name and the name. |
Employee code | The employee code will be output. |
Other employee management code 1 | "Other employee management code 1" will be output. |
Other employee management code 2 | "Other employee management code 2" will be output. |
Name | The employee's name is output as a full name (no furigana). |
Name (furigana) | The furigana of the employee's name (full name) will be output. |
Last name | The last name will be output (no furigana). |
Surname (Furigana) | The furigana of the last name will be output. |
First name | The name will be output (no furigana). |
Name (Furigana) | The furigana of the name will be output. |
Middle name | * It will be displayed when "First name middle name" or "First name middle name" is selected in Settings > Other > Options > Display Settings category > Display format. The middle name will be displayed. |
Gender | The gender will be output. |
Date of birth | Your date of birth will be output. |
Date of joining the company | The date of joining the company will be output. |
Date of retirement | The date of retirement will be output. |
Contracted working hours on the day (employees) | The contract working hours on the date registered in the employee settings will be output. If there is a registration in the employment classification setting, but there is no registration in the employee setting, this item will not be output. |
Number of contracted working days per week (employees) | The number of contract working days of the week registered in the employee settings will be output. If there is a registration in the employment classification setting, but there is no registration in the employee setting, this item will not be output. |
Email address | Your email address will be output. |
Aggregation start date | At the time of data output, the aggregation start date selected as the output period is output. |
Aggregation end date | When outputting the data, the aggregate end date selected as the output period is output. |
Output target month | At the time of data output, the output target month selected as the output period will be output. |
I belong to where I go to work | The "affiliation name" of the place of work will be output. |
Attendance code | The "affiliation code" of the place of work will be output. |
Affiliation (output option) | *Settings > Others > Options > Attendance Management Settings Category > Work Data Aggregation Units will be displayed when "You can output even by your workplace" in the aggregation unit. When outputting data, if "output at the employee's workplace" is not checked in the output option, your own affiliation name is displayed, and if it is attached, the name of the place of the place of work will be output. |
Affiliation code (output option) | *Settings > Others > Options > Attendance Management Settings Category > Work Data Aggregation Units will be displayed when "You can output even by your workplace" in the aggregation unit. When outputting attendance data, if "output at the employee's workplace" is not checked in the output option, the self-affiliate code is printed, and if it is attached, the destination code will be output. |
Estimated labor costs | ※It is displayed when using the labor cost estimate output function. Estimates of labor costs excluding transportation expenses will be output. |
Estimated labor costs (time zone classification) | ※It is displayed when using the labor cost estimate output function and the time zone classification setting function. Time zone classification hourly wage unit price × time zone classification working hours are output. |
Labor cost + transportation expenses | ※It is displayed when using the labor cost estimate output function. Estimated labor costs including transportation expenses will be output. |
Working base time (monthly) | ※It uses the deformed labor setting function, and it is displayed when "Display of working standard time" in the Settings > Other > Options > Deformed labor setting function. The reference time (monthly) of "transformed labor" registered in the employment classification setting (or employee setting) will be output. |
Predetermined time | The predetermined time will be output. |
Out-of-s. | The undetermined time will be output. |
Overtime hours | Overtime time will be output. |
Overtime of the week | ※It will be displayed when the statutory working hours of the week are set. It is calculated according to the rules set in Settings > Employment Category Settings > Overtime Aggregation Category of the Week > Legal Working Hours per Week. Daily overtime (such as exceeding 8 hours a day) are not included. |
Late-night overtime of the week | ※It will be displayed when the statutory working hours of the week are set. It is calculated according to the rules set in the following two items. Daily overtime (such as exceeding 8 hours a day) are not included.
|
Regular overtime hours on statutory holidays | ※It will be displayed when the statutory working hours of the week are set. It is calculated according to the rules set in Settings > Employment Category Settings > Overtime Aggregation Category of the Week > Legal Working Hours per Week. Daily overtime (such as exceeding 8 hours a day) are not included. |
Late night overtime on statutory holidays | ※It will be displayed when the statutory working hours of the week are set. It is calculated according to the rules set in the following two items. Daily overtime (such as exceeding 8 hours a day) are not included.
|
Deformed overtime hours | ※It is displayed when using the deformed labor setting function. It is calculated according to the rules set in Settings > Employment Classification Settings > Work Style Category > Deformed Working Hours System. Daily overtime (such as exceeding 8 hours a day) are not included. |
Deformed labor late-night overtime hours | ※It is displayed when using the deformed labor setting function. It is calculated according to the rules set in the following two items. Daily overtime (such as exceeding 8 hours a day) are not included.
|
Deformed labor statutory holiday overtime hours ★ | ※It is displayed when using the deformed labor setting function. It is calculated according to the rules set in the following two items. Daily overtime (such as exceeding 8 hours a day) are not included.
|
Deformed labor statutory holiday late-night overtime ★ | ※It is displayed when using the deformed labor setting function. It is calculated according to the rules set in the following three items. Daily overtime (such as exceeding 8 hours a day) are not included.
|
Deformed labor statutory overtime hours ★ | ※It is displayed when using the deformed labor setting function. It is calculated according to the rules set in the following two items. Daily overtime (such as exceeding 8 hours a day) are not included.
|
Deformed labor statutory overtime hours ★ | ※It is displayed when using the deformed labor setting function. It is calculated according to the rules set in the following three items. Daily overtime (such as exceeding 8 hours a day) are not included.
|
Late-night time | The designated time at midnight will be output. |
Late night outside time ★ | Late-night extra time will be output. |
Late night overtime | Late-night overtime will be output. |
Time for holidays | The scheduled holiday time will be output. |
Outside of the scheduled holiday ★ | The time outside the holiday will be output. |
Holiday overtime ★ | Holiday overtime will be output. |
Late night time on holidays | The designated time at midnight on holidays will be output. |
Late-night holidays outside of the night ★ | Out-of-sed hours will be output late at night on holidays. |
Late-night overtime on holidays ★ | Late-night overtime hours on holidays will be output. |
Extra overtime hours | ※It will be displayed when using the extra overtime aggregation function. Extra overtime will be output. |
Extra overtime hours 2 | ※It will be displayed when using the extra overtime aggregation function. Extra overtime hours 2 will be output. |
Extra late-night overtime hours | ※It will be displayed when using the extra overtime aggregation function. Extra late-night overtime will be output. |
Extra late-night overtime hours 2 | ※It will be displayed when using the extra overtime aggregation function. Extra late-night overtime hours 2 will be output. |
Break time | The break time will be output. |
Late time | The late arrival time will be output. |
Early departure time | The early departure time will be output. |
Total working hours | The total working time will be output. |
Late and early departure time | The sum of late hours and early departure time will be output. |
Time zone 1 to 8 working hours | ※It is displayed when using the time zone setting function. The working hours of each time zone category will be output. |
Time zone 1 to 8 overtime hours | ※It is displayed when using the time zone setting function. Overtime hours for each time zone will be output. |
Time zone outside the time zone | ※It is displayed when using the time zone setting function. On the day when the time zone classification is allocated, the working hours outside the time zone category will be output. |
Overtime hours outside the time zone | ※It is displayed when using the time zone setting function. Overtime hours outside the time zone on the day when the time zone classification is allocated will be output. |
Time zone classification Total overtime hours | ※It is displayed when using the time zone setting function. The sum of overtime hours generated in the time zone will be output. |
Legal holiday scheduled time | The prescribed time for the statutory holiday will be output. |
Legal non-holiday prescribed time | The prescribed time for non-statutory holidays will be output. |
Out-of-sal time on statutory holidays ★ | The extra time on statutory holidays will be output. |
Legal non-regular holidays ★ | The extra time for the statutory holiday will be output. |
Late night time on statutory holidays | The designated time for the late night of the statutory holiday will be output. |
Late night time on statutory holidays | The designated time for late night on non-statutory holidays will be output. |
Legal holiday overtime hours ★ | Legal holiday overtime hours will be output. |
Legal overtime hours on statutory holidays ★ | Legal overtime hours will be output. |
Late-night non-alregular hours on statutory holidays ★ | The extra time outside the late night of the statutory holiday will be output. |
Late-night overtime hours on statutory holidays ★ | Late-night overtime hours will be output on statutory holidays. |
Late-night out-of-late hours on statutory holidays ★ | The late night time outside of the statutory holiday will be output. |
Late-night overtime hours on statutory holidays ★ | Late-night overtime hours will be output on statutory holidays. |
(Vacation name) Time off taking time | ※It will be displayed when using hourly holidays. The time of taking time off is output. In the "Day Count" > (vacation name) section on the time card screen, the output value is different because the time of taking time off is converted to daily. |
(Vacation name) Number of days remaining / remaining time | ※It will be displayed when using hourly holidays. ※In Settings > Schedule > Leave Classification Settings, only vacations set to "Decomment" with "Decommentation" setting "How to calculate the number of leave due to vacation acquisition" at the time of new registration will be displayed. The remaining days and remaining time of the vacation will be output. Example: 10/3H |
Alternate leave grant time | ※It will be displayed when using the alternative leave grant function. The granted alternative leave time will be output. |
Alternate vacation converted time | ※It will be displayed when using the alternative leave grant function. The overtime hours converted as alternative leave will be output. |
Time to leave | The vacation time that has been set as a leave-deemed working hours will be output (click to the "recomm-de-vacation working hours" setting here). The aforementioned "predetermined time", "late night predetermined time" and "total working hours" are the time of the result of adding vacation-deemination working hours. ※In the case of the vacation acquisition method "Use of leave classification", the absence of leave only "Calculation of each vacation category" in the "Calculation of leave-deem vacation time" item in the leave classification setting or employment classification setting, the time without leave only set as "Calculation of each vacation category" will not be added to this item. |
No monthly overtime hours | "Monthly no overtime" registered in the employment classification setting (or employee setting) will be output. |
(Vacation name) Time | ※It will be displayed when the working hours deemed to be taken on vacation are set in the environment of the vacation acquisition method "Use vacation classification". The vacation time by vacation category will be output. |
Holiday labor fee allowance time | *Settings > Schedule > Leave Classification Settings > [Edit] > Increase the number of vacations when working on holidays is selected when "Increase the number of days off" is selected. Among the holiday working hours, the time that became the basis for the occurrence of the substitute leave will be output. For example,
|
Flex working standard time | * Displayed when "Deformed Labor Type: Flex" is set. Timecard > Flextime Aggregation > "Last month's reference time" will be output (click here for details). |
Working hours within the flex standard | * Displayed when "Deformed Labor Type: Flex" is set. Timecard > Flextime Aggregation > "In-standard working hours" will be output (click here for details). |
Working hours outside the flex standard | * Displayed when "Deformed Labor Type: Flex" is set. Timecard > Flextime Aggregation > "Out-standard working hours" will be output (click here for details). |
Flex surcharge target time | * Displayed when "Deformed Labor Type: Flex" is set. Timecard > Flextime Aggregation > "Additional Time" will be output (click here for details). |
Flex predetermined working hours | * Displayed when "Deformed Labor Type: Flex" is set. Timecard > Flextime Aggregation > "Determ time for the current month" will be output (click here for details). |
Working hours prescribed within the flex standard | * Displayed when "Deformed Labor Type: Flex" is set. Working hours in "Flex predetermined working hours" will be output. One-month flextime system (liquidation of the current month): It is the same aggregate value as "flex predetermined working hours". One-month flextime system (liquidated next month):
*2: The value of "Total statutory working hours for the next month" - "Flex predetermined working hours for the next month". For example, in the case of "total statutory working hours: 177 hours" and "flex prescribed working hours: 160 hours" in May, the "time that can be carried over to the next month" in April will be 17 hours. |
Outside of the flex-standard time | * Displayed when "Deformed Labor Type: Flex" is set. Timecard > Flextime Aggregation > "Out-of-Rated Time within the Standard" will be output (Click here for details). |
Number of working days on weekdays | The number of working days on weekdays will be output. |
Number of working days on statutory holidays | The number of working days on statutory holidays will be output. |
Number of working days on statutory holidays | The number of working days on statutory holidays will be output. |
Number of times you are late | The number of times you are late will be output. |
Number of early returns | The number of early returns will be output. |
Late and early return | The sum of the number of late arrivals and the number of early returns will be output. |
Number of interval shortages | ※It will be displayed when using the inter-work interval insufficient counting function. The number of interval shortages calculated by the rules set in the Settings > Options > Attendance Management Settings Category > Interwork Intervalency Count function will be output. |
Total number of working days | The total number of working days will be output. This is the total number of working days on weekdays and working days on holidays. The number of days of leave taken (such as paid leave) is not included. |
Total number of attendance | The total number of attendance will be output. The day you take a half day off and go to work for half a day is counted as once. |
Predetermined number of days | The sum of the number of working days on weekdays and the number of days of paid leave will be output. |
Number of days on the schedule | The scheduled number of days will be output. The date when the following schedule data is registered is counted.
|
(Vacation name) Number of days taken | The number of days of leave will be output. Only the number of days taken on a "day basis" such as full-day leave and half-day leave will be output. The "Days Aggregation" > (vacation name) section on the time card screen also includes the time of taking time off on an hourly basis, so the output value is different. |
(Vacation name) Number of days remaining | ※In Settings > Schedule > Leave Classification Settings, only vacations set to "Decomment" with "Decommentation" setting "How to calculate the number of leave due to vacation acquisition" at the time of new registration will be displayed. The remaining days of the vacation will be output. |
(Retired absence) Number of days granted (weekdays) | *In Settings > Schedule > Leave Classification Settings > Edit > Granting a Leave, it will be displayed when there is a vacation that is selected to "Grant a leave by granting a transfer schedule". The number of working days that have been granted on weekdays will be output. |
(Lifting days off) Number of days granted (statutory holiday) | *In Settings > Schedule > Leave Classification Settings > Edit > Granting a Leave, it will be displayed when there is a vacation that is selected to "Grant a leave by granting a transfer schedule". The number of working days granted a leave on a statutory holiday will be output. |
(Late rest) Number of days granted (statutory holidays) | *In Settings > Schedule > Leave Classification Settings > Edit > Granting a Leave, it will be displayed when there is a vacation that is selected to "Grant a leave by granting a transfer schedule". The number of working days that have been granted a leave on a non-statutory holiday will be output. |
(Name of leave) Number of days granted | The number of days granted will be output (automatic grant + manual grant). |
(Vacation name) Number of days granted (manual grant) | The number of days of days of the manually granted vacation will be output. |
(Vacation name) Number of half-day leave | *Only vacations set to "Use half-day off" will be displayed in Settings > Schedule > Vacation Classification Settings. The number of half-day take will be output. |
(Vacation name) Remaining time | ※It will be displayed when using hourly holidays. ※In Settings > Schedule > Leave Classification Settings, only vacations set to "Decomment" with "Decommentation" setting "How to calculate the number of leave due to vacation acquisition" at the time of new registration will be displayed. The remaining time of the hourly vacation will be output. |
(Vacation name) Cumulative time | ※It will be displayed when using hourly holidays. ※In Settings > Schedule > Leave Classification Settings, only vacations set to "Accomply" with "Additional" setting "How to calculate the number of leave due to vacations" will be displayed at the time of new registration. The cumulative time of the hourly leave generated within the target year will be output. |
Estimated transportation expenses | ※It is displayed when using the labor cost estimate output function. Transportation expenses will be output. |
Counting items | *It is displayed when using the counting function. You can select the count item you created as the layout. |
Monthly data custom items (aggregation items) | ※It is displayed when creating a monthly data custom item. You can select the monthly data custom item you created as the layout. |
Custom data items (monthly) | *It will be displayed when creating a custom data item. You can select the custom data item you created (monthly) as the layout. "(Item name)" is displayed. |