Data Entry System - Production Work Flow

 I - SOURCE DOCUMENT
  Receiving source documents for processing:
     • Downloading of images from FTP sites.
     • Downloading of images from client’s system.
     • Retrieving of images from specified websites.
     • Receipt of images through media such as DVDs, CDs and hard drives.
     • Receipt of paper documents via courier.

II - BATCHING
  A pre-defined number of documents to a batching unit including the link of images for production use. Instead of queuing document one at a time for process, a batch is queued containing the pre-defined number of documents to the production side for monitoring purposes. Normally, a batch for a specific project will contain between 10 to 50 documents. After the batches done in batching process will automatically available for data entry based on a project code.

III - DATA ENTRY (E1 & E2)
  Double entry process, known as E1 (Entry 1) & E2 (Entry 2).
E1 & E2 allow analysts to key required information onto fields as defined by the project.
Features include:
     • The image is automatic viewed by program, it also embedded the image manipulation using special key or combine keys into Textbox key event handler like zoom-in, zoom-out, scroll the image left, right, up, down etc.
     • On the fly validation rules on each field: This prevents users from keying an invalid data during entry.
     • Lookup and drop down tables for applicable fields.
     • The layout and sequence of the data entry fields are designed to simplify keying process.
     • The system not allowed user to key both E1 and E2 of the same batch.
     • Available batches for keying are queued and issued automatically by the system.

IV - COMPARE
  All completed batches after E1 and E2 are automatically available for the compare group.
     • The compare module will make a field by field comparison of all records for any mismatches between E1 and E2 using shortcut key (F7) and automatically the cursor focus on highlighted field then allow the comparer to resolve the differences.
     • The data entry system does not allow the comparer to continue to the next record if a mismatch remains on the current record.
     • After the comparer click the End Task button as a mark of finished, the data entry system automatically recompare the whole record to make it sure both E1 & E2 is completely they same. The data entry system not allowed to end task the batch if both E1 & E2 have discrepancy.
     • Once compare completed, a statistical report indicating the accuracy rating for both E1 and E2 at a field level is displayed and also create a log file where the field error located as a reference.

V - RESEARCH
     • Completed batches after compare, the data entry system will mark batch with research using the trigger field APN research equal to "Y" are automatically available for the Research group.
     • Research Data entry are disable the field does not required to modify to eliminate posible deletion or changes only the required field for research is enable during entry process.
     • The data entry systemautomatic skip the record w/out research during record navigation.

VI - Quality Control (QC)
  The final step for production is conducting a sampling QC rate on the records keyed to ensure that accuracy requirements are met.
     • At the early stages of a project, a 100% sampling rate is used to ensure that minimum accuracy level requirement is obtained. The rate reduced to a minimum of 10% in the long term.
     • Suggested sampling rate reduction from 100% to 75, 50, 25, and lastly 10%. Each reduction can be applied over several weeks or months depending on the progress of the quality of work.
     • QC also evaluates a comparer’s accuracy. This is done by comparing the QC output back to the Compare output for a quality report.
     • Batches for QC are queued and issued to the Quality Control Group. Errors found during QC are corrected on the spot.
     • Once completed, a statistical report indicating the accuracy rating for the comparer at a field level is displayed.
     • Only qualified analyst with a high degree of accuracy rating can be a member of the QC group.
     • A feedback report is made available to the comparer for discussion and updates.

VII - Edit (Validation)
Applied to all batches prior to final Output for transmission. Several log reports are generated depending on the project’s requirement. The objectives of validation are as follows:
     • Documents flagged for query and not resolved during production can be listed on the validation log report for resolution while waiting for client’s response. This is to eliminate waiting time by the production group for queries to be answered by client.
     • The data is validated against any set of rules and conditions, if conditions fails, create a log file on that record for verify.
     • Additional Validation rules are set at the beginning of a project. These rules are set in place and applied during validation to ensure that output data is in order and correct format. Most of these rules are already incorporated for all process but are included here for precautionary measures.

VIII - Final Output (conversion)
   Convert database data to an output format file as required by the project Output file format. Typical formats are:
     1.) Delimited Text File format
     2.) Flat File format
     3.) Spreadsheet format
     4.) XML File
     5.) other database platform

After conversion, log reports will be generated. These include record count, character count, and other information required during transmission.

FREE PDF BOOK DOWNLOAD

Recieved Updates



Enter your email address:

Delivered by FeedBurner

About the author

Name of author RUBEN CORRAL
System Developer in outSourcing company for almost 8 years. I built this blogs just for fun, sharing idea's, contribute a piece of code, especially to newbie programmers.

E-mail me Send mail

Calendar

<<  September 2008  >>
MoTuWeThFrSaSu
25262728293031
1234567
891011121314
15161718192021
22232425262728
293012345

View posts in large calendar

Disclaimer

The opinions expressed herein are my own personal point of view. Sample source codes are free to modify or enhance for your own satisfaction.

Sign in

All brand names, logos and trademarks in this site are property of their respective owners.