Re: Verifying data entered by re-punching

Your punch/verify operation could be accomplished on a single form, with some special PL/SQL coding. The form could be used to insert new records repeatedly, or to look up the same record once the second entry by the verification operator had been entered.

The first pass would insert the data into a table, the second verification pass would retrieve the original record from the table and compare every item entered. You could put a checkbox on the form to indicate which mode (insert or verify) it was running in.

But backing up, the two-person "punch/verify" system is pretty labor intensive -- you have someone spending time to fill out a form, and then two people to read the form and enter it into the computer. I think most places try to move the data entry point to the information source, completely bypassing the paper form and the punch/verify steps. But maybe your system wouldn't accommodate that.

In article <36475228.70D16941_at_honlab.nmfs.hawaii.edu>,   "Janet L. Pappas" <jpappas_at_honlab.nmfs.hawaii.edu> wrote:
> Our current (non-Oracle) data entry system is "punch/verify": one clerk
> initially enters a record and then a second clerk (at a later date)
> re-enters the same record. If the records agree, then the data is
> entered in the database. If there is a discrepancy, the second clerk
> corrects the record and then it is entered in the database. What would
> be the best way to implement this same system in Oracle Forms? Any
> suggestions would be greatly appreciated.
>
> jpappas_at_honlab.nmfs.hawaii.edu
>
>

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Thu Nov 12 1998 - 18:24:26 CET