Database Columns Changed: Ennov InSight 7.2
The following Database Columns were added, modified, or removed in this release.
| Field Name | Field Size | Database Column Name | Database Column Size | Db Table Name |
|---|---|---|---|---|
| N/A | N/A | N/A | N/A | DEVICE_NOMENCLATURE_TYPE is renamed to EU_DEVICE_NOMENCLATURE_TYPE. |
| N/A | N/A | N/A | N/A | GMDN_TYPE is renamed to FDA_DEVICE_GMDN_TYPE. |
| N/A | N/A | N/A | N/A | MARKETING_STATUS_REASON_TYPE is renamed to RISK_OF_SUPPLY_SHORTAGE_REASON_TYPE. |
| N/A | N/A | N/A | N/A | LIC_ACTION_ATTACHMENT is renamed to ACTION_ATTACHMENT. |
| N/A | N/A | N/A | N/A | LIC_ACTION_MP is renamed to MP_ACTION. |
| N/A | N/A | N/A | N/A | LIC_ACTION_EVENT is renamed to ACTION_EVENT. |
| N/A | N/A | N/A | N/A | LIC_ACTION is renamed to ACTION. |
| EU CT Number | N/A | EU_CT_NUMBER | VARCHAR2(100) | CTA_SHARED_DATA |
| Concentration Measure Type | N/A | CONCENTRATION_MEASURE_TYPE_ID | NUMBER | CONCENTRATION_VALUE |
| MAH/Organisation | N/A | SPONSOR_MAH_ID | NUMBER | LIC_PRODDET |
| Currently marketed in this country? | N/A | CURRENTLY_MARKETED_STATUS_ID | NUMBER | LIC_PRODDET_COUNTRY |
| Country | N/A | COUNTRY_ID | NUMBER | LIC_PRODDET_PCID |
| Version | N/A | VERSION | VARCHAR2(200) | LIC_PRODDET_PCID |
| Version Date | N/A | VERSION_DATE | DATE | LIC_PRODDET_PCID |
| Full Indication Language | N/A | FULL_INDICATION_TEXT_LANGUAGE_ID | NUMBER | MEDICINAL_PRODUCT |
| License Root Number | N/A | LICENSE_ROOT_NUMBER | VARCHAR2(100) | MEDICINAL_PRODUCT |
| Country | N/A | COUNTRY_ID | NUMBER | MP_MPID |
| IDMP Package Level | N/A | PACKAGE_LEVEL | VARCHAR2(200) | PACKAGING_CATEGORY_TYPE |
| Composition Grouping Description | N/A | COMPOSITION_GROUPING_DESCRIPTION | VARCHAR2(100) | PDS_ACTING_CHANGE |
| Origin of Substance | N/A | SUBSTANCE_ORIGIN_TYPE_ID | NUMBER | PDS_ACTING_CHANGE |
| Device Quantity Unit | N/A | PDS_MED_DEVICE_QTY_UOM_TYPE_ID | NUMBER | PDS_PACKSET_DETAIL_CHANGE |
| Composition Grouping Description | N/A | COMPOSITION_GROUPING_DESCRIPTION | VARCHAR2(100) | PDS_SUBSTANCE_CHANGE |
| Origin of Substance | N/A | SUBSTANCE_ORIGIN_TYPE_ID | NUMBER | PDS_SUBSTANCE_CHANGE |
| Authorized Representative Name | N/A | AUTHORIZED_REPRESENTATIVE_NAME | VARCHAR2(500) | SOURCE |
| Labeler DUNS Number/Legal Manufacturer Single Registration Number(SRN) | N/A | ORGANIZATION_IDENTIFIER2 | VARCHAR2(50) | SOURCE |
| Regulatory Agency | N/A | HEALTH_AUTHORITY_ID | NUMBER | SOURCE_AUTHORISATION |
| Confidentiality Indicator | N/A | DATA_CLASSIFICATION_TYPE_ID | NUMBER | SRC_PACK |
| Confidentiality Indicator | N/A | DATA_CLASSIFICATION_TYPE_ID | NUMBER | SRC_SUBSTANCE |
| Category of CMR Type | N/A | DEVICE_CMR_CATEGORY_TYPE_ID | NUMBER | SUBSTANCE |
| EC Number | N/A | EC_NUMBER | VARCHAR2(1000) | SUBSTANCE |
| Index Number | N/A | INDEX_NUMBER | VARCHAR2(50) | SUBSTANCE |
| Type | N/A | SUBSTANCE_SUBTYPE_TYPE_ID | NUMBER | SUBSTANCE |
| Use for xEVMPD | N/A | XEVMPD_FLAG | VARCHAR2(1) | XPHARMA_PRODUCT_REF_AI |
| Device Nomenclature Category | N/A | DEVICE_NOMENCLATURE_CATEGORY_TYPE_ID | NUMBER | EU_DEVICE_NOMENCLATURE_TYPE |
| Device Nomenclature Code | N/A | ID_CODE | VARCHAR2(300) | EU_DEVICE_NOMENCLATURE_TYPE |
| GMDN In-Vitro Term Type | N/A | DEVICE_INVITRO_TERM_TYPE_ID | NUMBER | FDA_DEVICE_GMDN_TYPE |
| Version | N/A | VERSION | VARCHAR2(100) | MP_MPID |
| Full Indication Text | N/A | FULL_INDICATION_TEXT | VARCHAR2(4000) | MP_NAME |
| Date of First Approval | N/A | FIRST_APPROVAL_DATE | DATE | MP_NAME |
| Device Quantity | N/A | PDS_MED_DEVICE_QTY | Integer | PDS_PACKSET_DETAIL_CHANGE |
| CAS Number | N/A | CAS_NUMBER | VARCHAR2(1000) | SUBSTANCE |
| Data Classification | N/A | DATA_CLASSIFICATION | VARCHAR2(100) | TERMINOLOGY_SYSTEM_LIST_MEMBER |
| Category | N/A | DATA_CATEGORY | VARCHAR2(100) | TERMINOLOGY_SYSTEM_LIST_MEMBER |
| Mapping Source | N/A | SOURCE_IDENTIFIER | VARCHAR2(500) | TERMINOLOGY_SYSTEM_LIST_MEMBER |
| xEVMPD Code | N/A | XEVMPD_CODE | VARCHAR2(500) | TERMINOLOGY_SYSTEM_LIST_MEMBER |
| Source Term Id | N/A | SOURCE_TERM | VARCHAR2(500) | TERMINOLOGY_SYSTEM_LIST_MEMBER |
| Version | N/A | VERSION | VARCHAR2(200) | XPHARMA_PRODUCT_PHPID |
| Version Date | N/A | VERSION_DATE | DATE | XPHARMA_PRODUCT_PHPID |
| N/A | N/A | N/A | LICENSE_ID is deleted. | ACTION |
| N/A | N/A | N/A | LICENSE_ID is deleted. | ACTION_ATTACHMENT |
| N/A | N/A | N/A | LICENSE_ID is deleted. | ACTION_EVENT |
| N/A | N/A | N/A | EXTRA_FIELDS_ID is deleted. | EU_DEVICE_NOMENCLATURE_TYPE |
| N/A | N/A | N/A | CURRENTLY_MARKETED_FLAG is deleted. | LIC_PRODDET_COUNTRY |
| N/A | N/A | N/A | STATUS_DATE is deleted. | LIC_PRODDET_PCID |
| N/A | N/A | N/A | LICENSE_ID is deleted. | MEDICINAL_PRODUCT |
| N/A | N/A | N/A | LICENSE_ID is deleted. | MP_ACTION |
| N/A | N/A | N/A | LICENSE_ID is deleted. | MP_AUTH_PHARMA_FORM |
| N/A | N/A | N/A | LICENSE_ID is deleted. | MP_MPID |
| N/A | N/A | N/A | LICENSE_ID is deleted. | MP_NAME |
| N/A | N/A | N/A | LICENSE_ID is deleted. | MP_NAME_COUNTRY |
| N/A | N/A | N/A | LICENSE_ID is deleted. | MP_PHARMA_PRODUCT |
| N/A | N/A | N/A | LICENSE_ID is deleted. | MP_XREF |
| N/A | N/A | N/A | TYPE_CODE is deleted. | SUBSTANCE |
| N/A | N/A | N/A | PROD_MATERIAL_TYPE_ID is deleted. | PACKAGE_COMPONENT |
| N/A | N/A | N/A | DATA_CARRIER_LANGUAGE_TYPE_ID is deleted. | LIC_PRODDET_COUNTRY |
| N/A | N/A | N/A | DATA_CARRIER_IDENTIFIER is deleted. | LIC_PRODDET_COUNTRY |
| N/A | N/A | N/A | DATA_CARRIER_TYPE_ID is deleted. | LIC_PRODDET_COUNTRY |