What kind of value is output by daily data export?

◆Menu > Export/Import > "Create export file layout" next to " Daily data [CSV] "

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 managers 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).
Division group 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
group 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.
Name The employee's name is output as the full name (without reading).
Other employee management code 1 "Other employee management code 1" is output.
Other employee management code 2 "Other employee management code 2" is output.
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 > Displayed when "First name, middle name, first name" or "First name, middle name, last name" is selected in "Display format".
The middle name is displayed.
Gender Gender is output.
DOB The date of birth is output.
Hire 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
(employee)
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 relevant clock in division is output.
Clock-in division code The "division code" of the corresponding clock-in 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.
Date The date of work day is output in yyyy/mm/dd (day of week) format.
Date (no day of the week) The date of work day is output in yyyy/mm/dd format.
Closing status Whether work days are closed,
It is output with "Closed" or no notation.
Schedule pattern code When a pattern is registered in the schedule of the day,
The "pattern code" is output.
Pattern name When a pattern is registered in the schedule of the day,
The "pattern name" is output.
Work day type The work day type (weekdays, legal holidays, non-legal holidays) is output.
Time category code * Displayed when using the time slot category setting function.
When the time slot category is registered on that day,
The "time slot category code" is output.
Time category name * Displayed when using the time slot category setting function.
When the time slot category is registered on that day,
The "time slot category name" is output.
Leave type * How to take leave Displayed when using "Leave category".
When the leave category is registered on the corresponding day, the type and acquisition unit (all day / AM / PM) are output. If you take an hourly vacation, it will not be output, so check the output in "(Vacation name) acquisition time" below.
Half-day vacation type The semi-holiday type is output.
Note (schedule) The remarks column of the time card is output.
Clock-in schedule time The scheduled work time is output in the yyyy/mm/dd (day of the week) hh:mm format.
Clock-out schedule time The scheduled work time is output in the yyyy/mm/dd (day of the week) hh:mm format.
Clock-in schedule time
(Time only)
The scheduled work time is output in hh:mm format.
Clock-out schedule time
(Time only)
The scheduled work time is output in hh:mm format.
Work fixed start time The work start time is output in the yyyy/mm/dd (day of the week) hh:mm format.
Work fixed end time The work end time is output in the yyyy/mm/dd (day of the week) hh:mm format.
Work fixed start time
(Time only)
The work start time is output in the hh:mm format.
Work fixed end time
(Time only)
The work end time is output in the hh:mm format.
Clock-in time The clock-in time is output in yyyy/mm/dd (day of the week) hh:mm format.
Clock-out time The clock-out recorded is output in the yyyy/mm/dd (day of the week) hh:mm format.
Clock-in time (time only) The time recorded of clock-in is output in hh:mm format.
Clock-out time (time only) The time stamp for leaving work is output in the hh:mm format.
Clock-in time-record division  The division name (time recorded division) that performed the time recorded is output.
Clock-out time-record division  The name of the division (time recorded division) that performed the time recorded is output.
Clock-in time-record (time-record method) Starting with the time-record method (finger, HB, etc.),
The clock-in time is output in yyyy/mm/dd (day of the week) hh:mm format.
Clock-out time-record (time-record method) The time record is output in the format of yyyy/mm/dd (day of the week) hh:mm, starting with the time record method (finger, HB, etc.).
Clock-in time
(Time record method) (Time only)
The time record is output in hh:mm format, starting with the time record method (finger, HB, etc.).
Clock-out time
(Time record method) (Time only)
The time record is output in hh:mm format, starting with the time record method (finger, HB, etc.).
Clock-in time-record (round off) The clock-in time after rounding is output in the yyyy/mm/dd (day of the week) hh:mm format.
Clock-out time-record (round off) The clock-out time after rounding is output in the yyyy/mm/dd (day of the week) hh:mm format.
Clock-in time-record (round off) (time only)
The clock-in time after rounding is output in hh:mm format.
Clock-out time-record (round off) (time only)
The clock-out time after rounding is output in hh:mm format.
Break start stamp 1-8 The break start time is output in hh:mm format.
1st to 8th break start stamps can be output.
Break end stamp 1-8 The time when the break ends is output in the hh:mm format.
The 1st to 8th break end stamps can be output.
Start off-site time * Displayed when using the off site button function.
The time record for going out is output in the yyyy/mm/dd (day of the week) hh:mm format.
End off-site time * Displayed when using the off site button function.
The time record of the end of off-site visit is output in the yyyy/mm/dd (day of the week) hh:mm format.
Start off-site time
(Time only)
* Displayed when using the off site button function.
The time record for going out is output in hh:mm format.
End off-site time
(Time only)
* Displayed when using the off site button function.
The time stamp for going out is output in hh:mm format.
Start off-site time
(time-record method)
* Displayed when using the off site button function.
The time record start time is output in the format yyyy/mm/dd (day of the week) hh:mm, starting with the time record method (finger, HB, etc.).
End off-site time
(time-record method)
* Displayed when using the off site button function.
The time record end time is output in the format yyyy/mm/dd (day of the week) hh:mm, starting with the time record method (finger, HB, etc.).
Start off-site time
(Time record method) (Time only)
* Displayed when using the off site button function.
Starting from the time record method (finger, HB, etc.), the time record for starting going out is output in hh:mm format.
End off-site time
(Time record method) (Time only)
* Displayed when using the off site button function.
The imprinting end time is output in hh:mm format, starting with the embossing method (finger, HB, etc.).
Start off-site time-record division * Displayed when using the off site button function.
The name of the division (time record division) that performed the time record start off site is output.
End off-site time-record division * Displayed when using the off site button function.
The name of the department (time record division) that performed the time record is output.
Fixed (hrs) The specified time is output.
Extra hours (hrs) The non-scheduled time is output.
Overtime (hrs) Overtime hours are output.
★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.
★ Time off overtime hours The holiday overtime hours are output.
★ Fixed Late-night hours on holiday The specified time at midnight on holidays is output.
★ Extra Late-night Hours on Holiday The non-scheduled hours for midnight holidays are output.
★ Time-off late night overtime Holidays Overnight 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.
Schedule work The scheduled working time (schedule time) is output.
* Click here for details on schedule time
Plan/actual work (hrs) difference The difference between the scheduled work time (schedule time) and the work record is output.
* Click here for details on schedule time
Break schedule hours The "scheduled break time" registered in the schedule for that day is output.
Break (hrs) plan/actual difference "Scheduled break time" registered in the schedule of the day,
The difference in the break results is output.
Fixed hours
(Based on time-record)
The overtime limit, the work time limit, and the "Handling of working hours before clock-in/out" within the employee type  setting are not 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 categories 1-8
* Displayed when using the time slot category setting function.
The overtime hours within each time zone category are output.
Time category not classified * 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 Work day type: Each time of legal holiday is output.
Fixed non legal holiday  The specified time for non-legal holidays is output.
★ Extra hours legal holiday The time outside the legal holiday schedule is output.
★ Extra hour on non legal holiday Non-legal holidays Non-scheduled hours are output.
★ Legal time off overtime hours Legal holiday overtime hours are output.
★ Non-legal time off overtime hours Overtime hours on non-legal holidays are output.
★Fixed late night hours on legal holiday The specified time at late night non legal holidays is output.
★ Fixed late night hours on non legal holiday The specified time at late night on non-legal holidays is output.
★ Extra late night hours on non legal holiday
The non-scheduled time is output at late night on legal holidays.
★ Legal time off late night  overtime hours The legal holiday late night overtime hours are output.
★ Late night extra hours on non legal holiday Non-legal holidays late night non-scheduled hours are output.
★ Non-legal time off late night overtime hours Non-legal holidays late night overtime hours are output.
(Vacation name) Obtained hours Outputs the vacation acquisition time when the vacation is acquired in hours.
Discretionary vacation hours The vacation time for which the discretionary working hours are set is output (Click here for the setting of "working hours without vacation")。

