KR102395415B1 - Service system for management information of general agency - Google Patents

Abstract

The present invention relates to an independent insurance agency management information service system which can enhance work efficiency of an independent insurance agency by processing data, received from a plurality of aligned insurance companies, with efficiency, no user intervention and intelligence and offering a service as management information required by the independent insurance agency. The present invention provides the independent insurance agency management information service system, comprising: a user server provided in the independent insurance agency; and a central service server in which registration information of the user server is stored and which is configured to integrally construct management information of the independent insurance agency and to offer a service by making communications with the user server via the internet.

Description

Independent insurance agency management information service system {SERVICE SYSTEM FOR MANAGEMENT INFORMATION OF GENERAL AGENCY}

The present invention relates to an independent insurance agency management information service system. More specifically, the independent insurance agency efficiently and intelligently processes data provided from affiliated insurance companies without user intervention to provide management information required by the independent insurance agency. It relates to an independent insurance agency management information service system that can improve the work efficiency of independent insurance agencies by providing services.

In general, a solicitor who sells insurance products may be directly affiliated with an insurance company such as a life insurance company or a non-life insurance company (hereafter referred to as the 'primary company'), but an independent insurance agency that can sell products from multiple life insurance companies and non-life insurance companies It is a common trend to be affiliated with a general agency (GA: General Agency), and accordingly, in some cases, the size of the independent insurance agency is as large as the size of the original investigation agency.

These independent insurance agencies (GAs) receive and process insurance contract-related information from multiple primary agents, or provide sales support functions for insurance business.

In addition, each independent insurance agency has its own system: life insurance, whole life insurance, disease insurance, auto insurance, driver's insurance, fire insurance, damage insurance, theft insurance, education insurance, death insurance, pension insurance, variable insurance, medical loss insurance, group insurance Insurance, accident insurance, travel insurance, child insurance, fetal insurance, etc. are handled by the original company.

Accordingly, the independent insurance agency's own system handles a variety of insurances, so it receives insurance contract-related information from a large number of original investigators in the form of structured data and uses it for business.

Accordingly, the management information system of independent insurance agencies has to be built with a more complex processing method compared to the IT system of insurance companies. There is a problem that takes a lot of time and money, etc.

In addition, the independent insurance agency predicts commissions, prizes, and promotions to be received from the original agent for insurance sales, determines which products of the principal agent will be strategically sold to generate more performance, and manages contracts or affiliates. It is not easy to understand the status of contracts (performance status) signed by sub-organizations (hereafter 'branches') other than the head office (the head office of an independent insurance agency) in order to pay the planner an allowance. This is because the status of the contract concluded at each branch must be directly entered into the independent insurance agency's own computer system. This is a more serious problem for independent insurance agencies created by a group of small independent insurance agencies.

Therefore, it is difficult to accurately determine the contract status (performance status) when the independent insurance agency head office sets up a sales strategy or profit creation strategy. You have to access and inquire or download the contract status (performance status), etc., but there is a problem in that there is a big loss in time and money. This kind of problem occurs greatly because it accesses, inquires, and downloads.

On the other hand, independent insurance agencies are supplied with insurance products through partnerships with original agents, and generate profits by contracting their own planners as agencies. In this process, profits (fees) are distributed to independent insurance agencies and planners with respect to the sales profit of the original agent.

Fees are paid at different rates depending on the various principal agents, and are differentiated by product, and are differentially paid to each independent insurance agency according to the operating capabilities of the independent insurance agency. can be defined. Of course, it goes without saying that the fee may vary depending on the individual competency of the designer.

Furthermore, in the case of insurance, in the case of initial sales, a certain multiple of the first month's sales cost is paid as a commission to inspire sales, and a certain percentage of the monthly premium is paid as a monthly commission to encourage the management of the policyholder. Various fees are incurred.

In this way, if the payment rate of these various fees is considered as the number of cases, such as the payment rate varies depending on the first fee and the monthly fee, the number of such cases becomes immeasurable.

Accordingly, there was a problem in that a lot of time and manpower were inevitably invested in managing, calculating, and paying these fees to the conventional original investigators, independent insurance agencies, and solicitors.

In particular, since the commission system of independent insurance agencies sells various products of life insurance companies, the calculation of commissions for product sales is more complicated than the commission system of insurance companies. The computerized systems that do this should be able to flexibly respond to the fee regulations of various independent insurance agencies.

As of September 2019, domestic independent insurance agencies are operating about 5,000 companies, and in order to calculate the fees of all independent insurance agencies, the business rules and fee regulations of independent insurance agencies must be reflected in the fee calculation. A lot of time and money are involved.

Korean Patent Publication No. 10-2017-0078022 (published on July 7, 2017) Republic of Korea Patent Publication No. 10-1604073 (2016.03.25. Announcement) Korean Patent Publication No. 10-2012-0105601 (published on September 26, 2012) Korean Patent Publication No. 10-2011-0049433 (published on May 12, 2011)

Accordingly, the present invention for solving the above problems of the prior art provides independent insurance by efficiently and intelligently processing data provided from several affiliated insurance companies without user intervention to provide management information required by independent insurance agencies. The purpose is to provide an independent insurance agency management information service system that can improve the agency's work efficiency.

The problems to be solved of the present invention are not limited to those mentioned above, and other problems not mentioned will be clearly understood by those skilled in the art from the following description.

According to one aspect of the present invention for achieving the above objects and other features of the present invention, there is provided a user server in which registration information of an independent insurance agency is stored, and a central service server that receives registration information of an independent insurance agency from the user server. In the independent insurance agency management information service system comprising a, the user server stores a planner partnership code, contract ledger information, and registration information of an independent insurance agency, and the planner partnership code is an independent insurance registered with an insurance company It is a registered code assigned to the agent affiliated with the agency, the contract ledger information includes a policy number and an insurance company affiliate code of a partner insurance company, the registration information of the independent insurance agency includes unique identification information of the independent insurance agency, and the central The service server includes a data upload server unit for receiving and uploading the structured data file from the user server, and an error data extraction server unit for extracting and classifying error data from the data uploaded to the data upload server unit through an error data processing algorithm. And, a data integrity server unit for correcting the error data extracted from the error data extraction server unit to determine the final structured data file in which the data is made integrity, and mapping using the final structured data file determined by the data integrity server unit A mapping data generation server unit for generating data, and a mapping data DB server unit for storing the mapping data generated by the mapping data generation server unit, wherein the structured data file is data that is an identifier for classifying data in affiliated insurance companies It is a data file structured in rows and columns, including a classification identifier and data corresponding to the data identification identifier, wherein the data classification identifier is a security number identifier that is an identifier for a security number, and a partnership with a designer It includes a designer affiliate code identifier that is an identifier for the code, and the data upload server unit parses the structured data file with SAX (simple API for XML) and uploads the parsing structured data file that is the result of parsing, and the error data The extraction server unit, when the security number identifier among the data identification identifiers of the uploaded structured data file does not exist in the security number of the contract ledger information of the user server, the column number, the row number, and the error code of the structured data file are combined stored data as stock number error data, a stock number identifier among the data classification identifiers of the uploaded structured data file exists in the stock number of the contract ledger information of the user server, and the data of the uploaded structured data file If the designer affiliate code identifier among the classification identifiers does not exist in the designer affiliate code stored in the user server, data in a form in which the column number, row number, and error code of the structured data file are combined is stored as affiliate code error data, A security number identifier among the data classification identifiers of the uploaded structured data file exists in the security number of the contract ledger information of the user server, and the affiliate code identifier of the structured data among the data classification identifiers of the uploaded structured data file is the user server When it exists in the designer affiliate code stored in the , the error data extraction process is terminated to finally determine the structured data file, and the mapping data generation server unit divides the data of the plurality of pre-established construction data identification identifiers and the final structured data file. By comparing the identifiers, if there is a data identification identifier of the final structured data file corresponding to the plurality of construction data identification identifiers, a representative identifier is determined with respect to the data identification identifier of the final structured data file, and the mapping data is generated Independent insurance agency management information service system, characterized in that the server unit generates mapping data having data of the determined representative identifier and data of the data classification identifier of the fixed data file read as data for the determined representative identifier. provided

