- servicerequest – Main service request record (this page)
- servicerequest_code_coding
- servicerequest_extension
- servicerequest_extension_vcc_coding
- servicerequest_references – Normalized references; see Reference Tables
- servicerequest_id
- 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 |