# Presentation: 949613

## Module 21: Data Quality

**Where did all that erroneous data come from?**

## This Session will cover..

- Some examples of possible data errors and  how to research cause
- All data has defects!
- Explaining data

## Data Quality in CISSources of Data Errors

- Original data entry within PRMS, TCAS, FFIS, iCAMS
- Calculations of numbers from original geographic area to another
- Some data errors are obvious and quickly identified.
- Other data errors are masked, particularly nationally, and are only identified  through careful examination and geospatial disintegration.

## Can that be right?

**Can that be right?**

- In South Dakota?

## Can that be right?

**Can that be right?**

- Yes only if SD employee(s) provided Field Assistance
- Training

## Example: WI questions CT charge?

- In South Dakota?

## Are the charges legitimate?

- In South Dakota?

- Yes only if CT employee(s) provided Field Assistance to Clark County
- No if CT attended training activity in Clark County
- NO if employee transferred from CT to WI but iCAMS duty Station was not updated by HR

## Determine when the charges began?

- 0 hours charged thru December

## Charges started in January?

- 48 hours charged thru January

## Charges Continued thru March?

- 98 hours charged thru January -March

## How de we correct the problem?

- If CT employee(s) provided Field Assistance to Clark County then no action is needed
- If CT attended training activity in Clark County then corrected T&A should be submitted by timekeeper
- If iCAMS duty Station was not updated by HR soon enough then corrected T&A should be submitted by timekeeper
- Will FFIS be correct? Depends on explanation

## Will FFIS be correct?

- If employee provided assistance to Clark County then States decide who is charged for time.
- If CT transferred employee then most likely appropriation and state charged in employee master record was updated and FFIS is correct even though CIS will be wrong

## Do a corrected T&A with correct State and County?

**Do a corrected T&A with correct State and County?**

- Change state and county

## Report Accurate or Bad input?

**Report Accurate or Bad input?**

## How can I be seeing data for an non-existing office?

**Notes:**
It is true the office does not exist today. I may have existed as a planned office and subsequently deleted. Lets look..

## OIP Agrees that this office does not exist?

**Notes:**
It is true the office does not exist today. I may have existed as a planned office and subsequently deleted. Lets look..

## iCAMS Employee Directory shows “101995” is CLOSED

- Note “P” for Planned office

- 2 employees are still assigned to closed office

## OIP Shows Active Office is “66427”

- Closed and moved to 66427

**Notes:**
Office 101995 was probably closed or plans changed.

## What do we see for charges in Dec?

**What do we see for charges in July?**

**What do we see for charges in August?**

## What the Solution?

- Step 1 fix duty station office id’s in iCAMS for employees with wrong office information

## What the Solution?

- Step 2 is to do corrected T&A

- Data feed from iCAMS

## Data Quality Examples –Negative  soil savings for Illinois

**Data Quality Examples –****Negative  soil savings for Illinois**

## Often only one error can bias entire State

- Most of the data error is within a single county, McLean County, Illinois.

**Often only one error can bias entire State**

## Now the Search begins

- PRMS Data Quality tool (View Prior Entries) finds records for McLean County, Illinois, there are 172 records.
- Further analysis narrows error to 1st Quarter

## Success- the offending record is found.

-  648 Tons/Acre/Year wind soil erosion loss after practice/system application