In the present invention, the data integrity server unit is configured to re-receive and correct the data for which it is determined that the policy number does not exist in the structured data file from the affiliated insurance company, and the central service among the extracted error data Error data that can be processed in the server is displayed on the screen of the service platform of the central service server so that the person in charge can access the service platform through the user server to which access is granted and take action on the error, and the mapping data is created The mapping data generated in the server unit may include data for information management of new contracts, holding contracts, collection information, contract status information, redemption information, maintenance contract information, fee information, and designer performance information.

According to the independent insurance agency management information service system according to the present invention, the following effects are provided.

First, the present invention has the effect of improving the work efficiency of independent insurance agencies by efficiently and reliably providing management information required by independent insurance agencies without having to build their own system for information management. .

Second, according to the present invention, management information can be obtained from independent insurance agencies without user intervention, thereby preventing errors caused by erroneous input or omission of conventional users, thereby reducing the burden on users, and obtaining reliable operation information from accurate data. can have an effect.

Third, the present invention improves the work efficiency of independent insurance agencies by enabling independent insurance agencies to use them quickly and efficiently and to pay accurate fees for various fees generated in selling insurance products, and service users without the help of developers A user can easily check the desired fee with a simple mouse click on the fee rule definition screen, which has the effect of further improving system usability.

Effects of the present invention are not limited to those mentioned above, and other solutions not mentioned will be clearly understood by those skilled in the art from the following description.

1 is a diagram schematically showing the configuration of an independent insurance agency management information service system according to the present invention.
2 is a block diagram showing the configuration of a central service server constituting the independent insurance agency management information service system according to the present invention in blocks.
3 is an exemplary screen for generating mapping data in the mapping data generation server unit included in the independent insurance agency management information service system according to the present invention.
4 is a diagram illustrating an example of a setting screen of a setting classification identifier in the independent insurance agency processing information service system according to the present invention.

Additional objects, features and advantages of the present invention may be more clearly understood from the following detailed description and accompanying drawings.

Prior to the detailed description of the present invention, the present invention can make various changes and can have various embodiments, and the examples described below and shown in the drawings are not intended to limit the present invention to specific embodiments. No, it should be understood to include all modifications, equivalents, and substitutes included in the spirit and scope of the present invention.

When an element is referred to as being “connected” or “connected” to another element, it is understood that it may be directly connected or connected to the other element, but other elements may exist in between. it should be On the other hand, when it is said that a certain element is "directly connected" or "directly connected" to another element, it should be understood that the other element does not exist in the middle.

The terms used herein are used only to describe specific embodiments, and are not intended to limit the present invention. The singular expression includes the plural expression unless the context clearly dictates otherwise. In the present specification, terms such as “comprise” or “have” are intended to designate that a feature, number, step, operation, component, part, or combination thereof described in the specification exists, but one or more other features It should be understood that this does not preclude the existence or addition of numbers, steps, operations, components, parts, or combinations thereof.

In addition, terms such as "...unit", "...unit", "...module", etc. described in the specification mean a unit that processes at least one function or operation, which includes hardware or software or hardware and It can be implemented by a combination of software.

In addition, in the description with reference to the accompanying drawings, the same components are given the same reference numerals regardless of the reference numerals, and the overlapping description thereof will be omitted. In describing the present invention, if it is determined that a detailed description of a related known technology may unnecessarily obscure the gist of the present invention, the detailed description thereof will be omitted.

Hereinafter, an independent insurance agency management information service system according to a preferred embodiment of the present invention will be described in detail with reference to the accompanying drawings.

1 is a diagram schematically showing the configuration of an independent insurance agency management information service system according to the present invention, and FIG. 2 is a block diagram of the configuration of a central service server constituting the independent insurance agency management information service system according to the present invention. 3 is an exemplary screen for generating mapping data in the mapping data generation server unit included in the independent insurance agency management information service system according to the present invention, and FIG. 4 is an independent insurance agency processing information service according to the present invention. It is a diagram showing an example of a setting screen of a setting identification identifier in the system.

