Product

Entity Relationship Diagram

 

Tip:   

Right click the attachment to view Entity Relationship Diagram for Product in a new tab.

List of Objects

Table Schema Name DB Object Name Object Business Name Object Description DB Attribute Name Attribute Business Name Ordinal Position Data Type Name Data Type Size Numeric Scale Is Identity Is Nullable Primary Key Mandatory
MDM_CANONICAL P_INDICATION PRODUCT MASTER PRODUCT MASTER INDICATION_ID INDICATION_ID 1 VARCHAR 16777216   NO NO YES YES
MDM_CANONICAL P_INDICATION PRODUCT MASTER PRODUCT MASTER PRODUCT_ID PRODUCT_ID 2 VARCHAR 16777216   NO YES NO NO
MDM_CANONICAL P_INDICATION PRODUCT MASTER PRODUCT MASTER PRODUCT_TYPE PRODUCT_TYPE 3 VARCHAR 16777216   NO YES NO NO
MDM_CANONICAL P_INDICATION PRODUCT MASTER PRODUCT MASTER INDICATION_TEXT INDICATION_TEXT 4 VARCHAR 16777216   NO YES NO NO
MDM_CANONICAL P_INDICATION PRODUCT MASTER PRODUCT MASTER TYPE TYPE 5 VARCHAR 16777216   NO YES NO NO
MDM_CANONICAL P_INDICATION PRODUCT MASTER PRODUCT MASTER INDICATION INDICATION 6 VARCHAR 16777216   NO YES NO NO
MDM_CANONICAL P_INDICATION PRODUCT MASTER PRODUCT MASTER DISEASE_STATUS DISEASE_STATUS 7 VARCHAR 16777216   NO YES NO NO
MDM_CANONICAL P_INDICATION PRODUCT MASTER PRODUCT MASTER INTENDED_EFFECT INTENDED_EFFECT 8 VARCHAR 16777216   NO YES NO NO
MDM_CANONICAL P_INDICATION PRODUCT MASTER PRODUCT MASTER COMORBIDITY COMORBIDITY 9 VARCHAR 16777216   NO YES NO NO
MDM_CANONICAL P_INDICATION PRODUCT MASTER PRODUCT MASTER DURATION DURATION 10 VARCHAR 16777216   NO YES NO NO
MDM_CANONICAL P_INDICATION PRODUCT MASTER PRODUCT MASTER COUNTRY COUNTRY 17 VARCHAR 16777216   NO NO NO NO
MDM_CANONICAL P_INDICATION PRODUCT MASTER PRODUCT MASTER SYS_CRT_DT SYS_CRT_DT 11 TIMESTAMP_LTZ     NO NO NO NO
MDM_CANONICAL P_INDICATION PRODUCT MASTER PRODUCT MASTER SYS_UPDT_DT SYS_UPDT_DT 12 TIMESTAMP_LTZ     NO NO NO NO
MDM_CANONICAL P_INDICATION PRODUCT MASTER PRODUCT MASTER SYS_EFF_DT SYS_EFF_DT 13 TIMESTAMP_LTZ     NO NO NO NO
MDM_CANONICAL P_INDICATION PRODUCT MASTER PRODUCT MASTER SYS_END_DT SYS_END_DT 14 TIMESTAMP_LTZ     NO NO NO NO
MDM_CANONICAL P_INDICATION PRODUCT MASTER PRODUCT MASTER SYS_CRT_BY SYS_CRT_BY 15 VARCHAR 16777216   NO NO NO NO
MDM_CANONICAL P_INDICATION PRODUCT MASTER PRODUCT MASTER SYS_UPDT_BY SYS_UPDT_BY 16 VARCHAR 16777216   NO NO NO NO
MDM_CANONICAL P_MED_PRODUCT PRODUCT MASTER PRODUCT MASTER MED_PRODUCT_ID MED_PRODUCT_ID 1 VARCHAR 16777216   NO NO YES YES
MDM_CANONICAL P_MED_PRODUCT PRODUCT MASTER PRODUCT MASTER PRODUCT_ID PRODUCT_ID 2 VARCHAR 16777216   NO YES NO NO
MDM_CANONICAL P_MED_PRODUCT PRODUCT MASTER PRODUCT MASTER PRODUCT_TYPE PRODUCT_TYPE 3 VARCHAR 16777216   NO YES NO NO
MDM_CANONICAL P_MED_PRODUCT PRODUCT MASTER PRODUCT MASTER HCO_MANUFACTURER_ID HCO_MANUFACTURER_ID 4 VARCHAR 16777216   NO YES NO NO
MDM_CANONICAL P_MED_PRODUCT PRODUCT MASTER PRODUCT MASTER NAME NAME 5 VARCHAR 16777216   NO YES NO NO
MDM_CANONICAL P_MED_PRODUCT PRODUCT MASTER PRODUCT MASTER TYPE TYPE 6 VARCHAR 16777216   NO YES NO NO
MDM_CANONICAL P_MED_PRODUCT PRODUCT MASTER PRODUCT MASTER ALTERNATE_NAME ALTERNATE_NAME 7 VARCHAR 16777216   NO YES NO NO
MDM_CANONICAL P_MED_PRODUCT PRODUCT MASTER PRODUCT MASTER COUNTRY COUNTRY 8 VARCHAR 16777216   NO YES NO NO
MDM_CANONICAL P_MED_PRODUCT PRODUCT MASTER PRODUCT MASTER PRODUCT_LEVEL PRODUCT_LEVEL 9 VARCHAR 16777216   NO YES NO NO
MDM_CANONICAL P_MED_PRODUCT PRODUCT MASTER PRODUCT MASTER MPID MPID 10 VARCHAR 16777216   NO YES NO NO
MDM_CANONICAL P_MED_PRODUCT PRODUCT MASTER PRODUCT MASTER PRODUCT_CODE PRODUCT_CODE 11 VARCHAR 16777216   NO YES NO NO
MDM_CANONICAL P_MED_PRODUCT PRODUCT MASTER PRODUCT MASTER IS_PRESCRIPTION_PRODUCT IS_PRESCRIPTION_PRODUCT 12 VARCHAR 16777216   NO YES NO NO
MDM_CANONICAL P_MED_PRODUCT PRODUCT MASTER PRODUCT MASTER ROUTE_OF_OF_ADMINISTRATION ROUTE_OF_OF_ADMINISTRATION 13 VARCHAR 16777216   NO YES NO NO
MDM_CANONICAL P_MED_PRODUCT PRODUCT MASTER PRODUCT MASTER MARKETING_START_DATE MARKETING_START_DATE 14 TIMESTAMP_LTZ     NO YES NO NO
MDM_CANONICAL P_MED_PRODUCT PRODUCT MASTER PRODUCT MASTER MARKETING_END_DATE MARKETING_END_DATE 15 TIMESTAMP_LTZ     NO YES NO NO
MDM_CANONICAL P_MED_PRODUCT PRODUCT MASTER PRODUCT MASTER PRODUCT_AVAILABILITY_STATUS PRODUCT_AVAILABILITY_STATUS 16 VARCHAR 16777216   NO YES NO NO
MDM_CANONICAL P_MED_PRODUCT PRODUCT MASTER PRODUCT MASTER PRODUCT_NDC_CODE PRODUCT_NDC_CODE 17 VARCHAR 16777216   NO YES NO NO
MDM_CANONICAL P_MED_PRODUCT PRODUCT MASTER PRODUCT MASTER PRODUCT_LAUNCH_STATUS PRODUCT_LAUNCH_STATUS 18 VARCHAR 16777216   NO YES NO NO
MDM_CANONICAL P_MED_PRODUCT PRODUCT MASTER PRODUCT MASTER BRAND_ID BRAND_ID 19 VARCHAR 16777216   NO YES NO NO
MDM_CANONICAL P_MED_PRODUCT PRODUCT MASTER PRODUCT MASTER PACK_DESCRIPTION PACK_DESCRIPTION 20 VARCHAR 16777216   NO YES NO NO
MDM_CANONICAL P_MED_PRODUCT PRODUCT MASTER PRODUCT MASTER PACKAGE_SIZE PACKAGE_SIZE 21 VARCHAR 16777216   NO YES NO NO
MDM_CANONICAL P_MED_PRODUCT PRODUCT MASTER PRODUCT MASTER PACK_LAUNCH_DATE PACK_LAUNCH_DATE 22 TIMESTAMP_LTZ     NO YES NO NO
MDM_CANONICAL P_MED_PRODUCT PRODUCT MASTER PRODUCT MASTER PACK_SIZE_PER_QUANTITY PACK_SIZE_PER_QUANTITY 23 NUMBER   0 NO YES NO NO
MDM_CANONICAL P_MED_PRODUCT PRODUCT MASTER PRODUCT MASTER PACK_SIZE_UOM PACK_SIZE_UOM 24 VARCHAR 16777216   NO YES NO NO
MDM_CANONICAL P_MED_PRODUCT PRODUCT MASTER PRODUCT MASTER PACK_QUANTITY_UOM PACK_QUANTITY_UOM 25 VARCHAR 16777216   NO YES NO NO
MDM_CANONICAL P_MED_PRODUCT PRODUCT MASTER PRODUCT MASTER CMF_REPACK_NUMBER CMF_REPACK_NUMBER 26 VARCHAR 16777216   NO YES NO NO
MDM_CANONICAL P_MED_PRODUCT PRODUCT MASTER PRODUCT MASTER CMF_PACK_NUMBER CMF_PACK_NUMBER 27 VARCHAR 16777216   NO YES NO NO
MDM_CANONICAL P_MED_PRODUCT PRODUCT MASTER PRODUCT MASTER PACK_UNIT_FACTOR PACK_UNIT_FACTOR 28 VARCHAR 16777216   NO YES NO NO
MDM_CANONICAL P_MED_PRODUCT PRODUCT MASTER PRODUCT MASTER PACK_UNIT_QUANTITY PACK_UNIT_QUANTITY 29 NUMBER   0 NO YES NO NO
MDM_CANONICAL P_MED_PRODUCT PRODUCT MASTER PRODUCT MASTER INTERNATIONAL_PACK_DESCRIPTION INTERNATIONAL_PACK_DESCRIPTION 30 VARCHAR 16777216   NO YES NO NO
MDM_CANONICAL P_MED_PRODUCT PRODUCT MASTER PRODUCT MASTER INTERNATIONAL_PACK_CODE INTERNATIONAL_PACK_CODE 31 VARCHAR 16777216   NO YES NO NO
MDM_CANONICAL P_MED_PRODUCT PRODUCT MASTER PRODUCT MASTER INTERNATIONAL_PACK_SIZE_CODE INTERNATIONAL_PACK_SIZE_CODE 32 VARCHAR 16777216   NO YES NO NO
MDM_CANONICAL P_MED_PRODUCT PRODUCT MASTER PRODUCT MASTER INTERNATIONAL_PACK_STRENGTH_CODE INTERNATIONAL_PACK_STRENGTH_CODE 33 VARCHAR 16777216   NO YES NO NO
MDM_CANONICAL P_MED_PRODUCT PRODUCT MASTER PRODUCT MASTER INTERNATIONAL_PACK_VOLUME_CODE INTERNATIONAL_PACK_VOLUME_CODE 34 VARCHAR 16777216   NO YES NO NO
MDM_CANONICAL P_MED_PRODUCT PRODUCT MASTER PRODUCT MASTER COMBINATION_PACK_STATUS COMBINATION_PACK_STATUS 35 VARCHAR 16777216   NO YES NO NO
MDM_CANONICAL P_MED_PRODUCT PRODUCT MASTER PRODUCT MASTER PACK_INDICATOR PACK_INDICATOR 36 VARCHAR 16777216   NO YES NO NO
MDM_CANONICAL P_MED_PRODUCT PRODUCT MASTER PRODUCT MASTER PACK_STRENGTH_UOM PACK_STRENGTH_UOM 37 VARCHAR 16777216   NO YES NO NO
MDM_CANONICAL P_MED_PRODUCT PRODUCT MASTER PRODUCT MASTER PACK_STRENGTH_MEASURE PACK_STRENGTH_MEASURE 38 VARCHAR 16777216   NO YES NO NO
MDM_CANONICAL P_MED_PRODUCT PRODUCT MASTER PRODUCT MASTER PACK_GAUGE_UOM PACK_GAUGE_UOM 39 VARCHAR 16777216   NO YES NO NO
MDM_CANONICAL P_MED_PRODUCT PRODUCT MASTER PRODUCT MASTER PACK_GAUGE_MEASURE PACK_GAUGE_MEASURE 40 VARCHAR 16777216   NO YES NO NO
MDM_CANONICAL P_MED_PRODUCT PRODUCT MASTER PRODUCT MASTER PACK_VOLUME_WEIGHT_UOM PACK_VOLUME_WEIGHT_UOM 41 VARCHAR 16777216   NO YES NO NO
MDM_CANONICAL P_MED_PRODUCT PRODUCT MASTER PRODUCT MASTER PACK_VOLUME_WEIGHT_MEASURE PACK_VOLUME_WEIGHT_MEASURE 42 VARCHAR 16777216   NO YES NO NO
MDM_CANONICAL P_MED_PRODUCT PRODUCT MASTER PRODUCT MASTER PACKAGE_TYPE PACKAGE_TYPE 43 VARCHAR 16777216   NO YES NO NO
MDM_CANONICAL P_MED_PRODUCT PRODUCT MASTER PRODUCT MASTER PACKAGE_COUNT PACKAGE_COUNT 44 VARCHAR 16777216   NO YES NO NO
MDM_CANONICAL P_MED_PRODUCT PRODUCT MASTER PRODUCT MASTER PACKAGE_LENGTH PACKAGE_LENGTH 45 VARCHAR 16777216   NO YES NO NO
MDM_CANONICAL P_MED_PRODUCT PRODUCT MASTER PRODUCT MASTER PACKAGE_WIDTH PACKAGE_WIDTH 46 VARCHAR 16777216   NO YES NO NO
MDM_CANONICAL P_MED_PRODUCT PRODUCT MASTER PRODUCT MASTER PACKAGE_HEIGHT PACKAGE_HEIGHT 47 VARCHAR 16777216   NO YES NO NO
MDM_CANONICAL P_MED_PRODUCT PRODUCT MASTER PRODUCT MASTER INDICATOR_OF_NEW_PACKSIZE INDICATOR_OF_NEW_PACKSIZE 48 VARCHAR 16777216   NO YES NO NO
MDM_CANONICAL P_MED_PRODUCT PRODUCT MASTER PRODUCT MASTER PATENT_TYPE PATENT_TYPE 49 VARCHAR 16777216   NO YES NO NO
MDM_CANONICAL P_MED_PRODUCT PRODUCT MASTER PRODUCT MASTER PATENT_STATUS PATENT_STATUS 50 VARCHAR 16777216   NO YES NO NO
MDM_CANONICAL P_MED_PRODUCT PRODUCT MASTER PRODUCT MASTER PATENT_EXPIRY PATENT_EXPIRY 51 VARCHAR 16777216   NO YES NO NO
MDM_CANONICAL P_MED_PRODUCT PRODUCT MASTER PRODUCT MASTER PRODUCT_STATUS PRODUCT_STATUS 52 VARCHAR 16777216   NO YES NO NO
MDM_CANONICAL P_MED_PRODUCT PRODUCT MASTER PRODUCT MASTER PRODUCT_STATUS_CHANGE_DATE PRODUCT_STATUS_CHANGE_DATE 53 TIMESTAMP_LTZ     NO YES NO NO
MDM_CANONICAL P_MED_PRODUCT PRODUCT MASTER PRODUCT MASTER IS_REGISTERED IS_REGISTERED 54 VARCHAR 16777216   NO YES NO NO
MDM_CANONICAL P_MED_PRODUCT PRODUCT MASTER PRODUCT MASTER FRANCE_PRESCRIPTION_STATUS FRANCE_PRESCRIPTION_STATUS 55 VARCHAR 16777216   NO YES NO NO
MDM_CANONICAL P_MED_PRODUCT PRODUCT MASTER PRODUCT MASTER CHEMICAL_COMPOSITION CHEMICAL_COMPOSITION 56 VARCHAR 16777216   NO YES NO NO
MDM_CANONICAL P_MED_PRODUCT PRODUCT MASTER PRODUCT MASTER CHEMICAL_SALT CHEMICAL_SALT 57 VARCHAR 16777216   NO YES NO NO
MDM_CANONICAL P_MED_PRODUCT PRODUCT MASTER PRODUCT MASTER DOSAGE_UNIT_FACTOR DOSAGE_UNIT_FACTOR 58 NUMBER   0 NO YES NO NO
MDM_CANONICAL P_MED_PRODUCT PRODUCT MASTER PRODUCT MASTER INTERNATIONAL_PRODUCT_LAUNCH_DATE INTERNATIONAL_PRODUCT_LAUNCH_DATE 59 TIMESTAMP_LTZ     NO YES NO NO
MDM_CANONICAL P_MED_PRODUCT PRODUCT MASTER PRODUCT MASTER INTERNATIONAL_PRODUCT_CODE INTERNATIONAL_PRODUCT_CODE 60 VARCHAR 16777216   NO YES NO NO
MDM_CANONICAL P_MED_PRODUCT PRODUCT MASTER PRODUCT MASTER THERAPY_TYPE THERAPY_TYPE 61 VARCHAR 16777216   NO YES NO NO
MDM_CANONICAL P_MED_PRODUCT PRODUCT MASTER PRODUCT MASTER PRODUCT_STRENGTH_DESCRIPTION PRODUCT_STRENGTH_DESCRIPTION 62 VARCHAR 16777216   NO YES NO NO
MDM_CANONICAL P_MED_PRODUCT PRODUCT MASTER PRODUCT MASTER PRODUCT_STRENGTH_UOM PRODUCT_STRENGTH_UOM 63 VARCHAR 16777216   NO YES NO NO
MDM_CANONICAL P_MED_PRODUCT PRODUCT MASTER PRODUCT MASTER PRODUCT_STRENGTH_PER_UNIT PRODUCT_STRENGTH_PER_UNIT 64 VARCHAR 16777216   NO YES NO NO
MDM_CANONICAL P_MED_PRODUCT PRODUCT MASTER PRODUCT MASTER INTERNATIONAL_PRODUCT_STRENGTH INTERNATIONAL_PRODUCT_STRENGTH 65 VARCHAR 16777216   NO YES NO NO
MDM_CANONICAL P_MED_PRODUCT PRODUCT MASTER PRODUCT MASTER PARALLEL_IMPORT_STATUS PARALLEL_IMPORT_STATUS 66 VARCHAR 16777216   NO YES NO NO
MDM_CANONICAL P_MED_PRODUCT PRODUCT MASTER PRODUCT MASTER PRODUCT_SHAPE PRODUCT_SHAPE 67 VARCHAR 16777216   NO YES NO NO
MDM_CANONICAL P_MED_PRODUCT PRODUCT MASTER PRODUCT MASTER COLOR COLOR 68 VARCHAR 16777216   NO YES NO NO
MDM_CANONICAL P_MED_PRODUCT PRODUCT MASTER PRODUCT MASTER SINGLE_USE_OR_REUSE SINGLE_USE_OR_REUSE 69 VARCHAR 16777216   NO YES NO NO
MDM_CANONICAL P_MED_PRODUCT PRODUCT MASTER PRODUCT MASTER FLAVOR FLAVOR 70 VARCHAR 16777216   NO YES NO NO
MDM_CANONICAL P_MED_PRODUCT PRODUCT MASTER PRODUCT MASTER PROMOTIONAL_FLAG PROMOTIONAL_FLAG 71 VARCHAR 16777216   NO YES NO NO
MDM_CANONICAL P_MED_PRODUCT PRODUCT MASTER PRODUCT MASTER IS_CLIENT_PRODUCT IS_CLIENT_PRODUCT 72 VARCHAR 16777216   NO YES NO NO
MDM_CANONICAL P_MED_PRODUCT PRODUCT MASTER PRODUCT MASTER PRODUCT_OF_OF_INTEREST PRODUCT_OF_OF_INTEREST 73 VARCHAR 16777216   NO YES NO NO
MDM_CANONICAL P_MED_PRODUCT PRODUCT MASTER PRODUCT MASTER INDICATOR_OF_NEW_PRODUCT INDICATOR_OF_NEW_PRODUCT 74 VARCHAR 16777216   NO YES NO NO
MDM_CANONICAL P_MED_PRODUCT PRODUCT MASTER PRODUCT MASTER PACKAGE_VOLUME PACKAGE_VOLUME 75 VARCHAR 16777216   NO YES NO NO
MDM_CANONICAL P_MED_PRODUCT PRODUCT MASTER PRODUCT MASTER PACKAGE_AGE PACKAGE_AGE 76 VARCHAR 16777216   NO YES NO NO
MDM_CANONICAL P_MED_PRODUCT PRODUCT MASTER PRODUCT MASTER PACK_LAUNCH_YEAR PACK_LAUNCH_YEAR 77 VARCHAR 16777216   NO YES NO NO
MDM_CANONICAL P_MED_PRODUCT PRODUCT MASTER PRODUCT MASTER BIO_SIMILAR_PRODUCT BIO_SIMILAR_PRODUCT 78 VARCHAR 16777216   NO YES NO NO
MDM_CANONICAL P_MED_PRODUCT PRODUCT MASTER PRODUCT MASTER PRODUCT_SECTOR PRODUCT_SECTOR 79 VARCHAR 16777216   NO YES NO NO
MDM_CANONICAL P_MED_PRODUCT PRODUCT MASTER PRODUCT MASTER DOSE_FORM DOSE_FORM 80 VARCHAR 16777216   NO YES NO NO
MDM_CANONICAL P_MED_PRODUCT PRODUCT MASTER PRODUCT MASTER DOSE DOSE 81 VARCHAR 16777216   NO YES NO NO
MDM_CANONICAL P_MED_PRODUCT PRODUCT MASTER PRODUCT MASTER PRODUCT_SIZE PRODUCT_SIZE 82 VARCHAR 16777216   NO YES NO NO
MDM_CANONICAL P_MED_PRODUCT PRODUCT MASTER PRODUCT MASTER PRODUCT_WEIGHT PRODUCT_WEIGHT 83 VARCHAR 16777216   NO YES NO NO
MDM_CANONICAL P_MED_PRODUCT PRODUCT MASTER PRODUCT MASTER PRODUCT_LENGTH PRODUCT_LENGTH 84 VARCHAR 16777216   NO YES NO NO
MDM_CANONICAL P_MED_PRODUCT PRODUCT MASTER PRODUCT MASTER STATUS_OF_MARKETING STATUS_OF_MARKETING 85 VARCHAR 16777216   NO YES NO NO
MDM_CANONICAL P_MED_PRODUCT PRODUCT MASTER PRODUCT MASTER LEGAL_STATUS_OF_SUPPLY LEGAL_STATUS_OF_SUPPLY 86 VARCHAR 16777216   NO YES NO NO
MDM_CANONICAL P_MED_PRODUCT PRODUCT MASTER PRODUCT MASTER BATCH_NUMBER BATCH_NUMBER 87 NUMBER   0 NO YES NO NO
MDM_CANONICAL P_MED_PRODUCT PRODUCT MASTER PRODUCT MASTER EXPIRY_DATE EXPIRY_DATE 88 TIMESTAMP_LTZ     NO YES NO NO
MDM_CANONICAL P_MED_PRODUCT PRODUCT MASTER PRODUCT MASTER LIFECYCLE_STATUS LIFECYCLE_STATUS 89 VARCHAR 16777216   NO YES NO NO
MDM_CANONICAL P_MED_PRODUCT PRODUCT MASTER PRODUCT MASTER IS_INTERNAL_PRODUCT IS_INTERNAL_PRODUCT 90 VARCHAR 16777216   NO YES NO NO
MDM_CANONICAL P_MED_PRODUCT PRODUCT MASTER PRODUCT MASTER IS_GENERIC_PRODUCT IS_GENERIC_PRODUCT 91 VARCHAR 16777216   NO YES NO NO
MDM_CANONICAL P_MED_PRODUCT PRODUCT MASTER PRODUCT MASTER GENERIC_PRODUCT_TYPE GENERIC_PRODUCT_TYPE 92 VARCHAR 16777216   NO YES NO NO
MDM_CANONICAL P_MED_PRODUCT PRODUCT MASTER PRODUCT MASTER IS_PIPELINE_PRODUCT IS_PIPELINE_PRODUCT 93 VARCHAR 16777216   NO YES NO NO
MDM_CANONICAL P_MED_PRODUCT PRODUCT MASTER PRODUCT MASTER LANGUAGE LANGUAGE 94 VARCHAR 16777216   NO YES NO NO
MDM_CANONICAL P_MED_PRODUCT PRODUCT MASTER PRODUCT MASTER MIDASPANEL_CODE MIDASPANEL_CODE 95 VARCHAR 16777216   NO YES NO NO
MDM_CANONICAL P_MED_PRODUCT PRODUCT MASTER PRODUCT MASTER MIDASPANEL_NAME MIDASPANEL_NAME 96 VARCHAR 16777216   NO YES NO NO
MDM_CANONICAL P_MED_PRODUCT PRODUCT MASTER PRODUCT MASTER ALL_BIOCOMPARABLE_PRODUCT ALL_BIOCOMPARABLE_PRODUCT 97 VARCHAR 16777216   NO YES NO NO
MDM_CANONICAL P_MED_PRODUCT PRODUCT MASTER PRODUCT MASTER BIOCOMPARABLE_PRODUCT BIOCOMPARABLE_PRODUCT 98 VARCHAR 16777216   NO YES NO NO
MDM_CANONICAL P_MED_PRODUCT PRODUCT MASTER PRODUCT MASTER BIOLOGICAL_PRODUCTS BIOLOGICAL_PRODUCTS 99 VARCHAR 16777216   NO YES NO NO
MDM_CANONICAL P_MED_PRODUCT PRODUCT MASTER PRODUCT MASTER BIOSIMILAR_PRODUCT BIOSIMILAR_PRODUCT 100 VARCHAR 16777216   NO YES NO NO
MDM_CANONICAL P_MED_PRODUCT PRODUCT MASTER PRODUCT MASTER ESTIMATED_PROTECTION_EXPIRY_DATE ESTIMATED_PROTECTION_EXPIRY_DATE 101 VARCHAR 16777216   NO YES NO NO
MDM_CANONICAL P_MED_PRODUCT PRODUCT MASTER PRODUCT MASTER ESTIMATED_PROTECTION_EXPIRY_YEAR ESTIMATED_PROTECTION_EXPIRY_YEAR 102 VARCHAR 16777216   NO YES NO NO
MDM_CANONICAL P_MED_PRODUCT PRODUCT MASTER PRODUCT MASTER IMS_MIDAS_QUANTUM_PRODUCT_FORM3 IMS_MIDAS_QUANTUM_PRODUCT_FORM3 103 VARCHAR 16777216   NO YES NO NO
MDM_CANONICAL P_MED_PRODUCT PRODUCT MASTER PRODUCT MASTER INNOVATION_INSIGHTS INNOVATION_INSIGHTS 104 VARCHAR 16777216   NO YES NO NO
MDM_CANONICAL P_MED_PRODUCT PRODUCT MASTER PRODUCT MASTER INTERNATIONAL_NAME INTERNATIONAL_NAME 105 VARCHAR 16777216   NO YES NO NO
MDM_CANONICAL P_MED_PRODUCT PRODUCT MASTER PRODUCT MASTER INTERNATIONAL_PRODUCT_PANEL_CODE INTERNATIONAL_PRODUCT_PANEL_CODE 106 VARCHAR 16777216   NO YES NO NO
MDM_CANONICAL P_MED_PRODUCT PRODUCT MASTER PRODUCT MASTER INTERNATIONAL_FORM INTERNATIONAL_FORM 107 VARCHAR 16777216   NO YES NO NO
MDM_CANONICAL P_MED_PRODUCT PRODUCT MASTER PRODUCT MASTER PRODUCT_LICENSING_STATUS PRODUCT_LICENSING_STATUS 108 VARCHAR 16777216   NO YES NO NO
MDM_CANONICAL P_MED_PRODUCT PRODUCT MASTER PRODUCT MASTER LOCAL_REIMBURSEMENT_STATUS LOCAL_REIMBURSEMENT_STATUS 109 VARCHAR 16777216   NO YES NO NO
MDM_CANONICAL P_MED_PRODUCT PRODUCT MASTER PRODUCT MASTER NON_BIOCOMPARABLE_PRODUCT NON_BIOCOMPARABLE_PRODUCT 110 VARCHAR 16777216   NO YES NO NO
MDM_CANONICAL P_MED_PRODUCT PRODUCT MASTER PRODUCT MASTER PRODUCT_PLUS PRODUCT_PLUS 111 VARCHAR 16777216   NO YES NO NO
MDM_CANONICAL P_MED_PRODUCT PRODUCT MASTER PRODUCT MASTER PRE_POST_PROTECTION_EXPIRY PRE_POST_PROTECTION_EXPIRY 112 VARCHAR 16777216   NO YES NO NO
MDM_CANONICAL P_MED_PRODUCT PRODUCT MASTER PRODUCT MASTER PROTECTION PROTECTION 113 VARCHAR 16777216   NO YES NO NO
MDM_CANONICAL P_MED_PRODUCT PRODUCT MASTER PRODUCT MASTER SYS_CRT_DT SYS_CRT_DT 114 TIMESTAMP_LTZ     NO NO NO NO
MDM_CANONICAL P_MED_PRODUCT PRODUCT MASTER PRODUCT MASTER SYS_UPDT_DT SYS_UPDT_DT 115 TIMESTAMP_LTZ     NO NO NO NO
MDM_CANONICAL P_MED_PRODUCT PRODUCT MASTER PRODUCT MASTER SYS_EFF_DT SYS_EFF_DT 116 TIMESTAMP_LTZ     NO NO NO NO
MDM_CANONICAL P_MED_PRODUCT PRODUCT MASTER PRODUCT MASTER SYS_END_DT SYS_END_DT 117 TIMESTAMP_LTZ     NO NO NO NO
MDM_CANONICAL P_MED_PRODUCT PRODUCT MASTER PRODUCT MASTER SYS_CRT_BY SYS_CRT_BY 118 VARCHAR 16777216   NO NO NO NO
MDM_CANONICAL P_MED_PRODUCT PRODUCT MASTER PRODUCT MASTER SYS_UPDT_BY SYS_UPDT_BY 119 VARCHAR 16777216   NO NO NO NO
MDM_CANONICAL P_MED_PRODUCT PRODUCT MASTER PRODUCT MASTER BF_ID BF_ID 120 VARCHAR 16777216   NO NO NO NO
MDM_CANONICAL P_MED_PRODUCT_ALT_NAME PRODUCT MASTER PRODUCT MASTER MED_PRODUCT_ALT_NAME_ID MED_PRODUCT_ALT_NAME_ID 1 VARCHAR 16777216   NO NO YES YES
MDM_CANONICAL P_MED_PRODUCT_ALT_NAME PRODUCT MASTER PRODUCT MASTER PRODUCT_ID PRODUCT_ID 2 VARCHAR 16777216   NO YES NO NO
MDM_CANONICAL P_MED_PRODUCT_ALT_NAME PRODUCT MASTER PRODUCT MASTER TYPE TYPE 3 VARCHAR 16777216   NO YES NO NO
MDM_CANONICAL P_MED_PRODUCT_ALT_NAME PRODUCT MASTER PRODUCT MASTER LANGUAGE LANGUAGE 4 VARCHAR 16777216   NO YES NO NO
MDM_CANONICAL P_MED_PRODUCT_ALT_NAME PRODUCT MASTER PRODUCT MASTER NAME NAME 5 VARCHAR 16777216   NO YES NO NO
MDM_CANONICAL P_MED_PRODUCT_ALT_NAME PRODUCT MASTER PRODUCT MASTER SYS_CRT_DT SYS_CRT_DT 6 TIMESTAMP_LTZ     NO NO NO NO
MDM_CANONICAL P_MED_PRODUCT_ALT_NAME PRODUCT MASTER PRODUCT MASTER SYS_UPDT_DT SYS_UPDT_DT 7 TIMESTAMP_LTZ     NO NO NO NO
MDM_CANONICAL P_MED_PRODUCT_ALT_NAME PRODUCT MASTER PRODUCT MASTER SYS_EFF_DT SYS_EFF_DT 8 TIMESTAMP_LTZ     NO NO NO NO
MDM_CANONICAL P_MED_PRODUCT_ALT_NAME PRODUCT MASTER PRODUCT MASTER SYS_END_DT SYS_END_DT 9 TIMESTAMP_LTZ     NO NO NO NO
MDM_CANONICAL P_MED_PRODUCT_ALT_NAME PRODUCT MASTER PRODUCT MASTER SYS_CRT_BY SYS_CRT_BY 10 VARCHAR 16777216   NO NO NO NO
MDM_CANONICAL P_MED_PRODUCT_ALT_NAME PRODUCT MASTER PRODUCT MASTER SYS_UPDT_BY SYS_UPDT_BY 11 VARCHAR 16777216   NO NO NO NO
MDM_CANONICAL P_MED_PRODUCT_CLASS PRODUCT MASTER PRODUCT MASTER MED_PRODUCT_CLASS_ID MED_PRODUCT_CLASS_ID 1 VARCHAR 16777216   NO NO YES YES
MDM_CANONICAL P_MED_PRODUCT_CLASS PRODUCT MASTER PRODUCT MASTER PRODUCT_ID PRODUCT_ID 2 VARCHAR 16777216   NO YES NO NO
MDM_CANONICAL P_MED_PRODUCT_CLASS PRODUCT MASTER PRODUCT MASTER PRODUCT_CLASSIFICATION_TYPE PRODUCT_CLASSIFICATION_TYPE 3 VARCHAR 16777216   NO YES NO NO
MDM_CANONICAL P_MED_PRODUCT_CLASS PRODUCT MASTER PRODUCT MASTER PRODUCT_CLASSIFICATION_CODE PRODUCT_CLASSIFICATION_CODE 4 VARCHAR 16777216   NO YES NO NO
MDM_CANONICAL P_MED_PRODUCT_CLASS PRODUCT MASTER PRODUCT MASTER PRODUCT_CLASSIFICATION_DESCRIPTION PRODUCT_CLASSIFICATION_DESCRIPTION 5 VARCHAR 16777216   NO YES NO NO
MDM_CANONICAL P_MED_PRODUCT_CLASS PRODUCT MASTER PRODUCT MASTER PRODUCT_CLASSIFICATION_LEVEL PRODUCT_CLASSIFICATION_LEVEL 6 VARCHAR 16777216   NO YES NO NO
MDM_CANONICAL P_MED_PRODUCT_CLASS PRODUCT MASTER PRODUCT MASTER SYS_CRT_DT SYS_CRT_DT 7 TIMESTAMP_LTZ     NO NO NO NO
MDM_CANONICAL P_MED_PRODUCT_CLASS PRODUCT MASTER PRODUCT MASTER SYS_UPDT_DT SYS_UPDT_DT 8 TIMESTAMP_LTZ     NO NO NO NO
MDM_CANONICAL P_MED_PRODUCT_CLASS PRODUCT MASTER PRODUCT MASTER SYS_EFF_DT SYS_EFF_DT 9 TIMESTAMP_LTZ     NO NO NO NO
MDM_CANONICAL P_MED_PRODUCT_CLASS PRODUCT MASTER PRODUCT MASTER SYS_END_DT SYS_END_DT 10 TIMESTAMP_LTZ     NO NO NO NO
MDM_CANONICAL P_MED_PRODUCT_CLASS PRODUCT MASTER PRODUCT MASTER SYS_CRT_BY SYS_CRT_BY 11 VARCHAR 16777216   NO NO NO NO
MDM_CANONICAL P_MED_PRODUCT_CLASS PRODUCT MASTER PRODUCT MASTER SYS_UPDT_BY SYS_UPDT_BY 12 VARCHAR 16777216   NO NO NO NO
MDM_CANONICAL P_MED_PRODUCT_CORPORATION PRODUCT MASTER PRODUCT MASTER MED_PRODUCT_CORPORATION_ID MED_PRODUCT_CORPORATION_ID 1 VARCHAR 16777216   NO NO YES YES
MDM_CANONICAL P_MED_PRODUCT_CORPORATION PRODUCT MASTER PRODUCT MASTER PRODUCT_ID PRODUCT_ID 2 VARCHAR 16777216   NO YES NO NO
MDM_CANONICAL P_MED_PRODUCT_CORPORATION PRODUCT MASTER PRODUCT MASTER CORPORATION_CODE CORPORATION_CODE 3 VARCHAR 16777216   NO YES NO NO
MDM_CANONICAL P_MED_PRODUCT_CORPORATION PRODUCT MASTER PRODUCT MASTER WHOLE_SALE_FLAG WHOLE_SALE_FLAG 4 VARCHAR 16777216   NO YES NO NO
MDM_CANONICAL P_MED_PRODUCT_CORPORATION PRODUCT MASTER PRODUCT MASTER CORPORATION_OWNERSHIP CORPORATION_OWNERSHIP 5 VARCHAR 16777216   NO YES NO NO
MDM_CANONICAL P_MED_PRODUCT_CORPORATION PRODUCT MASTER PRODUCT MASTER CORPORATION_NAME CORPORATION_NAME 6 VARCHAR 16777216   NO YES NO NO
MDM_CANONICAL P_MED_PRODUCT_CORPORATION PRODUCT MASTER PRODUCT MASTER CORPORATION_NATIONALITY CORPORATION_NATIONALITY 7 VARCHAR 16777216   NO YES NO NO
MDM_CANONICAL P_MED_PRODUCT_CORPORATION PRODUCT MASTER PRODUCT MASTER SYS_CRT_DT SYS_CRT_DT 8 TIMESTAMP_LTZ     NO NO NO NO
MDM_CANONICAL P_MED_PRODUCT_CORPORATION PRODUCT MASTER PRODUCT MASTER SYS_UPDT_DT SYS_UPDT_DT 9 TIMESTAMP_LTZ     NO NO NO NO
MDM_CANONICAL P_MED_PRODUCT_CORPORATION PRODUCT MASTER PRODUCT MASTER SYS_EFF_DT SYS_EFF_DT 10 TIMESTAMP_LTZ     NO NO NO NO
MDM_CANONICAL P_MED_PRODUCT_CORPORATION PRODUCT MASTER PRODUCT MASTER SYS_END_DT SYS_END_DT 11 TIMESTAMP_LTZ     NO NO NO NO
MDM_CANONICAL P_MED_PRODUCT_CORPORATION PRODUCT MASTER PRODUCT MASTER SYS_CRT_BY SYS_CRT_BY 12 VARCHAR 16777216   NO NO NO NO
MDM_CANONICAL P_MED_PRODUCT_CORPORATION PRODUCT MASTER PRODUCT MASTER SYS_UPDT_BY SYS_UPDT_BY 13 VARCHAR 16777216   NO NO NO NO
MDM_CANONICAL P_MED_PRODUCT_GENERIC PRODUCT MASTER PRODUCT MASTER MED_PRODUCT_GENERIC_ID MED_PRODUCT_GENERIC_ID 1 VARCHAR 16777216   NO NO YES YES
MDM_CANONICAL P_MED_PRODUCT_GENERIC PRODUCT MASTER PRODUCT MASTER PRODUCT_ID PRODUCT_ID 2 VARCHAR 16777216   NO YES NO NO
MDM_CANONICAL P_MED_PRODUCT_GENERIC PRODUCT MASTER PRODUCT MASTER GENERIC_TRADE_NAME_CODE GENERIC_TRADE_NAME_CODE 3 VARCHAR 16777216   NO YES NO NO
MDM_CANONICAL P_MED_PRODUCT_GENERIC PRODUCT MASTER PRODUCT MASTER GENERIC_TRADE_NAME_DESCRIPTION GENERIC_TRADE_NAME_DESCRIPTION 4 VARCHAR 16777216   NO YES NO NO
MDM_CANONICAL P_MED_PRODUCT_GENERIC PRODUCT MASTER PRODUCT MASTER PACK_GENERIC_DESCRIPTION PACK_GENERIC_DESCRIPTION 5 VARCHAR 16777216   NO YES NO NO
MDM_CANONICAL P_MED_PRODUCT_GENERIC PRODUCT MASTER PRODUCT MASTER BRAND_GENERIC_IND BRAND_GENERIC_IND 6 VARCHAR 16777216   NO YES NO NO
MDM_CANONICAL P_MED_PRODUCT_GENERIC PRODUCT MASTER PRODUCT MASTER GENERIC_OFFICIAL GENERIC_OFFICIAL 7 VARCHAR 16777216   NO YES NO NO
MDM_CANONICAL P_MED_PRODUCT_GENERIC PRODUCT MASTER PRODUCT MASTER ORIGINAL_GENERIC_LINK ORIGINAL_GENERIC_LINK 8 VARCHAR 16777216   NO YES NO NO
MDM_CANONICAL P_MED_PRODUCT_GENERIC PRODUCT MASTER PRODUCT MASTER GENERIC_DRUG_GROUP GENERIC_DRUG_GROUP 9 VARCHAR 16777216   NO YES NO NO
MDM_CANONICAL P_MED_PRODUCT_GENERIC PRODUCT MASTER PRODUCT MASTER GENERIC_DRUG_REFERRAL_AGENT GENERIC_DRUG_REFERRAL_AGENT 10 VARCHAR 16777216   NO YES NO NO
MDM_CANONICAL P_MED_PRODUCT_GENERIC PRODUCT MASTER PRODUCT MASTER GENERIC_DRUG_LIST_DATE GENERIC_DRUG_LIST_DATE 11 TIMESTAMP_LTZ     NO YES NO NO
MDM_CANONICAL P_MED_PRODUCT_GENERIC PRODUCT MASTER PRODUCT MASTER DATE_GENERIC_GROUP_ENTERS_CATALOGUE DATE_GENERIC_GROUP_ENTERS_CATALOGUE 12 TIMESTAMP_LTZ     NO YES NO NO
MDM_CANONICAL P_MED_PRODUCT_GENERIC PRODUCT MASTER PRODUCT MASTER GENERIC_INDICATOR_OF_BRAND_OR_INN GENERIC_INDICATOR_OF_BRAND_OR_INN 13 VARCHAR 16777216   NO YES NO NO
MDM_CANONICAL P_MED_PRODUCT_GENERIC PRODUCT MASTER PRODUCT MASTER GENERIC_GROUP_INDICATOR GENERIC_GROUP_INDICATOR 14 VARCHAR 16777216   NO YES NO NO
MDM_CANONICAL P_MED_PRODUCT_GENERIC PRODUCT MASTER PRODUCT MASTER GENERIC_ORIGINATOR_CODE GENERIC_ORIGINATOR_CODE 15 VARCHAR 16777216   NO YES NO NO
MDM_CANONICAL P_MED_PRODUCT_GENERIC PRODUCT MASTER PRODUCT MASTER GENERIC_ORIGINATOR_DESCRIPTION GENERIC_ORIGINATOR_DESCRIPTION 16 VARCHAR 16777216   NO YES NO NO
MDM_CANONICAL P_MED_PRODUCT_GENERIC PRODUCT MASTER PRODUCT MASTER GENERIC_SOURCE_CODE GENERIC_SOURCE_CODE 17 VARCHAR 16777216   NO YES NO NO
MDM_CANONICAL P_MED_PRODUCT_GENERIC PRODUCT MASTER PRODUCT MASTER GENERIC_SOURCE_DESCRIPTION GENERIC_SOURCE_DESCRIPTION 18 VARCHAR 16777216   NO YES NO NO
MDM_CANONICAL P_MED_PRODUCT_GENERIC PRODUCT MASTER PRODUCT MASTER SYS_CRT_DT SYS_CRT_DT 19 TIMESTAMP_LTZ     NO NO NO NO
MDM_CANONICAL P_MED_PRODUCT_GENERIC PRODUCT MASTER PRODUCT MASTER SYS_UPDT_DT SYS_UPDT_DT 20 TIMESTAMP_LTZ     NO NO NO NO
MDM_CANONICAL P_MED_PRODUCT_GENERIC PRODUCT MASTER PRODUCT MASTER SYS_EFF_DT SYS_EFF_DT 21 TIMESTAMP_LTZ     NO NO NO NO
MDM_CANONICAL P_MED_PRODUCT_GENERIC PRODUCT MASTER PRODUCT MASTER SYS_END_DT SYS_END_DT 22 TIMESTAMP_LTZ     NO NO NO NO
MDM_CANONICAL P_MED_PRODUCT_GENERIC PRODUCT MASTER PRODUCT MASTER SYS_CRT_BY SYS_CRT_BY 23 VARCHAR 16777216   NO NO NO NO
MDM_CANONICAL P_MED_PRODUCT_GENERIC PRODUCT MASTER PRODUCT MASTER SYS_UPDT_BY SYS_UPDT_BY 24 VARCHAR 16777216   NO NO NO NO
MDM_CANONICAL P_MED_PRODUCT_INT_CLASS PRODUCT MASTER PRODUCT MASTER MED_PRODUCT_INT_CLASS_ID MED_PRODUCT_INT_CLASS_ID 1 VARCHAR 16777216   NO NO YES YES
MDM_CANONICAL P_MED_PRODUCT_INT_CLASS PRODUCT MASTER PRODUCT MASTER PRODUCT_ID PRODUCT_ID 2 VARCHAR 16777216   NO YES NO NO
MDM_CANONICAL P_MED_PRODUCT_INT_CLASS PRODUCT MASTER PRODUCT MASTER INTERNATIONAL_CLASSIFICATION_TYPE INTERNATIONAL_CLASSIFICATION_TYPE 3 VARCHAR 16777216   NO YES NO NO
MDM_CANONICAL P_MED_PRODUCT_INT_CLASS PRODUCT MASTER PRODUCT MASTER INTERNATIONAL_CLASSIFICATION_CODE INTERNATIONAL_CLASSIFICATION_CODE 4 VARCHAR 16777216   NO YES NO NO
MDM_CANONICAL P_MED_PRODUCT_INT_CLASS PRODUCT MASTER PRODUCT MASTER INTERNATIONAL_CLASSIFICATION_DESCRIPTION INTERNATIONAL_CLASSIFICATION_DESCRIPTION 5 VARCHAR 16777216   NO YES NO NO
MDM_CANONICAL P_MED_PRODUCT_INT_CLASS PRODUCT MASTER PRODUCT MASTER INTERNATIONAL_CLASSIFICATION_LEVEL INTERNATIONAL_CLASSIFICATION_LEVEL 6 VARCHAR 16777216   NO YES NO NO
MDM_CANONICAL P_MED_PRODUCT_INT_CLASS PRODUCT MASTER PRODUCT MASTER SYS_CRT_DT SYS_CRT_DT 7 TIMESTAMP_LTZ     NO NO NO NO
MDM_CANONICAL P_MED_PRODUCT_INT_CLASS PRODUCT MASTER PRODUCT MASTER SYS_UPDT_DT SYS_UPDT_DT 8 TIMESTAMP_LTZ     NO NO NO NO
MDM_CANONICAL P_MED_PRODUCT_INT_CLASS PRODUCT MASTER PRODUCT MASTER SYS_EFF_DT SYS_EFF_DT 9 TIMESTAMP_LTZ     NO NO NO NO
MDM_CANONICAL P_MED_PRODUCT_INT_CLASS PRODUCT MASTER PRODUCT MASTER SYS_END_DT SYS_END_DT 10 TIMESTAMP_LTZ     NO NO NO NO
MDM_CANONICAL P_MED_PRODUCT_INT_CLASS PRODUCT MASTER PRODUCT MASTER SYS_CRT_BY SYS_CRT_BY 11 VARCHAR 16777216   NO NO NO NO
MDM_CANONICAL P_MED_PRODUCT_INT_CLASS PRODUCT MASTER PRODUCT MASTER SYS_UPDT_BY SYS_UPDT_BY 12 VARCHAR 16777216   NO NO NO NO
MDM_CANONICAL P_MED_PRODUCT_MOLECULE PRODUCT MASTER PRODUCT MASTER MED_PRODUCT_MOLECULE_ID MED_PRODUCT_MOLECULE_ID 1 VARCHAR 16777216   NO NO YES YES
MDM_CANONICAL P_MED_PRODUCT_MOLECULE PRODUCT MASTER PRODUCT MASTER PRODUCT_ID PRODUCT_ID 2 VARCHAR 16777216   NO YES NO NO
MDM_CANONICAL P_MED_PRODUCT_MOLECULE PRODUCT MASTER PRODUCT MASTER MOLECULE_ID MOLECULE_ID 3 VARCHAR 16777216   NO YES NO NO
MDM_CANONICAL P_MED_PRODUCT_MOLECULE PRODUCT MASTER PRODUCT MASTER MOLECULE_NAME MOLECULE_NAME 4 VARCHAR 16777216   NO YES NO NO
MDM_CANONICAL P_MED_PRODUCT_MOLECULE PRODUCT MASTER PRODUCT MASTER CHEMICAL_SALT CHEMICAL_SALT 5 VARCHAR 16777216   NO YES NO NO
MDM_CANONICAL P_MED_PRODUCT_MOLECULE PRODUCT MASTER PRODUCT MASTER CHEMICAL_FAMILY CHEMICAL_FAMILY 6 VARCHAR 16777216   NO YES NO NO
MDM_CANONICAL P_MED_PRODUCT_MOLECULE PRODUCT MASTER PRODUCT MASTER CHEMICAL_SUBFAMILY CHEMICAL_SUBFAMILY 7 VARCHAR 16777216   NO YES NO NO
MDM_CANONICAL P_MED_PRODUCT_MOLECULE PRODUCT MASTER PRODUCT MASTER MOLECULE_COUNT MOLECULE_COUNT 8 NUMBER   0 NO YES NO NO
MDM_CANONICAL P_MED_PRODUCT_MOLECULE PRODUCT MASTER PRODUCT MASTER MOLECULE_LIST MOLECULE_LIST 9 VARCHAR 16777216   NO YES NO NO
MDM_CANONICAL P_MED_PRODUCT_MOLECULE PRODUCT MASTER PRODUCT MASTER MOLECULE_LAUNCH_DATE MOLECULE_LAUNCH_DATE 10 TIMESTAMP_LTZ     NO YES NO NO
MDM_CANONICAL P_MED_PRODUCT_MOLECULE PRODUCT MASTER PRODUCT MASTER MOLECULE_CORPORATION MOLECULE_CORPORATION 11 VARCHAR 16777216   NO YES NO NO
MDM_CANONICAL P_MED_PRODUCT_MOLECULE PRODUCT MASTER PRODUCT MASTER MOLECULE_FIRST_LAUNCH_COUNTRY MOLECULE_FIRST_LAUNCH_COUNTRY 12 VARCHAR 16777216   NO YES NO NO
MDM_CANONICAL P_MED_PRODUCT_MOLECULE PRODUCT MASTER PRODUCT MASTER BIOLOGICAL_MOLECULE BIOLOGICAL_MOLECULE 13 VARCHAR 16777216   NO YES NO NO
MDM_CANONICAL P_MED_PRODUCT_MOLECULE PRODUCT MASTER PRODUCT MASTER CHEMICAL_WEIGHT CHEMICAL_WEIGHT 14 VARCHAR 16777216   NO YES NO NO
MDM_CANONICAL P_MED_PRODUCT_MOLECULE PRODUCT MASTER PRODUCT MASTER SYS_CRT_DT SYS_CRT_DT 15 TIMESTAMP_LTZ     NO NO NO NO
MDM_CANONICAL P_MED_PRODUCT_MOLECULE PRODUCT MASTER PRODUCT MASTER SYS_UPDT_DT SYS_UPDT_DT 16 TIMESTAMP_LTZ     NO NO NO NO
MDM_CANONICAL P_MED_PRODUCT_MOLECULE PRODUCT MASTER PRODUCT MASTER SYS_EFF_DT SYS_EFF_DT 17 TIMESTAMP_LTZ     NO NO NO NO
MDM_CANONICAL P_MED_PRODUCT_MOLECULE PRODUCT MASTER PRODUCT MASTER SYS_END_DT SYS_END_DT 18 TIMESTAMP_LTZ     NO NO NO NO
MDM_CANONICAL P_MED_PRODUCT_MOLECULE PRODUCT MASTER PRODUCT MASTER SYS_CRT_BY SYS_CRT_BY 19 VARCHAR 16777216   NO NO NO NO
MDM_CANONICAL P_MED_PRODUCT_MOLECULE PRODUCT MASTER PRODUCT MASTER SYS_UPDT_BY SYS_UPDT_BY 20 VARCHAR 16777216   NO NO NO NO
MDM_CANONICAL P_MED_PRODUCT_REGULATED_DOCS PRODUCT MASTER PRODUCT MASTER MED_PRODUCT_REGUL_DOCS_ID MED_PRODUCT_REGUL_DOCS_ID 1 VARCHAR 16777216   NO NO YES YES
MDM_CANONICAL P_MED_PRODUCT_REGULATED_DOCS PRODUCT MASTER PRODUCT MASTER PRODUCT_ID PRODUCT_ID 2 VARCHAR 16777216   NO YES NO NO
MDM_CANONICAL P_MED_PRODUCT_REGULATED_DOCS PRODUCT MASTER PRODUCT MASTER DOCUMENT_TYPE DOCUMENT_TYPE 3 VARCHAR 16777216   NO YES NO NO
MDM_CANONICAL P_MED_PRODUCT_REGULATED_DOCS PRODUCT MASTER PRODUCT MASTER DOCUMENT_ID DOCUMENT_ID 4 VARCHAR 16777216   NO YES NO NO
MDM_CANONICAL P_MED_PRODUCT_REGULATED_DOCS PRODUCT MASTER PRODUCT MASTER REGULATED_DOC REGULATED_DOC 5 VARCHAR 16777216   NO YES NO NO
MDM_CANONICAL P_MED_PRODUCT_REGULATED_DOCS PRODUCT MASTER PRODUCT MASTER DOC_EFF_DATE DOC_EFF_DATE 6 TIMESTAMP_LTZ     NO YES NO NO
MDM_CANONICAL P_MED_PRODUCT_REGULATED_DOCS PRODUCT MASTER PRODUCT MASTER SYS_CRT_DT SYS_CRT_DT 7 TIMESTAMP_LTZ     NO NO NO NO
MDM_CANONICAL P_MED_PRODUCT_REGULATED_DOCS PRODUCT MASTER PRODUCT MASTER SYS_UPDT_DT SYS_UPDT_DT 8 TIMESTAMP_LTZ     NO NO NO NO
MDM_CANONICAL P_MED_PRODUCT_REGULATED_DOCS PRODUCT MASTER PRODUCT MASTER SYS_EFF_DT SYS_EFF_DT 9 TIMESTAMP_LTZ     NO NO NO NO
MDM_CANONICAL P_MED_PRODUCT_REGULATED_DOCS PRODUCT MASTER PRODUCT MASTER SYS_END_DT SYS_END_DT 10 TIMESTAMP_LTZ     NO NO NO NO
MDM_CANONICAL P_MED_PRODUCT_REGULATED_DOCS PRODUCT MASTER PRODUCT MASTER SYS_CRT_BY SYS_CRT_BY 11 VARCHAR 16777216   NO NO NO NO
MDM_CANONICAL P_MED_PRODUCT_REGULATED_DOCS PRODUCT MASTER PRODUCT MASTER SYS_UPDT_BY SYS_UPDT_BY 12 VARCHAR 16777216   NO NO NO NO
MDM_CANONICAL P_MED_PRODUCT_VERSION PRODUCT MASTER PRODUCT MASTER VERSION_ID VERSION_ID 1 VARCHAR 16777216   NO NO YES YES
MDM_CANONICAL P_MED_PRODUCT_VERSION PRODUCT MASTER PRODUCT MASTER PRODUCT_ID PRODUCT_ID 2 VARCHAR 16777216   NO YES NO NO
MDM_CANONICAL P_MED_PRODUCT_VERSION PRODUCT MASTER PRODUCT MASTER SRC_VERSION_ID SRC_VERSION_ID 3 VARCHAR 16777216   NO YES NO NO
MDM_CANONICAL P_MED_PRODUCT_VERSION PRODUCT MASTER PRODUCT MASTER VERSION_DATE VERSION_DATE 4 TIMESTAMP_LTZ     NO YES NO NO
MDM_CANONICAL P_MED_PRODUCT_VERSION PRODUCT MASTER PRODUCT MASTER SYS_CRT_DT SYS_CRT_DT 5 TIMESTAMP_LTZ     NO NO NO NO
MDM_CANONICAL P_MED_PRODUCT_VERSION PRODUCT MASTER PRODUCT MASTER SYS_UPDT_DT SYS_UPDT_DT 6 TIMESTAMP_LTZ     NO NO NO NO
MDM_CANONICAL P_MED_PRODUCT_VERSION PRODUCT MASTER PRODUCT MASTER SYS_EFF_DT SYS_EFF_DT 7 TIMESTAMP_LTZ     NO NO NO NO
MDM_CANONICAL P_MED_PRODUCT_VERSION PRODUCT MASTER PRODUCT MASTER SYS_END_DT SYS_END_DT 8 TIMESTAMP_LTZ     NO NO NO NO
MDM_CANONICAL P_MED_PRODUCT_VERSION PRODUCT MASTER PRODUCT MASTER SYS_CRT_BY SYS_CRT_BY 9 VARCHAR 16777216   NO NO NO NO
MDM_CANONICAL P_MED_PRODUCT_VERSION PRODUCT MASTER PRODUCT MASTER SYS_UPDT_BY SYS_UPDT_BY 10 VARCHAR 16777216   NO NO NO NO
MDM_CANONICAL P_PRODUCT PRODUCT MASTER PRODUCT MASTER PRODUCT_ID PRODUCT_ID 1 VARCHAR 16777216   NO NO YES YES
MDM_CANONICAL P_PRODUCT PRODUCT MASTER PRODUCT MASTER PRODUCT_TYPE PRODUCT_TYPE 2 VARCHAR 16777216   NO YES NO NO
MDM_CANONICAL P_PRODUCT PRODUCT MASTER PRODUCT MASTER MDM_URI MDM_URI 3 VARCHAR 16777216   NO YES NO NO
MDM_CANONICAL P_PRODUCT PRODUCT MASTER PRODUCT MASTER SOURCE_NAME SOURCE_NAME 4 VARCHAR 16777216   NO YES NO NO
MDM_CANONICAL P_PRODUCT PRODUCT MASTER PRODUCT MASTER SOURCE_ID SOURCE_ID 5 VARCHAR 16777216   NO YES NO NO
MDM_CANONICAL P_PRODUCT PRODUCT MASTER PRODUCT MASTER LOAD_STATUS LOAD_STATUS 6 VARCHAR 16777216   NO YES NO NO
MDM_CANONICAL P_PRODUCT PRODUCT MASTER PRODUCT MASTER PLUGIN_PROCESS_DT PLUGIN_PROCESS_DT 7 TIMESTAMP_LTZ     NO YES NO NO
MDM_CANONICAL P_PRODUCT PRODUCT MASTER PRODUCT MASTER LOAD_DETAILS LOAD_DETAILS 8 VARCHAR 16777216   NO YES NO NO
MDM_CANONICAL P_PRODUCT PRODUCT MASTER PRODUCT MASTER SRC_EFF_DT SRC_EFF_DT 9 TIMESTAMP_LTZ     NO YES NO NO
MDM_CANONICAL P_PRODUCT PRODUCT MASTER PRODUCT MASTER SRC_UPDT_DT SRC_UPDT_DT 10 TIMESTAMP_LTZ     NO YES NO NO
MDM_CANONICAL P_PRODUCT PRODUCT MASTER PRODUCT MASTER SRC_END_DT SRC_END_DT 11 TIMESTAMP_LTZ     NO YES NO NO
MDM_CANONICAL P_PRODUCT PRODUCT MASTER PRODUCT MASTER SYS_CRT_DT SYS_CRT_DT 12 TIMESTAMP_LTZ     NO NO NO NO
MDM_CANONICAL P_PRODUCT PRODUCT MASTER PRODUCT MASTER SYS_UPDT_DT SYS_UPDT_DT 13 TIMESTAMP_LTZ     NO NO NO NO
MDM_CANONICAL P_PRODUCT PRODUCT MASTER PRODUCT MASTER SYS_EFF_DT SYS_EFF_DT 14 TIMESTAMP_LTZ     NO NO NO NO
MDM_CANONICAL P_PRODUCT PRODUCT MASTER PRODUCT MASTER SYS_END_DT SYS_END_DT 15 TIMESTAMP_LTZ     NO NO NO NO
MDM_CANONICAL P_PRODUCT PRODUCT MASTER PRODUCT MASTER SYS_CRT_BY SYS_CRT_BY 16 VARCHAR 16777216   NO NO NO NO
MDM_CANONICAL P_PRODUCT PRODUCT MASTER PRODUCT MASTER SYS_UPDT_BY SYS_UPDT_BY 17 VARCHAR 16777216   NO NO NO NO
MDM_CANONICAL P_PRODUCT_GRP PRODUCT MASTER PRODUCT MASTER PRODUCT_GRP_ID PRODUCT_GRP_ID 1 VARCHAR 16777216   NO NO YES YES
MDM_CANONICAL P_PRODUCT_GRP PRODUCT MASTER PRODUCT MASTER PRODUCT_ID PRODUCT_ID 2 VARCHAR 16777216   NO YES NO NO
MDM_CANONICAL P_PRODUCT_GRP PRODUCT MASTER PRODUCT MASTER PRODUCT_TYPE PRODUCT_TYPE 3 VARCHAR 16777216   NO YES NO NO
MDM_CANONICAL P_PRODUCT_GRP PRODUCT MASTER PRODUCT MASTER NAME NAME 4 VARCHAR 16777216   NO YES NO NO
MDM_CANONICAL P_PRODUCT_GRP PRODUCT MASTER PRODUCT MASTER TYPE TYPE 5 VARCHAR 16777216   NO YES NO NO
MDM_CANONICAL P_PRODUCT_GRP PRODUCT MASTER PRODUCT MASTER START_DATE START_DATE 6 TIMESTAMP_LTZ     NO YES NO NO
MDM_CANONICAL P_PRODUCT_GRP PRODUCT MASTER PRODUCT MASTER END_DATE END_DATE 7 TIMESTAMP_LTZ     NO YES NO NO
MDM_CANONICAL P_PRODUCT_GRP PRODUCT MASTER PRODUCT MASTER STATUS STATUS 8 VARCHAR 16777216   NO YES NO NO
MDM_CANONICAL P_PRODUCT_GRP PRODUCT MASTER PRODUCT MASTER COUNTRY COUNTRY 9 VARCHAR 16777216   NO YES NO NO
MDM_CANONICAL P_PRODUCT_GRP PRODUCT MASTER PRODUCT MASTER PRODUCT_LAUNCH_DATE PRODUCT_LAUNCH_DATE 10 TIMESTAMP_LTZ     NO YES NO NO
MDM_CANONICAL P_PRODUCT_GRP PRODUCT MASTER PRODUCT MASTER SYS_CRT_DT SYS_CRT_DT 11 TIMESTAMP_LTZ     NO NO NO NO
MDM_CANONICAL P_PRODUCT_GRP PRODUCT MASTER PRODUCT MASTER SYS_UPDT_DT SYS_UPDT_DT 12 TIMESTAMP_LTZ     NO NO NO NO
MDM_CANONICAL P_PRODUCT_GRP PRODUCT MASTER PRODUCT MASTER SYS_EFF_DT SYS_EFF_DT 13 TIMESTAMP_LTZ     NO NO NO NO
MDM_CANONICAL P_PRODUCT_GRP PRODUCT MASTER PRODUCT MASTER SYS_END_DT SYS_END_DT 14 TIMESTAMP_LTZ     NO NO NO NO
MDM_CANONICAL P_PRODUCT_GRP PRODUCT MASTER PRODUCT MASTER SYS_CRT_BY SYS_CRT_BY 15 VARCHAR 16777216   NO NO NO NO
MDM_CANONICAL P_PRODUCT_GRP PRODUCT MASTER PRODUCT MASTER SYS_UPDT_BY SYS_UPDT_BY 16 VARCHAR 16777216   NO NO NO NO
MDM_CANONICAL P_PRODUCT_GRP PRODUCT MASTER PRODUCT MASTER BF_ID BF_ID 17 VARCHAR 16777216   NO NO NO NO
MDM_CANONICAL P_PRODUCT_IDENTIFIERS PRODUCT MASTER PRODUCT MASTER IDENTIFIER_ID IDENTIFIER_ID 1 VARCHAR 16777216   NO NO YES YES
MDM_CANONICAL P_PRODUCT_IDENTIFIERS PRODUCT MASTER PRODUCT MASTER PRODUCT_ID PRODUCT_ID 2 VARCHAR 16777216   NO YES NO NO
MDM_CANONICAL P_PRODUCT_IDENTIFIERS PRODUCT MASTER PRODUCT MASTER TYPE TYPE 3 VARCHAR 16777216   NO YES NO NO
MDM_CANONICAL P_PRODUCT_IDENTIFIERS PRODUCT MASTER PRODUCT MASTER LEVEL LEVEL 4 VARCHAR 16777216   NO YES NO NO
MDM_CANONICAL P_PRODUCT_IDENTIFIERS PRODUCT MASTER PRODUCT MASTER DESCRIPTION DESCRIPTION 5 VARCHAR 16777216   NO YES NO NO
MDM_CANONICAL P_PRODUCT_IDENTIFIERS PRODUCT MASTER PRODUCT MASTER STATUS STATUS 6 VARCHAR 16777216   NO YES NO NO
MDM_CANONICAL P_PRODUCT_IDENTIFIERS PRODUCT MASTER PRODUCT MASTER BRIDGE_CODE BRIDGE_CODE 7 VARCHAR 16777216   NO YES NO NO
MDM_CANONICAL P_PRODUCT_IDENTIFIERS PRODUCT MASTER PRODUCT MASTER BRIDGE_DESCRIPTION BRIDGE_DESCRIPTION 8 VARCHAR 16777216   NO YES NO NO
MDM_CANONICAL P_PRODUCT_IDENTIFIERS PRODUCT MASTER PRODUCT MASTER DEACTIVATION_REASON_CODE DEACTIVATION_REASON_CODE 9 VARCHAR 16777216   NO YES NO NO
MDM_CANONICAL P_PRODUCT_IDENTIFIERS PRODUCT MASTER PRODUCT MASTER ID ID 10 VARCHAR 16777216   NO YES NO NO
MDM_CANONICAL P_PRODUCT_IDENTIFIERS PRODUCT MASTER PRODUCT MASTER SYS_CRT_DT SYS_CRT_DT 11 TIMESTAMP_LTZ     NO NO NO NO
MDM_CANONICAL P_PRODUCT_IDENTIFIERS PRODUCT MASTER PRODUCT MASTER SYS_UPDT_DT SYS_UPDT_DT 12 TIMESTAMP_LTZ     NO NO NO NO
MDM_CANONICAL P_PRODUCT_IDENTIFIERS PRODUCT MASTER PRODUCT MASTER SYS_EFF_DT SYS_EFF_DT 13 TIMESTAMP_LTZ     NO NO NO NO
MDM_CANONICAL P_PRODUCT_IDENTIFIERS PRODUCT MASTER PRODUCT MASTER SYS_END_DT SYS_END_DT 14 TIMESTAMP_LTZ     NO NO NO NO
MDM_CANONICAL P_PRODUCT_IDENTIFIERS PRODUCT MASTER PRODUCT MASTER SYS_CRT_BY SYS_CRT_BY 15 VARCHAR 16777216   NO NO NO NO
MDM_CANONICAL P_PRODUCT_IDENTIFIERS PRODUCT MASTER PRODUCT MASTER SYS_UPDT_BY SYS_UPDT_BY 16 VARCHAR 16777216   NO NO NO NO
MDM_CANONICAL P_PRODUCT_JURISDICTION PRODUCT MASTER PRODUCT MASTER JURISDICTION_ID JURISDICTION_ID 1 VARCHAR 16777216   NO NO YES YES
MDM_CANONICAL P_PRODUCT_JURISDICTION PRODUCT MASTER PRODUCT MASTER PRODUCT_ID PRODUCT_ID 2 VARCHAR 16777216   NO YES NO NO
MDM_CANONICAL P_PRODUCT_JURISDICTION PRODUCT MASTER PRODUCT MASTER JURISDICTION_COUNTRY JURISDICTION_COUNTRY 3 VARCHAR 16777216   NO YES NO NO
MDM_CANONICAL P_PRODUCT_JURISDICTION PRODUCT MASTER PRODUCT MASTER JURISDICTION JURISDICTION 4 VARCHAR 16777216   NO YES NO NO
MDM_CANONICAL P_PRODUCT_JURISDICTION PRODUCT MASTER PRODUCT MASTER LANGUAGE LANGUAGE 5 VARCHAR 16777216   NO YES NO NO
MDM_CANONICAL P_PRODUCT_JURISDICTION PRODUCT MASTER PRODUCT MASTER SYS_CRT_DT SYS_CRT_DT 6 TIMESTAMP_LTZ     NO NO NO NO
MDM_CANONICAL P_PRODUCT_JURISDICTION PRODUCT MASTER PRODUCT MASTER SYS_UPDT_DT SYS_UPDT_DT 7 TIMESTAMP_LTZ     NO NO NO NO
MDM_CANONICAL P_PRODUCT_JURISDICTION PRODUCT MASTER PRODUCT MASTER SYS_EFF_DT SYS_EFF_DT 8 TIMESTAMP_LTZ     NO NO NO NO
MDM_CANONICAL P_PRODUCT_JURISDICTION PRODUCT MASTER PRODUCT MASTER SYS_END_DT SYS_END_DT 9 TIMESTAMP_LTZ     NO NO NO NO
MDM_CANONICAL P_PRODUCT_JURISDICTION PRODUCT MASTER PRODUCT MASTER SYS_CRT_BY SYS_CRT_BY 10 VARCHAR 16777216   NO NO NO NO
MDM_CANONICAL P_PRODUCT_JURISDICTION PRODUCT MASTER PRODUCT MASTER SYS_UPDT_BY SYS_UPDT_BY 11 VARCHAR 16777216   NO NO NO NO
MDM_CANONICAL P_PRODUCT_ORGANIZATION PRODUCT MASTER PRODUCT MASTER PRODUCT_ORGANIZATION_ID PRODUCT_ORGANIZATION_ID 1 VARCHAR 16777216   NO NO YES YES
MDM_CANONICAL P_PRODUCT_ORGANIZATION PRODUCT MASTER PRODUCT MASTER PRODUCT_ID PRODUCT_ID 2 VARCHAR 16777216   NO YES NO NO
MDM_CANONICAL P_PRODUCT_ORGANIZATION PRODUCT MASTER PRODUCT MASTER SRC_PRODUCT_ORGANIZATION_ID SRC_PRODUCT_ORGANIZATION_ID 3 VARCHAR 16777216   NO YES NO NO
MDM_CANONICAL P_PRODUCT_ORGANIZATION PRODUCT MASTER PRODUCT MASTER ORGANIZATION_TYPE ORGANIZATION_TYPE 4 VARCHAR 16777216   NO YES NO NO
MDM_CANONICAL P_PRODUCT_ORGANIZATION PRODUCT MASTER PRODUCT MASTER INTERNATIONAL_NAME INTERNATIONAL_NAME 5 VARCHAR 16777216   NO YES NO NO
MDM_CANONICAL P_PRODUCT_ORGANIZATION PRODUCT MASTER PRODUCT MASTER NAME NAME 6 VARCHAR 16777216   NO YES NO NO
MDM_CANONICAL P_PRODUCT_ORGANIZATION PRODUCT MASTER PRODUCT MASTER OWNER OWNER 7 VARCHAR 16777216   NO YES NO NO
MDM_CANONICAL P_PRODUCT_ORGANIZATION PRODUCT MASTER PRODUCT MASTER SHORT_NAME SHORT_NAME 8 VARCHAR 16777216   NO YES NO NO
MDM_CANONICAL P_PRODUCT_ORGANIZATION PRODUCT MASTER PRODUCT MASTER COMPANY_TYPE COMPANY_TYPE 9 VARCHAR 16777216   NO YES NO NO
MDM_CANONICAL P_PRODUCT_ORGANIZATION PRODUCT MASTER PRODUCT MASTER SYS_CRT_DT SYS_CRT_DT 10 TIMESTAMP_LTZ     NO NO NO NO
MDM_CANONICAL P_PRODUCT_ORGANIZATION PRODUCT MASTER PRODUCT MASTER SYS_UPDT_DT SYS_UPDT_DT 11 TIMESTAMP_LTZ     NO NO NO NO
MDM_CANONICAL P_PRODUCT_ORGANIZATION PRODUCT MASTER PRODUCT MASTER SYS_EFF_DT SYS_EFF_DT 12 TIMESTAMP_LTZ     NO NO NO NO
MDM_CANONICAL P_PRODUCT_ORGANIZATION PRODUCT MASTER PRODUCT MASTER SYS_END_DT SYS_END_DT 13 TIMESTAMP_LTZ     NO NO NO NO
MDM_CANONICAL P_PRODUCT_ORGANIZATION PRODUCT MASTER PRODUCT MASTER SYS_CRT_BY SYS_CRT_BY 14 VARCHAR 16777216   NO NO NO NO
MDM_CANONICAL P_PRODUCT_ORGANIZATION PRODUCT MASTER PRODUCT MASTER SYS_UPDT_BY SYS_UPDT_BY 15 VARCHAR 16777216   NO NO NO NO
MDM_CANONICAL P_PRODUCT_ORGANIZATION PRODUCT MASTER PRODUCT MASTER BF_ID BF_ID 16 VARCHAR 16777216   NO NO NO NO
MDM_CANONICAL P_PRODUCT_RELATIONS PRODUCT MASTER PRODUCT MASTER RELATION_ID RELATION_ID 1 VARCHAR 16777216   NO NO YES YES
MDM_CANONICAL P_PRODUCT_RELATIONS PRODUCT MASTER PRODUCT MASTER RELATION_TYPE RELATION_TYPE 2 VARCHAR 16777216   NO YES NO NO
MDM_CANONICAL P_PRODUCT_RELATIONS PRODUCT MASTER PRODUCT MASTER MDM_URI MDM_URI 3 VARCHAR 16777216   NO YES NO NO
MDM_CANONICAL P_PRODUCT_RELATIONS PRODUCT MASTER PRODUCT MASTER LOAD_STATUS LOAD_STATUS 4 VARCHAR 16777216   NO YES NO NO
MDM_CANONICAL P_PRODUCT_RELATIONS PRODUCT MASTER PRODUCT MASTER PLUGIN_PROCESS_DT PLUGIN_PROCESS_DT 5 TIMESTAMP_LTZ     NO YES NO NO
MDM_CANONICAL P_PRODUCT_RELATIONS PRODUCT MASTER PRODUCT MASTER LOAD_DETAILS LOAD_DETAILS 6 VARCHAR 16777216   NO YES NO NO
MDM_CANONICAL P_PRODUCT_RELATIONS PRODUCT MASTER PRODUCT MASTER SRC_AFFILIATION_ID SRC_AFFILIATION_ID 7 VARCHAR 16777216   NO YES NO NO
MDM_CANONICAL P_PRODUCT_RELATIONS PRODUCT MASTER PRODUCT MASTER SOURCE_NAME SOURCE_NAME 8 VARCHAR 16777216   NO YES NO NO
MDM_CANONICAL P_PRODUCT_RELATIONS PRODUCT MASTER PRODUCT MASTER START_PRODUCT_ID START_PRODUCT_ID 9 VARCHAR 16777216   NO YES NO NO
MDM_CANONICAL P_PRODUCT_RELATIONS PRODUCT MASTER PRODUCT MASTER START_PRODUCT_TYPE START_PRODUCT_TYPE 10 VARCHAR 16777216   NO YES NO NO
MDM_CANONICAL P_PRODUCT_RELATIONS PRODUCT MASTER PRODUCT MASTER END_PRODUCT_ID END_PRODUCT_ID 11 VARCHAR 16777216   NO YES NO NO
MDM_CANONICAL P_PRODUCT_RELATIONS PRODUCT MASTER PRODUCT MASTER END_PRODUCT_TYPE END_PRODUCT_TYPE 12 VARCHAR 16777216   NO YES NO NO
MDM_CANONICAL P_PRODUCT_RELATIONS PRODUCT MASTER PRODUCT MASTER COUNTRY COUNTRY 13 VARCHAR 16777216   NO YES NO NO
MDM_CANONICAL P_PRODUCT_RELATIONS PRODUCT MASTER PRODUCT MASTER START_DATE START_DATE 14 TIMESTAMP_LTZ     NO YES NO NO
MDM_CANONICAL P_PRODUCT_RELATIONS PRODUCT MASTER PRODUCT MASTER END_DATE END_DATE 15 TIMESTAMP_LTZ     NO YES NO NO
MDM_CANONICAL P_PRODUCT_RELATIONS PRODUCT MASTER PRODUCT MASTER STATUS STATUS 16 VARCHAR 16777216   NO YES NO NO
MDM_CANONICAL P_PRODUCT_RELATIONS PRODUCT MASTER PRODUCT MASTER HIERARCHY_TYPE HIERARCHY_TYPE 17 VARCHAR 16777216   NO YES NO NO
MDM_CANONICAL P_PRODUCT_RELATIONS PRODUCT MASTER PRODUCT MASTER START_PRODUCT_MDM_URI START_PRODUCT_MDM_URI 18 VARCHAR 16777216   NO NO NO NO
MDM_CANONICAL P_PRODUCT_RELATIONS PRODUCT MASTER PRODUCT MASTER END_PRODUCT_MDM_URI END_PRODUCT_MDM_URI 19 VARCHAR 16777216   NO NO NO NO
MDM_CANONICAL P_PRODUCT_RELATIONS PRODUCT MASTER PRODUCT MASTER SYS_CRT_DT SYS_CRT_DT 20 TIMESTAMP_LTZ     NO NO NO NO
MDM_CANONICAL P_PRODUCT_RELATIONS PRODUCT MASTER PRODUCT MASTER SYS_UPDT_DT SYS_UPDT_DT 21 TIMESTAMP_LTZ     NO NO NO NO
MDM_CANONICAL P_PRODUCT_RELATIONS PRODUCT MASTER PRODUCT MASTER SYS_EFF_DT SYS_EFF_DT 22 TIMESTAMP_LTZ     NO NO NO NO
MDM_CANONICAL P_PRODUCT_RELATIONS PRODUCT MASTER PRODUCT MASTER SYS_END_DT SYS_END_DT 23 TIMESTAMP_LTZ     NO NO NO NO
MDM_CANONICAL P_PRODUCT_RELATIONS PRODUCT MASTER PRODUCT MASTER SYS_CRT_BY SYS_CRT_BY 24 VARCHAR 16777216   NO NO NO NO
MDM_CANONICAL P_PRODUCT_RELATIONS PRODUCT MASTER PRODUCT MASTER SYS_UPDT_BY SYS_UPDT_BY 25 VARCHAR 16777216   NO NO NO NO
MDM_CANONICAL P_PRODUCT_HIERTYPE P_PRODUCT_HIERTYPE PRODUCT MASTER PRODUCT_HIERID PRODUCT_HIERID 1 VARCHAR 16777216   NO NO YES YES
MDM_CANONICAL P_PRODUCT_HIERTYPE P_PRODUCT_HIERTYPE PRODUCT MASTER PRODUCT_ID PRODUCT_ID 2 VARCHAR 16777216   NO YES NO NO
MDM_CANONICAL P_PRODUCT_HIERTYPE P_PRODUCT_HIERTYPE PRODUCT MASTER HIERARCHY_TYPE HIERARCHY_TYPE 3 VARCHAR 16777216   NO YES NO NO
MDM_CANONICAL P_PRODUCT_HIERTYPE P_PRODUCT_HIERTYPE PRODUCT MASTER SYS_CRT_DT SYS_CRT_DT 4 TIMESTAMP_LTZ     NO NO NO NO
MDM_CANONICAL P_PRODUCT_HIERTYPE P_PRODUCT_HIERTYPE PRODUCT MASTER SYS_UPDT_DT SYS_UPDT_DT 5 TIMESTAMP_LTZ     NO NO NO NO
MDM_CANONICAL P_PRODUCT_HIERTYPE P_PRODUCT_HIERTYPE PRODUCT MASTER SYS_EFF_DT SYS_EFF_DT 6 TIMESTAMP_LTZ     NO NO NO NO
MDM_CANONICAL P_PRODUCT_HIERTYPE P_PRODUCT_HIERTYPE PRODUCT MASTER SYS_END_DT SYS_END_DT 7 TIMESTAMP_LTZ     NO NO NO NO
MDM_CANONICAL P_PRODUCT_HIERTYPE P_PRODUCT_HIERTYPE PRODUCT MASTER SYS_CRT_BY SYS_CRT_BY 8 VARCHAR 16777216   NO NO NO NO
MDM_CANONICAL P_PRODUCT_HIERTYPE P_PRODUCT_HIERTYPE PRODUCT MASTER SYS_UPDT_BY SYS_UPDT_BY 9 VARCHAR 16777216   NO NO NO NO