labobservations

The labobservations table manages the results of lab tests that were performed on the associated patient.

Table Schema

Name Type Description
id VARCHAR

Surrogate key. Primary key for the labobservations table.

acuitytext VARCHAR

An uncoded, human readable text field that describes the acuity of the related lab observation.

analysisdate VARCHAR

The date and time on which the specimen was evaluated.

observationdate VARCHAR

The date and time on which the specimen was obtained from the patient.

value VARCHAR

The value of the lab observation. This is the clinical result that was produced by the lab test described by the observationterm_id.

units VARCHAR

If applicable, a text representation of the units for the value column.

comment VARCHAR

An uncoded, human readable text field that provides additional information about the lab result.

normalrange VARCHAR

If applicable, a text representation of the normal range for the value of this lab.

observationresultstatusdate VARCHAR

The most recent date and time that the status of the result was changed.

sequence VARCHAR

The sequence which the lab result is managed on the related lab report.

subid VARCHAR

An additional id provided by the source to describe the result within the context of a lab report.

observationtext VARCHAR

An uncoded, human readable text field that provides additional information about the lab result value.

observationmethodtext VARCHAR

An uncoded, human readable text field that provides additional information about the method used to obtain the lab result.

observationterm_id INTEGER

Surrogate key. Foreign key reference to terms.id. The lab test that was performed to produce this lab observation.

observationalternateterm_id INTEGER

Surrogate key. Foreign key reference to terms.id

valueterm_id INTEGER

Surrogate key. Foreign key reference to terms.id

valuetermalternate_id INTEGER

Surrogate key. Foreign key reference to terms.id

valuetypeterm_id INTEGER

Surrogate key. Foreign key reference to terms.id

acuityterm_id INTEGER

Surrogate key. Foreign key reference to terms.id

acuityalternateterm_id INTEGER

Surrogate key. Foreign key reference to terms.id

observationresultstatusterm_id INTEGER

Surrogate key. Foreign key reference to terms.id

patient_id VARCHAR

Surrogate key. Foreign key reference to patients.id

performingorganizationcaregiver_id VARCHAR

Surrogate key. Foreign key reference to caregivers.id

performingorganizationmedicaldirectorcaregiver_id VARCHAR

Surrogate key. Foreign key reference to caregivers.id

unitsterm_id INTEGER

Surrogate key. Foreign key reference to terms.id

unitstermalternate_id INTEGER

Surrogate key. Foreign key reference to terms.id

observationmethodterm_id INTEGER

Surrogate key. Foreign key reference to terms.id

observationmethodalternateterm_id INTEGER

Surrogate key. Foreign key reference to terms.id

labreport_id VARCHAR

Surrogate key. Foreign key reference to labreports.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.

tenant_id SMALLINT

Surrogate key. Foreign key reference to tenants.id


Back to Tables