JP3197915U - Time management sheet - Google Patents

Abstract

The present invention provides an attendance management sheet that can easily comprehend a total value by week or by day of the week, based on monthly totals of employee working days and hours. [Solution] An identification field 1 for describing an item for identifying an employee, and a plurality of deficiencies that do not satisfy a predetermined working day or working hour condition in the month can be listed for the employee. Condition deficiency display column 2, Numeric column 3 indicating the number of working days or working hours corresponding to the above deficiency items corresponding to the above deficiency items described above, and the working hours on each working day of the month And a breakdown column 4 that describes the breakdown of each working day by date and day of the week, and a breakdown column 4 that summarizes the working hours in a weekly unit. And the breakdown column 4 are listed in parallel or in series to constitute a unit unit, and the unit unit is described in a single form. [Selection] Figure 2

Description

  The present invention relates to an attendance management sheet that aggregates the number of working days and working hours per month for each employee and displays the working status of each employee.

  In recent years, the complexity of labor management operations has been accelerating, such as a decline in employee retention, frequent deaths from overwork, and diversification of work styles. When the number of employees is small, the managers and labor managers are in an environment where they can observe the actual working conditions of the employees one by one, so that timely and appropriate management is often possible. However, as the number of employees increases, it is virtually impossible for managers and labor managers to observe each employee's employment situation one by one, so management work depends more or less on the data on the timetable. Must be carried out. The attendance schedule is generally in the form of recording daily office hours and leaving times for each employee and totaling them every month. In the first place, the attendance table functions as basic data for payroll calculation. Therefore, the attendance table itself is not suitable for data to be checked in labor management. Therefore, conventionally, a device has been devised for processing timetable data to generate a time management sheet for labor management.

  For example, based on the working days and working hours of time data in a given period, points are given to data that exceeds a predetermined threshold from daily data and continuity analysis data that satisfies a given condition. There has been proposed a risk analysis apparatus that correlates and displays the total number of points assigned to the next unit data (see, for example, Patent Document 1 (FIG. 11)).

  According to the risk analysis apparatus, it is possible to generate a risk map from the working days and working hours of each employee on the attendance management sheet. In this risk map, the first quadrant is obtained by dividing the coordinate plane with the total number of daily unit data on the vertical axis and the total number of points assigned to the continuity analysis data and current state analysis data on the horizontal axis. Can be divided into the 4th quadrant, and the risk level is grouped in each quadrant, and the labor risk can be visualized by a table in which the total score of each employee is plotted on the coordinate plane. Is. In other words, overwork is analyzed from two viewpoints, the amount of time, the number of days and continuity, and visualized so that the burden on the employee can be intuitively grasped.

  Furthermore, the restrictions on the working days and working hours of employees determined by laws and regulations are specified as a function of working days and working hours within a predetermined period, and multiple areas defined by the specified functions are set. A system has been proposed that counts the number of people belonging to a region and sets a pattern of uneven distribution that serves as a reference for evaluation from the distribution ratio of the number of people belonging to each region or within a combination of a plurality of regions (for example, (See Patent Document 2 (FIG. 6))

  Since the system can display the uneven distribution of employees in a way that allows comparison of multiple workplaces, it is necessary to accurately understand the restrictions imposed by various laws and regulations, labor contracts, and other arrangements. With regard to working hours and working days, it is possible to carry out labor management by accurately and specifically grasping what kind of assignment is biased in which workplace.

JP 2009-146257 A International Publication No. 2011/070790

  All of the above prior arts are based on monthly analysis, but it is often necessary to grasp signs of changes in the working status of employees by week or by day of the week. For example, in restaurants and the like, various working forms are mixed in a single workplace such as regular employees, part-time workers, and so on. Here, store managers usually adjust labor costs at the end of the month, and as a result of intensive reassignment of employee assignments at the end of the month, Despite being busy, there are many inconveniences due to the labor costs that cannot be assigned enough employees. In such a situation, if the movement can be grasped by week or day of the week, efficient adjustment is possible.

  In addition, since the standard hours of legal working hours are often set on a weekly basis, the analysis centered on the conventional monthly unit is not enough to grasp the status of legal compliance. There was a fear.

  On the other hand, simply enumerating the tabulated values on a weekly basis would subdivide the data, and labor management and analysis based on data on working days and working hours may be complicated. Also, if you create separate weekly and day-by-day reports, it will be easier to grasp each item, but multiple forms will be created for each employee, so that you can grasp the working situation from various perspectives. On the other hand, there is a risk that the work becomes complicated.

  The present invention has been made in view of the above-mentioned problems, and the total number of working days and working hours of each employee is based on monthly counting, but weekly counting and working status by day of the week can be easily grasped. The purpose is to provide a time management sheet that can be used.

  The attendance management sheet according to the present invention lists at least an identification field for identifying an item for identifying an employee, and a plurality of unsatisfactory conditions for the employee that do not satisfy the conditions for a predetermined number of working days or working hours within the month. Incompletion indication column that can be performed, a numerical value column that describes the number of working days or working hours corresponding to the above inadequacies corresponding to the inadequacies described above, and each working day of the month Breakdown of working hours is described by date and day of the week, and has a breakdown column that describes the time of counting the working hours in units of weeks, and for each identification column, the condition deficiency display column and the numerical value column, The breakdown fields are listed in parallel or in series to form unit units, and the unit units are described in a single form.

According to this configuration, it is possible to identify the occurrence condition of the condition deficiency item in the same form on a weekly basis and on the day of the week basis while grasping the condition deficiency items generated as a result of aggregation in monthly units.

More specifically, the breakdown column consists of a matrix-like table in which either the row or the column is a day of the week column and the other is a weekly column, and each cell where the row and the column intersect each day The working hours may be described, and the total value description column for each weekly working time may be provided in each end direction of the weekly column.

In addition, the cells that correlate with the condition deficiencies and the aggregation results may be displayed (for example, colored) that can be distinguished from other cells. That is, if the cell that caused the condition and the cell that caused the condition are identified can be identified by one or more cells, the cell that caused the condition may be displayed so that it can be distinguished from other cells. The correspondence relationship between the deficiency condition and the cell may be visually clarified by applying the same display as that of the cell that can be distinguished from the other cells to the deficiency condition to which the cell corresponds. For example, the cell to be displayed for distinction is a cell corresponding to the starting date when the number of consecutive working days exceeds a predetermined number of days, and the time from the departure time to the next sunrise working time. Is a cell corresponding to the next working day of the next sunrise when the number of times less than or equal to the predetermined time is greater than or equal to the predetermined number of days in the month, or one or more conditions displayed in the incomplete condition display column What is necessary is just a deficiency matter that can be determined by the single cell in the breakdown column that corresponds to the deficiency condition.

Further, the breakdown column may be provided with a week number column in the head direction of the week column, and the week number may be described based on the week in which the aggregation of the month is performed. Adjacent to the summary value entry column, a check column may be provided to indicate whether or not the weekly working hours conditions stipulated by laws, rules and other arrangements concerning employees are met.

  The attendance management sheet according to the present invention can display the working hours and working days of each employee by day, week, month, and day of the week on a single form, and within a given month. Because it is possible to display the deficiencies that do not satisfy the conditions of working days or working hours in a format that can be compared, you can view the information necessary for labor management, and it is difficult to grasp the working situation with multiple forms Also has the effect of being able to grasp immediately.

FIG. 1 shows a basic configuration of a form according to the present invention. (A) is arranged in parallel in the horizontal direction, (b) is configured so that the identification column covers the entire horizontal direction, and (c) is arranged in series in the vertical direction. is there. FIG. 2 shows a specific description example of a form according to the present invention. FIG. 3 shows an example in which a week number column is provided in the head direction of the week column, and the week number is described with reference to the week in which the aggregation of the month is executed. FIG. 4 is a diagram in which newly added condition deficiencies and the cells corresponding thereto are displayed in the same manner. FIG. 5 is a diagram showing an example in which a check column for displaying whether or not a weekly working hour condition defined by laws, rules and other arrangements concerning employees is satisfied is provided.

  FIG. 1 shows a variation of the layout configuration of the attendance management sheet according to the present invention. FIG. 1 shows three layout configuration examples from (a) to (c), but these configurations are not intended to exclude other configurations without departing from the scope of the utility model registration request. It is not limited to.

Each of (a) to (c) constitutes a record that records the working status for one month per employee. In the present invention, this is called a unit. The unit is configured so as to be able to instantly grasp what kind of problems the working information (working days and working hours) and the numerical working information in the month have in labor management.

The unit U1 in FIG. 1A is a unit in which items to be compared are arranged in parallel in the horizontal direction. Reference numeral 1 denotes an identification column for identifying an employee, and is a column in which the employee's name and employee code are written. In the front view of the drawing (hereinafter, the positional relationship in each column is based on the front view of the drawing), to the right of the identification column 1 is a condition that does not meet the prescribed working days or working hours within the month. A condition deficiency display column 2 in which a plurality of deficiencies can be listed is arranged. Inadequate conditions include legal working days and working hours as well as working days and working hours determined by the agreement between labor and management. Further, it may be a unique threshold value that a manager or labor manager recognizes as necessary for labor management. Next to the right side of the condition deficiency display column 2, there is provided a numerical value column 3 for describing the value of the working days or working hours corresponding to the condition deficiency items in correspondence with the above-mentioned condition deficiency items. Therefore, in the numerical value column 3, the total number of working days or working hours corresponding to the condition deficiencies in the month is described. On the right side of the numerical value column 3, there is provided a breakdown column 4 for displaying the labor status within the month in terms of working hours per day. In the breakdown column 4, in addition to the working hours per day, as described later, the total of weekly working hours is described, and it is possible to grasp the working situation by day of the week.

With the configuration described above, managers and labor managers can instantly analyze the actual employment situation that is a problem for individual workers as data that can be analyzed by date, day of the week, and week of the month. I can grasp it. The conventional attendance table only contains data that records the employee's name and daily time of attendance, and in order to grasp the working situation in question, a separate analysis form is required. Had to create. In addition, conventional analysis forms are based on monthly aggregation, and up to a detailed analysis of which point, day, day of the week, and week is the cause of the problem. However, there was almost nothing that was clearly recorded, and even if such an analysis was performed, there was only a level where problems could only be grasped across multiple forms. In the present invention, while displaying the simple structure as described above, the actual employment situation that is a problem in units of months is displayed, and analysis data in units more detailed than the units of months necessary for the cause analysis is displayed. It was devised to fit in the form. In addition to simply storing a plurality of data in a single form, it has a configuration devised so that problems can be pointed out and data having a causal relationship with the problems can be instantly grasped.

FIG. 1B shows a configuration in which the respective columns are arranged in the horizontal direction in the same manner as in FIG. 1A, but the identification column 1 is provided at the top, and the condition incomplete display column 2, the numerical value column 3, and the breakdown column 4 It is intended to take over the whole. FIG. 1C shows an identification column 1, an inadequate condition display column 2, a numerical value column 3, and a breakdown column 4 arranged in series in the vertical direction.

Hereinafter, specific embodiments will be described with reference to FIGS. 2 to 5. In the following embodiments, description will be made using the configuration of FIG.

  In the present embodiment, it is shown that the totaled month is one month from November 1, 2011 to November 30, 2011. In this embodiment, the monthly units to be counted are combined with the calendar. However, for labor management of each company, the count of one month is started not on the calendar but on a specific day (for example, the 15th of every month is the month). The date of the date of In addition, the calculation of the week to be described later is not specified on Sunday according to the calendar, and may be started from Monday, for example. The same applies to each embodiment below. That is, the weekly and monthly units in the present invention include not only those according to the calendar but also those based on the starting date determined by the designation of the person using the form according to the present invention.

The name is written in the identification column 1 and the condition deficiencies listed in the condition deficiency display column 2 are “working days exceeding 24 days” “total working hours exceeding 200 hours” “maximum number of consecutive working days” The four items are “the number of days exceeds 6 days” and “the free time until the next working day is 8 hours or less is 3 days or more”. Both thresholds are for monthly aggregation. In the present embodiment, the aggregated monthly data (numerical values) change the color of characters, change the typeface, or exceed the threshold for items that exceed and do not exceed the threshold for each condition deficiency. Items that do not exist are not shown and are displayed so that they can be distinguished. In addition, all of the condition deficiencies exemplified in the present embodiment are based on exceeding the threshold, but conversely, may be items below the threshold. For example, when the number of working days is less than a certain number of days, it may be displayed as inadequate conditions as described above.

  The numerical value column 3 describes the total value within each month so as to correspond to each condition deficiency displayed in the condition deficiency display column 2. In the numerical value column 3, the description method may be changed depending on whether the value exceeds the threshold value or not, in the same manner as the condition deficiency display column 2.

  The breakdown column 4 employs a matrix-like table format in which the row direction is a weekly column 41 and the column direction is a day-of-week column 42. In the present invention, a cell where each matrix intersects is defined as a cell 43. Each cell 43 is a column in which the working hours per day are described. In the weekly column 41, “1W” which means the first week from the upper left side is described, and “2W”, “3W”... “6W” are sequentially described downward. On the other hand, in the day-of-week column 42, the month (“November” in the present embodiment) is described in the leftmost cell 43, and thereafter, each day of the week from Sunday to Saturday is sequentially described in the right direction. On the right side of the Saturday column, that is, at the end in the column direction, a week total column 44 that describes the total value of each week is provided. With the configuration as described above, the breakdown column 4 indicates how the numerical values described in the numerical value column 3 are broken down. In addition, the breakdown of the numerical values described in the numerical value column 3 is not simply listed, but the minimum unit of the breakdown, that is, which day of the week of which working hour per day can be read instantaneously. .

  Furthermore, in this embodiment, when any of the condition deficiencies is met, the cell in the breakdown column 4 constituting the numerical value of the condition deficiency is displayed to be distinguished from other cells. For example, if the maximum number of consecutive working days exceeds 6 days among the inadequate conditions, the cell 45 frame of the day corresponding to the starting day of the corresponding consecutive day in the breakdown column 4 is indicated by a bold line. displayed.

  In addition, among the inadequacies, “the free time of 8 hours or less until the next working day is 3 days or more” means that the number of times from the leaving time to the working time of the next sunrise is 8 hours or less within the month. In this case, the cell 46 corresponding to the next sunrise working day was colored.

  As described above, in this embodiment, by making it possible to distinguish cells that are causally related to the condition defect display column 2 and the numerical value column 3 from other cells, it is possible to determine where the problem is in terms of labor management. The bird's-eye view and the data specifying the detailed cause can be viewed at the same time. Some of the deficiencies are not based on which cell in the breakdown column 4 is the cause, such as “(working days per month exceeds 24 days)”, but there are cases where judgment is based on the figures for the entire month. Except for such matters, if the cause of the condition deficiency can be identified by one or more cells, the cause can be easily identified by displaying it so that it can be distinguished from other cells.

  In the present embodiment, two units U1 are displayed in succession, and records for two persons are displayed. However, when a plurality of units U1 are described in a single form in this way, the uppermost unit U1 is displayed. In the item column (“name”, “condition deficiency”, “numerical value”, “November”, “Sun-Sat”, “weekly total”), only the top unit U1 is described, and the above-mentioned highest unit U1 of the second and subsequent units U1 The upper item column may be omitted.

Hereinafter, in Example 2 and subsequent items, items common to Example 1 are denoted by common numbers, and detailed description thereof is omitted. In the second embodiment, the week of the current month is displayed as “this week” in the weekly column 47, and “1 week ago”, “2 weeks ago”, “3 weeks ago” “4 weeks ago”. Such description facilitates analysis based on the current time.

  In the third embodiment, the same display is used so that the correlation between the incomplete condition and the cell can be intuitively understood. In other words, a condition deficiency item “working day after the last train time” is newly added, and this deficiency item and the cell 49 that caused the condition are colored in the same color. Thus, by coloring with the same color, the correspondence between the two can be instantly specified.

  In Example 4, the legal check column 5 is provided at the left end of the unit U1. In general, the working days and working hours of employees within a certain period are limited by laws and regulations. Therefore, this legal check column 5 is provided to determine whether or not the time is observed. For example, the employment insurance subscription is compulsory when the conditions of “employment period is 30 days or more, weekly working time is 20 hours or more, and under 65 years old” are satisfied. In the case of social insurance, those who work for corporations are not required to work for statutory working hours, but are required to join when working for more than 30 hours per week according to the guidance document. Regarding premium wages, according to Article 30 of the Labor Standards Law, “an employer shall not let a worker work for more than 40 hours per week, excluding breaks.” If you want to work beyond the limit, overtime hours will be set by the so-called 36 Agreement, and in this case, you will be subject to a premium wage. Furthermore, it is obliged to give at least one day every week, or four or more statutory holidays every four weeks (Article 35 of the Labor Standards Act).

  As mentioned above, the working days and working hours conforming to the statutory or equivalent standards have been prepared so that checks can be made on a monthly or daily basis in the conventional form. There was no one that could be checked weekly on a form.

In the fourth embodiment, the legal check column 5 is composed of an employment insurance column 51, a social insurance column 52, a non-prescribed (overtime) column 53, a 36 agreement column 54, and a legal holiday column 55 in the column direction, and the row direction is a breakdown column. A matrix-like table is configured corresponding to the weekly column 4 of 4. In each week, the result is displayed in each item of the legal check column 5. Specifically, for example, since the weekly total four weeks ago is 62.2 hours, black circles are written in the employment insurance column 51, social insurance 52, non-prescribed 53 and 36 agreements.

Although the attendance management sheet according to the present invention may be created by handwriting, the attendance management of employees is currently converted into electronic data for each employee by time card in many cases. ing. Therefore, the attendance management sheet according to the present invention may be automatically generated using a computer based on the electronic data.

As mentioned above, if you use the attendance management sheet according to the present invention, you can see at a glance whether the day-by-day trend or weekly tendency, for example, whether the week starts long hours or chronically long hours. It will be understood by.

In addition, it can be seen whether there is a trend in weekly units, that is, whether there are many working hours in the first week of the month or, in general, working hours every week.

Furthermore, it is easy to understand the meaning and meaning of continuous work while visually checking the meaning of the date, that is, whether it is the beginning of the month or the day of the week. For example, you can see the trend of whether continuous work is concentrated at the beginning of the month or at the end of the month. If the day of continuous work is at the end of the month and you work for a certain number of consecutive days across the month, the number of consecutive days from the previous month will be indicated by the prescribed mark or remarks column on the month to which the last day of continuous work belongs. Please state that it is.

In other words, the attendance management sheet according to the present invention concentrates information necessary for labor management on a single form, so that it is difficult to notice in tasks such as comparing simple attendance tables and multiple forms, for example, Depending on the length of continuity of work, it is possible to easily confirm matters that can grasp the actual situation of working conditions.

1 Identification field 2 Condition defect description field 3 Numerical value field 4 Breakdown field 5 Legal check field 1

Claims (7)

A time management sheet that aggregates the number of working days and working hours per month for each employee and displays the working status of each employee.
At least an identification field that describes an item that identifies the employee, and a condition deficiency indication that can list a plurality of condition deficiencies that do not meet the prescribed working days or working hours within the month for the employee Column, a numerical column that describes the number of working days or working hours corresponding to the above-mentioned deficiencies, and the breakdown of working hours on each work day of the month by date and It is described by day of the week, and has a breakdown column in which the working hours are tabulated in units of weeks. For each identification column, the condition deficiency display column, the numerical value column, and the breakdown column correspond to each other. An attendance management sheet characterized in that unit units are listed in parallel or in series, and the unit units are described in a single form.   The breakdown column consists of a matrix-like table in which either the row or the column is the day of the week column and the other is the weekly column, and each cell where the row and the column intersect each day is described in working hours. 2. The attendance management sheet according to claim 1, wherein a column for describing a total value of working hours for each week is provided in each end direction of the weekly column.   When the cell causing the condition and the cause cell corresponding to the condition defect can be specified by one or more cells, the cause cell is displayed so as to be distinguished from other cells. 2. The attendance management sheet described in 2.   4. The attendance management sheet according to claim 3, wherein the same display as that of the cell that can be distinguished from the other cells is applied to the inadequate condition for the cell.   The week number column is provided in the head direction of the weekly column, and the week number is described with reference to the week in which the aggregation of the month is executed. The attendance management sheet described in 1.   One or more condition deficiencies displayed in the condition deficiency display column, which can be determined by a single cell in the breakdown column as being applicable to the condition deficiency items, are described in the condition deficiency display column 6. The display according to any one of claims 2 to 5, wherein a common display is used to indicate a correspondence relationship between a specified defect and a cell in a breakdown column corresponding to the defect. The attendance management sheet described in 1. Adjacent to the above-mentioned total value column for working hours for each week, a check column is displayed to indicate whether or not the weekly working hours defined by laws, rules, and other agreements regarding employees are met. The attendance management sheet according to any one of claims 2 to 6, wherein the attendance management sheet is provided.

Images