JP2009187469A - Income allocation device and method thereof - Google Patents

Abstract

<P>PROBLEM TO BE SOLVED: To optimize allocation of income data concerning an income allocation device and its method. <P>SOLUTION: When data not coinciding a first diagnosis and treatment department with a second diagnosis and treatment department exists on income data, an adjustment means e adds medicine income concerning the data to the income sum of the second diagnosis and treatment department totaled by the first totaling calculation means while deducting the medicine income concerning the data from the income sum of the first diagnosis and treatment department totaled by the first totaling calculation means. An output means f outputs data including the income sum of every diagnosis and treatment departments as a revenue and expenditure improvement table according to a section by a prescribed form. <P>COPYRIGHT: (C)2009,JPO&INPIT

Description

  The present invention relates to an apparatus for optimizing allocation of revenue data.

  Amoeba management is known as a management method for profit management in each department. Amoeba management is based on the idea that company management is not performed by only a part of top management, but all employees are involved, and the company organization is divided as finely as possible. It is a business management system that encourages all employees to participate in management by clearly showing the results of their work.

  A characteristic of amoeba management is that timely management information in each department is grasped by calculating “value added per hour” for each department. In simple terms, “value added per hour” is the amount of money (money earned) obtained by subtracting “expenses (money spent)” from “sales (money earned)” as “working hours (time worked)”. The divided amount.

  In a business format where products and intermediate products are traded between departments, such as in the manufacturing industry, etc., the trade between departments is regarded as “sales” of internal sales, and “expenses” and “working hours” generated within the departments are grasped. If it can, “value added per hour” can be obtained.

  A system is known that performs business management by creating a profit and loss statement and a balance sheet for each individual or each group on the premise that all work is performed by in-house ordering (for example, Patent Document 1). ).

Tokurei 2002-073488

  However, in business categories such as service businesses that do not trade products, it is not possible to easily determine “value added per hour” because it is impossible to grasp inter-departmental transactions. There is a problem that it is difficult to apply. In particular, in a business format in which multiple departments (medical department, medical technology department, nursing department, office department) provide medical services to a single patient, such as the medical industry, the concept of inter-departmental transaction itself It did not occur and it was not easy to calculate “value added per hour”.

  For example, in a medical institution, there are many organizations according to function, and the earnings results are often captured only by the medical department to which the doctor belongs. When calculating “value added per hour” by considering the medical income of the medical department to which the doctor belongs only as sales, the “value added per hour” in the co-medical department (medical technology department, nursing department, office department) is grasped. The problem of not being able to do arises.

  In addition, it is possible to record the profit record by sorting by related department based on the name of the disease, not the department to which the doctor belongs. In this case, it seems that “value added per hour” can be grasped by distributing medical income including doctors and co-medical departments (medical technology department, nursing department, office department).

  However, in this case, when a doctor performs medical care that belongs to other than his / her own department, medical income is not recorded in the medical department to which the doctor belongs. Cannot be grasped. Specifically, when a doctor on duty belonging to internal medicine examines a patient with a fracture that should be dealt with by surgery, the medical income is recorded in the co-medical department related to surgery and surgery based on the disease name “fracture”. Therefore, medical income is not recorded in the internal medicine department to which the doctor belongs. For this reason, there arises a problem that the “added value per hour” cannot be accurately grasped.

  In addition, there is a demand for detailed analysis of the breakdown of medical income in order to perform business management appropriately. That is, there is a demand for grasping the medical income for each medical department based on the disease name and at the same time grasping the medical income for each medical department based on the doctor.

  In addition, assuming that all work is performed by in-house ordering and management is performed for each individual or each group (for example, Patent Document 1), there is a problem that business processing becomes complicated and the work is stagnated. is there.

  The present invention has been made to solve the above-described problems, and appropriately calculates the income and expenses generated in each department in the service business and the like to obtain the “value added per hour”. The purpose is to understand accurately and easily. In particular, it is intended to be applied in the medical industry in which doctors and co-medical departments provide medical services to a single patient.