The independent insurance agency management information service system according to the present invention, as shown in FIGS. 1 to 4, is largely independent of the user server 100 in which registration information of the independent insurance agency (GA) is stored, and the user server 100 and a central service server 200 for receiving insurance agency registration information.

Specifically, the independent insurance agency management information service system according to the present invention is a management information service system implemented by well-known software and hardware and executed through the Internet network, and is largely installed in independent insurance agencies (GA). a user server 100 in which registration information is stored; and receiving the registration information of the user server 100, and communicating with the user server 100 through the Internet network, data for fee calculation managed by an independent insurance agency, data for processing supply and demand information, data for processing contract information and a central service server 200 configured to integrate and build information including data such as data to serve as an independent insurance agency.

The user server 100 communicates with the central service server 200, accesses the central service server 200, and the right to view and register through the service platform of the central service server 200 is built and configured.

The registration information of the independent insurance agency is unique identification information of the independent insurance agency, and includes a unique code assigned to the independent insurance agency in order to distinguish several independent insurance agencies.

The central service server 200 includes: a data upload server unit 210 for receiving and uploading a structured data file built in an independent insurance agency; an error data extraction server unit 220 for extracting and classifying error data through an error data processing algorithm with respect to the data uploaded from the data upload server unit 210; a data integrity server unit 230 for correcting the error data extracted from the error data extraction server unit 220 and integrity of the data to determine the final structured data; Mapping data generation server unit 240 to generate mapping data by mapping the data identification identifier of the final structured data determined through the data integrity server unit 230 and the previously constructed construction data identification identifier (to be described later) ; and a mapping data DB server unit 250 for storing the mapping data generated by the mapping data generation server unit 400 as data for information management (business processing) in an independent insurance agency.

The data upload server unit 210 receives the structured data file from the user server 100 and uploads the data of the structured data file. Structured type structured data such as EXCEL, TEXT, CSV, DB, XML, JSON, etc. A file (an Excel file structured in rows and columns in the present invention) is downloaded from the user server 100 and the data of the structured data file is uploaded through a predetermined processing process.

The structured data file includes, for example, data for fee calculation, data for processing supply and demand information, and data for processing contract information for contracts managed by independent insurance agencies, such as new contracts, maintenance contracts, redemption cases, and reinstatement cases. It is a data file (eg, an Excel file) structured in rows and columns, including data such as.

The structured data file consists of structured data including a data identification identifier (or data identification code) in the first row of the structured data file and each data corresponding to each data identification identifier.

Here, the data classification identifier of the structured data file is an identifier for classifying data in each affiliated insurance company. Unique code), premium (insurance fee, insurance cost), insurance product name (product name, insurance name), and solicitor (solicitor, solicitor name) are defined as terms used by affiliated insurance companies to classify data in their own terms.

That is, the data classification identifier is a classification identifier for data with the same meaning according to affiliated insurance companies. For example, using a policy number as a policy number or policy No., using an affiliate code as a linkage code, original investigation code or unique code, using premiums as insurance commissions or insurance costs, or using the insurance product name as a product name or insurance name or use a different term (or identifier) for each affiliated insurance company for data with the same meaning, such as a solicitor or solicitor name, etc., and define a data classification identifier for data with the same meaning.

Subsequently, the data upload server unit 210 selects a structured data file and creates an array list (ArrayList) in which data of 1 row × 1 column to N rows × M column of the selected structured data file (Excel file) is entered, and , Parsing the structured data file with SAX (simple API for XML: Simple application program interface for Extensible Markup Language), and parses the data of the parsed structured data file from 1 row × 1 column to N rows × M columns It reads (reads), and stores and uploads the final structured data file in which the read data is reflected in the generated array list.

Parsing in the structured data upload server unit 210 performs SAX (simple API for XML) parsing of the structured data file so that information from row 1/1 column of the structured data file to row N/column M where data exists is XML (eXtensible Markup Language) is to be converted. The SAX parsing performed by the structured data upload server unit 210 is a well-known XML parsing method using a JAVA program, and a detailed description thereof will be omitted.

