JP2005202481A - Computer-executable program supporting cost allocation - Google Patents

Abstract

<P>PROBLEM TO BE SOLVED: To support management of cost of a plurality of places including a place shared by a plurality of departments. <P>SOLUTION: This computer-executable program making a computer function as a cost management support server supporting the management of the cost of the plurality of places including the place shared by the plurality of departments makes the computer: add a department bearing the cost of the place to an access management table recording access of staffers of the plurality of places on the basis of a lookup table of the place and the department bearing the cost; calculate a room entrance time from room entrance time and room exit time shown by the access management table; add the room entrance time to the access management table; calculate allocation of the cost to the plurality of departments on the basis of the sum of the room entrance times; and add the department of the adjacently entered place to the access management table when the department corresponding to the place by the lookup table shows the adjacent department. <P>COPYRIGHT: (C)2005,JPO&NCIPI

Description

  The present invention relates to a computer-executable program that functions as an expense management support server that supports the management of expenses in a plurality of places including a place shared by a plurality of departments.

2. Description of the Related Art In recent years, software technology has been developed that automatically calculates a cost allocation according to work results at a plurality of workplaces by detecting and recording staff entry and exit at each workplace using a sensor or the like. For example, it is possible to record the passage of a grooved person with a ticket gate sensor at the entrance to each block in the groove, and based on this record, maintain or inspect the common groove etc. There has been proposed a groove person management device that performs management of a groove person to be implemented (for example, Patent Document 1).
Japanese Patent Laid-Open No. 06-176037

  However, in the above-described conventional method, if it is an operation of a common groove, it is only necessary to grasp information about which block the user was in, and to grasp the cost for each block. Because there are rooms commonly used in each department, if you try to grasp the cost simply based on the history of entering and leaving the room, the cost of time in the room used in common can not be allocated anywhere turn into. In particular, it is a remarkable problem for a staff member who does not belong to any department, such as a nurse, but who enters and exits the above-mentioned common room according to a doctor's instruction.

  Therefore, an object of the present invention is to provide a computer-executable program that functions as an expense management support server that supports the management of expenses in a plurality of places including a place shared by a plurality of departments.

  In order to solve the above-described problems, the present invention provides a computer-executable program that functions as an expense management support server that supports the management of expenses in a plurality of places including a place shared by a plurality of departments. Based on the correspondence table that shows the correspondence between the department and the department that bears the expense, the department that bears the expense of the place indicated by the entry / exit management table that records the entry / exit of the staff of the plurality of places is added to the entry / exit management table And storing the department storage means, calculating the entry time from the entry time and the exit time indicated by the entry / exit management table, and adding the entry time to the entry / exit management table for storage. , Functioning as an allocation calculation means for calculating an allocation of expenses to the plurality of departments based on the total entry time, and the department storage means according to the correspondence table If the department that corresponds to the serial location indicates just before department, configured to store in addition to the above entry and exit management table the department that corresponds to the location that had entered the room just before you enter the 該場 office.

  In such a program, it is possible to appropriately allocate the cost of a place (room) shared by multiple departments to the computer, and to allocate the expense according to the actual work amount to each department. it can.

  As means for solving the above-mentioned problems, the present invention can also be a staffing device realized by executing the above-mentioned program and a storage medium storing the above-mentioned program.

  ADVANTAGE OF THE INVENTION According to this invention, the expense of the place (room) shared by several departments can be allocated appropriately, and the expense allocation according to the actual amount of work can be performed to each department.

  Hereinafter, embodiments of the present invention will be described with reference to the drawings.

  The network configuration of the expense management support system realized by the program according to the embodiment of the present invention is configured as shown in FIG. 1, for example. FIG. 1 is a diagram illustrating a network configuration of a cost management support system.

  In FIG. 1, the cost management support system 10 is constructed in a hospital, for example. In the cost management support system 10, the cost management support server 100 is a computer server controlled by a CPU (Central Processing Unit), and each room such as a doctor's room A, an operating room A, and a ward B via the network 11. Are connected to an ID card reader 2 that reads an ID card of a staff member entering and leaving the room, and a plurality of PCs (Personal Computers) 3 used by the staff member via an intranet 12.

  The cost management support server 100 receives and stores the entry / exit information indicating the employee ID, location ID, and entry / exit time of the staff read from each ID card reader 2 via the network 11.

  Further, the cost management support server 100 executes a cost allocation process to each department based on the received entry / exit information. Various information and processing results managed by the cost management support server 100 are provided to the PC 3 used by the staff via the intranet 12.

  FIG. 2 is a diagram illustrating a functional configuration of the expense management support server. In FIG. 2, the cost management support server 100 includes an output control unit 13, an input control unit 14, a display control unit 15, a storage area 16, a communication control unit 18, an installer 19, and a registered information management processing unit 31. An entry / exit information processing unit 32, a place-department conversion processing unit 33, an allocation ratio calculation processing unit 34, and an information provision processing unit 35. Further, the cost management support server 100 includes an employee registration table 41, a location registration table 42, a department registration table 43, an entrance / exit management table 44, a conversion table 45, and a department correspondence table 46 in an area such as a hard disk. The allocation ratio table 47 is stored and managed.

  The output control unit 13 controls output data and outputs it to a printer or the like in accordance with an instruction from the CPU. The input control unit 14 controls input data input by a keyboard, a mouse, or the like. The display control unit 15 controls display data to control display on a monitor or the like.

  The communication control unit 18 controls the cost management support server 100 to transmit / receive data to / from an external terminal via a network such as the Internet or a LAN (Local Area Network) according to a predetermined communication protocol.

  When the storage medium 20 storing the program for realizing the processing in the cost management support server 100 is set in the driver, the installer 19 reads the program from the storage medium 20 and installs it in a predetermined storage area such as a hard disk. To do. Execution of the processing in the cost management support server 100 is realized by the CPU performing in accordance with a program installed in a predetermined storage area such as a hard disk. The storage medium 20 may be any medium that can read a program by a computer. For example, it is a CD-ROM (Compact Disc Read-Only Memory). Alternatively, it may be downloaded via a network and installed in a predetermined storage area such as a hard disk.

  The registration information management processing unit 31 includes a staff registration table 41 indicating registration information regarding hospital staff, a location registration table 42 indicating registration information regarding each room in the hospital, and a department registration table 43 indicating registration information regarding hospital departments. Manage.

  The entrance / exit information processing unit 32 stores the entrance / exit information received via the network 11 in the entrance / exit management table 44.

  The location-department conversion processing unit 33 should bear the expense based on the location ID of the entry / exit information stored in the entry / exit management table 44 by referring to the conversion table 45 that associates the location with the department. Determine the department.

  The allocation ratio calculation processing unit 34 calculates the allocation ratio of the expense to each department according to the usage time of each room based on the entrance / exit information accumulated in the entrance / exit management table 44.

  In response to a request from the PC 3 connected via the Internet 12, the information provision processing unit 35 receives a staff registration slip 41, a location registration slip 42, a department registration slip 43, an entrance / exit management table 44, and a conversion table. 45, the department correspondence table 46, and the allocation ratio table 47, information such as the allocation ratio of expenses is provided to the PC 3.

  The entrance / exit management table 44, the conversion table 45, the department correspondence table 46, and the allocation ratio table 47 are created every day or every month.

  Next, a cost management process executed by the cost management support server 100 will be described with reference to FIG. FIG. 3 is a flowchart for explaining the cost management process. In FIG. 3, the place-department conversion processing unit 33 reads the entrance / exit management table 44 in which the entrance / exit information is stored by the entrance / exit information processing unit 32 (step S11), and sorts them by the entrance time for each staff ID (step S11). S12).

  Then, the location-department conversion processing unit 33 sequentially extracts one record from the sorted entry / exit management table 44 and adds it to the department correspondence table 46 (step S13), and the allocation department ID corresponding to the place ID of the record. Is obtained from the conversion table 45 (step S14).

  The location-department conversion processing unit 33 checks whether or not the allocation department ID acquired from the conversion table 45 indicates “immediately preceding department” (step S15). If the allocation department ID does not indicate “immediate department”, the allocation department ID acquired from the conversion table is set as the department ID in the department correspondence table 46 (step S16), and the process proceeds to step S18. On the other hand, when the allocated department ID indicates “immediately preceding department”, the department ID set in the immediately preceding record is set in the department correspondence table 46 (step S17).

  The place-department conversion processing unit 33 determines whether or not all records in the entry / exit management table 44 have been processed (step S18). If all the records have not been processed, the process returns to step S13, the next record is taken out from the entrance / exit management table 44, and the same processing as described above is repeated. On the other hand, when all the records have been processed, the processing in the place-department conversion processing unit 33 is terminated, and the process proceeds to step S19. Subsequently, processing by the allocation ratio calculation processing unit 34 is performed.

  The allocation ratio calculation processing unit 34 calculates the room entry time from the room entry time and the room exit time, and sets it in the department correspondence table (step S19). Then, the allocation ratio calculation processing unit 34 calculates the total entry time for each department for each staff ID, and stores the calculation result in the allocation ratio table 47 (step S19). The process by the allocation ratio calculation process part 34 is complete | finished, and the whole process of an expense management process is complete | finished.

  Next, various registration information tables managed by the registration information management processing unit 31 will be described with reference to FIGS.

  FIG. 4 is a diagram illustrating an example of the staff registration information table. In FIG. 4, the staff registration information table 41 has items such as staff ID, staff name, job type, and department. For example, the occupation name of the staff name “Ichiro Fuji” of the staff ID “ID00001” is “nursing personnel” and the department to which the staff belongs is “department A”.

  FIG. 5 is a diagram illustrating an example of the location registration information table. In FIG. 5, the location registration information table 42 has items such as a location ID and a location name. For example, it is indicated that the place name of the place ID “BA001” is “doctor's room A” or the like.

  FIG. 6 is a diagram illustrating an example of the department registration information table. In FIG. 6, the department registration information table 43 has items such as a department ID and a place name. For example, the location name of the department ID “BU001” is “Department A” or the like.

  Next, the entrance / exit management table 44 processed by the place-department conversion processing unit 33 in steps S11 and S12 of FIG. 3 will be described with reference to FIG. FIG. 7 is a diagram illustrating an example of an entrance / exit management table.

