lmt_obs_base

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 in the HL7 integration.

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

2. Related tables