ltt_obsrequests

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.

1. 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.

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).

2. Related tables