JDBC Driver for FHIR

Build 22.0.8462

Medication

Medication 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 medication.
identifier_use String The identifier-use of the identifier-use. Business identifier for this medication.
identifier_type_coding String The coding of the identifier-type. Business identifier for this medication.
identifier_type_text String The text of the identifier-type. Business identifier for this medication.
identifier_system String The identifier-system of the identifier-system. Business identifier for this medication.
identifier_period_start String The start of the identifier-period. Business identifier for this medication.
identifier_period_end String The end of the identifier-period. Business identifier for this medication.
code_coding String The coding of the code. A code (or set of codes) that specify this medication, or a textual description if no code is available. Usage note: This could be a standard medication code such as a code from RxNorm, SNOMED CT, IDMP etc. It could also be a national or local formulary code, optionally with translations to other code systems.
code_text String The text of the code. A code (or set of codes) that specify this medication, or a textual description if no code is available. Usage note: This could be a standard medication code such as a code from RxNorm, SNOMED CT, IDMP etc. It could also be a national or local formulary code, optionally with translations to other code systems.
status String A code to indicate if the medication is in active use.
manufacturer_display String The display of the manufacturer. Describes the details of the manufacturer of the medication product. This is not intended to represent the distributor of a medication product.
manufacturer_reference String The reference of the manufacturer. Describes the details of the manufacturer of the medication product. This is not intended to represent the distributor of a medication product.
manufacturer_identifier_value String The value of the manufacturer-identifier. Describes the details of the manufacturer of the medication product. This is not intended to represent the distributor of a medication product.
manufacturer_type String The manufacturer-type of the manufacturer-type. Describes the details of the manufacturer of the medication product. This is not intended to represent the distributor of a medication product.
form_coding String The coding of the form. Describes the form of the item. Powder; tablets; capsule.
form_text String The text of the form. Describes the form of the item. Powder; tablets; capsule.
amount String Specific amount of the drug in the packaged product. For example, when specifying a product that has the same strength (For example, Insulin glargine 100 unit per mL solution for injection), this attribute provides additional clarification of the package amount (For example, 3 mL, 10mL, etc.).
ingredient_id String The ingredient-id of the ingredient-id. Unique id for the element within a resource (for internal references). This may be any string value that does not contain spaces.
ingredient_extension String The ingredient-extension of the ingredient-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.
ingredient_modifierExtension String The ingredient-modifierExtension of the ingredient-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).
ingredient_item_x_coding String The coding of the ingredient-item[x]. The actual ingredient - either a substance (simple ingredient) or another medication of a medication.
ingredient_item_x_text String The text of the ingredient-item[x]. The actual ingredient - either a substance (simple ingredient) or another medication of a medication.
ingredient_isActive Bool The ingredient-isActive of the ingredient-isActive. Indication of whether this ingredient affects the therapeutic action of the drug.
ingredient_strength String The ingredient-strength of the ingredient-strength. Specifies how many (or how much) of the items there are in this Medication. For example, 250 mg per tablet. This is expressed as a ratio where the numerator is 250mg and the denominator is 1 tablet.
batch_id String The batch-id of the batch-id. Unique id for the element within a resource (for internal references). This may be any string value that does not contain spaces.
batch_extension String The batch-extension of the batch-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.
batch_modifierExtension String The batch-modifierExtension of the batch-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).
batch_lotNumber String The batch-lotNumber of the batch-lotNumber. The assigned lot number of a batch of the specified product.
batch_expirationDate Datetime The batch-expirationDate of the batch-expirationDate. When this specific batch of product will expire.
SP_source String The SP_source search parameter.
SP_lot_number_start String The SP_lot_number_start search parameter.
SP_text String The SP_text search parameter.
SP_ingredient_code_end String The SP_ingredient_code_end search parameter.
SP_content String The SP_content search parameter.
SP_securitySP_start String The SP_securitySP_start search parameter.
SP_tagSP_start String The SP_tagSP_start search parameter.
SP_identifier_start String The SP_identifier_start search parameter.
SP_list String The SP_list search parameter.
SP_identifier_end String The SP_identifier_end search parameter.
SP_ingredient_code_start String The SP_ingredient_code_start search parameter.
SP_profile String The SP_profile search parameter.
SP_code_start String The SP_code_start search parameter.
SP_code_end String The SP_code_end search parameter.
SP_tagSP_end String The SP_tagSP_end search parameter.
SP_securitySP_end String The SP_securitySP_end search parameter.
SP_expiration_date String The SP_expiration_date search parameter.
SP_form_start String The SP_form_start search parameter.
SP_form_end String The SP_form_end search parameter.
SP_filter String The SP_filter search parameter.
SP_lot_number_end String The SP_lot_number_end search parameter.
SP_manufacturer String The SP_manufacturer search parameter.
SP_ingredient String The SP_ingredient search parameter.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462