Related Topics   

WESPaC Data Validation

Contents

1 Overview

2 Validation Exception Report

3 How-to

4 Fields

5 Exception Messages

1 Overview

The WESPaC Data Validation process has various edit checks to validate data in Salary Negotiations plans. WSIPC has written the Data Validation process as a stand-alone utility as well as building it into other Salary Negotiations reports (Mix Factor Report, S-275 Report, and SPI Salary Exhibit Reports) so that it always runs when those reports are requested.  This automatic run of DV processing is designed to ensure the highest possible data integrity on state reports.

 

When run as a stand-alone utility, the user is able to select which of the three state reports (Mix Factor, S-275, and/or SPI Salary Exhibit) to edit for, and may choose to have exception messages printed by Employee Name or by Exception Message.  When run automatically as part of a state report, DV displays edits for that report only and exception messages are printed in Employee Name order.

 

An exception report is created, identifying whether the exception is an error, warning, or not applicable for the report(s) being edited against. Issues found by the validation process should be reviewed and fixed as needed before creating final reports.

 

Best Practice Strategies for WESPaC Data Validation

Step

Report Process

Purpose

1

Audit Assignment Salaries

Compare the calculated information to what displays on the assignment screen.

 Path: Human Resources / Salary Negotiations / Calculate / Audit Assignment Salaries

2

Generate Plan Detail

Calculate pay and benefit amounts for each assignment record in a given plan.

Path: Human Resources / Salary Negotiations / Calculate / Generate Plan Detail

3

WESPaC Data Validation

This step is optional.  WESPaC Data Validation will now run whenever any WESPaC Salary Negotiations Report is called.

 

Print Data Validation Exception Report from selected plans, for selected reports. Data issues found by the validation process need to be reviewed and fixed before finalizing the related WESPaC Salary Negotiations Report.

 Path: Human Resources / Salary Negotiations / / Salary Negotiations/ WESPaC Reports/ WESPaC Data Validation

4

Create any of the WESPaC Salary Negotiations reports

Mix Factor Report

Print Mix Factor Reports from selected plans.

Path: Human Resources / Salary Negotiations / / Salary Negotiations / WESPaC Reports / Mix Factor Report

S-275 Report

Run edit for S-275 data, print the S-275 Report, and create a transmittal file from a selected plan.

Path: Human Resources / Salary Negotiations / / Salary Negotiations / WESPaC Reports / S-275 Report

SPI Salary Exhibit Reports

Print SPI Salary Exhibit Reports and create an extract file from selected plans.

Path: Human Resources / Salary Negotiations / / Salary Negotiations / WESPaC Reports / SPI Salary Exhibit Reports

Page Updated 8/08

Top