JP2010122757A - Apparatus, method and program for managing waiting hour data - Google Patents

Abstract

<P>PROBLEM TO BE SOLVED: To efficiently acquire data about the waiting hours or the like of service recipients at a service providing facility. <P>SOLUTION: An information processing apparatus 1 sets a predetermined medical examination department code (S502) if there is a medical examination department yet to be processed (Y at S501). The information processing apparatus extracts the record of the corresponding medical examination department code from work data 15A for a certain patient on the day of a medical examination (S503), and searches for events from reception to accounting (S504). Next, the information processing apparatus searches for the event immediately before the start of the medical examination (S505), and searches for the event immediately before an accounting calculation (S506). The apparatus then calculates waiting hours for the medical examination (S507), and calculates the time of the medical examination (S508). If a setting for counting revisits to the same branch is not made (N at S510), the apparatus returns to S501. If there is no medical examination department yet to be processed (N at S501), the apparatus calculates waiting hours for the accounting (S511), and calculates the time that the patient stayed in the hospital (S512). Further, the apparatus adds a record with each item preset to the data 15B of waiting hours or the like in a storage unit 15 (S513). <P>COPYRIGHT: (C)2010,JPO&INPIT

Description

  The present invention relates to a waiting time data management apparatus, a waiting time data management method, and a waiting time data management program for calculating and storing data including service waiting time of a service recipient in a service providing facility.

In a hospital, data such as patient waiting time, examination time, staying time, and number of patients are useful for hospital service and management management. Patent Document 1 discloses a system that accurately predicts a waiting time until a service is received.
JP 2006-277609 A

However, in order to acquire such data as waiting time, data such as the reception time and start time of each patient are measured and statistical processing is performed. However, many manual operations are required. ,It takes time and effort.
The present invention has been made in view of the above problems, and a main object thereof is to efficiently acquire data such as waiting time of a service recipient in a service providing facility.

In order to solve the above-mentioned problems, the present invention is a waiting time data management apparatus for calculating and storing data including service waiting time of a service recipient in a service providing facility, wherein the service providing facility includes each service recipient. Means for storing business data consisting of a plurality of records including events indicating the start and end of each service included in a series of services provided to the service, date and time thereof, and service recipient identification information; and Means for extracting a record including service recipient identification information and date, and the occurrence time of the immediately preceding event that is an event that occurred immediately before the start time of the service by specifying a start time of a predetermined service in the extracted record Subtracting the occurrence time of the immediately preceding event from the start time of the service, Means for storing the subtraction value as the service waiting time according to a predetermined service receiving identification information and date, characterized in that it comprises a.
According to this configuration, the service waiting time of the service recipient can be efficiently determined by searching for the time when the immediately preceding event has occurred and starting the service waiting time from the service starting time and the immediately preceding event time. I can grasp it well.

In addition, the present invention is a waiting time data management device that calculates and stores data including patient service waiting time in a hospital, and is included in a series of services provided to each patient by each department of the hospital. Means for storing business data including a plurality of records including events indicating the start and end of each service including the start of examination, date and time thereof, patient identification information, and clinical department identification information, and predetermined patient identification from the business data Means for extracting a first record including information and date, means for extracting a second record including predetermined medical department identification information from the first record, and specifying a diagnosis start time in the second record Means for searching for the occurrence time of the event immediately before the diagnosis start time in the first record, and the occurrence of the immediately preceding event from the diagnosis start time. The time is subtracted, characterized in that it comprises means for storing the subtraction value given patient identification information, as examination latency according to date and department identification information.
According to this configuration, the time when the immediately preceding event occurs at the start time of the diagnosis of the predetermined department is searched from the record in which the departments are mixed, and the waiting time of the service is obtained from the start time of the diagnosis and the occurrence time of the immediately preceding event. Therefore, it is possible to accurately grasp the waiting time for a patient who has received a plurality of departments.

The present invention is the waiting time data management device, wherein the business data includes a record including a diagnosis end as the event, and means for specifying a diagnosis start time and a diagnosis end time in the second record; And means for subtracting the examination start time from the examination end time and storing the subtracted value as examination time relating to predetermined patient identification information, date and department identification information.
According to this configuration, the examination time can be accurately grasped.

The present invention is the waiting time data management device, wherein the business data includes a record including accounting calculation as the event, specifies accounting calculation time in the second record, and the first record And the means for searching for the occurrence time of the event immediately before the accounting calculation time and setting it as the pre-accounting event time in the second record, and the latest accounting calculation time and the latest pre-accounting event time in the second record. Means for searching, and means for subtracting the latest pre-accounting event time from the latest accounting calculation time, and storing the subtracted value as accounting waiting time for predetermined patient identification information and date. Features.
According to this configuration, when a patient has received a plurality of departments, the accounting waiting time is obtained from the last accounting calculation time and the last pre-accounting event time, so that the accounting waiting time can be accurately grasped. it can.

