JDBC Driver for FHIR

Build 22.0.8462

SubstanceDefinition

SubstanceDefinition 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. Identifier by which this substance is known.
identifier_use String The identifier-use of the identifier-use. Identifier by which this substance is known.
identifier_type_coding String The coding of the identifier-type. Identifier by which this substance is known.
identifier_type_text String The text of the identifier-type. Identifier by which this substance is known.
identifier_system String The identifier-system of the identifier-system. Identifier by which this substance is known.
identifier_period_start String The start of the identifier-period. Identifier by which this substance is known.
identifier_period_end String The end of the identifier-period. Identifier by which this substance is known.
version String A business level identifier of the substance.
status_coding String The coding of the status. Status of substance within the catalogue e.g. approved.
status_text String The text of the status. Status of substance within the catalogue e.g. approved.
classification_coding String The coding of the classification. A high level categorization, e.g. polymer or nucleic acid, or food, chemical, biological, or a lower level such as the general types of polymer (linear or branch chain) or type of impurity (process related or contaminant).
classification_text String The text of the classification. A high level categorization, e.g. polymer or nucleic acid, or food, chemical, biological, or a lower level such as the general types of polymer (linear or branch chain) or type of impurity (process related or contaminant).
domain_coding String The coding of the domain. If the substance applies to only human or veterinary use.
domain_text String The text of the domain. If the substance applies to only human or veterinary use.
grade_coding String The coding of the grade. The quality standard, established benchmark, to which substance complies (e.g. USP/NF, Ph. Eur, JP, BP, Company Standard).
grade_text String The text of the grade. The quality standard, established benchmark, to which substance complies (e.g. USP/NF, Ph. Eur, JP, BP, Company Standard).
description String Textual description of the substance.
informationSource_display String The display of the informationSource. Supporting literature.
informationSource_reference String The reference of the informationSource. Supporting literature.
informationSource_identifier_value String The value of the informationSource-identifier. Supporting literature.
informationSource_type String The informationSource-type of the informationSource-type. Supporting literature.
note String Textual comment about the substance's catalogue or registry record.
manufacturer_display String The display of the manufacturer. A company that makes this substance.
manufacturer_reference String The reference of the manufacturer. A company that makes this substance.
manufacturer_identifier_value String The value of the manufacturer-identifier. A company that makes this substance.
manufacturer_type String The manufacturer-type of the manufacturer-type. A company that makes this substance.
supplier_display String The display of the supplier. A company that supplies this substance.
supplier_reference String The reference of the supplier. A company that supplies this substance.
supplier_identifier_value String The value of the supplier-identifier. A company that supplies this substance.
supplier_type String The supplier-type of the supplier-type. A company that supplies this substance.
moiety_id String The moiety-id of the moiety-id. Unique id for the element within a resource (for internal references). This may be any string value that does not contain spaces.
moiety_extension String The moiety-extension of the moiety-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.
moiety_modifierExtension String The moiety-modifierExtension of the moiety-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).
moiety_role_coding String The coding of the moiety-role. Role that the moiety is playing.
moiety_role_text String The text of the moiety-role. Role that the moiety is playing.
moiety_identifier_value String The value of the moiety-identifier. Identifier by which this moiety substance is known.
moiety_identifier_use String The moiety-identifier-use of the moiety-identifier-use. Identifier by which this moiety substance is known.
moiety_identifier_type_coding String The coding of the moiety-identifier-type. Identifier by which this moiety substance is known.
moiety_identifier_type_text String The text of the moiety-identifier-type. Identifier by which this moiety substance is known.
moiety_identifier_system String The moiety-identifier-system of the moiety-identifier-system. Identifier by which this moiety substance is known.
moiety_identifier_period_start Datetime The start of the moiety-identifier-period. Identifier by which this moiety substance is known.
moiety_identifier_period_end Datetime The end of the moiety-identifier-period. Identifier by which this moiety substance is known.
moiety_name String The moiety-name of the moiety-name. Textual name for this moiety substance.
moiety_stereochemistry_coding String The coding of the moiety-stereochemistry. Stereochemistry type.
moiety_stereochemistry_text String The text of the moiety-stereochemistry. Stereochemistry type.
moiety_opticalActivity_coding String The coding of the moiety-opticalActivity. Optical activity type.
moiety_opticalActivity_text String The text of the moiety-opticalActivity. Optical activity type.
moiety_molecularFormula String The moiety-molecularFormula of the moiety-molecularFormula. Molecular formula for this moiety of this substance, typically using the Hill system.
moiety_amount_x_value Decimal The value of the moiety-amount[x]. Quantitative value for this moiety.
moiety_amount_x_unit String The unit of the moiety-amount[x]. Quantitative value for this moiety.
moiety_amount_x_system String The system of the moiety-amount[x]. Quantitative value for this moiety.
moiety_amount_x_comparator String The moiety-amount[x]-comparator of the moiety-amount[x]-comparator. Quantitative value for this moiety.
moiety_amount_x_code String The moiety-amount[x]-code of the moiety-amount[x]-code. Quantitative value for this moiety.
moiety_amountType_coding String The coding of the moiety-amountType. The measurement type of the quantitative value.
moiety_amountType_text String The text of the moiety-amountType. The measurement type of the quantitative value.
property_id String The property-id of the property-id. Unique id for the element within a resource (for internal references). This may be any string value that does not contain spaces.
property_extension String The property-extension of the property-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.
property_modifierExtension String The property-modifierExtension of the property-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).
property_type_coding String The coding of the property-type. A code expressing the type of characteristic.
property_type_text String The text of the property-type. A code expressing the type of characteristic.
property_value_x_coding String The coding of the property-value[x]. A value for the characteristic.
property_value_x_text String The text of the property-value[x]. A value for the characteristic.
molecularWeight_id String The molecularWeight-id of the molecularWeight-id. Unique id for the element within a resource (for internal references). This may be any string value that does not contain spaces.
molecularWeight_extension String The molecularWeight-extension of the molecularWeight-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.
molecularWeight_modifierExtension String The molecularWeight-modifierExtension of the molecularWeight-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).
molecularWeight_method_coding String The coding of the molecularWeight-method. The method by which the molecular weight was determined.
molecularWeight_method_text String The text of the molecularWeight-method. The method by which the molecular weight was determined.
molecularWeight_type_coding String The coding of the molecularWeight-type. Type of molecular weight such as exact, average (also known as. number average), weight average.
molecularWeight_type_text String The text of the molecularWeight-type. Type of molecular weight such as exact, average (also known as. number average), weight average.
molecularWeight_amount_value Decimal The value of the molecularWeight-amount. Used to capture quantitative values for a variety of elements. If only limits are given, the arithmetic mean would be the average. If only a single definite value for a given element is given, it would be captured in this field.
molecularWeight_amount_unit String The unit of the molecularWeight-amount. Used to capture quantitative values for a variety of elements. If only limits are given, the arithmetic mean would be the average. If only a single definite value for a given element is given, it would be captured in this field.
molecularWeight_amount_system String The system of the molecularWeight-amount. Used to capture quantitative values for a variety of elements. If only limits are given, the arithmetic mean would be the average. If only a single definite value for a given element is given, it would be captured in this field.
molecularWeight_amount_comparator String The molecularWeight-amount-comparator of the molecularWeight-amount-comparator. Used to capture quantitative values for a variety of elements. If only limits are given, the arithmetic mean would be the average. If only a single definite value for a given element is given, it would be captured in this field.
molecularWeight_amount_code String The molecularWeight-amount-code of the molecularWeight-amount-code. Used to capture quantitative values for a variety of elements. If only limits are given, the arithmetic mean would be the average. If only a single definite value for a given element is given, it would be captured in this field.
structure_id String The structure-id of the structure-id. Unique id for the element within a resource (for internal references). This may be any string value that does not contain spaces.
structure_extension String The structure-extension of the structure-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.
structure_modifierExtension String The structure-modifierExtension of the structure-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).
structure_stereochemistry_coding String The coding of the structure-stereochemistry. Stereochemistry type.
structure_stereochemistry_text String The text of the structure-stereochemistry. Stereochemistry type.
structure_opticalActivity_coding String The coding of the structure-opticalActivity. Optical activity type.
structure_opticalActivity_text String The text of the structure-opticalActivity. Optical activity type.
structure_molecularFormula String The structure-molecularFormula of the structure-molecularFormula. Molecular formula of this substance, typically using the Hill system.
structure_molecularFormulaByMoiety String The structure-molecularFormulaByMoiety of the structure-molecularFormulaByMoiety. Specified per moiety according to the Hill system, i.e. first C, then H, then alphabetical, each moiety separated by a dot.
SP_source String The SP_source 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_identifier_start String The SP_identifier_start search parameter.
SP_list String The SP_list search parameter.
SP_domain_end String The SP_domain_end search parameter.
SP_identifier_end String The SP_identifier_end search parameter.
SP_classification_end String The SP_classification_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_classification_start String The SP_classification_start search parameter.
SP_filter String The SP_filter search parameter.
SP_domain_start String The SP_domain_start search parameter.
SP_name String The SP_name search parameter.

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