(1) (3) (4) (9) The revenue allocation device according to the present invention is:
An income distribution device that distributes the medical income for each medical department based on income data including at least medical income,
(X) Revenue data that records at least medical income, disease name, and doctor, disease name / clinical department related information that records the clinical department corresponding to the disease name, and doctor / clinical department related information that records the clinical department corresponding to the doctor A recorded recording section; and
(A) referring to disease name / clinical department related information based on the disease name recorded in the income data, and acquiring a first clinical department acquisition unit corresponding to the disease name;
(B) second medical department acquisition means for referring to doctor / clinical department related information based on the doctor recorded in the income data and acquiring a second medical department corresponding to the doctor;
(C) first total calculation means for calculating medical income recorded in the income data for each first clinical department and calculating a total income for each clinical department;
(E) When there is data in which the first medical department and the second medical department do not match in the income data, the first medical calculation income related to the data is calculated by the first total calculation means. And adjusting means for subtracting from the total income of the second clinical department and adding to the total income of the second medical department totaled by the first total calculation means. Therefore, even when the doctor performs a medical treatment belonging to other than his / her own department, the first total calculation means grasps the medical income for each clinical department based on the disease name and at the same time the second total calculation. By means and adjusting means, it is also possible to grasp the medical income for each department based on the doctor.

  In other words, the medical revenue for each department based on the disease name can be grasped as the medical revenue that this department can essentially obtain, and at the same time, the medical revenue based on the doctor as a breakdown of the medical revenue in the clinical department I can grasp it.

  Thereby, it is possible to grasp not only the load situation such as the personnel allocation in each clinical department but also an accurate “value added per hour” for each clinical department, which can be used as a management management judgment material.

(2) In the revenue allocation device according to the present invention,
(D) Secondly, the medical revenue recorded in the revenue data is totaled using the first clinical department and the second clinical department as the first key and the second key, respectively, and a total income for each clinical department is calculated. Further comprising a tally calculation means,
It is characterized by. Therefore, the revenue data processed in the adjusting means can be aggregated in the preprocessing, and the number of processing cases can be reduced and the processing can be executed efficiently.

(5) (6) (10) The revenue allocation device according to the present invention is:
A numerical value distribution device that distributes the numerical values for each aggregated item based on input data including at least numerical values,
(X) Input data that records at least a numerical value, the first item, and the second item, first item / total item related information that records a total item corresponding to the first item, and a total item corresponding to the second item A recording unit that records the recorded second item / total item related information;
(A) a first total item obtaining unit that obtains a first total item corresponding to the first item by referring to the first item / total item related information based on the first item recorded in the input data; ,
(B) second total item acquisition means for referring to the second item / total item related information based on the second item recorded in the input data and acquiring a second total item corresponding to the second item; ,
(C) first total calculation means for calculating the numerical value recorded in the input data using the first total item as a key, and calculating a numerical total for each total item;
(E) In the case where there is data in which the first tabulation item and the second tabulation item do not match in the input data, the first total calculated by the first tabulation calculation means And adjusting means for subtracting from the sum of numerical values of the total items and adding to the sum of numerical values of the second total items calculated by the first total calculation means. Therefore, it is possible to grasp the numerical sum based on the second total key simultaneously with grasping the numerical sum based on the first total key. As a result, the breakdown of the numerical sum can be analyzed in detail, and an accurate added value for each aggregation key can be obtained.

(7) The revenue allocation device according to the present invention is:
An income distribution device that distributes the medical income for each medical department based on income data including at least medical income,
(X) Revenue data that records at least medical income, disease name, and doctor, disease name / clinical department related information that records the clinical department corresponding to the disease name, and doctor / clinical department related information that records the clinical department corresponding to the doctor A recorded recording section; and
(A) first medical department acquisition means for referring to doctor / clinic department related information based on a doctor recorded in the income data and acquiring a first medical department corresponding to the doctor;
(B) referring to disease name / clinical department related information based on the disease name recorded in the income data, and acquiring a second clinical department corresponding to the disease name;
(C) first medical calculation revenue recorded in the income data, using the first clinical department as a key, and a first total calculation means for calculating a total income for each medical department;
(D) Secondly, the medical revenue recorded in the revenue data is totaled using the first clinical department and the second clinical department as the first key and the second key, respectively, and a total income for each clinical department is calculated. Total calculation means of
(E) When there is data in which the first medical department and the second medical department do not match in the income data, the first medical calculation income related to the data is calculated by the first total calculation means. And adjusting means for subtracting from the total income of the second clinical department and adding to the total income of the second medical department totaled by the first total calculation means. Therefore, even if the doctor performs a medical care that belongs to a department other than his / her own department, the first total calculation means grasps the medical revenue for each clinical department based on the doctor and simultaneously calculates the second total calculation. By means and adjustment means, it is possible to grasp the medical income for each department based on the disease name. Thereby, the breakdown of medical income can be analyzed in detail, and business management can be appropriately performed based on the accurate “added value per hour” for each medical department.

