Information processing system, information processing method, and program

Abstract

To enable seamless aggregation and sharing of data between management units even when different systems and application software are used for each management unit that manages data consisting of a plurality of items.SOLUTION: In a CPU 11 of a management server 1, a data acquisition unit 32 acquires correspondence relationship data indicating a correspondence relationship between a plurality of items configuring first data and a plurality of items configuring second data; a template generation unit 33 generates a template that allows input of data for each item configuring the first data based on the correspondence relationship identified from the correspondence relationship data; and a transmission control unit 36 transmits the template to a person in charge terminal 2. Then, an import unit 34 imports the data for each item configuring the first data, which has been input into the template via the person in charge terminal 2, into the second data based on the correspondence relationship identified from the correspondence relationship data.SELECTED DRAWING: Figure 3

Description

[Technical Field]

[0001] The present invention relates to an information processing system, an information processing method, and a program. [Background technology]

[0002] There is known a technology for supporting the payment of wages to foreign workers residing in Japan (for example, Patent Document 1). [Prior art documents] [Patent documents]

[0003] [Patent Document 1] Patent Publication No. 2021-140586 Summary of the Invention [Problem to be solved by the invention]

[0004] For example, in a multinational corporation, where employees are located in multiple countries or regions and therefore there are multiple management units for managing employees, different systems and application software may be used for each management unit. In such cases, it can be difficult to seamlessly aggregate and share data consisting of multiple items, such as employee payroll information, between management units.

[0005] The present invention has been made in consideration of this situation, and aims to enable seamless aggregation and sharing of data between management units, even if different systems and application software are used for each management unit that manages data consisting of multiple items. [Means for solving the problem]

[0006] In order to achieve the above object, one aspect of the present invention is to a storage control means for executing control to store the first data; a first correspondence data acquisition means for acquiring first correspondence data indicating a first correspondence between a plurality of items constituting the first data and a plurality of items constituting the second data managed in another information processing system; a generation and output means for generating and outputting a template that allows input of data for each item constituting the second data based on the first correspondence data; an import means for importing data for each item constituting the target second data input into the template by a user of the other information processing system into the first data based on the first correspondence relationship; The information processing system includes:

[0007] An information processing device, an information processing method, and a program corresponding to the information processing system according to one aspect of the present invention are also provided as an information processing device, an information processing method, and a program corresponding to the information processing system according to one aspect of the present invention. [Effects of the Invention]

[0008] According to the present invention, even if different systems or application software are used for each management unit that manages data consisting of multiple items, data can be seamlessly aggregated and shared between management units. [Brief explanation of the drawings]

[0009] [Figure 1] 1 is a diagram illustrating an example of the overall configuration of an information processing system according to an embodiment of the present invention. [Figure 2] FIG. 2 is a block diagram illustrating an example of a hardware configuration of a management server according to the present embodiment. [Figure 3] FIG. 2 is a functional block diagram showing an example of a functional configuration of a management server and a staff member terminal. [Figure 4] 10 is a flowchart showing an example of the flow of an import process among the processes in a control unit of the management server. [Figure 5]10 is a flowchart showing an example of the flow of an export process among the processes in a control unit of the management server. [Figure 6] (A) is a diagram showing a specific example of an item of first data, (B) is a diagram showing a specific example of an item of second data, (C) is a diagram showing a specific example of correspondence data, and (D) is a diagram showing a specific example of a UL template. [Figure 7] 10A is a diagram showing a specific example of correspondence data, and FIG. 10B is a diagram showing a specific example of export data output based on a DL template. DETAILED DESCRIPTION OF THE INVENTION

[0010] Hereinafter, this embodiment will be described with reference to the drawings. <Information Processing System> FIG. 1 is a diagram showing an example of the overall configuration of an information processing system S according to this embodiment. The information processing system S is an information processing system that supports seamless management of employee information (hereinafter referred to as "employee information") in organizations such as companies that have multiple units (hereinafter referred to as "management units") for managing information about employees. Examples of "management units" include countries, regions consisting of multiple countries, and the entire world consisting of multiple regions. Examples of companies that have multiple management units include companies known as multinational companies or global companies.

[0011] The information processing system S allows seamless aggregation and sharing of data between management units, even when different systems and application software are used for each management unit. Specifically, for example, assume that the management units of a certain multinational corporation are divided into national units such as Japan, China, and the United States, and a global unit regardless of country or region. In this case, although the systems and application software may differ for each country, which is a management unit, the information processing system S allows seamless aggregation and sharing of data between management units. Specific examples of aggregation and sharing of data between management units will be described later with reference to FIGS. 6 and 7.

[0012] The information processing system S includes a global information processing system SG and local information processing systems SL-1 to SL-n (n is an integer value of 1 or more). The global information processing system SG is an information processing system used to manage various types of information on a global basis, regardless of country or region. Each of the local information processing systems SL-1 to SL-n is an information processing system used to manage various types of information on a country basis.

[0013] More specifically, the information processing system S is configured by connecting a management server 1 included in the global information processing system SG and staff terminals 2-1 to 2-n included in each of the local information processing systems SL-1 to SL-n via a network N. The network N is, for example, the Internet, a LAN (Local Area Network), or a VPN (Virtual Private Network). When there is no need to explain each of the staff terminals 2-1 to 2-n individually, they will be collectively referred to as the "staff terminal 2," and the local information processing systems SL-1 to SL-n will be collectively referred to as the "local information processing system SL."

