Data Migration Documentation

Calyx RIM 6.0 CHF 4 Data Administration Tables

Calyx RIM 6.0 CHF 4 includes the following updates to the Data Administration tables.

Reasons for Termination/Withdrawal Values

Be sure to run the pre-migration script rpt_pre_migration_application_list_withdrawals.sql to ensure that Reasons for Termination/Withdrawal values are mapped and migrated correctly. Otherwise, the value for ‘Termination/Withdrawal Reason’ will not migrate. The pre-migration report will indicate data that needs to be corrected.

Queries

For the reports where the ‘Termination/Withdraw Reason’ field from the Application entity is available, the query has been updated to display the migrated data from the new Reason for Termination/Withdrawal field. If there is no value, the field will continue to remain blank.

Procedure Type Values

For the following Procedure Types, the Country column is updated with Liechtenstein:
  • EU CP Bio
  • EU CP New API
  • EU CP Orphan

EU 3.0 Assemblies

For Standalone Assemblies, Template Assemblies, Working, Sequence, and Submitted Views where XML Definitions of the associated APL contains ‘EU-3-0’ and ‘FORM-1-1’, the folder with Number equal to ‘1.2’ and Name equal to ‘EMA-eAF’ and Extension equal to ‘Default’ will be updated to set Extension to 'XML Application Form' (version 2.0) with the Country attribute set to ‘ema’.