(8) The revenue allocation device according to the present invention is:
An income distribution device that distributes the medical income for each medical department based on income data including at least medical income,
(X) Revenue data that records at least medical income, disease name, and doctor, disease name / clinical department related information that records the clinical department corresponding to the disease name, and doctor / clinical department related information that records the clinical department corresponding to the doctor A recorded recording section; and
(A) referring to disease name / clinical department related information based on the disease name recorded in the income data, and acquiring a first clinical department acquisition unit corresponding to the disease name;
(B) second medical department acquisition means for referring to doctor / clinical department related information based on the doctor recorded in the income data and acquiring a second medical department corresponding to the doctor;
(E) In the income data, when the first clinical department and the second clinical department do not match, the medical income related to the data is subtracted from the medical income of the first clinical department, and the first It is characterized by the provision of adjusting means to add to the medical income of 2 departments. Therefore, even when a doctor performs a medical treatment that belongs to other than his / her own department, he / she grasps the medical income for each department based on the name of the disease, and at the same time, adjusts the medical income for each department based on the doctor. Can also be grasped. Thereby, the breakdown of medical income can be analyzed in detail, and business management can be appropriately performed based on the accurate “added value per hour” for each medical department.

[Correspondence with embodiment]
(X) In the embodiment, the disease name / clinical department related information in which the clinical department corresponding to the disease name is recorded corresponds to the disease name / clinical department master shown in FIG. 6B. The doctor / clinic department related information in which the department corresponding to the doctor is recorded corresponds to the doctor / clinical department master shown in FIG.

(A) Based on the disease name recorded in the income data, the first medical department acquisition means for referring to the disease name / clinical department master and acquiring the first medical department corresponding to the disease name is shown in FIG. The function of step S303 shown in FIG.

(B) The second medical department acquisition means for referring to the doctor / clinical department master based on the doctor recorded in the income data and acquiring the second medical department corresponding to the doctor is shown in FIG. 4 in the embodiment. The function of step S405 shown in FIG.

(C) The first total calculation means for calculating the total medical income recorded in the income data using the first clinical department as a key and calculating the total income for each clinical department is shown in FIG. 3 in the embodiment. The function of step S305 corresponds to this. Here, counting up using the first clinical department as a key is a concept of counting up the first clinical department as a sort key.

(D) Secondly, the medical revenue recorded in the revenue data is totaled using the first clinical department and the second clinical department as the first key and the second key, respectively, and a total income for each clinical department is calculated. In the embodiment, the total calculation means corresponds to the function of step S407 shown in FIG.

(E) When there is data in which the first medical department and the second medical department do not match in the income data, the first medical calculation income related to the data is calculated by the first total calculation means. The adjustment means that is subtracted from the total income of the medical departments and added to the total income of the second medical departments totaled by the first total calculation means is, in the embodiment, steps S409 to S409 shown in FIG. The function of S411 corresponds to this.

  Here, “subtracting” is a concept including subtracting the medical income from the total income of the first clinical department, clarifying the amount. Moreover, it is also a concept including not explicitly including medical income in the total income of the first clinical department.

  “Adding” is a concept that includes adding medical income to the total income of the first clinical department with its amount being clarified. It is also a concept including explicitly including medical income in the total income of the first clinical department.

(D) Secondly, the medical revenue recorded in the revenue data is totaled using the first clinical department and the second clinical department as the first key and the second key, respectively, and a total income for each clinical department is calculated. In the embodiment, the total calculation means corresponds to the function of step S407 shown in FIG. Here, counting up as the first key and the second key is a concept of counting up a key obtained by connecting the first key and the second key as a sort key.

  In the present invention, the “means” is a concept including a CPU function realized by a program. Here, the “program” is a concept including not only a program that can be directly executed by the CPU but also a program in a source format, a compressed program, an encrypted program, and the like.

1. First Embodiment In the present embodiment, a description will be given of a process for inputting medical data related to medical income created in advance in a general medical accounting system and distributing medical income for each medical department.

1-1. Functional Block Diagram FIG. 1 shows an example of a functional block diagram of the revenue allocation apparatus 1 according to one embodiment of the present invention. The revenue allocation device 1 is a computer device.

  The first medical department acquisition means a reads the income data 2073, refers to the disease name / clinical department master 2075 based on the disease name data recorded in the income data, and acquires the medical department data corresponding to the disease name. The second medical department acquisition unit b reads the income data, refers to the doctor / clinical department master 2077 based on the doctor data recorded in the income data, and acquires the medical department data corresponding to the doctor. The third medical department acquisition means g reads the income data, refers to the action / clinical department master 2079 based on the action data recorded in the income data, and acquires the medical department data corresponding to the action.

  The first total calculation means c totals the medical income recorded in the income data 2073 using the medical department acquired by the first clinical department acquisition means as a key, and calculates the total income for each medical department. The second tabulation calculation means d uses the first key and the first medical department data recorded in the income data 2073 as the first key and the first medical department data obtained by the first medical department acquisition means and the second medical department acquisition means, respectively. Aggregate as 2 keys and calculate the total income for each department. The third tabulation calculation means d uses the first key and the first key to obtain the medical income recorded in the income data 2073, the medical department data acquired by the second medical department acquisition means and the third medical department acquisition means, respectively. Aggregate as 2 keys and calculate the total income for each department.

  If there is income total data in which the first key and the second key do not match in the aggregation result in the second aggregation calculation unit or the third aggregation calculation unit, the adjustment unit e calculates the total income for the data. Is not included in the total income of the department related to the first key calculated in the first total calculation means, and the total income related to the data is totaled in the first total calculation means It is included in the total income of the department related to the second key. The output unit f outputs data including the total income for each department as a departmental balance improvement table in a predetermined format.

