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:
Source Concepts
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.
|
department |
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.
|
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.
|
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.
|
Back to Tables