Pre-Migration Scripts for Calyx RIM 6.0 CHF 2 to Calyx RIM 6.0 CHF 3
rpt_pre_migration_name_uniqueness.sql
To identify duplicates of Full Product Presentation entities with the same Full Product Name within the Registration entity, it is recommended that you run the rpt_pre_migration_name_uniqueness.sql script before starting your database migration.
The rpt_pre_migration_name_uniqueness.sql script should be run by the mgr user.
The rpt_pre_migration_name_uniqueness.sql script produces an Excel report that identifies duplicates of Full Product Name under the same Registration that cannot be migrated because they do not meet the criteria for migration to the Full Product Presentation entity.
| Report Column | Value |
|---|---|
| FPP_NAME | Displays the Full Product Name. |
| FPP_ID | Displays the Full Product Presentation ID. |
| PRODUCT FAMILY NAME | Displays the Product Family Name. |
| APPLICATION NAME | Displays the Application Name. |
| LICENSE CODE | Displays the License Code. |
| PRODUCTS | Displays the Product Name. |
rpt_pre_migration_missing_dosage_forms.sql
To identify missing Dosage Forms from single Component Products for Pharmaceutical Product entity, it is recommended that you run the rpt_pre_migration_missing_dosage_forms.sql script before starting your database migration.
The rpt_pre_migration_missing_dosage_forms.sql script should be run by the mgr user.
The rpt_pre_migration_missing_dosage_forms.sql script produces an Excel report that identifies single Component Products with missing component dosage form or multiple Component Products with missing product dosage form.
| Report Column | Value |
|---|---|
| PRODUCT_FAMILY_NAME | Displays the Product Family Name |
| PRODUCT FAMILY_ID | Displays the Product Family ID |
| PRODUCT_NAME | Displays the Product Name |
| PRODUCT_ID | Displays the Product ID |
| COMPONENT_NAME | Displays the Component Name |
| COMPONENT_ID | Displays the Component ID |
| XPHARMA_PRODUCT_ID | Displays the Pharmaceutical Product Name |
| XPHARMA_PRODUCT_ID | Displays the Pharmaceutical Product ID |