JP2021128486A - Crew working hours calculation system - Google Patents

Abstract

To automatically manage a breakdown of working hours in a crew working hours calculation system.SOLUTION: A work record totalization unit of a server totalizes work hours by day with reference to a planned crew route table, a train running record table, a daily work plan table and a roll call record table.SELECTED DRAWING: Figure 1

Description

The present invention relates to a crew working hour calculation system.

In a general crew work management system, a performance schedule is received and the working hours for each route are calculated from the route information. At the time of calculation, crew time (time when the driver and conductor work on the train), travel time (time when the train is boarded for movement but the driver and conductor do not work), preparation Report time (time to prepare and report at the transport station at the start and end of work), turnaround time (time to be handed over to the crew on the next train after the train is on board, or before the train is on board, to be handed over from the crew on the previous train Time) is divided and the time is counted. The above items are examples (basic time items), and it is expected that calculation items will be added or changed for each railway operator.

Patent Document 1 is a program for calculating the working hours of a vehicle driver from vehicle operation data. The characteristics of the driver's working hours management are the rest period (the free time for the worker between work and the next work, which requires 8 hours or more continuously), and the driving time (9 hours a day on average for 2 days). There are items to be observed, such as the following items), break time (continuous operation time is fixed to 4 hours, and a continuous break of 10 minutes or more is required before the next operation). Automatically calculated from operation data.

Patent Document 2 calculates the final work forecast time of a crew member from the scheduled work time at the time of planning the timetable, the actual timetable (actual timetable), and the delay prediction when the train timetable is disturbed, and sets it as the sleep time or the next day's work time. It is a program that determines whether there is any effect. The timetable at the time of planning is incorporated into the work planning system, the scheduled working time is calculated, the train delay is predicted when the timetable is disturbed, the estimated train arrival time is calculated, and the final from the scheduled working time and the estimated arrival time including delay. Calculate the estimated working hours.

JP-A-2019-67428 JP-A-2010-264914

In a general crew work management system, changes in working hours due to train delays can be automatically captured, but if working hours are changed from the plan outside the train crew, it is necessary to manually enter the working hours. This work takes a lot of time.

In Patent Document 1, since a crew member transfers a plurality of vehicles (organizations) in one work, it is not possible to grasp the working hours of the crew member only from the information on the vehicle side.

In Patent Document 2, since the time required for other than train crew is also included in the working hours, the final working time (actual result) cannot be calculated. Since the breakdown of working hours is not managed, it is not possible to recalculate allowances based on crew hours.

An object of the present invention is to automatically manage the breakdown of working hours in a crew working time calculation system.

The crew working time calculation system of one aspect of the present invention is a working time calculation system having a server that collects and manages information that is a source for calculating working hours, and a terminal that displays and corrects working hours. Therefore, the server has a work record totaling unit that totals working hours, and the server has a train schedule related to train operation, an operation planning system that plans vehicle operation and crew operation, and daily train operation. A course control system to control, a work planning system that allocates crew members according to the crew operation, and a roll call system that manages the schedule and results of roll calls made when the crew members go to work, before the crew, after the crew, and when they leave the office. Connected via a network, the operation planning system holds a planned crew route table that manages the crew route, which is a combination of trains that the crew is on board from work to departure, and the course control system is actually a train. The work planning system holds a daily work planning table that links the crew route and the crew, and the roll call system holds the train running record table that manages the departure time and the arrival time when the train travels to. A roll call record table that manages the actual roll call time of the route is held, and the work record totaling unit of the server holds the planned crew route table, the train travel record table, the daily work plan table, and the roll call record table. It is characterized in that the working hours are totaled by day with reference to.

According to one aspect of the present invention, the breakdown of working hours can be automatically managed in the crew working hours calculation system.

It is a figure which shows the whole structure of the system including the working hours calculation system which concerns on Example. It is a figure which shows the internal structure of the apparatus which comprises the working hours calculation system 1. It is a figure which shows an example of the planned crew route table 31 held by the operation planning system 3. It is a figure which shows an example of the train running record table 41 held by the course control system 4. It is a figure which shows an example of the daily work plan table 51 held by the work plan system 5. It is a figure which shows an example of the roll call record table 61 of the A ward office held by the roll call system 6. It is a figure which shows an example of the roll call record table 61 of the B ward place held by the roll call system 6. It is a flowchart which shows the whole processing of the working hours totaling program 1151. It is a flowchart which shows the detail of the performance crew route information creation processing. It is a figure which shows an example of the performance crew route table. It is a flowchart which shows the detail of the working hours calculation processing. It is a figure which shows an example of the daily work performance table. It is a figure which shows the screen example of the work record correction screen program 1261. It is a flowchart which shows the detail of the work record correction screen program 1261.

