ODBC Driver for FHIR

Build 24.0.9060

ServiceRequest

ServiceRequest 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. Identifiers assigned to this order instance by the orderer and/or the receiver and/or order fulfiller.
identifier_use String The identifier-use of the identifier-use. Identifiers assigned to this order instance by the orderer and/or the receiver and/or order fulfiller.
identifier_type_coding String The coding of the identifier-type. Identifiers assigned to this order instance by the orderer and/or the receiver and/or order fulfiller.
identifier_type_text String The text of the identifier-type. Identifiers assigned to this order instance by the orderer and/or the receiver and/or order fulfiller.
identifier_system String The identifier-system of the identifier-system. Identifiers assigned to this order instance by the orderer and/or the receiver and/or order fulfiller.
identifier_period_start String The start of the identifier-period. Identifiers assigned to this order instance by the orderer and/or the receiver and/or order fulfiller.
identifier_period_end String The end of the identifier-period. Identifiers assigned to this order instance by the orderer and/or the receiver and/or order fulfiller.
instantiatesCanonical String The URL pointing to a FHIR-defined protocol, guideline, orderset or other definition that is adhered to in whole or in part by this ServiceRequest.
instantiatesUri String The URL pointing to an externally maintained protocol, guideline, orderset or other definition that is adhered to in whole or in part by this ServiceRequest.
basedOn_display String The display of the basedOn. Plan/proposal/order fulfilled by this request.
basedOn_reference String The reference of the basedOn. Plan/proposal/order fulfilled by this request.
basedOn_identifier_value String The value of the basedOn-identifier. Plan/proposal/order fulfilled by this request.
basedOn_type String The basedOn-type of the basedOn-type. Plan/proposal/order fulfilled by this request.
replaces_display String The display of the replaces. The request takes the place of the referenced completed or terminated request(s).
replaces_reference String The reference of the replaces. The request takes the place of the referenced completed or terminated request(s).
replaces_identifier_value String The value of the replaces-identifier. The request takes the place of the referenced completed or terminated request(s).
replaces_type String The replaces-type of the replaces-type. The request takes the place of the referenced completed or terminated request(s).
requisition_value String The value of the requisition. A shared identifier common to all service requests that were authorized more or less simultaneously by a single author, representing the composite or group identifier.
requisition_use String The requisition-use of the requisition-use. A shared identifier common to all service requests that were authorized more or less simultaneously by a single author, representing the composite or group identifier.
requisition_type_coding String The coding of the requisition-type. A shared identifier common to all service requests that were authorized more or less simultaneously by a single author, representing the composite or group identifier.
requisition_type_text String The text of the requisition-type. A shared identifier common to all service requests that were authorized more or less simultaneously by a single author, representing the composite or group identifier.
requisition_system String The requisition-system of the requisition-system. A shared identifier common to all service requests that were authorized more or less simultaneously by a single author, representing the composite or group identifier.
requisition_period_start Datetime The start of the requisition-period. A shared identifier common to all service requests that were authorized more or less simultaneously by a single author, representing the composite or group identifier.
requisition_period_end Datetime The end of the requisition-period. A shared identifier common to all service requests that were authorized more or less simultaneously by a single author, representing the composite or group identifier.
status String The status of the order.
intent String Whether the request is a proposal, plan, an original order or a reflex order.
category_coding String The coding of the category. A code that classifies the service for searching, sorting and display purposes (e.g. 'Surgical Procedure').
category_text String The text of the category. A code that classifies the service for searching, sorting and display purposes (e.g. 'Surgical Procedure').
priority String Indicates how quickly the ServiceRequest should be addressed with respect to other requests.
doNotPerform Bool Set this to true if the record is saying that the service/procedure should NOT be performed.
code_coding String The coding of the code. A code that identifies a particular service (i.e., procedure, diagnostic investigation, or panel of investigations) that have been requested.
code_text String The text of the code. A code that identifies a particular service (i.e., procedure, diagnostic investigation, or panel of investigations) that have been requested.
orderDetail_coding String The coding of the orderDetail. Additional details and instructions about the how the services are to be delivered. For example, and order for a urinary catheter may have an order detail for an external or indwelling catheter, or an order for a bandage may require additional instructions specifying how the bandage should be applied.
orderDetail_text String The text of the orderDetail. Additional details and instructions about the how the services are to be delivered. For example, and order for a urinary catheter may have an order detail for an external or indwelling catheter, or an order for a bandage may require additional instructions specifying how the bandage should be applied.
quantity_x_value Decimal The value of the quantity[x]. An amount of service being requested which can be a quantity ( for example $1,500 home modification), a ratio ( for example, 20 half day visits per month), or a range (2.0 to 1.8 Gy per fraction).
quantity_x_unit String The unit of the quantity[x]. An amount of service being requested which can be a quantity ( for example $1,500 home modification), a ratio ( for example, 20 half day visits per month), or a range (2.0 to 1.8 Gy per fraction).
quantity_x_system String The system of the quantity[x]. An amount of service being requested which can be a quantity ( for example $1,500 home modification), a ratio ( for example, 20 half day visits per month), or a range (2.0 to 1.8 Gy per fraction).
quantity_x_comparator String The quantity[x]-comparator of the quantity[x]-comparator. An amount of service being requested which can be a quantity ( for example $1,500 home modification), a ratio ( for example, 20 half day visits per month), or a range (2.0 to 1.8 Gy per fraction).
quantity_x_code String The quantity[x]-code of the quantity[x]-code. An amount of service being requested which can be a quantity ( for example $1,500 home modification), a ratio ( for example, 20 half day visits per month), or a range (2.0 to 1.8 Gy per fraction).
subject_display String The display of the subject. On whom or what the service is to be performed. This is usually a human patient, but can also be requested on animals, groups of humans or animals, devices such as dialysis machines, or even locations (typically for environmental scans).
subject_reference String The reference of the subject. On whom or what the service is to be performed. This is usually a human patient, but can also be requested on animals, groups of humans or animals, devices such as dialysis machines, or even locations (typically for environmental scans).
subject_identifier_value String The value of the subject-identifier. On whom or what the service is to be performed. This is usually a human patient, but can also be requested on animals, groups of humans or animals, devices such as dialysis machines, or even locations (typically for environmental scans).
subject_type String The subject-type of the subject-type. On whom or what the service is to be performed. This is usually a human patient, but can also be requested on animals, groups of humans or animals, devices such as dialysis machines, or even locations (typically for environmental scans).
encounter_display String The display of the encounter. An encounter that provides additional information about the healthcare context in which this request is made.
encounter_reference String The reference of the encounter. An encounter that provides additional information about the healthcare context in which this request is made.
encounter_identifier_value String The value of the encounter-identifier. An encounter that provides additional information about the healthcare context in which this request is made.
encounter_type String The encounter-type of the encounter-type. An encounter that provides additional information about the healthcare context in which this request is made.
occurrence_x_ Datetime The date/time at which the requested service should occur.
asNeeded_x_ Bool If a CodeableConcept is present, it indicates the pre-condition for performing the service. For example 'pain', 'on flare-up', etc.
authoredOn Datetime When the request transitioned to being actionable.
requester_display String The display of the requester. The individual who initiated the request and has responsibility for its activation.
requester_reference String The reference of the requester. The individual who initiated the request and has responsibility for its activation.
requester_identifier_value String The value of the requester-identifier. The individual who initiated the request and has responsibility for its activation.
requester_type String The requester-type of the requester-type. The individual who initiated the request and has responsibility for its activation.
performerType_coding String The coding of the performerType. Desired type of performer for doing the requested service.
performerType_text String The text of the performerType. Desired type of performer for doing the requested service.
performer_display String The display of the performer. The desired performer for doing the requested service. For example, the surgeon, dermatopathologist, endoscopist, etc.
performer_reference String The reference of the performer. The desired performer for doing the requested service. For example, the surgeon, dermatopathologist, endoscopist, etc.
performer_identifier_value String The value of the performer-identifier. The desired performer for doing the requested service. For example, the surgeon, dermatopathologist, endoscopist, etc.
performer_type String The performer-type of the performer-type. The desired performer for doing the requested service. For example, the surgeon, dermatopathologist, endoscopist, etc.
locationCode_coding String The coding of the locationCode. The preferred location(s) where the procedure should actually happen in coded or free text form. E.g. at home or nursing day care center.
locationCode_text String The text of the locationCode. The preferred location(s) where the procedure should actually happen in coded or free text form. E.g. at home or nursing day care center.
locationReference_display String The display of the locationReference. A reference to the the preferred location(s) where the procedure should actually happen. E.g. at home or nursing day care center.
locationReference_reference String The reference of the locationReference. A reference to the the preferred location(s) where the procedure should actually happen. E.g. at home or nursing day care center.
locationReference_identifier_value String The value of the locationReference-identifier. A reference to the the preferred location(s) where the procedure should actually happen. E.g. at home or nursing day care center.
locationReference_type String The locationReference-type of the locationReference-type. A reference to the the preferred location(s) where the procedure should actually happen. E.g. at home or nursing day care center.
reasonCode_coding String The coding of the reasonCode. An explanation or justification for why this service is being requested in coded or textual form. This is often for billing purposes. May relate to the resources referred to in `supportingInfo`.
reasonCode_text String The text of the reasonCode. An explanation or justification for why this service is being requested in coded or textual form. This is often for billing purposes. May relate to the resources referred to in `supportingInfo`.
reasonReference_display String The display of the reasonReference. Indicates another resource that provides a justification for why this service is being requested. May relate to the resources referred to in `supportingInfo`.
reasonReference_reference String The reference of the reasonReference. Indicates another resource that provides a justification for why this service is being requested. May relate to the resources referred to in `supportingInfo`.
reasonReference_identifier_value String The value of the reasonReference-identifier. Indicates another resource that provides a justification for why this service is being requested. May relate to the resources referred to in `supportingInfo`.
reasonReference_type String The reasonReference-type of the reasonReference-type. Indicates another resource that provides a justification for why this service is being requested. May relate to the resources referred to in `supportingInfo`.
insurance_display String The display of the insurance. Insurance plans, coverage extensions, pre-authorizations and/or pre-determinations that may be needed for delivering the requested service.
insurance_reference String The reference of the insurance. Insurance plans, coverage extensions, pre-authorizations and/or pre-determinations that may be needed for delivering the requested service.
insurance_identifier_value String The value of the insurance-identifier. Insurance plans, coverage extensions, pre-authorizations and/or pre-determinations that may be needed for delivering the requested service.
insurance_type String The insurance-type of the insurance-type. Insurance plans, coverage extensions, pre-authorizations and/or pre-determinations that may be needed for delivering the requested service.
supportingInfo_display String The display of the supportingInfo. Additional clinical information about the patient or specimen that may influence the services or their interpretations. This information includes diagnosis, clinical findings and other observations. In laboratory ordering these are typically referred to as 'ask at order entry questions (AOEs)'. This includes observations explicitly requested by the producer (filler) to provide context or supporting information needed to complete the order. For example, reporting the amount of inspired oxygen for blood gas measurements.
supportingInfo_reference String The reference of the supportingInfo. Additional clinical information about the patient or specimen that may influence the services or their interpretations. This information includes diagnosis, clinical findings and other observations. In laboratory ordering these are typically referred to as 'ask at order entry questions (AOEs)'. This includes observations explicitly requested by the producer (filler) to provide context or supporting information needed to complete the order. For example, reporting the amount of inspired oxygen for blood gas measurements.
supportingInfo_identifier_value String The value of the supportingInfo-identifier. Additional clinical information about the patient or specimen that may influence the services or their interpretations. This information includes diagnosis, clinical findings and other observations. In laboratory ordering these are typically referred to as 'ask at order entry questions (AOEs)'. This includes observations explicitly requested by the producer (filler) to provide context or supporting information needed to complete the order. For example, reporting the amount of inspired oxygen for blood gas measurements.
supportingInfo_type String The supportingInfo-type of the supportingInfo-type. Additional clinical information about the patient or specimen that may influence the services or their interpretations. This information includes diagnosis, clinical findings and other observations. In laboratory ordering these are typically referred to as 'ask at order entry questions (AOEs)'. This includes observations explicitly requested by the producer (filler) to provide context or supporting information needed to complete the order. For example, reporting the amount of inspired oxygen for blood gas measurements.
specimen_display String The display of the specimen. One or more specimens that the laboratory procedure will use.
specimen_reference String The reference of the specimen. One or more specimens that the laboratory procedure will use.
specimen_identifier_value String The value of the specimen-identifier. One or more specimens that the laboratory procedure will use.
specimen_type String The specimen-type of the specimen-type. One or more specimens that the laboratory procedure will use.
bodySite_coding String The coding of the bodySite. Anatomic location where the procedure should be performed. This is the target site.
bodySite_text String The text of the bodySite. Anatomic location where the procedure should be performed. This is the target site.
note String Any other notes and comments made about the service request. For example, internal billing notes.
patientInstruction String Instructions in terms that are understood by the patient or consumer.
relevantHistory_display String The display of the relevantHistory. Key events in the history of the request.
relevantHistory_reference String The reference of the relevantHistory. Key events in the history of the request.
relevantHistory_identifier_value String The value of the relevantHistory-identifier. Key events in the history of the request.
relevantHistory_type String The relevantHistory-type of the relevantHistory-type. Key events in the history of the request.
SP_source String The SP_source search parameter.
SP_specimen String The SP_specimen search parameter.
SP_performer String The SP_performer search parameter.
SP_instantiates_canonical String The SP_instantiates_canonical search parameter.
SP_requisition_end String The SP_requisition_end search parameter.
SP_text String The SP_text search parameter.
SP_authored String The SP_authored search parameter.
SP_content String The SP_content search parameter.
SP_securitySP_start String The SP_securitySP_start search parameter.
SP_occurrence String The SP_occurrence search parameter.
SP_tagSP_start String The SP_tagSP_start search parameter.
SP_subject String The SP_subject search parameter.
SP_identifier_start String The SP_identifier_start search parameter.
SP_instantiates_uri String The SP_instantiates_uri search parameter.
SP_based_on String The SP_based_on search parameter.
SP_body_site_end String The SP_body_site_end search parameter.
SP_encounter String The SP_encounter 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_requisition_start String The SP_requisition_start search parameter.
SP_tagSP_end String The SP_tagSP_end search parameter.
SP_patient String The SP_patient 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.
SP_body_site_start String The SP_body_site_start search parameter.
SP_requester String The SP_requester search parameter.
SP_replaces String The SP_replaces search parameter.

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