mtt_obsrequests

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

Transaction table of orders at the OBR level. Analogous to ltt_obsrequests (LIMS), but for the HL7-based medical integration.

1. Columns

Name Type Length Description

obr_ID

nvarchar

36

GUID of the order (primary key).

obr_LastUpdatedTS

int

—

Timestamp of the last change (UNIX time).

obr_State

smallint

—

Status code.

obr_CreationDT

datetime

—

Creation date.

obr_CreationUser

nvarchar

255

User name of the creator.

obr_ReleaseDT

datetime

—

Release date.

obr_CancelDT

datetime

—

Cancellation date.

obr_CancelUser

nvarchar

255

User name of the canceller.

obr_CancelReason

nvarchar

120

Reason for cancellation.

obr_VisObjectID

int

—

Reference to DMS visit/case record.

obr_AccObjectID

int

—

Reference to DMS account record.

obr_PatObjectID

int

—

Reference to DMS patient record.

obr_PAVCabinetType

int

—

Cabinet type of the PAV.

obr_CommonOrder_ID

nvarchar

36

GUID of the parent common order. References mtt_commonorders.orc_ID.

obr_PlacerOrderID

nvarchar

15

Placer order ID.

obr_FillerOrderID

nvarchar

15

Filler order ID.

obr_ObservationDT

datetime

—

Time of the observation.

obr_ObsOrderSet_ID

nvarchar

7

Referenced order set.

obr_ArchiveDocID

int

—

ID of the archived DMS result document.

2. Related tables