servicerequest

A record of a request for service such as diagnostic investigations, treatments, or operations to be performed. See the HL7 FHIR R4 spec for full details.

Tables in this resource:

• servicerequest – Main service request record (this page)
• servicerequest_code_coding
• servicerequest_extension
• servicerequest_extension_vcc_coding
• servicerequest_references – Normalized references; see Reference Tables

Primary Keys:

• servicerequest_id

Foreign Keys:

• patient_id - links to the patient table (subject)

_{† Metriport Platform added}

Column	Data Type	Description
servicerequest_id	varchar	Unique identifier for the service request
patient_id	varchar	Unique identifier for the patient (subject)
status	varchar	Status of the request
occurrencedatetime	datetime	When the service should occur, if given as date/time (ServiceRequest.occurrenceDateTime)
code_text	varchar	Free-text description of the requested service
code_cpt_code†	varchar	CPT code for the requested service
code_cpt_display†	varchar	Human-readable CPT description
code_snomed_code†	varchar	SNOMED CT code for the requested service
code_snomed_display†	varchar	Human-readable SNOMED CT description
intent	varchar	Intent of the request (e.g. order, plan)
priority	varchar	Request priority (ServiceRequest.priority)
meta_source	varchar	Source document filename from FHIR meta.source
data_source_ext†	varchar	Integration source of the data, derived from FHIR extension

Related Tables:

Parent:

• patient

Child:

• servicerequest_code_coding
• servicerequest_extension