In FIG. 7, the entry / exit management table 44 has items such as staff ID, place ID, entry time, and exit time. Values corresponding to these items are transmitted from each ID card reader 2 connected via the network 11. For example, the staff ID “ID00001” is the place ID
This indicates that the user has entered “BA001” at the entrance time “10:00” and has exited at the exit time “10:05”.

  Since the location-department conversion processing unit 33 reads the entry / exit management table 44 in step S11 of FIG. 3, the entry / exit management information table 32 stores the entry / exit management table for each staff ID. 44 is not neatly organized.

  Therefore, the location-department conversion processing unit 33 sorts the entrance / exit management table 44 by the entrance time for each staff ID by the processing in step S12 in FIG. It can be done easily.

  The conversion table 45 referred to by the place-department conversion processing unit 33 in step S14 of FIG. 3 will be described with reference to FIG. FIG. 8 is a diagram illustrating an example of a conversion table.

  In FIG. 8, the conversion table 45 has items such as a place ID and an allocation department ID. The conversion table 45 relates to the registered location shown in the location registration information table 42 shown in FIG. 5, the department ID of the registered department shown in the department registration information table 43 shown in FIG. "As the allocation department ID.

  The “immediately preceding department” indicates that the department ID assigned to the room (place) where the staff member has entered immediately before is associated. As described above, by assigning “immediate department” to the location ID, it is possible to allocate the expense of the room used in common to the department assigned immediately before. For example, since a room such as an operating room is related to a room that has been working in a straight line, this makes it possible to allocate expenses to a department that should be properly burdened.

  The department correspondence table after the processing in step S19 in FIG. 3 will be described with reference to FIG. FIG. 9 is a diagram illustrating an example of a department correspondence table.

  9, in addition to the items in the entry / exit management table 44, the department correspondence table 46 includes the department ID set by the processes in steps S16 and S17 in FIG. 3 and the room entry time set by the process in step S19. Have items.

  In the department correspondence table 46 shown in FIG. 9, only the staff ID “ID00001” is shown, but actually, the same table continues for each staff ID “ID00002”, “ID00003”.

  In the department correspondence table 46, by referring to the conversion table 45 of FIG. 8, the department ID value “BU001” immediately before the department ID corresponding to the place ID “BA002” is set to the department ID value 46a. The immediately preceding department ID “BU005” is set in the ID value 46b.

  Next, the allocation ratio calculation result in step S20 of FIG. 3 will be described with reference to FIG. FIG. 10 is a diagram illustrating an example of an allocation ratio table showing the allocation ratio calculation result.

  In FIG. 10, an allocation ratio table 47 shows calculation results of the distribution ratio of expenses incurred during a predetermined period (daily, weekly, monthly, yearly, etc.), and items such as staff ID, department ID, total room entry time, and ratio Have In the allocation ratio table 47 shown in FIG. 10, only the staff ID “ID00001” is shown, but actually, the same table continues for each staff ID “ID00002”, “ID00003”.

  In the allocation ratio table 47, it is indicated that the department in which the expense has occurred for the staff ID “ID00001” is the department IDs “BU001”, “BU003”, and “BU005”. Then, the staff with the staff ID “ID00001” uses the room where the expense is allocated to the department ID “BU001” for 376 minutes, which indicates that the ratio is “72%” with respect to the whole. Further, the staff with the staff ID “ID00001” uses the room with the expense allocated to the department ID “BU003” for 90 minutes, which indicates that the ratio is “17%” with respect to the whole. Furthermore, the staff member with the staff ID “ID00001” uses the room in which the expense is allocated to the department ID “BU005” for 54 minutes, which indicates that the ratio is “11%” with respect to the whole.

  Next, screen examples provided to the PC 3 by the information provision processing unit 35 will be described with reference to FIGS. 11 and 12.

  FIG. 11 is a diagram illustrating an example of a screen that displays the entrance / exit of a staff member for one day. In FIG. 11, the screen 70 mainly has a display area 71 for displaying the status of the entrance / exit of the staff of the day and a display area 72 for displaying the correspondence of the cost allocation.

  The display area 71 further includes a designated area 711 for designating a search condition, and a display area 712 for displaying data indicating the status of daily entry / exit of the staff based on the search condition designated in the designated area 711. Have. The designated area 711 includes, for example, a designated area 711a for designating a job type, a designated area 711b for designating a staff member, and 711c for designating a date. For example, a staff member who uses the PC 3 designates the job type “nursing personnel” in the designated area 711a, the staff member “Ichiro Fuji” in the designated area 711b, and the date “2003/05/10” in the designated area 711c.

  A display area 712 displays a display area 712a for displaying a message indicating a search result based on the search condition specified in the specified area 711, and an entry / exit situation based on the search condition and a cost allocation department in time series. A display area 712b.

  In the display area 712a, for example, as a search result based on the search condition specified in the specified area 711, a message such as “May 10, 2003 Nursing personnel: Ichiro Fuji staff ID: ID00001 data” is displayed. Is displayed. If the search was not performed because the employee was on vacation on the specified date, for example, “May 10, 2003 Nursing staff: Ichiro Fuji staff ID: ID00001 data was not searched.” A message is displayed.

  In the display area 712b, data based on the department correspondence table 46 shown in FIG. 9 is displayed. At this time, by associating the place ID and department ID of the department correspondence table 46 with the place ID of the place registration information table 42 shown in FIG. 5 and the department ID of the department registration information table 43 shown in FIG. The place and department can be displayed by their names. In addition, a “change” item is provided in the display area 712b, and the location, department, entry time, exit time, and the like can be changed by clicking each change button 712c with a mouse or the like.

  In the display area 72, data based on the conversion table 45 shown in FIG. At this time, the location ID and department ID of the conversion table 45 are associated with the location ID of the location registration information table 42 shown in FIG. 5 and the department ID of the department registration information table 43 shown in FIG. And the department can be displayed by its name.

  The user of the PC 3 can check the data displayed in the display area 712b while referring to the conversion table displayed in the display area 72.

  FIG. 12 is a diagram illustrating an example of a screen that displays an allocation ratio for one month. In FIG. 12, a screen 80 includes a designated area 81 for designating search conditions, and a display area 82 for displaying data indicating the status of entrance / exit of a staff member for one month based on the search conditions designated in the designated area 81. Have

  The designated area 81 includes, for example, a designated area 81a for designating a distribution category, a designated area 81b for designating a job type, and a designated area 81c for designating a year and month. For example, a staff member who uses the PC 3 designates the assignment category “staff (job type)” in the designated area 81a, the job type “nursing personnel” in the designated area 81b, and the designated month “May 2003” in the designated area 81c.

  In the display area 82, for example, the allocation ratio is displayed in a list for each staff member of the occupation type “nursing personnel” designated in the designated area 81b in the designated month “May 2003” designated in the designated area 81c. The For each staff member, data based on the allocation ratio table 47 shown in FIG. 10 is displayed.

  The list displayed in the display area 82 includes items such as staff, direct distribution category, direct department, allocation department (1), allocation department (2), allocation department (3), and change. For example, in the case of “ID00001”, “Fuji Ichiro”, the cost is allocated (“allocation”), which is 72% for department A, 17% for department C, and 11% for department F, respectively. . Further, in the case of “ID 70007” “Fuji Shichirou”, it indicates that the department to which the affiliation belongs bears (“direct charge”), and that the department A bears.

  The value of each item can be changed by clicking ▼ with a mouse or the like.

  ADVANTAGE OF THE INVENTION According to this invention, the expense of the place (room) shared by several departments can be allocated appropriately, and the expense allocation according to the actual amount of work can be performed to each department.

