ltt_obsresults

This page was automatically generated from the database schema dump and may be incomplete or incorrect.

Transaction table of observation results in the LIMS integration. One row per single measured value for an order, including reference range, abnormality flag and HL7 status codes.

1. Columns

Name Type Length Description

obx_ID

nvarchar

36

GUID of the result (primary key, NOT NULL).

obx_LastUpdatedTS

int

—

Timestamp of the last change (UNIX time).

obr_ID

nvarchar

36

GUID of the parent order. References ltt_obsrequests.obr_ID.

obx_State

int

—

Status code of the result.

obs_ID

nvarchar

7

Observation ID. References lmt_obs_base.obs_ID.

obx_SubObs_ID

nvarchar

7

ID of a sub-observation (for multi-part observations).

obx_ValueType_ID

nvarchar

3

Value type (e.g. NM, ST).

obx_Value

nvarchar

50

Measured value as text.

obx_Unit_ID

nvarchar

36

Unit of the value. References lmt_units (GUID).

obx_CanonicalValue

nvarchar

50

Value in canonical form (converted to standard unit).

obx_CanonicalUnit

nvarchar

50

Canonical unit.

obx_RefRange

nvarchar

60

Reference range as text.

obx_MinValue

real

—

Lower normal limit.

obx_MaxValue

real

—

Upper normal limit.

obx_AbnormalFlagID

nvarchar

5

Abnormal-flag ID. References mmt_obsabnormflags.oaf_id.

obx_ResultStateID

nvarchar

1

Result-state ID. References mmt_obsresltstates.ors_ID.

obx_CreationUser

nvarchar

255

User name of the creator.

obx_GroupInfo

nvarchar

36

Grouping information.

obx_UpdateCount

int

—

Version counter.

obx_ResultChangeTS

int

—

Timestamp of the last result-value change (UNIX time).

obx_MessageIdent

nvarchar

255

HL7 message identifier.

obx_ArchiveDocID

int

—

ID of the archived DMS document with the original result.

obx_Comment

nvarchar

255

Free-text comment.

obx_Original

image

—

Original message (raw HL7 format, BLOB).

2. Related tables