JDBC Driver for FHIR

Build 22.0.8462

Procedure

Procedure 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. Business identifiers assigned to this procedure by the performer or other systems which remain constant as the resource is updated and is propagated from server to server.
identifier_use String The identifier-use of the identifier-use. Business identifiers assigned to this procedure by the performer or other systems which remain constant as the resource is updated and is propagated from server to server.
identifier_type_coding String The coding of the identifier-type. Business identifiers assigned to this procedure by the performer or other systems which remain constant as the resource is updated and is propagated from server to server.
identifier_type_text String The text of the identifier-type. Business identifiers assigned to this procedure by the performer or other systems which remain constant as the resource is updated and is propagated from server to server.
identifier_system String The identifier-system of the identifier-system. Business identifiers assigned to this procedure by the performer or other systems which remain constant as the resource is updated and is propagated from server to server.
identifier_period_start String The start of the identifier-period. Business identifiers assigned to this procedure by the performer or other systems which remain constant as the resource is updated and is propagated from server to server.
identifier_period_end String The end of the identifier-period. Business identifiers assigned to this procedure by the performer or other systems which remain constant as the resource is updated and is propagated from server to server.
instantiatesCanonical String The URL pointing to a FHIR-defined protocol, guideline, order set or other definition that is adhered to in whole or in part by this Procedure.
instantiatesUri String The URL pointing to an externally maintained protocol, guideline, order set or other definition that is adhered to in whole or in part by this Procedure.
basedOn_display String The display of the basedOn. A reference to a resource that contains details of the request for this procedure.
basedOn_reference String The reference of the basedOn. A reference to a resource that contains details of the request for this procedure.
basedOn_identifier_value String The value of the basedOn-identifier. A reference to a resource that contains details of the request for this procedure.
basedOn_type String The basedOn-type of the basedOn-type. A reference to a resource that contains details of the request for this procedure.
partOf_display String The display of the partOf. A larger event of which this particular procedure is a component or step.
partOf_reference String The reference of the partOf. A larger event of which this particular procedure is a component or step.
partOf_identifier_value String The value of the partOf-identifier. A larger event of which this particular procedure is a component or step.
partOf_type String The partOf-type of the partOf-type. A larger event of which this particular procedure is a component or step.
status String A code specifying the state of the procedure. Generally, this will be the in-progress or completed state.
statusReason_coding String The coding of the statusReason. Captures the reason for the current state of the procedure.
statusReason_text String The text of the statusReason. Captures the reason for the current state of the procedure.
category_coding String The coding of the category. A code that classifies the procedure for searching, sorting and display purposes (e.g. 'Surgical Procedure').
category_text String The text of the category. A code that classifies the procedure for searching, sorting and display purposes (e.g. 'Surgical Procedure').
code_coding String The coding of the code. The specific procedure that is performed. Use text if the exact nature of the procedure cannot be coded (e.g. 'Laparoscopic Appendectomy').
code_text String The text of the code. The specific procedure that is performed. Use text if the exact nature of the procedure cannot be coded (e.g. 'Laparoscopic Appendectomy').
subject_display String The display of the subject. The person, animal or group on which the procedure was performed.
subject_reference String The reference of the subject. The person, animal or group on which the procedure was performed.
subject_identifier_value String The value of the subject-identifier. The person, animal or group on which the procedure was performed.
subject_type String The subject-type of the subject-type. The person, animal or group on which the procedure was performed.
encounter_display String The display of the encounter. The Encounter during which this Procedure was created or performed or to which the creation of this record is tightly associated.
encounter_reference String The reference of the encounter. The Encounter during which this Procedure was created or performed 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 Procedure was created or performed 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 Procedure was created or performed or to which the creation of this record is tightly associated.
performed_x_ Datetime Estimated or actual date, date-time, period, or age when the procedure was performed. Allows a period to support complex procedures that span more than one date, and also allows for the length of the procedure to be captured.
recorder_display String The display of the recorder. Individual who recorded the record and takes responsibility for its content.
recorder_reference String The reference of the recorder. Individual who recorded the record and takes responsibility for its content.
recorder_identifier_value String The value of the recorder-identifier. Individual who recorded the record and takes responsibility for its content.
recorder_type String The recorder-type of the recorder-type. Individual who recorded the record and takes responsibility for its content.
asserter_display String The display of the asserter. Individual who is making the procedure statement.
asserter_reference String The reference of the asserter. Individual who is making the procedure statement.
asserter_identifier_value String The value of the asserter-identifier. Individual who is making the procedure statement.
asserter_type String The asserter-type of the asserter-type. Individual who is making the procedure statement.
performer_id String The performer-id of the performer-id. Unique id for the element within a resource (for internal references). This may be any string value that does not contain spaces.
performer_extension String The performer-extension of the performer-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.
performer_modifierExtension String The performer-modifierExtension of the performer-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).
performer_function_coding String The coding of the performer-function. Distinguishes the type of involvement of the performer in the procedure. For example, surgeon, anaesthetist, endoscopist.
performer_function_text String The text of the performer-function. Distinguishes the type of involvement of the performer in the procedure. For example, surgeon, anaesthetist, endoscopist.
performer_actor_display String The display of the performer-actor. The practitioner who was involved in the procedure.
performer_actor_reference String The reference of the performer-actor. The practitioner who was involved in the procedure.
performer_actor_identifier_value String The value of the performer-actor-identifier. The practitioner who was involved in the procedure.
performer_actor_type String The performer-actor-type of the performer-actor-type. The practitioner who was involved in the procedure.
performer_onBehalfOf_display String The display of the performer-onBehalfOf. The organization the device or practitioner was acting on behalf of.
performer_onBehalfOf_reference String The reference of the performer-onBehalfOf. The organization the device or practitioner was acting on behalf of.
performer_onBehalfOf_identifier_value String The value of the performer-onBehalfOf-identifier. The organization the device or practitioner was acting on behalf of.
performer_onBehalfOf_type String The performer-onBehalfOf-type of the performer-onBehalfOf-type. The organization the device or practitioner was acting on behalf of.
location_display String The display of the location. The location where the procedure actually happened. E.g. a newborn at home, a tracheostomy at a restaurant.
location_reference String The reference of the location. The location where the procedure actually happened. E.g. a newborn at home, a tracheostomy at a restaurant.
location_identifier_value String The value of the location-identifier. The location where the procedure actually happened. E.g. a newborn at home, a tracheostomy at a restaurant.
location_type String The location-type of the location-type. The location where the procedure actually happened. E.g. a newborn at home, a tracheostomy at a restaurant.
reasonCode_coding String The coding of the reasonCode. The coded reason why the procedure was performed. This may be a coded entity of some type, or may simply be present as text.
reasonCode_text String The text of the reasonCode. The coded reason why the procedure was performed. This may be a coded entity of some type, or may simply be present as text.
reasonReference_display String The display of the reasonReference. The justification of why the procedure was performed.
reasonReference_reference String The reference of the reasonReference. The justification of why the procedure was performed.
reasonReference_identifier_value String The value of the reasonReference-identifier. The justification of why the procedure was performed.
reasonReference_type String The reasonReference-type of the reasonReference-type. The justification of why the procedure was performed.
bodySite_coding String The coding of the bodySite. Detailed and structured anatomical location information. Multiple locations are allowed - e.g. multiple punch biopsies of a lesion.
bodySite_text String The text of the bodySite. Detailed and structured anatomical location information. Multiple locations are allowed - e.g. multiple punch biopsies of a lesion.
outcome_coding String The coding of the outcome. The outcome of the procedure - did it resolve the reasons for the procedure being performed?.
outcome_text String The text of the outcome. The outcome of the procedure - did it resolve the reasons for the procedure being performed?.
report_display String The display of the report. This could be a histology result, pathology report, surgical report, etc.
report_reference String The reference of the report. This could be a histology result, pathology report, surgical report, etc.
report_identifier_value String The value of the report-identifier. This could be a histology result, pathology report, surgical report, etc.
report_type String The report-type of the report-type. This could be a histology result, pathology report, surgical report, etc.
complication_coding String The coding of the complication. Any complications that occurred during the procedure, or in the immediate post-performance period. These are generally tracked separately from the notes, which will typically describe the procedure itself rather than any 'post procedure' issues.
complication_text String The text of the complication. Any complications that occurred during the procedure, or in the immediate post-performance period. These are generally tracked separately from the notes, which will typically describe the procedure itself rather than any 'post procedure' issues.
complicationDetail_display String The display of the complicationDetail. Any complications that occurred during the procedure, or in the immediate post-performance period.
complicationDetail_reference String The reference of the complicationDetail. Any complications that occurred during the procedure, or in the immediate post-performance period.
complicationDetail_identifier_value String The value of the complicationDetail-identifier. Any complications that occurred during the procedure, or in the immediate post-performance period.
complicationDetail_type String The complicationDetail-type of the complicationDetail-type. Any complications that occurred during the procedure, or in the immediate post-performance period.
followUp_coding String The coding of the followUp. If the procedure required specific follow up - e.g. removal of sutures. The follow up may be represented as a simple note or could potentially be more complex, in which case the CarePlan resource can be used.
followUp_text String The text of the followUp. If the procedure required specific follow up - e.g. removal of sutures. The follow up may be represented as a simple note or could potentially be more complex, in which case the CarePlan resource can be used.
note String Any other notes and comments about the procedure.
focalDevice_id String The focalDevice-id of the focalDevice-id. Unique id for the element within a resource (for internal references). This may be any string value that does not contain spaces.
focalDevice_extension String The focalDevice-extension of the focalDevice-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.
focalDevice_modifierExtension String The focalDevice-modifierExtension of the focalDevice-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).
focalDevice_action_coding String The coding of the focalDevice-action. The kind of change that happened to the device during the procedure.
focalDevice_action_text String The text of the focalDevice-action. The kind of change that happened to the device during the procedure.
focalDevice_manipulated_display String The display of the focalDevice-manipulated. The device that was manipulated (changed) during the procedure.
focalDevice_manipulated_reference String The reference of the focalDevice-manipulated. The device that was manipulated (changed) during the procedure.
focalDevice_manipulated_identifier_value String The value of the focalDevice-manipulated-identifier. The device that was manipulated (changed) during the procedure.
focalDevice_manipulated_type String The focalDevice-manipulated-type of the focalDevice-manipulated-type. The device that was manipulated (changed) during the procedure.
usedReference_display String The display of the usedReference. Identifies medications, devices and any other substance used as part of the procedure.
usedReference_reference String The reference of the usedReference. Identifies medications, devices and any other substance used as part of the procedure.
usedReference_identifier_value String The value of the usedReference-identifier. Identifies medications, devices and any other substance used as part of the procedure.
usedReference_type String The usedReference-type of the usedReference-type. Identifies medications, devices and any other substance used as part of the procedure.
usedCode_coding String The coding of the usedCode. Identifies coded items that were used as part of the procedure.
usedCode_text String The text of the usedCode. Identifies coded items that were used as part of the procedure.
SP_location String The SP_location search parameter.
SP_source String The SP_source search parameter.
SP_performer String The SP_performer search parameter.
SP_instantiates_canonical String The SP_instantiates_canonical 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_reason_reference String The SP_reason_reference 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_encounter String The SP_encounter search parameter.
SP_list String The SP_list search parameter.
SP_reason_code_start String The SP_reason_code_start 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_part_of String The SP_part_of search parameter.
SP_filter String The SP_filter search parameter.
SP_reason_code_end String The SP_reason_code_end search parameter.
SP_date String The SP_date search parameter.

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