Track and Trace Power BI Reports Documentation

TPD Codes Ordering and Consumption Reports

Version: 1, effective date: 22-Feb-2023

Alice Galoiu

---

Contents

• 1 Standard description

• 2 Data Source

• 3 Refresh Schedule

• 4 Pages

  • 4.1 Home
  • 4.2 Expire Soon (Within Next 30 Days)
  • 4.3 Codes Balance Per Line – Factory
  • 4.4 Codes balance Per Brand Per Market
  • 4.5 Codes Delivery Time
  • 4.6 Code Processing Time By ID Issuer

• 5 Document control

  • 5.1 Contact person
  • 5.2 Revision History

1 Standard description

This document will define the PowerBI report that allows to check the status of TPD Codes, processing, and delivery time.

2 Data Source

Database Vault

3 Refresh Schedule

Refresh frequency: daily

Time zone: UTC + 02:00

Time: 12:00 AM

4 Pages

4.1 Home

4.2 Expire Soon (Within Next 30 Days)

This page shows the details regarding codes that will expire in the next 30 days from today. It also shows an overview of number of production orders by expiration date or by factory.

4.3 Codes Balance Per Line – Factory

This page shows the number of available codes per factory in the period selected above.

4.4 Codes balance Per Brand Per Market

This page shows the number of available codes per market in the period selected above.

4.5 Codes Delivery Time

This page shows the number of production orders, the delivery time of codes by market / factory that has more then 5 days.

4.6 Code Processing Time By ID Issuer

This page shows an overview of the processing time of codes by ID issuer.

5 Document control

5.1 Contact person

Questions and feedback regarding this standard should be submitted to Alice Galoiu

5.2 Revision History

Version	Effective date	Purpose of change	Author
1	22-Feb-2023	First version of the document	Alice Galoiu

ANY QUESTIONS?

ASK TEAM