[0014] (Management Server) The management server 1 is an information processing device that functions as a server that manages the global information processing system SG and the local management system SL so that they work together to function as the information processing system S. The management server 1 acquires various information transmitted from the person in charge terminal 2 and from the outside, and performs various processes. The management server 1 also transmits various information to the person in charge terminal 2 and to the outside.

[0015] For example, the management server 1 acquires information (hereinafter referred to as "correspondence data") indicating the correspondence between multiple items constituting employee information managed on a country-by-country basis and multiple items constituting employee information managed on a global basis. Cross-sectional employee information managed on a global basis is an example of information (hereinafter referred to as "global data") managed on a global information processing system SG (e.g., the management server 1). Employee information managed on a country-by-country basis is an example of information (hereinafter referred to as "local data") managed on a local management system SL (e.g., the staff terminal 2 operated by a local administrator) managed on a country-by-country basis. The correspondence data is information created on the staff terminal 2 based on the operation of the local administrator and transmitted from the staff terminal 2 to the management server 1. Specific examples of local data, global data, and correspondence data will be described later.

[0016] The management server 1 acquires the correspondence data sent from the person in charge terminal 2 and generates a template (hereinafter referred to as a "UL template") to be used for uploading local data from the person in charge terminal 2 to the management server 1 based on the correspondence identified from the correspondence data. The UL template is a template that allows data for each item that makes up the local data to be entered into the person in charge terminal 2. The management server 1 sends the generated UL template to the person in charge terminal 2. As will be described in more detail later, the UL template may include in advance a calculation formula based on the items that make up the local data.

[0017] When upload data is sent from the person in charge terminal 2, the management server 1 acquires the upload data. "Upload data" is data entered into a UL template for each item that makes up local data. The operation of entering data for each item into a UL template and the operation of uploading the upload data are both performed by the local administrator.

[0018] The local management system SL uses application software for managing local data (hereinafter referred to as a "local data management application"). For example, a local administrator creates upload data by using a local data management app to copy (for example, by copying on the local data management app or by copying part or all of a file output by the export function) and pasting it into a UL template.

[0019] The management server 1 imports the data for each item constituting the local data entered in the acquired upload data into the global data based on the correspondence relationship identified from the correspondence data. As a result, the local data managed by the person in charge terminals 2 in the multiple local information processing systems SL are aggregated as global data managed by the management server 1.

[0020] For example, suppose that the local information processing system SL-1 is an information processing system used by a Japanese business operator and installed in Japan. In this case, application software that manages employee working hours and other information in accordance with the Labor Standards Act of Japan is used as the local data management application.

[0021] For example, local information processing system SL-2 is an information processing system used by a US business and installed in the US. In this case, application software that manages employee working hours and other information in compliance with US labor standards laws and regulations is used as the local data management application.

[0022] In this way, the local data managed by the person in charge terminals 2 in the plurality of local information processing systems SL are aggregated as global data managed by the management server 1.

[0023] This allows the global administrator to manage global data using an information processing terminal for the global administrator (not shown) provided in the management server 1 or the global management system SG. For example, the global administrator can compare, check, and process the local data of multiple local information processing systems SL in a consolidated state.

[0024] A local administrator can use any local data management application in his / her local information processing system SL. For example, suppose the local data management application is replaced with a different one. As a result, the format (item names, order, etc.) of the data output using the export function of the local data management application changes. In this case, the local administrator can easily continue to aggregate the local data into global data by resetting the above-mentioned correspondence data.

[0025] Furthermore, the global administrator does not need to develop applications that meet the needs of multiple local information processing systems SL. For example, the global administrator does not need to provide a local data management application that complies with the Labor Standards Act of each country, but can instead have the local administrators install applications provided by third parties. This means that the global administrator can simply have the local administrators install any local data management application they like.

[0026] The management server 1 also acquires correspondence data created to register a template (hereinafter referred to as a "DL template") for downloading global data to the person in charge terminal 2 and importing it as local data. The management server 1 registers the DL template based on the correspondence identified from the acquired correspondence data. The registered DL template is a template corresponding to a local data management application that manages local data using the person in charge terminal 2.

[0027] That is, the local management system SL uses a local data management application, such as application software that manages employee income and associated taxes in accordance with the tax laws of the country.

[0028] The local data management application that complies with the labor standards laws, etc. of each country mentioned above and the local data management application that manages employee income and associated taxes, etc., that complies with the tax laws, etc. of that country, may be one application software, or may be two or more application software. For ease of explanation, the following description will be given assuming that the first local data management application and the second local data management application are one piece of application software.

[0029] When one DL template is selected from one or more registered DL templates, the management server 1 generates and outputs export data in which global data is associated with each local data item based on the correspondence relationship identified from the selected DL template. The export data can be imported into local data managed by a local data management app on the staff terminal 2. The items constituting the DL template and the global data corresponding to the items may include calculation formulas. The specific configuration and processing of the management server 1 will be described in detail later.