Hereinafter, examples will be described with reference to FIG.

FIG. 1 is a diagram showing an overall configuration of a system including a working hour calculation system according to an embodiment.
The working hours calculation system 1 is a working hours calculation system server 11 (hereinafter referred to as a server 11) that collects and manages information that is a basis for calculating working hours, and a working hours calculation system terminal that displays and corrects working hours. 12 (hereinafter referred to as a terminal 12) is a system connected by a network 13. Server 11, train schedule related to train operation, operation planning system 3 for planning vehicle operation, crew operation, etc., course control system 4 for controlling daily train operation, work plan for allocating crew members according to crew operation The system 5 and the roll call system 6 that manages the schedule and results of roll calls made when the crew members go to work, before the crew, after the crew, and when leaving the office at the crew ward are connected via the network 2, respectively. The roll call system exists for each crew ward (A ward, B ward, C ward).

The operation planning system 3 holds the planned crew route table 31. The combination of trains that a crew member takes from work to work is called a crew route, and the planned crew route table is a table that manages the crew route.

The course control system 4 holds the train running record table 41. The train running record table 41 is a table that manages the departure time and the arrival time when the train actually runs.

The work planning system 5 holds the daily work planning table 51. The daily work plan table 51 is a table that links the crew route and the crew.

The roll call system 6 holds the roll call record table 61. The roll call record table 61 is a table that manages the record of the roll call time of the crew route, and is held by the roll call system of each ward (A ward, B ward, C ward) for each ward.

FIG. 2 is a diagram showing an internal configuration of equipment constituting the working time calculation system 1.
The server 11 and the terminal 12 have CPUs (Central Processing Units) 113 and 121, main storage devices 114 and 122, external interfaces 111, 112 and 123, and auxiliary storage such as HDD (Hard Disk Drive) and SSD (Solid State Drive), respectively. It has devices 115 and 126.

Further, the terminal 12 has a display device 124 for displaying various information and an input device 125 for receiving input of various information. The display device 124 is a general display device such as an LCD (Liquid Crystal Display), and the input device 125 is a general input device such as a keyboard or a mouse.

The auxiliary storage device 115 of the server 11 has a working time totaling program 1151 and a performance correction processing program 1152. Further, the auxiliary storage device 126 of the terminal 12 has a work record correction screen program 1261.

In the following description, a route is a process in which a crew member goes to work from the time he / she leaves the office to the time he / she leaves the office. There are many trains that are not in the same formation, with multiple trains on board in one route. In addition, even if the route number is the same, the crew members in charge may be different. The route spans one or two days. In addition, late-night and early-morning trains are handled by overnight crew members (two days).

A roll call means that the person in charge (assistant) checks and sends alcohol to the crew, sets the clock time, and confirms belongings, etc., at the timing of going to work, starting the train crew, ending the crew, and leaving the office. To tell. Moving means getting on a train to move between stations. When moving, the driver and conductor do not work. The implementation crew route refers to the data that defines the crew route at the time of planning. This data will also be updated if the crew route is changed due to train delays. The actual train timetable is the actual value of the timetable (departure / arrival time) after the train runs. The roll call record refers to data that records the actual time when the crew members of each route made a roll call. Daily route allocation refers to data that defines the route and crew allocation for each day.

FIG. 3 is an example of the planned crew route table 31 held by the operation planning system 3.
The planned crew route table 31 has, as data items, a "route crew start date" indicating the date when the crew starts to board the route, a "route number" that uniquely identifies the route, and a "detail number" that uniquely identifies the detailed information in the route. , Each information of "route detailed information" indicating detailed information of the trains on board in the route is stored.

