To be used in a rule, a codelist item must have the same data type as its parent codelist. If the data types do not match, when you upgrade from a release prior to 2.0, the data types of the codelist items are changed to the data types of their parent codelists. Changes in data type could have an impact on study reporting database extracts when new Central Designer 2.1 deployments are executed.
A SQL script called DetectInvalidCodeListItems.sql generates a report that identifies codelist items of types that are incompatible with the type of their parent codelist.
Run the script before upgrading the application server to assess the impact of data type changes on studies that are upgraded. The script and a readme file (DetectInvalidCodeListItems.Readme) are available on the product ZIP file in the InstallSupport directory.
Copyright © 2007, 2016 Oracle and/or its affiliates. All rights reserved.