[0030] (Personnel terminal) The person in charge terminal 2 is an information processing device operated by a local administrator, and is configured, for example, as a personal computer, a tablet terminal, a smartphone, etc. The person in charge terminal 2 is assumed to have dedicated application software installed that enables the information processing system S to be used.

[0031] The person in charge terminal 2 starts dedicated application software based on the operation of the local administrator, and performs various processes based on various information transmitted from the management server 1 and external sources, information input by the operation of the local administrator, etc. The person in charge terminal 2 also transmits various information to the management server 1 and external sources.

[0032] For example, the person in charge terminal 2 accepts an operation to input local data and manages the input information in a local data management application. The person in charge terminal 2 also accepts an input operation to create correspondence data and transmits the input information to the management server 1.

[0033] Also, for example, the person in charge terminal 2 acquires the UL template transmitted from the management server 1. The person in charge terminal 2 accepts an operation to input data for each item constituting the local data as an input operation for the UL template by the local administrator. Also, for example, the person in charge terminal 2 acquires the export data transmitted from the management server 1 and imports it into the local data of the second local data management application. As a result, the global data managed by the management server 1 is seamlessly imported into the local data managed by the second local data management application of the person in charge terminal 2. The specific configuration and processing details of the person in charge terminal 2 will be described later.

[0034] The above-described processes performed by the management server 1 and the person in charge terminal 2 that constitute the information processing system S are merely examples, and it is sufficient that the information processing system S as a whole has the functions to realize the above-described processes. Therefore, some or all of the functions to realize the above-described processes may be shared or cooperated within the information processing system S.

[0035] For example, some or all of the functions of the management server 1 may be functions of other information processing devices, etc. in the information processing system S, and some or all of the functions of other information processing devices, etc. in the information processing system S may be functions of the management server 1. Furthermore, some or all of the functions of the management server 1 may be transferred to other servers, etc. (not shown). This promotes processing in the information processing system S as a whole and also makes it possible for processes to complement each other.

[0036] <Hardware configuration> (Management server hardware configuration) FIG. 2 is a block diagram showing an example of the hardware configuration of the management server 1 according to this embodiment. The management server 1 includes a CPU (Central Processing Unit) 11, a ROM (Read Only Memory) 12, a RAM (Random Access Memory) 13, a bus 14, an input / output interface 15, an output unit 16, an input unit 17, a memory unit 18, a communication unit 19, and a drive 20.

[0037] The CPU 11 executes various processes in accordance with programs recorded in the ROM 12 or programs loaded from the storage unit 18 into the RAM 13. The RAM 13 also stores data and the like required for the CPU 11 to execute various processes. The CPU 11, the ROM 12, and the RAM 13 are interconnected via a bus 14. An input / output interface 15 is also connected to this bus 14.

[0038] The input / output interface 15 is connected to an output unit 16, an input unit 17, a memory unit 18, a communication unit 19, and a drive 20. The output unit 16 is composed of a display, a speaker, etc., and outputs various types of information as images and sounds. The input unit 17 is composed of a keyboard, a mouse, a touch panel, etc., and accepts input of various types of information. The memory unit 18 is composed of a hard disk, a DRAM (Dynamic Random Access Memory), etc., and stores various types of data. The communication unit 19 communicates with other devices via a network N including the Internet.

[0039] Removable media 21, such as a magnetic disk, optical disk, magneto-optical disk, or semiconductor memory, is appropriately attached to the drive 20. Programs read from the removable media 21 by the drive 20 are installed in the storage unit 18 as needed. The removable media 21 can also store various data stored in the storage unit 18 in the same way as the storage unit 18.

[0040] (Hardware configuration of the staff terminal) Although not shown, the person in charge terminal 2 has the hardware configuration shown in Fig. 2. That is, the person in charge terminal 2 has a CPU, ROM, RAM, bus, input / output interface, output unit, input unit, memory unit, communication unit, drive, and removable media that correspond to the CPU 11, ROM 12, RAM 13, bus 14, input / output interface 15, output unit 16, input unit 17, memory unit 18, communication unit 19, drive 20, and removable media 21 of the management server 1 in Fig. 2, respectively.

[0041] <Functional configuration> (Functional configuration of management server and staff terminal) 3 and 4 are functional block diagrams showing an example of the functional configuration of the management server 1 and the person in charge terminal 2. As shown in FIG. During operation, CPU 11 of management server 1 functions as a data management unit 31, a data acquisition unit 32, a template generation unit 33, an import unit 34, an export unit 35, and a transmission control unit 36. Storage unit 18 of management server 1 is also provided with a global DB 41 in which global data is stored, a correspondence DB 42 in which correspondence data is stored, a template DB 43 in which registered UL templates and DL templates are stored, and the like.

[0042] The data management unit 31 manages various types of data. For example, the data management unit 31 stores and manages global data in a global DB 41. The data management unit 31 also stores and manages acquired correspondence data in a correspondence DB 42. The data management unit 31 also stores and manages registered UL templates and DL templates in a template DB 43.

[0043] The data acquisition unit 32 acquires various types of information. For example, the data acquisition unit 32 acquires correspondence relationship data transmitted from the person in charge terminal 2. Specifically, for example, the data acquisition unit 32 acquires correspondence data for uploading (for example, information corresponding to table-format data shown in FIG. 6(C) described later) that indicates the correspondence between item names managed by the local information processing system SL and item names managed by the global information processing system SG. The correspondence data for uploading is created by the person in charge on the person in charge terminal 2 of the local information processing system SL.