As data items in the route detail information, "driving date" indicating the operating date of the train to be on board, "train number" uniquely identifying the train to be on board, "boarding station" indicating the station to start boarding the train, and crew "Boarding station departure time" indicating the time when the train departs from the starting station, "pre-crew roll call location" indicating the place where the crew makes a roll call before boarding this train, roll call before the crew boarded this train "Pre-crew roll call time" indicating the time to perform the train, "Getting off station" indicating the station where the train will end, "Getting off station arrival time" indicating the time when the train arrives at the station where the train will end, and the crew will be on this train. "Post-crew roll call location" indicating the place where the post-crew roll call is made, "Post-crew roll call time" indicating the time when the crew makes a post-crew roll call on this train, and "Career" indicating the work performed by the crew on this train. Each information of "contents" is stored one or more items per line.

FIG. 4 is an example of the train running record table 41 held by the course control system 4.
The train running record table 41 stores, as data items, a "driving date" indicating the date on which the train ran, a "train number" that uniquely identifies the train, and "stop station information" that stores the stop stations of the train in order from the first station. Each information of "" is stored.

As data items in the stop station information, "station name" that uniquely identifies the stop station, "actual arrival time" that shows the actual value of the time of arrival at the stop station, and "actual value of the time of departure from the stop station" Each information of "actual departure time" is stored in multiple cases per train. Since the "actual arrival time" at the first train station and the "actual departure time" at the last station of the train do not exist, they are not stored.

FIG. 5 is an example of the daily work plan table 51 held by the work plan system 5.
The daily work plan table 51 includes, as data items, a "crew number in charge" that uniquely identifies the crew member in charge of the date and the route number of the route crew start date, and a "work content" indicating the work content of the crew member on that date. "Attendance place" indicating the place where the crew starts and ends work, "Route crew start date" indicating the date when the crew starts to board the route, "Route number" that uniquely identifies the route, Departure time of the first train of the route The "scheduled work date and time" minus the time required for preparation after work (preparation report time), and the "scheduled leave date and time" obtained by adding the time required for reporting until leaving work (preparation report time) from the arrival time of the last train on the route. ”Each information is stored.

6 and 7 are examples of the roll call record table 61 held by the roll call system 6. Here, FIG. 6 is a roll call record table 61 of the A ward office, and FIG. 7 is a roll call record table 61 of the B ward office.

In the roll call record table 61, as data items, a "roll call date" indicating the date on which the roll call is scheduled to be performed, a "roll call scheduled time" indicating the time on which the roll call is scheduled to be performed, and a "route crew" indicating the flight start date of the route to be rolled are displayed. Roll call 1 contains information such as "start date", "route number" that uniquely identifies the route to be rolled, "roll call type" that indicates the type of roll call, and "roll call actual time" that indicates the time when the roll call was actually made. It is stored for each case.

FIG. 8 is a flowchart showing the overall processing of the working hours totaling program 1151.
In the working time totaling program (working time totaling unit) 1151, first, as step S1, the user inputs and selects the working time calculation target date.

Next, in step S2, the working hours totaling unit 1151 uses the working hours calculation target date acquired in step S1 as a key, and the planned crew route table 31 held by the operation planning system 3 and the daily working hours held by the working planning system 5 are used as keys. The work plan table 51 and the route crew start date of the roll call record table 61 held by the roll call system 6 of each crew member ward are searched, and matching records are acquired.

For example, when the working hour calculation target date is 20191001, the record whose route crew start date is 20191001 in the planned crew route table 31 (see FIG. 3) is extracted. When the working hour calculation target date is 20191001, the record whose route crew start date is 20191001 in the daily working plan table 51 (see FIG. 5) is extracted. When the working hour calculation target date is 20191001, the records whose route crew start date is 20191001 in the roll call record table 61 (see FIGS. 6 and 7) of each ward are extracted.

Further, in step S3, the working time totaling unit 1151 uses the working time calculation target date and (working time calculation target date + 1 day) acquired in step S1 as keys to obtain the train running record table 41 held by the course control system 4. Search for driving dates and get matching records.

For example, when the working time calculation target date is 20191001, the records in which the operating days of the train running record table 41 (see FIG. 4) are 20191001 and 20191002 are extracted. Since some of the routes are on board for two days, the train operation record of 20191002 is also required.

In step S4, the working time totaling unit 1151 obtains the actual crew route information based on the planned crew route table 31, the train travel record table 41, and the roll call record table 61 acquired in step S2 (see FIG. 10). Create as.

In step S5, the daily work plan table 51 (see FIG. 5) held by the work plan system 5 is copied.

