mtt_obsresults

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

Transaction table of observation results at the OBX level. Analogous to ltt_obsresults (LIMS), but for the HL7-based medical integration.

1. Columns

Name Type Length Description

obx_ID

nvarchar

36

GUID of the result (primary key).

obx_LastUpdatedTS

int

—

Timestamp of the last change (UNIX time).

obx_ObsRequest_ID

nvarchar

36

GUID of the associated order. References mtt_obsrequests.obr_ID.

obx_State

smallint

—

Status code.

obx_VisObjectID

int

—

Reference to DMS visit/case record.

obx_AccObjectID

int

—

Reference to DMS account record.

obx_PatObjectID

int

—

Reference to DMS patient record.

obx_PAVCabinetType

int

—

Cabinet type of the PAV.

obx_Observation_ID

nvarchar

7

Observation ID. References mmt_observations.obs_id.

obx_Observation_CE

nvarchar

250

Coded-element identifier of the observation (HL7 CE data type).

obx_SubObs_ID

nvarchar

7

Sub-observation ID.

obx_ValueType_ID

nvarchar

2

Value type. References mmt_obsvaluetypes.ovt_ID.

obx_Value

nvarchar

50

Measured value as text.

obx_Unit_ID

nvarchar

20

Unit. References mmt_units.unt_ID.

obx_RefRange

nvarchar

60

Reference range as text.

obx_MinValue

real

—

Lower normal limit.

obx_MaxValue

real

—

Upper normal limit.

obx_AbnormFlag_ID

nvarchar

5

Abnormal flag. References mmt_obsabnormflags.oaf_id.

obx_ResultState_ID

nvarchar

1

Result state. References mmt_obsresltstates.ors_ID.

obx_FootnoteID

nvarchar

5

Footnote ID.

obx_FootnoteText

nvarchar

255

Footnote text.

obx_Comment

nvarchar

50

Free-text comment.

obx_creationdt

datetime

—

Creation date.

obx_creationuser

nvarchar

16

User name of the creator.

obx_releasedt

datetime

—

Release date.

obx_canceldt

datetime

—

Cancellation date.

obx_canceluser

nvarchar

16

User name of the canceller.

obx_cancelreason

nvarchar

120

Reason for cancellation.

2. Related tables