[0044] Furthermore, for example, the data acquisition unit 32 acquires upload data transmitted from the person in charge terminal 2. Specifically, for example, the data acquisition unit 32 acquires correspondence data for download indicating a second correspondence between item names in the data after it has been imported again as local data in the local information processing system SL and a plurality of items constituting the global data. The correspondence data for download is created by the person in charge on the person in charge terminal 2 of the local information processing system SL.

[0045] The template generation unit 33 generates a UL template. Specifically, the template generation unit 33 generates a UL template based on the correspondence relationship identified from the correspondence relationship data acquired by the data acquisition unit 32. That is, the template generation unit 33 generates and outputs a UL template (for example, a tabular template shown in FIG. 6(D) described later) that allows input of data for each item that makes up the local data, based on the correspondence relationship data. Furthermore, the template generation unit 33 generates a DL template. Specifically, the template generation unit 33 generates a DL template based on the correspondence relationship identified from the correspondence relationship data acquired by the data acquisition unit 32. The DL template generated by the template generation unit 33 is registered and becomes available for selection by the local administrator.

[0046] The import unit 34 imports data for each item constituting the local data input into the upload data into the global data. Specifically, the import unit 34 imports data for each item constituting the first data input into the upload data acquired by the data acquisition unit 32 into the global data based on the correspondence relationship identified from the correspondence relationship data.

[0047] The export unit 35 generates export data to be output to the person in charge terminal 2. Specifically, the export unit 35 generates export data into which corresponding global data is input for each item of the first data, based on a DL template selected by the local administrator from one or more registered DL templates. The export data is data in a format that can be downloaded to the person in charge terminal 2 and imported into local data in the local data management app.

[0048] The transmission control unit 36 ​​controls the transmission of various information to the person in charge terminal 2 and to the outside via the communication unit 19. For example, the transmission control unit 36 ​​controls the transmission of a UL template to the person in charge terminal 2. Also, for example, the transmission control unit 36 ​​controls the transmission of export data to the person in charge terminal 2.

[0049] Furthermore, in the CPU of the person in charge terminal 2, an acquisition unit 51, a display control unit 52, and a transmission control unit 53 function during operation. Furthermore, the storage unit of the person in charge terminal 2 is provided with a local DB 61 in which local data is stored.

[0050] The acquisition unit 51 acquires various types of information. For example, the acquisition unit 51 acquires input information accepted by the input unit. For example, the acquisition unit 51 acquires information input to create correspondence data. The acquisition unit 51 also acquires various types of information transmitted from the management server 1 and from the outside. Specifically, for example, the acquisition unit 51 acquires a UL template transmitted from the management server 1. For example, the acquisition unit 51 also acquires export data transmitted from the management server 1.

[0051] The display control unit 52 controls the display of various types of information on the display of the output unit, etc. For example, the display control unit 52 controls the display of information for creating correspondence data on the display of the output unit, etc. For example, when a local administrator creates correspondence data using spreadsheet application software, the application software becomes the "information for creating correspondence data."

[0052] The transmission control unit 53 controls the transmission of various information to the management server 1 and to the outside via the communication unit. For example, the transmission control unit 53 controls the transmission of correspondence data to the management server 1. The transmission control unit 53 also controls the transmission of upload data to the management server 1.

[0053] <Processing flow> (Management Server Processing Flow) FIG. 4 is a flowchart showing an example of the flow of the import process among the processes executed by the CPU 11 of the management server 1. In the import process in the CPU 11 of the management server 1, the data management unit 31 of the CPU 11 manages global data (step S1). The management of global data by the data management unit 31 includes management of a plurality of items that make up the global data.

[0054] Thereafter, when correspondence data is transmitted from the person in charge terminal 2 (YES in step S2), the data acquisition unit 32 of the CPU 11 acquires the transmitted correspondence data (step S3). Then, the data management unit 31 stores and manages the correspondence data acquired by the data acquisition unit 32 in a database (the correspondence DB 42 in FIG. 3) (step S4). On the other hand, if the correspondence data has not been transmitted (NO in step S2), the data acquisition unit 32 repeats the determination process of step S2 until the correspondence data is transmitted.

[0055] Thereafter, template generation unit 33 of CPU 11 generates and registers a UL template based on the correspondence relationship identified from the correspondence relationship data acquired in step S3 (step S5). Specifically, the generated UL template is stored and managed in a database (template DB 43 in FIG. 3). Then, transmission control unit 36 ​​of CPU 11 controls transmission of the UL template to person in charge terminal 2 (step S6).

[0056] Thereafter, when upload data is transmitted from the person in charge terminal 2 in response to an upload operation by the local administrator (YES in step S7), the data acquisition unit 32 acquires the transmitted upload data (step S8). Then, the import unit 34 of the CPU 11 imports the data for each item of the local data entered in the upload data into the global data based on the correspondence relationship identified from the correspondence data (step S9). This completes the import process in the CPU 11 of the management server 1 (END).

