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, the batch is queued containing a pre-defined number of documents. Normally, a batch for specific project will contain between 10 to 50 documents or many, it depends on the project data conversion.

Data Entry System - User Input
File Pattern     - the extension of image file (*.tif)
Client Code      - unique id for client (FA)
Project Name  - client code plus unique id for project name (FA CL 1900)
Batch Code      - unique id for project name plus the county code (CL19AR59)
No. of Docs      - any number
Explorer View  - control to navigate the image location
Fileview           - display the folder or image file during navigation of explorer view control.
                        - user should be highlight selected file image or folder in fileview control
                          to process during the batching.

Batch Number = contain Batch Code plus incremental value of record stored in Batch Header database (dbo.batch_hdr).

During batching process the system create a template record of document in the database table Entry 1 (dbo.e1) and Entry 2 (dbo.e2) and other related table (dbo.e1.bbd_names, dbo.e1.sgp_names) for production use. After the batches done in batching process will automatically available for production entry (E1 & E2) based on a project code. (screen shot below are the template table to be used in data entry).

Batch Header

Batch Detailed

Entry 1 Main Table

Borrower Names (Sub-Table)

Seller Names (Sub-Table)

to be continue... Next post will be the design view & code behind of Batching Module.

Previous post of S2xDE Software Data Entry System

Table Structure of RES-1900 Project

Every Task processed in production group have a table repository:
ex: [E1] Entry 1
     dbo.e1_hdr
        -> batch header that contains batch no, user id, date issue, number of docs, number of record, number of character.
     dbo.e1
        -> main record captured on the documents.
     dbo.e1_bbd_names
        -> (sub-record) in one document are allowed four record of borrower names to be captured.
     dbo.e1_sgp_names
        -> (sub-record) in one document are allowed two record of seller names to be captured.

Batch Header Table


Entry 1 Main Table


Entry 1 sub table - borrower names


Entry 1 sub table - seller names


Visual idea of s2xde database schema and table structure, on my next post we proceed Batching module.


Previous Post of S2xDE Software