Hello, this may be a long one
I’m working on finishing an architecture for Review by Exception at the Life Sciences manufacturer I work for. I’m trying to ensure that we’ve got an efficient and maintainable scaffold for preparing new devices and supporting existing devices. Currently how I’ve structured this is with a few artifact tables that connect together, and documenting standard design patterns for other users in our Account.
To plan manufacturing activity, I’ve set up these tables:
- Item Master
- Routing Master
- Data Master
- Routing Stages
These are linked together, so each Item has multiple routings, and each routing has a set of expected data and expected stages
Then to track manufacturing activity, I’ve set up these tables:
- Exceptions (for defects, record corrections, etc.)
These are linked together, so each order has assemblies, and each assembly has a set of metrics, activity, and exceptions.
When users create new Orders, they select a routing for that order. Then they populate that order with assembly records (before rollout we’ll connect this to our ERP so they are transferring the records from there, instead of making them manually). These assemblies get pushed to the manufacturing environment and get routed through the work process based on their Routing Stages.
At the end, each device gets pushed to an eDHR review application. QA review checks:
- Each order quantity is correct
- All exceptions are closed
- The activity logged for each assembly record matches the expected routing stages in the routing
- The data logged for each assembly record matches the expected data in the routing
I’d like to make sure this process is as efficient as possible. Currently, for QA review the user clicks through each assembly and the app runs a query to check the items above. If it doesn’t find anything, I’m comfortable saying they can accept as is. But for larger orders that could mean clicking through hundreds of records.
In an ideal case, what I’d like to do is be able to query info on the order and return to QA a list of only assemblies that were flagged for one of these items being out of tolerance, but I’m not sure how to do that.