How can a data reconciliation check be carried out?
Data at previous investigation + business come onto the books - business gone off the books = data at current investigation
Data that can be checked for non-unitised business
Data that can be checked for unitised business
Checks should be made for unusual values such as
Examples of consistency checks that can be done
Examples of Spot checks / unusual values
Look for anomalies like:
Zero or very large unit values
Impossible dates (birth, retirement, start)
Clustering of birth months