KR20090000203A

KR20090000203A - Customer relationship management integrative system of management information system in hospital

Info

Publication number: KR20090000203A
Application number: KR1020070009942A
Authority: KR
Inventors: 임성완
Original assignee: 주식회사 에코벨
Priority date: 2007-01-31
Filing date: 2007-01-31
Publication date: 2009-01-07

Abstract

A system for integrating a hospital management information system with a customer relation management system is provided to manage a database of the customer relation management system integrally as an oracle database of the management information system, thereby performing unified data management. A management information system comprises a client server integrally performing an ambulatory practice reservation of patient and health medical examination reservation. A customer relation management system defines a determination reservation and disease class. The determination reservation is performed by determining possibility of reservation by customer medical data and visit history data. The disease class has high clinic induction frequency and possibility. The customer relation management system extracts a customer, who had medical treatment and operation for disease, as an object. The customer relation management system plans transmission time and contents to be transmitted to the customer. The customer relation management system performs a function for recommending and publicizing the clinic to the customer. The customer relation management system automatically confirms reactions of the customer about the transmitted contents, and integrally performs clinic reservation for managing an execution result. An integrated database integrates the management information system and the customer relation management system, and is constructed be interworked in real-time.

Description

Customer relationship management integrative system of management information system in hospital

1 is a configuration diagram of a management information system of a conventional hospital;

2 is a block diagram of a customer relationship management system of a hospital according to a preferred embodiment of the present invention;

3 is a block diagram of integrated reservation management through the customer relationship management system of the hospital according to an embodiment of the present invention,

4 is a flowchart in which a management information system and a customer relationship management system of a hospital according to a preferred embodiment of the present invention are linked in real time by an integrated database;

5 is a flow chart for determining and determining the reservation availability of the patient according to an embodiment of the present invention;

6 is an automated flowchart of promotion and recommendation according to a preferred embodiment of the present invention;

7 is a view showing the difference between the integrated system of the present invention and the conventional non-integrated system.

The present invention relates to an integrated system of a hospital management information system and a customer relationship management system. More particularly, the present invention relates to a hospital management information system and a customer relationship management system that can solve the difficulties of integrated management due to the current distributed reservation system. It relates to an integrated system.

In general, the reservation management system of a hospital is able to systematically manage reservation schedules related to hospital duties such as medical treatment, consultation, and inspection by computerization. In addition, the reservation system can be applied on-site through the customer relationship management system, and reservation management through telephone and reservation management through visits are integrated and managed by the customer relationship management system, and can interface with the management information system. Is implemented.

However, because the database is established by using the reservation module of the existing management information system for the reservation and storing the reservation result in the customer relationship management system and the management information system, the double information is stored in the customer relationship management system and the management information system system. I'm using a way to save.

Accordingly, as described above, since the data is duplicated in the customer relationship management system and the management information system, duplication occurs due to duplication of data, and there is a problem in that reservation registration, modification and cancellation are cumbersome.

The present invention has been made to solve the above problems, and to provide an integrated system of the hospital management information system and customer relationship management system to solve the difficulties of integrated management due to the current distributed booking system.

In addition, integrated management of database of customer relationship management system into Oracle database of management information system provides integrated system of hospital management information system and customer relationship management system that can realize unified data management and real time.

In addition, it provides an integrated system of hospital management information system and customer relationship management system that can strengthen customer management by implementing targeting and grouping function for customers and realizing automatic promotion function by reinforcing promotion management (PR, recommendation) function. It is.

In order to solve the above problems, the integrated management system of the hospital management information system and the customer relationship management system according to the present invention, the management information is provided with a client server to perform the patient's outpatient appointment: and medical examination reservation: System; and customer's basic information and profile information (resident area, gender, social status, age, occupation, disposition, family, etc.) and client's medical data (history, family history, disease code, visit time, clinic, abnormal finding type) Determination reservation to determine the possibility of reservation based on data such as reservation history, etc.), and the frequency of occurrence of clinic and the most likely disease group, and those who have previously received medical treatment and surgery for the disease. After extracting, plan what and when to deliver to the customer, and perform the function of recommending and promoting the clinic to the customer. A clinic reservation that automatically checks the customer's response and manages the execution result: a customer relationship management system that performs integration; and an integrated database built to integrate the management information system and the customer relationship management system in real time; It is characterized by.

The reservation management system is designed to systematically manage reservation schedules related to hospital work such as medical treatment, consultation, and inspection. In addition, the reservation system can be applied on-site through the customer relationship management system, and reservation management through telephone and reservation management through visits are integrated and managed by the customer relationship management system. Implemented to make it possible.

However, by using the reservation module of the existing management information system for the current reservation, the reservation result is stored in the customer relationship management system and the management information system in a dual manner to eliminate the duplication of data by integrated management through the customer relationship management system. Make it easy to register, modify and cancel reservations. Therefore, more detailed customer reservation management is possible.

