A salary statistics method, system, computer device and readable storage medium

By configuring the relationship between the control scheme and the salary items, the complexity of salary data statistics for subsidiaries of large enterprise groups has been solved, enabling flexible hierarchical statistics and data display, and meeting the statistical needs of organizations at all levels within the enterprise.

CN114723396BActive Publication Date: 2026-04-10SHANDONG INSPUR GENESOFT INFORMATION TECH CO LTD
View PDF 2 Cites 0 Cited by

Patent Information

Authority / Receiving Office
CN · China
Patent Type
Patents(China)
Current Assignee / Owner
Filing Date
2022-03-28
Publication Date
2026-04-10

AI Technical Summary

Technical Problem

The salary data statistics needs of various units under large enterprise groups are complex, and existing systems are unable to meet the statistical needs of different dimensions, especially in the context of diversified cost analysis and control information.

Method used

By flexibly configuring the relationships between management and control schemes and management items, as well as between compensation schemes and compensation items, the system enables data conversion and display of compensation items in different statistical business scenarios, meeting the statistical needs of every level of the enterprise organization.

Benefits of technology

It enables tiered statistics of payroll items under different statistical business scenarios, meets the statistical needs of management and control items of organizations at all levels of the enterprise, and improves the flexibility and accuracy of data statistics.

✦ Generated by Eureka AI based on patent content.

Smart Images

  • Figure CN114723396B_ABST
    Figure CN114723396B_ABST
Patent Text Reader

Abstract

The present application relates to the technical field of data processing, and discloses a salary statistical method and system, a computer device and a readable storage medium.The method comprises the following steps: defining a control scheme and control items under the control scheme; defining a salary scheme and salary items under the salary scheme, and establishing an association relationship between the salary scheme and the corresponding control scheme and between the salary items and the corresponding control items; receiving business data and storing the business data in the dimension of the salary items; in response to receiving a salary statistical request, converting the business data stored in the dimension of the salary items into business data in the dimension of the control items based on the association relationship, and sending the business data in the dimension of the control items to a salary statistical interface to display the business data in the dimension of the control items. Through the present application, hierarchical statistics of the salary items are realized.
Need to check novelty before this filing date? Find Prior Art

Description

TECHNICAL FIELD

[0001] The present application relates to the technical field of data processing, and in particular to a salary statistical method, system, computer device and readable storage medium. BACKGROUND

[0002] With the diversification of enterprise salary accounting business and the pertinence of salary control data statistics, the business demand of salary control data statistics is becoming more and more complex and urgent. In most enterprises, especially large enterprise groups, each subordinate unit often has different business demands for cost analysis and salary data statistics. At this time, various different dimension control schemes are usually defined for statistics, and the system is needed to support the statistical demand of enterprises at different levels of organization in different dimensions in order to better statistically control the information of each enterprise of the group. SUMMARY

[0003] Therefore, the present application provides a salary statistical method, system, computer device and readable storage medium, which realizes the statistics of corresponding salary business data of the salary item in different statistical business scenarios by flexibly configuring the control scheme, the control item under the control scheme, the salary scheme, the salary item under the salary scheme, the association relationship between the salary item and the control item, and the association relationship between the hierarchical control items. In addition, it also meets the statistical demand of the control item of each level of organization, and realizes the hierarchical statistics of the salary item in various salary statistical dimension business scenarios based on different hierarchical organizations.

[0004] Based on the above purpose, one aspect of an embodiment of the present application provides a salary statistical method, which specifically includes the following steps:

[0005] defining a control scheme and a control item under the control scheme;

[0006] defining a salary scheme and a salary item under the salary scheme, and establishing an association relationship between the salary scheme and the corresponding control scheme and between the salary item and the corresponding control item;

[0007] receiving business data and storing the business data in the salary item dimension;

[0008] in response to receiving a salary statistical request, converting the business data stored in the salary item dimension into business data in the control item dimension based on the association relationship, and sending the business data in the control item dimension to a salary statistical interface to display the business data in the control item dimension.

