text: insert into hierarchy (id, name, type) values ('CL_0000670', 'Sex', 'classification');
  
  
  insert into hierarchy_entry (id, hierarchy_id, code, parent, name, hierarchy_level_type_id, display_order) values ('9268c203-9033-4bc6-817a-b68475a0f4ed', 'CL_0000670', 'CI_0005430', null, 'Male', null, 2);
  insert into hierarchy_entry (id, hierarchy_id, code, parent, name, hierarchy_level_type_id, display_order) values ('2ec826d7-d631-4fe4-a9b5-11d991bd7083', 'CL_0000670', 'CI_0005444', null, 'Female', null, 1);
  insert into hierarchy_entry (id, hierarchy_id, code, parent, name, hierarchy_level_type_id, display_order) values ('d11f6a2d-6f62-4f68-8a3a-dbb5169a52ea', 'CL_0000670', 'CI_0005569', null, 'All Persons', null, 3);
  