1-2. Hardware Configuration FIG. 2 shows an example of a hardware configuration in which the revenue allocation apparatus 1 shown in FIG. 1 is realized using a CPU. The revenue allocation apparatus 1 includes a display 201, a CPU 203, a memory 205, a keyboard / mouse 206, a hard disk 207, a communication circuit 209, and a CD-ROM drive 211.

  The hard disk 207 includes a revenue allocation program 2071 for performing revenue data allocation processing, the above-described revenue data 2073, a disease name / clinical department master 2075, a doctor / clinical department master 2077, an act / clinical department master 2079, and a clinical department. Every total data 2081 is recorded.

  6A shows an example of income data 2073, which records a patient name 601, a disease name 603, a doctor 605, an act 607, a medical service income 609, and the like. FIG. 6B shows an example of a disease name / clinical department master 2075, which records a disease name 621 and a medical department 623 corresponding to the disease name. C of FIG. 6 is an example of the doctor / clinic department master 2077, and records a doctor 641 and a clinical department 643 to which the doctor belongs. D of FIG. 6 is an example of the act / clinical department master 2079, which records the act 661, the clinical department 663 that is the department that performs the act, and the allocation ratio 665 of in-hospital cooperation revenue.

  FIG. 10 shows an example of the aggregate data 2081 for each department. For the sake of explanation, the total data 2081 for each medical department is in a format that can be output as a “departmental balance improvement table”, but may be in other formats.

  First medical department acquisition means a, second medical department acquisition means b, third medical department acquisition means g, first total calculation means c, second total calculation means d, third The total calculation means h, the adjustment means e, and the output means f are realized by executing the revenue allocation program 2071 on the CPU 203.

1-3. Processing Details Processing details in the present embodiment will be described with reference to FIGS. 3 to 5 are examples of flowcharts when the revenue allocation apparatus 1 of the present embodiment reads revenue data created by the medical accounting system and allocates revenue data for each medical department in the hospital. is there.

1-3-1. FIG. 3 is a flowchart of medical income data creation processing. Here, medical income data for each medical department set based on the disease name is calculated.

  When the user in the revenue allocation apparatus 1 operates the keyboard / mouse 206 to give an instruction to execute the revenue allocation program 2071, the CPU 203 reads the revenue data 2073 (step S301). For example, all the records of the income data 2073 shown in A of FIG.

  Next, the CPU 203 refers to the disease name / clinical department master 2075 based on the disease name data 603 recorded in the read income data 2073, and acquires the clinical department data corresponding to the disease name data (step S303). For example, by combining all the records of the income data 2073 shown in A of FIG. 6 and the clinical department data acquired based on the disease name data of each record, the data shown in A of FIG. 7 can be acquired.

  Next, the CPU 203 totalizes the medical income for each clinical department data based on the disease name with respect to the data acquired in the above, and records this in the clinical department total data 2081 (step S305). For example, the data shown in A of FIG. 7 can be obtained for each medical department data 701 based on the disease by collecting the medical income 609 and obtaining the data shown in B of FIG. In B of FIG. 7, the total medical income 703 in the medical department (disease name) 701 “internal medicine” is “200,000” yen, and the total medical income 703 in the medical department (disease name) 701 “surgery” is “600,000”. It is a circle.

  In the “departmental balance improvement table” corresponding to the total data 2081 for each medical department shown in FIG. 10, 101 indicates medical income for internal medicine, and 103 indicates medical income for surgery.

