Egyptian Drug Authority #EDA has officially announced Phase 1 of the Egyptian Pharmaceutical Track & Trace System (EPTTS), a significant milestone in the journey toward full pharmaceutical traceability in Egypt.
Phase 1 focuses on a practical and controlled onboarding approach through CSV File Upload, allowing stakeholders to begin submitting traceability events in a structured and validated format.
𝐖𝐡𝐚𝐭 𝐝𝐨𝐞𝐬 𝐏𝐡𝐚𝐬𝐞 𝟏 𝐢𝐧𝐜𝐥𝐮𝐝𝐞?
The current implementation scope is intentionally limited to two core EPCIS business steps:
Commissioning of Serialized Trade Items (STIN)
Commissioning of Shipping Container Codes (SCC)
Packing (Aggregation) to support multi-level packaging hierarchies
All other events are currently outside the scope of Phase 1 CSV uploads.
𝐂𝐨𝐫𝐞 𝐌𝐚𝐫𝐤𝐞𝐭 𝐑𝐮𝐥𝐞𝐬 (𝐌𝐚𝐧𝐝𝐚𝐭𝐨𝐫𝐲)
To ensure data consistency and system integrity, the following rules apply:
• Each CSV file is processed as a single unit; any error rejects the entire file.
• Rows must be sorted by eventTime in ascending order.
• An EPC must be commissioned before it can be packed.
• readPointGLN is mandatory and must equal bizLocationGLN.
• Maximum 5 distinct lots/batches per commissioning file (STIN only).
• Maximum 50,000 unique serialized items per file.
• manufDate must always be earlier than the event timestamp (eventTime) when provided.
𝐂𝐒𝐕 𝐓𝐞𝐦𝐩𝐥𝐚𝐭𝐞 𝐑𝐞𝐪𝐮𝐢𝐫𝐞𝐦𝐞𝐧𝐭𝐬
All uploads must follow a fixed header structure and column order.
No columns can be renamed, removed, or added.
seqNo,bizstep,eventTime,timeOffset,readPointGLN,bizLocationGLN,epc,parent,import,expiryDate,manufDate
𝐏𝐫𝐞-𝐔𝐩𝐥𝐨𝐚𝐝 𝐕𝐚𝐥𝐢𝐝𝐚𝐭𝐢𝐨𝐧 𝐂𝐡𝐞𝐜𝐤𝐥𝐢𝐬𝐭
Before submitting a file, verify:
CSV header and column order match exactly
Mandatory fields exist in every row
readPointGLN equals bizLocationGLN
Rows are sorted by eventTime (ascending)
STIN commissioning rules are respected
SCC commissioning fields remain blank where required
Packing events reference valid parent EPCs
Maximum 50,000 serialized items per file
Maximum 5 lots per commissioning file