layout_options


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

Holds the layout settings for a specific dynamic field in the system

Columns

Column Type Size Nulls Auto Default Children Parents Comments
form_id VARCHAR 31
layout_group_properties.grp_form_id Defined in XML R
field_id VARCHAR 31
lbf_data.field_id Defined in XML R
lbt_data.field_id Defined in XML R
shared_attributes.field_id Defined in XML R
group_id VARCHAR 31
layout_group_properties.grp_group_id Defined in XML R
title TEXT 65535 √ null
seq INT 10 0
data_type TINYINT 3 0
uor BIT 1 1
fld_length INT 10 15
max_length INT 10 0
list_id VARCHAR 100
titlecols TINYINT 3 1
datacols TINYINT 3 1
default_value VARCHAR 255
edit_options VARCHAR 36
description TEXT 65535 √ null
fld_rows INT 10 0
list_backup_id VARCHAR 100
source CHAR 1 F

F=Form, D=Demographics, H=History, E=Encounter
conditions TEXT 65535 √ null

serialized array of skip conditions
validation VARCHAR 100 √ null
codes VARCHAR 255

Indexes

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

Relationships

Close relationships within degrees of separation