1-3-2. 4. In-hospital cooperation data creation processing FIG. 4 is a flowchart of in-hospital cooperation data creation processing. Here, data indicating the in-hospital cooperation income and cost generated when a doctor examines a patient who should be in charge of a department other than the department to which the doctor belongs is calculated.

  When the medical income data creation process (FIG. 3) is completed, the CPU 203 reads the income data 2073 again (step S401). Next, the CPU 203 refers to the disease name / clinical department master 2075 based on the disease name data 603 recorded in the read income data 2073, and obtains medical department data corresponding to the disease name data (step S403). For example, as shown above, the data shown in FIG. 7A can be acquired.

  Next, the CPU 203 refers to the doctor / clinical department master 2077 based on the doctor data 605 recorded in the read income data 2073, and acquires the clinical department data corresponding to the doctor data (step S405). For example, by combining all the records of the income data 2073 shown in A of FIG. 7 and the clinical department data acquired based on the doctor data of each record, the data shown in A of FIG. 8 can be acquired.

  Next, the CPU 203 totals the medical income for each of the clinical department data based on the disease name and the clinical department data based on the doctor for the data acquired above (step S407). For example, if medical income 609 is tabulated for each department (disease name) 701 and department (doctor) 801, data shown in B of FIG. 8 can be acquired.

  Next, the CPU 203 searches the acquired data for total data with different clinical department data (step S409). For example, the record 81 of the total data shown in B of FIG. 8 has different clinical department data because the clinical department (disease name) 701 is “surgery” and the clinical department (doctor) 801 is “internal medicine”.

  When there is data with different medical department data (step S409, YES), the CPU 203 counts this aggregated data as the in-hospital cooperation fee of the medical department based on the disease name, and as the in-hospital cooperation income of the medical department based on the doctor. (Step S411). For example, in B of FIG. 8, the in-hospital cooperation cost in the medical department (disease name) 701 “surgery” is “300,000” yen, and the in-hospital cooperation income in the medical department (doctor) 801 “internal medicine” is “300,000”. It is a circle.

  In the “Departmental Balance Improvement Table” corresponding to the total data 2081 for each department shown in FIG. 10, 105 indicates the in-hospital cooperation cost for surgery, and 107 indicates the in-hospital cooperation income for internal medicine.

1-3-3. Action Hospital Cooperation Data Creation Processing FIG. 5 is a flowchart of action hospital cooperation data creation processing. Here, data indicating the in-hospital cooperation income / cost generated for medical practice other than medical examination by a doctor is calculated.

  When the in-hospital cooperation creation process (FIG. 4) is completed, the CPU 203 reads the income data 2073 again (step S501). The CPU 203 extracts a data record in which the action 607 is other than “diagnosis” in the income data 2073 (step S503). For example, as shown in FIG. 9A, a record whose action 607 is “dispensing” or “film” is extracted from the income data 2073.

  Next, the CPU 203 refers to the doctor / clinical department master 2077 based on the doctor data 605 recorded in the income data 2073 extracted above, and acquires the medical department data corresponding to the doctor data (step S505). For example, data shown in B of FIG. 9 can be acquired.

  Next, the CPU 203 refers to the action / clinical department master 2079 based on the action data 607 recorded in the read income data 2073, and acquires the medical department data corresponding to the action data (step S507). For example, when the action 607 is “dispensing”, the medical department “pharmaceutical department” is acquired from the action / clinical department master 2079. Similarly, the department “radiology” is acquired from the act 607 “film”. Thereby, the data shown in C of FIG. 9 can be acquired.

  The medical revenue in C of FIG. 9 is calculated by multiplying the original medical revenue by the allocation ratio 665. This is for apportioning medical revenue between the medical department to which the doctor belongs and the pharmacology and radiology departments of the co-medical department, and can be determined for each hospital.

  Next, the CPU 203 adds up the medical income for each of the clinical department data based on the doctor and the clinical department data based on the action with respect to the data acquired above (step S509). For example, when medical income 609 is tabulated for each medical department (doctor) 901 and medical department (action) 903, data shown in D of FIG. 9 can be acquired.

  Next, the CPU 203 searches the acquired data for total data with different clinical department data (step S511). For example, since the clinical department (doctor) 901 is “internal medicine” and the medical department (action) 903 is “pharmaceutical department”, the medical data 91 of the aggregated data record 91 shown in FIG. 9D is different.

  Normally, medical actions other than the doctor's examination are often actions other than the department to which the doctor belongs, but in order to exclude cases where the doctor's department and the department of the action are the same, Consider the difference.

  When there is data with different medical department data (step S511, YES), the CPU 203 records this aggregated data as in-hospital cooperation expenses for the medical department based on the doctor, and as in-hospital cooperation income for the medical department based on the action. (Step S513). For example, in FIG. 9D, the in-hospital cooperation cost in the medical department (doctor) 901 “internal medicine” is “40,000” yen, and the in-hospital cooperation income in the medical department (action) 903 “pharmaceutical department” is “40,000”. "Yen.

  In the “Departmental Income Improvement Table” corresponding to the total data 2081 for each department shown in FIG. 10, 109 and 111 are the in-hospital cooperation costs of the internal medicine, 113 are the in-hospital cooperation expenses of the pharmacology, and 115 are the in-hospital of the radiology department. Each cooperation cost is explicitly indicated.

