S2xDE Software Data Entry System - Database Schema and Table Structure (Part 1)

by Ruben 6/28/2008 11:00:00 PM

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

Related posts

Add comment


(Will show your Gravatar icon)  

  Country flag

[b][/b] - [i][/i] - [u][/u]- [quote][/quote]



Live preview

9/7/2008 5:26:46 AM

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.