Scope

High level user flow (BA & business stakeholders) 

https://miro.com/app/board/uXjVN5MF2XQ=/#tpicker-content

Data flow (BA and Architect) 

https://app.diagrams.net/#G1mfwQh_gsmV1lNLwc9OfvJrRAWPaZyTYm#%7B%22pageId%22%3A%22jheWgB9ikYpCB23Nlwa9%22%7D

Web app requirements 

Production:  https://solvayagile.atlassian.net/browse/EBR-20 ->Done
Laboratory: https://solvayagile.atlassian.net/browse/EBR-31 →Done 
Quality:   https://solvayagile.atlassian.net/browse/EBR-32 ->Done
Logistic: https://solvayagile.atlassian.net/browse/EBR-30 -> Done

Handling inconsistencies: Done

Header page → Done

Summary page:  https://solvayagile.atlassian.net/browse/EBR-37-> Done
Access management:  https://solvayagile.atlassian.net/browse/EBR-36 -> Done
Versioning:  https://solvayagile.atlassian.net/browse/EBR-38->    In progress




Data model requirements 

Refresh frequency:  to be discussed with technical team 

SAP source

Silo number: Batch attributes derived from SAP (MTP & Torrelavega) → Done

Batch attribute table: Done

Lab parameters  derived from SAP → Done 

Packaging attributes from SAP (MTP and Torrelavega)  

Test data in BQ views→ In progress


Other sources 

 Reference table → In progress (technical decision making) 

ProdX data view (Data model) pending the meeting with the owner of the app (Technical info to connect)


PI source

PI data model Dombasle  pending tag names from business 

PI data link with BQ  → Pending PI data ingestion in BQ 

Batch manufacturing time (start/stop time) calculations Requirements specification is pending stakholders decision making on the excluding nonconformity period from the calculation.  Pending decision making on where to host the calculation. Web app or BG. If web app. 


Source batch 21 & PI sheet