The structured data upload server unit 210 is executed for a large-capacity file (structured data file), and the present invention uses a SAX (Simple API for XML) parsing method to quickly increase the capacity of a large-capacity file without overloading the system memory. file can be processed. This is the problem of uploading a large-capacity structured data file through a relational database management system (RDBMS), that is, in the case of a DOM (Document Object Model) parsing method that calls a structured data file into memory. It is possible to solve a problem that will cause a fatal issue in the system as the overload increases.

Next, the error data extraction server unit 220 performs error (error) verification through an error data processing algorithm, and is basically configured to automatically detect and classify errors in the securities number and affiliate code.

Here, the affiliate code (use encoding) is a unique code of a solicitor belonging to an independent insurance agency registered with the original insurance company (affiliate insurance company) with which the independent insurance agency (GA) is affiliated. In order for a solicitor belonging to an independent insurance agency to sell insurance products from a partner insurance company, the code for the solicitor must be registered with the partner insurance company. For this reason, most insurance agents belonging to independent insurance agencies have at least one affiliate code to sell various products. In addition, the affiliated insurance company refers to the original insurance company (life insurance company or non-life insurance company) affiliated with an independent insurance agency (GA). Since independent insurance agencies are qualified to sell the products of multiple original agents, the independent insurance agency must have an alliance with each principal in order to sell the products of the affiliated insurance companies. In addition, the head of the HR director refers to the personnel information entered in the computerized system of the independent insurance agency (GA). The terms of the contract ledger, HR director, affiliate code, and affiliated insurance company are widely known in the insurance industry, and those skilled in the art can fully understand.

Next, the error data extraction server unit 220 first converts the security number among the data classification identifiers of the final structured data file that has undergone the data upload process with the security number of the contract ledger (ERP server or ERP system of an independent insurance agency) By comparison, it is determined whether or not the stock number of the structured data file exists. Stores error data (ie, security number error data) in a combined form, and when it is determined that the security number exists, secondly, an affiliate code from the data classification identifier of the final structured data file is set to the head of the HR (independent insurance agency) of the ERP server or ERP system) to determine whether the affiliate code of the structured data file exists, and if it is determined that the affiliate code of the structured data file does not exist, Num), row number (Col Num), and error code (Error No) are combined to store error data (ie, affiliate code error data), and when it is determined that there is an affiliate code of structured data, error data extraction process will end

Here, the error data extracted from the error data extraction server unit 220 is configured to be displayed on the web screen of the service platform so that the person in charge can access it through the user server to which the access right is granted. Upon completion, the number of normal processing cases, the number of errors in the securities number, and the number of errors in the affiliate code are displayed on the screen, and a detailed page for the number of these errors is provided through the service platform so that the error data can be processed.

In addition, the contract ledger refers to a contract signed by an insurance solicitor (FC) with a consumer (insured person) when selling insurance at each independent insurance agency, and to which the affiliate code of the affiliated insurance company (affiliation code assigned to the affiliated insurance company) and the policy number are assigned. and the contract ledger is registered in the ERP server or ERP system, which is the management system of each independent insurance agency. Here, the ERP server or ERP system may be configured as the user server 100 .

Next, the data integrity server unit 230 transmits data that cannot be processed among the extracted error data (that is, error data that the person in charge of the independent insurance agency cannot process through the service platform) from the affiliated insurance company. It is made to be corrected by re-reception. That is, the data integrity server unit 230 re-receives and corrects the data of the structured data file from the affiliated insurance company that provided the structured data file for the data determined that the stock number does not exist in the final structured data file. is done

In addition, the data integrity server unit 230 serves the error data that can be processed among the extracted error data (that is, error data that can be processed by the person in charge of the use of the independent insurance agency) through the user server to which access is granted. It is configured to be displayed on the web screen of the service platform so that the person in charge of using the platform can access and correct the error. Error data that can be processed in this way is displayed on the web screen of the service platform so that the person in charge can access the service platform and take action.