The following is added.
(Supplementary note 1) In a computer-executable program that functions as a cost management support server that supports management of costs in a plurality of places including a place shared by a plurality of departments,
Based on the correspondence table showing the correspondence between the place and the department that bears the expense, the department that bears the expense of the place indicated by the entry / exit management table that records the entry / exit of the staff at the plurality of places is the entry / exit management table. Department storage means for storing in addition to,
An entry time storage means for calculating an entry time from the entry time and the exit time indicated by the entry / exit management table, and adding the entry time to the entry / exit management table and storing the entry time;
Based on the total entry time, function as an allocation calculation means to calculate the allocation of expenses to the multiple departments,
When the department corresponding to the location indicates the previous department according to the correspondence table, the department storage means adds and stores the department corresponding to the place where the room was entered immediately before entering the place to the entrance / exit management table. A program to do.
(Supplementary note 2) The program according to supplementary note 1, wherein the allocation calculating means calculates an allocation of expenses to the plurality of departments for each staff member.
(Additional remark 3) In the expense management support server which supports management of the expense of several places including the place shared by several departments,
Based on the correspondence table showing the correspondence between the place and the department that bears the expense, the department that bears the expense of the place indicated by the entry / exit management table that records the entry / exit of the staff at the plurality of places is the entry / exit management table. Department storage means for storing in addition to,
An entry time storage means for calculating an entry time from the entry time and the exit time indicated by the entry / exit management table, and adding the entry time to the entry / exit management table and storing the entry time;
An allocation calculation means for calculating an allocation of expenses to the plurality of departments based on the total entry time;
When the department corresponding to the location indicates the previous department according to the correspondence table, the department storage means adds and stores the department corresponding to the place where the room was entered immediately before entering the place to the entrance / exit management table. An expense management support server designed to do this.
(Supplementary Note 4) In a computer-executable program that functions as a cost management support server that supports management of costs in a plurality of locations including a location shared by a plurality of departments,
Based on the correspondence table showing the correspondence between the place and the department that bears the expense, the department that bears the expense of the place indicated by the entry / exit management table that records the entry / exit of the staff at the plurality of places is the entry / exit management table. Department storage means for storing in addition to,
An entry time storage means for calculating an entry time from the entry time and the exit time indicated by the entry / exit management table, and adding the entry time to the entry / exit management table and storing the entry time;
Based on the total entry time, function as an allocation calculation means to calculate the allocation of expenses to the multiple departments,
When the department corresponding to the location indicates the previous department according to the correspondence table, the department storage means adds and stores the department corresponding to the place where the room was entered immediately before entering the place to the entrance / exit management table. A computer-readable storage medium storing a program to be executed.

