ODBC Driver for FHIR

Build 24.0.9060

MedicinalProductDefinition

MedicinalProductDefinition view.

Columns

Name Type Description
id String The logical id of the resource, as used in the URL for the resource. Once assigned, this value never changes.
lastUpdated Datetime The metadata about the resource. This is content that is maintained by the infrastructure. Changes to the content might not always be associated with version changes to the resource.
implicitRules String A reference to a set of rules that were followed when the resource was constructed, and which must be understood when processing the content. Often, this is a reference to an implementation guide that defines the special rules along with other profiles etc.
language String The base language in which the resource is written.
text_div String The div of the text. A human-readable narrative that contains a summary of the resource and can be used to represent the content of the resource to a human. The narrative need not encode all the structured data, but is required to contain sufficient detail to make it 'clinically safe' for a human to just read the narrative. Resource definitions may define what content should be represented in the narrative to ensure clinical safety.
text_status String The status of the text. A human-readable narrative that contains a summary of the resource and can be used to represent the content of the resource to a human. The narrative need not encode all the structured data, but is required to contain sufficient detail to make it 'clinically safe' for a human to just read the narrative. Resource definitions may define what content should be represented in the narrative to ensure clinical safety.
contained String These resources do not have an independent existence apart from the resource that contains them - they cannot be identified independently, and nor can they have their own independent transaction scope.
extension String May be used to represent additional information that is not part of the basic definition of the resource. To make the use of extensions safe and manageable, there is a strict set of governance applied to the definition and use of extensions. Though any implementer can define an extension, there is a set of requirements that SHALL be met as part of the definition of the extension.
modifierExtension String May be used to represent additional information that is not part of the basic definition of the resource and that modifies the understanding of the element that contains it and/or the understanding of the containing element's descendants. Usually modifier elements provide negation or qualification. To make the use of extensions safe and manageable, there is a strict set of governance applied to the definition and use of extensions. Though any implementer is allowed to define an extension, there is a set of requirements that SHALL be met as part of the definition of the extension. Applications processing a resource are required to check for modifier extensions. Modifier extensions SHALL NOT change the meaning of any elements on Resource or DomainResource (including cannot change the meaning of modifierExtension itself).
identifier_value String The value of the identifier. Business identifier for this product. Could be an MPID.
identifier_use String The identifier-use of the identifier-use. Business identifier for this product. Could be an MPID.
identifier_type_coding String The coding of the identifier-type. Business identifier for this product. Could be an MPID.
identifier_type_text String The text of the identifier-type. Business identifier for this product. Could be an MPID.
identifier_system String The identifier-system of the identifier-system. Business identifier for this product. Could be an MPID.
identifier_period_start String The start of the identifier-period. Business identifier for this product. Could be an MPID.
identifier_period_end String The end of the identifier-period. Business identifier for this product. Could be an MPID.
type_coding String The coding of the type. Regulatory type, e.g. Investigational or Authorized.
type_text String The text of the type. Regulatory type, e.g. Investigational or Authorized.
domain_coding String The coding of the domain. If this medicine applies to human or veterinary uses.
domain_text String The text of the domain. If this medicine applies to human or veterinary uses.
version String A business identifier relating to a specific version of the product, this is commonly used to support revisions to an existing product.
status_coding String The coding of the status. The status within the lifecycle of this product record. A high-level status, this is not intended to duplicate details carried elsewhere such as legal status, or authorization status.
status_text String The text of the status. The status within the lifecycle of this product record. A high-level status, this is not intended to duplicate details carried elsewhere such as legal status, or authorization status.
statusDate Datetime The date at which the given status became applicable.
description String General description of this product.
combinedPharmaceuticalDoseForm_coding String The coding of the combinedPharmaceuticalDoseForm. The dose form for a single part product, or combined form of a multiple part product.
combinedPharmaceuticalDoseForm_text String The text of the combinedPharmaceuticalDoseForm. The dose form for a single part product, or combined form of a multiple part product.
route_coding String The coding of the route. The path by which the product is taken into or makes contact with the body. In some regions this is referred to as the licenced or approved route. See also AdministrableProductDefinition resource.
route_text String The text of the route. The path by which the product is taken into or makes contact with the body. In some regions this is referred to as the licenced or approved route. See also AdministrableProductDefinition resource.
indication String Description of indication(s) for this product, used when structured indications are not required. In cases where structured indications are required, they are captured using the ClinicalUseDefinition resource. An indication is a medical situation for which using the product is appropriate.
legalStatusOfSupply_coding String The coding of the legalStatusOfSupply. The legal status of supply of the medicinal product as classified by the regulator.
legalStatusOfSupply_text String The text of the legalStatusOfSupply. The legal status of supply of the medicinal product as classified by the regulator.
additionalMonitoringIndicator_coding String The coding of the additionalMonitoringIndicator. Whether the Medicinal Product is subject to additional monitoring for regulatory reasons.
additionalMonitoringIndicator_text String The text of the additionalMonitoringIndicator. Whether the Medicinal Product is subject to additional monitoring for regulatory reasons.
specialMeasures_coding String The coding of the specialMeasures. Whether the Medicinal Product is subject to special measures for regulatory reasons.
specialMeasures_text String The text of the specialMeasures. Whether the Medicinal Product is subject to special measures for regulatory reasons.
pediatricUseIndicator_coding String The coding of the pediatricUseIndicator. If authorised for use in children.
pediatricUseIndicator_text String The text of the pediatricUseIndicator. If authorised for use in children.
classification_coding String The coding of the classification. Allows the product to be classified by various systems.
classification_text String The text of the classification. Allows the product to be classified by various systems.
marketingStatus String Marketing status of the medicinal product, in contrast to marketing authorization.
packagedMedicinalProduct_coding String The coding of the packagedMedicinalProduct. Package representation for the product. See also the PackagedProductDefinition resource.
packagedMedicinalProduct_text String The text of the packagedMedicinalProduct. Package representation for the product. See also the PackagedProductDefinition resource.
ingredient_coding String The coding of the ingredient. The ingredients of this medicinal product - when not detailed in other resources. This is only needed if the ingredients are not specified by incoming references from the Ingredient resource, or indirectly via incoming AdministrableProductDefinition, PackagedProductDefinition or ManufacturedItemDefinition references. In cases where those levels of detail are not used, the ingredients may be specified directly here as codes.
ingredient_text String The text of the ingredient. The ingredients of this medicinal product - when not detailed in other resources. This is only needed if the ingredients are not specified by incoming references from the Ingredient resource, or indirectly via incoming AdministrableProductDefinition, PackagedProductDefinition or ManufacturedItemDefinition references. In cases where those levels of detail are not used, the ingredients may be specified directly here as codes.
impurity_display String The display of the impurity. Any component of the drug product which is not the chemical entity defined as the drug substance or an excipient in the drug product. This includes process-related impurities and contaminants, product-related impurities including degradation products.
impurity_reference String The reference of the impurity. Any component of the drug product which is not the chemical entity defined as the drug substance or an excipient in the drug product. This includes process-related impurities and contaminants, product-related impurities including degradation products.
impurity_identifier_value String The value of the impurity-identifier. Any component of the drug product which is not the chemical entity defined as the drug substance or an excipient in the drug product. This includes process-related impurities and contaminants, product-related impurities including degradation products.
impurity_type String The impurity-type of the impurity-type. Any component of the drug product which is not the chemical entity defined as the drug substance or an excipient in the drug product. This includes process-related impurities and contaminants, product-related impurities including degradation products.
attachedDocument_display String The display of the attachedDocument. Additional information or supporting documentation about the medicinal product.
attachedDocument_reference String The reference of the attachedDocument. Additional information or supporting documentation about the medicinal product.
attachedDocument_identifier_value String The value of the attachedDocument-identifier. Additional information or supporting documentation about the medicinal product.
attachedDocument_type String The attachedDocument-type of the attachedDocument-type. Additional information or supporting documentation about the medicinal product.
masterFile_display String The display of the masterFile. A master file for the medicinal product (e.g. Pharmacovigilance System Master File). Drug master files (DMFs) are documents submitted to regulatory agencies to provide confidential detailed information about facilities, processes or articles used in the manufacturing, processing, packaging and storing of drug products.
masterFile_reference String The reference of the masterFile. A master file for the medicinal product (e.g. Pharmacovigilance System Master File). Drug master files (DMFs) are documents submitted to regulatory agencies to provide confidential detailed information about facilities, processes or articles used in the manufacturing, processing, packaging and storing of drug products.
masterFile_identifier_value String The value of the masterFile-identifier. A master file for the medicinal product (e.g. Pharmacovigilance System Master File). Drug master files (DMFs) are documents submitted to regulatory agencies to provide confidential detailed information about facilities, processes or articles used in the manufacturing, processing, packaging and storing of drug products.
masterFile_type String The masterFile-type of the masterFile-type. A master file for the medicinal product (e.g. Pharmacovigilance System Master File). Drug master files (DMFs) are documents submitted to regulatory agencies to provide confidential detailed information about facilities, processes or articles used in the manufacturing, processing, packaging and storing of drug products.
contact_id String The contact-id of the contact-id. Unique id for the element within a resource (for internal references). This may be any string value that does not contain spaces.
contact_extension String The contact-extension of the contact-extension. May be used to represent additional information that is not part of the basic definition of the element. To make the use of extensions safe and manageable, there is a strict set of governance applied to the definition and use of extensions. Though any implementer can define an extension, there is a set of requirements that SHALL be met as part of the definition of the extension.
contact_modifierExtension String The contact-modifierExtension of the contact-modifierExtension. May be used to represent additional information that is not part of the basic definition of the element and that modifies the understanding of the element in which it is contained and/or the understanding of the containing element's descendants. Usually modifier elements provide negation or qualification. To make the use of extensions safe and manageable, there is a strict set of governance applied to the definition and use of extensions. Though any implementer can define an extension, there is a set of requirements that SHALL be met as part of the definition of the extension. Applications processing a resource are required to check for modifier extensions. Modifier extensions SHALL NOT change the meaning of any elements on Resource or DomainResource (including cannot change the meaning of modifierExtension itself).
contact_type_coding String The coding of the contact-type. Allows the contact to be classified, for example QPPV, Pharmacovigilance Enquiry Information.
contact_type_text String The text of the contact-type. Allows the contact to be classified, for example QPPV, Pharmacovigilance Enquiry Information.
contact_contact_display String The display of the contact-contact. A product specific contact, person (in a role), or an organization.
contact_contact_reference String The reference of the contact-contact. A product specific contact, person (in a role), or an organization.
contact_contact_identifier_value String The value of the contact-contact-identifier. A product specific contact, person (in a role), or an organization.
contact_contact_type String The contact-contact-type of the contact-contact-type. A product specific contact, person (in a role), or an organization.
clinicalTrial_display String The display of the clinicalTrial. Clinical trials or studies that this product is involved in.
clinicalTrial_reference String The reference of the clinicalTrial. Clinical trials or studies that this product is involved in.
clinicalTrial_identifier_value String The value of the clinicalTrial-identifier. Clinical trials or studies that this product is involved in.
clinicalTrial_type String The clinicalTrial-type of the clinicalTrial-type. Clinical trials or studies that this product is involved in.
code_version String The version of the code. A code that this product is known by, usually within some formal terminology. Products (types of medications) tend to be known by identifiers during development and within regulatory process. However when they are prescribed they tend to be identified by codes. The same product may be have multiple codes, applied to it by multiple organizations.
code String A code that this product is known by, usually within some formal terminology. Products (types of medications) tend to be known by identifiers during development and within regulatory process. However when they are prescribed they tend to be identified by codes. The same product may be have multiple codes, applied to it by multiple organizations.
code_display String The display of the code. A code that this product is known by, usually within some formal terminology. Products (types of medications) tend to be known by identifiers during development and within regulatory process. However when they are prescribed they tend to be identified by codes. The same product may be have multiple codes, applied to it by multiple organizations.
code_userSelected String The userSelected of the code. A code that this product is known by, usually within some formal terminology. Products (types of medications) tend to be known by identifiers during development and within regulatory process. However when they are prescribed they tend to be identified by codes. The same product may be have multiple codes, applied to it by multiple organizations.
code_system String The code-system of the code-system. A code that this product is known by, usually within some formal terminology. Products (types of medications) tend to be known by identifiers during development and within regulatory process. However when they are prescribed they tend to be identified by codes. The same product may be have multiple codes, applied to it by multiple organizations.
name_id String The name-id of the name-id. Unique id for the element within a resource (for internal references). This may be any string value that does not contain spaces.
name_extension String The name-extension of the name-extension. May be used to represent additional information that is not part of the basic definition of the element. To make the use of extensions safe and manageable, there is a strict set of governance applied to the definition and use of extensions. Though any implementer can define an extension, there is a set of requirements that SHALL be met as part of the definition of the extension.
name_modifierExtension String The name-modifierExtension of the name-modifierExtension. May be used to represent additional information that is not part of the basic definition of the element and that modifies the understanding of the element in which it is contained and/or the understanding of the containing element's descendants. Usually modifier elements provide negation or qualification. To make the use of extensions safe and manageable, there is a strict set of governance applied to the definition and use of extensions. Though any implementer can define an extension, there is a set of requirements that SHALL be met as part of the definition of the extension. Applications processing a resource are required to check for modifier extensions. Modifier extensions SHALL NOT change the meaning of any elements on Resource or DomainResource (including cannot change the meaning of modifierExtension itself).
name_productName String The name-productName of the name-productName. The full product name.
name_type_coding String The coding of the name-type. Type of product name, such as rINN, BAN, Proprietary, Non-Proprietary.
name_type_text String The text of the name-type. Type of product name, such as rINN, BAN, Proprietary, Non-Proprietary.
name_namePart_id String The name-namePart-id of the name-namePart-id. Unique id for the element within a resource (for internal references). This may be any string value that does not contain spaces.
name_namePart_extension String The name-namePart-extension of the name-namePart-extension. May be used to represent additional information that is not part of the basic definition of the element. To make the use of extensions safe and manageable, there is a strict set of governance applied to the definition and use of extensions. Though any implementer can define an extension, there is a set of requirements that SHALL be met as part of the definition of the extension.
name_namePart_modifierExtension String The name-namePart-modifierExtension of the name-namePart-modifierExtension. May be used to represent additional information that is not part of the basic definition of the element and that modifies the understanding of the element in which it is contained and/or the understanding of the containing element's descendants. Usually modifier elements provide negation or qualification. To make the use of extensions safe and manageable, there is a strict set of governance applied to the definition and use of extensions. Though any implementer can define an extension, there is a set of requirements that SHALL be met as part of the definition of the extension. Applications processing a resource are required to check for modifier extensions. Modifier extensions SHALL NOT change the meaning of any elements on Resource or DomainResource (including cannot change the meaning of modifierExtension itself).
name_namePart_part String The name-namePart-part of the name-namePart-part. A fragment of a product name.
name_namePart_type_coding String The coding of the name-namePart-type. Identifying type for this part of the name (e.g. strength part).
name_namePart_type_text String The text of the name-namePart-type. Identifying type for this part of the name (e.g. strength part).
name_countryLanguage_id String The name-countryLanguage-id of the name-countryLanguage-id. Unique id for the element within a resource (for internal references). This may be any string value that does not contain spaces.
name_countryLanguage_extension String The name-countryLanguage-extension of the name-countryLanguage-extension. May be used to represent additional information that is not part of the basic definition of the element. To make the use of extensions safe and manageable, there is a strict set of governance applied to the definition and use of extensions. Though any implementer can define an extension, there is a set of requirements that SHALL be met as part of the definition of the extension.
name_countryLanguage_modifierExtension String The name-countryLanguage-modifierExtension of the name-countryLanguage-modifierExtension. May be used to represent additional information that is not part of the basic definition of the element and that modifies the understanding of the element in which it is contained and/or the understanding of the containing element's descendants. Usually modifier elements provide negation or qualification. To make the use of extensions safe and manageable, there is a strict set of governance applied to the definition and use of extensions. Though any implementer can define an extension, there is a set of requirements that SHALL be met as part of the definition of the extension. Applications processing a resource are required to check for modifier extensions. Modifier extensions SHALL NOT change the meaning of any elements on Resource or DomainResource (including cannot change the meaning of modifierExtension itself).
name_countryLanguage_country_coding String The coding of the name-countryLanguage-country. Country code for where this name applies.
name_countryLanguage_country_text String The text of the name-countryLanguage-country. Country code for where this name applies.
name_countryLanguage_jurisdiction_coding String The coding of the name-countryLanguage-jurisdiction. Jurisdiction code for where this name applies.
name_countryLanguage_jurisdiction_text String The text of the name-countryLanguage-jurisdiction. Jurisdiction code for where this name applies.
name_countryLanguage_language_coding String The coding of the name-countryLanguage-language. Language code for this name.
name_countryLanguage_language_text String The text of the name-countryLanguage-language. Language code for this name.
crossReference_id String The crossReference-id of the crossReference-id. Unique id for the element within a resource (for internal references). This may be any string value that does not contain spaces.
crossReference_extension String The crossReference-extension of the crossReference-extension. May be used to represent additional information that is not part of the basic definition of the element. To make the use of extensions safe and manageable, there is a strict set of governance applied to the definition and use of extensions. Though any implementer can define an extension, there is a set of requirements that SHALL be met as part of the definition of the extension.
crossReference_modifierExtension String The crossReference-modifierExtension of the crossReference-modifierExtension. May be used to represent additional information that is not part of the basic definition of the element and that modifies the understanding of the element in which it is contained and/or the understanding of the containing element's descendants. Usually modifier elements provide negation or qualification. To make the use of extensions safe and manageable, there is a strict set of governance applied to the definition and use of extensions. Though any implementer can define an extension, there is a set of requirements that SHALL be met as part of the definition of the extension. Applications processing a resource are required to check for modifier extensions. Modifier extensions SHALL NOT change the meaning of any elements on Resource or DomainResource (including cannot change the meaning of modifierExtension itself).
crossReference_product_display String The display of the crossReference-product. Reference to another product, e.g. for linking authorised to investigational product.
crossReference_product_reference String The reference of the crossReference-product. Reference to another product, e.g. for linking authorised to investigational product.
crossReference_product_identifier_value String The value of the crossReference-product-identifier. Reference to another product, e.g. for linking authorised to investigational product.
crossReference_product_type String The crossReference-product-type of the crossReference-product-type. Reference to another product, e.g. for linking authorised to investigational product.
crossReference_type_coding String The coding of the crossReference-type. The type of relationship, for instance branded to generic, product to development product (investigational), parallel import version.
crossReference_type_text String The text of the crossReference-type. The type of relationship, for instance branded to generic, product to development product (investigational), parallel import version.
operation_id String The operation-id of the operation-id. Unique id for the element within a resource (for internal references). This may be any string value that does not contain spaces.
operation_extension String The operation-extension of the operation-extension. May be used to represent additional information that is not part of the basic definition of the element. To make the use of extensions safe and manageable, there is a strict set of governance applied to the definition and use of extensions. Though any implementer can define an extension, there is a set of requirements that SHALL be met as part of the definition of the extension.
operation_modifierExtension String The operation-modifierExtension of the operation-modifierExtension. May be used to represent additional information that is not part of the basic definition of the element and that modifies the understanding of the element in which it is contained and/or the understanding of the containing element's descendants. Usually modifier elements provide negation or qualification. To make the use of extensions safe and manageable, there is a strict set of governance applied to the definition and use of extensions. Though any implementer can define an extension, there is a set of requirements that SHALL be met as part of the definition of the extension. Applications processing a resource are required to check for modifier extensions. Modifier extensions SHALL NOT change the meaning of any elements on Resource or DomainResource (including cannot change the meaning of modifierExtension itself).
operation_type_display String The display of the operation-type. The type of manufacturing operation e.g. manufacturing itself, re-packaging. For the authorization of this, a RegulatedAuthorization would point to the same plan or activity referenced here.
operation_type_reference String The reference of the operation-type. The type of manufacturing operation e.g. manufacturing itself, re-packaging. For the authorization of this, a RegulatedAuthorization would point to the same plan or activity referenced here.
operation_type_identifier_value String The value of the operation-type-identifier. The type of manufacturing operation e.g. manufacturing itself, re-packaging. For the authorization of this, a RegulatedAuthorization would point to the same plan or activity referenced here.
operation_type_type String The operation-type-type of the operation-type-type. The type of manufacturing operation e.g. manufacturing itself, re-packaging. For the authorization of this, a RegulatedAuthorization would point to the same plan or activity referenced here.
operation_effectiveDate_start Datetime The start of the operation-effectiveDate. Date range of applicability.
operation_effectiveDate_end Datetime The end of the operation-effectiveDate. Date range of applicability.
operation_organization_display String The display of the operation-organization. The organization or establishment responsible for (or associated with) the particular process or step, examples include the manufacturer, importer, agent.
operation_organization_reference String The reference of the operation-organization. The organization or establishment responsible for (or associated with) the particular process or step, examples include the manufacturer, importer, agent.
operation_organization_identifier_value String The value of the operation-organization-identifier. The organization or establishment responsible for (or associated with) the particular process or step, examples include the manufacturer, importer, agent.
operation_organization_type String The operation-organization-type of the operation-organization-type. The organization or establishment responsible for (or associated with) the particular process or step, examples include the manufacturer, importer, agent.
operation_confidentialityIndicator_coding String The coding of the operation-confidentialityIndicator. Specifies whether this particular business or manufacturing process is considered proprietary or confidential.
operation_confidentialityIndicator_text String The text of the operation-confidentialityIndicator. Specifies whether this particular business or manufacturing process is considered proprietary or confidential.
characteristic_id String The characteristic-id of the characteristic-id. Unique id for the element within a resource (for internal references). This may be any string value that does not contain spaces.
characteristic_extension String The characteristic-extension of the characteristic-extension. May be used to represent additional information that is not part of the basic definition of the element. To make the use of extensions safe and manageable, there is a strict set of governance applied to the definition and use of extensions. Though any implementer can define an extension, there is a set of requirements that SHALL be met as part of the definition of the extension.
characteristic_modifierExtension String The characteristic-modifierExtension of the characteristic-modifierExtension. May be used to represent additional information that is not part of the basic definition of the element and that modifies the understanding of the element in which it is contained and/or the understanding of the containing element's descendants. Usually modifier elements provide negation or qualification. To make the use of extensions safe and manageable, there is a strict set of governance applied to the definition and use of extensions. Though any implementer can define an extension, there is a set of requirements that SHALL be met as part of the definition of the extension. Applications processing a resource are required to check for modifier extensions. Modifier extensions SHALL NOT change the meaning of any elements on Resource or DomainResource (including cannot change the meaning of modifierExtension itself).
characteristic_type_coding String The coding of the characteristic-type. A code expressing the type of characteristic.
characteristic_type_text String The text of the characteristic-type. A code expressing the type of characteristic.
characteristic_value_x_coding String The coding of the characteristic-value[x]. A value for the characteristic.
characteristic_value_x_text String The text of the characteristic-value[x]. A value for the characteristic.
SP_source String The SP_source search parameter.
SP_characteristic_start String The SP_characteristic_start search parameter.
SP_text String The SP_text search parameter.
SP_content String The SP_content search parameter.
SP_status_start String The SP_status_start search parameter.
SP_securitySP_start String The SP_securitySP_start search parameter.
SP_tagSP_start String The SP_tagSP_start search parameter.
SP_name_language_start String The SP_name_language_start search parameter.
SP_identifier_start String The SP_identifier_start search parameter.
SP_type_start String The SP_type_start search parameter.
SP_product_classification_end String The SP_product_classification_end search parameter.
SP_status_end String The SP_status_end search parameter.
SP_characteristic_type_end String The SP_characteristic_type_end search parameter.
SP_list String The SP_list search parameter.
SP_master_file String The SP_master_file search parameter.
SP_domain_end String The SP_domain_end search parameter.
SP_type_end String The SP_type_end search parameter.
SP_identifier_end String The SP_identifier_end search parameter.
SP_characteristic_type_start String The SP_characteristic_type_start search parameter.
SP_profile String The SP_profile search parameter.
SP_product_classification_start String The SP_product_classification_start search parameter.
SP_tagSP_end String The SP_tagSP_end search parameter.
SP_characteristic_end String The SP_characteristic_end search parameter.
SP_securitySP_end String The SP_securitySP_end search parameter.
SP_contact String The SP_contact search parameter.
SP_name_language_end String The SP_name_language_end search parameter.
SP_filter String The SP_filter search parameter.
SP_domain_start String The SP_domain_start search parameter.
SP_ingredient_start String The SP_ingredient_start search parameter.
SP_ingredient_end String The SP_ingredient_end search parameter.
SP_name String The SP_name search parameter.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9060