JP2019159688A - Qualification allowance total amount calculation device, qualification allowance total amount calculation method, and qualification allowance total amount calculation program - Google Patents

Abstract

To provide a qualification allowance total amount calculation device, a qualification allowance total amount calculation method, and a qualification allowance total amount calculation program, which can calculate the total amount of qualification allowance amounts for qualifications held by employees.SOLUTION: The present embodiment (1) acquires a qualification CD associated with a specified employee CD from an employee-holding qualification registration master including an employee CD and a qualification CD, (2) acquires a qualification allowance amount associated with the qualification CD acquired by the above (1) from a qualification master including the qualification CD and qualification allowance amounts, and (3) calculates the total amount of the qualification allowance amounts acquired by the above (2).SELECTED DRAWING: Figure 8

Description

  The present invention relates to a qualification allowance total amount calculation device, a qualification allowance total amount calculation method, and a qualification allowance total amount calculation program.

  Patent Document 1 automatically executes payroll work just by entering information entered in the daily work report, and can easily create an appropriate wage ledger and various necessary report documents, as well as significant payroll work. A construction salary calculation method that can save labor is disclosed (see paragraph 0003 of Patent Document 1).

JP-A-7-65084

  In the field of payroll calculation, it has been difficult to automatically calculate the total amount of qualification allowance for qualifications held by employees.

  The present invention has been made in view of the above problems, and is a qualification allowance total amount calculation device, a qualification allowance total amount calculation method, and a qualification allowance total that can calculate the total amount of qualification allowances for qualifications held by employees. The purpose is to provide an amount calculation program.

  In order to solve the above-described problems and achieve the object, a qualification allowance total amount calculation device according to the present invention is a qualification allowance total amount calculation device including a control unit and a storage unit, and the storage unit includes A qualification master including qualification identification data for identifying the qualification and a qualification allowance that is an allowance for the qualification, and an employee qualification registration master including the employee identification data for identifying the employee and the qualification identification data. The control unit is acquired by the qualification acquisition means from the qualification master, qualification acquisition means for acquiring the qualification identification data associated with the specified employee identification data from the employee possession qualification registration master An allowance amount acquisition means for acquiring a qualification allowance amount associated with the qualification identification data; and a total amount calculation means for calculating a total amount of the qualification allowance amount acquired by the allowance amount acquisition means. And, characterized by.

  In the qualification allowance total amount calculation device according to the present invention, the employee possession qualification registration master further includes an employee unit qualification allowance supply flag, and the employee unit qualification allowance supply flag provides a certain qualification as the provision of the qualification allowance amount. Either one of the flag indicating that it is a target and the flag indicating that it is not a supply target is set for each employee, and the qualification acquisition means is specified from the employee qualification registration master. It is further characterized by further comprising supply target qualification acquisition means for acquiring qualification identification data associated with the employee identification data and the flag indicating the supply target.

  Further, in the qualification allowance total amount calculation device according to the present invention, the employee possession qualification registration master further includes an expiration date of the qualification, and the qualification acquisition unit is configured to identify the designated employee identification from the employee possession qualification registration master. It further comprises valid qualification acquisition means for acquiring qualification identification data associated with the data and the expiration date after the salary payment date for the employee.

  Further, the qualification allowance total amount calculation device according to the present invention is the priority order of payment of the qualification allowance for the qualification within the same qualification classification as the qualification classification for identifying the classification to which the qualification master belongs. The qualification acquisition means acquires qualification identification data associated with the designated employee identification data from the employee possession qualification registration master, and further, the qualification master associated with the acquired qualification identification data Qualification classification and acquisition means for acquiring the qualification classification and priority in the qualification, and qualification identification associated with the highest priority among the same qualification classification acquired by the qualification classification acquisition means from the qualification master And a higher-level qualification acquisition means for acquiring data.

  In the qualification allowance total amount calculation device according to the present invention, the qualification master further includes related business identification data for identifying a business related to the qualification, and the storage unit is engaged with employee identification data and employees. An employee master including engagement work identification data for identifying the work to be performed is further stored, and the qualification acquisition unit is connected to the designated employee identification data from the employee possession qualification registration master. And the related work acquisition means for acquiring the related work identification data in the qualification master associated with the acquired qualification identification data, and the engagement work associated with the designated employee identification data from the employee master. Engagement work acquisition means for acquiring identification data; and from the qualification master, the engagement work acquisition of the related work identification data acquired by the related work acquisition means. Further comprising a business qualification acquisition means for acquiring a string attached qualification identification data and which matches the engaged business identification data acquired by the step, and characterized.

  The qualification allowance total amount calculation method according to the present invention is a qualification allowance total amount calculation method executed by an information processing apparatus including a control unit and a storage unit, and the storage unit is for identifying the qualification. A qualification master that includes qualification identification data and a qualification allowance that is an allowance for the qualification, and an employee holding qualification registration master that includes employee identification data and qualification identification data for identifying the employee; Qualification acquisition step for obtaining qualification identification data associated with designated employee identification data from the employee possession qualification registration master, executed by the control unit, and the qualification acquired from the qualification master in the qualification acquisition step An allowance amount acquisition step for acquiring a qualification allowance amount associated with the identification data, and a total amount calculation step for calculating a total amount of the qualification allowance amount acquired in the allowance amount acquisition step. Include a flop, and characterized.

  Further, a qualification allowance total amount calculation program according to the present invention is a qualification allowance total amount calculation program for causing an information processing apparatus including a control unit and a storage unit to execute, and the storage unit identifies a qualification Qualification master including qualification identification data and qualification allowance, which is the allowance for qualification, and employee holding qualification registration master including employee identification data and qualification identification data for identifying employees The qualification acquiring step for acquiring the qualification identification data associated with the specified employee identification data from the employee holding qualification registration master, and the qualification master acquiring in the qualification acquisition step The allowance amount acquisition step for acquiring the qualification allowance amount associated with the qualification identification data, and the total amount of the qualification allowance amount acquired in the allowance amount acquisition step Comprise a total amount calculation step of calculating, the features a.

  According to the present invention, it is possible to calculate the total amount of qualification allowances for qualifications held by employees.

