Metadata change detection during metadata loading

During metadata loading, the system:

• Reloads the required static metadata tables: IRV tables and RD_DATADICTIONARY.

• Compares the static metadata tables with the data stored in DME_IA_SRC_TABLES and DME_IA_SRC_COLUMNS to detect significant changes including:

  • New, missing, or changed reference path for an item

  • Changed data type

  • Increased data length for VARCHAR2 columns

  • Changes to column (item) blinding status

• If significant changes are found, updates DME_IA_SRC_TABLES and DME_IA_SRC_COLUMNS, other extended metadata mapping tables, and the InForm input clinical data model tables. Note:

  • Tables are never dropped. If an RDE view is missing, the system marks the corresponding DMW table as Not Used.

  • Columns are never dropped. If an existing item is not included, it is marked Not Used. If a column data type is changed, a new column is created with the new data type.

  • Updating a column's blinding status may require updating its table's blinding status as well.

• Displays the message "Metadata needs to be reloaded" and suspends data loading until it is done.