It is a figure which shows the network structure of a cost management support system. It is a figure which shows the function structure of a cost management support server. It is a flowchart figure for demonstrating expense management processing. It is a figure which shows the example of a staff registration information table. It is a figure which shows the example of a place registration information table. It is a figure which shows the example of a department registration information table. It is a figure which shows the example of an entrance / exit management table | surface. It is a figure which shows the example of a conversion table. It is a figure which shows the example of a division | segmentation correspondence table. It is a figure which shows the example of the allocation ratio table | surface which shows an allocation ratio calculation result. It is a figure which shows the example of the screen which displays the entrance / exit of the staff of a day. It is a figure which shows the example of the screen which displays the allocation ratio of one month.

Explanation of symbols

2 ID card reader 3 PC
DESCRIPTION OF SYMBOLS 11 Network 12 Intranet 13 Output control part 14 Input control part 15 Display control part 18 Communication control part 19 Installer 20 Storage medium 31 Registration information management process part 32 Entrance / exit information processing part 33 Location-department conversion process part 34 Allocation ratio calculation process Department 35 Information provision processing section 41 Staff registration table 42 Location registration table 43 Department registration table 44 Entrance / exit management table 45 Conversion table 46 Department correspondence table 47 Allocation ratio table 100 Cost management support server

Claims (3)

