JP2000099377A - Record updation processor and program recording medium therefor - Google Patents

Abstract

PROBLEM TO BE SOLVED: To update an object record planned to be updated at its set time as it is set by only preliminarily designating an optional record as an object record planned to be updated and also, setting updation instruction data instructing when and how updation should be performed in each record. SOLUTION: An optional record among employee records in an employee information file 12-1 is designated as an object record planned to be updated and updation data for updating the designated record is set to an undecided issue file 12-2 with its updation time as issue data in each record. In this state, a CPU 1 updates a corresponding employee record in the file 12-1 based on issue data arriving at its updation time.

Description

DETAILED DESCRIPTION OF THE INVENTION

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a record update processing device for updating record data and a program recording medium for the same.

[0002]

2. Description of the Related Art Conventionally, in an information processing apparatus which performs personnel management in a company or the like, employee information is stored and managed as a personnel database. It updates the employee records in the database based on it. In this case, the update of the record is executed on the premise of a decision instruction given a decision on the issuance. That is, the record is updated when the instruction data is input and the decision is made that the decision has been made, and the affiliation code and the post code are rewritten.

[0003]

As described above, the record is not updated unless a decision instruction is given by an input operation, so that the instruction must be given for each decision, which makes the business processing complicated. There was a drawback of inviting. An object of the present invention is to specify an arbitrary record in advance as a target record to be updated and to set update instruction data for instructing when and what update is to be performed for each record by simply setting the update instruction data for each record. To be updated as set at the set time.

[0004]

The means of the present invention are as follows. According to the first aspect of the present invention, among various records, an arbitrary record is specified in advance as a target record to be updated, and update data for updating the specified record and the update time are used as update instruction data. Setting means for setting for each record, timing means for obtaining timing information, and whether the update time has been reached by comparing the timing information obtained by the timing means with the update time set for each record by the setting means Determination means for determining whether or not the record has been updated; and when the determination means determines that the update time has been reached, the record is updated based on the update data set corresponding to the record. And updating means for performing the updating.
The present invention may be as follows. (1) A start timing setting unit for arbitrarily setting a start timing for automatically starting the update process may be provided, and the determining unit may determine whether or not the update timing has been reached for each of the start timings. . (2) In the case where an update category is set for each record, indicating whether the record is to be updated automatically when the update time arrives, or if the update time arrives, the automatic update is suspended and the operation of the update instruction is waited. The updating means may control the execution of the updating process according to the update category. (3) The update instruction data set corresponding to the record may be deleted when the update processing is performed by the update unit. (4) When the update process is performed by the update unit, the record storage unit may store the record before the update and the record after the update in association with each other.

According to the first aspect of the present invention, an arbitrary record is specified in advance as a target record to be updated, and update data for updating the specified record and the update time are set for each record as update instruction data. Time information (eg current date)
By comparing the data with the update time set for each record, it is determined whether the update time has been reached. If the update time has been reached, the update data set for the record is determined. The record is updated based on. Therefore, an arbitrary record is specified in advance as a target record to be updated, and update instruction data indicating when and what update is to be performed is set for each record. Can be updated as set.

[0006]

DETAILED DESCRIPTION OF THE PREFERRED EMBODIMENTS An embodiment of the present invention will be described below with reference to FIGS. FIG. 1A is a block diagram showing the overall configuration of the data processing device. The CPU 1 is a central processing unit that controls the overall operation of the data processing device according to various programs. The storage device 2 includes a storage medium 3 in which an operating system, various application programs, a database, character font data, and the like are stored in advance, and a drive system thereof. The storage medium 3 is fixedly provided or removably mountable, and includes a magnetic / optical storage medium such as a floppy disk, a hard disk, an optical disk, and a RAM card, and a semiconductor memory. The programs and data in the storage medium 3 are loaded into the RAM 4 under the control of the CPU 1 as needed. Further, the CPU 1 receives programs and data transmitted from other devices via a communication line or the like and stores them in the storage medium 3 or stored in a storage medium provided in other devices. Existing programs and data can be used via a communication line or the like. Further, an input device 5, a display device 6, and a printing device 7, which are input / output peripheral devices, are connected to the CPU 1 via a bus line, and the CPU 1 controls these operations according to an input / output program.
The input device 5 has a pointing device such as a keyboard and a mouse for inputting character string data and the like and for inputting various commands. Here, when character string data is input from the input device 5 at the time of database creation, the display device 6
Is displayed on the text screen and the determined character string determined by the Kana-Kanji conversion is stored in the RAM 4. The display device 6 is a liquid crystal display device, a CRT display device, a plasma display device, or the like that performs multicolor display.
The printing device 7 is a full-color printer device, and is a non-impact printer such as thermal transfer or inkjet or a dot impact printer.

