Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Scope

Google Drive Live Link
urlhttps://drive.google.com/file/d/19gK8sn5qSIDFG8LMmlMzEiY3moyryzz0pc3N-uQFJbo/view

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:

Jira
serverJira
serverIdbbf5f9ee-7f3e-3274-bb6e-be12673f2166
keyEBR-
24

...

85
Done

Header page

Jira
serverJira
serverIdbbf5f9ee-7f3e-3274-bb6e-be12673f2166
keyEBR-37
→ 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:

Jira
serverJira
serverIdbbf5f9ee-7f3e-3274-bb6e-be12673f2166
keyEBR-45
 to be discussed with technical team 

SAP source

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

Jira
serverJira
serverIdbbf5f9ee-7f3e-3274-bb6e-be12673f2166
keyEBR-43
→ Done

Batch attribute table:

Jira
serverJira
serverIdbbf5f9ee-7f3e-3274-bb6e-be12673f2166
keyEBR-80
Done

Lab parameters  derived from SAP 

Jira
serverJira
serverIdbbf5f9ee-7f3e-3274-bb6e-be12673f2166
keyEBR-42
→ Done 

Packaging attributes from SAP (MTP and Torrelavega) 

Jira
serverJira
serverIdbbf5f9ee-7f3e-3274-bb6e-be12673f2166
keyEBR-81
 

Test data in BQ views→ In progress


Other sources 

 Reference table

Jira
serverJira
serverIdbbf5f9ee-7f3e-3274-bb6e-be12673f2166
keyEBR-44
→ In progress (technical decision making) 

ProdX data view (Data model)

Jira
serverJira
serverIdbbf5f9ee-7f3e-3274-bb6e-be12673f2166
keyEBR-41
pending the meeting with the owner of the app (Technical info to connect)


PI source

PI data model Dombasle 

Jira
serverJira
serverIdbbf5f9ee-7f3e-3274-bb6e-be12673f2166
keyEBR-47
pending tag names from business 

PI data link with BQ 

Jira
serverJira
serverIdbbf5f9ee-7f3e-3274-bb6e-be12673f2166
keyEBR-25

...

46
→ Pending PI data ingestion in BQ 

Batch manufacturing time (start/stop time) calculations

Jira
serverJira
serverIdbbf5f9ee-7f3e-3274-bb6e-be12673f2166
keyEBR-20

Logistic form 

Laboratory form 

Quality form 

Versioning requirements 

...

109
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 


Jira
serverJira
serverIdbbf5f9ee-7f3e-3274-bb6e-be12673f2166
keyEBR-27