FIG. 1 is a block diagram showing an example of the configuration of the qualifying allowance total amount calculation device. FIG. 2 is a diagram illustrating a data configuration example in the qualification master. FIG. 3 is a diagram illustrating a data configuration example in the employee possession qualification registration master. FIG. 4 is a diagram illustrating an example of qualification acquisition in consideration of the supply flag. FIG. 5 is a diagram illustrating an example of qualification acquisition in consideration of the expiration date of the qualification. FIG. 6 is a diagram illustrating an example of qualification acquisition in consideration of the qualification classification and the higher rank No. FIG. 7 is a diagram illustrating an example of qualification acquisition in consideration of employee engagement work and qualification related work. FIG. 8 is a diagram illustrating an example of calculating the total amount of qualification allowances for acquired qualifications.

  Hereinafter, embodiments of a qualification allowance total amount calculation device, a qualification allowance total amount calculation method, and a qualification allowance total amount calculation program will be described in detail based on the drawings. In addition, this invention is not limited by this embodiment. Hereinafter, a specific configuration and operation will be described.

[1. Constitution]
An example of the configuration of the qualification allowance total calculation device 100 according to the present embodiment will be described with reference to FIG. FIG. 1 is a block diagram illustrating an example of the configuration of the qualification allowance total amount calculation device 100.

  The qualification allowance total calculation device 100 is a commercially available desktop personal computer. The total qualifying allowance calculation device 100 is not limited to a stationary information processing device such as a desktop personal computer, but is a commercially available notebook personal computer, PDA (Personal Digital Assistants), smartphone, tablet personal computer, or the like. It may be a portable information processing apparatus.

  The total qualifying allowance calculation device 100 includes a control unit 102, a communication interface unit 104, a storage unit 106, and an input / output interface unit 108. Each unit included in the qualification allowance total calculation device 100 is connected to be communicable via an arbitrary communication path.

  The communication interface unit 104 connects the qualification allowance total amount calculation device 100 to the network 300 through a communication device such as a router and a wired or wireless communication line such as a dedicated line so as to be communicable. The communication interface unit 104 has a function of communicating data with other devices via a communication line. Here, the network 300 has a function of connecting the qualifying allowance total calculation device 100 and the server 200 so that they can communicate with each other, and is, for example, the Internet or a LAN (Local Area Network). Note that data such as various masters described later may be stored in the server 200, for example.

  An input device 112 and an output device 114 are connected to the input / output interface unit 108. As the output device 114, a speaker (including a home television), a speaker, and a printer can be used. As the input device 112, in addition to a keyboard, a mouse, and a microphone, a monitor that realizes a pointing device function in cooperation with the mouse can be used. In the following description, the output device 114 may be described as the monitor 114, and the input device 112 may be described as the keyboard 112 or the mouse 112.

  The storage unit 106 stores various databases, tables, files, and the like. The storage unit 106 stores a computer program for giving various instructions to a CPU (Central Processing Unit) in cooperation with an OS (Operating System). As the storage unit 106, for example, a memory device such as a RAM (Random Access Memory) and a ROM (Read Only Memory), a fixed disk device such as a hard disk, a flexible disk, and an optical disk can be used.

  The storage unit 106 includes, for example, a qualification master 106a, an employee possession qualification registration master 106b (hereinafter simply referred to as “registration master 106b”), an employee master 106c, a control master 106d, and an employee supply table 106e. ing.

  The qualification master 106a is, for example, a master for managing a list of qualifications handled by a certain company and a qualification allowance for the qualifications. As shown in FIG. 2, the qualification master 106a includes, for example, qualification identification data (qualification CD and qualification name) for identifying the qualification, a company unit qualification allowance supply flag (supply FLG), and a qualification that is an allowance for the qualification. The amount of allowance (qualification allowance), the validity period of the qualification (effective date), the qualification classification (qualification classification) for identifying the classification to which the qualification belongs, and the provision of the qualification allowance for the qualification within the same qualification classification It includes a record having priority (higher No) and related business identification data (related business) for identifying a business related to the qualification. Note that the record refers to one horizontal line of information in the qualification master 106a.

  The company unit qualification allowance supply flag (payment FLG) means, for example, a flag ("Supply FLG: 1" in FIG. 2) that means that a certain qualification is eligible for the qualification allowance, and that it is not eligible for payment. One of the flags to be executed ("Supply FLG: 0" in FIG. 2) is set for each company. In other words, the company unit qualification allowance supply flag (supply FLG) is a flag for registering whether the qualification is a qualification allowance target. For example, the qualification of XX1 grade in Fig. 2 is that payment FLG is "0", so even if the employee owns XX1 grade, XX1 grade is not eligible for qualification allowance Don't be.

  The amount of qualification allowance is, for example, a monthly amount of allowance paid to an employee having a certain qualification.

  The validity period (valid date) represents, for example, how many years and months from the date of qualification acquisition that the qualification is valid.

  The qualification classification is, for example, the same CD when the qualification types are the same. Further, the upper number is a number assigned from the first in the order of the priority of payment of the qualification allowance in the qualifications with the same qualification classification (order of higher qualifications). For example, both XX1 class and XX2 class in FIG. 2 belong to the same qualification class because they have qualification class 1, but XX1 class has higher rank No1 and XX2 class has higher rank No2. Therefore, only XX grade 1 is eligible for the qualification allowance. In other words, XX class 1 and XX class 2 have the same classification qualification, but there is a distinction between upper and lower levels. On the other hand, for example, -1 grade and -2 grade in FIG. 2 both belong to the same qualification category because they have qualification category 1, and furthermore, since both have higher rank No. 1, -1 grade and- Both -2 grades are eligible for qualification allowance. In other words, the -1 class and the -2 class have the same classification qualification, and there is no distinction between upper and lower levels.

  The related business identification data (related business) can be set in the qualification master 106a by registering a business pattern in the related business master and selecting from the list.

  The registration master 106b is, for example, a master for managing a list of qualifications held by a certain employee. The registration master 106b in FIG. 3 shows a list of qualifications held by the employee of the employee CD “1000”. As shown in FIG. 3, the registration master 106b includes, for example, employee identification data (employee CD) for identifying an employee, qualification identification data (qualification CD and qualification name), employee unit qualification allowance supply flag (supply FLG), It includes records having the date of acquisition of qualification (acquisition date) and the expiration date (expiration date) of qualification. Note that the record refers to one horizontal line of information in the registration master 106b.

  Employee qualification allowance supply flag (payment FLG) For example, a flag ("Supply FLG: 1" in FIG. 3) that means that a certain qualification is eligible for the qualification allowance, and a flag that means not eligible for payment Any one of (Supply FLG: 0 in FIG. 3) is set for each employee. The employee unit qualification allowance payment flag is set as the initial value of the company unit qualification allowance payment flag of the qualification master 106a. However, if the qualification allowance amount is not paid against the setting of the qualification master 106a, the employee unit qualification allowance payment is provided. Set to change the flag to "0". For example, since the supply FLG “1” is set for the qualification ΔΔ in the qualification master 106a of FIG. 2, the supply FLG “1” is set as the initial value for the qualification ΔΔ in the registration master 106b. Since the setting has been changed by the operator, the supply FLG in the qualification ΔΔ is “0” in the registration master 106b of FIG.

  The expiration date can be calculated by acquiring the effective date from the qualification master 106a and adding the acquired effective date to the acquisition date included in the registration master 106b. For example, the qualification acquisition date for □□ 2 class in Fig. 3 is "2009/1/1", and the effective date of □□ 2 class in Fig. 2 is "9 (years)". Level 2 is valid for "9 years" from "2009/1/1", that is, the expiration date is "2017/12/31". For this reason, for example, assuming that the salary date is January, 2018, the date of □□ 2 class has already expired, so □□ 2 class is eligible for the qualification allowance. Must not.

  The employee master 106c is, for example, a master for managing work that a certain employee is engaged in. As shown in FIG. 7, the employee master 106c includes, for example, employee identification data (employee CD) and engagement work identification data (engagement work) for identifying the work that the employee is engaged in.

  For example, the control master 106d sets whether or not to determine whether the engagement business identification data included in the employee master 106c and the related business identification data included in the qualification master 106a match or do not match, using FLG (business match determination FLG). Master for. For example, when the business coincidence determination FLG is “0”, it is not determined whether the engaged business identification data and the related business identification data match, or when the business coincidence determination FLG is “1”. It can be set so as to determine whether or not the engagement job identification data and the related job identification data match.

  The employee supply table 106e is a table for managing the total amount of qualification allowance for a certain employee, for example. As shown in FIG. 8, the employee supply table 106e includes, for example, employee identification data (employee CD), a total amount of qualification allowance (qualification allowance amount), and the like.

  The control unit 102 is a CPU or the like that comprehensively controls the qualification allowance total amount calculation device 100. The control unit 102 has an internal memory for storing a control program such as an OS, a program that defines various processing procedures, and necessary data, and performs various information processing based on these stored programs. Execute.

  The control unit 102 is functionally conceptually, for example, (1) a qualification acquisition unit 102a as a qualification acquisition unit that acquires qualification identification data associated with specified employee identification data from the employee possession qualification registration master; 2) A supply target qualification acquisition unit 102a1 as a supply target qualification acquisition unit that acquires the specified employee identification data and the qualification identification data associated with the flag indicating that it is a supply target from the employee possession qualification registration master (3) Effective qualification as valid qualification acquisition means for acquiring from the employee possession qualification registration master the qualification identification data associated with the designated employee identification data and the expiration date after the salary payment date for the employee. Qualification identification data associated with the designated employee identification data from the acquisition unit 102a2 and (4) the employee possession qualification registration master Qualification classification etc. acquisition part 102a3 as qualification classification etc. acquisition means which acquires, and further acquires the qualification classification and priority in the qualification master linked with the acquired qualification identification data, and (5) from the qualification master, An upper qualification acquisition unit 102a4 as upper qualification acquisition means for acquiring qualification identification data associated with the highest priority among the same qualification classification acquired by the qualification classification acquisition means; and (6) the employee Related business acquisition means for acquiring qualification identification data associated with the designated employee identification data from the possession qualification registration master and further acquiring related business identification data in the qualification master associated with the acquired qualification identification data (7) From the employee master, acquire the job identification data associated with the designated employee identification data. (8) From the qualification master, the engaged work identification data acquired by the engaged work acquisition means out of the related work identification data acquired by the related work acquisition means. A business qualification acquisition unit 102a7 as a business qualification acquisition unit that acquires qualification identification data associated with the qualification identification data, and (9) a qualification allowance associated with the qualification identification data acquired by the qualification acquisition unit from the qualification master An allowance amount acquisition unit 102b as an allowance amount acquisition unit for acquiring an amount; and (10) a total amount calculation unit 102c as a total amount calculation unit that calculates the total amount of the qualified allowance amount acquired by the allowance amount acquisition unit; It is equipped with. The details of the processing executed by each unit are described in [2. Specific Example of Processing] will be described.

