mtt_commonorders

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

Transaction table of common orders. Maps the ORC level from HL7 messages — a common order is the parent container for one or more OBR orders.

1. Columns

Name Type Length Description

orc_ID

nvarchar

36

GUID of the common order (primary key).

orc_LastUpdatedTS

int

—

Timestamp of the last change (UNIX time).

orc_State

smallint

—

Status code.

orc_CreationDT

datetime

—

Creation date.

orc_CreationUser

nvarchar

255

User name of the creator.

orc_ReleaseDT

datetime

—

Release date.

orc_CancelDT

datetime

—

Cancellation date.

orc_CancelUser

nvarchar

255

User name of the canceller.

orc_CancelReason

nvarchar

80

Reason for cancellation.

orc_VisObjectID

int

—

Reference to DMS visit/case record.

orc_AccObjectID

int

—

Reference to DMS account record.

orc_PatObjectID

int

—

Reference to DMS patient record.

orc_PAVCabinetType

int

—

Cabinet type of the PAV (patient-file management).

orc_OrderCtrl_ID

nvarchar

2

Order-control code. References mmt_orderctrlcodes.occ_ID.

orc_PlacerOrderID

nvarchar

15

Placer order ID (assigned by the requester).

orc_FillerOrderID

nvarchar

15

Filler order ID (assigned by the lab).

2. Related tables