[0057] FIG. 5 is a flowchart showing an example of the flow of the export process among the processes executed by the CPU 11 of the management server 1. In the processing in the CPU 11 of the management server 1, the data management unit 31 manages global data (step S21). Thereafter, when correspondence data is transmitted from the person in charge terminal 2 (YES in step S22), the data acquisition unit 32 acquires the transmitted correspondence data (step S23). Then, the data management unit 31 stores and manages the correspondence data acquired by the data acquisition unit 32 in a database (the correspondence DB 42 in FIG. 3) (step S24). On the other hand, when the correspondence data has not been transmitted (NO in step S22), the data acquisition unit 32 repeats the determination processing of step S22 until the correspondence data is transmitted.

[0058] The template generation unit 33 generates and registers a DL template based on the correspondence relationship identified from the correspondence relationship data acquired in step S23 (step S25). Specifically, the generated DL template is stored and managed in a database (template DB 43 in FIG. 3).

[0059] Thereafter, when one DL template is selected from the registered DL templates by an operation of the local administrator (YES in step S26), the export unit 35 of the CPU 11 generates export data in which global data is associated with each local data item based on the selected DL template (step S27).On the other hand, if one DL template has not been selected (NO in step S26), the export unit 35 repeats the determination process of step S26 until one DL template is selected.

[0060] The transmission control unit 36 ​​of the CPU 11 performs control to transmit the export data generated in step S27 to the person in charge terminal 2 (step S28). This ends the export process in the CPU 11 of the management server 1 (END).

[0061] <Example> (Specific examples of various types of data) Fig. 6(A) is a diagram showing specific examples of local data items. Fig. 6(B) is a diagram showing specific examples of global data items. Fig. 6(C) is a diagram showing specific examples of correspondence data. Fig. 6(D) is a diagram showing a specific example of a UL template. The local data items shown in FIG. 6(A) include "Name," "Salary," "Special Remuneration," and "Tax." The global data items shown in FIG. 6(B) include "Salary," "Bonus," "Deduction," and "Name." That is, the staff member terminal 2 manages local data consisting of items such as "Name," "Salary," "Special Remuneration," and "Tax." In contrast, the management server 1 manages global data consisting of items such as "Salary," "Bonus," "Deduction," and "Name." The order of the local data items does not necessarily have to be related to the order of the global data items.

[0062] The local administrator creates the correspondence data shown in FIG. 6(C) by operating the person in charge terminal 2. There are no particular limitations on the method for creating the correspondence data. Note that FIG. 6(C) shows an example of correspondence data created using spreadsheet application software pre-installed on the person in charge terminal 2. In the correspondence data shown in FIG. 6(C), the first row is made up of local data items, and the second row is made up of global data items.

[0063] The local administrator creates the correspondence data shown in Figure 6(C) using, for example, the following method. That is, the local administrator first exports the local data from the person in charge terminal 2. Next, the local administrator leaves the first line in which the items that make up the local data are entered, and deletes the other data (data from the second line onwards). Next, the local administrator enters in the second line the items of global data that correspond to each of the items entered in the first line.

[0064] Specifically, for example, if the items entered in the first line are "Name," "Salary," "Special Remuneration," and "Tax," the local administrator enters the global data items corresponding to "Name," "Salary," "Special Remuneration," and "Tax" in the second line. The local administrator enters "Name" as the global data item corresponding to "Name" entered in column R11, first column, of the first line, into column R21, first column, of the second line, and enters "Salary" as the global data item corresponding to "Salary" entered in column R12, second column, of the first line, into column R22, second column, of the second line. In addition, the local administrator enters "Bonus" as a global data item corresponding to the "Special Remuneration Amount" entered in column R13, third column of line 1, into column R23, third column of line 2, and enters "Deduction" as a global data item corresponding to the "Tax Amount" entered in column R14, fourth column of line 1, into column R24, fourth column of line 2.

[0065] Furthermore, the local administrator can register items to be added to the export data in the UL template. For example, as shown in Figure 6(C), a new item, "Total Pay," can be added to column R15 in the first row and fifth column. In this case, the local administrator can also enter the calculation formula for "Total Pay" in column R15. For example, if the value in column R12 in the first row and second column of a spreadsheet application is "A2" and the value in column R13 in the first row and third column is "A3," the local administrator can enter the combination of the item name and calculation formula (e.g., "Total Pay (=A2 + A3)") in column R15. When adding a new item, if there is a global data item corresponding to the "Total Pay" entered in column R15, the local administrator can register the name of that item. For example, if there is a global data item called "Income" that corresponds to "Total Pay," the name of that item can be entered in column R25 in the second row and fifth column.

[0066] The correspondence data created on the person in charge terminal 2 is sent to the management server 1. Then, the management server 1 generates and registers a UL template based on the correspondence data. Figure 6(D) shows a specific example of a UL template generated and registered by the management server 1. The first line of the UL template reflects the items entered in the first line of the correspondence data: "Name," "Salary," "Special Remuneration Amount," "Tax Amount," and "Total Payment Amount."

[0067] The second and subsequent rows of the UL template are input fields (blank fields) for individual data corresponding to the items in the first row. However, if the information entered in the first row of the correspondence data includes a formula, that formula is reflected in the second and subsequent rows. For example, column R45 in the second row, fifth column of the UL template reflects the formula (=A2+A3) entered in column R15 in the first row, fifth column of the correspondence data (see Figure 6(C)). Therefore, the sum (total payment amount) of the amount entered in column R42 in the second row, second column of the UL template (salary amount) and the amount entered in column R43 in the third column of the second row (special remuneration amount) is automatically calculated and entered in column R45 of the UL template.

[0068] The local administrator downloads the UL template from the management server 1 by operating the person in charge terminal 2. The local administrator then inputs local data into the downloaded UL template (or pastes copied local data). Specifically, for example, in the second row of FIG. 6(D), local data is input into each of columns R41 to R44. In this way, local data is input into the second and subsequent rows of the UL template. At this time, the "total payment amount," which is the sum of the "salary amount" and the "special remuneration amount," is automatically calculated and input into the fifth column of the second and subsequent rows of the UL template (for example, column R45 in the second row) based on the formula (=A2+A3).

[0069] The local administrator uploads a UL template, into which data for each item constituting the local data has been input, as upload data to the management server 1. The management server 1 then imports the data for each item constituting the local data input in the uploaded upload data into global data based on the correspondence relationship identified from the correspondence relationship data.

[0070] In this way, there are cases where the items constituting the local data managed on the person in charge terminal 2 and the items constituting the global data managed on the management server 1 are managed with different item names. However, by using a UL template generated based on the correspondence relationship data created by the local administrator, it is possible to simplify the series of operations of uploading local data from the person in charge terminal 2 to the management server 1 and importing it into global data.

[0071] In addition, even if the local system used on the person in charge terminal 2 is replaced or the specifications of the local data change, the UL template can be easily updated to a compatible one simply by creating correspondence relationship data on the person in charge terminal 2. Furthermore, even if there are many management units, a UL template is generated for each management unit, making it easy to import and integrate the local data managed by each of multiple local administrators into the global data managed by the global administrator.

[0072] Fig. 7(A) is a diagram showing a specific example of correspondence data, and Fig. 7(B) is a diagram showing a specific example of export data output based on a DL template. The local administrator creates correspondence data for registering a DL template for downloading global data and importing it into local data by operating the person in charge terminal 2. Fig. 7(A) shows a specific example of correspondence data for registering a DL template created by the local administrator.

[0073] In the first row of the correspondence data shown in FIG. 7(A), local data items are input. In addition, in the second row of the correspondence data, global data items corresponding to the local data items input in the first row are input. Specifically, in each of the first to fifth columns of the first row of the correspondence data shown in FIG. 7(A), "Name," "Special Remuneration Amount," "Total Payment Amount," and "Tax Amount" are input as local data items. In addition, in each of the first to fifth columns of the second row, "Name," "Bonus," "Income," and "Deduction" are input as global data items corresponding to the local data items.

[0074] The local administrator operates the person in charge terminal 2 to send the created correspondence data to the management server 1. As a result, a DL template is generated based on the contents of the correspondence data and registered in the information processing system S. The local administrator can register the contents of each of the multiple types of correspondence data as a different DL template in the information processing system S. As a result, the local administrator can select a desired DL template from the multiple types of DL templates registered in the information processing system S.

[0075] For example, suppose that a local administrator selects a DL template registered based on the contents of the correspondence data shown in Fig. 7(A). In this case, the individual global data items corresponding to "Name," "Bonus," "Income," and "Deduction" among the global data items are associated with the local data items "Name," "Bonus Amount," "Total Payment Amount," and "Tax Amount," and are output as export data.

[0076] Export data output from the global data managed by the management server 1 is downloaded to the person in charge terminal 2 and imported into the local data in the same format. Figure 7(B) shows a specific example of export data output by the management server 1 based on a DL template. The first line of the export data shown in Figure 7(B) contains the local data items. Furthermore, the second and subsequent lines of the export data contain individual global data items corresponding to each of the local data items entered on the first line.

[0077] <Advantageous Effects of the Present Embodiment> According to the above-described embodiment, a UL template that allows input of data for each item that constitutes the local data is generated based on the correspondence relationship identified from the correspondence data that indicates the correspondence relationship between multiple items that constitute the local data and multiple items that constitute the global data, and is provided to the person in charge terminal 2. Then, when local data is input into the UL template on the person in charge terminal 2 and uploaded to the management server 1 as upload data, the data for each item that constitutes the local data that has been input as upload data is imported into the global data based on the correspondence relationship identified from the correspondence data.

[0078] Furthermore, when a registered DL template is selected, export data is generated with the corresponding global data entered for each local data item and output for download. This allows for seamless data aggregation and sharing between management units, even if each management unit manages data consisting of multiple items using different systems and application software.

[0079] <Other embodiments> Although one embodiment of the present invention has been described above, the present invention is not limited to the above-described embodiment, and modifications, improvements, etc. within the scope of achieving the object of the present invention are included in the present invention.

[0080] For example, in the above embodiment, it has been described that one local data management application is installed on the person in charge terminal 2 operated by the local administrator. In this case, the information processing system S can export local data from the first local data management application, and once the data has been compared, confirmed, processed, etc. as global data, it can be used to import the data back into the first local data management application.

[0081] Furthermore, other application software for managing multiple pieces of local data (for example, a first local data management application and a second local data management application) may be installed in the person in charge terminal 2. In this case, for example, data from a first local data management app (e.g., an attendance management app) can be imported as global data, and once it has been compared, confirmed, processed, etc. as global data, it can be exported to a second local data management app.

[0082] The DL template registered for importing global data into a local data management software is generally different from the DL template registered for importing global data into another local data management software. In other words, the import format of one local data management software cannot be used as the import format of another local data management software.

[0083] On the other hand, even if a local administrator uses multiple systems or application software in the same management unit, the local administrator can share local data seamlessly by using UL templates and DL templates. Specifically, the local administrator uses a registered UL template to upload local data from the local data management software to the management server 1. As a result, the uploaded local data is imported into the global data managed by the management server 1.

[0084] Next, the local administrator selects a registered DL template, exports the data corresponding to the local data of the local data management software from the global data, and downloads it to the person in charge terminal 2. In this way, even if the import format of the local data management software cannot be used as is as the import format of other local data management software, the desired work can be performed seamlessly by combining the upload of local data to the management server 1 and the download of global data.

[0085] Furthermore, the above-described series of processes can be executed by hardware or software. In other words, the above-described functional configuration is merely an example and is not particularly limited. In other words, it is sufficient for the information processing system to be provided with a function that can execute the above-described series of processes as a whole, and the type of functional block used to realize this function is not particularly limited to the above-described example.

[0086] The location of the functional blocks is not particularly limited and may be arbitrary. For example, the functional blocks of the management server 1 may be transferred to another device, or the functional blocks of another device may be transferred to a server. Furthermore, one functional block may be configured as a single piece of hardware, a single piece of software, or a combination of both.

[0087] When a series of processes is executed by software, the programs constituting the software are installed onto a computer or the like from a network or a recording medium. The computer may be a computer incorporated into dedicated hardware. The computer may also be a computer capable of executing various functions by installing various programs, such as a server, a general-purpose smartphone, or a personal computer.

[0088] The recording medium containing such a program may be configured as a removable medium (not shown) that is distributed separately from the device main body in order to provide the program to users, etc., or may be configured as a recording medium that is pre-installed in the device main body and provided to users, etc. Since the program can be distributed via a network, the recording medium may be installed in or accessible from a computer that is connected or connectable to the network.

[0089] In this specification, the steps describing the program recorded on the recording medium include not only processes that are performed in chronological order, but also processes that are not necessarily performed in chronological order but are performed in parallel or individually. Also, in this specification, the term "system" means an overall device composed of multiple devices or multiple means, etc.

[0090] In other words, the information processing system to which the present invention is applied can take various forms having the following configurations. (1) That is, an information processing system to which the present invention is applied (for example, the global information processing system SG in FIG. 1) is a storage control means for controlling storage of first data (e.g., global data in the specification); a first correspondence data acquiring means (for example, the data acquiring unit 32 in FIG. 3) for acquiring first correspondence data (for example, data in a table format shown in FIG. 6(C)) indicating a first correspondence between a plurality of items (for example, item names managed in the local information processing system SL) constituting second data (for example, local data in the specification) managed in another information processing system (for example, the local information processing system SL in FIG. 1) and a plurality of items (for example, item names managed in the local information processing system SL) constituting the first data (for example, item names managed in the global information processing system SG); a generation and output means (for example, the template generation unit 33 in FIG. 3) that generates and outputs a template (for example, a tabular template shown in FIG. 6(D)) that allows data for each item constituting the second data to be input based on the first correspondence data; an import unit (e.g., the import unit 34 in FIG. 3) that imports data for each item constituting the target second data input into the template by a user of the other information processing system into the first data based on the first correspondence relationship; Equipped with.

[0091] As a result, a UL template is output that allows data for each item that makes up the second data to be input based on the correspondence relationship identified from the correspondence data that indicates the correspondence relationship between the multiple items that make up the second data and the multiple items that make up the first data. Then, when the second data is input into the UL template at the person in charge terminal 2 and uploaded to the management server 1 as upload data, the data for each item that makes up the upload data (the input second data) is imported into the first data based on the correspondence relationship identified from the correspondence data. As a result, even if different systems and application software are used for each management unit that manages data consisting of multiple items, data can be seamlessly aggregated between management units.

[0092] (2) Here, the first correspondence data acquisition means can acquire the first correspondence data created by the user in the other information processing system.

[0093] As a result, the first correspondence data is created by a user who manages the second data in a certain management unit, and the second data is imported as the first data. As a result, even if the systems and application software used by terminals that manage the first data in other management units are different, data aggregation and sharing between management units can be performed seamlessly, and the other management units and their users can be protected from the effects of changes in the system and application software in the management unit.

[0094] (3) The information processing system to which the present invention is applied further includes a second correspondence data acquisition means (e.g., the data acquisition unit 32 in FIG. 3) for acquiring second correspondence data indicating a second correspondence between a plurality of items constituting the first data and a plurality of items constituting the third data managed in the other information processing system (e.g., item names in the data after being imported again as local data); an export unit (e.g., the export unit 35 in FIG. 3) that exports data in which items of the first data are associated with items of the third data based on the second correspondence relationship identified from the second correspondence relationship data; Further provided are:

[0095] Thus, data in which the items of the first data correspond to the items of the third data based on the correspondence relationship identified from the correspondence data indicating the correspondence relationship between the multiple items constituting the third data and the multiple items constituting the first data is generated and output. As a result, even if different systems and application software are used for each management unit that manages data consisting of multiple items, data can be seamlessly shared between management units.

[0096] (4) The other information processing system is managed by a second organization different from the first organization that manages the first data. As a result, the second organization managing the second data and the third data is different from the first organization managing the first data. Generally, it is difficult to make all data items common between organizations, posing a problem of requiring item conversion when transferring data. If the second organization changes the format of the second data or the third data, it will cause the first organization to take on additional work. According to the present invention, the second organization can input the first correspondence data and the second correspondence data to perform import and export. Therefore, the second organization generates and outputs export data in which the first items correspond to each item of the second data. The output export data is downloaded to the person in charge terminal 2 and imported into the second data in the data management software for the second data in the same format. As a result, even if different systems and application software are used for each management unit managing data consisting of multiple items, data can be seamlessly shared between management units.

[0097] (5) The first correspondence data is The information includes, as a correspondence relationship with a predetermined item constituting the first data, information of an equation calculated based on data of an item constituting the second data, When data of an item constituting the second data on which the formula is based is input as the second data, the generation and output means generates and outputs a template that performs an operation according to the formula. The items of the template and the data for each item may include a calculation formula. This allows calculation formulas to be included in template items and data for each item, reducing the workload of local and global administrators.

[0098] (6) Furthermore, the information processing method executed by the information processing system to which the present invention is applied is a storage control step of executing control to store the first data; a first correspondence data acquisition step of acquiring first correspondence data indicating a first correspondence between a plurality of items constituting the first data and a plurality of items constituting second data managed in another information processing system; a generating and outputting step of generating and outputting a template that allows input of data for each item constituting the second data based on the first correspondence data; an import step of importing data for each item constituting the target second data input into the template by a user of the other information processing system into the first data based on the first correspondence relationship; Includes.

[0099] (7) Also, the program to which the present invention is applied is On the computer, a storage control step of executing control to store the first data; a first correspondence data acquisition step of acquiring first correspondence data indicating a first correspondence between a plurality of items constituting the first data and a plurality of items constituting second data managed in another information processing system; a generating and outputting step of generating and outputting a template that allows input of data for each item constituting the second data based on the first correspondence data; an import step of importing data for each item constituting the target second data input into the template by a user of the other information processing system into the first data based on the first correspondence relationship; The control process including the above is executed. [Explanation of symbols]

[0100] 1: Management server, 2: Personnel terminal, 11: CPU, 16: Output unit, 17: Input unit, 18: Storage unit, 19: Communication unit, 31: Data management unit, 32: Data acquisition unit, 33: Template generation unit, 34: Import unit, 35: Export unit, 36: Transmission control unit, 41: Global DB, 42: Correspondence DB, 43: Template DB, 51: Acquisition unit, 52: Display control unit, 53: Transmission control unit, 61: Local DB, S: Information processing system, N: Network

Claims

1. a storage control unit that controls storage of the first data; a first correspondence data acquisition means for acquiring first correspondence data indicating a first correspondence between a plurality of items constituting the first data and a plurality of items constituting the second data managed in another information processing system; a generation and output means for generating and outputting a template that allows input of data for each item constituting the second data based on the first correspondence data; an import unit that imports data for each item constituting the target second data input into the template by a user of the other information processing system into the first data based on the first correspondence relationship; An information processing system comprising:

2. The first correspondence data acquisition means acquiring the first correspondence data created by the user in the other information processing system; The information processing system according to claim 1 .

3. a second correspondence data acquisition means for acquiring second correspondence data indicating a second correspondence between a plurality of items constituting the first data and a plurality of items constituting the third data managed in the other information processing system; an export means for exporting data in which items of the first data are associated with items of the third data based on the second correspondence relationship identified from the second correspondence relationship data; The information processing system according to claim 1 , further comprising:

4. the other information processing system is managed by a second organization different from a first organization that manages the first data; The information processing system according to claim 1 .

5. The first correspondence data is The information includes, as a correspondence relationship with a predetermined item constituting the first data, information on an equation calculated based on data of an item constituting the second data, the generation and output means, when data of items constituting the second data on which the formula is based is input as the second data, generates and outputs a template that performs an operation in accordance with the formula. The information processing system according to claim 1 .

6. An information processing method executed by an information processing system, a storage control step of executing control to store the first data; a first correspondence data acquisition step of acquiring first correspondence data indicating a first correspondence between a plurality of items constituting the first data and a plurality of items constituting second data managed in another information processing system; a generating and outputting step of generating and outputting a template that allows input of data for each item constituting the second data based on the first correspondence data; an import step of importing data for each item constituting the target second data input into the template by a user of the other information processing system into the first data based on the first correspondence relationship; An information processing method including:

7. On the computer, a storage control step of executing control to store the first data; a first correspondence data acquisition step of acquiring first correspondence data indicating a first correspondence between a plurality of items constituting the first data and a plurality of items constituting second data managed in another information processing system; a generating and outputting step of generating and outputting a template that allows input of data for each item constituting the second data based on the first correspondence data; an import step of importing data for each item constituting the target second data input into the template by a user of the other information processing system into the first data based on the first correspondence relationship; A program that executes control processing including:

Images