[2. Specific example of processing]
Hereinafter, specific examples of processing according to the present embodiment will be described in detail with reference to FIGS. The specific contents in the qualification master 106a and the registration master 106b are as shown in FIGS. 2 and 3, respectively.

[2-1. Qualification]
The qualification acquisition unit 102a acquires qualification identification data (qualification CD) associated with the designated employee identification data (employee CD) from the registration master 106b.

  Specifically, when “1000” is designated as the employee CD, the qualification acquisition unit 102a obtains from the registration master 106b of FIG. 3 qualification CDs 1111, 1112, 1121, which are associated with “1000” as the employee CD. 2112, 3111, 4111 and 4112 are obtained. The acquisition is a process of acquiring all the qualifications possessed by a certain employee. However, as described in the following (1) to (4), qualifications that satisfy a predetermined condition may be acquired.

(1) Acquisition of qualification considering supply flag In this item (1), acquisition of qualification considering the supply flag in the registration master 106b will be described.

  The supply target qualification obtaining unit 102a1 associates the designated employee identification data (employee CD) and a flag (supply flag “1”) indicating that the qualification allowance is provided from the registration master 106b. Acquire qualification identification data.

  Specifically, the supply target qualification acquisition unit 102a1 obtains the first record from the top as the record including the designated employee CD “1000” and the supply flag “1” from the registration master 106b of FIG. Five records of the first record, the fourth record, the sixth record, and the seventh record are acquired. Thereby, the supply target qualification acquisition unit 102a1 acquires 1111, 1112, 2112, 4111 and 4112 which are qualification CDs included in the five records. In other words, the supply target qualification acquisition unit 102a1 acquires the qualification CD included in the record by acquiring the record with the supply FLG “1” as a valid record from the registration master 106b of FIG.

  On the other hand, the two records of the third record and the fifth record from the top in the registration master 106b of FIG. 4 include the supply flag “0”, and therefore the acquisition target of the supply target qualification acquisition unit 102a1 Instead, the record becomes invalid as shown as “invalid” in FIG. FIG. 5 shows a diagram in which the two invalid records are deleted.

  As described above in this item (1), according to the qualification allowance total amount calculation device 100 according to the present embodiment, for example, the qualification allowance amount is or is not paid by detaching the payment FLG in the registration master 106b. Can be controlled.

