Medications Upload specs

Data file

File: Medications&Innm2Load

Page: "Original-2017-08-26"

Upload steps & logic

Step 1- Load Innms

1. Source page "innm"
2. Mapping:
   1. innm_identifier = column `C`
   2. name = column `A`
3. Check exist by `innm_identifier`
   1. If not exist - Insert new.
      
      1. status=INACTIVE (DICTIONARY: innm_status)
      2. is_active=TRUE

Step 2 - Load Routes

1. Source page: "Dic: route"
2. Mapping:
   1. name = column `A`
3. Check exist by `value`
   1. If not exist - Insert new.

Step 3 - Add Countries

1. Manually add new values into Dictionary: COUNTRY
2. TBD !!!!

Step 3 - Load Medications

1. Source page: "Original-2017-07-26"
2. Delete * from medications (delete old data)
3. Mapping:
   1. name = column `C`(3)

   2. is_active = TRUE

   3. start_at = `2017/07/26`
   4. end_at = `3000/01/01`
   5. route = column `D`(4) + search in Dictionary `medication_route` by name
   6. container_dosage
      1. numerator_value = column `E`(5) + Mapping procedure Dosage
   7. package_qty = column `G`(6)
   8. package_min_qty = column `G`(6)
   9. code_ATX = column `H`(7)
   10. manufacturer_name_country =column `I`(8) + Parsing procedure Manufacturer & Country
   11. certificate = column `J`(9)
   12. expired_certificate_date = column `K`(10) + format `DD.MM.YYYY`

Mapping procedure Dosage

dsvds

Mapping procedure Container Dosage

dsfdsfd

Parsing procedure Manufacturer & Country

1. Parsing string by format: `manufacturer_name`,`country_name` 
2. Examples: 
   1. Юнікем Лабораторіз Лімітед , Індія;
   2. Асіно Фарма АГ , Швейцарія
3. Mapping for structure Manufacturer_info
   1. name = `manufacturer_name`
   2. country = `country_name` search in Dictionary `Country` by name