IM 443 Edit Checks

Sample Field Edit Checks

1. Check Digit 2. Completeness Check 3. Default Value 4. Field or mode check 5. Range Check 6. Limit Check 7. Validity Check

Key Verification

A first data entry clerk enters the data and a second entry clerk reenters the same data. The computer compares the data entered on the second keying operation with the original data and highlights any differences. The second clerk verifies and corrects any differences.

Referential integrity

A safeguard to ensure that every posted foreign key attribute relates to a primary key attribute

Sample Batch Edit Check

Checks an entire batch of events or transactions

Validity Check

Compares entered data against pre-specified data stored within the computer.

Range Check

Compares entered data to a predetermined acceptable upper AND lower limit

Limit Check

Compares entered data to a predetermined upper OR lower limit

Sample Record Edit Checks

Examines an entire record, generally a record in the file being updated by business event data.

Valid Sign Check

Highlights illogical balances in a master file record. For instance you can't have negative inventory

Default Value

Sets a field contents to a pre-specified value.

Financial/numeric control total

The sum of a financial field, such as the invoice amount, of all records in a batch

Hash Control Total

The sum of an attribute in a file that has no real meaning or use

Record Control Total

Total of the number of records in a batch

Batch Control Totals

Used to verify that all transactions within a bath are present and have been processed

Closed-loop verification

Uses and input data item to locate the record to be updated, then displaying other data about the record so the data entry person can verify the correctness of the record.

Completeness Check

Verifies that all critical field data are entered. It checks for missing data or blanks

Transaction type check

Verifies that all transactions included within the batch are of the same category or type

Field or Mode Check

Verifies that the entered data type is the appropriate mode for a field

Sequence check

Verifies that the records in a batch are sorted in the proper sequence

Reasonableness check

Verifies whether the amount of a new transaction record appears reasonable when compared to other elements associated with each item being processed

Process controls

Verify that the input data are properly recorded in the database and any balances maintained within the system are properly updated

Edit Checks

can be incorporated into computer instructions to verify and validate the completeness, reasonableness, and/or accuracy of data

Master reference check

verifies that an event/transaction record has a corresponding mast record to be updated