1-5. Summary As described above, according to the present invention, even when a doctor performs a medical treatment belonging to other than his / her own department, the medical income for each department based on the name of the disease is recorded, and at the same time, By recording the medical service revenue for each medical department based on the in-hospital cooperation cost / revenue, the accurate medical service revenue for each medical department can be grasped. In other words, even in a business type such as the medical industry where products are not traded in each department, it is possible to calculate the accurate income and expenses for each department by reflecting the income to the department that should be recorded.

  In addition, by expanding the in-hospital cooperation costs and revenues to the co-medical department (the medical technology department, the nursing department, and the administrative department), it is possible to grasp the “value added per hour” in the entire hospital operation.

  For example, in the departmental balance improvement table shown in FIG. 10, the internal profit is “390,000” yen and the working time is “26” hours, so that “value added per hour” is “15,000”. Calculated as a yen. Similarly, “value added per hour” for surgery is “10,000” yen, “value added per hour” for pharmacy is “4,000” yen, and “value added per hour” for radiology is “10,000”. Calculated as “yen”.

  As a result, it is possible to accurately and easily grasp the “value added per hour” based on the profit (income-expense) for each department, and to practice the management of amoeba management.

2. Other Embodiment 2-1. Non-aggregation process In the above embodiment, the medical data of the income data is aggregated with the clinical department based on the disease name and the clinical department based on the doctor as the first key and the second key, respectively. The in-hospital cooperation costs and income may be recorded in the back-up process.

2-2. ASP
In the said embodiment, although the revenue allocation apparatus 1 demonstrated the example which processes independently, income data is acquired from the other computer apparatus via a network, and the division | segmentation balance improvement table is made into the said computer apparatus. It may be in a form (ASP) for transmission.

  Specifically, when the revenue data terminal transmits revenue data to the revenue allocation server, the revenue allocation server performs the same processing as the revenue allocation device 1. Then, as a processing result, a “departmental balance improvement table” corresponding to the total data 2081 for each department shown in FIG. 10 is transmitted to the income data terminal. Thereby, the “value added per hour” can be grasped in the income data terminal.

2-3. Aggregation order In the above embodiment, the total income for the medical department based on the name of the disease is calculated first, and then the total income for the medical department based on the doctor is calculated. May be calculated, and the total income for the department based on the disease name may be calculated later.

  That is, in this case, the medical department based on the doctor is the first key, and the medical department based on the disease name is the second key. For this reason, once the medical income is recorded in the medical department based on the doctor, the medical income is returned to the medical department based on the disease name.

2-4. Single data In the above embodiment, the revenue data composed of a plurality of data records is acquired and processed from the medical accounting system. However, the single data record is acquired and processed. May be. For example, each time the income data is generated, the total income may be recalculated for each clinical department, and the medical income may be reversed based on the input income data.

2-5. In the above embodiment, the medical revenue generated by the in-hospital cooperation is configured to be fully refunded to the original medical department. However, only a part of the medical revenue is allocated based on the preset recall rate. You may make it return.

2-6. Other Fields In the embodiment described above, an example in the case of the medical industry has been described, but application to other fields is also possible. For example, when a certain numerical value is allocated, there are a plurality of conditions for determining an allocation destination. This is the case when a teacher performs an off-charge in school management, or a lawyer performs an off-charge at a law office.

2-7. Other Implementation Methods In the embodiment described above, this is implemented by software using a CPU in order to implement the functions shown in FIG. However, some or all of them may be realized by hardware such as a logic circuit. In addition, you may make it make an operating system (OS) process a part of program further.

It is a functional block diagram of a revenue allocation apparatus. It is a figure which shows the hardware constitutions of an income allocation apparatus. It is a figure which shows the example of the flowchart of medical industry income data creation processing. It is a figure which shows the example of the flowchart of a doctor's office cooperation data creation process. It is a figure which shows the example of the flowchart of an action hospital cooperation data creation process. It is a figure which shows the example of income data, a disease name and medical department master, a doctor and medical department master, and an action and medical department master. It is a figure which shows the example of the processing data of income data. It is a figure which shows the example of the processing data of income data. It is a figure which shows the example of the processing data of income data. It is a figure which shows the example of the balance-of-sectors improvement table by department.

Explanation of symbols

  1: Revenue distribution device

Claims (10)