FIG. 1B is a diagram showing a characteristic portion in the storage device 2. The employee information file 12-1 stores employee information for each employee as data for one record.
As shown in FIG. 2A, one record is composed of field data of employee No., affiliation code, post code,.... FIG. 2A shows the state before the record is updated.
FIG. 2B illustrates the contents of the employee information file 12-1 after updating the record. The undecided issuance file 12-2 stores, for each employee, the undecided issuance data among the issuances indicating personnel changes, and as shown in FIG. Date of issue, category of issue, category of automatic decision, affiliation code,
The post code is stored. Here, the “issuing date” is the actual day when the personnel change is issued, and the “issuing category” is data indicating the type of issuing indicating promotion, movement, or the like. The "automatic approval classification" is to automatically update the corresponding employee record in the employee information file 12-1 when the date of issue is reached, or to suspend the automatic update and perform the input operation in the same manner as usual. Indicates whether the record is updated. When the flag "1" is set in the "automatic approval classification", it indicates that the record is to be automatically updated, and when the flag "0" is set, the automatic update is not to be performed. ing. “Affiliation code” and “post code” are field data to be updated in accordance with the contents of the “announcement category”. FIG. 3 (A) shows the data before the approval of the announcement data.
FIG. 3B shows an undecided issuance notification file 12-
2 is illustrated. Declaration file 12-3
Is stored in the employee data in the employee information file 12-1 when the employee record in the employee information file 12-1 is updated based on the official data in the undecided authority file 12-2. The announcement data is read from the undecided announcement file 12-2, and the approved announcement file 1 is read.
Moved to 2-3. Fig. 4 shows this file 1
2-3 shows an example, (A) after the previous decision, (B)
Indicates the state after the current decision, and even if the command data is moved from the undecided command file 12-2 to the cleared command file 12-3 by the current command, the command data that was previously determined is used as the command history as it is. Will be retained. The update timing setting memory 12-4 is used to set an update timing for starting the execution of the automatic update process of the employee record. For example, any one of a day unit, a month unit, and a day unit is selectively set.

Next, the operation of the data processing apparatus will be described with reference to FIGS.
This will be described according to the flowchart shown in FIG. here,
Programs for implementing the functions described in these flowcharts are stored in the storage medium 3 in the form of program codes readable by the CPU 1, and
The operation according to the contents is performed. FIG. 5 is a flowchart showing the operation in the case where the undecided execution command data is collectively set in advance in the undecided execution file 12-2. First, the employee number of the employee whose personnel change has been issued is input from the input device 5 (step A1), the date of issuance is input (step A2), and when an instruction category is input (step A3), the input is made. Employee number, date of announcement,
The issue category is stored and held in the work area in the RAM 4 as input item data. Next, a screen for selecting an automatic decision category is displayed.
When one of the items is not selected (step A4), the selected item is determined (step A5), and the flag “1” is set (step A6) or the flag “0” is set (step A7) accordingly. . Next, the new assigned affiliation code is input (step A).
8) When a post code is input (step A9), the entered affiliation code and post code are stored and held in a work area in the RAM 4. When the item data for one record has been collected in this way, the CPU 1 generates an announcement record in which the item data stored in the work area in the RAM 4 are arranged in the order of the items, and temporarily stores the record in the RAM 4 (step A10). ). Then, it is checked whether the setting is completed (step A1).
1), the process returns to step A1 until there is an end instruction, and the above operation is repeated for each record. Here, when the setting end is instructed, each issue record in the RAM 4 is stored in the undecided issue file 12-2 (step A1).
2).

