Hi all.
Yes, I suppose the title is not very clear. Let me explain my problem.
I want an app to map the processes in the company.
So I have type of process (core, support, management).
Then I have another table which is for macroprocesses. It belongs to the Type of Process table.
Then I have a table to processesโฆ it belongs to Macroprocesses table (because a Macroprocess can have several processes, but each process belongs to a single macroprocess)
Then SubProcesses Level 1 and SubProcesses Level 2.
The problem is that when I reach the Process Level, all the other levels below have the same fields.
Process Owner, Main Department, Version, Date Modified, subtable for Processes Inputs and another for Outputs, Diagram Image, subtable for Documents related to that process, etc.
It seems counter productive to have three tables (Processes, SubProcess L1 and SubProcessL2, all repeating some 20 different fields.
Is there anyway to have like 3 different fields for those Tables, and then the other 17 fields show below, seamlessly?
(ps, I guess I could have a single Process Table and then choose the Process Level instead of a table for each levelโฆ but I created different tables for this ownership relationโฆ a Process can have multiple subprocesses level 1โฆ a subprocess level 1 can have multiple subprocesses level 2โฆ)
I believe you may wish to mention the exact reason such as below you are seeking a solution for so that community could suggest a possible solution
One time creation of a large number of tables with an identical column structure
User experience in probably having to navigate to many similar views with different names
What are the differences between SubProcess Level 1 and Level 2? If itโs only the level itself to be different, then Iโd use the same table for both, and the Level is a column of the table (you can use Enum type for restricting the choices).
Regarding MacroProcesses, what are they? Are they simply a series of processes? In this case, you need one table for MacroProcesses and one for Processes. A column in Processes references MacroProcesses table. Are the 20 columns necessary for MacroProcess or should you inherit the columns of the Processes? If you can inherit them, you donโt need to define the columns in the MacroProcesses table.
As I mentioned, the problem arises at the Process Level, so no need to worry about macroprocesses. Macroprocesses work only as a logical agglomeration of processes. It is at Process Level that there are tons of parameters for each process, which would generate too many columns and thus make no sense to have two (or more) tables with all those repeated columns.
There are no differences between Process, SubProcess Level 1 and SubProcess Level 2.
The ONLY difference is that a Process can have many subprocess level 1โฆ and a subprocess level 1 can have many subprocess level 2.
That isโฆ there is a 1 - n relationship between the different levels.
Process, SubProcess Level 1 and SubProcess Level 2:
GENERAL INFORMATION TAB
ORGANIZATION tab
-Process Owner (related table of employees)
-Process Manager (related table of employees)
INPUT/OUTPUT tab
SYSTEMS/PRODUCTS tab
-Referenced Applications / IT Systems (related table of systems and applications)
DOCUMENTS tab
-Referenced Documents (related table to documents)
-Terms Abbreviations (link to external document)
CUSTOMERS/SUPPLIERS tab
CONTINUOUS IMPROVEMENT tab
RISK MANAGEMENT tab
An example:
Type of Process : Management Process
Macroprocess: Quality Management
Process: Audit Management
SubProcess Level 1: Internal Audit Programming.
User | Count |
---|---|
44 | |
29 | |
23 | |
20 | |
15 |