About HR Data Quality Dashboards
The following HR Data Quality dashboards identify data errors and inconsistencies based on a set of business rules:
The Data Quality Indexes on these pages indicate the quality of the data, where 0% represents the lowest data integrity and 100% represents the highest data integrity.
Note the following about business rules:
- Rules are categorized into two groups:
- PA (Personnel Administration): Employee-related attributes
- OM (Organizational Management): Position-related attributes
- Each rule is configured with a Severity Level (and Severity Value):
- High: 0.5
- Medium: 0.3
- Low: 0.1
- Each rule has an assigned a Rule Weight, calculated based on the Severity Level:
[Severity Value] of Rule / SUM of [Severity Value] for all Rules in the same Group (PA or OM)
The following table lists the available business rule attributes for employee objects, and how to correct identified issues.
|
Rule Name |
Group |
Severity (Value) |
How to Correct |
|---|---|---|---|
|
Employees without Positions |
PA |
High (0.50) |
Check if the employee has an active position assigned. |
|
Employees with Multiple Positions |
PA |
High (0.50) |
Check if the employee has multiple active positions assigned. |
|
Employees without Nationality |
PA |
High (0.50) |
Check if the employee has a nationality maintained. |
|
Employees without Location |
PA |
Low (0.10) |
Check if the employee has a location maintained. |
|
Employees without Contact Details |
PA |
Low (0.10) |
Check if the employee has at least one contact field (email, telephone or mobile) maintained. |
|
Employees below 18 years old or above 70 years old |
PA |
Medium (0.30) |
Check if the employee has a birth date prior or equal to December 31st, 70 years ago, or greater or equal to January 1st, 18 years ago. |
|
Employees without FTE |
PA |
Medium (0.30) |
Check if the employee has FTE maintained. |
|
Employees without Ethnicity |
PA |
Medium (0.30) |
Check if the employee has their ethnicity maintained. |
|
Employees without Communication Language |
PA |
Low (0.10) |
Check if the employee has a preferred native language maintained. |
|
Employees without Salary |
PA |
High (0.50) |
Check if the employee has their salary maintained for the type AnnualizedSalary. |
|
Employees without Performance Rating |
PA |
Medium (0.3) |
Check if the employee has a Performance rating maintained. |
|
Employees without Potential Rating |
PA |
Medium (0.30) |
Check if the employee has a Potential Rating maintained. |
|
Employees without Risk of Loss Rating |
PA |
Medium (0.30) |
Check if the employee has a Risk of Loss rating maintained. |
|
Employees without Hire Date |
PA |
High (0.50) |
Check if the employee has an employment hire record maintained. |
|
Terminated Employees without Termination Date |
PA |
High (0.50) |
Check if the employee has an employment termination record maintained. |
|
Employees without Job |
PA |
Low (0.10) |
Check if the employee's position has a job maintained. |
|
Employees without Gender |
PA |
High (0.50) |
Check if the employee has their gender maintained. |
|
Employees without Cost Center |
PA |
Medium (0.30) |
Check if the employee's position has a Cost Center assigned. |
|
Employees with invalid Salary Currency |
PA |
High (0.50) |
Check if the employee salary currency and exchange rate are maintained. |
|
Duplicate Employees |
PA |
High (0.50) |
There are duplicate employees with different Employee IDs but with the same first name, last name, and date of birth. Delete the duplicate employee record. |
|
Part-time Employees with Employee FTE more than or equals 1 |
PA |
Low (0.10) |
Check the employee FTE. |
|
Full-time Employees with Employee FTE less than 1 |
PA |
Low (0.10) |
Check the employee FTE. |
|
Employees without Hours per Week |
PA |
Low (0.10) |
Check if the employee has Hours per Week maintained. |
|
Employees without Org Unit |
PA |
Medium (0.30) |
Check if the employee's position has an org unit assigned. Note: Only used in OOSP structures. |
|
Employees without Personnel Area/Subarea |
PA |
Medium (0.30) |
Check if the employee has their Personnel Area/Subarea maintained. Note: Only used in OOSP structures. |
|
Employees with conflicting Personnel Area/Subarea |
PA |
Medium (0.30) |
Check if the employee and its assigned position have different Personnel Area/Subarea maintained. Note: Only used in OOSP structures. |
The following table lists the available business rule attributes for position objects, and how to correct identified issues.
|
Rule Name |
Group |
Severity (Value) |
How to Correct |
|---|---|---|---|
|
Unoccupied positions |
OM |
High (0.50) |
Check if the position has an active employee assigned. |
|
Positions with multiple employees |
OM |
Medium (0.30) |
Check if the position has multiple active employees assigned. |
|
Positions with inactive employees |
OM |
High (0.50) |
Check if the position has inactive employees assigned. |
|
Positions without Manager |
OM |
High (0.50) |
Check if the position has a parent position assigned. Note: Only used in SSP structures. |
|
Positions without location |
OM |
Low (0.1) |
Check if the position has its location maintained. |
|
Positions without jobs |
OM |
Low (0.1) |
Check if the position has a job assigned. |
|
Positions without name |
OM |
Medium (0.30) |
Check if the position has a name maintained. |
|
Positions without Legal Entity |
OM |
Medium (0.30) |
Check if the position has a legal entity assigned. Note: Only used in SSP structures. |
|
Positions without Business Unit |
OM |
Medium (0.30) |
Check if the position has a business unit assigned. Note: Only used in SSP structures. |
|
Positions without Division |
OM |
Medium (0.30) |
Check if the position has a division assigned. Note: Only used in SSP structures. |
|
Positions without Department |
OM |
Medium (0.30) |
Check if the position has a department assigned. Note: Only used in SSP structures. |
|
Positions without Cost Center |
OM |
Medium (0.30) |
Check if the position has a cost center assigned. |
|
Positions without Pay Grade |
OM |
High (0.50) |
Check if the position has a pay grade maintained. |
|
Positions without Salary Scale |
OM |
High (0.50) |
Check if the position has a salary scale maintained. |
|
Positions without Hours per Week |
OM |
Low (0.10) |
Check if the position has Hours per Week maintained. Note: Only used in SSP structures. |
|
Positions without FTE |
OM |
Low (0.10) |
Check if the position has FTE maintained. Note: Only used in SSP structures. |
|
Positions with the same Solid and Matrix reporting line |
OM |
Low (0.10) |
The position has a direct and indirect reporting line to the same position. Check the position's direct and indirect reporting line, and delete the duplicate reporting line. Note: Only used in SSP structures. |
|
Positions without Org Unit |
OM |
Medium (0.30) |
Check if the position has an org unit assigned. Note: Only used in OOSP structures. |
|
Positions without Employee Group/Subgroup |
OM |
Medium (0.30) |
Check if the position has an Employee Group/Subgroup maintained. Note: Only used in OOSP structures. |
|
Positions without Personnel Area/Subarea |
OM |
Medium (0.30) |
Check if the position has the Personnel Area/Subarea maintained. Note: Only used in OOSP structures. |
The following table lists the available business rule attributes for org unit objects, and how to correct identified issues.
|
Rule Name |
Group |
Severity (Value) |
How to Correct |
|---|---|---|---|
|
Org Units without Company Code |
OM |
Medium (0.30) |
Check if the org unit has a Company Code maintained. Note: Only used in OOSP structures. |
|
Org Units without Parent Org Unit |
OM |
Medium (0.30) |
Check if the org unit has a parent org unit assigned. Note: Only used in OOSP structures. |
|
Org Units without Cost Center |
OM |
Medium (0.30) |
Check if the org unit has a Cost Center maintained. Note: Only used in OOSP structures. |
|
Org Units without Business Area |
OM |
Low (0.10) |
Check if the org unit has a Business Area maintained. Note: Only used in OOSP structures. |
|
Org Units without Personnel Area/Subarea |
OM |
Low (0.10) |
Check if the org unit has a Personnel Area/Subarea maintained. Note: Only used in OOSP structures. |
|
Org Units without Location |
OM |
Low (0.10) |
Check if the org unit has a location maintained. Note: Only used in OOSP structures. |
|
Org Units without direct Manager |
OM |
Medium (0.30) |
Check if the org unit has a direct manager assigned. Note: Only used in OOSP structures. |
|
Org Units with multiple Managers |
OM |
Medium (0.30) |
Check if the org unit has multiple manager assignments. Note: Only used in OOSP structures. |
These dashboards also provide Data Quality trends, analytics, charts, error, and record details (e.g., country and company) and recommended actions to resolve the data errors and/or inconsistencies.
Note: Contact Nakisa to configure the business rule attributes and to set the URL for your ERP or correction tool.
See also:
|
Nakisa Advanced Analytics 2022.R2-SP1 © 2023
|
Nakisa Inc. All rights reserved worldwide. |