(2) Acquisition of qualification considering the expiration date In this item (2), acquisition of the qualification considering the expiration date in the registration master 106b will be described.

  The valid qualification acquisition unit 102a2 acquires from the registration master 106b the qualification identification data (qualification CD) associated with the designated employee identification data (employee CD) and the expiration date after the salary payment date for the employee.

  Specifically, it is assumed that the salary payment date for the employee is “January 2018 XX Day”. In this case, the valid qualification acquisition unit 102a2 obtains the expiration date after the designated employee CD “1000” and “January 2018” from the five records shown in FIG. 5 acquired in (1). As the records to be included, four records are acquired: the first record, the second record, the fourth record, and the fifth record from the top. Thereby, the valid qualification acquisition unit 102a2 acquires 1111, 1112, 4111 and 4112 which are qualification CDs included in the four records. In other words, the valid qualification acquisition unit 102a2 acquires the qualification CD included in the record by acquiring the qualification within the expiration date as the valid record at the time of salary payment (in this example, at the time of the salary calculation in January 2018). get.

  On the other hand, among the five records shown in FIG. 5 acquired in (1), the third record from the top is the expiration date “2017/12 / 31 ”, it is not an acquisition target of the valid qualification acquisition unit 102a2, and becomes an invalid record as indicated by“ invalid ”in FIG. A diagram in which the invalid record is deleted is shown on the right side of FIG.

  As described above in this item (2), according to the qualification allowance total amount calculation device 100 according to this embodiment, for example, the expiration date has been exceeded by managing the expiration date of the qualification held by the employee. It is possible to control that qualification is not subject to qualification allowance.