In a computer-executable program that functions as a cost management support server that supports management of costs in a plurality of locations, including a location shared by a plurality of departments,
Based on the correspondence table showing the correspondence between the place and the department that bears the expense, the department that bears the expense of the place indicated by the entry / exit management table that records the entry / exit of the staff at the plurality of places is the entry / exit management table. Department storage means for storing in addition to,
An entry time storage means for calculating an entry time from the entry time and the exit time indicated by the entry / exit management table, and adding the entry time to the entry / exit management table and storing the entry time;
Based on the total entry time, function as an allocation calculation means to calculate the allocation of expenses to the multiple departments,
When the department corresponding to the location indicates the previous department according to the correspondence table, the department storage means adds and stores the department corresponding to the place where the room was entered immediately before entering the place to the entrance / exit management table. A program to do. In a cost management support server that supports the management of costs in multiple locations, including locations shared by multiple departments,
Based on the correspondence table showing the correspondence between the place and the department that bears the expense, the department that bears the expense of the place indicated by the entry / exit management table that records the entry / exit of the staff at the plurality of places is the entry / exit management table. Department storage means for storing in addition to,
An entry time storage means for calculating an entry time from the entry time and the exit time indicated by the entry / exit management table, and adding the entry time to the entry / exit management table and storing the entry time;
An allocation calculation means for calculating an allocation of expenses to the plurality of departments based on the total entry time;
When the department corresponding to the location indicates the previous department according to the correspondence table, the department storage means adds and stores the department corresponding to the place where the room was entered immediately before entering the place to the entrance / exit management table. An expense management support server designed to do this. In a computer-readable storage medium storing a program that functions as a cost management support server that supports management of costs in a plurality of locations including a location shared by a plurality of departments,
Based on the correspondence table showing the correspondence between the place and the department that bears the expense, the department that bears the expense of the place indicated by the entry / exit management table that records the entry / exit of the staff at the plurality of places is the entry / exit management table. Department storage means for storing in addition to,
An entry time storage means for calculating an entry time from the entry time and the exit time indicated by the entry / exit management table, and adding the entry time to the entry / exit management table and storing the entry time;
Based on the total entry time, function as an allocation calculation means to calculate the allocation of expenses to the multiple departments,
When the department corresponding to the location indicates the previous department according to the correspondence table, the department storage means adds and stores the department corresponding to the place where the room was entered immediately before entering the place to the entrance / exit management table. A computer-readable storage medium storing a program to be executed.

Images