freetextitems

freetextitems table

The freetextitems table contains all observations, including laboratory results, that store text (non-numeric) data. Personal data, including references to hospital staff have been removed. All items have an associated admissionid from the admissions table.

Fields

Name	Type	Description
admissionid	integer	links the items with the admissionid in the admissions table
itemid	integer	id to identify the type of result
item	string	type of result
value	string	value of this text result
comment	string	comment associated with this result
measuredat	integer	time associated with this result in milliseconds since the first admission. Negative results imply that the sample was drawn before the first ICU admission
registeredat	integer	time the result was saved to the database in milliseconds since the first admission. Negative results imply that the sample was drawn before the first ICU admission.
registeredby	string	user group that updated the result ('System')
updatedat	integer	time the result was updated, in milliseconds since the first admission
updatedby	string	user group that updated the result ('System')
islabresult	bit	determines wheter the observation is a labresult. Currently, only freetext labresults have been released