(3) Acquisition of qualifications considering qualification classification and upper No. In this item (3), acquisition of qualifications considering qualification classification and upper No. will be described.

(3-1) Acquisition of qualification classification and higher rank No. Acquisition section 102a3 such as qualification classification acquires qualification identification data (qualification CD) associated with the designated employee identification data (employee CD) from registration master 106b. Further, the qualification classification and priority (higher rank No.) in the qualification master 106a associated with the acquired qualification identification data (qualification CD) are acquired.

  Specifically, the qualification classification acquisition unit 102a3 selects the first record from the top as a record including the designated employee CD “1000” from the four records shown in the right of FIG. 6 acquired in (2). 4 records of the fourth record are acquired, and further, the acquired record from the qualification master 106a in FIG. 6 (the master is a part of the qualification master 106a in FIG. 2). As the information associated with the qualification CDs 1111, 1112, 4111 and 4112 included in the qualification CD1111, “qualification classification 1 and upper No. 1” for the qualification CD 1111, “qualification classification 1 and upper No. 2” for the qualification CD 1112, and “ “Qualification classification 5 and upper No. 1” and “qualification classification 5 and upper No. 1” for the qualification CD 4112 are acquired.

(3-2) Acquisition of qualification Subsequently, the upper qualification acquisition unit 102a4 is associated with the highest priority (higher No.) in the same qualification classification acquired by the qualification classification acquisition unit 102a3 from the qualification master 106a. Acquire qualification identification data (qualification CD).

  Specifically, among the “qualification classification 1 and upper No. 1” for the qualification CD 1111 and “qualification classification 1 and upper No. 2” for the qualification CD 1112, the highest upper No. is “upper No. 1”. Therefore, the upper qualification acquisition unit 102a4 acquires the qualification CD1111 associated with “higher No1” as indicated by X in the qualification master 106a in FIG. 6 (that is, the qualification and qualification of the qualification CD1111 belonging to the same qualification classification). Among the CD1112 qualifications, only the higher qualification CD1111 qualification is valid). As a result, the upper qualification acquisition unit 102a4 acquires the first record having the qualification CD 1111 as a valid record from the four records shown in FIG. On the other hand, as indicated by X in the qualification master 106a of FIG. 6, the qualification CD associated with “higher No. 2” which is not the highest is 1112. Therefore, the second record from the top shown in FIG. 6 having the qualification CD 1112 is not an acquisition target of the upper qualification acquisition unit 102a4, and becomes an invalid record as shown in FIG. 6 as “invalid”. A diagram in which the invalid record is deleted is shown on the right side of FIG.

  On the other hand, among the “qualification classification 5 and upper No. 1” for the qualification CD 4111 and “qualification classification 5 and upper No. 1” for the qualification CD 4112, the highest upper No. is “upper No. 1”. Therefore, the upper qualification acquisition unit 102a4 acquires the qualification CD4111 and the qualification CD4112 associated with “higher No1” as indicated by Y in the qualification master 106a in FIG. 6 (that is, the qualification CD4111 belonging to the same qualification classification). Qualification and qualification Both qualifications are valid because the upper rank is the same among the qualifications of CD4112). Thereby, the upper qualification acquisition unit 102a4 acquires the third record from the top having the qualification CD4111 and the fourth record from the top having the qualification CD4112 from the four records shown in FIG.

  As described above in this item (3), according to the qualification allowance total amount calculation device 100 according to the present embodiment, for example, even when a payment FLG is attached, Only the qualification with the lowest value of No can be acquired. Thereby, for example, only the upper level qualification can be targeted for the qualification allowance.

  In addition, as described in this item (3), according to the qualification allowance total amount calculation device 100 according to the present embodiment, for example, when there are a plurality of qualifications having the lowest top No in the qualification classification, All multiple qualifications can be obtained. Thereby, for example, a qualification allowance can be provided in addition to a higher level qualification.

