Labout Based Form With Every Data Type

test_form_every_datatype.sql

# Will need to change the datababase name if needed
INSERT INTO openemr.list_options (list_id, option_id, title, seq, is_default, option_value, mapping, notes, codes, toggle_setting_1, toggle_setting_2, activity, subtype, edit_options, timestamp) VALUES ('lbfnames', 'LBFfull_lbv_form', 'Full LBV Form', 0, 0, 0, '', '{}', '', 0, 0, 1, '', 1, '2017-06-02 17:43:59');
INSERT INTO openemr.layout_options (form_id, field_id, group_name, title, seq, data_type, uor, fld_length, max_length, list_id, titlecols, datacols, default_value, edit_options, description, fld_rows, list_backup_id, source, conditions, validation) VALUES ('LBFfull_lbv_form', 'Allergies', '2Group 2', 'Allergies', 140, 24, 1, 0, 0, '', 1, 1, '', '', '', 0, '', 'F', '', '');
INSERT INTO openemr.layout_options (form_id, field_id, group_name, title, seq, data_type, uor, fld_length, max_length, list_id, titlecols, datacols, default_value, edit_options, description, fld_rows, list_backup_id, source, conditions, validation) VALUES ('LBFfull_lbv_form', 'BillingCodes', '2Group 2', 'Billing Codes', 80, 15, 1, 20, 0, '', 1, 1, '', '', '', 0, '', 'F', '', '');
INSERT INTO openemr.layout_options (form_id, field_id, group_name, title, seq, data_type, uor, fld_length, max_length, list_id, titlecols, datacols, default_value, edit_options, description, fld_rows, list_backup_id, source, conditions, validation) VALUES ('LBFfull_lbv_form', 'Checkbox', '2Group 2', 'Checkbox', 110, 21, 1, 1, 0, 'yesno', 1, 1, '', '', '', 0, '', 'F', '', '');
INSERT INTO openemr.layout_options (form_id, field_id, group_name, title, seq, data_type, uor, fld_length, max_length, list_id, titlecols, datacols, default_value, edit_options, description, fld_rows, list_backup_id, source, conditions, validation) VALUES ('LBFfull_lbv_form', 'chk_with_text', '2Group 2', 'Checkbox with text', 150, 25, 1, 20, 0, 'boolean', 1, 1, '', '', '', 0, '', 'F', '', '');
INSERT INTO openemr.layout_options (form_id, field_id, group_name, title, seq, data_type, uor, fld_length, max_length, list_id, titlecols, datacols, default_value, edit_options, description, fld_rows, list_backup_id, source, conditions, validation) VALUES ('LBFfull_lbv_form', 'ExamResults', '2Group 2', 'Exam Results', 130, 23, 1, 20, 0, 'reaction', 1, 1, '', '', '', 0, '', 'F', '', '');
INSERT INTO openemr.layout_options (form_id, field_id, group_name, title, seq, data_type, uor, fld_length, max_length, list_id, titlecols, datacols, default_value, edit_options, description, fld_rows, list_backup_id, source, conditions, validation) VALUES ('LBFfull_lbv_form', 'Facilities', '2Group 2', 'Facilities', 230, 35, 1, 0, 0, '', 1, 1, '', '', '', 0, '', 'F', '', '');
INSERT INTO openemr.layout_options (form_id, field_id, group_name, title, seq, data_type, uor, fld_length, max_length, list_id, titlecols, datacols, default_value, edit_options, description, fld_rows, list_backup_id, source, conditions, validation) VALUES ('LBFfull_lbv_form', 'image', '2Group 2', 'Image Canvas', 250, 40, 1, 20, 0, '', 1, 1, '', '', '', 0, '', 'F', '', '');
INSERT INTO openemr.layout_options (form_id, field_id, group_name, title, seq, data_type, uor, fld_length, max_length, list_id, titlecols, datacols, default_value, edit_options, description, fld_rows, list_backup_id, source, conditions, validation) VALUES ('LBFfull_lbv_form', 'Insurances', '2Group 2', 'Insurances', 90, 16, 1, 0, 0, '', 1, 1, '', '', '', 0, '', 'F', '', '');
INSERT INTO openemr.layout_options (form_id, field_id, group_name, title, seq, data_type, uor, fld_length, max_length, list_id, titlecols, datacols, default_value, edit_options, description, fld_rows, list_backup_id, source, conditions, validation) VALUES ('LBFfull_lbv_form', 'Lifestyle', '2Group 2', 'Lifestyle', 180, 28, 1, 20, 0, '', 1, 1, '', '', '', 0, '', 'F', '', '');
INSERT INTO openemr.layout_options (form_id, field_id, group_name, title, seq, data_type, uor, fld_length, max_length, list_id, titlecols, datacols, default_value, edit_options, description, fld_rows, list_backup_id, source, conditions, validation) VALUES ('LBFfull_lbv_form', 'list_box', '2Group 2', 'List Box', 10, 1, 1, 0, 0, 'issue_types', 1, 1, '', '', '', 0, '', 'F', '', '');
INSERT INTO openemr.layout_options (form_id, field_id, group_name, title, seq, data_type, uor, fld_length, max_length, list_id, titlecols, datacols, default_value, edit_options, description, fld_rows, list_backup_id, source, conditions, validation) VALUES ('LBFfull_lbv_form', 'lst_with_add', '2Group 2', 'List box with add', 160, 26, 1, 0, 0, 'allergy_issue_list', 1, 1, '', '', '', 0, '', 'F', '', '');
INSERT INTO openemr.layout_options (form_id, field_id, group_name, title, seq, data_type, uor, fld_length, max_length, list_id, titlecols, datacols, default_value, edit_options, description, fld_rows, list_backup_id, source, conditions, validation) VALUES ('LBFfull_lbv_form', 'multiselect', '2Group 2', 'Multiple Select List', 240, 36, 1, 0, 0, 'allergy_issue_list', 1, 1, '', '', '', 0, '', 'F', '', '');
INSERT INTO openemr.layout_options (form_id, field_id, group_name, title, seq, data_type, uor, fld_length, max_length, list_id, titlecols, datacols, default_value, edit_options, description, fld_rows, list_backup_id, source, conditions, validation) VALUES ('LBFfull_lbv_form', 'nationnotes', '2Group 2', 'Nation Note', 220, 34, 1, 0, 0, 'Subjective', 1, 1, '', '', '', 0, '', 'F', '', '');
INSERT INTO openemr.layout_options (form_id, field_id, group_name, title, seq, data_type, uor, fld_length, max_length, list_id, titlecols, datacols, default_value, edit_options, description, fld_rows, list_backup_id, source, conditions, validation) VALUES ('LBFfull_lbv_form', 'Organizations', '2Group 2', 'Organizations', 70, 14, 1, 0, 0, '', 1, 1, '', '', '', 0, '', 'F', '', '');
INSERT INTO openemr.layout_options (form_id, field_id, group_name, title, seq, data_type, uor, fld_length, max_length, list_id, titlecols, datacols, default_value, edit_options, description, fld_rows, list_backup_id, source, conditions, validation) VALUES ('LBFfull_lbv_form', 'Pharmacies', '2Group 2', 'Pharmacies', 60, 12, 1, 0, 0, '', 1, 1, '', '', '', 0, '', 'F', '', '');
INSERT INTO openemr.layout_options (form_id, field_id, group_name, title, seq, data_type, uor, fld_length, max_length, list_id, titlecols, datacols, default_value, edit_options, description, fld_rows, list_backup_id, source, conditions, validation) VALUES ('LBFfull_lbv_form', 'Providers', '2Group 2', 'Providers', 40, 10, 1, 0, 0, '', 1, 1, '', '', 'Providers', 0, '', 'F', '', '');
INSERT INTO openemr.layout_options (form_id, field_id, group_name, title, seq, data_type, uor, fld_length, max_length, list_id, titlecols, datacols, default_value, edit_options, description, fld_rows, list_backup_id, source, conditions, validation) VALUES ('LBFfull_lbv_form', 'provider_npi', '2Group 2', 'Provider NPI', 50, 11, 1, 0, 0, '', 1, 1, '', '', 'Description', 0, '', 'F', '', '');
INSERT INTO openemr.layout_options (form_id, field_id, group_name, title, seq, data_type, uor, fld_length, max_length, list_id, titlecols, datacols, default_value, edit_options, description, fld_rows, list_backup_id, source, conditions, validation) VALUES ('LBFfull_lbv_form', 'race', '2Group 2', 'Race and Ethnicity', 210, 33, 1, 0, 0, 'ethrace', 1, 1, '', '', '', 0, '', 'F', '', '');
INSERT INTO openemr.layout_options (form_id, field_id, group_name, title, seq, data_type, uor, fld_length, max_length, list_id, titlecols, datacols, default_value, edit_options, description, fld_rows, list_backup_id, source, conditions, validation) VALUES ('LBFfull_lbv_form', 'Radio', '2Group 2', 'Radio', 170, 27, 1, 20, 0, 'yesno', 1, 1, '', '', '', 0, '', 'F', '', '');
INSERT INTO openemr.layout_options (form_id, field_id, group_name, title, seq, data_type, uor, fld_length, max_length, list_id, titlecols, datacols, default_value, edit_options, description, fld_rows, list_backup_id, source, conditions, validation) VALUES ('LBFfull_lbv_form', 'smoking', '2Group 2', 'Smoking Status', 200, 32, 1, 20, 0, '', 1, 1, '', '', '', 0, '', 'F', '', '');
INSERT INTO openemr.layout_options (form_id, field_id, group_name, title, seq, data_type, uor, fld_length, max_length, list_id, titlecols, datacols, default_value, edit_options, description, fld_rows, list_backup_id, source, conditions, validation) VALUES ('LBFfull_lbv_form', 'squads', '2Group 2', 'Squads', 10, 13, 1, 0, 0, '', 1, 1, '', '', '', 0, '', 'F', '', '');
INSERT INTO openemr.layout_options (form_id, field_id, group_name, title, seq, data_type, uor, fld_length, max_length, list_id, titlecols, datacols, default_value, edit_options, description, fld_rows, list_backup_id, source, conditions, validation) VALUES ('LBFfull_lbv_form', 'Static', '2Group 2', 'Static', 190, 31, 1, 0, 0, '', 1, 1, '', '', '', 0, '', 'F', '', '');
INSERT INTO openemr.layout_options (form_id, field_id, group_name, title, seq, data_type, uor, fld_length, max_length, list_id, titlecols, datacols, default_value, edit_options, description, fld_rows, list_backup_id, source, conditions, validation) VALUES ('LBFfull_lbv_form', 'TextboxList', '2Group 2', 'Textbox List', 120, 22, 1, 20, 0, 'marital', 1, 1, '', '', '', 0, '', 'F', '', '');
INSERT INTO openemr.layout_options (form_id, field_id, group_name, title, seq, data_type, uor, fld_length, max_length, list_id, titlecols, datacols, default_value, edit_options, description, fld_rows, list_backup_id, source, conditions, validation) VALUES ('LBFfull_lbv_form', 'txtarea_label', '2Group 2', 'Textarea Label', 20, 3, 1, 20, 0, '', 1, 1, '', '', 'Description', 0, '', 'F', '', '');
INSERT INTO openemr.layout_options (form_id, field_id, group_name, title, seq, data_type, uor, fld_length, max_length, list_id, titlecols, datacols, default_value, edit_options, description, fld_rows, list_backup_id, source, conditions, validation) VALUES ('LBFfull_lbv_form', 'txt_date', '2Group 2', 'Text Date Label', 30, 4, 1, 0, 0, '', 1, 1, '', '', '', 0, '', 'F', '', '');
INSERT INTO openemr.layout_options (form_id, field_id, group_name, title, seq, data_type, uor, fld_length, max_length, list_id, titlecols, datacols, default_value, edit_options, description, fld_rows, list_backup_id, source, conditions, validation) VALUES ('LBFfull_lbv_form', 'txt_label', '2Group 2', 'Text Box Label', 10, 2, 1, 20, 0, '', 1, 1, '', '', '', 0, '', 'F', '', '');
INSERT INTO openemr.layout_options (form_id, field_id, group_name, title, seq, data_type, uor, fld_length, max_length, list_id, titlecols, datacols, default_value, edit_options, description, fld_rows, list_backup_id, source, conditions, validation) VALUES ('LBFfull_lbv_form', 'Visits', '2Group 2', 'Visits', 100, 18, 1, 0, 0, '', 1, 1, '', '', '', 0, '', 'F', '', '');