The present invention is the waiting time data management device, wherein the business data includes a record including reception and payment as the event, and searches for the earliest reception time and latest payment time in the second record. And means for subtracting the earliest reception time from the latest payment time and storing the subtraction value as hospital stay time related to predetermined patient identification information and date.
According to this configuration, when the patient is receiving a plurality of medical departments, the hospital stay time is obtained from the first reception time and the last payment time, so the hospital stay time can be accurately grasped.

  The present invention includes a waiting time data management method and a waiting time data management program. In addition, the problems disclosed in the present application and the solutions thereof will be clarified by the column of the best mode for carrying out the invention and the drawings.

  ADVANTAGE OF THE INVENTION According to this invention, data, such as a service recipient's waiting time in a service provision facility, can be acquired efficiently.

  Hereinafter, the best mode for carrying out the present invention will be described with reference to the drawings. An information processing apparatus (waiting time data management apparatus) according to an embodiment of the present invention is an event related to each service recipient in a service providing facility (for example, in the case of a hospital, reception for each department, examination, accounting, payment) The date and time are stored, and the waiting time, stay time, etc. of the service recipient in a predetermined period are calculated from the stored data. According to this, it is useful for service management and business management in a service providing facility. Below, the example of a hospital is demonstrated as a service provision facility.

≪Device configuration and overview≫
FIG. 1 is a diagram illustrating a configuration of the information processing apparatus 1. The information processing apparatus 1 includes a communication unit 11, a display unit 12, an input unit 13, a processing unit 14, and a storage unit 15. The communication unit 11 is a part that performs IP communication with another device (for example, a terminal installed in each medical department of a hospital) via a network, and is realized by, for example, a NIC (Network Interface Card) or the like. The display unit 12 is a part that displays data according to an instruction from the processing unit 14, and is realized by, for example, a liquid crystal display (LCD). The input unit 13 is a part where an operator inputs data (for example, data such as a patient's name and event time), and is realized by, for example, a keyboard or a mouse. The processing unit 14 transfers data between the units and controls the information processing apparatus 1 as a whole, and is realized by a CPU (Central Processing Unit) executing a program stored in a predetermined memory. Is done. The storage unit 15 stores data from the processing unit 14 and reads the stored data, and is realized by, for example, a nonvolatile storage device such as a flash memory or a hard disk device. The information processing apparatus 1 may be a stand-alone apparatus (PC (Personal Computer) or the like), or may be an apparatus (server or the like) that can communicate with a plurality of terminals via a network. . In the case of a stand-alone device, data is acquired from the input unit 13 and the data is displayed on the display unit 12. In the case of a device that can communicate with a plurality of terminals, the communication unit 11 transmits and receives data to and from the terminal, and the terminal acquires and displays data.

<< Data structure >>
2 and 3 are diagrams illustrating the configuration of data stored in the storage unit 15 of the information processing apparatus 1. These data are stored in a DB (Data Base) constructed in the storage unit 15. The DB is constructed by, for example, SQL which is a relational database language.

  FIG. 2A shows the configuration of the business data 15A. The business data 15A stores various data related to the patient and the hospital for each event related to the patient in the hospital (start, end, etc. of the hospital). The business ID 15A1, the date 15A2, the time 15A3, the patient number 15A4, Includes medical department code 15A5, reservation status 15A6, reservation start time 15A7, doctor number 15A8, test status 15A9, terminal number 15A10, entrance / exit flag 15A11, referral status 15A12, first visit 15A13, deletion flag 15A14 and final test result 15A15 Consists of records. The data of each item is set by the character variable type.

  The business ID 15A1 indicates an ID unique to the event related to the business provided to the patient by the hospital. A (reception), b (diagnosis start), c (examination end), d (accounting reception), e (accounting) Calculation), f (payment), g (start of inspection), h (end of inspection), etc. are set. The date 15A2 is the date (year / month / day) of the event. Time 15A3 is the time (hour minute second) of the event. Patient number 15A4 is a number unique to the patient. The clinical department code 15A5 is a code unique to the medical department that the patient visits. Reservation presence / absence 15A6 indicates whether or not there is a reservation from a patient in advance, and 1 (with reservation) or 2 (without reservation) is set. The reservation start time 15A7 is a start time (hours, minutes, seconds) of a diagnosis reserved in advance. The doctor number 15A8 is a number unique to the doctor.

  The inspection presence / absence 15A9 indicates whether or not an inspection is performed on the patient, and is set to 1 (with inspection) or 2 (without inspection). The terminal number 15A10 is a number unique to the terminal from which the business data is acquired. The entrance / exit flag 15A11 indicates whether the patient is hospitalized or outpatient, and 1 (hospital) or 2 (outpatient) is set. The introduction presence / absence 15A12 indicates whether or not the patient has been introduced by another, and 1 (with introduction) or 2 (without introduction) is set. The first revisit 15A13 indicates whether the patient is a first visit or revisit, and 1 (first visit) or 2 (revisit) is set. The deletion flag 15A14 is a flag for invalidating the record once created, and becomes invalid when 1 (deletion) is set. The final inspection result 15A15 is a flag indicating that the inspection result is final, and 1 (when the inspection result is final) is set.

  FIG. 2B shows the data structure of the waiting time data 15B. The waiting time data 15B is for creating a record including waiting time for each date, patient number, and clinical department code from the business data 15A. The date 15B1, patient number 15B2, clinical department code 15B3, clinical department name 15B4, Doctor number 15B5, Doctor name 15B6, Reception time 15B7, Reservation time 15B8, Pre-examination event time 15B9, Examination start time 15B10, Examination end time 15B11, Pre-accounting event time 15B12, Accounting calculation time 15B13, Payment time 15B14, Examination waiting time 15B15, examination time 15B16, accounting waiting time 15B17, and record including hospital stay time 15B18.

  Date 15B1 is the date on which the patient visited the department. Patient number 15B2 is a number unique to the patient. The medical department code 15B3 is a code unique to the medical department. The department name 15B4 is the name of the department. The doctor number 15B5 is a number unique to the doctor who examined the patient. The doctor name 15B6 is the name of the doctor. Reception time 15B7 is the time when the patient is received. The reservation time 15B8 is a diagnosis start time when a reservation is made in advance. The pre-examination event time 15B9 is recorded with the occurrence time (including the reservation time) of the event immediately before the examination.

  The examination start time 15B10 is the time when the examination of the patient in the department is started. The examination end time 15B11 is the time when the examination of the patient in the department is completed. The pre-accounting event time 15B12 is a record of the event occurrence time immediately before the accounting calculation. The accounting calculation time 15B13 is the time when accounting for the patient is calculated. The payment time 15B14 is the time when the patient paid for the transaction. The examination waiting time 15B15 is the time that the patient has been waiting for the examination, and is calculated from “diagnosis start time 15B10−pre-examination event time 15B9”. The examination time 15B16 is a time when the patient is undergoing a medical examination, and is calculated by “medical examination end time 15B11-medical examination start time 15B10”. The accounting waiting time 15B17 is the time when the patient is waiting for accounting. The hospital stay time 15B18 is a time during which the patient stays in the hospital. Note that the accounting waiting time 15B17 and the hospital staying time 15B18 are set not for all medical departments but for records of specific medical departments.

  FIG. 3A shows the data structure of the doctor-specific data 15C. The doctor-specific data 15C is obtained by counting the waiting time data 15B for each doctor. The doctor number 15C1, the doctor name 15C2, the department code 15C3, the department name 15C4, the average waiting time 15C5, and the waiting time 15C6 , Examination time average 15C7, Examination time number 15C8, Examination waiting time average (with reservation) 15C9, Examination waiting time number (with reservation) 15C10, Examination waiting time average (without reservation) 15C11 and Examination waiting time number (without reservation) 15C12 Consists of records that contain The doctor number 15C1 is a number unique to the doctor. The doctor name 15C2 is the name of the doctor. The clinical department code 15C3 is a code unique to the medical department to which the doctor belongs. The medical department name 15C4 is the name of the medical department. The medical examination waiting time average 15C5 is an average value of the medical examination waiting time relating to the doctor. The number 15C6 of examination waiting time is the number of examination waiting times related to the doctor. The consultation time average 15C7 is an average value of the consultation time concerning the doctor. The number of examination hours 15C8 is the number of examination hours related to the doctor. The medical examination waiting time average (with reservation) 15C9 is an average value of the medical examination waiting time with reservation for the doctor concerned. The number of waiting times for consultation (with reservation) 15C10 is the number of waiting times for consultation with the doctor concerned. The medical examination waiting time average (no reservation) 15C11 is an average value of the medical examination waiting time without reservation for the doctor concerned. The number of consultation waiting times (no reservation) 15C12 is the number of consultation waiting times without reservation for the doctor concerned.

  FIG. 3B shows the data structure of the department-specific data 15D. The data 15D for each medical department is a summary of the waiting time data 15B for each clinical department, and includes the clinical department code 15D1, the name of the medical department 15D2, the average waiting time for the diagnosis 15D3, the number of waiting times for the diagnosis 15D4, the average diagnosis time 15D5, It consists of records including a consultation time number 15D6, a consultation waiting time average (with reservation) 15D7, a consultation waiting time number (with reservation) 15CD8, a consultation waiting time average (without reservation) 15D9, and a consultation waiting time number (without reservation) 15D10. The medical department code 15D1 is a code unique to the medical department. The department name 15D2 is the name of the department. The examination waiting time average 15D3 is an average value of the examination waiting time relating to the medical department. This is the number of waiting times for examination 15D4, the number of waiting times for examination related to the department concerned. The examination time average 15D5 is an average value of the examination time according to the medical department. The number of examination hours 15D6 is the number of examination hours related to the medical department. The examination waiting time average (with reservation) 15D7 is an average value of the examination waiting time with reservation for the medical department concerned. The number of waiting times for medical examination (with reservation) 15CD8 is the number of waiting times for medical examination with reservation related to the medical department. The average examination waiting time (no reservation) 15D9 is an average value of the waiting time for examination without reservation for the relevant department. The number of waiting times for medical examination (no reservation) 15D10 is the number of waiting times for medical examination without reservation related to the medical department.

