Customization of B3 to C3 mapping
If customization is required, it can be achieved by the customizing export mapping query
for the below elements in Console > Interchange
Mapping > MFDS profile.
- PATIENTPASTDRUGTHERAPY
- PARENTPASTDRUGTHERAPY
- DRUG
- ACTIVESUBSTANCE
Note:
pkg_mfds.sql is unwrapped for this purpose.
WHO Medicinal Product ID and WHO CAS Number are captured and transmitted as outlined in the table below.
For details, refer to the Business Rules defined in E2B(R3) export mapping document.
| Element ID | Element Description | Data Capture and Transmitted From |
|---|---|---|
| D.8.r.1.KR.1a | WHO-DD version | Console > Common Profile Switch > E2B > Regional Drugs Dictionary |
| D.8.r.1.KR.1b | Medicinal Product ID
(Patient Past drug Therapy) |
WHO Medicinal Product ID is retrieved from WHO-DD C3 dictionary WHO_DRUG_C_MASTER table using Drug code of the Patient past drug details |
| D.10.8.r.1.KR.1a | WHO-DD version | Console > Common Profile Switch > E2B > Regional Drugs Dictionary |
| D.10.8.r.1.KR.1b | Medicinal Product ID
(Parent Past drug Therapy) |
WHO Medicinal Product ID is retrieved from WHO-DD C3 dictionary WHO_DRUG_C_MASTER table using Drug code of the Parent past drug details |
| G.k.2.1.KR.1a | WHO-DD version | Console > Common Profile Switch > E2B > Regional Drugs Dictionary |
| G.k.2.1.KR.1b | Medicinal Product ID
(Suspect/Concomitant/Interacting Products) |
WHO Medicinal Product ID is retrieved from WHO-DD C3 dictionary WHO_DRUG_C_MASTER table using Case Form > Product > Drug Code |
| G.k.2.3.r.1.KR.1a | WHO-DD version | Console > Common Profile Switch > E2B > Regional Drugs Dictionary |
| G.k.2.3.r.1.KR.1b | Substance ID
(Ingredients of Suspect/Concomitant/Interacting Products) |
WHO CAS Number is retrieved from WHO-DD C3 dictionary WHO_DRUG_C_SUBSTANCE table using Case Form > Product > Substance Information > Substance Name |