Observation Table

Field NameTypeModificationsComment
patientid

integer

mapped id

datetime

timestamp

timeshift

Time point the observation was made

entertime

timestamp

timeshift

Time point the entry was made into the data base.

status

short

1=out of range 2=invalidated 4=first of connection 8=caused by event 16=compressed 32=notified, not measured 64=is bigger than 128=is smaller than 1024=mandatory

stringvalue

string

type

string

For lab values only: C=correction F=Final result P=preliminary result

value

float

variableid

long