An income distribution device that distributes the medical income for each medical department based on income data including at least medical income,
(X) Revenue data that records at least medical income, disease name, and doctor, disease name / clinical department related information that records the clinical department corresponding to the disease name, and doctor / clinical department related information that records the clinical department corresponding to the doctor A recorded recording section; and
(A) referring to disease name / clinical department related information based on the disease name recorded in the income data, and acquiring a first clinical department acquisition unit corresponding to the disease name;
(B) second medical department acquisition means for referring to doctor / clinical department related information based on the doctor recorded in the income data and acquiring a second medical department corresponding to the doctor;
(C) first total calculation means for calculating medical income recorded in the income data for each first clinical department and calculating a total income for each clinical department;
(E) When there is data in which the first medical department and the second medical department do not match in the income data, the first medical calculation income related to the data is calculated by the first total calculation means. An income distribution apparatus comprising: adjusting means for subtracting from the total income of the second department and adding to the total income of the second medical department calculated by the first total calculation means. In the revenue allocation device according to claim 1,
(D) Secondly, the medical revenue recorded in the revenue data is totaled using the first clinical department and the second clinical department as the first key and the second key, respectively, and a total income for each clinical department is calculated. Further comprising a tally calculation means,
A revenue distribution device characterized by An income distribution device that distributes the medical income for each medical department based on income data including at least medical income,
(X) Revenue data that records at least medical income, disease name, and doctor, disease name / clinical department related information that records the clinical department corresponding to the disease name, and doctor / clinical department related information that records the clinical department corresponding to the doctor A program for realizing, using a computer, an income distribution device having a recorded recording unit, the computer comprising the following means (a) to (e):
(A) referring to disease name / clinical department related information based on the disease name recorded in the income data, and acquiring a first clinical department acquisition unit corresponding to the disease name;
(B) second medical department acquisition means for referring to doctor / clinical department related information based on the doctor recorded in the income data and acquiring a second medical department corresponding to the doctor;
(C) a first tabulation calculation unit that tabulates medical revenue recorded in the revenue data using the first clinical department as a key, and calculates medical revenue for each clinical department;
(E) When there is data in which the first medical department and the second medical department do not match in the revenue data, the first medical calculation revenue related to the data is calculated by the first total calculation means. Adjusting means for subtracting from the total income of the medical department and adding to the total income of the second medical department calculated by the first total calculation means. A revenue allocation system composed of a revenue data terminal and a revenue allocation server that can be connected to the revenue data terminal via a network,
Revenue data terminal
(1) a transmission means for transmitting at least medical income, a disease name, and income data recording a doctor to an income allocation server;
(2) a display means for displaying data indicating the total income for each department received from the revenue allocation server;
Revenue allocation server
(X) a recording unit that records the name of the disease / clinical department related information that records the medical department corresponding to the disease name, and the doctor / clinical department related information that records the clinical department corresponding to the doctor;
(A) referring to disease name / clinical department related information based on the disease name recorded in the income data, and acquiring a first clinical department acquisition unit corresponding to the disease name;
(B) second medical department acquisition means for referring to doctor / clinical department related information based on the doctor recorded in the income data and acquiring a second medical department corresponding to the doctor;
(C) first medical calculation revenue recorded in the income data, using the first clinical department as a key, and calculating a total income for each medical department;
(E) When there is data in which the first medical department and the second medical department do not match in the revenue data, the first medical calculation revenue related to the data is calculated by the first total calculation means. Adjusting means for subtracting from the total income of the medical departments of the medical department and adding to the total income of the second medical departments totaled in the first total calculation means,
(F) A revenue distribution system comprising a transmission means for transmitting data indicating the total revenue for each department to the revenue data terminal. A numerical value distribution device that distributes the numerical values for each aggregated item based on input data including at least numerical values,
(X) Input data that records at least a numerical value, the first item, and the second item, first item / total item related information that records a total item corresponding to the first item, and a total item corresponding to the second item A recording unit that records the recorded second item / total item related information;
(A) a first total item obtaining unit that obtains a first total item corresponding to the first item by referring to the first item / total item related information based on the first item recorded in the input data; ,
(B) second total item acquisition means for referring to the second item / total item related information based on the second item recorded in the input data and acquiring a second total item corresponding to the second item; ,
(C) first total calculation means for calculating the numerical value recorded in the input data using the first total item as a key, and calculating a numerical total for each total item;
(E) In the case where there is data in which the first tabulation item and the second tabulation item do not match in the input data, the first total calculated by the first tabulation calculation means A numerical value distribution apparatus comprising: adjusting means for subtracting from the numerical value sum of the total items of the second item and adding to the numerical value sum of the second total item calculated by the first total calculation unit. A numerical value distribution device that distributes the numerical values for each aggregated item based on input data including at least numerical values,
(X) Input data that records at least a numerical value, the first item, and the second item, first item / total item related information that records a total item corresponding to the first item, and a total item corresponding to the second item A program for realizing, using a computer, a revenue allocation apparatus having a recording unit that records recorded second item / total item related information, and comprises the following means (a) to (e) in the computer A program characterized by:
(A) a first total item obtaining unit that obtains a first total item corresponding to the first item by referring to the first item / total item related information based on the first item recorded in the input data; ,
(B) second total item acquisition means for referring to the second item / total item related information based on the second item recorded in the input data and acquiring a second total item corresponding to the second item; ,
(C) first total calculation means for calculating the numerical value recorded in the input data using the first total item as a key, and calculating a numerical total for each total item;
(E) In the case where there is data in which the first tabulation item and the second tabulation item do not match in the input data, the first total calculated by the first tabulation calculation means Adjusting means for subtracting from the sum of numerical values of the total items and adding to the sum of numerical values of the second total items calculated by the first total calculation means. An income distribution device that distributes the medical income for each medical department based on income data including at least medical income,
(X) Revenue data that records at least medical income, disease name, and doctor, disease name / clinical department related information that records the clinical department corresponding to the disease name, and doctor / clinical department related information that records the clinical department corresponding to the doctor A recorded recording section; and
(A) first medical department acquisition means for referring to doctor / clinic department related information based on a doctor recorded in the income data and acquiring a first medical department corresponding to the doctor;
(B) referring to disease name / clinical department related information based on the disease name recorded in the income data, and acquiring a second clinical department corresponding to the disease name;
(C) first medical calculation revenue recorded in the income data, using the first clinical department as a key, and a first total calculation means for calculating a total income for each medical department;
(D) Secondly, the medical revenue recorded in the revenue data is totaled using the first clinical department and the second clinical department as the first key and the second key, respectively, and a total income for each clinical department is calculated. Total calculation means of
(E) When there is data in which the first medical department and the second medical department do not match in the revenue data, the first medical calculation revenue related to the data is calculated by the first total calculation means. An income distribution apparatus comprising: adjusting means for subtracting from the total income of the second department and adding to the total income of the second medical department calculated by the first total calculation means. An income distribution device that distributes the medical income for each medical department based on income data including at least medical income,
(X) Revenue data that records at least medical income, disease name, and doctor, disease name / clinical department related information that records the clinical department corresponding to the disease name, and doctor / clinical department related information that records the clinical department corresponding to the doctor A recorded recording section; and
(A) referring to disease name / clinical department related information based on the disease name recorded in the income data, and acquiring a first clinical department acquisition unit corresponding to the disease name;
(B) second medical department acquisition means for referring to doctor / clinical department related information based on the doctor recorded in the income data and acquiring a second medical department corresponding to the doctor;
(E) In the income data, when the first clinical department and the second clinical department do not match, the medical income related to the data is subtracted from the medical income of the first clinical department, and the first 2. An income distribution apparatus comprising an adjusting means for adding to the medical income of the second medical department. An income allocation method that allocates the medical income for each department based on income data including at least medical income,
(X) Revenue data that records at least medical income, disease name, and doctor, disease name / clinical department related information that records the clinical department corresponding to the disease name, and doctor / clinical department related information that records the clinical department corresponding to the doctor Record it,
(A) referring to disease name / clinical department related information based on the disease name recorded in the income data, and acquiring a first clinical department corresponding to the disease name;
(B) a second clinical department acquisition step of referring to doctor / clinical department related information based on the doctor recorded in the income data and acquiring a second clinical department corresponding to the doctor;
(C) a first tally calculating step of tallying medical income recorded in the income data using the first medical department as a key and calculating medical income for each medical department;
(E) When there is data in which the first medical department and the second medical department do not match in the revenue data, the first income obtained by totaling the medical revenue related to the data in the first total calculation step An income distribution method comprising: an adjustment step of subtracting from the total income of the medical department and adding to the total income of the second medical department totaled in the first total calculation step. Based on input data including at least a numerical value, the numerical value allocation method distributes the numerical value for each aggregation item,
(X) Input data that records at least a numerical value, the first item, and the second item, first item / total item related information that records a total item corresponding to the first item, and a total item corresponding to the second item Record the recorded second item / total item related information,
(A) referring to the first item / total item related information based on the first item recorded in the input data, and acquiring a first total item corresponding to the first item; ,
(B) a second total item acquisition step of referring to the second item / total item related information based on the second item recorded in the input data and acquiring a second total item corresponding to the second item; ,
(C) a first total calculation step of calculating the numerical values recorded in the input data by using the first total item as a key and calculating a numerical total for each total item;
(E) In the case where there is data in which the first tabulation item and the second tabulation item do not match in the input data, the first numerical value summed up in the first tabulation calculation step A numerical value distribution method comprising: an adjustment step of subtracting from the numerical value sum of the total items and adding to the numerical value sum of the second total items calculated in the first total calculation step.

Images