(4) Acquiring qualifications taking into account the employee's work In this item (4), the acquisition of qualifications taking into account the employee's work is explained.

(4-1) Acquisition of related work The related work acquisition unit 102a5 acquires the qualification identification data (qualification CD) associated with the designated employee identification data (employee CD) from the registration master 106b, and further acquires the acquisition The related work identification data (related work) in the qualification master 106a associated with the obtained qualification identification data (qualification CD) is acquired.

  Specifically, the related task acquisition unit 102a5 selects the first record from the top as the record including the designated employee CD “1000” from the three records shown in the right of FIG. Three records of the third record are acquired, and further, from the qualification master 106a in FIG. 7 (the master is a part of the qualification master 106a in FIG. 2), As the information associated with the included qualification CDs 1111, 4111 and 4112, the related work 100 for the qualification CD1111, the related work 450 for the qualification CD4111, and the related work 450 for the qualification CD4112 are acquired.

(4-2) Acquisition of Employee's Engaged Work The engaged work acquisition unit 102a6 acquires the engaged work identification data (engaged work) associated with the designated employee identification data (employee CD) from the employee master 106c.

  Specifically, the engaged work acquisition unit 102a6 acquires the engaged work 450 as information associated with the designated employee CD “1000” from the employee master 106c of FIG.

(4-3) Acquisition of Qualification The business qualification acquisition unit 102a7 acquires from the qualification master 106a the engagement business identification data acquired by the engagement business acquisition unit 102a6 among the related business identification data (related business) acquired by the related business acquisition unit 102a5. Acquire qualification identification data (qualification CD) associated with the one that matches (engaged work).

  Specifically, among the related work 100 and the related work 450 acquired in (4-1), the related work 450 is the same as the engaged work 450 acquired in (4-2). In this case, the business qualification acquisition unit 102a7 acquires the qualification CDs 4111 and 4112 associated with the related business 450 from the qualification master 106a of FIG. As a result, the business qualification acquisition unit 102a7 acquires the second record from the top having the qualification CD4111 and the third record from the top having the qualification CD4112 as valid records from the three records shown on the right in FIG. To do. In other words, the business qualification acquisition unit 102a7 has a function of determining whether or not a qualification allowance is to be paid by looking at a match with the employee's business. In addition, in order to control the validity or invalidity of the function, a task matching determination FLG is separately provided in the control master 106d.

  On the other hand, among the three records shown on the right in FIG. 7, the first record from the top does not match the engaged work and the related work, and thus is not the acquisition target of the work qualification acquisition unit 102a7. As shown in FIG. 7, “invalid” is an invalid record.

  As described above in this item (4), according to the qualification allowance total amount calculation apparatus 100 according to the present embodiment, for example, the qualification allowance is obtained by checking the agreement between the employee's engagement work and the qualification related work. It is possible to automatically determine whether or not to pay.

(5) Summary As described above in (1) to (4), the qualification acquisition unit 102a acquires the qualification of the qualification CD4111 and the qualification of the qualification CD4112 as the qualification that satisfies a predetermined condition.

[2-2. Acquisition of qualification allowance]
The allowance amount acquisition unit 102b acquires a qualification allowance amount associated with the qualification identification data (qualification CD) acquired by the qualification acquisition unit 102a from the qualification master 106a.

  Specifically, the allowance acquisition unit 102b obtains the qualification acquired in [2-1] from the qualification master 106a in FIG. 8 (the master is a part of the qualification master 106a in FIG. 2). Acquire 15,000 yen and 6000 yen as qualification allowances associated with CD4111 and qualification CD4112, respectively.

[2-3. Calculation of total amount]
The total amount calculation unit 102c calculates the total amount of the qualified allowance amount acquired by the allowance amount acquisition unit 102b.

  Specifically, the total amount calculation unit 102c totals the qualification allowance amounts of 15,000 yen and 6000 yen acquired in [2-2], and the total qualification allowance for the employee of the employee CD “1000” is 21000 yen. calculate. The total amount of 21,000 yen is set in the employee supply table 106e as shown in FIG.

