Tools and Software for Data Validation

States and grantees can use these tools to validate data. The ETA software can also be used to generate the aggregate information required in reports submitted to ETA. States and grantees that use the software provided by ETA to generate this aggregate information will not be required to perform report validation.

February 8, 2008:
In accordance with the Paperwork Reduction Act, OMB has approved without change the Employment and Training Data Validation requirement through February 28, 2011.

Workforce Investment Act  Trade Adjustment Assistance  National Farmworker Jobs Program

	In This Section
Version 7.0 WIA DRVS 7.0 What's New DRVS 7.0 DRVS 7.0 WIA Handbook DRVS 7.0 LX User Guide Instruction to Upgrade DRVS 6.3 to 7.0 Script DRVS 6.3 to 7.0 Upgrade Script Version 2.0 NFJP NFJP Software NFJP User's Handbook Whats new with NFJP Patch WIA 6.3 DRVS 6.3 Upgrade Patch DRVS 6.3 Current Qtr Retention patch Instructions for applying DRVS 6.3 Upgrade patch Instructions for applying DRVS 6.3 Current Qtr Retention patch Version 6.3 WIA DRVS 6.3 What's New DRVS 6.3. DRVS 6.3 WIA User Guide DRVS 6.3 LX User Guide SQL Files Version 6.2.1.8 WIA DRVS 6.2.1.8 What's New DRVS 6.2. DRVS WIA User Guide DRVS LX User Guide Version 6.1.5.4 WIA DRVS 6.1.5.4 Applying WIASRD Patch DRVS WIA User Guide DRVS LX User Guide Sp WIASRD Export WIASRD General Instruction Version 6.1 DRVS 6.1 Version 6.0 WIA WIA-LX_DRVS6.0 Software Whats New with DRVS DRVS WIA User guide DRVS LX Userguide Version 2.0 TAA TAA Software TAA User's Guide Version 1.3 TAA TAA Software TAA User's Guide TAA Instruction Version 1.2 NFJP NFJP Software NFJP Software - Windows 98 NFJP User's Guide

What's New

in Data Validation as of 10/22/07

What's New for the Upgrade DRVS 6.3 to 7.0 Script

• The script can upgrade a prior DRVS 6.3 database to version 7.0 functionality so that states can finalize and submit their PY05 Data Element Validation results.  Please make sure to follow the upgrade instructions in order to avoid losing your data.
• The script upgrades the most recent DRVS 7.0 release to enable reporting for the first quarterly report for PY07.
• The script corrects the 90-day duplicate detection rule to only apply to records with Dates of Exit on or after 7/1/2006 or blank.
• The script also corrects the PY06 Table K public assistance calculations for the Diploma and Retention Rates.

DRVS Version 7.0

•  Implements functionality for calculating the PY06 ETA 9091 Annual Report (including Table O results), for performing PY06 Report Validation, and for submitting results to ETA
•  Implements functionality for performing PY06 Data Element Validation and submitting results to ETA
•  Corrects previously reported Literacy-Numeracy calculation issues related to same date post-tests or missing pre-test dates
•  Provides the ability to export the DEV worksheet summary for each funding stream to a .txt file (described on pages 85-86 of the User Handbook). To display in comma-delimited format, open these files through the excel application and select “delimited,” click next, and then select “comma.”
•  Adds lines separating data elements on the printed validation worksheets

Important Note: DRVS 7.0 is designed for PY06 reporting and validation. DRVS 7.0 is NOT for use in completing PY05 data element validation and should NOT be installed on computers housing PY05 DEV results. An upgrade script for completing PY05 data element validation will be forthcoming.

States are advised to use separate computers for PY05 data element validation and PY06 reporting. To prevent states from losing PY05 databases created in DRVS versions 6.2 or 6.3, the installation default for DRVS 7.0 is set to “I DO NOT want to create a DRVS database.” When installing DRVS 7.0 on a new computer, states should create a new database by selecting “I want to create a DRVS database” (see page 19 of the User Handbook). Failure to follow these steps could cause states to lose their PY05 sample and validation results created in version 6.2 or 6.3.

