Pre-Migration Mandatory Scripts for Calyx RIM 5.1 to Calyx RIM 6.1
Pre-Migration Scripts
There are a number of pre-migration scripts. It is recommended the scripts are run to identify potential migration problems where data does not conform to the new requirements. These scripts are listed below with a brief description of their use.
| Script Number | Script Name | Description | Type of Output |
|---|---|---|---|
| Script 1 | rpt_pre_migration_substances.sql |
Prior to the consolidation into a single Substance list in Data Administration. Identifies data conflicts in the Active Ingredient and Excipient Values tables. |
Excel |
| Script 2 | rpt_pre_migration_excipient.sql |
Prior to migrating the Excipient role. Identifies PDS Excipients that would result in duplicate Excipients in the PDS if the Excipient Role is not migrated. |
Excel |
| Script 3 | rpt_pre_migration_concentration.sql |
Prior to migrating concentration measures to a format that conforms with XEVMPD and IDMP. Identifies concentration measures for a Substance that cannot be migrated to the new measure fields because the values do not meet the criteria for migration. |
Excel |
| Script 4 | rpt_pre_migration.sql |
Identifies: -Substances with a CAS Number greater than 15 characters for Active Ingredients and Excipients. The CAS Number field has been restricted to15 characters to support Calyx RIM for XEVMPD; - Indications/Intended Use that contain values for Lower Level Term Code (LLT) and/or Preferred Term Code (PT Code) that do not meet the criteria for migration; - MAH/Development Sponsor/Legal Representative Name Values that do not contain a Country value that meets the criteria for migration. |
Text |
| Script 5 | master-pre.sql | Pre-migration script for database upgrade to Calyx RIM 6.0 Certified Hotfix (CHF) 1 | None |
| Script 6 | rpt_pre_mig_name_uniqueness.sql |
Identifies duplicate of Full Product Presentation entities with same Full Product Name within the Registration entity. Pre-migration script for database upgrade to Calyx RIM 6.0 Certified Hotfix (CHF) 3 |
Excel |
| Script 7 | rpt_pre_mig_missing_dosage_forms.sql |
Identifies missing Dosage Forms from Products or Components for Pharmaceutical Product entity. Pre-migration script for database upgrade to Calyx RIM 6.0 Certified Hotfix (CHF) 3 |
Excel |