In step S6, it is determined whether or not there is a crew number whose working hours have not been calculated. As a result of the determination, if there is a crew number whose working hours have not been calculated, in step S7, the working hours totaling unit 1151 copies the daily work plan table 51 in step S5, and the actual crew route information created in step S4 (FIG. 10). The working hours are calculated based on the actual crew route table).

Further, in step S8, the working time totaling unit 1151 creates a daily working record (daily working record table in FIG. 12) based on the working time calculated in step S7.

After that, the process returns to step S6, and if there is a crew number for which working hours have not been calculated, steps S7 and S8 are repeated.

Next, with reference to FIG. 9, the actual crew route information creation process (S4 in FIG. 8) will be described. Here, FIG. 9 is a flowchart showing the details of the actual crew route information creation process.
First, in step S101, the actual crew route information creation process performs the route crew start date, route number, detailed number, operation date, and train number for all the records of the planned crew route table 31 (see FIG. 3) passed to the process. , Boarding station, pre-crew roll call location, pre-crew roll call time, disembarkation station, post-crew roll call location, post-crew roll call time, and crew details are copied to the actual crew route table (see FIG. 10). Here, the actual departure time and actual arrival time columns of the actual crew route table are left blank.

In step S102, it is determined whether or not there is a route / detail for which the actual result has not been imported.
In step S102, when there is a record of the actual crew route table that has not been imported, in step S103, the actual crew route information creation process is performed on the operation date, train number, and boarding in the record of the actual crew route table (FIG. 10). The actual departure time and the actual arrival time are acquired by referring to the train running record table 41 (see FIG. 4) using the station / getting-off station as a key. The actual departure time and the actual arrival time acquired in this way are stored in the items of the actual departure time and the actual arrival time of the actual crew route table (see FIG. 10), respectively. As described above, in step S103, the train running record table 41 is referred to by using the boarding station and the getting-off station as keys, and the actual departure time and the actual arrival time in the matching records of the train running record table 41 (see FIG. 4) are set. Obtain it and set it in the item of the actual crew route table (see FIG. 10).

Further, in step S104, the actual crew route information creation process is set to "A ward office" in either the pre-crew roll call location or the post-crew roll call location in the records of the actual crew route table (see FIG. 10). For the record, the roll call actual time is acquired by referring to the roll call record table 61 (see FIG. 6) of the A ward office using the route crew start date, the route number, and the roll call time before the crew as keys. The roll call actual time acquired in this way is stored in the items of the roll call time before the crew and the roll call time after the crew in the actual crew route table (see FIG. 10), respectively. The same process applies to B and C wards. As described above, in step S104, the roll call actual time in the matching record of the A ward roll call record table 61 (see FIG. 6) is acquired and set in the item of the actual crew route table (see FIG. 10). The process of step S104 is executed for the number of wards in the roll call record table.

In addition, when the minimum required time from the end of the flight to the roll call time after the flight (hereinafter referred to as the standard time after the flight) is set, the actual crew route table (Fig.) In the roll call record correction process in step S105. If the difference between the actual arrival time and the post-flight roll call time is less than the standard post-flight time, set the value obtained by adding the actual arrival time and the standard post-flight time to the post-flight roll call time. May be good.

After that, the process returns to step S102, and if there is a route / detail record for which the actual result has not been imported, steps S103, S104, and S105 are repeated.

FIG. 10 is an example of a performance crew route table.
The actual crew route table has data items such as "route crew start date" that indicates the date when the crew starts to board the route, "route number" that uniquely identifies the route, and "detail number" that uniquely identifies the detailed information in the route. , Each information of "route detailed information" which shows the detailed information of the train which was on board in the route is stored.

Data items in the route details information include "driving date" indicating the operating date of the train on board, "train number" that uniquely identifies the train on board, "boarding station" indicating the station where the train started to be on board, and crew. "Actual departure time" indicating the actual time when the train departed from the starting station, "Pre-crew roll call location" indicating the place where the crew made a roll call before boarding this train, before the crew boarded this train "Pre-crew roll call time" that shows the actual time when the roll call was made, "Getting off station" that shows the station where the train has finished boarding, "Actual arrival time" that shows the actual time when the train arrived at the station where the train has finished, "Post-crew roll call location" indicating the location where the post-crew roll call was made on this train, "Post-crew roll call time" indicating the actual time when the crew made a post-crew roll call on this train, and the crew boarded this train. Each information of "crew content" indicating the business content is stored one or more items per line.