NFJP Data Validation Software Version 2.0 Update

• An updated NFJP User's Guide that updates the acceptable federal source documentation listed in Appendix C.  The prior version accidentally excluded some acceptable source documentation.  The new version includes all source documentation from last year.  States should copy this document and put it in C:\program files\NFJP\docs folder so that they can access it from Help menu.
• An updated NFJP.exe for NFJP Data Validation Software version 2.0 is now available. This updated NFJP.exe file implements valid value edit checks for only those key elements that need to be validated or are important for validation, thus solving the problem that some grantee files are not able to import properly due to too many invalid values. It also fixes edit check B for the Exit Category field

Important Note: Grantees should first install NFJP2.0_Setup.exe (released 4/30/07) if they haven't done so, then replace the old NFJP.exe in C:\Program Files\NFJP (or in whatever location grantees chose to install the software) with this updated executable. The new executable is in addition to the installation so that the installation should not be removed. Open the application and follow the instructions in the NFJP user handbook to import files and conduct data validation. Please contact NFJPTA@mathematica-mpr.com for any technical assistance questions.

NFJP Data Validation Software Version 2.0 is now available. NFJP grantees can use version 2.0 with the PY 2006 Quarter 3 WIASPR to conduct data element validation for PY 2005 exiters, and to analyze exiter performance.

DRVS Version 6.3 Upgrade Patch

DRVS Version 6.3 incorporates the basic functionality for conducting WIA data element validation. These include:

WIA:

• Implements the new PY06 Average Earnings measure for adults, dislocated workers, and NEGs
• Implements the new performance outcome groups for Entered Employment, Retention, and Earnings for adults, dislocated workers, and NEGs corresponding to the change in the earnings measure
• Calculates Literacy-Numeracy results
• Provides the Dislocated Worker Sample Report functionality that was not operational in version 6.2
• Provides enhancements to version 6.2 printed validation worksheets and sample reports
• Sub-Sample Reports (although displayed in the Data Element Validation Sub-Sample menu) are not operational

LX:

• Implements the new PY06 Average Earnings measure on the 9002 C and D and VETS 200 reports, and the new performance outcome groups corresponding to the change in the earnings measure
• Corrects the 9002D Entered Employment Following Staff-Assisted Services numerator, denominator, and rate to exclude self-service exiters who are veterans from the calculation

Important Notes:

States that used DRVS 6.2 to draw their WIA data element validation sample can upgrade to DRVS 6.3 without losing the sample by following the steps listed below. Failure to follow these steps could cause states to lose their sample and sample results. States would then have to draw a new sample and re-start the validation process. This patch is only intended to upgrade the WIA sample database. It does not upgrade LX databases, and it does not upgrade all the calculations for the WIA Annual report.

DRVS Version 6.2.1.8 is now available for download with the following key improvements:

• Sampling records for each of the five funding groups (adults, dislocated workers, NEGs, older youth, and younger youth). Samples may be drawn by record, office, or WIB.
• Validation worksheets by funding group for each record sampled, and the ability to print validation worksheets individually or by funding stream.
• The ability to export and validate sub-samples by WIB or office for each funding group.
• Sub-sample reports for all funding groups except dislocated workers.

In addition, the WIA Validation Handbook and DRVS User Guide have been consolidated into a single DRVS User Handbook, so states only need one reference document to conduct validation.

ETA has redesigned the WIA DEV sampling algorithms to make the samples more efficient and to provide more precise estimates of error for specific data elements. These features are described in the 6.2 DRVS User Handbook.

Important Notes:

• States should create backup databases for information stored in DRVS 6.1 prior to installing the new version of the software. Instructions for creating databases can be found in the Database Management section of the User Handbook.
• DRVS 6.2 does not calculate the new PY 2006 WIA and LX Average Earnings measure. This and other enhancements will be incorporated into DRVS 6.3, scheduled for release in early November. States may use DRVS 6.1 to begin edit checking their PY 2006 quarter 1 files.
• DRVS 6.2 does not include any new Labor Exchange functionality.
• A future release will contain the ability to import sub-samples and to produce the Summary/Analytical Report, which will contain the error rate calculations.

