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.