Validation Rules for Data Validation Report

You can add validation rules to the Data Validation Report to identify missing data required to run a process or report. You can run the report and make relevant corrections to complete the employer or payroll-related data.

Use the Extract Definitions task in the Data Exchange area in My Client Groups on the Home page, to add a validation rule to the Data Validation Report extract definition.

Rule Formula

Use the delivered formula 'Global Attribute Mandatory Check' to set up validations to identify missing data. You add the validations to the Data Validation Report extract definition.

This formula includes certain important enhancements such as supporting translated messages. It also offers the ability to control the validations without you deleting the validation already configured by you or delivered by Oracle. It's not mandatory for you to migrate your existing validations from the 'Global Null Check Rule' formula to the new one. Oracle recommends migrating to the new formula to make use of the benefits.

Validation Levels

This table describes the validation rules at the various levels.

Validation Level	Description
Employee	Add simple validations for a missing attribute at the worker level. For example, if the National Identifier value is missing for a worker.
Organization	Add simple validations for a missing attribute at the organization level. For example, a missing Tax Reporting Registration Number.
Repeating Child Entity of a Worker	Add validations at the repeating child entity of a worker. For example, you may add a validation for a missing IBAN number for one of the multiple payment methods that a worker has. You can add a validation to specify the details of the attribute value (IBAN Number). This attribute value is missing for the Entity Type (Personal Payment Method) and for the Entity Name (Personal Payment Method Name).
Repeating Child Entity of the Organization	Add validations at the repeating child entity of an organization. For example, add a validation for a missing SWIFT Code for one of the multiple organization payment methods that's valid for a payroll statutory unit. You can add a validation to specify the details of the attribute value (SWIFT Code). This attribute value is missing for the Entity Type (Organization Payment Method) and for the Entity Name (Organization Payment Method Name).

Data Groups

The data group you select when adding validation rules to the Data Validation Report determines the level of validation. For example, you might have a validation rule at the tax reporting unit level or at the worker details level.

The processes associated with the Data Validation Report extract definition are:

Run Payroll Data Validation Report
Run Worker Data Validation Report
Data Validation Report for Payroll Interface

These reports use different data groups to report data validation. You must select a data group for any validation rules you add based on the type of data and the level you want the validation to occur.

Payroll Data Validation Report

Add validation rules to these data groups to report payroll-related data validation:

Payroll Statutory Units
Tax Reporting Units
Payroll Relationships
Payroll Assignments

Worker Data Validation Report

Add validation rules to these data groups to report worker-related data validation:

Payroll Statutory Units
Legal Employers
Reporting Establishments
Work Relationships
Person Details
Assignments

Data Validation Report for Payroll Interface

Add validation rules to these data groups to report worker-related and payroll-related data validation for Global Payroll Interface:

Payroll Group
Payroll Relationship Group
Work Relationships
Assignments
Payroll Relationships
Payroll Assignments

Usage of Tags

The report output has different sections for legal employer, reporting establishment, person, and so on. The validations reported in the different sections is based on the tag that's added for rule data element. Consider these conditions while using tags for adding validation rules for Data Validation Report.

For reporting validations at organization level, add the validations to Organization Data Groups and the related tags, as given in the table here.

Validation Level	Data Group	Tag
Legal Employer	Legal Employers	`LEMP_RULE_TEXT`
Establishment	Reporting Establishments	`REP_EST_RULE_TEXT`
Payroll Statutory Unit	Payroll Statutory Units	`PSU_RULE_TEXT`
Tax Reporting Unit	Tax Reporting Units	`TRU_RULE_TEXT`

For reporting validations at worker level, add the validations to the corresponding data group and the predefined tags as given in the table here.

Validation Level	Data Group	Tag
Employee or payroll relationship level validations	Identify appropriate data groups (Example: Assignment).	`RULE_TEXT`

For reporting organization validations or the validations of other entities in a separate table, add the validations to the corresponding data group and the predefined tags as given here.

Validation Level	Data Group	Tag
All levels other than employee or organization	Identify appropriate data groups (Example: Assignment).	`OTHERS_RULE_TEXT`