≪Device processing≫
FIG. 4A is a flowchart showing the data search process (1/2) by the information processing apparatus 1. First, the information processing apparatus 1 acquires a search condition (S401). Search conditions include start date, end date, search target (all clinical departments, each clinical department, individual calculation [internal medicine, surgery, ...]), calculation target (examination waiting time, examination time), etc. Is done. Next, it is determined whether or not the acquired search condition is valid (S402). Specifically, it is correct that the start date is earlier than the end date, the period from the start date to the end date is within one week, and the search target data exists in the business data 15A. Check. If the search condition is not valid (N in S402), an error message is displayed on the display unit 12 (S403), and the data search process is terminated. An error message may be transmitted from the communication unit 11 to the terminal.

  If the search condition is valid (Y in S402), a DB reread flag is created (S404). The DB reread flag is set to TRUE (value = 1) if the necessary business data 15A is loaded in the memory and need not be read from the DB of the storage unit 15. On the other hand, since there is no necessary business data 15A, if re-reading is necessary, FALSE (value = 0) is set. Specifically, comparing the current search condition with the previous search condition, if the search period, the same-family check and the entry / exit conditions are the same, the DB reload flag is set to TRUE. If the DB re-read flag is TRUE (Y in S405), the data processing is skipped and the graph display is performed (S430 in FIG. 4B).

  If the DB reread flag is FALSE (N in S405), the business data 15A is read from the DB of the storage unit 15 into the memory (S406). Then, it is determined whether or not an inpatient is excluded from the calculation on the calculation condition and display condition setting screen (see FIG. 6) (S407). If the selection to exclude the inpatient is made (Y in S407), the record of the inpatient is deleted from the business data 15A on the memory (S408). Since the in / out flag 15A11 is set to 1 for the record of the inpatient, the record corresponding to it is deleted. If it is not selected to exclude hospitalized patients (N in S407), the process of S408 is skipped.

  Subsequently, the business data 15A is narrowed down according to the search period (S409). Specifically, a record in which the date 15A2 is included between the start date and the end date of the search condition is extracted from the business data 15A on the memory. This is to narrow down the business data 15A and improve the processing efficiency, and such a period limitation is not necessarily required. Next, it is determined whether or not there is a record of revisiting the same department in the narrowed down business data 15A (S410). Specifically, it is searched whether or not the business ID 15A1 is a: “diagnosis start” and the clinical department code 15A5 has the same record. If there is a record from the same department (Y in S410), the subsequent record is deleted (S411). If there is no record of the same department revisited (N in S410), the process proceeds to the next process. This is a process in the case where it is set not to count the same family revisit on the setting screen of FIG. 6, and if it is set to count, it is not necessary to delete the record.

  FIG. 4B is a flowchart showing data search processing (2/2) by the information processing apparatus 1. Subsequently, the information processing apparatus 1 performs a process of calculating a waiting time for each patient and each examination date from the business data 15A narrowed down by the search period. First, it is determined whether there is an unprocessed patient (S421). Since all patients are unprocessed at first (Y in S421), a patient number to be processed is set (S422). Here, for example, patient numbers are set in the work memory in order from the smallest, and the patient number currently being processed is specified. And the record of the set patient number is extracted from the work data 15A narrowed down by the search period (S423).

  Furthermore, it is determined whether there is an unprocessed examination date (S424). Initially, since all the examination dates within the search period are unprocessed (Y in S424), the examination date to be processed is set (S425). Here, for example, examination dates are set in the work memory in order from the earliest, and the examination date currently being processed is specified. And the record of the set consultation date is extracted from the record extracted by S423 (S426). The waiting time is calculated from the extracted record (S427). By the process of S427, a record of data 15B such as waiting time is generated for each date, patient number, and department code. Details of the processing will be described separately.

  In S424, if there is no unprocessed medical examination date (N in S424), the processing related to the record of the patient number has been completed, so the determination in S421 is performed in order to perform processing related to the record of the next patient number. .

  In S421, if there is no unprocessed patient (N in S421), the processing relating to the records of all patient numbers is completed. Subsequently, the waiting time data 15B is aggregated for each doctor, and is set as doctor-specific data 15C (S428). Specifically, a record in which the doctor name 15B6 is a predetermined name is extracted from the records of the waiting time etc. data 15B. The average value of the examination waiting time 15B15 of the extracted record is set to the examination waiting time average 15C5 of the doctor-specific data 15C. The number of extracted records is set to the examination waiting time number 15C6. The average value of the examination time 15B16 of the extracted record is set to the examination time average 15C7. The number of extracted records is set to the number of examination hours 15C8.

  Further, among the extracted records, the average value of the examination waiting time 15B15 of the record having the valid reservation time 15B8 is set to the examination waiting time average (with reservation) 15C9. Among the extracted records, the number of records for which the reservation time 15B8 is valid is set to the number of waiting times for examination (with reservation) 15C10. Among the extracted records, the average value of the examination waiting time 15B15 of the record with the invalid reservation time 15B8 is set as the examination waiting time average (no reservation) 15C11. Among the extracted records, the number of records whose reservation time 15B8 is invalid is set as the number of waiting times for examination (no reservation) 15C12.

  Next, the waiting time data 15B is aggregated for each medical department, and is set as data 15D by medical department (S429). Specifically, a record in which the department name 15B4 is a predetermined department name is extracted from the records of the waiting time data 15B. The average value of the examination waiting time 15B15 of the extracted record is set to the examination waiting time average 15D3 of the department-specific data 15D. The number of extracted records is set to the examination waiting time number 15D4. The average value of the examination time 15B16 of the extracted record is set to the examination time average 15D5. The number of extracted records is set to the examination time number 15D6.

  Furthermore, among the extracted records, the average value of the examination waiting time 15B15 of the record having the valid reservation time 15B8 is set to the examination waiting time average (with reservation) 15D7. Among the extracted records, the number of records for which the reservation time 15B8 is valid is set to the number of waiting times for examination (with reservation) 15D8. Of the extracted records, the average value of the examination waiting time 15B15 of the record with the invalid reservation time 15B8 is set to the examination waiting time average (no reservation) 15D9. Among the extracted records, the number of records whose reservation time 15B8 is invalid is set to the number of waiting times for examination (no reservation) 15D10.

  Then, the information processing apparatus 1 displays a graph relating to the waiting time or the like on the display unit 12 based on the waiting time or the like data 15B, the doctor-specific data 15C, and the department-specific data 15D (S430). Display examples of the graph are shown in FIGS. FIG. 7 is a graph showing the average value of the examination waiting time and the number of examinations in all the departments. FIG. 8 is a graph showing hospital stay time.

  In the column for selecting a department as a search condition target in FIG. 7, a combo box including all the department codes and department names is created in advance, and the combo box is displayed and selected from the combo box. Shall. The same applies to a doctor number and a doctor name when a doctor is separately selected.

  FIG. 5 is a flowchart showing calculation processing such as waiting time in S427 of FIG. 4B. In this process, the waiting time and the like for each department are calculated from the business data extracted on the patient and the examination date.

  First, the information processing apparatus 1 determines whether there is an unprocessed medical department (S501). Since all medical departments are unprocessed at first (Y in S501), a medical department code to be processed is set (S502). Here, for example, the department code is set in the work memory in order from the smallest, and the department code currently being processed is specified. Then, a record of the set clinical department code is extracted (S503), and data processing (S504 to S509) related to the clinical department code is performed. The information processing apparatus 1 searches for each event from patient reception to payment (S504). Specifically, among the extracted records of the business data 15A, records whose business ID 15A1 is a (reception) to f (payment) are searched, and the existence of each record is confirmed. Here, for the pairing of the “start” and “end” times, such as when the work ID 15A1 is b (examination start) and c (examination end), g (examination start) and h (examination end), basically Pair the nearest end time after the start time. When the time data is missing and two or more times match, the closest one is paired.

  Next, the information processing apparatus 1 searches for an event immediately before the start of the diagnosis (S505). This is to search for the event (including the reservation time) immediately before the diagnosis start time from the record of the diagnosis date extracted in S426 (the clinical departments are mixed), but the business ID 15A1 is e (accounting calculation) and f ( Payment). Then, the time 15A3 of the corresponding record is set as the pre-examination event time 15B9 of the waiting time data 15B. Subsequently, an event immediately before the accounting calculation is searched (S506). This is to search for the event immediately before the accounting from the record of the examination date extracted in S426 (mixed medical departments). Then, the time 15A3 of the corresponding record is set as the pre-accounting event time 15B12 of the waiting time data 15B.

  Here, in the record of the examination date in which a plurality of clinical departments are mixed, searching for an event immediately before a predetermined event is not necessarily the same medical department immediately before. This is because it is possible to correctly grasp the waiting time of the patient if the last event is identified.

  Next, the information processing apparatus 1 calculates a consultation waiting time (S507). In this process, first, the time 15A3 of the record whose work ID 15A1 is b (diagnosis start) is set to the diagnosis start time 15B10 of the waiting time data 15B. Then, in the waiting time data 15B, a value obtained by subtracting the pre-diagnosis event time 15B9 from the diagnosis start time 15B10 is set as the diagnosis waiting time 15B15.

  Next, the information processing apparatus 1 calculates a consultation time (S508). In this process, first, the time 15A3 of the record whose work ID 15A1 is c (examination end) is set as the end-of-examination time 15B11 of the waiting time data 15B. Then, in the waiting time data 15B, a value obtained by subtracting the examination start time 15B10 from the examination end time 15B11 is set as the examination time 15B16. Of the waiting time data 15B, regarding the reception time 15B7, the accounting calculation time 15B13, and the payment time 15B14, the business ID 15A1 is set to the time 15A3 of the record of a (reception), e (accounting calculation), and f (payment). Shall be.

  The information processing apparatus 1 adds the record in which each item is set to the waiting time data 15B of the storage unit 15 (S509). Then, it is determined whether or not it is set to count the same department multiple visits (S510). This is to confirm whether or not “Counterpart revisited” is set to “Count” on the setting screen of FIG. If the setting is made (Y in S510), there is a possibility that a record indicating a series of events (acceptance to payment) related to the clinical department may exist, and therefore the search after S504 is performed again.

  If the setting is not made (N in S510), it is considered that there is no record of a series of events relating to the medical department, and the process returns to the determination in S501 to process the next medical department. If there is no unprocessed medical department (N in S501), the processing of all the medical departments is completed, and thus processing that requires data 15B such as waiting time of each medical department is performed.

  First, the information processing apparatus 1 calculates the accounting waiting time (S511). In this process, the latest pre-accounting event time 15B12 and the latest accounting calculation time 15B13 are extracted from the waiting time data 15B of each department. Then, the pre-accounting event time 15B12 is subtracted from the extracted accounting calculation time 15B13, and the subtraction value is set as the accounting waiting time 15B17 in the record of the latest pre-accounting event time 15B12. This is for grasping the accounting waiting time at the last accounting calculation time when the patient is receiving a plurality of medical departments.

  Next, the information processing apparatus 1 calculates hospital stay time (S512). In this process, the earliest reception time 15B7 and the latest payment time 15B14 are extracted from the waiting time data 15B of each department. Then, the reception time 15B7 is subtracted from the extracted payment time 15B14, and the subtraction value is set as the hospital stay time 15B18 in the record of the latest payment time 15B14. This is because if a patient visits multiple departments in a day, the patient will be accepted at the first department and stay at the hospital until payment is made at the last department. is there.

  Further, the information processing apparatus 1 adds a record in which each item is set to the waiting time data 15B of the storage unit 15 (S513).

<Example>
FIG. 9 is a diagram illustrating examples of the business data 15A and the waiting time data 15B. FIG. 9A shows a first record group in which data including a predetermined patient number and date is extracted from the business data 15A. FIG. 9B shows a second record group obtained by extracting a record including a predetermined clinical department code from the first record group shown in FIG. FIG. 9C shows waiting time data 15B created from the first record group of FIG. 9A and the second record group of FIG. 9B.

  A specific example of the processing of S505 and S506 of FIG. 5 will be described with reference to FIG. When searching for an event immediately before the start of the diagnosis in S505, first, a record with the business ID b: “start of diagnosis” is identified from the second record group. As a result, the second record from the top in FIG. 9B is specified. Next, in the first record group, the time immediately before the time 13:10 of the record is searched. As a result, the second record from the top in FIG. 9A is specified. Then, the time 12:14 of the record is set to the pre-examination event time of the first record from the top in the waiting time data 15B of FIG. 9C.

  When searching for an event immediately before the accounting calculation in S506, first, a record having a business ID of e: “accounting calculation” is specified from the second record group. As a result, the second record from the bottom in FIG. 9B is specified. Next, in the first record group, the time immediately before the time 16:05 of the record is searched. However, the record whose business ID is e: “accounting calculation” is excluded. As a result, the fourth record from the bottom in FIG. 9A is specified. Then, the time 15:40 of the record is set to the pre-accounting event time of the first record from the top in the waiting time data 15B of FIG. 9C.

  Although the embodiment of the present invention has been described above, a program (latency data management program) executed by the processing unit 14 can be read by a computer in order to make each unit in the information processing apparatus 1 shown in FIG. 1 function. It is assumed that the information processing apparatus 1 according to the embodiment of the present invention is realized by recording on a recording medium, causing the computer to read and execute the recorded program. Note that the program may be provided to the computer via a network such as the Internet, or a semiconductor chip or the like in which the program is written may be incorporated in the computer.

  According to the embodiment of the present invention described above, from the record of the business data 15A in which clinical departments are mixed, the time at which the previous event occurred at the time when the predetermined service (diagnosis, accounting) was performed, Since the service waiting time is obtained from the service execution time and the previous event time, it is possible to efficiently grasp the service waiting time (diagnosis waiting time, accounting waiting time) of a patient who has received a plurality of departments. And when the examination waiting time and the accounting waiting time are long, it is an opportunity to improve the operation of the hospital so as to reduce the burden on the patient.

<< Other embodiments >>
Although the best mode for carrying out the present invention has been described above, the above embodiment is intended to facilitate understanding of the present invention and is not intended to limit the present invention. The present invention can be changed and improved without departing from the gist thereof, and equivalents thereof are also included in the present invention. For example, the following embodiments can be considered.

(1) Although the said embodiment showed the example applied to the hospital, if it is a service provision facility which has a series of procedures, it is applicable to others. For example, it can be applied to government offices and banks.

(2) In the above embodiment, the waiting time and staying time of the patient in the hospital are displayed as they are. However, the waiting time, staying time, the number of examinations (number of patients) and the staff operating rate are provided with index values, Signal display in blue, yellow, and red may be performed according to the index value level. In this case, an index value related to the service is provided for the waiting time and the staying time. On the other hand, for the number of examinations (number of patients) and staff availability, index values related to hospital management are set. Thereby, for example, if there is a medical department with an extremely small number of examinations (number of patients), there is a possibility that the department is in a deficit, which is useful for the judgment related to hospital management.

1 is a diagram illustrating a configuration of an information processing device 1. FIG. It is a figure which shows the structure of the data memorize | stored in the memory | storage part 15 of the information processing apparatus 1, (a) shows the structure of business data 15A, (b) shows the data structure of data 15B, such as waiting time. It is a figure which shows the structure of the data memorize | stored in the memory | storage part 15 of the information processing apparatus 1, (a) shows the data structure of data 15C according to doctor, (b) shows the data structure of data 15D according to medical department. It is a flowchart which shows the data search process (1/2) by the information processing apparatus. 3 is a flowchart showing data search processing (2/2) by the information processing apparatus 1; It is a flowchart which shows calculation processing, such as waiting time of S427 of FIG. 4B. It is a figure which shows the setting screen of calculation conditions and display conditions. It is a graph which shows the consultation waiting time average value and the number of examinations of all the medical departments. It is a graph which shows hospital stay time. It is a figure which shows the example of business data 15A and data 15B, such as waiting time, (a) shows the 1st record group which extracted the thing containing a predetermined patient number and date from business data 15A, (b) shows (a ) Shows a second record group extracted from the first record group including a predetermined department code, and (c) shows a wait created from the first record group of (a) and the second record group of (b). The time etc. data 15B is shown.