Next, the working hours calculation process (S6 in FIG. 8) will be described with reference to FIG. Here, FIG. 11 is a flowchart showing the details of the working hour calculation process.
First, in S201, the flight time is calculated.
Of the records corresponding to the route numbers to be calculated in the actual results, those whose crew content is other than "movement" are added to the crew hours on the driving day.

When the train operation time spans days (when the arrival time is earlier than the departure time), the flight time on the operation day: the time from the departure time to 24:00 and the operation time on the operation day + 1: 24:00 ~ Add the time to arrival time to the flight time on each driving day.

Next, in S202, the travel time is calculated.
Among the records corresponding to the route number of the actual calculation target, the record whose crew content is "movement" is added to the travel time on the driving day. The way of thinking when the train operation time spans days is the same as the flight time.

Next, in S203, the commuting preparation / leaving report time (preparation report time) is calculated.
Specifically, among the records corresponding to the track numbers to be calculated, the actual crew route table is used from the attendance roll call actual time of the daily work record table (see FIG. 12) by using the information in the record of detail number 1. Calculate the time until the train departure time (see FIG. 10).

Among the records corresponding to the route numbers to be calculated, the daily work record table (see FIG. 12) from the train arrival time of the actual crew route table (see FIG. 10) using the information in the record at the end of the detail number. Calculate the time until the actual time of leaving roll call.

Next, in S204, the turnaround time between crews (turnback time) is calculated.
Specifically, among the records corresponding to the route numbers to be calculated in the actual results, the detail numbers are used from the train arrival time of the record with the detail number N by using the information in the record whose detail number is N (N = 1 to the end). Calculate the time until the roll call time after the flight of N records (except when N = the end). Calculate the time from the roll call time before the flight of the record of detail number N to the departure time of the record train of detail number N (except when N = 1). If the post-crew roll call location for item number N is "direct transfer" and the pre-crew roll call location for the record with item number N + 1 is "direct transfer", the record with item number N + 1 from the train arrival time of the record with item number N Calculate the time until the train departure time of (except when N = the end).

Next, in S205, the midnight working hours are calculated.
Specifically, among the records corresponding to the actual calculation target route number, if the following cases (1) to (3) are applicable, the records are added to the midnight working hours.

(1) If the pre-crew roll call time is before 22:00 and the post-crew roll call time exceeds 22:00, the time from 22:00 to the post-crew roll call time (2) The pre-crew roll call time is before 5:00 If the train arrival time exceeds 5:00, the time from the pre-crew roll call time to 5:00 (3) If the pre-crew roll call time is after 22:00, the time from the pre-crew roll call time to the post-crew roll call time Time Here, it is assumed that train operation and roll call are not performed after 5:00.

FIG. 12 is an example of a daily work record table.
The daily work record table has data items such as "date" indicating the absolute date, "crew number" that uniquely identifies the crew member, "work content" indicating the work content of the crew member on that date, and the start date of the route of work. "Route crew start date" indicating, "Route number" that uniquely identifies the route, "Attendance place" that indicates the place where the crew member starts and ends work, "Attendance roll call actual time" that indicates the actual time when the crew started working , "Actual time of leaving roll call" indicating the actual time of the end of work, "Career time" indicating the cumulative time the crew member was on the train on the date, and "Movement time" indicating the cumulative time the crew member traveled on the date other than the crew member. ”,“ Preparation report time ”indicating the cumulative time required from attendance to the start of the first train flight on that date, from the end of the last train flight to the departure from work, from the roll call before the flight to the start of the train flight on that date, after the train flight is completed , "Return time" indicating the cumulative time required to make a roll call after the crew, and "Midnight working hours" indicating the cumulative time worked in the midnight zone specified on the date, one case per crew member per day It is stored.

Next, the work record correction screen program 1261 will be described with reference to FIG. FIG. 13 is a screen example of the work record correction screen program 1261.
The work record correction screen has a crew name selection combo box 2611, a registration button 2612, a route information display unit 2613, a performance time correction unit 2614, and a work time display unit 2615.

Further, FIG. 14 is a flowchart showing the details of the work record correction screen program 1261.
On the work record correction screen, first, as step S301, the work management person 9 selects a crew member whose performance is to be corrected.
Next, in step S302, the daily work record table (see FIG. 12) is searched using the crew number acquired in step S301 as a key, and the route number on each date is acquired.
Next, in step S303, the actual crew route table (FIG. 10) is searched using the route number acquired in step S302 as a key, and matching records are acquired.

Further, in step S304, the daily work record table (see FIG. 12) is searched using the route number acquired in step S302 as a key, and matching records are acquired.

In step S305, the acquired actual crew route information (see FIG. 10) is displayed on the route information display unit 2613, and the daily work record information is displayed on the working hour display unit 2615.

In step S306, it is determined whether or not to correct the actual result. When correcting the actual result, in step S307, the labor management person 9 inputs the start / end time of each work (crew, turn-back, movement, etc.) in the route into the actual time correction unit 2614.

When the work record correction input in step S307 is detected, the work time calculation process is performed based on the time input in step S307 in step S308, and the recalculated result is displayed on the work time display unit 2615.

Here, the commuting roll call actual time is the start time of the preparation report time before the first flight entered on the actual correction screen. The leaving roll call actual time is the end time of the preparation report time after the last flight entered on the actual correction screen. The crew time, travel time, preparation report time, turnaround time, and midnight working time are the results calculated by the working time calculation process based on the time entered on the performance correction screen.

After repeatedly inputting steps S307 and S308, the labor management staff presses the "Register" button on the work record correction screen, and in step S309, the start time of the preparation report time before the first flight entered in step S307 is set to ". The end time of the preparation report time after the last flight entered in step S307 as the "attendance roll call actual time" is updated to the daily work record table (see FIG. 12) as the "exit roll call actual time". Further, the daily work record table (see FIG. 12) is updated based on the crew time, travel time, preparation report time, turnaround time, and midnight work time calculated in step S308.

Further, each time input in step S307 is updated to the actual crew route table (see FIG. 10). After that, the process returns to step S305, and the track record and work record after the record correction are displayed on the record correction screen. When the actual result is corrected in step S306, steps S307, S308, and S309 are repeated.

In the above embodiment, the actual working hours for each day are calculated by combining the crew route information at the time of planning, the timetable that actually operated the train, and the actual information of the roll call performed before and after the train crew. By referring to the implementation timetable and actual timetable, even if you are on the same train, you can use the crew to perform the duties of the driver and conductor, the duties to get the train in and out of the garage (on the premises), and to move. You can distinguish between train rides (movements). In addition, by referring to the roll call record information, it is possible to grasp the actual value of the time other than the time when the train is boarded, that is, the preparation report time and the return time. Moreover, since only the information managed in the operation management system is used, it is not necessary to equip the crew with special equipment.

By combining the roll call record information (roll call record table 61), working hours can be calculated and input without hassle even for sudden events (customer guidance, etc.) for individual crew members that occur outside the train. Accurate calculation of working hours is also important from the viewpoint of salary payment and legal compliance.

As described above, in the above embodiment, by combining the crew route information and the actual timetable, even if different trains are boarded in one route, the working hours during the train ride (not only the crew but also the working hours are not counted). Movement can also be determined). Furthermore, the actual value of working hours for each day can be calculated by calculating from the time of the actual timetable and the roll call actual information.

1 Working hours calculation system 11 Working hours calculation system Server 12 Working hours calculation system Terminal 13 Network 3 Operation planning system 4 Career control system 5 Working hours planning system 6 Roll call system 2 Network 31 Planned crew route table 41 Train running record table 51 Daily work Planning table 61 Roll call record table 113 CPU
121 CPU
114 Main storage 122 Main storage 111 External interface 112 External interface 123 External interface 115 Auxiliary storage device 126 Auxiliary storage device 124 Display device 125 Input device 1151 Working time totaling program 1152 Performance correction processing program 1261 Working performance correction screen program

Claims (9)

