layout_group_properties


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

Record of the grouped fields used in dynamic layout based forms (LBF)

Columns

Column Type Size Nulls Auto Default Children Parents Comments
grp_form_id VARCHAR 31 null
layout_options.form_id Defined in XML R
grp_group_id VARCHAR 31
layout_options.group_id Defined in XML R

empty when representing the whole form
grp_title VARCHAR 63

descriptive name of the form or group
grp_subtitle VARCHAR 63

for display under the title
grp_mapping VARCHAR 31

the form category
grp_seq INT 10 0

optional order within mapping
grp_activity BIT 1 1
grp_repeats INT 10 0
grp_columns INT 10 0
grp_size INT 10 0
grp_issue_type VARCHAR 75
grp_aco_spec VARCHAR 63
grp_save_close BIT 1 0
grp_init_open BIT 1 0
grp_referrals BIT 1 0
grp_unchecked BIT 1 0
grp_services VARCHAR 4095
grp_products VARCHAR 4095
grp_diags VARCHAR 4095
grp_last_update TIMESTAMP 19 √ null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc/Asc grp_form_id + grp_group_id

Relationships

Close relationships within degrees of separation