Since outpatient medical appointment management is required by the organization of outpatient medical examination center, a separate outpatient medical appointment reservation system is developed.

In addition, it enables various reservation management and reservation status through additional development of decision reservation and clinic reservation. And through the customer relationship management system, the reservation business is unified and the customer database is integrated, enabling real-time data interworking and web output of the year-end settlement receipt for the convenience of customers.

It aims for real-time data linkage by integrating customer database between customer relationship management system and management information system. It builds integration and integrates and links to unify existing complicated business logic to operate efficiently.

Integrate into the same database to solve the interface difficulties between the existing MS-SQL database of the customer relationship management system and the Oracle database of the management information system. Accordingly, there is a characteristic that data can be unified through real-time implementation and efficient processing in management information system and customer relationship management system.

Customer's basic information and profile (resident area, gender, social status, age, occupation, disposition, family, etc.) and client's medical data (history, family history, disease code, visit time, clinic, abnormal finding type, reservation history) Etc.) and a list of customers corresponding to the condition data of the customer, such as a history and a visit history. Customer data can be selected in multiple ways according to conditions, and various customer relationship management activities such as medical recommendation, promotion, and special customer group management can be efficiently performed on the extracted customer list.

Next, if you want to recommend the client to the clinic to proceed to the next step.

First, define the frequency and likely disease groups of the clinic.

Second, in the past, the patients who were treated and operated on the disease were extracted.

Third, when and what content will be delivered to the customer, the clinic is delivered to the customer, promoted and recommended.

Finally, it automatically checks the customer's response to the delivery and manages the results of promotion and recommendation.

Next, the function for the above-mentioned promotion and recommendation will be described in more detail.

First, set the target.

Second, secure the customer list by setting the target group.

Third, set up an execution schedule.

Fourth, triggers such as periodic automatic sending and aperiodic temporary sending are set.

Fifth, set contents (delivery contents) to be provided to target person

Sixth, set the delivery channel (text message, telephone advertisement, e-mail, etc.).

Seventh, performance verification results and reaction monitoring.

Finally, we report the execution results and effects.

Next, the features of the present invention will be described in detail with reference to FIG.

Conventionally, the data processing method according to the customer management system of the hospital is separated from the customer relationship management system and the management information system data, but the present invention is characterized by integrating customer relationship management and management information system data into an Oracle database.

In addition, although the conventional work type according to the customer management system of the hospital is complicated in the reservation registration, modification and cancellation due to the duplication of the reservation system, the present invention is easy to register, modify and cancel the reservation by the unification of the reservation system, it is characterized by integrated management to be.

In addition, although there was a difficulty in real-time interworking by the database according to the customer management system of the conventional hospital, the present invention is characterized by the real-time data processing and detailed customer management is possible due to the integration of the database.

In addition, in order to make a medical appointment according to the conventional hospital's customer management system, there was no outpatient medical reservation system, judgment reservation, or click-nic reservation function. In addition, it is possible to manage various reservation types by integrated management and additional development of decision reservation and clinic reservation.

In addition, although the convenience of the conventional hospital's customer management system is not computerized for the year-end settlement receipt, it is characterized by the fact that the end-of-year settlement receipt output through the web can increase the convenience of the customer and increase the work efficiency. .

As described above, the integration of the customer relationship management system and the management information system eliminates the duplication of data through real-time processing and enables more detailed customer management by data integration.

The best embodiments have been disclosed in the drawings and the specification. Although specific terms have been used herein, they are used only for the purpose of describing the present invention and are not intended to limit the scope of the invention as defined in the definitions or claims. Therefore, those skilled in the art will understand that various modifications and equivalent other embodiments are possible from this. Therefore, the true technical protection scope of the present invention will be defined by the technical spirit of the appended claims.

As described above, according to the present invention, there is an advantage that can solve the difficulty of integrated management due to the current distributed reservation system.

In addition, the integrated management of the database of the customer relationship management system into the Oracle database of the management information system has the advantage of unified data management and real-time implementation.

In addition, the promotion management (promotion, recommendation) function has the advantage of reinforcing the customer management by implementing the targeting and grouping function and automatic promotional function for the customer.

Claims

Management information system equipped with a client server that performs the outpatient appointment of the patient: and medical examination appointment: and;

Customer's basic information and profile information (resident area, gender, social status, age, occupation, disposition, family, etc.) and client's medical data (history, family history, disease code, visit time, clinic, abnormal finding type, reservation history) Determination reservation to determine the possibility of reservation based on data such as

Ability to recommend clinic to customers by defining clinic incidence and likely disease groups, extracting clients who have previously received medical treatment and surgery for the disease, and planning when and how to deliver them to customers. Clinic reservation that automatically checks the customer's response to the delivery and manages the execution result after the execution of the service;

And an integrated database constructed to integrate the management information system and the customer relationship management system in real time.