FIG. 6 is a flowchart showing a command data decision process which is started in response to a command command from the operator. First, the contents of the undecided issuance notification file 12-2 are read out and displayed in a list (step B1). Here, when the execution data to be settled is arbitrarily selected from the list display (step B2), the selected execution data is read out from the undecided execution file 12-2 and stored in the settled execution file 12-3. At the same time as moving (step B3), the moved issuing data is stored in the undecided issuing file 1
2-2 is deleted (step B4). Then, the record in the employee information file 12-1 is updated based on the selected announcement data (step B5). In this case, the employee information file 12-1 is searched using the employee number in the selected announcement data as a key, and any one of the affiliation code or the post code in the searched employee record is entered in the announcement data. And then rewrite the contents of this selection item to the corresponding affiliation code or post code in the announcement data. When the update for one record is completed in this way, it is checked whether the selection end is instructed (step B6), and the process returns to step B2 until there is an end instruction, and the above operation is repeated for each record. As described above, the operator can update the record in the employee information file 12-1 as usual by selecting arbitrary announcement data and giving the decision instruction.

FIG. 7 is a flowchart showing a process for automatically updating the contents of the employee information file 12-1 based on the issuing data in the undecided issuing file 12-2. First, the CPU 1 accesses the update timing setting memory 12-4, reads out update timing in units of days, months, and days of the week (step C1), and checks whether the update timing has been reached (step C2). In this case, the update timing is detected by determining whether 24 hours, one month, and one week have elapsed since the last update.
Here, if it is not the update timing, the process directly exits from this flow, but if it is the update timing, the issuing data for one record from the head of the undecided issuing file 12-2 is extracted (step C3). Then, it is checked whether the “automatic decision section” in the extracted record is “1” (step C).
4) If the automatic decision category is "0", the record is not subject to the automatic decision, so the process proceeds to step C10, where the next record is extracted from the undecided issuance file 12-2, and it is determined whether the record is completed. Check (step C11). If the record has not ended, the process returns to step C4,
It is checked whether the automatic decision classification in the extracted record is “1”.

As a result, when the issuing data with the automatic decision classification of “1” is extracted, the issuing date is extracted from the issuing data (step C5), and the issuing date and the system date (current date) are set. Are compared (step C6). Here, if the current date has not reached the issue date, the process proceeds to step C10, and the next record is extracted. on the other hand,
If the current date is equal to or greater than the date of issuance, that is, if the current date is after the date of issuance or the date of issuance, the issued data is moved to the approved issued file 12-3 (step C7), and the moved issued data is stored in the file. Undecided Announcement File 1
Delete from 2-2 (step C8). Then, the corresponding record in the employee information file 12-1 is updated based on the announcement data. At this time, the employee N in the announcement data is updated.
Search for the applicable employee record using o. as a key, select either the affiliation code or post code in this employee record according to the categorization in the announcement data, and change the contents of this selection item to the affiliation code in the announcement data. Or rewrite it as a post code. In this case, if the announcement category indicates promotion or demotion, the post code is updated, and if it indicates movement, the affiliation code is updated.
Then, the next record is extracted (step C10), and thereafter, the process returns to step C4 until the end of the record is detected in step C11, and the above operation is repeated for each record.

By executing such an update process, the contents of the undecided issuance notification file 12-2 are changed from the state shown in FIG. 3 (A) to the state shown in FIG. 3 (B). Announcement data that has reached the issuance date are all deleted from the undecided issuance announcement file 12-2. Further, before and after the execution of the current update process, before execution of the current update, as shown in FIG. 4A, the previously issued announcement data is stored, and in this state, the current update process is performed. As shown in FIG. 4 (B), the previously-issued announcement data and the currently-announced announcement data are stored in the approved-issue file 12-3 in association with each other. In this case, the previously issued issue data is stored and held as an issue history, and its contents can be read and confirmed at any time. Further, the contents of the employee information file 12-1 are changed from the state shown in FIG.
Is rewritten to the state shown in.

