Created
June 2, 2017 23:51
-
-
Save robertdown/17e548c595bbd116ae6ce69f79bb06d9 to your computer and use it in GitHub Desktop.
Labout Based Form With Every Data Type
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| # 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', '', ''); |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment