Database Columns Added: Ennov InSight 7.3.3
The following Database fields, columns and tables were added in this release.
| UI Field Name | Database Table Name | Database Column Name | Database Column Type and Size | Description |
|---|---|---|---|---|
| Attached Document Country | MGR.ATTACHMENT_TYPE | COUNTRY_ID | NUMBER | The COUNTRY_ID column is added to the MGR.ATTACHMENT_TYPE table. |
| Attached Document Country | MGR.ACTION_ATTACHMENT | COUNTRY_ID | NUMBER | The COUNTRY_ID column is added to the MGR.ACTION_ATTACHMENT table. |
| Alternate IDMP Active Ingredient | MGR.XPHARMA_PRODUCT_REF_AI | ALTERNATE_REF_SUBSTANCE_ID | NUMBER | The ALTERNATE_REF_SUBSTANCE_IDcolumn is added to the MGR.XPHARMA_PRODUCT_REF_AI table |
| Alternate IDMP Active Ingredient | MGR.MI_REF_AI | ALTERNATE_REF_SUBSTANCE_ID | NUMBER | The ALTERNATE_REF_SUBSTANCE_IDcolumn is added to the MGR.MI_REF_AI table. |
| N/A | ODS.MIGRATION_ASSEMBLY_TEMPLATE_ID | REFERENCED_DTD_TYPE | NUMBER | The new REFERENCED_DTD_TYPE column is added to the ODS.MIGRATION_ASSEMBLY_TEMPLATE_ID table. |
| N/A | RAWSTAGE.ENTITY_INSTANCE_FIELD_VALUE | RAW_VALUE | CLOB | The new RAW_VALUE column is added to the RAWSTAGE.ENTITY_INSTANCE_FIELD_VALUE table. |
| N/A | RAWSTAGE.ENTITY_INSTANCE_FIELD_VALUE | CONVERTED_VALUE | CLOB | The new CONVERTED_VALUE column is added to the RAWSTAGE.ENTITY_INSTANCE_FIELD_VALUE table. |