JDBC Driver for FHIR

Build 22.0.8462

MedicationRequest

MedicationRequest 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 associated with this medication request that are defined by business processes and/or used to refer to it when a direct URL reference to the resource itself is not appropriate. They are business identifiers assigned to this resource by the performer or other systems and remain constant as the resource is updated and propagates from server to server.
identifier_use String The identifier-use of the identifier-use. Identifiers associated with this medication request that are defined by business processes and/or used to refer to it when a direct URL reference to the resource itself is not appropriate. They are business identifiers assigned to this resource by the performer or other systems and remain constant as the resource is updated and propagates from server to server.
identifier_type_coding String The coding of the identifier-type. Identifiers associated with this medication request that are defined by business processes and/or used to refer to it when a direct URL reference to the resource itself is not appropriate. They are business identifiers assigned to this resource by the performer or other systems and remain constant as the resource is updated and propagates from server to server.
identifier_type_text String The text of the identifier-type. Identifiers associated with this medication request that are defined by business processes and/or used to refer to it when a direct URL reference to the resource itself is not appropriate. They are business identifiers assigned to this resource by the performer or other systems and remain constant as the resource is updated and propagates from server to server.
identifier_system String The identifier-system of the identifier-system. Identifiers associated with this medication request that are defined by business processes and/or used to refer to it when a direct URL reference to the resource itself is not appropriate. They are business identifiers assigned to this resource by the performer or other systems and remain constant as the resource is updated and propagates from server to server.
identifier_period_start String The start of the identifier-period. Identifiers associated with this medication request that are defined by business processes and/or used to refer to it when a direct URL reference to the resource itself is not appropriate. They are business identifiers assigned to this resource by the performer or other systems and remain constant as the resource is updated and propagates from server to server.
identifier_period_end String The end of the identifier-period. Identifiers associated with this medication request that are defined by business processes and/or used to refer to it when a direct URL reference to the resource itself is not appropriate. They are business identifiers assigned to this resource by the performer or other systems and remain constant as the resource is updated and propagates from server to server.
status String A code specifying the current state of the order. Generally, this will be active or completed state.
statusReason_coding String The coding of the statusReason. Captures the reason for the current state of the MedicationRequest.
statusReason_text String The text of the statusReason. Captures the reason for the current state of the MedicationRequest.
intent String Whether the request is a proposal, plan, or an original order.
category_coding String The coding of the category. Indicates the type of medication request (for example, where the medication is expected to be consumed or administered (i.e. inpatient or outpatient)).
category_text String The text of the category. Indicates the type of medication request (for example, where the medication is expected to be consumed or administered (i.e. inpatient or outpatient)).
priority String Indicates how quickly the Medication Request should be addressed with respect to other requests.
doNotPerform Bool If true indicates that the provider is asking for the medication request not to occur.
reported_x_ Bool Indicates if this record was captured as a secondary 'reported' record rather than as an original primary source-of-truth record. It may also indicate the source of the report.
medication_x_coding String The coding of the medication[x]. Identifies the medication being requested. This is a link to a resource that represents the medication which may be the details of the medication or simply an attribute carrying a code that identifies the medication from a known list of medications.
medication_x_text String The text of the medication[x]. Identifies the medication being requested. This is a link to a resource that represents the medication which may be the details of the medication or simply an attribute carrying a code that identifies the medication from a known list of medications.
subject_display String The display of the subject. A link to a resource representing the person or set of individuals to whom the medication will be given.
subject_reference String The reference of the subject. A link to a resource representing the person or set of individuals to whom the medication will be given.
subject_identifier_value String The value of the subject-identifier. A link to a resource representing the person or set of individuals to whom the medication will be given.
subject_type String The subject-type of the subject-type. A link to a resource representing the person or set of individuals to whom the medication will be given.
encounter_display String The display of the encounter. The Encounter during which this [x] was created or to which the creation of this record is tightly associated.
encounter_reference String The reference of the encounter. The Encounter during which this [x] was created or to which the creation of this record is tightly associated.
encounter_identifier_value String The value of the encounter-identifier. The Encounter during which this [x] was created or to which the creation of this record is tightly associated.
encounter_type String The encounter-type of the encounter-type. The Encounter during which this [x] was created or to which the creation of this record is tightly associated.
supportingInformation_display String The display of the supportingInformation. Include additional information (for example, patient height and weight) that supports the ordering of the medication.
supportingInformation_reference String The reference of the supportingInformation. Include additional information (for example, patient height and weight) that supports the ordering of the medication.
supportingInformation_identifier_value String The value of the supportingInformation-identifier. Include additional information (for example, patient height and weight) that supports the ordering of the medication.
supportingInformation_type String The supportingInformation-type of the supportingInformation-type. Include additional information (for example, patient height and weight) that supports the ordering of the medication.
authoredOn Datetime The date (and perhaps time) when the prescription was initially written or authored on.
requester_display String The display of the requester. The individual, organization, or device that initiated the request and has responsibility for its activation.
requester_reference String The reference of the requester. The individual, organization, or device that initiated the request and has responsibility for its activation.
requester_identifier_value String The value of the requester-identifier. The individual, organization, or device that initiated the request and has responsibility for its activation.
requester_type String The requester-type of the requester-type. The individual, organization, or device that initiated the request and has responsibility for its activation.
performer_display String The display of the performer. The specified desired performer of the medication treatment (e.g. the performer of the medication administration).
performer_reference String The reference of the performer. The specified desired performer of the medication treatment (e.g. the performer of the medication administration).
performer_identifier_value String The value of the performer-identifier. The specified desired performer of the medication treatment (e.g. the performer of the medication administration).
performer_type String The performer-type of the performer-type. The specified desired performer of the medication treatment (e.g. the performer of the medication administration).
performerType_coding String The coding of the performerType. Indicates the type of performer of the administration of the medication.
performerType_text String The text of the performerType. Indicates the type of performer of the administration of the medication.
recorder_display String The display of the recorder. The person who entered the order on behalf of another individual for example in the case of a verbal or a telephone order.
recorder_reference String The reference of the recorder. The person who entered the order on behalf of another individual for example in the case of a verbal or a telephone order.
recorder_identifier_value String The value of the recorder-identifier. The person who entered the order on behalf of another individual for example in the case of a verbal or a telephone order.
recorder_type String The recorder-type of the recorder-type. The person who entered the order on behalf of another individual for example in the case of a verbal or a telephone order.
reasonCode_coding String The coding of the reasonCode. The reason or the indication for ordering or not ordering the medication.
reasonCode_text String The text of the reasonCode. The reason or the indication for ordering or not ordering the medication.
reasonReference_display String The display of the reasonReference. Condition or observation that supports why the medication was ordered.
reasonReference_reference String The reference of the reasonReference. Condition or observation that supports why the medication was ordered.
reasonReference_identifier_value String The value of the reasonReference-identifier. Condition or observation that supports why the medication was ordered.
reasonReference_type String The reasonReference-type of the reasonReference-type. Condition or observation that supports why the medication was ordered.
instantiatesCanonical String The URL pointing to a protocol, guideline, orderset, or other definition that is adhered to in whole or in part by this MedicationRequest.
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 MedicationRequest.
basedOn_display String The display of the basedOn. A plan or request that is fulfilled in whole or in part by this medication request.
basedOn_reference String The reference of the basedOn. A plan or request that is fulfilled in whole or in part by this medication request.
basedOn_identifier_value String The value of the basedOn-identifier. A plan or request that is fulfilled in whole or in part by this medication request.
basedOn_type String The basedOn-type of the basedOn-type. A plan or request that is fulfilled in whole or in part by this medication request.
groupIdentifier_value String The value of the groupIdentifier. A shared identifier common to all requests that were authorized more or less simultaneously by a single author, representing the identifier of the requisition or prescription.
groupIdentifier_use String The groupIdentifier-use of the groupIdentifier-use. A shared identifier common to all requests that were authorized more or less simultaneously by a single author, representing the identifier of the requisition or prescription.
groupIdentifier_type_coding String The coding of the groupIdentifier-type. A shared identifier common to all requests that were authorized more or less simultaneously by a single author, representing the identifier of the requisition or prescription.
groupIdentifier_type_text String The text of the groupIdentifier-type. A shared identifier common to all requests that were authorized more or less simultaneously by a single author, representing the identifier of the requisition or prescription.
groupIdentifier_system String The groupIdentifier-system of the groupIdentifier-system. A shared identifier common to all requests that were authorized more or less simultaneously by a single author, representing the identifier of the requisition or prescription.
groupIdentifier_period_start Datetime The start of the groupIdentifier-period. A shared identifier common to all requests that were authorized more or less simultaneously by a single author, representing the identifier of the requisition or prescription.
groupIdentifier_period_end Datetime The end of the groupIdentifier-period. A shared identifier common to all requests that were authorized more or less simultaneously by a single author, representing the identifier of the requisition or prescription.
courseOfTherapyType_coding String The coding of the courseOfTherapyType. The description of the overall patte3rn of the administration of the medication to the patient.
courseOfTherapyType_text String The text of the courseOfTherapyType. The description of the overall patte3rn of the administration of the medication to the patient.
insurance_display String The display of the insurance. Insurance plans, coverage extensions, pre-authorizations and/or pre-determinations that may be required 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 required 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 required 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 required for delivering the requested service.
note String Extra information about the prescription that could not be conveyed by the other attributes.
dosageInstruction_system String The system of the dosageInstruction. Indicates how the medication is to be used by the patient.
dosageInstruction_comparator String The dosageInstruction-comparator of the dosageInstruction-comparator. Indicates how the medication is to be used by the patient.
dispenseRequest_id String The dispenseRequest-id of the dispenseRequest-id. Unique id for the element within a resource (for internal references). This may be any string value that does not contain spaces.
dispenseRequest_extension String The dispenseRequest-extension of the dispenseRequest-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.
dispenseRequest_modifierExtension String The dispenseRequest-modifierExtension of the dispenseRequest-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).
dispenseRequest_initialFill_id String The dispenseRequest-initialFill-id of the dispenseRequest-initialFill-id. Unique id for the element within a resource (for internal references). This may be any string value that does not contain spaces.
dispenseRequest_initialFill_extension String The dispenseRequest-initialFill-extension of the dispenseRequest-initialFill-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.
dispenseRequest_initialFill_modifierExtension String The dispenseRequest-initialFill-modifierExtension of the dispenseRequest-initialFill-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).
dispenseRequest_initialFill_quantity_value Decimal The value of the dispenseRequest-initialFill-quantity. The amount or quantity to provide as part of the first dispense.
dispenseRequest_initialFill_quantity_unit String The unit of the dispenseRequest-initialFill-quantity. The amount or quantity to provide as part of the first dispense.
dispenseRequest_initialFill_quantity_system String The system of the dispenseRequest-initialFill-quantity. The amount or quantity to provide as part of the first dispense.
dispenseRequest_initialFill_quantity_comparator String The dispenseRequest-initialFill-quantity-comparator of the dispenseRequest-initialFill-quantity-comparator. The amount or quantity to provide as part of the first dispense.
dispenseRequest_initialFill_quantity_code String The dispenseRequest-initialFill-quantity-code of the dispenseRequest-initialFill-quantity-code. The amount or quantity to provide as part of the first dispense.
dispenseRequest_initialFill_duration String The dispenseRequest-initialFill-duration of the dispenseRequest-initialFill-duration. The length of time that the first dispense is expected to last.
dispenseRequest_dispenseInterval String The dispenseRequest-dispenseInterval of the dispenseRequest-dispenseInterval. The minimum period of time that must occur between dispenses of the medication.
dispenseRequest_validityPeriod_start Datetime The start of the dispenseRequest-validityPeriod. This indicates the validity period of a prescription (stale dating the Prescription).
dispenseRequest_validityPeriod_end Datetime The end of the dispenseRequest-validityPeriod. This indicates the validity period of a prescription (stale dating the Prescription).
dispenseRequest_numberOfRepeatsAllowed String The dispenseRequest-numberOfRepeatsAllowed of the dispenseRequest-numberOfRepeatsAllowed. An integer indicating the number of times, in addition to the original dispense, (aka refills or repeats) that the patient can receive the prescribed medication. Usage Notes: This integer does not include the original order dispense. This means that if an order indicates dispense 30 tablets plus '3 repeats', then the order can be dispensed a total of 4 times and the patient can receive a total of 120 tablets. A prescriber may explicitly say that zero refills are permitted after the initial dispense.
dispenseRequest_quantity_value Decimal The value of the dispenseRequest-quantity. The amount that is to be dispensed for one fill.
dispenseRequest_quantity_unit String The unit of the dispenseRequest-quantity. The amount that is to be dispensed for one fill.
dispenseRequest_quantity_system String The system of the dispenseRequest-quantity. The amount that is to be dispensed for one fill.
dispenseRequest_quantity_comparator String The dispenseRequest-quantity-comparator of the dispenseRequest-quantity-comparator. The amount that is to be dispensed for one fill.
dispenseRequest_quantity_code String The dispenseRequest-quantity-code of the dispenseRequest-quantity-code. The amount that is to be dispensed for one fill.
dispenseRequest_expectedSupplyDuration String The dispenseRequest-expectedSupplyDuration of the dispenseRequest-expectedSupplyDuration. Identifies the period time over which the supplied product is expected to be used, or the length of time the dispense is expected to last.
dispenseRequest_performer_display String The display of the dispenseRequest-performer. Indicates the intended dispensing Organization specified by the prescriber.
dispenseRequest_performer_reference String The reference of the dispenseRequest-performer. Indicates the intended dispensing Organization specified by the prescriber.
dispenseRequest_performer_identifier_value String The value of the dispenseRequest-performer-identifier. Indicates the intended dispensing Organization specified by the prescriber.
dispenseRequest_performer_type String The dispenseRequest-performer-type of the dispenseRequest-performer-type. Indicates the intended dispensing Organization specified by the prescriber.
substitution_id String The substitution-id of the substitution-id. Unique id for the element within a resource (for internal references). This may be any string value that does not contain spaces.
substitution_extension String The substitution-extension of the substitution-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.
substitution_modifierExtension String The substitution-modifierExtension of the substitution-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).
substitution_allowed_x_ Bool The substitution-allowed[x] of the substitution-allowed[x]. True if the prescriber allows a different drug to be dispensed from what was prescribed.
substitution_reason_coding String The coding of the substitution-reason. Indicates the reason for the substitution, or why substitution must or must not be performed.
substitution_reason_text String The text of the substitution-reason. Indicates the reason for the substitution, or why substitution must or must not be performed.
priorPrescription_display String The display of the priorPrescription. A link to a resource representing an earlier order related order or prescription.
priorPrescription_reference String The reference of the priorPrescription. A link to a resource representing an earlier order related order or prescription.
priorPrescription_identifier_value String The value of the priorPrescription-identifier. A link to a resource representing an earlier order related order or prescription.
priorPrescription_type String The priorPrescription-type of the priorPrescription-type. A link to a resource representing an earlier order related order or prescription.
detectedIssue_display String The display of the detectedIssue. Indicates an actual or potential clinical issue with or between one or more active or proposed clinical actions for a patient; e.g. Drug-drug interaction, duplicate therapy, dosage alert etc.
detectedIssue_reference String The reference of the detectedIssue. Indicates an actual or potential clinical issue with or between one or more active or proposed clinical actions for a patient; e.g. Drug-drug interaction, duplicate therapy, dosage alert etc.
detectedIssue_identifier_value String The value of the detectedIssue-identifier. Indicates an actual or potential clinical issue with or between one or more active or proposed clinical actions for a patient; e.g. Drug-drug interaction, duplicate therapy, dosage alert etc.
detectedIssue_type String The detectedIssue-type of the detectedIssue-type. Indicates an actual or potential clinical issue with or between one or more active or proposed clinical actions for a patient; e.g. Drug-drug interaction, duplicate therapy, dosage alert etc.
eventHistory_display String The display of the eventHistory. Links to Provenance records for past versions of this resource or fulfilling request or event resources that identify key state transitions or updates that are likely to be relevant to a user looking at the current version of the resource.
eventHistory_reference String The reference of the eventHistory. Links to Provenance records for past versions of this resource or fulfilling request or event resources that identify key state transitions or updates that are likely to be relevant to a user looking at the current version of the resource.
eventHistory_identifier_value String The value of the eventHistory-identifier. Links to Provenance records for past versions of this resource or fulfilling request or event resources that identify key state transitions or updates that are likely to be relevant to a user looking at the current version of the resource.
eventHistory_type String The eventHistory-type of the eventHistory-type. Links to Provenance records for past versions of this resource or fulfilling request or event resources that identify key state transitions or updates that are likely to be relevant to a user looking at the current version of the resource.
SP_source String The SP_source search parameter.
SP_medication String The SP_medication search parameter.
SP_intended_performertype_start String The SP_intended_performertype_start search parameter.
SP_text String The SP_text search parameter.
SP_intended_performertype_end String The SP_intended_performertype_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_subject String The SP_subject search parameter.
SP_identifier_start String The SP_identifier_start 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_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_intended_dispenser String The SP_intended_dispenser search parameter.
SP_intended_performer String The SP_intended_performer search parameter.
SP_filter String The SP_filter search parameter.
SP_date String The SP_date search parameter.
SP_requester String The SP_requester search parameter.

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