lbf_data


If there is patient data for this table the file for this export will be found in the extracted zip folder location under the filename of lbf_data.csv

If there are non-patient data column elements that are not part of the designated record set they will be marked in the Comment's column for that data element

Description

Dynamic Field values that are part of the following forms: Demographics, Facility Specific User Information, History Form, and custom dynamically generated encounter forms

Columns

Column Type Size Nulls Auto Default Children Parents Comments
form_id INT 10 √ null
transactions.id Defined in XML R

references forms.form_id
field_id VARCHAR 31 null
layout_options.field_id Defined in XML R

references layout_options.field_id
field_value LONGTEXT 2147483647 √ NULL

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc/Asc form_id + field_id

Relationships

Close relationships within degrees of separation