Explanation of symbols

1 Information processing device (waiting time data management device)
14 processing unit 15 storage unit 15A business data (record, first record, second record)
15A1 Business ID (event)
15A2 Date 15A3 Time (Service implementation time)
15A4 Patient number (service recipient identification information, patient identification information)
15B Data such as waiting time 15B1 Date 15B2 Patient number (service recipient identification information, patient identification information)
15B3 clinical department code (clinical department identification information)
15B7 reception time 15B9 pre-examination event time (occurrence time of previous event)
15B10 Examination start time 15B11 Examination end time 15B12 Pre-accounting event time (occurrence time of previous event)
15B13 Accounting calculation time 15B14 Payment time 15B15 Exam waiting time (service waiting time)
15B16 Examination time 15B17 Accounting waiting time (service waiting time)
15B18 Hospital stay time

Claims (11)

A waiting time data management device for calculating and storing data including service waiting time of a service recipient at a service providing facility,
Stores business data including a plurality of records including an event indicating the start and end of each service included in a series of services provided to each service recipient by the service providing facility, its date and time, and service recipient identification information. Means,
Means for extracting records including predetermined service recipient identification information and date from the business data;
Means for identifying the start time of a predetermined service in the extracted record and searching for the occurrence time of a previous event that is an event that occurred immediately before the start time of the service;
Means for subtracting the occurrence time of the previous event from the start time of the service, and storing the subtraction value as the service waiting time relating to predetermined service receiver identification information and date;
A waiting time data management apparatus comprising: A waiting time data management device for calculating and storing data including service waiting time of a patient in a hospital,
A plurality of events including the start and end of each service including the start of examination, date and time, patient identification information, and clinical department identification information included in a series of services provided to each patient by each department of the hospital Means for storing business data consisting of records;
Means for extracting a first record including predetermined patient identification information and date from the business data;
Means for extracting a second record including predetermined medical department identification information from the first record;
Means for specifying a diagnosis start time in the second record and searching for an occurrence time of an event immediately before the diagnosis start time in the first record;
Means for subtracting the occurrence time of the immediately preceding event from the examination start time, and storing the subtraction value as predetermined patient identification information, date and examination waiting time relating to clinical department identification information;
A waiting time data management apparatus comprising: The waiting time data management device according to claim 2,
The business data has a record including the end of the examination as the event,
Means for specifying a diagnosis start time and a diagnosis end time in the second record;
Means for subtracting the examination start time from the examination end time, and storing the subtraction value as examination time according to predetermined patient identification information, date and department identification information;
The waiting time data management device further comprising: The waiting time data management device according to claim 2 or 3,
The business data has a record including accounting calculation as the event,
Means for identifying the accounting calculation time in the second record, searching for the occurrence time of the event immediately before the accounting calculation time in the first record, and setting the event time before accounting in the second record;
Means for searching for the latest accounting time and the latest pre-accounting event time in the second record;
Means for subtracting the latest pre-accounting event time from the latest accounting calculation time, and storing the subtracted value as accounting waiting time for predetermined patient identification information and date;
The waiting time data management device further comprising: The waiting time data management device according to any one of claims 2 to 4,
The business data has a record including acceptance and payment as the event,
Means for searching for the earliest reception time and latest payment time in the second record;
Means for subtracting the earliest reception time from the latest payment time, and storing the subtraction value as hospital stay time according to predetermined patient identification information and date;
The waiting time data management device further comprising: A waiting time data management method for calculating and storing data including service waiting time of a service recipient at a service providing facility,
Information processing device
Stores business data including a plurality of records including an event indicating the start and end of each service included in a series of services provided to each service recipient by the service providing facility, its date and time, and service recipient identification information. Steps,
Extracting a record including predetermined service recipient identification information and date from the business data;
In the extracted record, specifying a start time of a predetermined service and searching for the occurrence time of a previous event that is an event that occurred immediately before the start time of the service;
Subtracting the occurrence time of the immediately preceding event from the start time of the service, and storing the subtraction value as the service waiting time according to predetermined service receiver identification information and date;
The waiting time data management method characterized by performing this. A waiting time data management method for calculating and storing data including service waiting time of a patient in a hospital,
Information processing device
A plurality of events including the start and end of each service including the start of examination, date and time, patient identification information, and clinical department identification information included in a series of services provided to each patient by each department of the hospital Storing business data consisting of records;
Extracting a first record including predetermined patient identification information and date from the business data;
Extracting a second record including predetermined medical department identification information from the first record;
Identifying a diagnosis start time in the second record and searching for an occurrence time of an event immediately before the diagnosis start time in the first record;
Subtracting the occurrence time of the previous event from the examination start time, and storing the subtraction value as predetermined patient identification information, date and examination waiting time related to clinical department identification information;
The waiting time data management method characterized by performing this. The waiting time data management method according to claim 7,
The business data has a record including the end of the examination as the event,
The information processing apparatus includes:
Identifying a diagnosis start time and a diagnosis end time in the second record;
Subtracting the examination start time from the examination end time, storing the subtraction value as the examination time according to predetermined patient identification information, date and department identification information;
The waiting time data management method, further comprising: The waiting time data management method according to claim 7 or claim 8,
The business data has a record including accounting calculation as the event,
The information processing apparatus includes:
Specifying an accounting calculation time in the second record, searching for an occurrence time of an event immediately before the accounting calculation time in the first record, and setting the second record as a pre-accounting event time;
Searching for the latest accounting time and the latest pre-accounting event time in the second record;
Subtracting the latest pre-accounting event time from the latest accounting calculation time, and storing the subtracted value as accounting waiting time according to predetermined patient identification information and date;
The waiting time data management method, further comprising: The waiting time data management method according to any one of claims 7 to 9,
The business data has a record including acceptance and payment as the event,
The information processing apparatus includes:
Searching for the earliest reception time and latest payment time in the second record;
Subtracting the earliest reception time from the latest payment time, and storing the subtraction value as hospital stay time according to predetermined patient identification information and date;
The waiting time data management method, further comprising: A waiting time data management program for calculating data including service waiting time of a service recipient in a service providing facility and causing the information processing apparatus to execute processing to be stored,
Stores business data including a plurality of records including an event indicating the start and end of each service included in a series of services provided to each service recipient by the service providing facility, its date and time, and service recipient identification information. Steps,
Extracting a record including predetermined service recipient identification information and date from the business data;
In the extracted record, specifying a start time of a predetermined service and searching for the occurrence time of a previous event that is an event that occurred immediately before the start time of the service;
Subtracting the occurrence time of the immediately preceding event from the start time of the service, and storing the subtraction value as the service waiting time according to predetermined service receiver identification information and date;
A waiting time data management program comprising: