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


You have already a visual idea of s2xde database schema and table structure, on my next post we proceed Batching module.


Previous Post of S2xDE Software

S2xDE Software Database Schema
    1) RES-1900
    2) RES-ADC
    3) RES-EFX
    4) RES-MAP
    5) RES-TRACKING
    6) S2xDE

S2xDE Software Production Monitoring or Tracking
    - All activity task code are monitored by the Task Code
    BA     Batching
    E1     Entry 1
    E2     Entry 2
    CO    Compare
    RE     Research
    QC    QC Sampling
    ED     Edit
    CV    Conversion

- All task are auto queuing its important to keep track batches by storing the information. See screenshot of RES-Tracking schema.



Batch Table


Monitoring Table


Pending Table


Audit Trail Table


Document Count Table


Accuracy Table

to be continue on next post of data entry system...

Previous Post of S2xDE Software