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 Medications

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

   2. is_active = TRUE

      start_at | date | not null
      	end_at | date | not null
      	route | varchar | not null
      	container_dosage | jsonb | not null
      	package_qty | number | not null
      	package_min_qty | number | not null
      	code_ATX | varchar | not null
      	manufacturer_name_country | jsonb | not null
      	certificate | varchar | not null
      	expired_certificate_date

4. cd