Core 5.2 Model | Unified | servicerequest

servicerequest

The servicerequest table is related to the ServiceRequest resource that is available via the FHIR API.

The servicerequest table represents physician orders for a person.

See also:

Overview of the Unified Model
Using Terminology Concepts Mapped By Rosetta for columns represented with Rosetta-mapped terms.

Source Concepts

HIEBus orders

Table Schema

Name	Type	Description
personid	VARCHAR(38) GUID	Unique identifier representing a unique person that may include data from several sources that have been linked. This identifier is the person_id of a HIEBus recordgroup.
servicerequestid	VARCHAR(38) GUID	Internal identifier of the HIEBus source row.
code	VARCHAR	Mapped by Rosetta. The primary mapped terminology code determined to represent the service request. This is the preferred mapped concept determined by the Rosetta Terminology Service.
display	VARCHAR	Mapped by Rosetta. The primary mapped terminology description determined to represent the service request. This is the preferred mapped concept determined by the Rosetta Terminology Service.
codesystem	VARCHAR	Mapped by Rosetta. The terminology namespace of the code field. This is the preferred mapped concept determined by the Rosetta Terminology Service.
termid	INTEGER	A reference to the original primary term that can be used to show the original code or relate to alternative mappings.
alternatetermids	VARCHAR	A comma delimited list of termids that provide supplemental terms (usually in alternate coding systems) to represent the service request.
departmentcode	VARCHAR	Mapped by Rosetta. The primary mapped terminology code determined to represent the department associated with the order. This is the preferred mapped concept determined by the Rosetta Terminology Service.
departmentdisplay	VARCHAR	Mapped by Rosetta. The primary mapped terminology description determined to represent the department associated with the order. This is the preferred mapped concept determined by the Rosetta Terminology Service.
departmenttermid	INTEGER	A reference to the original primary term that can be used to show the original code or relate to alternative mappings.
occurrence	TIMESTAMP	When the service should occur.
occurrenceenddate	TIMESTAMP	If applicable, when the service should be completed.
datasource	VARCHAR	The name of the external data source. Commonly determined from the namespace of the source terminology namespace.
lastupdated	TIMESTAMP	System generated timestamp indicating the most recent change to this data row. Used for differential operations. Managed in UTC.