The mapping data generation server unit 240 maps the data classification identifier of the final structured data file determined through the data integrity server unit 230 and the pre-established construction data classification identifier to manage information at an independent insurance agency It is made to generate mapping data (usage data) used for

In other words, the mapping data generation server unit 240 compares a plurality of previously constructed construction data identification identifiers with the data identification identifiers of the final structured data file, and constructs corresponding to the data identification identifiers of the final structured data file. When the data identification identifier exists, the mapping data is generated using data of the data identification identifier of the structured data file as data for the corresponding representative identifier while determining the representative identifier for the construction data identification identifier.

Here, the plurality of pre-constructed data identification identifiers are identifiers for data (usage data) of the same nature (or meaning), and one of them is referred to as a representative identifier or another identifier defined as a representative identifier is referred to as a representative identifier. , in the identifier database (identifier DB) built and stored.

For example, for data of the same nature (usage data), Affiliate Insurance Company A uses a data classification identifier of “Security Number”, Affiliate Insurance Company B uses a data identification identifier of “Security No.”, and Affiliate Insurance Company C can use the data classification identifier of "Security Number", and the identifier database stores the identifiers of "Security Number", "Security No," and "Security Number" used by each affiliated insurance company as the construction data classification identifier, In mapping data, "security number" is defined and set as a representative identifier.

The identifier database is configured so that it can be updated with respect to other data identification identifiers for data with the same meaning.

Subsequently, the mapping data generation server unit 240 compares the previously constructed construction data identification identifier with the data identification identifier of the final structured data file, and when a corresponding identifier exists, the data of the final structured data file A representative identifier is determined with respect to the classification identifier, and when the representative identifier is determined, data corresponding to the data classification identifier of the final structured data file is read, and data corresponding to the corresponding data classification identifier as data of the representative identifier is obtained. The mapped mapping data is created, and this mapping data is used as data managed by an independent insurance agency.

Here, in the method of reading the corresponding data, the data can be read individually, and the data can be read in a column unit, which is a single column unit. there may be

On the other hand, the construction setting classification identifier, the data classification identifier and the representative identifier of the structured data can be selected or excluded from the identifier management screen of the service platform of the central service server 200 by accessing the user in charge through the user server 100 . can be set.

Next, the mapping data DB server unit 250 manages the mapping data generated by the mapping data generation server unit 240 at an independent insurance agency (eg, new contract, holding contract, collection information, contract). It is stored to be used as data (usage data or basic data) for management information such as status information, redemption information, maintenance contract information, fee information, and performance information), and the user in charge through the user server 100 through the service platform made to be verified.

The mapping data DB server unit 250 automatically generates and stores information (mapping data) mapped according to a set identification identifier.

On the other hand, in the present invention, after the mapping data is stored, the mapping data is sent to a learning engine server for machine learning or deep learning, so that it can be used as a basis for reducing an error in recognition rate.

On the other hand, in the present invention, the central service server 200 is preferably made of a cloud server.

According to the independent insurance agency management information service system according to the present invention as described above, each independent insurance agency provides the information required by the independent insurance agency efficiently and reliably without the need to establish its own system for information management. The work efficiency of insurance agencies can be improved, and management information can be obtained from independent insurance agencies without user intervention. There is an advantage in being able to manage the existing information.

The embodiments described in the independent insurance agency management information service system according to the present invention described above may be implemented as a hardware component, a software component, and/or a combination of a hardware component and a software component. For example, the apparatus, methods, and components described in the embodiments may include, for example, a processor, a controller, an arithmetic logic unit (ALU), a digital signal processor, a microcomputer, a field programmable gate (FPGA) array), a programmable logic unit (PLU), a microprocessor, or any other device capable of executing and responding to instructions, may be implemented using one or more general purpose or special purpose computers. The processing device may execute an operating system (OS) and one or more software applications running on the operating system. A processing device may also access, store, manipulate, process, and generate data in response to execution of the software. For convenience of understanding, although one processing device is sometimes described as being used, one of ordinary skill in the art will recognize that the processing device includes a plurality of processing elements and/or a plurality of types of processing elements. It can be seen that can include For example, the processing device may include a plurality of processors or one processor and one controller. Other processing configurations are also possible, such as parallel processors.

