Ennov InSight 7.1 Data Migration Documentation

Component Active Ingredient vs PDS Active Ingredient Data Migration

Ennov InSight 7.1 changes the way how PDS Active Ingredients are created.

When there are Component Active Ingredients under Product, a PDS is created from this Product with Active Ingredient PDS Details added automatically with the strength information from Component Active ingredient.

After migration to Ennov InSight 7.1 strength data in the existing PDS Active Ingredients will become equal to Component Active Ingredients.

To avoid missing data there is a pre-migration script which helps to identify if values for existing PDS Active Ingredient strength fields are different from Component Active Ingredients.

You can make any correction to the Component Active Ingredient data before the migration. The data correction for Component Active Ingredient is done in in user interface.

Migration script that identifies Active Ingredients from entity level Component that are different from PDS Active Ingredients for Ennov InSight 7.1 (output is txt):
Table 1. Report Column Definition
pre_mig_rpt_ai_diff.sql
Report Column Value
PRODUCT FAMILY NAME Displays the Product Family Name.
APPLICATION NAME Displays the Application Name.
PRODUCT NAME Displays the Product Name.
COMPONENT NAME Displays the Component Name.
ACTIVE INGREDIENT NAME Displays the Active Ingredient Name.
CONCENTRATION MEASURE TYPE Displays the Concentration Measure Type.
LOW AMOUNT NUMERATOR VALUE Displays the Low Amount Numerator Value.
LOW AMOUNT NUMERATOR PREFIX Displays the Low Amount Numerator Prefix.
LOW AMOUNT NUMERATOR UNIT Displays the Low Amount Numerator Unit.
LOW AMOUNT DENOMINATOR VALUE Displays the Low Amount Denominator Value.
LOW AMOUNT DENOMINATOR PREFIX Displays the Low Amount Denominator Prefix.
LOW AMOUNT DENOMINATOR UNIT Displays the Low Amount Denominator Unit.
HIGH AMOUNT NUMERATOR VALUE Displays the High Amount Numerator Value.
HIGH AMOUNT NUMERATOR PREFIX Displays the High Amount Numerator Prefix.
HIGH AMOUNT NUMERATOR UNIT Displays the High Amount Numerator Unit.
HIGH AMOUNT DENOMINATOR VALUE Displays the High Amount Denominator Value.
HIGH AMOUNT DENOMINATOR PREFIX Displays the High Amount Denominator Prefix.
HIGH AMOUNT DENOMINATOR UNIT Displays the High Amount Denominator Unit.
MEASUREMENT POINT Displays the Measurement Point.
Note: The output will be in the following format [COMPONENT AI VALUE] - - ->[PDS AI VALUE].