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