In addition, the above-mentioned "fixed hours", "fixed hours at late night", "total working hours", etc. are the results of adding the working hours without vacation.
Comp. vacation hours for time off work * Settings > Schedule > Leave type settings > [Edit] of “Substitute leave” > Displayed when “Grant substitute time-off for substitute clock-in schedule"
Of the holiday working hours, the time that is the basis for the occurrence of substitute leave is output.
for example,
・ Half-day grant for holiday work of 4 hours 0 minutes or more
・ One day is granted for holiday work of 8 hours 0 minutes or more
If the specified holiday for the target day occurs for 9 hours and 30 minutes (of which 8 hours of the holiday work allowance allotment time), the holiday work allowance allotment time for this day will be 8 hours.
★ Overtime max limit * Displayed when using the overtime limit function.
The "overtime limit" registered on the relevant day is output.
Location information for clock in * Displayed when using My Recorder / Mobile Browser Stamping.
* Map display is not supported.
The location information (address) at the time of clock in stamp is output.
Location information for clock out  * Displayed when using My Recorder / Mobile Browser Stamping.
* Map display is not supported.
The location information (address) at the time of clock out work is output.
Location information for break start  * Displayed when using My Recorder / Mobile Browser Stamping.
* Map display is not supported.
The location information (address) at the time of the break start stamp is output.
Location information for break end * Displayed when using My Recorder / Mobile Browser Stamping.
* Map display is not supported.
The location information (address) at the time of the break end stamp is output.
Location information for offsite start * Displayed when using My Recorder / Mobile Browser Stamping.
* Map display is not supported.
The location information (address) at the time of the offsite start stamp is output.
Location information for offsite end  * Displayed when using My Recorder / Mobile Browser Stamping.
* Map display is not supported.
The location information (address) at the time of the offsite end stamp is output.
(Vacation name) Number of days granted The number of vacation days granted on that date is output.
Estimated transportation cost * Displayed when using the labor cost estimation ability function.
Transportation expenses are output.
Daily data custom items You can also select the created daily data custom item as a layout.
Count item * Displayed when using the count function.
Count data is output.
 
Custom stamped items * Displayed when using the custom stamping function.
〇〇 time, 〇〇 time (time only), 〇〇 stamping place, 〇〇 time (stamping type), 〇〇time (stamping type) (time only), 〇〇time (rounding), 〇〇time (Round) (Time only), 〇〇 Time position information can be selected.

★ May not be displayed depending on the settings on the support center side. 

Was this article helpful?
0 out of 0 found this helpful