As described above, in this data processing apparatus, an arbitrary employee record among the employee records constituting the employee information file 12-1 is designated as a target record to be updated in accordance with the announcement of the personnel change, and the corresponding employee record is designated. If the update data indicating which field data in the designated record is to be updated and how to update the data and the update data including the update time (date of issue) are set in advance in the undecided issue file 12-2, the date of the issue is reached. The corresponding record being updated can be automatically updated according to the update data.
Therefore, as in the past, the personnel manager constantly monitors the date of issuance, and can save the trouble of giving a decision-making instruction by input operation every time the date of the issuance is issued, thereby making it possible to increase the efficiency of business processing. . In addition, since the automatic decision category is set in the announcement data, the undecided announcement data in which the record is updated according to the approval instruction from the personnel officer and the decision announcement data in which the automatic update is performed based on the issue date are set. They can be mixed in the undecided issuance file 12-2, and are arbitrarily selected according to the importance of the issuance and whether or not the issuance of the issuance is possible. Can be set. In addition, since the decision-completed announcement file 12-3 previously stores and retains the decision-completed announcement data of the present time in association with the previous one, it is possible to easily confirm the announcement history.

In the above-described embodiment, the update timing is arbitrarily set and the update process is performed at each update timing. However, the update process may be performed at the start or end of daily work. Further, although the issuance of the personnel change is described as an example, the present invention is not limited to the issuance of the personnel, and the product order data to be ordered in the future may be set together with the order date. Furthermore, the case where predetermined field data is rewritten as new item data as the type of update has been illustrated,
The type of update such as addition update and subtraction update is not limited.

[0015]

According to the present invention, an arbitrary record is designated in advance as a target record to be updated, and update instruction data for instructing when and what update is to be performed is set for each record. Since the target record to be updated can be updated as set at the set time, it is possible to improve the efficiency of business processing.

[Brief description of the drawings]

FIG. 1A is a block diagram illustrating an overall configuration of a data processing device, and FIG. 1B is a diagram illustrating a characteristic portion in a storage device 2.

FIG. 2 illustrates the contents of an employee information file 12-1;
7A is a diagram showing the contents of an employee information file 12-1 before updating, and FIG.

FIG. 3 illustrates the contents of the undecided issuance file 12-2,
(A) is a diagram showing the contents before the decision of the issuing data, and (B) is a diagram showing the contents after the decision of the issuing data.

FIG. 4 exemplifies the contents of the approved announcement file 12-3,
(A) shows the contents after the previous decision, and (B) shows the contents after the current decision.

FIG. 5 is a flowchart showing a process of setting undecided announcement data.

FIG. 6 is a flowchart showing an issuing data decision process.

FIG. 7 is a flowchart illustrating an automatic update process.

[Explanation of symbols]

 DESCRIPTION OF SYMBOLS 1 CPU 2 Storage device 3 Storage medium 4 RAM 5 Input device 12-1 Employee information file 12-2 Undecided notification file 12-3 Decided notification file 12-4 Update timing setting memory

Claims (6)

[Claims] 1. An arbitrary record among various records is designated in advance as a target record to be updated, and update data for updating the designated record and its update time are set as update instruction data for each record. Setting means for performing, time measuring means for obtaining time information, and comparing the time information obtained by the time measuring means with the update time set for each record by the setting means to determine whether or not the update time has been reached. Determining means for determining, and updating means for updating the record based on the update data set corresponding to the record when the determining means determines that the update time has been reached. A record update processing device comprising: 2. An apparatus according to claim 1, further comprising: a start timing setting unit for arbitrarily setting a start timing for automatically starting an update process, wherein said determination unit determines whether or not an update timing has been reached for each of said start timings. 2. The record update processing device according to claim 1, wherein: 3. An update category is set for each record, indicating whether a record is automatically updated when the update time has arrived, or if the update time has arrived, the automatic update is suspended and an update instruction operation is waited. 2. The apparatus according to claim 1, wherein said updating means controls the execution of the updating process according to the update category. 4. The record update according to claim 1, wherein when update processing is executed by said update means, said update instruction data set corresponding to said record is deleted. Processing equipment. 5. The apparatus according to claim 1, wherein when the update processing is executed by the update means, the record storage means stores the record before the update and the record after the update in association with each other. Record update processing device according to the description. 6. A recording medium having a program code read by a computer, wherein an arbitrary record among various records is designated in advance as a target record to be updated, and an update record for updating this designated record is provided. A function of setting the data and its update time for each record as update instruction data, and a function of determining whether or not the update time has been reached by comparing the timing information and the update time set for each record, Recording medium having a program code for realizing a function of updating a record based on the update data set corresponding to the record when it is determined that the update time has been reached .