[0009] In some embodiments, converting the business data stored in the salary item dimension into business data in the control item dimension based on the association relationship includes:

[0010] Based on the association relationship, corresponding business data stored in the salary item dimension is obtained, and the corresponding business data stored in the salary item dimension is converted into business data of the management and control item dimension in the form of metadata.

[0011] In some embodiments, establishing the association relationship between the salary scheme and the corresponding management and control scheme, and between the salary item and the corresponding management and control item includes:

[0012] The corresponding management and control scheme is added to the foreign key of the salary scheme, and the corresponding management and control item is added to the foreign key of the salary item.

[0013] In some embodiments, defining the management and control scheme and the management and control item under the management and control scheme includes:

[0014] Defining the basic information of the management and control scheme, the basic information of the management and control scheme including the management and control scheme name, the organization to which it belongs;

[0015] Defining the basic information of the management and control item, the basic information of the management and control item including the management and control item name and the management and control level to which it belongs.

[0016] In some embodiments, defining the salary scheme and the salary item under the salary scheme includes:

[0017] Defining the basic information of the salary scheme, the basic information of the salary scheme including the salary scheme name and the management and control scheme to which it belongs;

[0018] Defining the basic information of the salary item, the basic information of the salary item including the salary item name, the increase / decrease attribute, and the management and control item under the management and control scheme set by the corresponding salary scheme.

[0019] In some embodiments, after defining the salary scheme and the salary item under the salary scheme, and establishing the association relationship between the salary scheme and the corresponding management and control scheme, and between the salary item and the corresponding management and control item, further includes:

[0020] Storing the defined management and control scheme, management and control item, salary scheme and salary item into the database.

[0021] In some embodiments, based on the association relationship, the business data stored in the salary item dimension is converted into business data of the management and control item dimension includes:

[0022] Obtaining the association relationship between the management and control scheme, the management and control item, the salary scheme and the salary item from the database;

[0023] Based on the association relationship, the business data stored in the salary item dimension is converted into business data of the management and control item dimension and stored into the database.

[0024] Another aspect of the embodiment of the present application also provides a salary statistics system, comprising:

[0025] A first definition module configured to define a management and control scheme and a management and control item under the management and control scheme;

[0026] A second definition module configured to define a salary scheme and a salary item under the salary scheme, and to establish a correlation between the salary scheme and a corresponding management and control scheme and between the salary item and a corresponding management and control item;

[0027] A receiving processing module configured to receive business data and store the business data in a salary item dimension;

[0028] A statistics module configured to, in response to receiving a salary statistics request, convert the business data stored in the salary item dimension into business data in a management and control item dimension based on the correlation, and send the business data in the management and control item dimension to a salary statistics interface for display.

[0029] Still another aspect of the embodiment of the present application also provides a computer device, comprising: at least one processor; and a memory storing a computer program executable on the processor, the computer program being executed by the processor to implement the steps of the above method.

[0030] Still another aspect of the embodiment of the present application also provides a computer readable storage medium storing a computer program executable by a processor to implement the steps of the above method.

[0031] The present application has at least the following beneficial technical effects: by flexibly configuring the management and control scheme and the management and control item under the management and control scheme, the salary scheme and the salary item under the salary scheme, the correlation between the salary item and the management and control item, and the correlation between the hierarchical management and control items, the salary item can realize the statistics of the corresponding salary business data in different statistical business scenarios; and it also meets the management and control item statistical requirements of each level of organization of an enterprise, and realizes the hierarchical statistics of the salary item in various salary statistical dimension business scenarios under different hierarchical organizations. BRIEF DESCRIPTION OF DRAWINGS

[0032] In order to more clearly illustrate the technical solutions in the embodiments of the present application or the prior art, the following will briefly introduce the drawings needed to be used in the embodiments or prior art description. Obviously, the drawings in the following description are only some embodiments of the present application, and for those skilled in the art, other embodiments can also be obtained from these drawings without creative labor.

[0033] Figure 1 A block diagram of an embodiment of the compensation statistics method provided by the present application;

[0034] Figure 2 A schematic diagram of an embodiment of the establishment of a management and control scheme for a group company provided by the present application;

[0035] Figure 3 A schematic diagram of an embodiment of the establishment of a management and control scheme for a group company and a management and control project under the management and control scheme provided by the present application;

[0036] Figure 4 A schematic diagram of an embodiment of the compensation statistics system provided by the present application;

[0037] Figure 5 A structural schematic diagram of an embodiment of the computer device provided by the present application;

[0038] Figure 6 A structural schematic diagram of an embodiment of the computer readable storage medium provided by the present application. DETAILED DESCRIPTION

[0039] In order to make the objectives, technical solutions and advantages of the present application clearer and more apparent, the embodiments of the present application are further described in detail below with reference to the accompanying drawings.

[0040] It should be noted that all the expressions of "first" and "second" in the embodiments of the present application are used to distinguish two same-named different entities or different parameters, and the "first" and "second" are only used for the convenience of description and should not be understood as a limitation of the embodiments of the present application. The subsequent embodiments will not be described one by one.

[0041] Based on the above purpose, the first aspect of the embodiments of the present application proposes an embodiment of a compensation statistics method. As shown in the figure, it includes the following steps: Figure 1

[0042] S101, defining a management and control scheme and a management and control project under the management and control scheme;

[0043] S103, defining a compensation scheme and a compensation project under the compensation scheme, and establishing an association relationship between the compensation scheme and the corresponding management and control scheme and between the compensation project and the corresponding management and control project;

[0044] S105, receiving business data and storing the business data in the dimension of the compensation project;

[0045] ​S107, in response to receiving the salary statistics request, converting the business data stored in the salary item dimension into business data in the management item dimension based on the association relationship, and sending to the salary statistics interface to display the business data in the management item dimension.

[0046] In step S101, define the management scheme basic information, including the scheme name and the organization to which it belongs, whether it is associated with the superior management scheme, if it is associated with the superior management scheme, the management scheme basic information contains the superior management scheme, if it is not associated with the superior management scheme, the management scheme basic information does not contain the superior management scheme. Define the management project basic information, including the project name, the management level to which it belongs, the superior management project and other information. Establish an association relationship between the management project and the management scheme, that is, establish a hierarchical management project under the management scheme, as shown in Figure 2 An embodiment of establishing a management scheme for a group company. Group A establishes a group A management scheme, A company under group A establishes an A management scheme, B company under group A establishes a B management scheme, A company under group A establishes an A company A department management scheme and an A company B department management scheme, and B company under group A establishes a B company A department management scheme and a B company B department management scheme. If group A wants to conduct management statistics based on A and B companies, it can set the association relationship between A and B management schemes and group A management scheme.

[0047] As shown in Figure 3 An embodiment of establishing a management scheme and a management project under the management scheme for a group company.

[0048] Group B establishes a group B management scheme, and group B management project 1, 2 …… n is established under the group B management scheme. A company under group B establishes an A company management scheme, and A company management project 1, 2 …… n is established under the A company management scheme. B company under group B establishes a B company management scheme, and B company management project 1, 2 …… n is established under the B company management scheme. Group B management project is established in association with A company management project 1, 2 …… n, B company management project 1, 2 …… n and group B management project 1, 2 …… n, Figure 3 A company management project and B company management project are omitted in the association relationship between B company management project 1, 2 …… n and group B management project 1, 2 …… n. The project content of A company management project and B company management project is related to the content of salary statistics, such as basic salary, performance salary, overtime allowance, business trip allowance, quarterly bonus, annual bonus, provident fund, etc. The management project established by each company is self-defined according to the company's requirements, and the order of the management project is self-defined. It is not limited to one-to-one correspondence of the content of each company's project 1, 2 …… n. Through the establishment of the association relationship, the management projects of each company are corresponded.

[0049] In step S103, the basic information of the salary scheme is defined, including the scheme name and the belonging management and control scheme; the basic information of the salary item is defined, including the item name, the increase / decrease attribute, and the belonging management and control item under the management and control scheme set by the corresponding salary scheme.

[0050] In combination Figure 3 , the group B establishes a salary scheme of the group B, establishes salary items 1, 2, …, n under the salary scheme of the group B, and establishes the association relationship between the salary items 1, 2, …, n and the management and control items 1, 2, …, n of the group B. Similarly, the subordinate A company of the group B establishes a salary scheme of the A company, establishes salary items 1, 2, …, n under the salary scheme of the A company, and establishes the association relationship between the salary items 1, 2, …, n and the management and control items 1, 2, …, n of the A company; the subordinate B company of the group B establishes a salary scheme of the B company, establishes salary items 1, 2, …, n under the salary scheme of the B company, and establishes the association relationship between the salary items 1, 2, …, n and the management and control items 1, 2, …, n of the B company. The item content of the salary item and the item content of the management and control item are similar, and are the content related to the salary statistics, for example, basic salary, performance salary, overtime allowance, business trip allowance, quarterly bonus, annual bonus, and public accumulation fund. Similarly, the salary items established by each company are self-defined according to the company requirements, and the order of the salary items is self-defined. The content of the salary items 1, 2, …, n of each company is not limited to be one-to-one corresponding, and the content of the salary items 1, 2, …, n of each company is not limited to be one-to-one corresponding to the content of the corresponding management and control item. Through the establishment of the association relationship, the salary items of each company are corresponded to the management and control items.

[0051] In steps S101 and S103, the management and control schemes and the management and control items of different business attributes are defined according to the salary hierarchical statistics. Whether the management and control scheme is associated with the superior organization can be set on the management and control scheme. The management and control item can be defined hierarchically, that is, the management and control item associated with the superior organization is set. The defined salary scheme and salary item are distributed to the management and control scheme and the management and control item, to indicate which management and control items need to be counted in the salary scheme.

[0052] In step S105, the salary business data input by the user is received, and the salary business data is counted according to the salary item and stored in the database, so as to facilitate the subsequent salary query and salary statistical business.

[0053] In step S107, in response to receiving a salary statistics request of the group company or the superior company, each company in the statistics range is converted into the business data of the management and control project dimension based on the association relationship between the salary project and the management and control project and the association relationship between the management and control projects of different companies, and the business data of the salary project dimension is sent to the salary statistics interface for display. Through the association relationship between the salary project and the management and control project and the association relationship between the management and control projects of different companies, the corresponding salary business data can be quickly obtained, and redundant management and control projects in a certain organization level can be avoided.

[0054] The embodiment of the present application can flexibly configure the management and control scheme, the management and control project under the management and control scheme, the salary scheme, the salary project under the salary scheme, the association relationship between the salary project and the management and control project, and the association relationship between the hierarchical management and control projects, realize the statistics of the corresponding salary business data of the salary project in different statistical business scenarios, meet the management and control project statistics demand of each organization of the enterprise, and realize the hierarchical statistics of the salary project in various salary statistical dimension business scenarios under different hierarchical organizations.

[0055] In some embodiments, the business data stored in the salary project dimension is converted into the business data of the management and control project dimension based on the association relationship, including:

[0056] Based on the association relationship, the corresponding business data stored in the salary project dimension is obtained, and the corresponding business data stored in the salary project dimension is converted into the business data of the management and control project dimension in the form of metadata.

[0057] Specifically, metadata is data for describing data, mainly used for describing information of data attributes, and used to support functions such as indicating storage location, historical data, resource search, file recording, etc. In the embodiment, the metadata specifically refers to the project name of the management and control project. In order to facilitate the statistics of the salary business data, the salary business data of the salary project dimension is converted into the salary business data of the management and control project dimension presented in the form of metadata, i.e. the salary project name.

[0058] Further, the salary business data presented in the form of metadata can be obtained by get() method, specifically as follows:

[0059] get_base_meta(company_id, biz_type);

[0060] company_id: current unit code

[0061] biz_type: metadata type

[0062] The metadata of the salary business data of the management and control project dimension obtained based on the salary statistics request is returned in the above manner.

[0063] Further, the metadata of the management and control project dimension is displayed on a salary statistics interface, such as a salary statistics table.

[0064] In some embodiments, establishing a correlation relationship for the salary scheme and the corresponding management and control scheme and the salary project and the corresponding management and control project comprises:

[0065] Adding the corresponding management and control scheme to the foreign key of the salary scheme and adding the corresponding management and control project to the foreign key of the salary project.

[0066] When defining the management and control scheme, the management and control project, the salary scheme, and the salary project, if there is a correlation relationship between the salary scheme and the management and control scheme, the corresponding management and control scheme information is added to the foreign key of the salary scheme field to establish a relationship between the salary scheme and the corresponding management and control; if there is a correlation relationship between the salary project and the management and control project, the corresponding management and control project information is added to the foreign key of the salary project field to establish a correlation relationship between the salary project and the corresponding management and control project; if there is a correlation relationship between the management and control project of the current level and the management and control project of the upper level, the management and control project information of the upper level is added to the foreign key of the management and control project field of the current level to establish a relationship between the management and control project of the current level and the management and control project of the upper level.

[0067] In some embodiments, defining the management and control scheme and the management and control project under the management and control scheme comprises:

[0068] Defining basic information of the management and control scheme, the basic information of the management and control scheme comprising a management and control scheme name and a belonging organization;

[0069] Defining basic information of the management and control project, the basic information of the management and control project comprising a management and control project name and a belonging management and control level.

[0070] In some embodiments, defining the salary scheme and the salary project under the salary scheme comprises:

[0071] Defining basic information of the salary scheme, the basic information of the salary scheme comprising a salary scheme name and a belonging management and control scheme;

[0072] Defining basic information of the salary project, the basic information of the salary project comprising a salary project name, an increase or decrease attribute, and a management and control project under a management and control scheme set by a corresponding salary scheme.

[0073] Specifically, through the defined management and control scheme, management and control project, salary scheme, and salary project information, the specific implementation process of obtaining the salary business data is as follows:

[0074] summary_statistic_data

[0075] (company_id, program_id=None, month=None, department_id=None, state='calc');

[0076] company_id: Current company code

[0077] program_id: Salary plan ID

[0078] month: statistical month

[0079] depart_id: Department ID,

[0080] `state`: This is used to set additional statistical conditions, such as permissions.

[0081] Method body structure:

[0082]

[0083]

[0084] In some implementations, after defining the compensation scheme and the compensation items under the compensation scheme, and establishing associations between the compensation scheme and the corresponding management scheme, and between the compensation items and the corresponding management items, the process further includes:

[0085] The defined control scheme, control items, compensation scheme, and compensation items are stored in the database.

[0086] The defined control schemes, control items, compensation schemes, and compensation items are stored in the database to persist the defined information.

[0087] In some implementations, converting business data stored at the payroll item dimension into business data at the management item dimension based on the association includes:

[0088] Retrieve the relationships between the management plan, the management items, the compensation plan, and the compensation items from the database;

[0089] Based on the aforementioned relationships, the business data stored in the salary item dimension is converted into business data in the management item dimension and stored in the database.

[0090] Based on the same inventive concept, according to another aspect of the present invention, such as Figure 4 As shown, embodiments of the present invention also provide a salary statistics system, including:

[0091] A first definition module 110 is configured to define a management and control scheme and a management and control item under the management and control scheme;

[0092] A second definition module 120 is configured to define a salary scheme and a salary item under the salary scheme, and to establish a correlation between the salary scheme and a corresponding management and control scheme and between the salary item and a corresponding management and control item;

[0093] A receiving processing module 130 is configured to receive business data and store the business data in a salary item dimension;

[0094] A statistical module 140 is configured to, in response to receiving a salary statistics request, convert the business data stored in the salary item dimension into business data in a management and control item dimension based on the correlation, and send the business data in the management and control item dimension to a salary statistics interface to display the business data in the management and control item dimension.

