labreports

The labreports table manages lab panels and ordering information that describe how a set of labobservations was ordered by a provider.

Table Schema

Name Type Description
id VARCHAR

Surrogate key. Primary key for the labreports table.

observationdate VARCHAR

The date on which the specimen associated with the lab report was collected.

placerordernumber VARCHAR

An order number created in a provider’s information system to manage the order associated with the lab report.

fillerordernumber VARCHAR

An order number created in a provider’s information system to manage the order associated with the lab report.

accessionnumber VARCHAR

The accession number provided by the lab for this lab report.

labreportcontent VARCHAR

A blob representation of contents of the lab report. Can be- text, HTML, PDF.

comment VARCHAR

An uncoded, human-readable text field to provide additional information about the lab report.

reportstatusdate VARCHAR

The date of the most recent status change associated with the lab report.

messageid INTEGER

Surrogate key. Foreign key reference to messageids.id

parentobservationsubid VARCHAR

Surrogate key. Foreign key reference to observationsubids.id

parentplacerordernumber VARCHAR

An order number created in a provider’s information system to manage the order associated with the lab report.

parentfillerordernumber VARCHAR

An order number created in a provider’s information system to manage the order associated with the lab report.

servicetext VARCHAR

An uncoded, human-readable text field to describe the concept in the serviceterm_id.

specimenactioncodetext VARCHAR

An uncoded, human-readable text field to describe the concept in the specimenactioncodeterm_id.

patient_id VARCHAR

Surrogate key. Foreign key reference to patients.id

encounter_id VARCHAR

Surrogate key. Foreign key reference to encounters.id

order_id VARCHAR

Surrogate key. Foreign key reference to orders.id

serviceterm_id INTEGER

Surrogate key. Foreign key reference to terms.id

servicealternateterm_id INTEGER

Surrogate key. Foreign key reference to terms.id

reportstatusterm_id INTEGER

Surrogate key. Foreign key reference to terms.id

labreportformat INTEGER
parentobservationterm_id INTEGER

Surrogate key. Foreign key reference to terms.id

parentlabreportserviceterm_id INTEGER

Surrogate key. Foreign key reference to terms.id

specimenactioncodeterm_id INTEGER

Surrogate key. Foreign key reference to terms.id

specimenactioncodealternateterm_id INTEGER

Surrogate key. Foreign key reference to terms.id

principalresultinterpretercaregiver_id VARCHAR

Surrogate key. Foreign key reference to caregivers.id

placerassigningauthority_id INTEGER

Surrogate key. Foreign key reference to assigningauthorities.id

fillerassigningauthority_id INTEGER

Surrogate key. Foreign key reference to assigningauthorities.id

parentplacerassigningauthority_id INTEGER

Surrogate key. Foreign key reference to assigningauthorities.id

parentfillerassigningauthority_id INTEGER

Surrogate key. Foreign key reference to assigningauthorities.id

inserteddate TIMESTAMP

Timestamp (UTC) indicating the date the row was first inserted into HIEBus.

insertedbyapplication_id SMALLINT

The application that first inserted the row into HIEBus. Foreign key reference to applications.id.

insertedbyuser_id VARCHAR

The user associated with the process that first inserted the row into HIEBus. Foreign key reference to users.id.

modifieddate TIMESTAMP

Timestamp (UTC) indicating the date the row was last modified.

modifiedbyapplication_id SMALLINT

The application that last modified the row. Foreign key reference to applications.id.

modifiedbyuser_id VARCHAR

The user associated with the process that last modified the row. Foreign key reference to users.id.

datasource_id VARCHAR

Surrogate key. Foreign key reference to datasources.id. The external data source from which the data in this row originated.

tenant_id SMALLINT

Surrogate key. Foreign key reference to tenants.id


Back to Tables