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:

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.

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