CELLS Workflow MES Administrator Table examples


The administrator table examples in the figures below such as NEXT_STEP, DEFECTS, DOCUMENTS, etc. contain the instructions that the CELLS Workflow MES software uses to track and collect data on the products you build. The administrator tables contain the setup of routing, linked documents, defects, users, etc. The example database tables below are in Microsoft Access and are displayed in datasheet view. CELLS Workflow MES complies with Microsoft's ODBC database standard and therefore can be used with any ODBC compliant database such as Oracle, Microsoft SQL Server, etc. For help, contact Unisoft and we can go online with you.

The administrator tables can be populated 2 ways, either by directly editing the database tables or the preferred method for route building is to use the CELLS Route Builder module.

To create your own process routing for your products the CELLS Route Builder provides a quick natural way to populate the PROCESS, NEXT_STEP, OPERATIONS and CONDITIONS tables by using an Excel spreadsheet. These tables direct the CELLS Workflow MES software on how to route your products. With CELLS Route Builder you can enter data according to the flow of the process being described rather than entering data directly into these tables in a fragmented, out-of-order manner.


next-step-tracking



Administrator Tables

Assemblies Table

Conditions Table

Data Entry Table

Data Items Table

Defects Table

Documents Table

History Table

cells-table-history

Next Step Table

Operations Table

Operation Defects Table

cells-table-operation-defect

Processes Table

cells-table-process

Stations Table

Sub Assembly Table

Users Table

cells-table-users

User Operations Table

cells-table-user-operation

Work in Progress (WIP) Table

Work Orders Table


Contact our webmaster (enable JavaScript for the email address) with questions or comments about this web site.

Web Consulting by Dorene Matney
© 2024, Unisoft