Processing Controls And Data Validation

Several methods have been devised to control processing activities. Data records, for example, may be batched into small groups to control totals. In batch processing, if an error is detected, the batch that contains the error reviewed without disturbing the remaining batches of the file. If all con totals balance, the batch is accepted. If the batch balances but certain records are rejected, the batch may be held until the errors are correct

           In addition to batch controls, several other programmed checks can be used for testing the data:

   1. Completeness check ensures that all fields in a record are present and are read in the proper sequence. In a multiple-record check, the program verifies the self-checking number of the record(s) that make up transaction. If an error is detected, the entire group of records is rejected.

   2. Consistency check refers to the relevance of one type of data to another. For example, a retailer may have a policy of extending a 30 percent discount to religious leaders on all merchandise ordered and up $2,000 credit at no interest. An order-received rom a customer must checked against these provisions to ensure consistency with the specified policy.

  3. Reasonableness check evaluates a transaction against a standard determine whether it meets the test. For example, if the maximum w rate is $5 per hour and no overtime is allowed, an employee's wee gross pay of $210 would be unreasonable, since the limit is $200.

   4. Sequence check verifies that data records are in sequence prior processing. A check of duplicate records may also be incorporated in the routine.