QA Checks Feedback

[rhi-batstone]

PAMs

• Population estimates change max from 43000 to 46000
• Nature of population change:
  - Columns 2 and 3 – change min from 22000 to 25000
  - Population change – change min from -5500 to -8000
  - Births – change min from 1500 to 12000 and change max from 510000 to 520000
  - Deaths - change min from 2400 to 2200 and change max from 600000 to 620000
  - Natural change - change min from 2400 to 2200 and change max from 600000 to 620000
  - Net migration - change min from -650 to -2000 and change max from 190000 to 210000
• Migration – change max from 100000 to 120000.
• Net migration - change min from -2500 to -3000 and change max from 17500 to 20000
• Net migration rates - change min from -6.5 to -8 and change max from 17.5 to 20

Vital Events

• Maximum percentage for leading cause of death is a bit low. Maybe a better one would be to check that the sum of the 5 percentages doesn’t equal 100% (it shouldn’t as we only include the top 5).

Households

Proposed checks

Dataset	Checks	Threshold Min	Threshold Max
Household Estimates	1. household estimates < correspondent dwelling estimates 2. Scotland value = sum of councils	8300 (the 2001 value)	101% of last year value for Scotland (= 2,495,623 for 2019)
Dwellings Estimates	Scotland value = sum of councils	9000 (the 2001 value)	102% of last year value for Scotland (= 2,636,871 for 2019
dwellings-by-type*	sum (number) [by Council] = sum (dwellings-by-council-tax-band $number) [by Council]
dwellings-by-council-tax-band		0	23% of last year total value for Scotland ( = 2,645,950 for 2019)
Household projections	1. total (1 adult 1 child, 1 adult 2+ children, 1 person female, 1 person male, 2 person all adult, 2+ adult 1+ children, 3+ person all adult) = All households 2. non-heads + all households = population projection value for that age-class and area	0

* At the moment data on type of dwellings are not available so the last published are the 2017 data.

• Re to the dwellings_by_type dataset: it includes the total by council that we removed from the dwellings-by-council-tax-band table. Do we need it?
• Re the household projections: In the data we provided there are still the non-heads category, do you use it? We do not publish these values anywhere.