[0095] The embodiments of the present application can flexibly configure the management and control scheme and the management and control item under the management and control scheme, the salary scheme and the salary item under the salary scheme, the correlation between the salary item and the management and control item, and the correlation between the hierarchical management and control items, and realize the statistics of the corresponding salary business data of the salary item in different statistical business scenarios. In addition, the statistical requirements of the management and control item of each level of organization of the enterprise are met, and the hierarchical statistics of the salary item in various salary statistical dimension business scenarios under different hierarchical organizations are realized.

[0096] Based on the same inventive concept, according to another aspect of the present application, as shown in Figure 5 The embodiments of the present application also provide a computer device 30, which includes a processor 310 and a memory 320, the memory 320 stores a computer program 321 executable on the processor, and the processor 310 executes the steps of the method as above when executing the program.

[0097] Based on the same inventive concept, according to another aspect of the present application, as shown in Figure 6 The embodiments of the present application also provide a computer readable storage medium 40, which stores a computer program 410 executed by a processor to execute the method as above.

[0098] Those of skill would further appreciate that the various illustrative logical blocks, modules, circuits, and algorithm steps described in connection with the disclosure herein can be implemented as electronic hardware, computer software, or combinations of both. To clearly illustrate this interchangeability of hardware and software, various illustrative components, blocks, modules, circuits, and steps have been described above generally in terms of their functionality. Whether such functionality is implemented as hardware or software depends upon the particular application and design constraints imposed on the overall system. Skilled artisans can implement the described functionality in varying ways for each particular application, but such implementation decisions should not be interpreted as causing a departure from the scope of the present embodiments.

[0099] The above are only exemplary embodiments of the present embodiments, but it should be noted that various changes and modifications can be made without departing from the scope of the present embodiments defined by the claims. The functions, steps and / or actions of the method claims described above need not be performed in any particular order. Unless explicitly stated otherwise, the ordinal use of terms such as first, second, etc., in the description above does not reflect an ordinal use of the terms in the description of the embodiments. Furthermore, although the elements of the present embodiments can be described or claimed in individual forms, unless expressly limited to individual form, multiple elements can be substituted for a single element of an embodiment. The embodiments of the present embodiments disclosed above can be implemented in the form of software, firmware, hardware, or any combination thereof.

[0100] It should be understood that, as used herein, the singular forms "a", "an" and "the" are intended to include the plural forms as well, unless the context clearly indicates otherwise. It will be further understood that the terms "comprises" and / or "comprising", or "includes" and / or "including" when used herein, specify the presence of stated features, integers, steps, operations, elements, and / or components but do not preclude the presence or addition of one or more other features, integers, steps, operations, elements, components, and / or groups thereof.

[0101] Those of skill would further appreciate that the various illustrative logical blocks, modules, circuits, and algorithm steps described in connection with the disclosure herein can be implemented as electronic hardware, computer software, or combinations of both. To clearly illustrate this interchangeability of hardware and software, various illustrative components, blocks, modules, circuits, and steps have been described above generally in terms of their functionality. Whether such functionality is implemented as hardware or software depends upon the particular application and design constraints imposed on the overall system. Skilled artisans can implement the described functionality in varying ways for each particular application, but such implementation decisions should not be interpreted as causing a departure from the scope of the present embodiments.

Claims

1. A compensation statistics method, characterized by, The method comprises the following steps: defining a management and control scheme under which a hierarchical management and control project is established; wherein the management and control scheme basic information comprises a scheme name and a belonging organization, whether it is associated with a superior management and control scheme, if associated with a superior management and control scheme, the management and control scheme basic information comprises a superior management and control scheme, if not associated with a superior management and control scheme, the management and control scheme basic information does not comprise a superior management and control scheme; the management and control project basic information comprises a management and control project name, a belonging management and control level and a superior management and control project; defining a salary scheme and a salary project under the salary scheme, and adding a corresponding management and control scheme to the foreign key of the salary scheme, and adding a corresponding management and control project to the foreign key of the salary project, to establish an association relationship between the salary scheme and the corresponding management and control scheme and between the salary project and the corresponding management and control project, and to correspond the salary project and the management and control project of each company, wherein the salary scheme comprises a salary scheme name and a belonging management and control scheme; the salary project comprises a salary project name, a management and control project under a management and control scheme set by a corresponding salary scheme; receiving business data and storing the business data in a salary project dimension; in response to receiving a salary statistics request of a group company or a superior company, each company in a statistics range is based on the association relationship between the salary project and the management and control project and the association relationship between the management and control projects of different companies, converts the business data stored in the salary project dimension into business data in a management and control project dimension, and sends the business data in the management and control project dimension to a salary statistics interface to display the business data in the management and control project dimension.

2. The method of claim 1, wherein, Based on the association relationship between the salary project and the management and control project and the association relationship between the management and control projects of different companies, converting the business data stored in the salary project dimension into business data in a management and control project dimension comprises: Based on the association relationship between the salary project and the management and control project and the association relationship between the management and control projects of different companies, obtaining corresponding business data stored in the salary project dimension, and converting the corresponding business data stored in the salary project dimension into metadata form business data in a management and control project dimension.

3. The method of claim 1, wherein, The salary project further comprises an increase / decrease attribute.

4. The method of claim 1, wherein, After defining the salary scheme and the salary project under the salary scheme, and establishing the association relationship between the salary scheme and the corresponding management and control scheme and between the salary project and the corresponding management and control project, the method further comprises: storing the defined management and control scheme, management and control project, salary scheme and salary project into a database.

5. The method of claim 4, wherein, Based on the association relationship, converting the business data stored in the salary project dimension into business data in a management and control project dimension comprises: obtaining the association relationship between the management and control scheme, the management and control project, the salary scheme and the salary project from the database; based on the association relationship, converting the business data stored in the salary project dimension into business data in a management and control project dimension and storing it into the database.

6. A compensation statistics system, characterized by, The method comprises the following steps: A first definition module is configured to define a management and control scheme, and establish a hierarchical management and control project under the management and control scheme, wherein the management and control scheme basic information includes a scheme name and a belonging organization, and whether it is associated with a superior management and control scheme, if associated with the superior management and control scheme, the management and control scheme basic information includes the superior management and control scheme, if not associated with the superior management and control scheme, the management and control scheme basic information does not include the superior management and control scheme; and the management and control project basic information includes a management and control project name, a belonging management and control level and a superior management and control project; A second definition module is configured to define a salary scheme and a salary project under the salary scheme, and add a corresponding management and control scheme to an external key of the salary scheme, and add a corresponding management and control project to an external key of the salary project, so as to establish an association relationship between the salary scheme and the corresponding management and control scheme and between the salary project and the corresponding management and control project, and correspond the salary project and the management and control project of each company, wherein the salary scheme includes a salary scheme name and a belonging management and control scheme; and the salary project includes a salary project name, a management and control project under a management and control scheme set by a corresponding salary scheme; A receiving and processing module is configured to receive business data and store the business data in a salary project dimension; A statistical module is configured to, in response to receiving a salary statistics request of a group company or a superior company, based on an association relationship between the salary project and the management and control project and an association relationship between the management and control projects of each different company, convert the business data stored in the salary project dimension into business data in a management and control project dimension, and send the business data in the management and control project dimension to a salary statistics interface to display the business data in the management and control project dimension.

7. A computer device, comprising: at least one processor; and a memory storing a computer program capable of running on the processor, characterized in that the processor executes the program to execute the steps of the method according to any one of claims 1 to 5.

8. A computer-readable storage medium storing a computer program, the computer program comprising instructions that, when executed by a computer, cause the computer to perform the method of any one of claims 1 to 7. The computer program is executed by the processor to execute the steps of the method according to any one of claims 1 to 5.

Citation Information

Patent Citations

  • Method for dynamically expanding personnel transaction in human resource management information system

    CN102110142A

  • Salary management system

    CN113435852A