CN110471912B - Employee attribute information verification method and device and terminal equipment - Google Patents
Employee attribute information verification method and device and terminal equipment Download PDFInfo
- Publication number
- CN110471912B CN110471912B CN201910667523.4A CN201910667523A CN110471912B CN 110471912 B CN110471912 B CN 110471912B CN 201910667523 A CN201910667523 A CN 201910667523A CN 110471912 B CN110471912 B CN 110471912B
- Authority
- CN
- China
- Prior art keywords
- employee
- information
- attribute
- attribute information
- staff
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Active
Links
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/21—Design, administration or maintenance of databases
- G06F16/214—Database migration support
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/21—Design, administration or maintenance of databases
- G06F16/215—Improving data quality; Data cleansing, e.g. de-duplication, removing invalid entries or correcting typographical errors
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q10/00—Administration; Management
- G06Q10/10—Office automation; Time management
- G06Q10/105—Human resources
Landscapes
- Engineering & Computer Science (AREA)
- Databases & Information Systems (AREA)
- Theoretical Computer Science (AREA)
- Business, Economics & Management (AREA)
- Physics & Mathematics (AREA)
- Human Resources & Organizations (AREA)
- General Physics & Mathematics (AREA)
- Data Mining & Analysis (AREA)
- Strategic Management (AREA)
- Quality & Reliability (AREA)
- Entrepreneurship & Innovation (AREA)
- General Engineering & Computer Science (AREA)
- Economics (AREA)
- Marketing (AREA)
- Operations Research (AREA)
- Tourism & Hospitality (AREA)
- General Business, Economics & Management (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The invention provides a staff attribute information verification method, a device and terminal equipment, which are suitable for the technical field of data processing, and the method comprises the following steps: acquiring attribute information and job level of each employee in a database to be checked; judging whether the employee numbers corresponding to each piece of position information are in the corresponding preset employee number ranges respectively, and judging whether the ratio between the employee numbers corresponding to each piece of position level meets the preset number distribution ratio; identifying a first type attribute tag of each employee based on the type of each piece of information in the attribute information, and inquiring a second type attribute tag corresponding to each employee according to the attribute corresponding relation table; judging whether the attribute information of each employee contains the information of the corresponding second type attribute tag; if all three judging results are met, judging that the attribute information data is complete and correct. The embodiment of the invention realizes the quick verification of the integrity of the employee attribute information data after migration and combination.
Description
Technical Field
The invention belongs to the technical field of data processing, and particularly relates to a staff attribute information verification method and terminal equipment.
Background
In practical applications, different attribute information of an employee may be stored in different databases, for example, basic personal information, job record, attendance information and performance information of the employee may be stored in 4 different databases, and when all attribute information of the employee is summarized, various attribute information of users stored in the databases needs to be migrated and combined.
In actual situations, due to the fact that the number of staff is large and the staff attribute information is large, the data quantity of the staff attribute information which is required to be migrated and combined is large finally, so that the problem of data loss is extremely easy to occur in the migration and combination process, the loss mainly comprises the loss of the whole attribute information of some staff, such as the attribute information of 1000 staff, but the attribute information of 10 staff is lost after combination, so that the attribute information of 990 staff is remained finally, and part of the attribute information of some staff is lost, such as the attendance information in the attribute information of staff A is lost, the integrity check of the attribute information of the staff in a database after combination is required, and the possible problem of data loss is found in time.
In the prior art, technicians manually compare the data of the original database and the data of the combined database after migration and combination to judge whether the employee attribute information data is complete or not, and the efficiency is quite low.
Disclosure of Invention
In view of the above, the embodiment of the invention provides a method and terminal equipment for verifying employee attribute information, so as to solve the problem that in the prior art, the efficiency of the method for verifying the integrity of migrated and combined employee attribute information data is low.
A first aspect of an embodiment of the present invention provides a method for checking employee attribute information, including:
acquiring attribute information of each employee in a database to be checked, and inquiring a position level of the employee according to position information in the attribute information;
judging whether the employee numbers corresponding to each piece of position information are in the corresponding preset employee number ranges respectively, and judging whether the ratio between the employee numbers corresponding to each piece of position level meets the preset number distribution ratio;
acquiring a preset attribute corresponding relation table, wherein a plurality of first type attribute tags and one or more second type attribute tags on which each first type attribute tag depends are recorded in the attribute corresponding relation table; identifying a first type attribute tag of each employee based on the type of each piece of information in the attribute information, and inquiring a second type attribute tag corresponding to each employee according to the attribute corresponding relation table;
Judging whether the attribute information of each employee contains the information of the corresponding second type attribute tag;
if the number of staff corresponding to each piece of position information is in a preset staff number range corresponding to each piece of position information, the number of staff corresponding to each piece of position level meets a preset number distribution proportion, the attribute information of each piece of staff contains the information of the corresponding second type attribute tag, and the attribute information data is judged to be complete.
A second aspect of an embodiment of the present invention provides an employee attribute information verification apparatus, including:
the information acquisition module is used for acquiring attribute information of each employee in the database to be checked and inquiring the position level of the employee according to the position information in the attribute information;
the number judging module is used for judging whether the number of staff corresponding to each piece of position information is in a preset staff number range corresponding to each piece of position information, and judging whether the ratio between the staff numbers corresponding to each piece of position level meets a preset number distribution ratio;
the tag query module is used for acquiring a preset attribute corresponding relation table, wherein a plurality of first type attribute tags and one or more second type attribute tags on which each first type attribute tag depends are recorded in the attribute corresponding relation table; identifying a first type attribute tag of each employee based on the type of each piece of information in the attribute information, and inquiring a second type attribute tag corresponding to each employee according to the attribute corresponding relation table;
The information detection module is used for judging whether the attribute information of each employee contains the information of the corresponding second type attribute tag;
the first complete detection module is used for judging that the attribute information data is complete if the number of staff corresponding to each piece of position information is in a preset staff number range corresponding to each piece of position information, the number of staff corresponding to each piece of position level meets a preset number distribution proportion, and the attribute information of each piece of staff contains the information of the corresponding second type of attribute tags.
A third aspect of the embodiments of the present invention provides a terminal device, where the terminal device includes a memory, and a processor, where the memory stores a computer program that can be run on the processor, and where the processor implements the steps of the employee attribute information verification method as described above when the processor executes the computer program.
A fourth aspect of embodiments of the present invention provides a computer-readable storage medium comprising: a computer program is stored, characterized in that the computer program, when executed by a processor, implements the steps of the employee attribute information verification method as described above.
Compared with the prior art, the embodiment of the invention has the beneficial effects that: according to the embodiment of the invention, the integrity verification is carried out on the attribute information of the staff in the combined database from the two aspects of the whole layer and the detail layer, specifically, based on the staff number range of each position in the position organization structure and the staff number proportion of each position layer, the attribute information of all staff is integrally verified, so that when the attribute information of each position staff is completely lost, a large amount of data analysis is not needed, the situation of complete loss can be found out in time by simply carrying out quantity statistics, the detail layer, considering that different attribute information has a certain logic dependency relationship, based on the dependency relationship among the attribute information, the first type attribute label which can exist only by needing other dependency attribute information is firstly determined, then whether the attribute information of the staff in the database contains the information of the second type attribute label on which the first type attribute label depends is judged, if the attribute information exists, and therefore, the quick verification on whether the attribute information of each position staff is normally exists is realized, and the complicated data processing operation is not needed, and finally, the integrity verification of the attribute information in the database is completely and the detail layer is completely checked.
Drawings
In order to more clearly illustrate the technical solutions of the embodiments of the present invention, the drawings that are needed in the embodiments or the description of the prior art will be briefly described below, it being obvious that the drawings in the following description are only some embodiments of the present invention, and that other drawings may be obtained according to these drawings without inventive effort for a person skilled in the art.
Fig. 1 is a schematic implementation flow chart of an employee attribute information verification method according to an embodiment of the present invention;
fig. 2 is a schematic implementation flow chart of an employee attribute information verification method according to a second embodiment of the present invention;
fig. 3 is a schematic implementation flow chart of an employee attribute information verification method according to the third embodiment of the present invention;
fig. 4 is a schematic implementation flow chart of an employee attribute information verification method according to a fourth embodiment of the present invention;
fig. 5 is a schematic structural diagram of an employee attribute information verification apparatus according to a fifth embodiment of the present invention;
fig. 6 is a schematic diagram of a terminal device according to a sixth embodiment of the present invention.
Detailed Description
In the following description, for purposes of explanation and not limitation, specific details are set forth such as the particular system architecture, techniques, etc., in order to provide a thorough understanding of the embodiments of the present invention. It will be apparent, however, to one skilled in the art that the present invention may be practiced in other embodiments that depart from these specific details. In other instances, detailed descriptions of well-known systems, devices, circuits, and methods are omitted so as not to obscure the description of the present invention with unnecessary detail.
In order to illustrate the technical scheme of the invention, the following description is made by specific examples.
In order to facilitate understanding of the present invention, the embodiments of the present invention are briefly described herein, and in the actual situation, data loss is very likely to occur in the migration and merging of employee attribute information with large data volume, but in spite of the loss of the entire attribute information or the loss of part of attribute information of an employee, the final merged employee attribute information data is incomplete, and in order to perform integrity verification on the merged data, in the prior art, a technician manually compares the data of the original database and the merged database to determine whether the employee attribute information data is complete, but in the face of employee attribute information with large data volume, the manual comparison efficiency is low and is prone to error.
Considering the actual situation, on one hand, for each company, the staff number of each staff level in the organization architecture can be known in advance and relatively fixed, on the other hand, the staff attribute information has certain specificity, different attribute information has certain logic dependency relationship, for example, the staff has basic personal information to explain that the staff is in normal staff of the company, can have subsequent optional records, attendance information, performance information and the like, and is based on the actual situations, the invention carries out integrity check on the staff attribute information in the merged database from the two aspects of the whole layer and the detail layer, specifically, because the attribute information itself contains staff position information, the invention calculates the staff number of each staff level through the attribute information, carries out whole check on the attribute data of all staff based on the staff number range of each staff level in the staff organization architecture and the staff number proportion of each staff level, so that when the staff attribute information is completely lost, the situation that the staff can be completely lost can be found without carrying out a large amount of data analysis, and the situation that the staff is completely lost can be simply found out, and if the first class-II attribute information is not required to be quickly checked based on the first-class-B attribute information, and the dependency relationship is not required to be quickly determined based on the first-class-I attribute information, and the first-class attribute information has the attribute information, and the dependency relationship is required to be quickly checked based on the first class-B attribute information, and finally, checking the integrity of the employee attribute information data after migration and merging is realized by judging that the attribute information in the database is complete and correct when the integrity of the employee attribute information data is checked in the whole layer and the detail layer. The details are as follows:
Fig. 1 shows a flowchart of an implementation of an employee attribute information verification method according to an embodiment of the present invention, which is described in detail below:
s101, acquiring attribute information of each employee in the database to be checked, and inquiring the position hierarchy of the employee according to position information in the attribute information.
S102, judging whether the employee numbers corresponding to each piece of position information are in the corresponding preset employee number ranges, and judging whether the ratio between the employee numbers corresponding to each piece of position level meets the preset number distribution ratio.
The database to be checked is obtained by transferring and combining employee attribute information data in the original database.
Because the total staff number of each company and the staff number corresponding to each position may change in real time, the staff number and position situations actually contained in the merging cannot be predicted in advance, and it is difficult to preset staff positions and corresponding lists, but the staff position organization architecture is generally unchanged for the company, that is, how many kinds of positions are set up, the hierarchical relationship among the positions, the staff number distribution proportion of each position level and the like are relatively fixed, for example, a director, a total manager level, a total supervision level, a supervisor level and common staff can be set up, 5 position levels are all set up, the director length is 1 person, the total manager level is 1 to 5 persons, the total supervision level is 10 to 15, the supervisor level is 20 to 30 and the common staff is more than 100, and meanwhile, the staff number distribution proportion of each level is set up to be the director length: the total manager level is 1:3-5: the total supervision level is 1:3-5: the main pipe stage is 1:2-3: the ratio of the common staff to the staff is 1:5-10. In the embodiment of the invention, corresponding organization structure data are preset according to the actual situation of the company to be checked, or the organization structure data of the company to be checked are analyzed based on the original database, so that the number range of staff corresponding to each piece of position information, the position level to which each piece of position information belongs and the number of staff corresponding to each position level are obtained. On the basis of acquiring required organization structure data, the embodiment of the invention firstly counts the number of staff corresponding to each piece of position information according to the position information in the attribute information, counts the number of staff corresponding to each piece of position level, compares the counted actual data with the data in the organization structure data, judges whether the number of staff corresponding to each piece of position information meets the range requirement of the corresponding number of staff, judges whether the number proportion of staff among the position levels in the actual data meets the number distribution proportion in the organization structure data, and if so, indicates that the whole-level staff attribute information in the database to be checked is not lost completely. If a certain job level exists in a plurality of pairwise proportional relationships in the quantity distribution proportion at the same time, for example, in the above example, the total manager level exists in the "board: the total manager level is 1:3-5' and the total manager level is as follows: in the general supervision level of 1:3-5', the staff number of the position hierarchy is required to meet all corresponding pairwise proportion relationships at the same time, and then the pairwise proportion between the staff number corresponding to the position hierarchy and the staff number of other position hierarchies is judged to meet the quantity distribution proportion.
S103, a preset attribute corresponding relation table is obtained, and a plurality of first type attribute labels and one or a plurality of second type attribute labels on which each first type attribute label depends are recorded in the attribute corresponding relation table. And identifying a first type attribute tag of each employee based on the type of each piece of information in the attribute information, and inquiring a second type attribute tag corresponding to each employee according to the attribute corresponding relation table.
On the other hand, the above description shows that the attribute information has a certain logic dependency relationship, for example, an employee must have a job record and can have performance information, so even if it is impossible to know in advance what attribute information each employee may have (because the job position of each employee is different and even the same job position, there is a difference between actual individual situations of different employees, so that it is difficult to predict attribute information situations of all employees one by one), according to some attribute information of the employees in the merged data, it can be theoretically inferred that what information must have according to the dependency relationship between attribute information, for example, in the merged database, employee a has performance information, it is indicated that it must have basic personal information, job record and attendance information, at this time, the attribute information of employee a can be checked to determine whether the condition is satisfied, if the condition is satisfied, the attribute information of employee a is indicated as correct, and if the condition is not satisfied, it is indicated that the attribute information of employee a must have a problem, that is the migration process data has a problem. Therefore, in order to realize the record of the attribute logic relationship existing in the attachment, attribute information corresponding to the dependency is set for each attribute information in the scheme, for example, the performance information depends on basic personal information, optional record and attendance information, so as to obtain the attribute corresponding relationship table required by the embodiment of the invention. It should be noted that, since the dependency relationship itself is a relative concept, for a single attribute information, it may be a first attribute tag that needs to depend on other attribute information, or may be a second attribute tag that is dependent, or may belong to both the first attribute tag and the second attribute tag, for example, for a performance prize, it is attached to the performance information, where the performance information is the second attribute tag, and thus the performance information belongs to both the first attribute tag and the second attribute tag, and therefore when setting the attribute correspondence table, it is necessary to perform classification and setting of the corresponding first attribute tag and the second attribute tag according to the actual dependency and the dependent situation of the performance information.
After the attribute corresponding relation table is obtained, the embodiment of the invention queries one or more first attribute tags corresponding to each employee according to the first attribute tags recorded in the attribute corresponding relation table and the attribute information actually possessed by the employee, and screens out second attribute tags corresponding to each first attribute tag. For example, in the above example, assuming that the queried employee a includes performance information in the first attribute tags, a plurality of corresponding second attribute tags may be screened out: basic personal information, tenure records and attendance information.
S104, judging whether the attribute information of each employee contains the information of the corresponding second type attribute label.
After determining the second attribute tags corresponding to each employee, searching the attribute information of the employee in turn, and if attribute information corresponding to the second attribute tags is included, for example, in the above example, it is assumed that the query of a plurality of second attribute tags corresponding to employee a is: the attribute information of the staff A is inquired to judge whether the specific basic personal information, the job record and the attendance information data content are contained or not. If the attribute information is included, the attribute information of the explanation staff A is complete.
S105, if the number of staff corresponding to each piece of position information is in a preset staff number range corresponding to each piece of position information, the number of staff corresponding to each piece of position level meets a preset number distribution proportion, and the attribute information of each piece of staff contains information of a corresponding second type attribute tag, the attribute information data is judged to be complete.
According to the embodiment of the invention, the integrity verification is carried out on the attribute information of the staff in the combined database from the two aspects of the whole layer and the detail layer, specifically, the whole verification is carried out on the attribute information of all staff based on the staff number range of each position in the position organization structure and the staff number proportion of each position layer, so that when the attribute information of each staff is completely lost, a large amount of data analysis is not needed, the situation of complete loss can be found out in time by simply carrying out quantity statistics, the detail layer is considered, the first type attribute tag which can exist only by needing other dependency attribute information is determined based on the dependency relation among the attribute information, then whether the attribute information of the staff in the database contains the information of the second type attribute tag on which the first type attribute tag depends is judged, if so, the attribute information is normally existing is indicated, and finally, the whole and the complete and the error-free performance of the attribute information in the database is judged. In practical cases, the data loss is not just as simple as one or two pieces of data, and the amount of the lost data is at least tens to tens, so that when the integrity check is carried out, the embodiment of the invention is not limited to the check of specific data content of single attribute information, but the integral check is carried out by taking the single employee attribute as a unit, and meanwhile, the detail check is carried out on the single employee attribute by using the dependency relationship corresponding to each piece of attribute information.
As a specific implementation manner for obtaining organization architecture data in the first embodiment of the present invention, as shown in fig. 2, the second embodiment of the present invention includes:
s201, organization structure data which are respectively counted and sent by one or more original databases are obtained, wherein the organization structure data comprise the number of staff corresponding to each piece of position information in the original databases and the number of staff corresponding to each piece of position level.
S202, summarizing and analyzing one or more pieces of organization structure data, and determining a preset staff number range corresponding to each piece of position information respectively and a number distribution ratio between staff numbers corresponding to each piece of position hierarchy based on the summarized organization structure data.
In the embodiment of the invention, in order to ensure the accuracy and effectiveness of the used organization structure data, the actual organization structure data in each original database is counted, namely the number of staff corresponding to each piece of position information and the corresponding staff data under each piece of position level in each original database are counted, and the original database transfers the staff attribute information data and simultaneously sends the organization structure data to the database to be checked.
After the database to be checked receives one or more pieces of organization structure data sent by all the original databases (the number of the original databases is determined by actual conditions for carrying out organization structure statistics because staff position information does not necessarily exist in all the original databases), the received organization structure data are summarized to obtain the organization structure data before final actual combination. It should be noted that, unlike the case where the technician sets the organization structure data in advance, the embodiment of the present invention is the organization structure data obtained by counting the real situation of the original database, so for the embodiment of the present invention, the range of the number of employees corresponding to each piece of position information included in the organization structure data should be a specific numerical value, rather than a value range including a plurality of numerical values, for example, 3 persons in the general supervision, rather than 1 to 3 persons, and similarly, the number distribution ratio corresponding to each position level should also be a specific ratio value, rather than the ratio range exemplified in the first embodiment of the present invention.
In the embodiment of the invention, the organization architecture data for checking the number of staff is very accurate and reliable by counting and summarizing the organization architecture data of the original database, and meanwhile, the data quantity is very small because only some quantity information is recorded in the organization architecture data, so that little influence is caused on data transmission and the like, the accuracy of checking the integrity of the attribute data of the staff is greatly improved, and the safety and the rapidness of the checking are ensured.
As an embodiment of the present invention, in order to implement quick integrity verification of employee attribute information, before performing the verification method in the first embodiment of the present invention, the method further includes:
and checking whether the position information of each employee in the database to be checked is complete, and if the checking result is complete, executing the operation of acquiring the attribute information of each employee in the database to be checked.
Because the position information of each employee is necessarily existing data, the embodiment of the invention can directly check whether the position information of each employee exists completely, if not, or the data is incomplete, the employee attribute data can be directly judged to be incomplete, otherwise, the method of the embodiment of the invention is executed to check. The method for verifying whether the position information is complete can preset all positions contained in the company to be verified, and set corresponding position coexistence rules, for example, positions of a management level and common staff members cannot coexist in position information of one staff member, and then verify the position information of each staff member by utilizing the prestored position information and position coexistence rules to judge whether the requirements are met.
As a third embodiment of the present invention, in order to implement quick integrity verification of employee attribute information, before performing the verification method in the first embodiment of the present invention, as shown in fig. 3, the method further includes:
s301, identifying the type of information contained in the attribute information, and searching for a data format corresponding to each type.
S302, performing format verification on the attribute information based on the data format, and if the format verification is correct, executing the operation of acquiring the attribute information of each employee in the database to be verified.
In the embodiment of the invention, certain differences are considered in the data format of different types of attribute information, for example, job information is generally Chinese or English characters, and attendance records are generally digital + punctuation characters, so that the embodiment of the invention can set the data format actually corresponding to each type of attribute information in advance, and the data format of each type of employee attribute information is checked before the integrity check of the first embodiment of the invention is carried out, if the attribute information with wrong format exists, the attribute information is indicated to have errors, and the employee attribute information is directly judged to be incomplete at the moment. The embodiment of the invention only performs data format verification of the attribute information, but does not relate to specific data content identification analysis and other processes, so that the actual processing workload is relatively small, and preliminary and rapid verification of the attribute information of staff is realized on the basis of not increasing the verification workload additionally.
As the fourth embodiment of the present invention, considering that in actual situations, when the data size of the employee attribute information is large, the workload of the integrity check is also large, and at this time, a certain error possibility may exist in the check work itself, so in order to avoid interference to the integrity check result caused by the error of the check work itself, the embodiment of the present invention does not directly determine that the employee attribute information data is incomplete when the check result is not the whole level and the detail level simultaneously meets the requirements, and further performs repeated check, as shown in fig. 4, including:
s401, if the number of staff corresponding to any piece of position information is not in the corresponding preset staff number range, the number of staff corresponding to any piece of position level does not meet the preset number distribution proportion, or the attribute information of any piece of staff does not contain the information of the corresponding second type attribute tag, judging that the verification is abnormal, and updating the number of times of the verification is abnormal.
When the three-aspect verification is insufficient, the verification result is not capable of proving the integrity of the employee attribute information data, but the result is not capable of being the integrity of the employee attribute information data, and is also capable of being errors, such as errors, in the verification process, for example, the statistics data are errors, and the like, so that the embodiment of the invention does not directly judge that the employee attribute information is incomplete, but judges that the verification is abnormal, and counts the corresponding verification abnormal times.
And S402, if the verification anomaly times are smaller than a preset anomaly times threshold value, returning to execute the operation of acquiring the attribute information of each employee in the database to be verified until the attribute information data are complete and correct as a result of judgment.
S403, if the number of verification anomalies is greater than or equal to a preset anomaly number threshold, judging that the attribute information has data loss.
In the embodiment of the invention, firstly, a threshold value of the number of abnormality is preset by a technician, and when the integrity check is abnormal, the threshold value of the number of abnormality is updated and judged, if the threshold value of the number of abnormality is not exceeded, the integrity check of the first embodiment of the invention is carried out, so that errors possibly caused by the check work per se are reduced, when the check is abnormal for a plurality of times, the possibility of errors of the check work per se is extremely small, therefore, the embodiment of the invention can directly judge that the attribute information has data loss, and if the threshold value of the number of abnormality is within, the attribute information data is identified to be complete and correct, the former check abnormality is extremely likely to be the errors of the check work per se, and therefore, the attribute information data can be directly judged to be complete and correct at the moment.
Corresponding to the method of the above embodiment, fig. 5 shows a block diagram of the employee attribute information verification apparatus provided in the embodiment of the present invention, and for convenience of explanation, only the portion relevant to the embodiment of the present invention is shown. The employee attribute information verification apparatus illustrated in fig. 5 may be an execution subject of the employee attribute information verification method provided in the first embodiment.
Referring to fig. 5, the employee attribute information verification apparatus includes:
the information obtaining module 51 is configured to obtain attribute information of each employee in the database to be verified, and query a job level of the employee according to job information in the attribute information.
The number judging module 52 is configured to judge whether the number of employees corresponding to each piece of job position information is within a preset number of employees corresponding to each piece of job position information, and judge whether a ratio between the number of employees corresponding to each piece of job position level meets a preset number distribution ratio.
The tag query module 53 is configured to obtain a preset attribute correspondence table, where a plurality of first type attribute tags and one or more second type attribute tags on which each first type attribute tag depends are recorded in the attribute correspondence table. And identifying a first type attribute tag of each employee based on the type of each piece of information in the attribute information, and inquiring a second type attribute tag corresponding to each employee according to the attribute corresponding relation table.
The information detection module 54 is configured to determine whether the attribute information of each employee includes information of the corresponding attribute tag of the second class.
The first integrity detection module 55 is configured to determine that the attribute information data is complete if the number of employees corresponding to each piece of job information is within a preset employee number range corresponding to each piece of job information, the number of employees corresponding to each piece of job level meets a preset number distribution ratio, and the attribute information of each piece of employees includes information of the corresponding second type attribute tag.
Further, the employee attribute information verification apparatus further includes:
the data acquisition module is used for acquiring organization architecture data which are respectively counted and sent by one or more original databases, wherein the organization architecture data comprise the number of staff corresponding to each piece of position information in the original databases and the number of staff corresponding to each piece of position level.
The data analysis module is used for summarizing and analyzing one or more pieces of organization structure data, and determining the preset employee number range corresponding to each piece of position information respectively and the number distribution proportion among the employee numbers corresponding to each piece of position hierarchy based on the summarized organization structure data.
Further, the employee attribute information verification apparatus further includes:
and checking whether the position information of each employee in the database to be checked is complete, and if the checking result is complete, executing the operation of acquiring the attribute information of each employee in the database to be checked.
Further, the employee attribute information verification apparatus further includes:
and identifying the type of the information contained in the attribute information, and searching the data format corresponding to each type.
And carrying out format verification on the attribute information based on the data format, and if the format verification is correct, executing the operation of acquiring the attribute information of each employee in the database to be verified.
Further, the employee attribute information verification apparatus further includes:
the second complete detection module is used for judging the verification abnormality and updating the verification abnormality times if any employee number which is not corresponding to each piece of position information is not in a preset employee number range which is respectively corresponding to any employee number, the employee number which is corresponding to any position level does not meet a preset number distribution proportion, or the attribute information of any employee and each employee does not contain the corresponding information of the second type attribute tag.
And the detection module is used for returning to execute the operation of acquiring the attribute information of each employee in the database to be checked if the checking abnormal times are smaller than a preset abnormal times threshold value until the judging result is that the attribute information data are complete.
And the judging module is used for judging that the attribute information has data loss if the check anomaly times are greater than or equal to the preset anomaly times threshold value.
The process of implementing the respective functions of each module in the employee attribute information verification apparatus provided in the embodiment of the present invention may refer to the description of the first embodiment shown in fig. 1, which is not repeated herein.
It should be understood that the sequence number of each step in the foregoing embodiment does not mean that the execution sequence of each process should be determined by the function and the internal logic, and should not limit the implementation process of the embodiment of the present invention.
It will also be understood that, although the terms "first," "second," etc. may be used herein in some embodiments of the invention to describe various elements, these elements should not be limited by these terms. These terms are only used to distinguish one element from another element. For example, a first table may be named a second table, and similarly, a second table may be named a first table without departing from the scope of the various described embodiments. The first table and the second table are both tables, but they are not the same table.
Fig. 6 is a schematic diagram of a terminal device according to an embodiment of the present invention. As shown in fig. 6, the terminal device 6 of this embodiment includes: a processor 60, a memory 61, said memory 61 having stored therein a computer program 62 executable on said processor 60. The steps of the various employee attribute information verification method embodiments described above, such as steps 101 through 105 shown in fig. 1, are implemented by the processor 60 when executing the computer program 62. Alternatively, the processor 60, when executing the computer program 62, performs the functions of the modules/units of the apparatus embodiments described above, such as the functions of the modules 51 to 55 shown in fig. 5.
The terminal device 6 may be a computing device such as a desktop computer, a notebook computer, a palm computer, a cloud server, etc. The terminal device may include, but is not limited to, a processor 60, a memory 61. It will be appreciated by those skilled in the art that fig. 6 is merely an example of the terminal device 6 and does not constitute a limitation of the terminal device 6, and may include more or less components than illustrated, or may combine certain components, or different components, e.g., the terminal device may also include an input transmitting device, a network access device, a bus, etc.
The processor 60 may be a central processing unit (Central Processing Unit, CPU), other general purpose processors, digital signal processors (Digital Signal Processor, DSP), application specific integrated circuits (Application Specific Integrated Circuit, ASIC), off-the-shelf programmable gate arrays (Field-Programmable Gate Array, FPGA) or other programmable logic devices, discrete gate or transistor logic devices, discrete hardware components, or the like. A general purpose processor may be a microprocessor or the processor may be any conventional processor or the like.
The memory 61 may be an internal storage unit of the terminal device 6, such as a hard disk or a memory of the terminal device 6. The memory 61 may be an external storage device of the terminal device 6, such as a plug-in hard disk, a Smart Media Card (SMC), a Secure Digital (SD) Card, a Flash memory Card (Flash Card) or the like, which are provided on the terminal device 6. Further, the memory 61 may also include both an internal storage unit and an external storage device of the terminal device 6. The memory 61 is used for storing the computer program and other programs and data required by the terminal device. The memory 61 may also be used for temporarily storing data that has been transmitted or is to be transmitted.
In addition, each functional unit in the embodiments of the present invention may be integrated in one processing unit, or each unit may exist alone physically, or two or more units may be integrated in one unit. The integrated units may be implemented in hardware or in software functional units.
The integrated modules/units, if implemented in the form of software functional units and sold or used as stand-alone products, may be stored in a computer readable storage medium. Based on such understanding, the present invention may implement all or part of the flow of the method of the above embodiment, or may be implemented by a computer program to instruct related hardware, where the computer program may be stored in a computer readable storage medium, and when the computer program is executed by a processor, the computer program may implement the steps of each of the method embodiments described above. Wherein the computer program comprises computer program code which may be in source code form, object code form, executable file or some intermediate form etc. The computer readable medium may include: any entity or device capable of carrying the computer program code, a recording medium, a U disk, a removable hard disk, a magnetic disk, an optical disk, a computer Memory, a Read-Only Memory (ROM), a random access Memory (Random Access Memory, RAM), an electrical carrier signal, a telecommunications signal, a software distribution medium, and so forth.
The above embodiments are only for illustrating the technical solution of the present invention, and not for limiting the same; although the invention has been described in detail with reference to the foregoing embodiments, it will be understood by those of ordinary skill in the art that: the technical scheme described in the foregoing embodiments can be modified or some technical features thereof can be replaced by equivalents; such modifications and substitutions do not depart from the spirit and scope of the technical solutions of the embodiments of the present invention, and are intended to be included in the scope of the present invention.
Claims (6)
1. The employee attribute information verification method is characterized by comprising the following steps of:
acquiring attribute information of each employee in a database to be checked, and inquiring a position level of the employee according to position information in the attribute information;
judging whether the employee numbers corresponding to each piece of position information are in the corresponding preset employee number ranges respectively, and judging whether the ratio between the employee numbers corresponding to each piece of position level meets the preset number distribution ratio;
acquiring a preset attribute corresponding relation table, wherein a plurality of first type attribute tags and one or more second type attribute tags on which each first type attribute tag depends are recorded in the attribute corresponding relation table; identifying a first type attribute tag of each employee based on the type of each piece of information in the attribute information, and inquiring a second type attribute tag corresponding to each employee according to the attribute corresponding relation table;
Judging whether the attribute information of each employee contains the information of the corresponding second type attribute tag;
if the number of staff corresponding to each piece of position information is in a preset staff number range corresponding to each piece of position information, the number of staff corresponding to each piece of position level meets a preset number distribution proportion, and the attribute information of each piece of staff contains the information of the corresponding second type attribute tag, the attribute information data is judged to be complete;
if the number of staff corresponding to any piece of position information is not in the corresponding preset staff number range, the number of staff corresponding to any piece of position level does not meet the preset number distribution proportion, or the attribute information of any piece of staff does not contain the corresponding information of the second type attribute tag, judging that the verification is abnormal, and updating the number of times of the verification abnormality;
if the verification anomaly times are smaller than a preset anomaly times threshold value, returning to execute the operation of acquiring the attribute information of each employee in the database to be verified until the judgment result is that the attribute information data are complete;
if the verification anomaly times are greater than or equal to the preset anomaly times threshold value, judging that the attribute information has data loss;
Before the attribute information of each employee in the database to be checked is obtained, the method comprises the following steps:
obtaining organization architecture data which are respectively counted and sent by one or more original databases, wherein the organization architecture data comprise the number of staff corresponding to each piece of position information in the original databases and the number of staff corresponding to each piece of position level;
and carrying out summarization analysis on one or more pieces of organization structure data, and determining the preset employee number range corresponding to each piece of position information respectively and the number distribution proportion between the employee numbers corresponding to each piece of position hierarchy based on the summarized organization structure data.
2. An employee attribute information verification method as in claim 1, further comprising, prior to said obtaining attribute information for each employee in the database to be verified:
and checking whether the position information of each employee in the database to be checked is complete, and if the checking result is complete, executing the operation of acquiring the attribute information of each employee in the database to be checked.
3. An employee attribute information verification method as in claim 1, further comprising, prior to said obtaining attribute information for each employee in the database to be verified:
Identifying the type of the information contained in the attribute information, and searching the data format corresponding to each type;
and carrying out format verification on the attribute information based on the data format, and if the format verification is correct, executing the operation of acquiring the attribute information of each employee in the database to be verified.
4. An employee attribute information verification apparatus, comprising:
the information acquisition module is used for acquiring attribute information of each employee in the database to be checked and inquiring the position level of the employee according to the position information in the attribute information;
the number judging module is used for judging whether the number of staff corresponding to each piece of position information is in a preset staff number range corresponding to each piece of position information, and judging whether the ratio between the staff numbers corresponding to each piece of position level meets a preset number distribution ratio;
the tag query module is used for acquiring a preset attribute corresponding relation table, wherein a plurality of first type attribute tags and one or more second type attribute tags on which each first type attribute tag depends are recorded in the attribute corresponding relation table; identifying a first type attribute tag of each employee based on the type of each piece of information in the attribute information, and inquiring a second type attribute tag corresponding to each employee according to the attribute corresponding relation table;
The information detection module is used for judging whether the attribute information of each employee contains the information of the corresponding second type attribute tag;
the first complete detection module is used for judging that the attribute information data is complete if the number of staff corresponding to each piece of position information is in a preset staff number range corresponding to each piece of position information and the number of staff corresponding to each piece of position level meets a preset number distribution proportion, and the attribute information of each piece of staff contains information of the corresponding second type of attribute tags;
the second complete detection module is used for judging that the verification is abnormal and updating the number of the verification abnormality if the number of staff corresponding to any one of the position information is not in the corresponding preset staff number range and the number of staff corresponding to any one of the position levels does not meet the preset number distribution proportion or the attribute information of any one of the staff does not contain the information of the corresponding second type attribute tag;
the detection module is used for returning to execute the operation of acquiring the attribute information of each employee in the database to be checked if the checking abnormal times are smaller than a preset abnormal times threshold value until the judging result is that the attribute information data are complete;
The judging module is used for judging that the attribute information has data loss if the verification anomaly times are greater than or equal to the preset anomaly times threshold value;
the data acquisition module is used for acquiring organization architecture data which are respectively counted and sent by one or more original databases, wherein the organization architecture data comprise the number of staff corresponding to each piece of position information in the original databases and the number of staff corresponding to each piece of position level;
the data analysis module is used for summarizing and analyzing one or more pieces of organization structure data, and determining the preset employee number range corresponding to each piece of position information respectively and the number distribution proportion among the employee numbers corresponding to each piece of position hierarchy based on the summarized organization structure data.
5. A terminal device, characterized in that it comprises a memory, a processor, on which a computer program is stored which is executable on the processor, the processor executing the computer program to carry out the steps of the method according to any one of claims 1 to 3.
6. A computer readable storage medium storing a computer program, characterized in that the computer program when executed by a processor implements the steps of the method according to any one of claims 1 to 3.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910667523.4A CN110471912B (en) | 2019-07-23 | 2019-07-23 | Employee attribute information verification method and device and terminal equipment |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910667523.4A CN110471912B (en) | 2019-07-23 | 2019-07-23 | Employee attribute information verification method and device and terminal equipment |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN110471912A CN110471912A (en) | 2019-11-19 |
| CN110471912B true CN110471912B (en) | 2023-07-25 |
Family
ID=68509169
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201910667523.4A Active CN110471912B (en) | 2019-07-23 | 2019-07-23 | Employee attribute information verification method and device and terminal equipment |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN110471912B (en) |
Families Citing this family (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN112488729A (en) * | 2020-11-30 | 2021-03-12 | 上海中商网络股份有限公司 | Data verification method and device, computer equipment and readable storage medium |
| CN112732755B (en) * | 2020-12-30 | 2024-03-22 | 招商局金融科技有限公司 | Label value matching joint verification method and device based on customer grouping and computer equipment |
| CN114048744A (en) * | 2021-10-28 | 2022-02-15 | 盐城金堤科技有限公司 | Entity extraction-based job record generation method, device and equipment |
Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| WO2015062767A1 (en) * | 2013-11-01 | 2015-05-07 | Peter Fink | System and method for visualizing and simulating personal knowledge structures in a company |
| WO2018120457A1 (en) * | 2016-12-29 | 2018-07-05 | 平安科技（深圳）有限公司 | Data processing method, apparatus, device, and computer readable storage medium |
| CN108510239A (en) * | 2018-03-13 | 2018-09-07 | 平安普惠企业管理有限公司 | Employee information management method, device, computer equipment and storage medium |
Family Cites Families (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US7739195B2 (en) * | 2001-01-12 | 2010-06-15 | Acs State & Local Solutions, Inc. | Apparatus and methods for providing a payment system over a network |
-
2019
- 2019-07-23 CN CN201910667523.4A patent/CN110471912B/en active Active
Patent Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| WO2015062767A1 (en) * | 2013-11-01 | 2015-05-07 | Peter Fink | System and method for visualizing and simulating personal knowledge structures in a company |
| WO2018120457A1 (en) * | 2016-12-29 | 2018-07-05 | 平安科技（深圳）有限公司 | Data processing method, apparatus, device, and computer readable storage medium |
| CN108510239A (en) * | 2018-03-13 | 2018-09-07 | 平安普惠企业管理有限公司 | Employee information management method, device, computer equipment and storage medium |
Also Published As
| Publication number | Publication date |
|---|---|
| CN110471912A (en) | 2019-11-19 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US9047164B2 (en) | Calculating defect density by file and source module | |
| CN110471912B (en) | Employee attribute information verification method and device and terminal equipment | |
| CN110928718A (en) | Exception handling method, system, terminal and medium based on correlation analysis | |
| CN111177134B (en) | Data quality analysis method, device, terminal and medium suitable for mass data | |
| US10210227B2 (en) | Processing a data set | |
| CN112445875A (en) | Data association and inspection method and device, electronic equipment and storage medium | |
| CN110825757A (en) | Equipment behavior risk analysis method and system | |
| CN112559831A (en) | Link monitoring method and device, computer equipment and medium | |
| CN106528828A (en) | Multi-dimensional checking rule-based data quality detection method | |
| CN110389941B (en) | Database checking method, device, equipment and storage medium | |
| CN113469857A (en) | Data processing method and device, electronic equipment and storage medium | |
| CN112667501A (en) | Link testing method and device based on automatic baffle and related equipment | |
| CN112364145A (en) | Work order processing method and device, electronic equipment and storage medium | |
| CN113806343B (en) | Evaluation method and system for Internet of vehicles data quality | |
| JP2009181496A (en) | Job processing system and job management method | |
| CN113434542A (en) | Data relation identification method and device, electronic equipment and storage medium | |
| CN115099922B (en) | Financial data query method, system, readable storage medium and computer equipment | |
| CN109710651B (en) | Data type identification method and device | |
| CN111045849A (en) | Method, device, server and storage medium for identifying reason of checking abnormality | |
| CN114116811B (en) | Log processing method, device, equipment and storage medium | |
| CN115562934A (en) | Service flow switching method based on artificial intelligence and related equipment | |
| CN114780106A (en) | Interface function self-development system | |
| CN114706856A (en) | Fault processing method and device, electronic equipment and computer readable storage medium | |
| CN112346938B (en) | Operation auditing method and device, server and computer readable storage medium | |
| CN113900902A (en) | Log processing method and device, electronic equipment and storage medium |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |