◆All menus> Export/Import> Next to “Monthly data [CSV]”"Output layout creation"
The details of each output item are shown below.
*Depending on the settings, the items in the following list may not be displayed in your environment.
Output item details
| Item name | Description |
|---|---|
| Company code | The company code is a 3-digit or 6-digit code issued when the environment of this system is opened. IDs for administrators and employees are issued based on this code. |
| Company name | The company name is output. |
| Division code | The "division code" of the division to which the employee belongs is output (not the work division). |
| Division name | The "division name" of the department to which the employee belongs is output (not the work department). |
| Employee group Division code/ Employee type code |
* Displayed when using the group function. The belonging group code is output. |
| Division group name | * Displayed when using the group function. The belonging group name is output. |
| Employee type code | The employee type code is output. |
| Employee type | The employee type name is output. |
| Employee Division code/ Employee type code |
* Displayed when using the employee group function. The employee group code to which the employee belongs is output. If you belong to more than one employee group, the codes of all the groups that belong to the group are output. There is one blank space between the code. |
| Employee Code (:: category) |
* Displayed when using the employee group function. The employee group code to which the employee belongs is output. If you belong to more than one employee group, the codes of all the groups that belong to the group are output. Codes are separated by "::". |
| Employee group name | * Displayed when using the employee group function. The employee group name to which the employee belongs is output. If you belong to two or more employee groups, the names of all the groups to which you belong are output. There is a blank space between the names. |
| Employee code | The employee code is output. |
| Other employees admin code 1 |
"Other employee admin code 1" are output. |
| Other employees admin code 2 |
"Other employee admin code 2" are output. |
| Name | The employee's name is output as the full name (without reading). |
| Name: (Phonetics) | The full name of the employee is output (with reading). |
| Last name* | The family name is output (without reading). |
| Last name (Phonetics) | The surname is output (with reading). |
| First Name* | The name is output (without reading). |
| First name (Phonetics) | The name is output (with reading). |
| middle name | *Settings ＞ Other ＞ Options ＞ "Display Settings" category ＞ "Display Format" is displayed when "Last Name Middle Name First Name" or "First Name Middle Name Last Name" is selected. The middle name is displayed. |
| Gender | Gender is output. |
| DOB | The date of birth is output. |
| Hired date | The date of joining the company is output. |
| Resignation date | The resignation date is output. |
| Daily contract work hours (employee) |
The contracted working hours on the day registered in the employee settings are output. If there is a registration in the employee type setting but not in the employee setting , this item is not output. |
| Weekly contract work days | The contracted working days of the week registered in the employee settings are output. If there is a registration in the employee type setting but not in the employee setting , this item is not output. |
| Email address | The email address will be output. |
| Aggregate start date | When data is output, the aggregation start date selected as the output period is output. |
| Aggregate end date | When data is output, the aggregation end date selected as the output period is output. |
| Output applicable month | When outputting data, the output target month selected as the output period is output. |
| Workplace division | The "division name" of the work organization is output. |
| Clock-in division code | The "division code" of the work organization is output. |
| Division name (Output option) |
*Settings ＞ Other ＞ Options ＞ "Attendance management settings" category ＞ "Summerize Attendance data by" is displayed only when "Enable output with division at each work location" is set. When outputting data, if "Enable output with division at each work location" is not checked in the output options, the self-division name is output and if it is checked, the work-division name is output. |
| Division code (Output option) |
*Settings ＞ Other ＞ Options ＞ "Attendance management settings" category ＞ "Summerize Attendance data by" is displayed only when "Enable output with division at each work location" is set. When outputting data, if "Enable output with division at each work location" is not checked in the output options, the self-division name is output and if it is checked, the work-division name is output. |
| Labor cost estimate | * Displayed when using the Labor cost estimate output function. Estimated personnel expenses excluding transportation expenses are output. |
| Labor cost estimate (Time category) |
* Displayed when using the Labor cost estimate output function and the time zone setting function. The hourly unit price by time category × time zone working hours is output. |
| Labor cost + transportation expenses | * Displayed when using the Labor cost estimate output function. Estimated personnel costs including transportation costs are output. |
| Standard work hour (Month) |
* This is displayed when you are using the Variable Working Hours Setting Feature and you have selected "Display standard work (hrs)" in Settings> Other> Options> "Variable Working Hours Setting Feature". The standard time (monthly unit) of "transformed work" registered in the employee type setting (or employee setting ) is output. |
| Fixed (hrs) | The specified time is output. |
| Extra hours (hrs) | The non-scheduled time is output. |
| Overtime hours | Overtime hours are output. |
| Overtime Under Variable Working Hours | *Displayed when using the variable working hours setting feature. ・Settings ＞ Employee type settings ＞ “Working style” category ＞ “Modified working hours system” It is calculated according to the accounting rule set above. Overtime hours calculated by day (over 8 hours/day, etc.) are not included. |
| Late Night Overtime Under Variable Working Hours | *Displayed when using the variable working hours setting feature. ・ Setting ＞ Employee type setting ＞ “Working style” category ＞ “Modified working hours system” ・Setting ＞ Employee type setting ＞ "Night work" category ＞ "late night work hours slot" It is calculated according to the accounting rule set above. Overnight work overtime (exceeding 8 hours/day, etc.) aggregated by day is not included. |
| Overtime under variable working hours Legal time-off overtime (hrs) |
*Displayed when using the variable working hours setting feature. ・ Setting ＞ Employee type setting ＞ “Working style” category ＞ “Modified working hours system” ・Variable working hours setting ＞ "Common" category ＞ Target Workday Type "legal time-off" It is calculated according to the accounting rule set above. Overnight work overtime (exceeding 8 hours/day, etc.) aggregated by day is not included. |
| Overtime under variable working hours Legal time-off late night overtime (hrs) |
*Displayed when using the variable working hours setting feature. ・ Setting ＞ Employee type setting ＞ “Working style” category ＞ “Modified working hours system” ・Variable working hours setting ＞ "Common" category ＞ Target Workday Type "legal time-off" ・Setting ＞ Employee type setting ＞ "Night work" category ＞ "late night work hours slot" It is calculated according to the accounting rule set above. Overnight work overtime (exceeding 8 hours/day, etc.) aggregated by day is not included. |
| Overtime under variable working hours Non-legal time-off overtime |
*Displayed when using the variable working hours setting feature. ・ Setting ＞ Employee type setting ＞ “Working style” category ＞ “Modified working hours system” ・Variable labor settings ＞ "Common" category ＞ Target work day type "non-legal time-off" It is calculated according to the accounting rule set above. Overnight work overtime (exceeding 8 hours/day, etc.) aggregated by day is not included. |
| Overtime under variable working hours Non-Legal time-off late night overtime (hrs) |
*Displayed when using the variable working hours setting feature. ・ Setting ＞ Employee type setting ＞ “Working style” category ＞ “Modified working hours system” ・Variable labor settings ＞ "Common" category ＞ Target work day type "non-legal time-off" ・Setting ＞ Employee type setting ＞ "Night work" category ＞ "late night work hours slot" It is calculated according to the accounting rule set above. Overnight work overtime (exceeding 8 hours/day, etc.) aggregated by day is not included. |
| ★Fixed late-night hours | The specified time at midnight is output. |
| ★Extra Late-night hours | The non-scheduled hours at midnight are output. |
| Late-night overtime hours | The midnight overtime hours are output. |
| Fixed Holiday hours | The specified holiday time is output. |
| ★ Extra Hours on Holiday | The non-scheduled holiday time is output. |
| ★ Fixed Late-night hours on holiday | The specified time at midnight on holidays is output. |
| ★ Extra Late-night Hours on Holiday | The specified time outside the holiday is output. |
| ★ Holiday overtime hours | The holiday overtime hours are output. |
| ★ Time-off late night overtime | Holidays Overnight hours are output. |
| Bonus wage overtime hours 1, 2 | *Displayed when using the bonus wage overtime aggregate function. The extra overtime hours are output. |
| Bonus wage late-night overtime hours 1, 2 | *Displayed when using the bonus wage overtime aggregate function. The extra late-night overtime hours are output. |
| Break (hrs) | The break time is output. |
| Late-in (hrs) | The late-in time is output. |
| Early-out (hrs) | The early exit time is output. |
| Total work (hrs) | The total labor time is output. |
| Late-in/early-out (hrs) | The sum of late time and early leave time is output. |
| Time slot categories 1-8 working time |
* Displayed when using the time slot category setting function. The working hours in each time slot category are output. |
| Time slot categories 1-8 |
* Displayed when using the time slot category setting function. The overtime hours for each time zone are output. |
| The overtime hours within each time slot category are output. | * Displayed when using the time slot category setting function. The working hours outside the time slot category on the day to which the time slot category is assigned are output. |
| Time category not classified overtime |
* Displayed when using the time slot category setting function. The overtime hours outside the time slot category on the day to which the time slot category is assigned are output. |
| Time category total overtime hours | * Displayed when using the time slot category setting function. The total of overtime hours that occurred within the time slot category is output. |
| Fixed Legal Holiday (hrs) | The specified time on legal holidays is output. |
| Fixed Non-legal Holiday(hrs) | The specified time on non-statutory holidays is output. |
| ★Extra Hours Legal Holiday (hrs) | The unassigned legal holiday hours are output. |
| ★ Extra Hours on Non-legal Holiday (hrs) | Non-statutory holidays The unassigned hours are output. |
| ★Legal holiday overtime hours | The legal holiday overtime hours are output. |
| ★ Overtime hours on non-statutory holidays | Non-legal holiday overtime hours are output. |
| ★ legal holiday Fixed late night hours |
Legal holiday The specified time at midnight is output. |
| ★ Non-legal holiday Fixed late night hours |
Non-statutory holiday The specified time at midnight is output. |
| ★ legal holiday Extra late night hours |
The non-scheduled hours of midnight on legal holidays are output. |
| ★ Non-legal holiday Extra late night hours |
Non-statutory holidays Non-scheduled hours are output at midnight. |
| ★ legal holiday Midnight prescribed overtime hours |
The legal holiday midnight overtime hours are output. |
| ★ Non-legal holiday Midnight prescribed overtime hours |
Non-statutory holidays midnight overtime hours are output. |
| Comp. vacation hours for time-off work | Of the working hours on holidays, the time that was the basis for the occurrence of substitute leave is output. Settings ＞ Schedule ＞ Leave type setting ＞ On the registration screen of "daily vacation", For example, ・Half-day work for 4 hours and 0 minutes or more ・Granted for one day on holiday work for 8 hours 0 minutes or more If the setting is made as follows, the scheduled holiday is 5 hours and 23 minutes on April 1 (of which 4 hours are allocated to work and holidays), and the scheduled holiday on April 2 is 9 hours and 30 minutes (including 8 hours). If this occurs, the allotted holiday work allowance time for this month will be 12 hours. |
| Standard flextime hours | * Displayed when "Variable working hour: flex" is set. Time card> Flextime total> "Criterion time of this month" is output. |
| Hours within standard flextime hours | * Displayed when "Variable working hour: flex" is set. Time card> Flextime total> "Standard working hours" is output. |
| Hours beyond standard flextime hours | * Displayed when "Variable working hour: flex" is set. Time card ＞ Flexible time total ＞ "Standard working hours (Extra hours)" is output. |
| Flextime bonus wage hours | * Displayed when "Variable working hour: flex" is set. Time card ＞ Flexible time total ＞ "Additional time" is output. |
| (Vacation name) Obtained (hrs) | * Displayed when using hourly leave. The vacation acquisition time is output. |
| (Vacation name) Number of remaining days/remaining time |
* Displayed when using hourly leave. * Only the vacations for which "Calculation method for vacation (count)" set to "Subtract" at the time of new registration in Settings> Schedule> Leave type settings are displayed. The number of days left and the time remaining will be output. |
| (Vacation name) remaining days/hours | * Displayed when using hourly leave. * Only the vacations for which "Calculation method for vacation (count)" set to "Subtract" at the time of new registration in Settings> Schedule> Leave type settings are displayed. The remaining vacation time is output. |
| Discretionary Overtime of the Month | Registered with employee type settings (or employee settings) "Monthly overtime hours" is output. |
| Discretionary vacation (hrs) | The vacation time for which the discretionary time is set is output. The total vacation discretionary hours of "discretionary working hours" set for full-day vacations and "discretionary working hours" for half-day vacations and hourly vacations are output. |
| Weekday clock-in (days) | The number of work days on weekdays is output. |
| Legal time-off clock-in (days) | The number of days worked for legal holidays is output. |
| Non-legal time-off clock-in (days) | The number of days worked for non-legal holidays is output. |
| Late-in (count) | The number of tardiness is output. |
| Early-out (count) | The number of early exits is output. |
| Late-in/early-out (count) | The sum of the number of late arrivals and the number of early exits is output. |
| Total clock-in days | The total number of working days is output. |
| Total clock-in (count) | The total number of attendances is output. Even on the day when you take half a day off and work half a day, it will be treated as one count. |
| Fixed (days) | The sum of the number of days worked on weekdays and the number of days used for paid leave is output. |
| Scheduled (days) | Outputs the number of days that the schedule is registered. Both regular work patterns and vacation patterns are counted. Even if you get a half-day leave, it will be output as one day. |
| (Vacation name) Obtained (days) |
The number of days of vacation acquisition is output. |
| (Vacation name) Number of remaining days | * Only the vacations for which "Calculation method for vacation (count)" set to "Subtract" at the time of new registration in Settings> Schedule> Leave type settings are displayed. The number of days left for vacation is output. |
| (Substitute time off Vacation name) remaining days (Weekdays) |
Outputs the number of work days when substitute time-off is granted on weekday. |
| (Substitute time off Vacation name) remaining days (Legal time-off) |
Outputs the number of work days when substitute time-off is granted on legal holidays. |
| (Substitute time off Vacation name) remaining days (Non-statutory holiday) |
Outputs the number of work days when substitute time-off is granted on non-statutory holidays. |
| (Substitute time off Vacation name) remaining days (Manual) |
The number of days manually granted is output. *The number of days automatically assigned by time-off work is not included. |
| (Vacation name) Grant days | The number of days of grant is output. (Automatic grant + manual grant) |
| (Vacation name) Grant days (Manual) |
The number of days of leaves manually granted is output. |
| (Vacation name) Obtained half-day vacation (count) | * Only the vacation that are set to "Half-day vacation: Apply" in Settings> Schedule> Leave type settings will be displayed. The number of half holiday acquisitions is output. |
| Transportation expenses estimate | * Displayed when using the Labor cost estimate output function. The transportation cost is output. |
| Monthly data (Custom item) |
You can also select the created monthly data custom item as a layout. |
★ Depending on the settings on the support center side, it may not be displayed. be careful.