[2-4. Summary]
As described above in [2-1] to [2-3], according to the qualification allowance total calculation device 100 according to the present embodiment, the total qualification allowance for the qualifications held by the employee is calculated. it can.

  Also, in the past, management of qualifications and management of qualification allowances are separate, so management is complicated, and even when qualifications and qualification allowances can be linked, the relationship between the upper level qualifications, qualification expiration dates and qualifications There was a problem that the person in charge had to manually determine the payment in consideration of the work. Therefore, in the present embodiment, for example, the following functions 1 to 5 can be implemented to solve the problem.

  First, the registration master 106b registers the holding qualification for each employee so that the necessary amount of information can be acquired from the qualification master 106a (that is, the management of the employee holding qualification and the automatic processing of the allowance payment associated therewith). ).

  Second, even if the qualification is eligible for qualification allowance, the qualification master 106a automatically determines the upper qualification within a plurality of qualifications belonging to the same qualification classification, and the lower qualification is not eligible for qualification allowance. And made it possible.

  Thirdly, when it is not necessary to discriminate between the upper qualification and the lower qualification among a plurality of qualifications belonging to the same qualification classification, the plurality of the plurality of qualifications can be determined by setting the qualification master 106a without distinguishing the upper qualification and the lower qualification All qualifications can now be eligible for qualification allowances.

  Fourth, by managing the expiration date of employee qualifications, qualifications exceeding the expiration date can be excluded from the qualification allowance.

  Fifthly, if the employee's work does not match the business use of the qualification, the qualification can be excluded from the qualification allowance (ie, the employee is usually eligible for the qualification allowance) Even if you have a qualification, if you do not have a relationship between the qualification and the work that the employee is engaged in, you can respond to the election of not paying the qualification allowance).

[3. Other Embodiments]
In addition to the above-described embodiments, the present invention may be implemented in various different embodiments within the scope of the technical idea described in the claims.

  For example, among the processes described in the embodiments, all or part of the processes described as being automatically performed can be performed manually, or all of the processes described as being performed manually are all performed. Alternatively, a part can be automatically performed by a known method.

  In addition, the processing procedures, control procedures, specific names, information including parameters such as registration data and search conditions for each processing, screen examples, and database configurations shown in the present specification and drawings, unless otherwise specified. Can be changed arbitrarily.

  In addition, regarding the qualifying allowance total amount calculation device 100, each illustrated component is functionally conceptual and does not necessarily need to be physically configured as illustrated.

  For example, all or some of the processing functions provided in the qualifying allowance total calculation device 100, particularly the processing functions performed by the control unit, are realized by the CPU and a program interpreted and executed by the CPU. Alternatively, it may be realized as hardware by wired logic. Note that the program is recorded on a non-transitory computer-readable recording medium including programmed instructions for causing the information processing apparatus to execute the processing described in the present embodiment. It is mechanically read by the forehead calculation device 100. In other words, in a storage unit such as a ROM or a HDD (Hard Disk Drive), a computer program for giving instructions to the CPU in cooperation with the OS and performing various processes is recorded. This computer program is executed by being loaded into the RAM, and constitutes a control unit in cooperation with the CPU.

  The computer program may be stored in an application program server connected to the qualifying allowance total calculation device 100 via an arbitrary network, and may be downloaded in whole or in part as necessary. Is also possible.

  In addition, a program for executing the processing described in this embodiment may be stored in a non-temporary computer-readable recording medium, or may be configured as a program product. Here, the “recording medium” refers to a memory card, USB (Universal Serial Bus) memory, SD (Secure Digital) card, flexible disk, magneto-optical disk, ROM, EPROM (Erasable Programmable Read Only Memory), EEPROM (registration). Trademark) (Electrically Erasable and Programmable Read Only Memory), CD-ROM (Compact Disk Read Only Memory), MO (Magneto-Optical disk), DVD (Digital Digital, Trademark) Any “portable physical media It is intended to include.

  The “program” is a data processing method described in an arbitrary language or description method, and may be in any form such as source code or binary code. Note that the “program” is not necessarily limited to a single configuration, and functions are achieved in cooperation with a separate configuration such as a plurality of modules and libraries or a separate program represented by the OS. Including things. In addition, a well-known structure and procedure can be used about the specific structure and reading procedure for reading a recording medium in each apparatus shown to embodiment, the installation procedure after reading, etc.

  Various databases and the like stored in the storage unit are storage means such as a memory device such as RAM and ROM, a fixed disk device such as a hard disk, a flexible disk, and an optical disk. Stores programs, tables, databases, web page files, etc.

  Further, the total qualifying allowance calculation device 100 may be configured as an information processing device such as a known personal computer or workstation, or may be configured as the information processing device to which an arbitrary peripheral device is connected. . Further, the qualifying allowance total amount calculation device 100 may be realized by installing software (including a program or data) that realizes the processing described in the present embodiment in the device.

  Furthermore, the specific form of distribution / integration of the devices is not limited to that shown in the figure, and all or a part of them may be functionally or physically in arbitrary units according to various additions or according to functional loads. It can be configured to be distributed and integrated. That is, the above-described embodiments may be arbitrarily combined and may be selectively implemented.

  The present invention is useful, for example, in an industry where management of holding qualifications is important and the allowance for holding qualifications is specified as wages, specifically, building maintenance industry, IT industry, financial industry, real estate industry and construction It is extremely useful in the industry.