A working hours calculation system that has a server that collects and manages information that is the basis for calculating working hours, and a terminal that displays and corrects working hours.
The server
It has a work record totaling department that totals working hours.
The server
A train schedule related to train operation, an operation planning system for planning vehicle operation and crew operation, a course control system for controlling daily train operation, a work planning system for allocating crew members according to crew operation, and the crew ward office. It is connected to the roll call system that manages the schedule and results of roll calls made when the crew members go to work, before the flight, after the flight, and when they leave the office, respectively, via a network.
The operation planning system is
Holds a planned crew route table that manages the crew route, which is a combination of trains that the crew travels from work to departure.
The course control system is
Holds a train running record table that manages the departure time and arrival time when the train actually runs,
Holds a daily work plan table that links the crew route and crew,
The roll call system
Holds a roll call record table that manages the roll call time record of the crew route,
The work record totaling unit of the server
A working hour calculation system characterized in that the working hours are totaled by day with reference to the planned crew route table, the train running record table, the daily work plan table, and the roll call record table. The work record totaling unit of the server
The first aspect of claim 1 is that the actual crew route information is created based on the planned crew route table, the train travel record table, and the roll call record table, and the actual crew route information is created as the actual crew route table. Described working hours calculation system. The work record totaling unit of the server
Using the work time calculation target date as a key, the line crew start date of the planned crew route table, the daily work plan table, and the roll call record table is searched, and the matching first record is acquired.
Using the work time calculation target date as a key, the operation date of the train travel record table is searched and the matching second record is acquired.
The working hour calculation system according to claim 2, wherein the actual crew route information creation process is performed based on the first record and the second record. The work record totaling unit of the server
If there is a crew number whose working hours have not been calculated, the working hours are calculated based on the daily work plan table and the actual crew route information.
The working hour calculation system according to claim 2, wherein daily working record information is created as a daily working record table based on the working hours. The performance crew route information creation process of the work record totaling unit of the server is
For all records of the planned crew route table, the route crew start date, route number, detailed number, driving date, train number, boarding station, pre-crew roll call location, pre-crew roll call time, disembarkation station, post-crew roll call location, and post-crew Copy the roll call time and crew details to the actual crew route table,
If there are routes and details that have not been imported, refer to the train travel record table using the operation date, train number, boarding station, and getting-off station in the record of the actual crew route table that has not been imported as keys. , Acquire the actual departure time and the actual arrival time in the matching record of the train running record table, and set it in the item of the actual uncaptured item of the actual crew route table.
If there are routes and details that have not been imported, the roll call record table can be used using the route crew start date, route number, pre-crew roll call time, or post-crew roll call time as keys in the records of the actual crew route table. The working time calculation according to claim 2, wherein the roll call actual time in the matching record of the roll call actual table is acquired and set in the item of the actual crew route table for which the actual result has not been imported. system. The work time calculation process of the work record totaling unit of the server is
Calculate the crew time, which indicates the cumulative time the crew has been on the train, for each date.
Calculate the travel time for each date, which indicates the cumulative time that the crew has traveled outside the crew.
Calculate the preparatory report time for each date, which indicates the cumulative time required from the start of the first train to the start of the first train, and the end of the last train to the departure of the train.
The turnaround time, which indicates the cumulative time required from the roll call before the flight to the start of the train flight, and the roll call after the train flight after the end of the train flight, is calculated for each date.
Calculate the midnight working hours, which indicates the cumulative hours worked in the specified midnight zone, for each date.
The working time calculation system according to claim 4, wherein the crew time, the traveling time, the preparation report time, the turnaround time, and the midnight working time are stored in the daily working record table for each date. .. The server
It has a work record correction department for correcting the work record.
The terminal
The work record correction screen part for correcting the work record via the work record correction screen,
A display device that displays the work record correction screen and
It has an input device that accepts information input, and
The work record correction screen is
It has a route information display unit, an actual time correction unit, and a working time display unit.
The work record correction section and the work record correction screen section
On the work record correction screen,
Using the crew number of the crew member whose performance is to be corrected as a key, the daily work performance table is searched to obtain the route number for each date.
Using the crew number as a key, the actual crew route table is searched to obtain matching records.
Using the route number as a key, the daily work record table is searched to obtain matching records.
The acquired track record crew route information is displayed on the route information display unit, and
The acquired daily work record information is displayed on the working hours display section, and
When correcting the actual result, the start and end times of each work in the route are input to the actual time correction unit via the input device.
When the work record correction input is detected, the work time calculation process is performed based on the input start and end times of each work, and the recalculated result is displayed on the work time display unit. The working hour calculation system according to claim 1. The work record correction section and the work record correction screen section
The start time of the preparation report time before the first flight is set as the actual attendance roll call time, and the end time of the preparation report time after the last flight is set as the exit roll call actual time. Update the preparation report time, the turnaround time, and the midnight working time,
Update each time in the performance crew route table,
The working hour calculation system according to claim 7, wherein the track record and the working record after the actual result correction are displayed on the actual result correction screen. The working hour calculation system according to claim 1, wherein the roll call system exists for each crew ward office.

Images