# Laboratory (LIMS)

<a id="database.lmt_obs_base"></a>

## lmt_obs_base

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

Master-data table of all observations (laboratory parameters) in the LIMS integration with LOINC axes and chemical properties. Analogous to [mmt_observations](medicine_hl7.md#database.mmt_observations) in the HL7 integration.

### Columns

| Name | Type | Length | Description |
|---|---|---|---|
| `obs_ID` | `nvarchar` | 7 | Observation ID (primary key, NOT NULL). |
| `obs_LastupdatedTS` | `int` | — | Timestamp of the last change (UNIX time). |
| `obs_Name` | `nvarchar` | 255 | Display name. |
| `obs_Position` | `int` | — | Sort position. |
| `obs_Color` | `int` | — | Display color (RGB). |
| `obs_ScsClass` | `nvarchar` | 30 | SCS classification. |
| `obs_LnComponent` | `nvarchar` | 150 | LOINC: component. |
| `obs_LnProperty` | `nvarchar` | 30 | LOINC: property. |
| `obs_LnTimeAspct` | `nvarchar` | 15 | LOINC: time-aspect. |
| `obs_LnSystem` | `nvarchar` | 100 | LOINC: system (specimen material). |
| `obs_LnScaleType` | `nvarchar` | 30 | LOINC: scale-type. |
| `obs_LnMethodType` | `nvarchar` | 50 | LOINC: method-type. |
| `obs_LnRelatedNames` | `nvarchar` | 255 | LOINC: related names. |
| `obs_LnClass` | `nvarchar` | 20 | LOINC class. |
| `obs_LnClassType` | `int` | — | LOINC class type. |
| `obs_IUPAC` | `nvarchar` | 8 | IUPAC code. |
| `obs_MolarMass` | `real` | — | Molar mass. |

### Related tables

* [lmt_obs_set_rels](laboratory_lims.md#database.lmt_obs_set_rels) — assignment to sets.
* [ltt_obsresults](laboratory_lims.md#database.ltt_obsresults) — concrete results reference these definitions.

<a id="database.lmt_obs_set_rels"></a>

## lmt_obs_set_rels

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

Connects observations ([lmt_obs_base](laboratory_lims.md#database.lmt_obs_base)) with sets ([lmt_sets](laboratory_lims.md#database.lmt_sets)), including the display order.

### Columns

| Name | Type | Length | Description |
|---|---|---|---|
| `ovd_ID` | `nvarchar` | 36 | GUID of the assignment (primary key, NOT NULL). |
| `ovd_LastUpdatedTS` | `int` | — | Timestamp of the last change (UNIX time). |
| `set_ID` | `nvarchar` | 36 | GUID of the set. References [lmt_sets.set_ID](laboratory_lims.md#database.lmt_sets). |
| `ovd_Position` | `int` | — | Display order within the set. |
| `obs_ID` | `nvarchar` | 7 | Observation ID. References [lmt_obs_base.obs_ID](laboratory_lims.md#database.lmt_obs_base). |

<a id="database.lmt_sets"></a>

## lmt_sets

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

Master-data table of sets in the laboratory-data integration (LIMS) — groupings of observations (profiles, panels, order bundles).

### Columns

| Name | Type | Length | Description |
|---|---|---|---|
| `set_ID` | `nvarchar` | 36 | GUID of the set (primary key, NOT NULL). |
| `set_LastUpdatedTS` | `int` | — | Timestamp of the last change (UNIX time). |
| `set_Name` | `nvarchar` | 50 | Display name of the set. |
| `set_Type` | `nvarchar` | 10 | Type of the set (profile/panel/order bundle). |

### Related tables

* [lmt_obs_set_rels](laboratory_lims.md#database.lmt_obs_set_rels) — assignment of observations to sets.
* [lmt_obs_base](laboratory_lims.md#database.lmt_obs_base) — observations (master data).

<a id="database.lmt_units"></a>

## lmt_units

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

Master-data table of units of measurement in the laboratory-data integration. Analogous to [mmt_units](medicine_hl7.md#database.mmt_units), but with an additional GUID.

### Columns

| Name | Type | Length | Description |
|---|---|---|---|
| `unt_ID` | `nvarchar` | 20 | Unit identifier (primary key). |
| `unt_LastUpdatedTS` | `int` | — | Timestamp of the last change (UNIX time). |
| `unt_Abbreviation` | `nvarchar` | 20 | Abbreviation of the unit. |
| `unt_Name` | `nvarchar` | 200 | Full name of the unit. |
| `unt_GUID` | `nvarchar` | 36 | Additional GUID of the unit. |

<a id="database.ltt_obsrequests"></a>

## ltt_obsrequests

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

Transaction table of orders in the LIMS integration. One row per concrete examination order to the lab, linked to the DMS objects patient/case/result.

### Columns

| Name | Type | Length | Description |
|---|---|---|---|
| `obr_ID` | `nvarchar` | 36 | GUID of the order (primary key, NOT NULL). |
| `obr_LastUpdatedTS` | `int` | — | Timestamp of the last change (UNIX time). |
| `obr_State` | `int` | — | Status code of the order. |
| `obr_CreationUser` | `nvarchar` | 255 | User name of the creator. |
| `obr_VisObjectID` | `int` | — | Reference to the DMS visit/case record (object ID). |
| `obr_AccObjectID` | `int` | — | Reference to the DMS account record (object ID). |
| `obr_PatObjectID` | `int` | — | Reference to the DMS patient record (object ID). |
| `obr_CommonOrder_ID` | `nvarchar` | 36 | GUID of the parent common order. References [mtt_commonorders.orc_ID](medicine_hl7.md#database.mtt_commonorders). |
| `obr_PlacerOrderID` | `nvarchar` | 36 | Placer order ID (number assigned by the requester). |
| `obr_FillerOrderID` | `nvarchar` | 36 | Filler order ID (number assigned by the lab). |
| `obr_ObservationDT` | `int` | — | Time of the observation (UNIX time). |
| `obr_ObsOrderSet_ID` | `nvarchar` | 7 | Referenced order set. |
| `obr_ArchiveDocID` | `int` | — | ID of the archived DMS document with the result. |
| `obr_Test` | `int` | — | Test flag (for test data). |
| `obr_UpdateCount` | `int` | — | Version counter. |
| `obr_Comment` | `nvarchar` | 255 | Free-text comment. |
| `obr_Original` | `image` | — | Original message (raw HL7 format, BLOB). |

### Related tables

* [ltt_obsresults](laboratory_lims.md#database.ltt_obsresults) — result values for the order.
* [mtt_commonorders](medicine_hl7.md#database.mtt_commonorders) — parent common order.

<a id="database.ltt_obsresults"></a>

## ltt_obsresults

> **Warning:** 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.

### 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](laboratory_lims.md#database.ltt_obsrequests). |
| `obx_State` | `int` | — | Status code of the result. |
| `obs_ID` | `nvarchar` | 7 | Observation ID. References [lmt_obs_base.obs_ID](laboratory_lims.md#database.lmt_obs_base). |
| `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](laboratory_lims.md#database.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](medicine_hl7.md#database.mmt_obsabnormflags). |
| `obx_ResultStateID` | `nvarchar` | 1 | Result-state ID. References [mmt_obsresltstates.ors_ID](medicine_hl7.md#database.mmt_obsresltstates). |
| `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). |

### Related tables

* [ltt_obsrequests](laboratory_lims.md#database.ltt_obsrequests) — parent order.
* [lmt_obs_base](laboratory_lims.md#database.lmt_obs_base) — observation master data.
* [lmt_units](laboratory_lims.md#database.lmt_units) — units.
* [mmt_obsabnormflags](medicine_hl7.md#database.mmt_obsabnormflags), [mmt_obsresltstates](medicine_hl7.md#database.mmt_obsresltstates) — flag / status encodings.