Manufactured Product (MP) = The representation of a brand specific drug that is available for prescribing and dispensing in Canada. The file contains one entry for every concept that has ever been released. Column Data Type Length Description mp_code String 8 "The unique Manufactured Product identifier, that may be a Health Canada assigned DIN or NPN, or an identifier specific to the Canadian Clinical Drug Data Set" mp_formal_name String 500 The unambiguous description of the Manufactured Product that includes details necessary to distinguish it from other similar concepts mp_en_description String 500 The user-friendly English description that may be used for web applications or the user interface for any system. NB: Not present in the files currently mp_fr_description String 500 The French description of the Manufactured Product formal name mp_status String 8 "The lifecycle state for the product. Allowable values for status are “Active”, “Inactive” and ""Deprec"" (deprecated)" mp_status_effective_time String (Date) 8 The date of the mp_status in this file is based on the underlying regulatory status data in the DPD. Format = YYYYMMDD mp_type String 8 "The mp_type distinguishes whether the MP code corresponds to the DPD medicinal product (DIN) identifier, the natural health product (NPN) identifier or is a code created for the CCDD.  Allowable values for mp_type are “DIN”, “NPN”, and “CCDD”" Health_Canada_ identifier String 8 The DIN or NPN identifier assigned to an authorized medicinal product by Health Canada Health_Canada_product_name String 200 "The product name (as present in the DPD or Licensed Natural Health Products Database (LNHPD) approved by Health Canada, under which the drug product may be marketed" Non-proprietary Therapeutic Product (NTP) = A representation of a brand independent and clinically oriented representation of a manufactured (therapeutic) drug product. The file contains one entry for every concept that has ever been released. Column Data Type Length Description ntp_code String 7 Unique meaningless Non-proprietary Therapeutic Product identifier ntp_formal_name String 500 The unambiguous description of the Non-proprietary Therapeutic Product that includes details necessary to distinguish it from other similar concepts ntp_en_description String 500 The user-friendly English description that may be used for web applications or the user interface for any system. NB: Not present in the files currently ntp_fr_description String 500 The French description of the Non-proprietary Therapeutic Product formal name. ntp_status String 8 "The lifecycle state for the product. Allowable values for status are “Active”, “Inactive” and ""Deprec"" (deprecated)" ntp_status_effective_time String (Date) 8 The date of the ntp_status in this file has been inferred based on the Manufactured Products associated with the ntp. Format = YYYYMMDD ntp_type String 8 "This attribute is used to differentiate combination products. Values = ""Comb"" or ""NA""" Therapeutic Moeity (TM) = The representation of the functional and clinically significant part of the active ingredient substance(s) present in a medicinal product, and as such the TM class is an abstract representation of a medicinal product without reference to strength and dose form, focusing only on active ingredient substance(s). The file contains one entry for every concept that has ever been released. Column Data Type Length Description tm_code String 7 Unique meaningless Therapeutic Moiety identifier tm_formal_name String 500 The unambiguous description of the Therapeutic Moiety that includes details necessary to distinguish it from other similar concepts tm_fr_description String 500 The French description of the Therapeutic Moiety formal name tm_status String 8 "The lifecycle state for the product. Allowable values for status are “Active”, “Inactive” and ""Deprec"" (deprecated)" tm_status_effective_time String (Date) 8 The date of the tm_status in this file has been inferred based on the Manufactured Products associated with the tm. Format = YYYYMMDD MP-NTP-TM Relationship (English) = Each row represents the relationship between an MP and its NTP, and its TM (where one exists). It will include both active and inactive content from the full release files for the MP, NTP and TM. It will not include deprecated content. As well as the mp_,ntp_ and tm_codes, it contains the mp, ntp_ and tm_formal names. MP-NTP-TM Relationship (French) = Each row represents the relationship between an MP and its NTP, and its TM (where one exists). It will include both active and inactive content with mp_, ntp_and tm_codes and French descriptions from the full release files for the MP, NTP and TM. It will not include deprecated content. Device Non-proprietary Therapeutic Product = A brand independent and clinically oriented representation of a healthcare device. The file contains one entry for every concept that has ever been released. Column Data Type Length Description device_ntp_code String 7 Unique meaningless Device Non-proprietary Therapeutic Product identifier device_ntp_formal_name String 500 The unambiguous description of the Device Non-proprietary Therapeutic Product that includes details necessary to distinguish it from other similar concepts device_ntp_en_description String 500 The user-friendly English description that may be used for web applications or the user interface for any system. NB: Not present in the files currently device_ntp_fr_description String 500 The French description of the Device Non-proprietary Therapeutic Product formal name device_ntp_status String 8 "The lifecycle status for the concept in this file. Allowable values for status are “Active”, “Inactive” and ""Deprec"" (deprecated)" device_ntp_status_effective_time String (Date) 8 The date of the status in this file. Format = YYYYMMDD Special Groupings = Identifies and provides relationships between concepts in the Canadian Clinical Drug Data Set and policies that apply to those product Column Data Type Length Description ccdd_code String 8 "Unique meaningless identifier for a concept within the Canadian Clinical Drug Data Set.  This may be a tm_code, an ntp_code or an mp_code" ccdd_formal_name String 500 "The unambiguous description of the concept within the Canadian Clinical Drug Data Set.  This may be a tm_formal_name, an ntp_formal_name or an mp_formal_name" ccdd_type String 15 "The identification of the specific Canadian Clinical Drug Data Set concept type (either MP, NTP or TM)" policy_type String 250 A code representing the policy that the concept described in ccdd_code is controlled by. The detail of the code can be found in the coded_attributes file policy_reference String 250 A reference to further information about the policy.  This reference may be a url special_groupings_status String 8 "The lifecycle status of the relationship between the concept described in ccdd_code and the policy described in policy_type.  Allowable values for this status are ""Active"" and ""Inactive""" special_groupings_status_effective_time String (Date) 8 "For “Active” status entries, this is the date that the information became present in this file.  For “Inactive” status entries, this is the date that the policy information in this file is no longer applicable.  Format = YYYYMMDD" Coded attributes = This file provides the coded values used in an attribute field within the Canadian Clinical Drug Data Set Column Data Type Length Description attribute String 50 The name of the specific coded attribute from the CCDD file type attribute_code String 8 Unique identifier for an attribute value within the Clinical Drug Data Set attribute_value String 500 Unambiguous description of an attribute within Clinical Drug Data Set fr_attribute_value String 500 "The French description of the CCDD Attribute Value.  In the event a French description is not available, the value will be “NA”" CCDD_file_type String 200 The name of the specific CCDD file type the attribute is from. attribute_ status String 8 "The lifecycle status for the concept in this file. Allowable values for status are “Active”, “Inactive” and ""Deprec"" (deprecated )" attribute_ status_effective_time String (Date) 8 The date of the status in this file. Format = YYYYMMDD