100 Total qualification allowance calculation device 102 Control unit
102a Qualification Department
102a1 Qualification Acquisition Department
102a2 Effective qualification acquisition department
102a3 Qualification Classification etc. Acquisition Department
102a4 Senior Qualification Department
102a5 Related Business Acquisition Department
102a6 Engaged work acquisition department
102a7 Business qualification acquisition department
102b Allowance amount acquisition part
102c Total amount calculation unit 104 Communication interface unit 106 Storage unit
106a Qualification Master
106b Employee qualification registration master
106c Employee Master
106d Control master
106e Employee supply table 108 Input / output interface unit 112 Input device 114 Output device 200 Server 300 Network

Claims (7)

A qualification allowance total calculation device comprising a control unit and a storage unit,
In the storage unit,
A qualification master including qualification identification data for identifying the qualification and a qualification allowance that is an allowance for the qualification;
Employee qualification registration master including employee identification data and qualification identification data for identifying employees,
Is stored,
The controller is
Qualification acquisition means for acquiring qualification identification data associated with designated employee identification data from the employee possession qualification registration master;
From the qualification master, an allowance amount acquisition means for acquiring a qualification allowance amount associated with the qualification identification data acquired by the qualification acquisition means;
A total amount calculating means for calculating a total amount of the qualifying allowance acquired by the allowance amount acquiring means;
Providing
Qualification allowance total amount calculation device characterized by. The employee possession qualification registration master further includes an employee unit qualification allowance payment flag, and the employee unit qualification allowance payment flag is not a flag indicating that a certain qualification is to be paid for the qualification allowance amount and is not eligible for payment. One of the flags that means is set on a per employee basis,
The qualification acquisition means is
Further comprising a supply target qualification acquiring means for acquiring from the employee possession qualification registration master, qualification identification data associated with the designated employee identification data and a flag meaning to be the supply target;
The qualification allowance total amount calculation device according to claim 1, wherein: The employee possession qualification registration master further includes an expiration date of the qualification,
The qualification acquisition means is
Valid qualification acquisition means for acquiring, from the employee possession qualification registration master, qualification identification data associated with the designated employee identification data and the expiration date after the salary payment date for the employee;
The qualifying allowance total amount calculating device according to claim 1 or 2, characterized in that: The qualification master further includes a qualification classification for identifying a classification to which the qualification belongs and a priority order of payment of the qualification allowance for the qualification in the same qualification classification,
The qualification acquisition means is
Qualification for acquiring qualification identification data associated with the designated employee identification data from the employee possession qualification registration master, and further obtaining a qualification classification and priority in the qualification master associated with the acquired qualification identification data Classification acquisition means,
From the qualification master, upper qualification acquisition means for acquiring qualification identification data associated with the highest priority among the same qualification classification acquired by the qualification classification etc. acquisition means;
Further comprising,
The qualification allowance total amount calculation device according to any one of claims 1 to 3. The qualification master further includes related business identification data for identifying a business related to the qualification,
In the storage unit,
An employee master including employee identification data and engagement work identification data for identifying the work the employee is engaged in is further stored.
The qualification acquisition means is
Related work for obtaining qualification identification data associated with the designated employee identification data from the employee possession qualification registration master, and further obtaining related work identification data in the qualification master associated with the obtained qualification identification data Acquisition means;
From the employee master, engagement work acquisition means for acquiring engagement work identification data associated with the designated employee identification data;
Business qualification acquisition means for acquiring, from the qualification master, qualification identification data associated with the related business identification data acquired by the related business acquisition means among the related business identification data acquired by the engagement business acquisition means. When,
Further comprising,
The qualification allowance total amount calculation device according to any one of claims 1 to 4. A qualifying allowance total amount calculation method executed by an information processing apparatus including a control unit and a storage unit,
In the storage unit,
A qualification master including qualification identification data for identifying the qualification and a qualification allowance that is an allowance for the qualification;
Employee qualification registration master including employee identification data and qualification identification data for identifying employees,
Is stored,
Executed by the control unit,
From the employee possession qualification registration master, a qualification obtaining step for obtaining qualification identification data associated with the designated employee identification data;
From the qualification master, an allowance amount acquisition step of acquiring a qualification allowance amount associated with the qualification identification data acquired in the qualification acquisition step;
A total amount calculating step for calculating a total amount of the qualified allowance amount acquired in the allowance amount acquiring step;
Including,
A method for calculating the total amount of qualification allowance. A qualification allowance total amount calculation program for causing an information processing device including a control unit and a storage unit to execute,
In the storage unit,
A qualification master including qualification identification data for identifying the qualification and a qualification allowance that is an allowance for the qualification;
Employee qualification registration master including employee identification data and qualification identification data for identifying employees,
Is stored,
For causing the control unit to execute,
From the employee possession qualification registration master, a qualification obtaining step for obtaining qualification identification data associated with the designated employee identification data;
From the qualification master, an allowance amount acquisition step of acquiring a qualification allowance amount associated with the qualification identification data acquired in the qualification acquisition step;
A total amount calculating step for calculating a total amount of the qualified allowance amount acquired in the allowance amount acquiring step;
Including,
Qualification allowance total amount calculation program characterized by

Images