JDBC Driver for FHIR

Build 22.0.8462

Substance

Substance 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. Unique identifier for the substance.
identifier_use String The identifier-use of the identifier-use. Unique identifier for the substance.
identifier_type_coding String The coding of the identifier-type. Unique identifier for the substance.
identifier_type_text String The text of the identifier-type. Unique identifier for the substance.
identifier_system String The identifier-system of the identifier-system. Unique identifier for the substance.
identifier_period_start String The start of the identifier-period. Unique identifier for the substance.
identifier_period_end String The end of the identifier-period. Unique identifier for the substance.
status String A code to indicate if the substance is actively used.
category_coding String The coding of the category. A code that classifies the general type of substance. This is used for searching, sorting and display purposes.
category_text String The text of the category. A code that classifies the general type of substance. This is used for searching, sorting and display purposes.
code_coding String The coding of the code. A code (or set of codes) that identify this substance.
code_text String The text of the code. A code (or set of codes) that identify this substance.
description String A description of the substance - its appearance, handling requirements, and other usage notes.
instance_id String The instance-id of the instance-id. Unique id for the element within a resource (for internal references). This may be any string value that does not contain spaces.
instance_extension String The instance-extension of the instance-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.
instance_modifierExtension String The instance-modifierExtension of the instance-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).
instance_identifier_value String The value of the instance-identifier. Identifier associated with the package/container (usually a label affixed directly).
instance_identifier_use String The instance-identifier-use of the instance-identifier-use. Identifier associated with the package/container (usually a label affixed directly).
instance_identifier_type_coding String The coding of the instance-identifier-type. Identifier associated with the package/container (usually a label affixed directly).
instance_identifier_type_text String The text of the instance-identifier-type. Identifier associated with the package/container (usually a label affixed directly).
instance_identifier_system String The instance-identifier-system of the instance-identifier-system. Identifier associated with the package/container (usually a label affixed directly).
instance_identifier_period_start Datetime The start of the instance-identifier-period. Identifier associated with the package/container (usually a label affixed directly).
instance_identifier_period_end Datetime The end of the instance-identifier-period. Identifier associated with the package/container (usually a label affixed directly).
instance_expiry Datetime The instance-expiry of the instance-expiry. When the substance is no longer valid to use. For some substances, a single arbitrary date is used for expiry.
instance_quantity_value Decimal The value of the instance-quantity. The amount of the substance.
instance_quantity_unit String The unit of the instance-quantity. The amount of the substance.
instance_quantity_system String The system of the instance-quantity. The amount of the substance.
instance_quantity_comparator String The instance-quantity-comparator of the instance-quantity-comparator. The amount of the substance.
instance_quantity_code String The instance-quantity-code of the instance-quantity-code. The amount of the substance.
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_quantity String The ingredient-quantity of the ingredient-quantity. The amount of the ingredient in the substance - a concentration ratio.
ingredient_substance_x_coding String The coding of the ingredient-substance[x]. Another substance that is a component of this substance.
ingredient_substance_x_text String The text of the ingredient-substance[x]. Another substance that is a component of this substance.
SP_source String The SP_source search parameter.
SP_container_identifier_end String The SP_container_identifier_end search parameter.
SP_text String The SP_text 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_substance_reference String The SP_substance_reference search parameter.
SP_identifier_start String The SP_identifier_start search parameter.
SP_quantity String The SP_quantity search parameter.
SP_container_identifier_start String The SP_container_identifier_start search parameter.
SP_expiry String The SP_expiry search parameter.
SP_list String The SP_list search parameter.
SP_category_end String The SP_category_end search parameter.
SP_identifier_end String The SP_identifier_end 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_category_start String The SP_category_start search parameter.
SP_filter String The SP_filter search parameter.

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