Can someone please send a screenshot of the default settings for the demographics group of the forms layout. I accidentally deleted the whole group and need to rebuild it
@ekasten I had given you the layout_group_properties and layout_options please check with this tables and also I had old OpenEMR version.
INSERT INTO `layout_group_properties` (`grp_form_id`, `grp_group_id`, `grp_title`, `grp_subtitle`, `grp_mapping`, `grp_seq`, `grp_activity`, `grp_repeats`, `grp_columns`, `grp_size`, `grp_issue_type`, `grp_aco_spec`, `grp_save_close`, `grp_init_open`, `grp_referrals`, `grp_unchecked`, `grp_services`, `grp_products`, `grp_diags`, `grp_last_update`) VALUES
(‘DEM’, ‘’, ‘Demographics’, ‘’, ‘Core’, 0, 1, 0, 0, 0, ‘’, ‘’, 0, 0, 0, 0, ‘’, ‘’, ‘’, NULL),
(‘DEM’, ‘1’, ‘Who’, ‘’, ‘’, 0, 1, 0, 0, 0, ‘’, ‘’, 0, 0, 0, 0, ‘’, ‘’, ‘’, NULL),
(‘DEM’, ‘2’, ‘Contact’, ‘’, ‘’, 0, 1, 0, 0, 0, ‘’, ‘’, 0, 0, 0, 0, ‘’, ‘’, ‘’, NULL),
(‘DEM’, ‘3’, ‘Choices’, ‘’, ‘’, 0, 1, 0, 0, 0, ‘’, ‘’, 0, 0, 0, 0, ‘’, ‘’, ‘’, NULL),
(‘DEM’, ‘4’, ‘Employer’, ‘’, ‘’, 0, 1, 0, 0, 0, ‘’, ‘’, 0, 0, 0, 0, ‘’, ‘’, ‘’, NULL),
(‘DEM’, ‘5’, ‘Stats’, ‘’, ‘’, 0, 1, 0, 0, 0, ‘’, ‘’, 0, 0, 0, 0, ‘’, ‘’, ‘’, NULL),
(‘DEM’, ‘6’, ‘Misc’, ‘’, ‘’, 0, 1, 0, 0, 0, ‘’, ‘’, 0, 0, 0, 0, ‘’, ‘’, ‘’, NULL),
(‘DEM’, ‘8’, ‘Guardian’, ‘’, ‘’, 0, 1, 0, 0, 0, ‘’, ‘’, 0, 0, 0, 0, ‘’, ‘’, ‘’, NULL);
INSERT INTO `layout_options` (`form_id`, `field_id`, `group_id`, `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`, `codes`) VALUES
(‘DEM’, ‘additional_addresses’, ‘2’, ‘’, 16, 54, 1, 0, 0, ‘’, 4, 4, ‘’, ‘[\“J\”,\“SP\”]’, ‘Additional Patient Addresses’, 0, ‘’, ‘F’, NULL, NULL, ‘’),
(‘DEM’, ‘allow_health_info_ex’, ‘3’, ‘Allow Health Information Exchange’, 120, 1, 1, 0, 0, ‘yesno’, 1, 1, ‘’, ‘’, ‘’, 0, ‘’, ‘F’, NULL, NULL, ‘’),
(‘DEM’, ‘allow_imm_info_share’, ‘3’, ‘Allow Immunization Info Sharing’, 110, 1, 1, 0, 0, ‘yesno’, 1, 1, ‘’, ‘’, ‘’, 0, ‘’, ‘F’, NULL, NULL, ‘’),
(‘DEM’, ‘allow_imm_reg_use’, ‘3’, ‘Allow Immunization Registry Use’, 100, 1, 1, 0, 0, ‘yesno’, 1, 1, ‘’, ‘’, ‘’, 0, ‘’, ‘F’, NULL, NULL, ‘’),
(‘DEM’, ‘allow_patient_portal’, ‘3’, ‘Allow Patient Portal’, 130, 1, 1, 0, 0, ‘yesno’, 1, 1, ‘’, ‘’, ‘’, 0, ‘’, ‘F’, NULL, NULL, ‘’),
(‘DEM’, ‘billing_note’, ‘1’, ‘Billing Note’, 230, 2, 1, 60, 0, ‘’, 1, 3, ‘’, ‘’, ‘Patient Level Billing Note (Collections)’, 0, ‘’, ‘F’, ‘’, ‘’, ‘’),
(‘DEM’, ‘birth_fname’, ‘1’, ‘Birth Name’, 60, 2, 1, 15, 63, ‘’, 1, 3, ‘’, ‘[\“C\”,\“DAP\”]’, ‘Birth First Name’, 0, ‘’, ‘F’, ‘’, ‘’, ‘’),
(‘DEM’, ‘birth_lname’, ‘1’, ‘’, 80, 2, 1, 20, 63, ‘’, 0, 0, ‘’, ‘[\“C\”,\“DAP\”]’, ‘Birth Last Name’, 0, ‘’, ‘F’, ‘’, ‘’, ‘’),
(‘DEM’, ‘birth_mname’, ‘1’, ‘’, 70, 2, 1, 5, 63, ‘’, 0, 0, ‘’, ‘[\“C\”,\“DAP\”]’, ‘Middle Name’, 0, ‘’, ‘F’, ‘’, ‘’, ‘’),
(‘DEM’, ‘care_team_facility’, ‘3’, ‘Care Team (Facility)’, 230, 44, 1, 0, 0, ‘’, 1, 1, ‘’, ‘[\“EP\”]’, ‘’, 0, ‘’, ‘F’, NULL, NULL, ‘’),
(‘DEM’, ‘care_team_provider’, ‘3’, ‘Care Team (Provider)’, 210, 45, 1, 0, 0, ‘’, 1, 1, ‘’, ‘[\“EP\”]’, ‘’, 0, ‘’, ‘F’, NULL, NULL, ‘’),
(‘DEM’, ‘care_team_status’, ‘3’, ‘Care Team Status’, 220, 1, 1, 0, 0, ‘Care_Team_Status’, 1, 1, ‘’, ‘[\“EP\”]’, ‘Indicates whether the care team is current , represents future intentions or is now a historical record.’, 0, ‘’, ‘F’, NULL, NULL, ‘’),
(‘DEM’, ‘city’, ‘2’, ‘City’, 3, 2, 1, 15, 63, ‘’, 1, 1, ‘’, ‘[\“U\”]’, ‘City Name’, 0, ‘’, ‘F’, NULL, NULL, ‘’),
(‘DEM’, ‘cmsportal_login’, ‘3’, ‘CMS Portal Login’, 140, 2, 1, 30, 60, ‘’, 1, 1, ‘’, ‘’, ‘CMS Portal Login ID’, 0, ‘’, ‘F’, NULL, NULL, ‘’),
(‘DEM’, ‘contact_relationship’, ‘2’, ‘Emergency Contact’, 9, 2, 1, 10, 63, ‘’, 1, 1, ‘’, ‘C’, ‘Emergency Contact Person’, 0, ‘’, ‘F’, NULL, NULL, ‘’),
(‘DEM’, ‘contrastart’, ‘5’, ‘Contraceptives Start’, 11, 4, 0, 10, 10, ‘’, 1, 1, ‘’, ‘’, ‘Date contraceptive services initially provided’, 0, ‘’, ‘F’, NULL, NULL, ‘’),
(‘DEM’, ‘country_code’, ‘2’, ‘Country’, 6, 26, 1, 0, 0, ‘country’, 1, 1, ‘’, ‘’, ‘Country’, 0, ‘’, ‘F’, NULL, NULL, ‘’),
(‘DEM’, ‘county’, ‘2’, ‘County’, 7, 26, 1, 0, 0, ‘county’, 1, 1, ‘’, ‘’, ‘County’, 0, ‘’, ‘F’, NULL, NULL, ‘’),
(‘DEM’, ‘deceased_date’, ‘6’, ‘Date Deceased’, 1, 4, 1, 20, 20, ‘’, 1, 3, ‘’, ‘D’, ‘If person is deceased, then enter date of death.’, 0, ‘’, ‘F’, NULL, NULL, ‘’),
(‘DEM’, ‘deceased_reason’, ‘6’, ‘Reason Deceased’, 2, 2, 1, 30, 255, ‘’, 1, 3, ‘’, ‘’, ‘Reason for Death’, 0, ‘’, ‘F’, NULL, NULL, ‘’),
(‘DEM’, ‘DOB’, ‘1’, ‘DOB’, 90, 4, 2, 0, 10, ‘’, 1, 1, ‘’, ‘[\“D\”]’, ‘Date of Birth’, 0, ‘’, ‘F’, ‘’, ‘past_date’, ‘’),
(‘DEM’, ‘drivers_license’, ‘1’, ‘License/ID’, 150, 2, 1, 15, 63, ‘’, 1, 1, ‘’, ‘’, ‘Drivers License or State ID’, 0, ‘’, ‘F’, ‘’, ‘’, ‘’),
(‘DEM’, ‘email’, ‘2’, ‘Contact Email’, 14, 2, 1, 30, 95, ‘’, 1, 1, ‘’, ‘’, ‘Contact Email Address’, 0, ‘’, ‘F’, NULL, NULL, ‘’),
(‘DEM’, ‘email_direct’, ‘2’, ‘Trusted Email’, 15, 2, 1, 30, 95, ‘’, 1, 1, ‘’, ‘’, ‘Trusted Direct Email Address’, 0, ‘’, ‘F’, NULL, NULL, ‘’),
(‘DEM’, ‘em_city’, ‘4’, ‘City’, 6, 2, 1, 15, 63, ‘’, 1, 1, ‘’, ‘C’, ‘City Name’, 0, ‘’, ‘F’, NULL, NULL, ‘’);
Hi @Nilesh_Hake She most likely wants to fix from layout editor. Do you have a screenshot from close to her version?
1 Like
Correct, This is the form layout I am looking for the screenshot of. I tried re-building myself, but I dont think I have the fields filled in correctly. I am wondering if this is why I cannot create a new patient now.
@ekasten Can you please share me your version of OpenEMR
7.0.2
I dont know if this has anything to do with my main issue, which is the fact that I can no longer create a new patient.