Patient ID
Upon first save, the Patient will have a unique ID assigned automatically by the system. The Patient ID is generated as follow:
Ordering Patient IDs
While using the data extract, one might require ordering patients by the unique number in the program (the last characters after the hyphen). To do so, follow the following steps:
-
Create a new column in your Excel export, to the right of the Patient ID column
-
For your first patient, in cell A2, enter in cell B2 the formula
=RIGHT (A2, (FIND ("-”, A2,1)-3)) -
For patients 2-9, drag the formula above so it applies
-
For patient 10, update the formula:
=RIGHT (A2, (FIND ("-”, A2,1)-2)) -
Drag the formula until patient 99
-
Repeat for patients 100-999 with
=RIGHT (A2, (FIND ("-”, A2,1)-1))
If you reach 1000 patients, -1 becomes 1. For 10,000 patients, 1 becomes 2, etc.
Medication Release Letter / Voucher / EAC (Electronic Authentication Code)
Each document generated by the PMS will have 3 different codes/identifiers.
Code
Also known as the MedPack code. This is a unique code to identify the actual medication boxes we provide to Pharmacies. This code could be printed and labelled on each box to monitor stocks. The format is as follow:
Serial number
The unique identifier for each document issued by the system. The format is as follow:
Security Code
The unique identifier the Pharmacist will enter in the Pharmacy portal to confirm the Patient has picked up the medication. The format is as follow:
Going Further
Learn more about how to create a patient in the Patient Creation article.
Learn more about MRL and Voucher configuration in the MRL and Voucher Configuration article.