LEARNING OBJECTIVES:
The specification states - you should be able to:
understand the purpose of the following data validation methods: check digits; and batch totals (hash and control);
Some information systems process data that is entered into them in batches from documents. These systems typically use batch processing.
Transactions are grouped until a sufficient quantity is available
or until a particular time is reached/over a period of time.
All transactions in a batch undergo the same processing.
Processing takes place at an off peak period/night.
No human intervention is required.
When data is entered in batches there are two extra types of error that may occur:
A document may be accidentally missed out.
The data on a document is entered twice.
Batch totals are used when data is entered in batches to identify if one of these types of error occurs. These can be hash totals or control totals.
Before the information on the documents is entered the user counts how many documents there are.
After the data has been entered the total that was manually calculated is compared to the computer generated total.
If the two differ then a document has been missed or some data has been entered twice.
Hash totals are more sophisticated than batch totals.
They can be used to spot missed out or doubly entered documents
and can also spot more complex errors such as one document being entered twice at the same time as another is missed out.
A particular field on the batch of documents is chosen. e.g. Hours Worked, Employee Number, Invoice number.
A hash total it is used purely for error checking. The total itself has no meaning.
This number will be added for all documents manually.
The hash total becomes part of batch.
It is automatically recalculated post processing.
The calculated value is compared with the original value.
If the values are different then an error has occurred.
Control total has the same process as the Hash Total, however, a more meaningful field is chosen for the calculation.
This total is meaningful and useful e.g. the total cost of all the invoices in the batch.
Example: VAT, Total