mmt_observations

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

Central master-data table of the medical-data integration: holds the definitions of all observations (lab values, examinations, diagnostic parameters) with standard unit, standard reference range, LOINC components and classification.

1. Columns

Name Type Length Description

obs_id

nvarchar

7

Observation ID (primary key).

obs_lastupdatedTS

int

—

Timestamp of the last change (UNIX time).

obs_name

nvarchar

50

Display name of the observation.

obs_StdValType_ID

nvarchar

2

Standard value type. References mmt_obsvaluetypes.

obs_StdUnit_ID

nvarchar

20

Standard unit. References mmt_units.

obs_StdRefRange

nvarchar

60

Standard reference range as text (e.g. "70-110").

obs_StdMinValue

real

—

Lower normal limit of the standard range.

obs_StdMaxValue

real

—

Upper normal limit of the standard range.

obs_Position

int

—

Sort position in list displays.

obs_Color

int

—

Display color (RGB value).

obs_ScsClass

nvarchar

30

SCS classification.

obs_LnComponent

nvarchar

150

LOINC: component axis.

obs_LnProperty

nvarchar

30

LOINC: property axis.

obs_LnTimeAspct

nvarchar

15

LOINC: time-aspect axis.

obs_LnSystem

nvarchar

100

LOINC: system axis (specimen material).

obs_LnScaleType

nvarchar

30

LOINC: scale-type axis.

obs_LnMethodType

nvarchar

50

LOINC: method-type axis.

obs_LnRelatedNames

nvarchar

255

LOINC: related names.

obs_LnClass

nvarchar

20

LOINC class.

obs_LnClassType

smallint

—

LOINC class type.

obs_IUPAC

nvarchar

8

IUPAC code.

obs_MolarMass

real

—

Molar mass (for substance-quantity calculations).

obs_altcode

nvarchar

50

Alternative code.

obs_material

nvarchar

255

Specimen-material description.

obs_comment

nvarchar

255

Descriptive comment.

obs_lnmoleid

nvarchar

20

LOINC molecule ID.

obs_lnshortname

nvarchar

50

LOINC short name.

obs_lnrelnames2

nvarchar

255

LOINC: further related names.

obs_euclide

nvarchar

20

EUCLIDES code.

obs_snowmed

nvarchar

20

SNOMED code.

2. Related tables