Content Comparison

Table of Contents

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:
3. sasad

Step 3 - Load Medications

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

   2. is_active = TRUE

   3. start_at | date | not null= `2017/07/26`
   4. end_at | date | not nullroute | varchar | not nullcontainer_dosage | jsonb | not nullpackage_qty | number | not null = `3000/01/01`
   5. route = column `D`(4) + search in Dictionary `medication_route` by name
   6. container_dosage
      1. = column ``
   7. package_qty = column `G`(6)
   8. package_min_qty | number | not null = column `G`(6)
   9. code_ATX | varchar | not null = column `H`(7)
   10. manufacturer_name_country | jsonb | not nullcertificate | varchar | not null=column `I`(8) + Parsing Procedure 1
   11. certificate = column `J`(9)
   12. expired_certificate_date= column `K`(10) + format `DD.MM.YYYY`
4. cd