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 BOOLEAN 3 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_services VARCHAR 4095 ''
grp_products VARCHAR 4095 ''
grp_diags VARCHAR 4095 ''
grp_save_close BOOLEAN 3 0
grp_init_open BOOLEAN 3 0
grp_last_update TIMESTAMP 19 √ NULL
grp_referrals BOOLEAN 3 0
grp_unchecked BOOLEAN 3 0

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