ODBC Driver for FHIR

Build 24.0.9060

Observation

Observation 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. A unique identifier assigned to this observation.
identifier_use String The identifier-use of the identifier-use. A unique identifier assigned to this observation.
identifier_type_coding String The coding of the identifier-type. A unique identifier assigned to this observation.
identifier_type_text String The text of the identifier-type. A unique identifier assigned to this observation.
identifier_system String The identifier-system of the identifier-system. A unique identifier assigned to this observation.
identifier_period_start String The start of the identifier-period. A unique identifier assigned to this observation.
identifier_period_end String The end of the identifier-period. A unique identifier assigned to this observation.
basedOn_display String The display of the basedOn. A plan, proposal or order that is fulfilled in whole or in part by this event. For example, a MedicationRequest may require a patient to have laboratory test performed before it is dispensed.
basedOn_reference String The reference of the basedOn. A plan, proposal or order that is fulfilled in whole or in part by this event. For example, a MedicationRequest may require a patient to have laboratory test performed before it is dispensed.
basedOn_identifier_value String The value of the basedOn-identifier. A plan, proposal or order that is fulfilled in whole or in part by this event. For example, a MedicationRequest may require a patient to have laboratory test performed before it is dispensed.
basedOn_type String The basedOn-type of the basedOn-type. A plan, proposal or order that is fulfilled in whole or in part by this event. For example, a MedicationRequest may require a patient to have laboratory test performed before it is dispensed.
partOf_display String The display of the partOf. A larger event of which this particular Observation is a component or step. For example, an observation as part of a procedure.
partOf_reference String The reference of the partOf. A larger event of which this particular Observation is a component or step. For example, an observation as part of a procedure.
partOf_identifier_value String The value of the partOf-identifier. A larger event of which this particular Observation is a component or step. For example, an observation as part of a procedure.
partOf_type String The partOf-type of the partOf-type. A larger event of which this particular Observation is a component or step. For example, an observation as part of a procedure.
status String The status of the result value.
category_coding String The coding of the category. A code that classifies the general type of observation being made.
category_text String The text of the category. A code that classifies the general type of observation being made.
code_coding String The coding of the code. Describes what was observed. Sometimes this is called the observation 'name'.
code_text String The text of the code. Describes what was observed. Sometimes this is called the observation 'name'.
subject_display String The display of the subject. The patient, or group of patients, location, or device this observation is about and into whose record the observation is placed. If the actual focus of the observation is different from the subject (or a sample of, part, or region of the subject), the `focus` element or the `code` itself specifies the actual focus of the observation.
subject_reference String The reference of the subject. The patient, or group of patients, location, or device this observation is about and into whose record the observation is placed. If the actual focus of the observation is different from the subject (or a sample of, part, or region of the subject), the `focus` element or the `code` itself specifies the actual focus of the observation.
subject_identifier_value String The value of the subject-identifier. The patient, or group of patients, location, or device this observation is about and into whose record the observation is placed. If the actual focus of the observation is different from the subject (or a sample of, part, or region of the subject), the `focus` element or the `code` itself specifies the actual focus of the observation.
subject_type String The subject-type of the subject-type. The patient, or group of patients, location, or device this observation is about and into whose record the observation is placed. If the actual focus of the observation is different from the subject (or a sample of, part, or region of the subject), the `focus` element or the `code` itself specifies the actual focus of the observation.
focus_display String The display of the focus. The actual focus of an observation when it is not the patient of record representing something or someone associated with the patient such as a spouse, parent, fetus, or donor. For example, fetus observations in a mother's record. The focus of an observation could also be an existing condition, an intervention, the subject's diet, another observation of the subject, or a body structure such as tumor or implanted device. An example use case would be using the Observation resource to capture whether the mother is trained to change her child's tracheostomy tube. In this example, the child is the patient of record and the mother is the focus.
focus_reference String The reference of the focus. The actual focus of an observation when it is not the patient of record representing something or someone associated with the patient such as a spouse, parent, fetus, or donor. For example, fetus observations in a mother's record. The focus of an observation could also be an existing condition, an intervention, the subject's diet, another observation of the subject, or a body structure such as tumor or implanted device. An example use case would be using the Observation resource to capture whether the mother is trained to change her child's tracheostomy tube. In this example, the child is the patient of record and the mother is the focus.
focus_identifier_value String The value of the focus-identifier. The actual focus of an observation when it is not the patient of record representing something or someone associated with the patient such as a spouse, parent, fetus, or donor. For example, fetus observations in a mother's record. The focus of an observation could also be an existing condition, an intervention, the subject's diet, another observation of the subject, or a body structure such as tumor or implanted device. An example use case would be using the Observation resource to capture whether the mother is trained to change her child's tracheostomy tube. In this example, the child is the patient of record and the mother is the focus.
focus_type String The focus-type of the focus-type. The actual focus of an observation when it is not the patient of record representing something or someone associated with the patient such as a spouse, parent, fetus, or donor. For example, fetus observations in a mother's record. The focus of an observation could also be an existing condition, an intervention, the subject's diet, another observation of the subject, or a body structure such as tumor or implanted device. An example use case would be using the Observation resource to capture whether the mother is trained to change her child's tracheostomy tube. In this example, the child is the patient of record and the mother is the focus.
encounter_display String The display of the encounter. The healthcare event (e.g. a patient and healthcare provider interaction) during which this observation is made.
encounter_reference String The reference of the encounter. The healthcare event (e.g. a patient and healthcare provider interaction) during which this observation is made.
encounter_identifier_value String The value of the encounter-identifier. The healthcare event (e.g. a patient and healthcare provider interaction) during which this observation is made.
encounter_type String The encounter-type of the encounter-type. The healthcare event (e.g. a patient and healthcare provider interaction) during which this observation is made.
effective_x_ Datetime The time or time-period the observed value is asserted as being true. For biological subjects - e.g. human patients - this is usually called the 'physiologically relevant time'. This is usually either the time of the procedure or of specimen collection, but very often the source of the date/time is not known, only the date/time itself.
issued String The date and time this version of the observation was made available to providers, typically after the results have been reviewed and verified.
performer_display String The display of the performer. Who was responsible for asserting the observed value as 'true'.
performer_reference String The reference of the performer. Who was responsible for asserting the observed value as 'true'.
performer_identifier_value String The value of the performer-identifier. Who was responsible for asserting the observed value as 'true'.
performer_type String The performer-type of the performer-type. Who was responsible for asserting the observed value as 'true'.
value_x_value Decimal The value of the value[x]. The information determined as a result of making the observation, if the information has a simple value.
value_x_unit String The unit of the value[x]. The information determined as a result of making the observation, if the information has a simple value.
value_x_system String The system of the value[x]. The information determined as a result of making the observation, if the information has a simple value.
value_x_comparator String The value[x]-comparator of the value[x]-comparator. The information determined as a result of making the observation, if the information has a simple value.
value_x_code String The value[x]-code of the value[x]-code. The information determined as a result of making the observation, if the information has a simple value.
dataAbsentReason_coding String The coding of the dataAbsentReason. Provides a reason why the expected value in the element Observation.value[x] is missing.
dataAbsentReason_text String The text of the dataAbsentReason. Provides a reason why the expected value in the element Observation.value[x] is missing.
interpretation_coding String The coding of the interpretation. A categorical assessment of an observation value. For example, high, low, normal.
interpretation_text String The text of the interpretation. A categorical assessment of an observation value. For example, high, low, normal.
note String Comments about the observation or the results.
bodySite_coding String The coding of the bodySite. Indicates the site on the subject's body where the observation was made (i.e. the target site).
bodySite_text String The text of the bodySite. Indicates the site on the subject's body where the observation was made (i.e. the target site).
method_coding String The coding of the method. Indicates the mechanism used to perform the observation.
method_text String The text of the method. Indicates the mechanism used to perform the observation.
specimen_display String The display of the specimen. The specimen that was used when this observation was made.
specimen_reference String The reference of the specimen. The specimen that was used when this observation was made.
specimen_identifier_value String The value of the specimen-identifier. The specimen that was used when this observation was made.
specimen_type String The specimen-type of the specimen-type. The specimen that was used when this observation was made.
device_display String The display of the device. The device used to generate the observation data.
device_reference String The reference of the device. The device used to generate the observation data.
device_identifier_value String The value of the device-identifier. The device used to generate the observation data.
device_type String The device-type of the device-type. The device used to generate the observation data.
referenceRange_id String The referenceRange-id of the referenceRange-id. Unique id for the element within a resource (for internal references). This may be any string value that does not contain spaces.
referenceRange_extension String The referenceRange-extension of the referenceRange-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.
referenceRange_modifierExtension String The referenceRange-modifierExtension of the referenceRange-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).
referenceRange_low_value Decimal The value of the referenceRange-low. The value of the low bound of the reference range. The low bound of the reference range endpoint is inclusive of the value (e.g. reference range is >=5 - <=9). If the low bound is omitted, it is assumed to be meaningless (e.g. reference range is <=2.3).
referenceRange_low_unit String The unit of the referenceRange-low. The value of the low bound of the reference range. The low bound of the reference range endpoint is inclusive of the value (e.g. reference range is >=5 - <=9). If the low bound is omitted, it is assumed to be meaningless (e.g. reference range is <=2.3).
referenceRange_low_system String The system of the referenceRange-low. The value of the low bound of the reference range. The low bound of the reference range endpoint is inclusive of the value (e.g. reference range is >=5 - <=9). If the low bound is omitted, it is assumed to be meaningless (e.g. reference range is <=2.3).
referenceRange_low_comparator String The referenceRange-low-comparator of the referenceRange-low-comparator. The value of the low bound of the reference range. The low bound of the reference range endpoint is inclusive of the value (e.g. reference range is >=5 - <=9). If the low bound is omitted, it is assumed to be meaningless (e.g. reference range is <=2.3).
referenceRange_low_code String The referenceRange-low-code of the referenceRange-low-code. The value of the low bound of the reference range. The low bound of the reference range endpoint is inclusive of the value (e.g. reference range is >=5 - <=9). If the low bound is omitted, it is assumed to be meaningless (e.g. reference range is <=2.3).
referenceRange_high_value Decimal The value of the referenceRange-high. The value of the high bound of the reference range. The high bound of the reference range endpoint is inclusive of the value (e.g. reference range is >=5 - <=9). If the high bound is omitted, it is assumed to be meaningless (e.g. reference range is >= 2.3).
referenceRange_high_unit String The unit of the referenceRange-high. The value of the high bound of the reference range. The high bound of the reference range endpoint is inclusive of the value (e.g. reference range is >=5 - <=9). If the high bound is omitted, it is assumed to be meaningless (e.g. reference range is >= 2.3).
referenceRange_high_system String The system of the referenceRange-high. The value of the high bound of the reference range. The high bound of the reference range endpoint is inclusive of the value (e.g. reference range is >=5 - <=9). If the high bound is omitted, it is assumed to be meaningless (e.g. reference range is >= 2.3).
referenceRange_high_comparator String The referenceRange-high-comparator of the referenceRange-high-comparator. The value of the high bound of the reference range. The high bound of the reference range endpoint is inclusive of the value (e.g. reference range is >=5 - <=9). If the high bound is omitted, it is assumed to be meaningless (e.g. reference range is >= 2.3).
referenceRange_high_code String The referenceRange-high-code of the referenceRange-high-code. The value of the high bound of the reference range. The high bound of the reference range endpoint is inclusive of the value (e.g. reference range is >=5 - <=9). If the high bound is omitted, it is assumed to be meaningless (e.g. reference range is >= 2.3).
referenceRange_type_coding String The coding of the referenceRange-type. Codes to indicate the what part of the targeted reference population it applies to. For example, the normal or therapeutic range.
referenceRange_type_text String The text of the referenceRange-type. Codes to indicate the what part of the targeted reference population it applies to. For example, the normal or therapeutic range.
referenceRange_appliesTo_coding String The coding of the referenceRange-appliesTo. Codes to indicate the target population this reference range applies to. For example, a reference range may be based on the normal population or a particular sex or race. Multiple `appliesTo` are interpreted as an 'AND' of the target populations. For example, to represent a target population of African American females, both a code of female and a code for African American would be used.
referenceRange_appliesTo_text String The text of the referenceRange-appliesTo. Codes to indicate the target population this reference range applies to. For example, a reference range may be based on the normal population or a particular sex or race. Multiple `appliesTo` are interpreted as an 'AND' of the target populations. For example, to represent a target population of African American females, both a code of female and a code for African American would be used.
referenceRange_age_low String The referenceRange-age-low of the referenceRange-age-low. The age at which this reference range is applicable. This is a neonatal age (e.g. number of weeks at term) if the meaning says so.
referenceRange_age_high String The referenceRange-age-high of the referenceRange-age-high. The age at which this reference range is applicable. This is a neonatal age (e.g. number of weeks at term) if the meaning says so.
referenceRange_text String The referenceRange-text of the referenceRange-text. Text based reference range in an observation which may be used when a quantitative range is not appropriate for an observation. An example would be a reference value of 'Negative' or a list or table of 'normals'.
hasMember_display String The display of the hasMember. This observation is a group observation (e.g. a battery, a panel of tests, a set of vital sign measurements) that includes the target as a member of the group.
hasMember_reference String The reference of the hasMember. This observation is a group observation (e.g. a battery, a panel of tests, a set of vital sign measurements) that includes the target as a member of the group.
hasMember_identifier_value String The value of the hasMember-identifier. This observation is a group observation (e.g. a battery, a panel of tests, a set of vital sign measurements) that includes the target as a member of the group.
hasMember_type String The hasMember-type of the hasMember-type. This observation is a group observation (e.g. a battery, a panel of tests, a set of vital sign measurements) that includes the target as a member of the group.
derivedFrom_display String The display of the derivedFrom. The target resource that represents a measurement from which this observation value is derived. For example, a calculated anion gap or a fetal measurement based on an ultrasound image.
derivedFrom_reference String The reference of the derivedFrom. The target resource that represents a measurement from which this observation value is derived. For example, a calculated anion gap or a fetal measurement based on an ultrasound image.
derivedFrom_identifier_value String The value of the derivedFrom-identifier. The target resource that represents a measurement from which this observation value is derived. For example, a calculated anion gap or a fetal measurement based on an ultrasound image.
derivedFrom_type String The derivedFrom-type of the derivedFrom-type. The target resource that represents a measurement from which this observation value is derived. For example, a calculated anion gap or a fetal measurement based on an ultrasound image.
component_id String The component-id of the component-id. Unique id for the element within a resource (for internal references). This may be any string value that does not contain spaces.
component_extension String The component-extension of the component-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.
component_modifierExtension String The component-modifierExtension of the component-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).
component_code_coding String The coding of the component-code. Describes what was observed. Sometimes this is called the observation 'code'.
component_code_text String The text of the component-code. Describes what was observed. Sometimes this is called the observation 'code'.
component_value_x_value Decimal The value of the component-value[x]. The information determined as a result of making the observation, if the information has a simple value.
component_value_x_unit String The unit of the component-value[x]. The information determined as a result of making the observation, if the information has a simple value.
component_value_x_system String The system of the component-value[x]. The information determined as a result of making the observation, if the information has a simple value.
component_value_x_comparator String The component-value[x]-comparator of the component-value[x]-comparator. The information determined as a result of making the observation, if the information has a simple value.
component_value_x_code String The component-value[x]-code of the component-value[x]-code. The information determined as a result of making the observation, if the information has a simple value.
component_dataAbsentReason_coding String The coding of the component-dataAbsentReason. Provides a reason why the expected value in the element Observation.component.value[x] is missing.
component_dataAbsentReason_text String The text of the component-dataAbsentReason. Provides a reason why the expected value in the element Observation.component.value[x] is missing.
component_interpretation_coding String The coding of the component-interpretation. A categorical assessment of an observation value. For example, high, low, normal.
component_interpretation_text String The text of the component-interpretation. A categorical assessment of an observation value. For example, high, low, normal.
SP_combo_data_absent_reason_start String The SP_combo_data_absent_reason_start search parameter.
SP_code_value_quantity String The SP_code_value_quantity search parameter.
SP_combo_value_concept_end String The SP_combo_value_concept_end search parameter.
SP_based_on String The SP_based_on search parameter.
SP_combo_code_end String The SP_combo_code_end search parameter.
SP_combo_code_value_quantity String The SP_combo_code_value_quantity search parameter.
SP_combo_value_quantity String The SP_combo_value_quantity search parameter.
SP_combo_code_start String The SP_combo_code_start search parameter.
SP_value_concept_start String The SP_value_concept_start search parameter.
SP_subject String The SP_subject search parameter.
SP_code_value_concept String The SP_code_value_concept search parameter.
SP_combo_value_concept_start String The SP_combo_value_concept_start search parameter.
SP_performer String The SP_performer search parameter.
SP_category_start String The SP_category_start search parameter.
SP_value_concept_end String The SP_value_concept_end search parameter.
SP_component_code_end String The SP_component_code_end search parameter.
SP_category_end String The SP_category_end search parameter.
SP_part_of String The SP_part_of search parameter.
SP_method_end String The SP_method_end search parameter.
SP_value_date String The SP_value_date search parameter.
SP_dna_variant String The SP_dna_variant search parameter.
SP_code_end String The SP_code_end search parameter.
SP_securitySP_end String The SP_securitySP_end search parameter.
SP_gene_amino_acid_change String The SP_gene_amino_acid_change search parameter.
SP_amino_acid_change String The SP_amino_acid_change search parameter.
SP_component_code_start String The SP_component_code_start search parameter.
SP_component_value_quantity String The SP_component_value_quantity search parameter.
SP_component_data_absent_reason_end String The SP_component_data_absent_reason_end search parameter.
SP_list String The SP_list search parameter.
SP_gene_identifier_end String The SP_gene_identifier_end search parameter.
SP_code_start String The SP_code_start search parameter.
SP_gene_identifier_start String The SP_gene_identifier_start search parameter.
SP_component_data_absent_reason_start String The SP_component_data_absent_reason_start search parameter.
SP_derived_from String The SP_derived_from search parameter.
SP_value_string String The SP_value_string search parameter.
SP_identifier_end String The SP_identifier_end search parameter.
SP_combo_code_value_concept String The SP_combo_code_value_concept search parameter.
SP_tagSP_start String The SP_tagSP_start search parameter.
SP_securitySP_start String The SP_securitySP_start search parameter.
SP_text String The SP_text search parameter.
SP_code_value_string String The SP_code_value_string search parameter.
SP_profile String The SP_profile search parameter.
SP_component_value_concept_end String The SP_component_value_concept_end search parameter.
SP_component_code_value_concept String The SP_component_code_value_concept search parameter.
SP_data_absent_reason_end String The SP_data_absent_reason_end search parameter.
SP_source String The SP_source search parameter.
SP_content String The SP_content search parameter.
SP_method_start String The SP_method_start search parameter.
SP_specimen String The SP_specimen search parameter.
SP_encounter String The SP_encounter search parameter.
SP_component_code_value_quantity String The SP_component_code_value_quantity search parameter.
SP_focus String The SP_focus search parameter.
SP_component_value_concept_start String The SP_component_value_concept_start search parameter.
SP_identifier_start String The SP_identifier_start search parameter.
SP_combo_data_absent_reason_end String The SP_combo_data_absent_reason_end search parameter.
SP_patient String The SP_patient search parameter.
SP_filter String The SP_filter search parameter.
SP_device String The SP_device search parameter.
SP_has_member String The SP_has_member search parameter.
SP_value_quantity String The SP_value_quantity search parameter.
SP_date String The SP_date search parameter.
SP_tagSP_end String The SP_tagSP_end search parameter.
SP_data_absent_reason_start String The SP_data_absent_reason_start search parameter.
SP_code_value_date String The SP_code_value_date search parameter.
SP_gene_dnavariant String The SP_gene_dnavariant search parameter.

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