Resolving Duplicate Records

1
Resolving Duplicate Records

• Ryan Murray
• DfES
• (ryan.murray_at_dfes.gsi.gov.uk)

2
Early Years Census

• Fuzzy matching forename, surname, middle
  name, DOB, gender etc
• Funded hours greater than 12.5
• User can choose
• within my LA only
• my LA plus neighbours
• all LAs

3
Alternative Provision PRUs

• Duplicate UPN check
• AND
• Fuzzy matching forename, surname, middle
  name, DOB, gender etc.
• User can choose
• within my LA only
• my LA plus neighbours
• all LAs

4
What to do

• LAs
• Run reports continuously
• Resolve internal duplicates
• Resolve external duplicates
• Amend data
• Submit data

5
Cross-blade Duplicates

• Pilot 2007
• Six possible checks
• DfES to run internally
• No action required!!!
• Full roll out 2008
• Discuss!

6
Other reports

• The COLLECT blades include other useful reports
• Year on year comparisons
• Summary reports
• Examples are provided in your packs