Data Migration Documentation

Calyx RIM 6.1 CHF 1 Data Administration Tables

Calyx RIM 6.2 CHF 1 includes the following updates to the Data Administration tables.

The new table MGR.REGION_TYPE will be created. All existing regions from MGR.REGION will be updated to set REGION.REGION_TYPE_ID to the ID of the row from MGR.REGION_TYPE where CODE = ‘REGULATORY’

Internal Type Values

New values will be created in MGR.INTERNAL_TYPE with ENTITY__TYPE_ID equal to MGR.ENTITY_TYPE.ID where MGR.ENTITY_TYPE.CODE = ‘CHANGE_DET_STAT’.

New values will be created in MGR.EVT_CHNG_DETAIL_STATUS_TYPE.

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. The pre-migration report will indicate which data needs to be corrected. Otherwise, the value for ‘Termination/Withdrawal Reason’ will not migrate.

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.

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’.

Job Request Status

The Job Requests status ‘Waiting’ (ODS.REQUEST_STATUS_TYPE.NAME = ‘Waiting’) will be updated to ‘Waiting for InSight’.

Activities in the Alert Center

A new table will be created to support the integration of Activities into the Alert Center.

  • Favorites will be updated to support integration of Activities into the Alert Center.
  • Recently Viewed will be updated to support integration of Activities into the Alert Center.

Calyx RIM 6.2

A new Data Administration selection list, Workflow Management, has been added in Calyx RIM 6.2 to support the new Calyx RIM Workflow Integrations module.