The embodiments described in this specification and the accompanying drawings are merely illustrative of some of the technical ideas included in the present invention. Accordingly, since the embodiments disclosed in the present specification are for explanation rather than limitation of the technical spirit of the present invention, it is obvious that the scope of the technical spirit of the present invention is not limited by these embodiments. Modifications and specific embodiments that can be easily inferred by those skilled in the art within the scope of the technical spirit included in the specification and drawings of the present invention should be interpreted as being included in the scope of the present invention.

100: user server
200: central service server
210: data upload server unit
220: error data extraction server unit
230: data integrity server unit
240: mapping data generation server unit
250: mapping data DB server unit

Claims (2)

An independent insurance agency management information service system comprising: a user server storing registration information of independent insurance agencies; and a central service server receiving registration information of independent insurance agencies from the user server,
In the user server, the designer's affiliate code, the contract ledger information, and the registration information of the independent insurance agency are stored,
The agent affiliate code is a registered code assigned to a planner belonging to an independent insurance agency registered with the insurance company,
The contract ledger information includes a policy number and an insurance company affiliate code of a partner insurance company,
The registration information of the independent insurance agency includes unique identification information of the independent insurance agency;
The central service server includes a data upload server unit for receiving and uploading the structured data file from the user server, and error data extraction for extracting and classifying error data from the data uploaded to the data upload server unit through an error data processing algorithm Using the server unit, the data integrity server unit for correcting the error data extracted from the error data extraction server unit to determine the final structured data file in which the data is made integrity, and the final structured data file determined by the data integrity server unit and a mapping data generation server unit that generates mapping data by
The structured data file is a data file structured in rows and columns, including a data identification identifier, which is an identifier for classifying data in an affiliated insurance company, and data corresponding to the data identification identifier,
The data identification identifier includes a security number identifier that is an identifier for a security number, and a designer affiliate code identifier that is an identifier for the designer affiliate code,
The data upload server unit parses the structured data file with SAX (simple API for XML) and uploads the parsing structured data file, which is a result of parsing,
The error data extraction server unit, when the security number identifier among the data classification identifiers of the uploaded structured data file does not exist in the security number of the contract ledger information of the user server, the column number, the row number, the error of the structured data file The code-combined data is stored as stock number error data, and the stock number identifier among the data classification identifiers of the uploaded structured data file is present in the stock number of the contract ledger information of the user server, and the uploaded structured data When the designer affiliate code identifier among the data classification identifiers of the file does not exist in the designer affiliate code stored in the user server, the data in the form of combining the column number, row number, and error code of the structured data file is stored as affiliate code error data and a security number identifier among the data identification identifiers of the uploaded structured data file exists in the security number of the contract ledger information of the user server, and the affiliate code identifier of the structured data among the data classification identifiers of the uploaded structured data file If it exists in the designer affiliate code stored in the user server, the error data extraction process is terminated to finalize the structured data file,
The mapping data generation server unit compares a plurality of pre-built data classification identifiers with a data classification identifier of the final structured data file, and the data classification identifier of the final structured data file corresponding to the plurality of construction data classification identifiers is If present, determine a representative identifier for the data identification identifier of the final structured data file,
The mapping data generation server unit generates mapping data having the determined representative identifier and data from which data of the data identification identifier of the corresponding final structured data file is read as data for the determined representative identifier.
Independent insurance agency management information service system.
The method of claim 1,
The data integrity server unit,
It is made to re-receive and correct the data for which it is determined that the policy number does not exist in the structured data file from the affiliated insurance company. The processable error data is displayed on the screen of the service platform of the central service server so that the user in charge can access the service platform through the given user server and take action on the error,
The mapping data generated by the mapping data generation server unit includes information management of new contracts, information management of holding contracts, information management of collection information, information management of contract status information, information management of redemption information, and maintenance contract Characterized in that it includes data for information management of information, information management of fee information, and information management of designer performance information
Independent insurance agency management information service system.

Images