DRVS Version 6.1.5.4 is now available for download with the following key improvements:

DRVS 6.1.5.4 is a maintenance release that completes functionalities that were not fully implemented in DRVS 6.1 and fixes several known errors. The new release may be downloaded from the ETA website and installed in place of the earlier version of DRVS 6.1. A separate patch is also available for states wanting to export the WIASRD file. The patch and instructions for applying it are also available on the web site. Questions regarding installing DRVS 6.1.5.4 or applying the patch should be directed to MPR at WIATA@mathematica-mpr.com or ESTA@mathematica-mpr.com.

Please read the document “Applying the WIASRD Patch” before installing the file: spwiasrdexport.sql. All technical assistance questions and requests for support should be directed to MPR at the emails listed above with copies to your Regional Performance Specialist and Traci DiMartini in the National office, dimartini.traci@dol.gov .

WIA

• Table O functionality is now fully operational.

• Adult and Dislocated Worker 12 Month Earnings calculation errors were fixed.

LX:

• Problems with edit checks associated with fields 75-77 have been fixed. The system will now allow 0.00, 000000, 000000.00, etc. as values to denote no wages.

• Modifications to ADO connection strings have been made to mitigate potential timeout issues when using functionality in DRVS 6.1.

 

DRVS Version 6.0 is now available for download with the following key improvements:

WIA

• The ability to calculate the WIA Annual Report (ETA 9091).
• A new edit has been added to the software that requires participants to have received at least one WIA service to be successfully imported.
• Duplicate Detection edit B and Edit check A for Category Of Assessment (WIASRD 701) are now operational.
• Edit check B for Type of Recognized Credential (WIASRD 619) has been deleted.
• Edit Check C for Date Goal #1 Was Set (WIASRD 621) and Edit A for Category of Assessment (WIASRD 601) have been added.
• The ability to filter reports on WIB Name, Office Name, Case Manager, and the two User Fields is now operational.
• The error report is now sorted by WIB, Office, and Case Manager.
• Reporting period for Literacy-Numeracy measure has been revised.
• The Older Youth 12-month Retention and Earnings Increase calculations are incorrect. This problem will be fixed in the next release.

LX

• Report Validation and Data Element functionality for LX has been added to the software.
• The ability to upload the validation results through the EBSS system has also been added to the software.
• Problems with the calculations associated with More Than One Race have been fixed.
• Client/server functionality has been added.
• The 9002E calculations have been fixed to States only include records within the applicable reporting period.

version 2.0 of the TAA Validation Software is now available. This software should be used to validate the TAPR records submitted for Fiscal Year 2006. The software has been updated to account for the following:

• The Record Layout has been revised to reflect TAPR changes for FY06.
• The software's edit checks have been updated to conform to the TAPR edits listed in ETA's edit checks.
• Performance Outcome Groups and the Performance Report have been revised to implement common measures.

Any questions should be about the software should be directed toTAATA@mathematica-mpr.com

Version 1.3 of the TAA Validation Software is now updated with the following improvements:

• The software provides the ability to e-submit the data validation summary/analytical reports through the EIMS website.The software allows users to easily create and backup database.The software reduces the number of elements that need to be validated as provided for in TEGL 3-03 change 1, attachment AThe software clearly identifies which records that have been completely validated.The summary of samples screen provides find functionality.
• Additional checkboxes have been added to the online worksheets to allow users to report when records are missing, cannot be located, are invalid, or have the wrong SSN.

Version 1.2 of the NFJP Data Validation Software is now available. Two versions of the installation are available.

• NFJPv1-2Setup.zip which can be installed on computers with Windows 2000 operating system or later, and
• NFJPv1-2SetupWin98.zip which can be installed on computers with Windows 98.

 

To view pdf files you need Acrobat reader.  

To view the pdf file as html  Go to Adobe's pdf-to-HTML conversion tool