Pre-Migration Scripts for Calyx RIM 6.0 CHF 3 to Calyx RIM 6.0 CHF 4
rpt_pre_migration_application_list_withdrawals.sql
To identify potential migration problems where data does not conform to the new requirements, it is recommended that you run the rpt_pre_migration_application_list_withdrawals.sql script before starting your database migration.
The rpt_pre_migration_application_list_withdrawals.sql script should be run by an ism user.
The rpt_pre_migration_application_list_withdrawals.sql script produces an Excel report that identifies application names with Application Statuses that are not mapped to any internal system status, or are mapped to the incorrect values and have data in the ‘Termination/Withdraw Reason’ field that cannot be migrated because they do not meet the criteria for migration.
| Report Column | Value |
|---|---|
| PRODUCT FAMILY NAME | Displays the Product Family Name. |
| APPLICATION NAME | Displays the Application Name. |
| APPLICATION STATUS | Displays the Application Status mapped to the incorrect internal system status. |
| INTERNAL SYSTEM STATUS | Displays Internal System Status for Application Status value. |
| TERMINATION/WITHDRAW REASON | Displays the Termination/Withdraw Reason field data. |
rpt_pre_migration_fpp_uniqueness.sql
To identify duplicate 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_fpp_uniqueness.sql script before starting your database migration.
The rpt_pre_migration_fpp_uniqueness.sql script should be run by an mgr user.
The rpt_pre_migration_fpp_uniqueness.sql script produces a report that identifies duplicates of LST Full Product Name under the same Registration.
| Report Column | Value |
|---|---|
| FPP_NAME | Displays the Full Product Presentation Name. |
| FPP_ID | Displays the Full Product Presentation entity ID. |
| PRODUCT_FAMILY_NAME | Displays the Product Family Name. |
| APPLICATION_NAME | Displays the Application Name. |
| IDENTIFICATION_CODE | Displays the License Code. |
| AUTHORISATION_DATE | Displays the Authorisation/Renewal Date on Full Product Presentation. |
| PACKAGE_ DESCRIPTION | Displays the Package Description on Full Product Presentation. |
master_pre.sql
The master_pre.sql script should be run by a system user. You must run the master_pre.sql script before running the master.sql script.