JP5184483B2 - Survey form inspection system, survey form inspection method, and survey form inspection program - Google Patents

Description

  The present invention relates to a survey form inspection system, method, and program for supporting confirmation of consistency of item values recorded in a survey form.

  Sometimes, questionnaires are collected from various organizations, and statistics are calculated based on these questionnaires. For example, in the national health insurance business, the basics for widespread use of the system for the sound operation of the system, such as improving the system, organizing budgets, and issuing subsidies for national insurance, are ascertained from the insurer's national insurance business operation results nationwide. An annual report is prepared for the purpose of obtaining materials. Here, all insurers (municipalities and national health insurance associations) are subject to the survey.

  A region-specific health analysis method for comprehensively analyzing such data on health checkups, data on long-term care insurance, and data on national health insurance has been studied (for example, see Patent Document 1). In the technique described in this document, first data based on a health checkup, second data based on a long-term care insurance, and third data based on a national health insurance are input to a computer. For each person, fourth data is created for each individual from the first to third data by specifying the address of each individual and tabulating the data of the health checkup, long-term care insurance, and national health insurance. Based on the fourth data created in the second step, calculate an index consisting of one or both of the trends and degrees of regional health checkups, long-term care insurance, and national health insurance from the address of each individual Create fifth data.

  However, human errors such as calculation errors may occur. Therefore, a technique for suppressing an input error of the original value and a subsequent calculation error has been studied (see, for example, Patent Document 2). In the technique described in this document, a user interface that does not use a keyboard eliminates typing errors caused by key input and limits the input range. The calculated value is checked again inside the computer to determine whether it is appropriate. If it is not correct, a warning is issued and the user is fed back.

Japanese Patent Laying-Open No. 2006-59107 (first page, FIG. 1) JP 2002-169891 A (first page, FIG. 1)

  As described above, when a value (item value) is recorded in each item of the survey form in various organizations, there is a case where a calculation error or an error is recorded. For example, the number of digits of the item value may be wrong, or the item to be calculated may be wrong. In addition, the calculation itself may be wrong.

  When survey forms in which such item values are recorded are obtained from various institutions and each item value is manually inspected, it takes time and effort. In particular, when the number of items to be inspected is large, the load becomes large.

In some cases, the survey form is inspected using a check expression having item values for a plurality of items as variables. If an error is detected for this check expression, any value used as a variable may be incorrect. However, when item values of a plurality of items are used as variables, it is difficult to determine which item item value is wrong.

  In addition, when surveys are periodically performed, it may be possible to determine whether each item value is appropriate based on past survey history. That is, an item value that deviates from a range predicted from past item values may be wrong.

  The present invention has been made to solve the above-described problems, and includes a survey form inspection system, a survey form inspection method, and a survey form inspection program for efficiently inspecting item values recorded in a survey form. It is to provide.

In order to solve the above-mentioned problem, the invention described in claim 1 is characterized in that a survey form storage means storing a survey form in which item values for a plurality of items are recorded, and a check condition for the item is used as the check condition. Check condition storage means for recording an arithmetic expression using the item values recorded in a plurality of items included in the vote as variables, a confirmation result storage means for recording a confirmation result using the check condition for each item, and a questionnaire A survey form inspection system comprising a control means for inspecting item values contained in the control means, wherein the control means obtains a survey form to be inspected from the survey form storage means, and the check condition storage means, An arithmetic expression to be applied to each item of the questionnaire is acquired, and for each arithmetic expression , the item value recorded in each item is substituted as a variable, and a questionnaire inspection process for determining whether the arithmetic expression is satisfied is executed. means , When not satisfy the mathematical expression includes means for recording error information in the confirmation result storage means for all items variables constituting the arithmetic expression, when the completion of the determination for all the check condition And a means for calculating the number of errors obtained by counting the error information recorded in the confirmation result storage unit for each item and outputting a display corresponding to the number of errors for each item .

According to a second aspect of the present invention, in the survey form inspection system according to the first aspect, the check condition storage means further stores an allowable range of increase / decrease rate for each item of the survey form as a check condition. In addition, a survey form history information storage unit that records past survey forms is further provided, and the control unit further calculates an increase / decrease rate of each item using the survey form recorded in the survey form history information storage unit. And comparing the allowable range recorded in the check condition storage means with the increase / decrease rate of each item included in the survey form to be inspected, and if the increase / decrease rate exceeds the allowable range, the confirmation result The gist is to record error information for this item in the storage means.

According to a third aspect of the present invention, in the survey form inspection system according to the first or second aspect , when the control means acquires a correction value of a value recorded in each item, the correction value is stored as correction information. Recording on the means, executing the survey form inspection process using the correction value, recording the distribution of the number of errors in association with the correction value, and displaying the distribution of the number of errors before and after correction Is the gist.

The gist of the invention described in claim 4 is that, in the survey form inspection system according to any one of claims 1 to 3 , correction candidates are output according to the number of errors in the survey form.
According to the fifth aspect of the present invention, a survey form storage means storing a survey form in which item values for a plurality of items are recorded, and a plurality of items included in the survey form are recorded as check conditions for the items. Check condition storage means for recording an arithmetic expression using the item value as a variable, confirmation result storage means for recording the confirmation result using the check condition for each item, and control for inspecting the item value included in the survey form A method for inspecting a survey form using a survey form inspection system provided with means, wherein the control means obtains a survey form to be inspected from the survey form storage means, and the check condition storage from the means, the acquired operation expressions to be applied to each item of the questionnaire, for each of the arithmetic expression, substitutes the field values stored in each item as variables, questionnaire checking process determining sufficiency of the arithmetic expression Run A step that, if you do not satisfy the mathematical expression includes the steps of recording the error information to the confirmation result storage means for all items variables constituting the arithmetic expression, the determination for all the check condition When the processing is completed, calculating the number of errors obtained by counting the error information recorded in the confirmation result storage unit for each item and outputting a display corresponding to the number of errors for each item To do.

According to a sixth aspect of the present invention, a survey form storage means for storing a survey form in which item values for a plurality of items are recorded, and a plurality of items included in the survey form are recorded as check conditions for the items. Check condition storage means for recording an arithmetic expression using the item value as a variable, confirmation result storage means for recording the confirmation result using the check condition for each item, and control for inspecting the item value included in the survey form A program for inspecting a survey form using a survey form inspection system provided with means, the control means, a means for acquiring a survey form to be inspected from the survey form storage means, and the check condition storage means from obtains an equation to be applied to each item of the questionnaire, for each of the arithmetic expression, it substitutes the field values stored in each item as a variable, determining questionnaire inspection process satisfiability of the arithmetic expression It means for row, when not satisfy the arithmetic expression, means for recording error information for every item of the variable constituting the arithmetic expression on the confirmation result storage means, terminates the determination for all the check condition In this case, the gist is to calculate the number of errors obtained by counting the error information recorded in the confirmation result storage unit for each item , and to function as a unit for outputting a display corresponding to the number of errors for each item .

(Function)
According to the first, fifth , and sixth aspects of the invention, the control unit acquires the survey form to be inspected from the survey form storage unit. Then, a check condition to be applied to each item of the survey form is acquired from the check condition storage unit, and a survey form inspection process for determining whether the check condition is satisfied is executed for each check condition. Next, when the check condition is not satisfied, error information for this item is recorded in the confirmation result storage means. When the determination for all the check conditions is completed, the number of errors for the error information recorded for each item is calculated, and the distribution of the number of errors for the survey form is output. Thereby, according to the number of errors, items to be preferentially corrected in the survey form can be specified.

According to the present invention, for each conditional expression, the control unit substitutes the item value recorded in each item as a variable, determines whether the conditional expression is satisfied, and stores the confirmation result when the conditional expression is not satisfied. In the means, error information is recorded for the item of the variable constituting the conditional expression. Thereby, the item which may be wrong can be specified using the conditional expression which uses the item value of a some item as a variable.

According to the second aspect of the present invention, the control means calculates the increase / decrease rate of each item using the survey form recorded in the survey form history information storage means. Then, the allowable range recorded in the check condition storage means is compared with the increase / decrease rate of each item included in the survey form to be inspected, and if the increase / decrease rate exceeds the allowable range, the confirmation result storage means Record error information for this item. Thereby, it is possible to determine the suitability of the item values included in the survey form to be inspected using the past survey form.

According to the third aspect of the present invention, when the control means acquires the correction value of the value recorded in each item, the correction value is recorded in the correction information storage means, and the survey form is inspected using the correction value. Execute the process. Then, the error number distribution is recorded in association with the correction value, and displayed so that the error number distribution before and after the correction can be compared. Thereby, it is possible to determine whether or not the correction is appropriate from the increase or decrease of the number of errors.

According to the invention described in claim 4 , correction candidates are output according to the number of errors in the survey form. Thereby, the survey form can be efficiently corrected.

  According to the present invention, it is possible to provide a survey form inspection system, a survey form inspection method, and a survey form inspection program for efficiently inspecting item values recorded in a survey form.

The system schematic of embodiment of this invention. It is explanatory drawing of the data memorize | stored in each data memory | storage part, (a) is a survey form data memory | storage part, (b) is a test result data memory | storage part, (c) is the data recorded on the correction history data memory | storage part. FIG. It is explanatory drawing of the data memorize | stored in each data memory | storage part, Comprising: (a) is a check condition data memory | storage part, (b) is explanatory drawing of the data recorded on the item name conversion file memory | storage part. Explanatory drawing of the data memorize | stored in the output frame data storage part. Explanatory drawing of the process sequence of embodiment of this invention. Explanatory drawing of the process sequence of embodiment of this invention. Explanatory drawing of the process sequence of embodiment of this invention. Explanatory drawing of the process sequence of embodiment of this invention. Explanatory drawing of the process sequence of embodiment of this invention. It is explanatory drawing of four arithmetic operation check processing of embodiment of this invention, Comprising: (a) is grouping, (b) is item extraction, (c) is explanatory drawing about acquisition of an address. It is explanatory drawing of the four arithmetic operation check process of embodiment of this invention, Comprising: (a) is acquisition of a data value, (b) is explanatory drawing about calculation for every check type | formula. It is explanatory drawing of the setting process of the order | rank of the correction candidate in other embodiment, Comprising: (a) is the formation relationship of each relational expression, (b) is explanatory drawing about specification of the item used as a correction candidate.

  DESCRIPTION OF EMBODIMENTS Hereinafter, embodiments embodying the present invention will be described with reference to FIGS. This embodiment will be described as a survey form inspection system, a survey form inspection method, and a survey form inspection program used when inspecting item values recorded on a survey form submitted from a survey organization periodically. Here, in the survey form including a plurality of items, a check process of the item value recorded for each item is performed.

  In this embodiment, as shown in FIG. 1, a survey form inspection apparatus 20 is used as a survey form inspection system. The survey form inspection apparatus 20 is a computer system that performs data processing for inspecting item values of each item of the survey form. The survey form inspection device 20 is connected to the input unit 11, the output unit 12, and the data reading device 30.

The input unit 11 is a device that acquires various types of information input by the user, and includes a keyboard and a pointing device.
The output unit 12 is a device that outputs a check result executed in the survey form inspection apparatus 20 and is configured by a display.

The data reading device 30 is a device that reads a survey form file stored in a recording medium.
The survey form inspection apparatus 20 includes a control unit 21, a survey form data storage unit 22, an inspection result data storage unit 23, a correction history data storage unit 24, a check condition data storage unit 25, an item name conversion file storage unit 26, and output frame data. A storage unit 27 is provided.

The control unit 21 of the survey form inspection device 20 functions as a control unit that performs various data processing and the like for inspecting the item value of each item of the survey form. The control unit 21 includes a CPU, a RAM, a ROM, and the like (not shown), and performs processes (data read stage, check management stage, four arithmetic operation confirmation stage, increase / decrease rate confirmation stage, display management stage, etc.) described later. . By executing the survey form inspection program for that purpose, the control unit 21 has a data reading means 211, an inspection management means 212, an arithmetic operation confirmation means 213, an increase / decrease rate confirmation means 214, a display management means 215, as shown in FIG. It functions as survey form correction means 216 and the like.

The data reading unit 211 executes a process of acquiring a survey form to be inspected and check conditions.
The inspection management means 212 executes processing for controlling inspection processing (four arithmetic operation check processing and increase / decrease rate check processing) for each item included in the survey form.

The four arithmetic operation confirming means 213 executes processing for confirming the consistency of the result of performing the four arithmetic operations using the check formula described later for the item values of each item included in the survey form.
The increase / decrease rate confirmation unit 214 executes processing for confirming the consistency of the item value of each item included in the survey form using the increase / decrease rate with respect to the past item value.

The display management means 215 executes processing for displaying the result of the inspection processing on the output unit 12 for the survey form. The display management means 215 includes a color arrangement table for determining the background color of the area corresponding to the item code in which an error has occurred according to the error count value.
The survey form correcting means 216 executes a process of accepting a correction input of the survey form performed in the input unit 11.

  The survey form data storage unit 22 functions as a survey form storage unit, and stores a survey form file 220 used for inspection processing, as shown in FIG. This survey form file 220 is registered when a survey form is acquired from a recording medium inserted into the data reading device 30. This survey form file 220 includes data on a survey form code, a survey date, and survey form contents.

  In the survey form code data area, data relating to an identifier for specifying the type of each survey form is recorded. By using this survey form code, it is possible to specify other related survey forms for one survey form.

  In the survey date data area, data related to the date for specifying the survey time of this survey form is recorded. By using this survey date, it is possible to specify a survey form to be inspected and a past survey form. Thereby, the survey form data storage unit 22 functions as a survey form history information storage unit.

  In the survey form content data area, data relating to each item and item value included in the survey form is recorded. In this survey form, as shown in FIG. 11A, a value holding array is recorded. This value holding array is assigned addresses in order, and an item is associated with each address. In the value holding array, item values (numerical values in the present embodiment) corresponding to each item are recorded.

  The inspection result data storage unit 23 functions as a confirmation result storage unit, and stores inspection result data 230 for the survey form as shown in FIG. The inspection result data 230 includes an operation inspection result record 231 and an item-specific evaluation record 232. The operation inspection result record 231 is registered when an arithmetic operation check process described later is performed. On the other hand, the item-by-item evaluation record 232 is registered when the four arithmetic operation check processing and the increase / decrease rate check processing inspection processing are performed.

The operation inspection result record 231 includes data relating to a survey form code, a check type code, and a determination result.
In the survey form code data area, data relating to an identifier for specifying the type of survey form to be inspected is recorded.

In the check expression code data area, data relating to an identifier for specifying an operation expression used for checking the item value of each item in the four arithmetic operation confirmation processing is recorded.
In the determination result data area, data relating to an identifier for specifying the result of whether the check expression used in the inspection is satisfied or not is recorded.

The item-specific evaluation record 232 includes data relating to a survey form code, an item code, an error count, and an increase / decrease rate error.
In the survey form code data area, data relating to an identifier for specifying the type of survey form to be inspected is recorded.

In the item code data area, data relating to an identifier for specifying each item included in the survey form is recorded.
In the error count data area, data relating to the number of times an error has occurred for this item in the arithmetic operation check process is recorded.
In the increase / decrease rate error data area, a flag for determining whether there is an error regarding the increase / decrease rate in this item is recorded.

  The correction history data storage unit 24 functions as a correction information storage unit, and stores a correction history record 240 for a survey form that has been corrected based on the check result, as shown in FIG. The correction history record 240 is registered when the survey form inspection process is performed. The correction history record 240 includes data relating to the version code, the preceding version code, the correction content, the total error count, and the total increase / decrease error.

In the version code data area, data relating to an identifier for specifying the version of the survey form is recorded.
In the preceding version code data area, data relating to an identifier for specifying the version of the survey form before correction is recorded. In the case of the survey form file (original file) of the version before correction, the preceding version code data area is blank.

In the correction content data area, data relating to the content of the corrected survey form is recorded. In the present embodiment, data relating to the corrected item value is recorded with respect to the corrected survey form and information for specifying the item (survey form code, item code). In the case of an original file, the correction content data area is blank. Therefore, the correction history can be specified by the preceding version code based on the original file whose preceding version code data area is blank. Then, by sequentially changing each item value according to the correction history, the item value of each version can be acquired.
In each data area of the total error count and the total increase / decrease rate error, data relating to the total error count and the total increase / decrease rate error calculated by the survey form inspection process is recorded.

  The check condition data storage unit 25 functions as a check condition storage unit, and stores check condition data 250 for conditions used when checking each item included in the survey form, as shown in FIG. This check condition data 250 is registered when the contents to be inspected are determined in the survey form. The check condition data 250 includes an operation check condition record 251 and an increase / decrease rate check condition record 252.

The calculation check condition record 251 includes a check expression code and data related to the check expression.
In the check expression code data area, data relating to an identifier for specifying an operation expression used for checking the item value of each item in the four arithmetic operation confirmation processing is recorded.

  In the check expression data area, data relating to an operation expression used for checking the item value of each item in the four arithmetic operation confirmation processing is recorded. This check expression is connected by a relational operator such as an equality symbol or an inequality symbol, with the item value of an item code (for example, A10, B20, C30) specifying each item as a variable.

The increase / decrease rate check condition record 252 includes data regarding item codes and increase / decrease rate allowable ranges.
In the item code data area, data relating to an identifier for specifying each item included in the survey form is recorded.
In the increase / decrease rate allowable range data area, data relating to the range of the increase / decrease rate allowed in the item value of each item is recorded.

  As shown in FIG. 3B, the item name conversion file storage unit 26 stores an item name conversion file 260 used when specifying the item value of each item included in the survey form. The item name conversion file 260 is registered when the format of the survey form is determined. The item name conversion file 260 is configured to include data relating to the survey form code and address with respect to the item code.

In the item code data area, data relating to an identifier for specifying each item included in the survey form is recorded.
In the survey form code data area, data relating to an identifier for specifying the type of each survey form is recorded.
In the address data area, data related to the address where the item value of each item is recorded in the value holding array of the survey form is recorded.

  As shown in FIG. 4, the output frame data storage unit 27 stores various frames used for an output screen for outputting the contents of the survey form and the inspection results. In this embodiment, a survey form list frame, a survey form item frame, an item value frame, an error count frame, and an increase / decrease rate error frame are recorded.

  The survey form list frame is a frame used for an output screen for displaying the intake status and inspection status of each survey form. In the survey form list frame, symbols indicating the fetching status (whether there is a file) and the inspection status (whether there is an error) are displayed for the survey form code of the survey form.

  The survey form item frame is a frame in which a layout for displaying each item included in the survey form is set. A plurality of areas are provided in this survey form item frame, and each item code included in the survey form is assigned to each area.

The item value frame corresponds to the layout of the area to which each item code is assigned in the survey form item frame, and is a frame for outputting the item value of each item code.
The error count frame corresponds to the layout of the area to which each item code is assigned in the survey form item frame, and is a frame for outputting the error count distribution by setting the error count detected in the four arithmetic operation confirmation processing It is. Each area of the error count frame can be selected, and when each area is selected, the display management unit 215 acquires an item code corresponding to this area.

  The change rate error frame corresponds to the layout of the area to which each item code is assigned in the survey form item frame. By setting the change rate error detected in the change rate check process, the distribution of the change rate error is output. It is a frame for. Each area of the increase / decrease rate error frame can also be selected, and when each area is selected, the display management unit 215 acquires an item code corresponding to this area.

  Next, processing when inspecting item values for each item of the survey form of the present embodiment will be described. Here, an overview of the overall process (FIG. 5), survey form inspection process (FIG. 6), arithmetic operation check process (FIG. 7), increase / decrease rate check process (FIG. 8), and survey form display process (FIG. 9) Explained.

(Overview of overall processing)
First, the outline of the entire process will be described with reference to FIG.
The control unit 21 of the survey form inspection device 20 executes a survey form data reading process (step S1-1). Specifically, the survey form inspection program of the survey form inspection apparatus 20 is activated. In this case, the data reading unit 211 of the control unit 21 outputs a menu screen to the output unit 12. On this menu screen, icons for selecting each of the “investigation of survey form”, “correction”, and “end” processes are displayed. Here, when newly reading data, the recording medium storing the survey form file is inserted into the data reading device 30. Then, on the menu screen, the “take survey form” icon is selected. In this case, the data reading unit 211 reads the survey form file from the recording medium inserted in the data reading apparatus 30 and records the survey form file 220 in the survey form data storage unit 22.

  Then, the data reading unit 211 outputs a survey table designation screen to be inspected to the output unit 12. This survey table designation screen is provided with a setting column and an execution icon for designating the survey date (inspection date) of the survey form to be inspected. When a desired inspection date is input in this setting field and the execution icon is selected, the data reading unit 211 loads the inspection form file 220 to be inspected from the inspection form data storage unit 22. Then, the data reading unit 211 generates a correction history record 240 to which the version code is assigned and stores it in the correction history data storage unit 24. In this case, the previous version code of the correction history record 240 is left blank.

  Next, the control unit 21 of the survey form inspection apparatus 20 executes a check condition reading process (step S1-2). Specifically, the data reading unit 211 of the control unit 21 acquires the check condition data 250 for the survey form from the check condition data storage unit 25.

  Next, the control unit 21 of the survey form inspection apparatus 20 executes a survey form inspection process (step S1-3). Specifically, the inspection management unit 212 of the control unit 21 executes a survey form inspection process to be described later using the acquired check condition data 250 for the survey form file 220 of the inspection target date.

  Next, the control part 21 of the survey form inspection apparatus 20 performs a survey form display process (step S1-4). Specifically, the display management means 215 of the control unit 21 displays the result of the survey form inspection process using various frames recorded in the output frame data storage unit 27 in the output unit 12 as will be described later. .

And the control part 21 of the survey form inspection apparatus 20 performs the correction process of a survey form (step S1-5). Specifically, the survey form correction means 216 of the control unit 21 makes a determination based on whether or not the “correction” icon is selected on the menu screen.

  When the “correction” icon is selected on the menu screen and the survey form is corrected (in the case of “YES” in step S1-5), the control unit 21 of the survey form inspection device 20 executes a correction value acquisition process. (Step S1-6). Specifically, the survey form correction means 216 of the control unit 21 acquires the correction value of the survey form input using the input unit 11. Then, the survey form correcting means 216 generates a new correction history record 240 to which a version code is assigned for this correction, and stores it in the correction history data storage unit 24. In this case, the version code of the correction history record 240 before correction is recorded as the preceding version code. Then, the survey form correcting means 216 records the correction contents in the correction history record 240 until the series of corrections is completed.

  Next, the control unit 21 of the survey form inspection apparatus 20 executes a survey form inspection process (step S1-7). Specifically, the inspection management unit 212 of the control unit 21 executes a survey form inspection process described later again using the corrected value.

  Next, the control part 21 of the survey form inspection apparatus 20 performs a survey form display process (step S1-8). Specifically, the display management means 215 of the control unit 21 displays the result of the survey form inspection process for the corrected survey form on the output unit 12 as will be described later.

  Next, the control unit 21 of the survey form inspection device 20 executes a determination process regarding whether or not the survey form needs to be updated (step S1-9). Specifically, the inspection management means 212 of the control unit 21 outputs a confirmation screen for confirming whether or not the changed survey form needs to be updated to the output unit 12.

  When the update of the survey form is selected (in the case of “YES” in step S1-9), the control unit 21 of the survey form inspection device 20 executes the update process of the survey form (step S1-10). Specifically, the inspection management unit 212 of the control unit 21 corrects the survey form file 220 recorded in the survey form data storage unit 22 based on the correction history record 240. If the survey form update is not selected (“NO” in step S1-9), the survey form update process (step S1-10) is skipped.

  Next, the control part 21 of the survey form inspection apparatus 20 performs the determination process about whether it is complete | finished (step S1-11). Specifically, the inspection management unit 212 of the control unit 21 makes a determination based on whether or not an “end” icon is selected on the menu screen.

  When the “end” icon is selected on the menu screen (“YES” in step S1-11), the control unit 21 of the survey form inspection device 20 ends the survey form inspection program. If the “end” icon is not selected (in the case of “NO” in step S1-11), the process after the survey form correction determination process (step S1-5) is repeated.

(Survey form inspection process)
Next, the survey form inspection process will be described with reference to FIG.
In this survey form inspection process, for each check condition recorded in the check condition data storage unit 25, the control unit 21 of the survey form inspection apparatus 20 executes a four arithmetic operation check process (step S2-1). Specifically, the inspection management means 212 of the control unit 21 uses the four arithmetic operation confirmation means 213 to execute an arithmetic operation check process to be described later.

Next, for each check condition recorded in the check condition data storage unit 25, the control unit 21 of the survey form inspection apparatus 20 executes an increase / decrease rate check process (step S2-2). Specifically, the inspection management unit 212 of the control unit 21 uses the increase / decrease rate confirmation unit 214 to execute an increase / decrease rate confirmation process to be described later.

(Four arithmetic check processing)
Next, the four arithmetic operation check processing will be described with reference to FIG.
Here, the control unit 21 of the survey form inspection apparatus 20 executes a grouping process for the check condition check expression for each relational operator (step S3-1). Specifically, the four arithmetic operation confirmation means 213 of the control unit 21 acquires the check formula recorded in the check condition data storage unit 25. Here, it is assumed that the check formula (“A10 ≦ B20 + C30 ≦ 500”) illustrated in FIG.

  The arithmetic operation confirmation unit 213 performs grouping for each relational operator included in the check expression. Here, as shown in FIG. 10A, the tables divided into groups 1 to 3 are temporarily stored in the memory by dividing the check expression by the relational operator.

  Next, the control unit 21 of the survey form inspection apparatus 20 executes an item extraction process from each group (step S3-2). Specifically, the four arithmetic operation confirmation means 213 of the control unit 21 extracts items from a table temporarily stored in the memory. Here, as shown in FIG. 10B, underlined “A10”, “B20”, and “C30” are extracted in each group.

  Next, the control unit 21 of the survey form inspection apparatus 20 executes the process of acquiring the address of the value holding array for each item (step S3-3). Specifically, the four arithmetic operation confirmation means 213 of the control unit 21 uses the item name conversion file 260 recorded in the item name conversion file storage unit 26 to set the item code of the item included in each check expression for each group. Get the associated survey form code and address. In the present embodiment, as shown in FIG. 10C, in the item name conversion file 260, the item code “A10” is recorded at the address “10” of the survey form code “1”. Further, the item code “B20” is recorded at the address “20” of the survey form code “2”, and the item code “C30” is recorded at the address “30” of the survey form code “3”.

  Next, the control unit 21 of the survey form inspection apparatus 20 executes a data value acquisition process from the value holding array (step S3-4). Specifically, the four arithmetic operation confirmation means 213 of the control unit 21 accesses the survey form file designated by the survey form code. And the four arithmetic operation confirmation means 213 acquires the value recorded in the address designated in the item name conversion file from the value holding array included in this survey form. In the present embodiment, as shown in FIG. 11A, the item value “17” is acquired for the item code “A10”. Similarly, the item value “125” is acquired for the item code “B20”, and the item value “750” is acquired for the item code “C30”.

  Next, the control unit 21 of the survey form inspection apparatus 20 executes calculation processing for each check expression (step S3-5). Specifically, the four arithmetic operation confirmation means 213 of the control unit 21 substitutes the item value acquired from the value holding array into the arithmetic expression of each group. And the four arithmetic operation confirmation means 213 calculates the value of the arithmetic expression designated for every group. In the present embodiment, as shown in FIG. 11B, the group (1, 3) does not include an arithmetic expression and no calculation is performed. On the other hand, in group 2, operations using item codes “B20” and “C30” are recorded. Here, “875” is calculated by adding the item values of the two item codes.

Next, the control unit 21 of the survey form inspection apparatus 20 executes a determination process as to whether or not an error has occurred in the check condition check expression (step S3-6). Specifically, the four arithmetic operation confirmation means 213 of the control unit 21 determines whether or not the value calculated for each group satisfies a relational operator that joins the groups. In this embodiment, it is determined whether the relational operators of group 1 and group 2 and the relational operators of group 2 and group 3 are established.

  When the relational operator is not satisfied and an error occurs in the check condition check expression (in the case of “YES” in step S3-6), the control unit 21 of the survey form inspection apparatus 20 executes an error count process ( Step S3-7). Specifically, the four arithmetic operation confirmation means 213 of the control unit 21 records an error flag in the determination result data area of the operation inspection result record 231 in which the check expression code of the check expression in which an error has occurred is recorded.

  Next, the four arithmetic operation confirmation means 213 adds “1” to the value recorded in the error count data area of the item-by-item evaluation record 232 in which all item codes included in this check expression are recorded.

Furthermore, the four arithmetic operation confirmation means 213 records the total error count in the correction history record 240 of the correction history data storage unit 24.
On the other hand, when the relational operator is satisfied and no error occurs in the check condition check expression (in the case of “NO” in step S3-6), the control unit 21 of the survey form inspection apparatus 20 skips the error count process. To do.

(Change rate check process)
Next, the increase / decrease rate check process will be described with reference to FIG.
The control unit 21 of the survey form inspection device 20 executes an acquisition process of the item values recorded in the past survey form (step S4-1). Specifically, the increase / decrease rate confirmation unit 214 of the control unit 21 is a survey form file 220 in which a survey form code to be examined is recorded from the survey form data storage unit 22, and the survey date of the examination date. The file in which the previous survey date was recorded is extracted. Then, the increase / decrease rate confirmation unit 214 acquires item values for items included in the survey form to be inspected from the past survey form file 220. Also in this case, the address is specified using the item name conversion file 260, and the item value of each item is acquired from the value holding array.

  Next, the control unit 21 of the survey form inspection apparatus 20 executes an increase / decrease rate calculation process (step S4-2). Specifically, the increase / decrease rate confirmation unit 214 of the control unit 21 checks the inspection target with respect to the item values recorded in the value holding array of the past survey form for each item included in the inspection form of the inspection target. The increase / decrease rate of the item value recorded in the vote value holding array is calculated.

  Next, the control unit 21 of the survey form inspection apparatus 20 executes an acquisition process of an allowable range of item increase / decrease rate (step S4-3). Specifically, the increase / decrease rate confirmation unit 214 of the control unit 21 acquires the increase / decrease rate allowable range for each item included in the survey form to be inspected from the check condition data storage unit 25.

  Next, the control unit 21 of the survey form inspection apparatus 20 performs a determination process as to whether or not the increase / decrease rate is within an allowable range (step S4-4). Specifically, the increase / decrease rate confirmation unit 214 of the control unit 21 compares the increase / decrease rate calculated using the survey form to be inspected with the allowable range of increase / decrease rate.

When the calculated increase / decrease rate exceeds the allowable increase / decrease rate range (in the case of “NO” in step S4-4), the control unit 21 of the survey form inspection device 20 sets an increase / decrease rate error flag for the survey form item. A recording process is executed (step S4-5). Specifically, the increase / decrease rate confirmation unit 214 of the control unit 21 records an error flag in the increase / decrease rate error data area of the item-specific evaluation record 232 in the inspection result data storage unit 23.
Further, the increase / decrease rate confirmation unit 214 includes a correction history record 240 in the correction history data storage unit 24.
Record the total increase / decrease error.

(Survey form display processing)
Next, the survey form display process will be described with reference to FIG.

  Here, the control unit 21 of the survey form inspection apparatus 20 executes an output process of the survey form list frame (step S5-1). Specifically, the display management unit 215 of the control unit 21 acquires the survey form list frame from the output frame data storage unit 27. Then, the display management unit 215 sets a symbol indicating the presence / absence of the survey form file 220 of the inspection target date for the survey form code of the obtained survey form list frame. Further, the display management unit 215 acquires the operation inspection result record 231 and the item-specific evaluation record 232 from the inspection result data storage unit 23, and indicates that there is an error in the survey form code including the error in the survey form list frame. Set the symbol. Then, the display management unit 215 displays the generated survey form list frame on the output unit 12. The survey form code displayed in the survey form list frame is provided with a selection button for specifying each survey form.

  When the selection button for outputting the survey form is selected, the control unit 21 of the survey form inspection device 20 executes the process for setting the survey form item frame (step S5-2). Specifically, the display management unit 215 of the control unit 21 acquires the survey form code of the survey form specified by the selection button, and sets the survey form code and the survey target date from the survey form data storage unit 22. Obtained survey form file 220 is acquired. Further, the display management unit 215 acquires the survey form item frame from the output frame data storage unit 27. Then, the display management unit 215 assigns the item code included in the survey form file 220 to each area of the survey form item frame. Next, the display management unit 215 acquires the address of each item from the item name conversion file 260 and extracts each item value from the value holding array. Then, the display management unit 215 sets the acquired item value in each area of the item value frame corresponding to each item code of the survey form item frame.

  Next, the control unit 21 of the survey form inspection device 20 executes a determination process as to whether or not there is an error in this survey form (step S5-3). Specifically, the display management unit 215 of the control unit 21 confirms the presence or absence of an error using the item-specific evaluation record 232 in which the specified survey form code is recorded.

  When there is no error in this survey form (in the case of “NO” in step S5-3), the control unit 21 of the survey form inspection device 20 executes the display process of the survey form (step S5-4). Specifically, the display management unit 215 of the control unit 21 generates a display screen including a report display area and displays it on the output unit 12. In this report display area, an item value frame corresponding to the survey form item frame is set.

  On the other hand, when there is an error in this survey form (in the case of “YES” in step S5-3), the control unit 21 of the survey form inspection device 20 executes an error count frame setting process (step S5-5). Specifically, the display management unit 215 of the control unit 21 acquires an error count frame from the output frame data storage unit 27. Further, the display management unit 215 acquires an error count for each item code from the inspection result data storage unit 23. Then, the display management unit 215 sets an error count in an area corresponding to each item code of the survey form item frame in the error count frame.

Next, the control unit 21 of the survey form inspection apparatus 20 executes display color determination processing according to the error count (step S5-6). Specifically, the display management means 215 of the control unit 21 assigns display colors determined in the color arrangement table in order of increasing error count in each area of the error count frame.

  Next, the control unit 21 of the survey form inspection apparatus 20 executes an increase / decrease rate error frame setting process (step S5-7). Specifically, the display management unit 215 of the control unit 21 acquires an increase / decrease rate error frame from the output frame data storage unit 27. Further, the display management unit 215 uses the inspection result data storage unit 23 to check whether or not the increase / decrease rate error flag is recorded for each item code. Next, the display management means 215 sets the presence / absence of an increase / decrease rate error in the area corresponding to each item code of the survey form item frame in the increase / decrease rate error frame. Then, the display management unit 215 assigns different display colors to an area having an increase / decrease rate error and an area having no increase / decrease rate error.

  Next, the control unit 21 of the survey form inspection apparatus 20 executes a survey form display process (step S5-8). Specifically, the display management unit 215 of the control unit 21 generates a display screen in which an item value frame corresponding to the survey form item frame is set in the report display area. Further, the display management means 215 includes an error list display area on this display screen. The error list display area includes a selection icon for switching between error count display and increase / decrease rate error display.

  Here, when the error count display icon is selected, the control unit 21 of the survey form inspection device 20 executes display processing of the four arithmetic operation check processing results (step S5-9). Specifically, the display management means 215 of the control unit 21 sets the display color of each area of the error count frame as the background color of each area of the survey form item frame included in the display screen. Further, when an area in which an error is recorded in the error count frame is selected, the display management unit 215 acquires the item code of this area from the survey form item frame. Then, the display management unit 215 acquires a check expression including this item code from the check condition data storage unit 25. Further, the display management unit 215 acquires an error count for the item code from the inspection result data storage unit 23. Next, the display management means 215 records the item code in which the error is recorded in the error list display area, the check expression recorded in the operation inspection result record 231 for this item code, and the item-specific evaluation record 232. Display error count.

  On the other hand, when the increase / decrease rate error display icon is selected, the control unit 21 of the survey form inspection device 20 executes a display process of the increase / decrease rate check processing result (step S5-10). Specifically, the display management means 215 of the control unit 21 sets the display color of each area of the increase / decrease rate error frame as the background color of each area of the survey form item frame included in the display screen. Further, when an area in which an error is recorded in the increase / decrease rate error frame is selected, the display management unit 215 acquires the item code of this area from the survey form item frame. Then, the display management unit 215 acquires the increase / decrease rate allowable range for this item code from the check condition data storage unit 25. Next, the display management means 215 displays the item code in which the error is recorded, the increase / decrease rate and the allowable increase / decrease range for this item code in the error list display area.

Next, the control unit 21 of the survey form inspection apparatus 20 executes an error comparison display process before and after correction (step S5-11). Specifically, the display management unit 215 of the control unit 21 confirms whether or not the correction history record 240 is recorded in the correction history data storage unit 24. When the correction history record 240 is recorded, the preceding version code recorded in the correction history record 240 is acquired. Then, the display management unit 215 acquires from the correction history data storage unit 24 the error count and the increase / decrease rate error number of the survey form in which the preceding version code is recorded. Then, the display management unit 215 displays an error comparison screen on the output unit 12 on which error conditions (error count and increase / decrease rate error number) before and after correction are displayed. If the correction history record 240 is not recorded, an error comparison display process (step S5-11)
) Is not performed.

  Next, the control unit 21 of the survey form inspection apparatus 20 executes a determination process regarding whether or not display change is desired (step S5-12). Specifically, when an inspection of another survey form is desired, a selection button for a desired survey form is selected in the survey form list frame. When it is determined that there is a desire to change the display by selecting the survey form selection button ("YES" in step S5-12), the control unit 21 of the survey form inspection apparatus 20 selects the survey form list. The processing after step S5-2 is repeated for the survey form selected in the frame. On the other hand, when the display change is not desired (“NO” in step S5-12), the control unit 21 of the survey form inspection apparatus 20 ends the survey form display process.

As described above, according to the present embodiment, the following effects can be obtained.
(1) In the said embodiment, the control part 21 of the survey form inspection apparatus 20 performs four arithmetic operation check processes (step S2-1). Thereby, it is possible to identify inconsistencies (for example, calculation errors and wrinkles about the same item) regarding the item values of each item set in the survey form.

  Furthermore, in the four arithmetic operation check processing, the control unit 21 of the survey form inspection device 20 executes error count processing (step S3-7). In the check condition, when a plurality of item codes are related to one check expression, it is difficult to determine which item has the wrong item value. Therefore, when each item included in the survey form is related to a plurality of check conditions, it is possible to identify an item that is highly likely to be wrong based on the error count calculated for each item code.

  (2) In the above embodiment, the control unit 21 of the survey form inspection device 20 executes the increase / decrease rate check process (step S2-2). Thereby, the abnormal value included in the survey form to be inspected can be specified by using the item value of the past survey form. Then, it is possible to identify an item that may be erroneous due to the abnormal value.

  (3) In the said embodiment, the control part 21 of the survey form inspection apparatus 20 performs the setting process of an error count frame (step S5-5). And the control part 21 of the survey form inspection apparatus 20 performs the determination process of a display color according to an error count (step S5-6). When the error count display icon is selected, the control unit 21 of the survey form inspection device 20 executes display processing of the four arithmetic operation check processing results (step S5-9). Specifically, the display management means 215 of the control unit 21 sets the display color of each area of the error count frame as the background color of each area of the survey form item frame included in the display screen. As a result, it is possible to grasp the distribution of error counts and efficiently identify items in which many errors have occurred. Then, by changing the item value of this item preferentially, the survey form can be corrected efficiently.

  On the other hand, when the increase / decrease rate error display icon is selected, the control unit 21 of the survey form inspection device 20 executes a display process of the increase / decrease rate check processing result (step S5-10). Specifically, the display management means 215 of the control unit 21 sets the display color of each area of the increase / decrease rate error frame as the background color of each area of the survey form item frame included in the display screen. Thereby, the distribution of the increase / decrease rate error can be grasped, and the item for which the abnormal value is set can be efficiently identified and corrected.

(4) In the embodiment described above, the correction history data storage unit 24 stores the correction history record 240 for the survey form that has been corrected based on the check result. The correction history record 240 includes data relating to the version code, the preceding version code, the correction content, the total error count, and the total increase / decrease error. And the control part 21 of the survey form inspection apparatus 20 performs the error comparison display process before and behind correction (step S5-11). Thereby, it is possible to specify a correction with few errors. Further, when the number of errors is increased due to the correction, the survey form can be returned to the original state using the correction contents in the preceding version code, and the correction can be performed again.

In addition, you may change the said embodiment into the following aspects.
In the above embodiment, the control unit 21 of the survey form inspection apparatus 20 executes display color determination processing according to the error count (step S5-6). The display method of the error state is not limited to this. For example, an item to be preferentially corrected may be specified based on the error occurrence rate. Specifically, a plurality of check expressions are used as shown in FIG. Here, it is assumed that the check expression (A, D, E) is not established and the check expression (B, C) is established. Each check expression uses item codes (1) to (7) as variables.

  Therefore, the control unit 21 of the survey form inspection device 20 counts the number of satisfied check expressions and the number of unsatisfied items for each item. In the present embodiment, the number of established and unestablished items is as shown in FIG. And the control part 21 of the survey form inspection apparatus 20 calculates a formation rate by dividing the number of formation by a total number. And the control part 21 of the survey form inspection apparatus 20 determines the order of a correction candidate in an order from the item with this low establishment ratio. Based on this establishment ratio, an item value of an item that is highly likely to be wrong can be specified, and this item can be preferentially corrected.

  In the above embodiment, the control unit 21 of the survey form inspection apparatus 20 executes display color determination processing according to the error count (step S5-6). Instead of this, the control unit 21 of the survey form inspection apparatus 20 may calculate a correction value by simulation. In this case, an item that is highly likely to be wrong is specified, and a predetermined value is sequentially added or subtracted for the item value of this item. Then, an item value having the smallest error count total and increase / decrease rate error total is searched. As a result, the contents of correction can be identified efficiently.

  In the above embodiment, the control unit 21 of the survey form inspection device 20 executes the display processing of the four arithmetic operation check processing results (step S5-9) and the display processing of the increase / decrease rate check processing results (step S5-10). The display method of each check processing result is not limited to this, and both may be displayed on the same screen.

  In the above embodiment, the survey form inspection device 20 includes the survey form data storage unit 22, the inspection result data storage unit 23, the correction history data storage unit 24, the check condition data storage unit 25, the item name conversion file storage unit 26, and the output. A frame data storage unit 27 is provided. The hardware configuration is not limited to this, and it is not necessary to provide all the data storage units in the survey form inspection apparatus 20. For example, data necessary for the survey form inspection process may be acquired from another system via a network.

  In the above embodiment, the correction history data storage unit 24 stores the correction history record 240 for the survey form that has been corrected based on the check result. In the correction content data area of the correction history record 240, data relating to the content of the corrected survey form is recorded. Alternatively, when correction is performed, the corrected value holding array may be recorded for each version code. In this case, all item values in this version can be acquired without using the preceding version code.

In the above embodiment, the total error count and the increase / decrease rate error total are recorded in the correction history data storage unit 24. Instead, when each survey form is displayed, the survey form inspection process may be executed each time to calculate the total number of errors.

  In the above embodiment, the check condition data storage unit 25 stores check condition data 250 for conditions used when checking each item included in the survey form. In the check condition data 250, the increase / decrease rate check condition record 252 is configured to include data on item codes and increase / decrease rate allowable ranges. In this increase / decrease rate allowable range data area, data relating to the range of the increase / decrease rate allowed in the item value of each item is recorded. Here, the increase / decrease rate allowable range may be calculated based on the past item values recorded in the survey form history information storage means. Specifically, when the increase / decrease rate check process is executed, the increase / decrease rate confirmation unit 214 acquires item values of a predetermined reference period from the survey form history information storage unit for each item to be inspected. Then, the increase / decrease rate confirmation unit 214 performs a regression analysis on this item value, and calculates a change tendency and a fluctuation range. Next, the increase / decrease rate confirmation unit 214 calculates the prediction range of the current item value using the change tendency and the fluctuation range. Then, the increase / decrease rate confirmation unit 214 performs an increase / decrease rate check process using the predicted range as the allowable increase / decrease rate range. Thereby, the item which deviated from the range of the item value estimated from a track record value is detectable.

  DESCRIPTION OF SYMBOLS 11 ... Input part, 12 ... Output part, 20 ... Survey form inspection apparatus, 21 ... Control part, 211 ... Data reading means, 212 ... Inspection management means, 213 ... Four arithmetic operation confirmation means, 214 ... Increase / decrease rate confirmation means, 215 ... Display management means, 216 ... survey form correction means, 22 ... survey form data storage section, 23 ... inspection result data storage section, 24 ... correction history data storage section, 25 ... check condition data storage section, 26 ... item name conversion file storage 27, an output frame data storage unit, 30 ... a data reading device.

Claims (6)

Survey form storage means for storing a survey form in which item values for a plurality of items are recorded;
As a check condition for the item, a check condition storage unit that records an arithmetic expression using a variable as an item value recorded in a plurality of items included in the survey form ;
Confirmation result storage means for recording confirmation results using check conditions for each item;
A survey form inspection system comprising a control means for inspecting item values included in a survey form,
The control means is
Means for obtaining a survey form to be inspected from the survey form storage means;
From the check condition storage means, obtain an arithmetic expression to be applied to each item of the survey form,
For each of the arithmetic expression, and means for substituting the field values stored in each item as a variable, it executes the determining questionnaire inspection process satisfiability of the mathematical expression,
When not satisfying the arithmetic expression , means for recording error information in the confirmation result storage means for all items of the variable constituting the arithmetic expression ;
Means for calculating the number of errors obtained by counting the error information recorded in the confirmation result storage means for each item and outputting a display corresponding to the number of errors for each item when the determination for all the check conditions is completed The survey form inspection system characterized by comprising. The check condition storage means further stores an allowable range of increase / decrease rate for each item of the survey form as a check condition,
It further comprises survey form history information storage means for recording past survey forms,
The control means further comprises:
Using the survey form recorded in the survey form history information storage means, calculate the increase / decrease rate of each item,
Compare the allowable range recorded in the check condition storage means with the rate of increase / decrease of each item included in the survey form to be inspected,
When said rate of change exceeds the allowable range, the check result storage means, questionnaires inspection system according to claim 1, characterized in that to record the error information for this item. The control means is
When the correction value of the value recorded in each item is acquired, the correction value is recorded in the correction information storage means,
Using the correction value, execute the survey form inspection process,
Record the error number distribution in relation to the correction value,
The survey form inspection system according to claim 1 or 2 , wherein the distribution of the number of errors before and after correction is displayed so as to be compared. Questionnaire inspection system according to any one of claims 1-3, characterized by outputting the correction candidate in accordance with the number of errors in the questionnaire. Survey form storage means for storing a survey form in which item values for a plurality of items are recorded;
As a check condition for the item, a check condition storage unit that records an arithmetic expression using a variable as an item value recorded in a plurality of items included in the survey form ;
Confirmation result storage means for recording confirmation results using check conditions for each item;
A method for inspecting a survey form using a survey form inspection system having a control means for inspecting item values included in a survey form,
The control means is
Obtaining a survey form to be inspected from the survey form storage means;
From the check condition storage means, obtain an arithmetic expression to be applied to each item of the survey form,
For each of the arithmetic expression, the method comprising substituting the field values stored in each item as a variable, executes the determining questionnaire inspection process satisfiability of the mathematical expression,
When not satisfying the arithmetic expression , recording error information in the confirmation result storage means for all items of the variable constituting the arithmetic expression ;
A step of calculating the number of errors obtained by counting the error information recorded in the confirmation result storage unit for each item and outputting a display corresponding to the number of errors for each item when the determination for all the check conditions is completed And a questionnaire inspection method characterized in that Survey form storage means for storing a survey form in which item values for a plurality of items are recorded;
As a check condition for the item, a check condition storage unit that records an arithmetic expression using a variable as an item value recorded in a plurality of items included in the survey form ;
Confirmation result storage means for recording confirmation results using check conditions for each item;
A program for inspecting a survey form using a survey form inspection system having a control means for inspecting item values included in a survey form,
The control means;
Means for obtaining a survey form to be inspected from the survey form storage means;
From the check condition storage means, obtain an arithmetic expression to be applied to each item of the survey form,
For each of the arithmetic expression, substitutes the field values stored in each item as a variable, means for performing a survey inspection process determines satisfaction of the mathematical expression,
If the arithmetic expression is not satisfied, means for recording error information in the confirmation result storage means for all items of variables constituting the arithmetic expression ,
Means for calculating the number of errors obtained by counting the error information recorded in the confirmation result storage means for each item and outputting a display corresponding to the number of errors for each item when the determination for all the check conditions is completed Survey form inspection program characterized by functioning as

Images