INSERT INTO public.quaadpoint_tag (id, procedure_needed, documents_needed, "scope", additional_param, "period", scope2, where_notagid, isglobalscope, document_scope) VALUES(1, '3', 1, 'institution', 'and institution.id=___ins_id___', -1, NULL, 'false', false, 'institution'); INSERT INTO public.quaadpoint_tag (id, procedure_needed, documents_needed, "scope", additional_param, "period", scope2, where_notagid, isglobalscope, document_scope) VALUES(2, '3', 1, 'v_device_plus_deviceinstallation_instid', 'and modalitytype!=''US'' and dep_id=___dep_id___ and inst_removed=false', -1, NULL, 'false', false, 'device_installation'); INSERT INTO public.quaadpoint_tag (id, procedure_needed, documents_needed, "scope", additional_param, "period", scope2, where_notagid, isglobalscope, document_scope) VALUES(3, '3', -1, 'institution', NULL, -1, NULL, 'false', false, 'department'); INSERT INTO public.quaadpoint_tag (id, procedure_needed, documents_needed, "scope", additional_param, "period", scope2, where_notagid, isglobalscope, document_scope) VALUES(4, '3', 1, 'v_device_plus_deviceinstallation_devid', 'and modalitytype!=''US'' and dep_id=___dep_id___ and inst_removed=false', -1, NULL, 'false', false, 'device'); INSERT INTO public.quaadpoint_tag (id, procedure_needed, documents_needed, "scope", additional_param, "period", scope2, where_notagid, isglobalscope, document_scope) VALUES(8, '3', 1, 'v_device_plus_deviceinstallation_devid', 'and modalitytype!=''US'' and dep_id=___dep_id___ and inst_removed=false', -1, NULL, 'false', false, 'device'); INSERT INTO public.quaadpoint_tag (id, procedure_needed, documents_needed, "scope", additional_param, "period", scope2, where_notagid, isglobalscope, document_scope) VALUES(9, '3', 1, 'v_device_plus_deviceinstallation_devid', 'and modalitytype!=''US'' and dep_id=___dep_id___ and inst_removed=false', -1, NULL, 'false', false, 'device'); INSERT INTO public.quaadpoint_tag (id, procedure_needed, documents_needed, "scope", additional_param, "period", scope2, where_notagid, isglobalscope, document_scope) VALUES(10, '3', 1, 'v_device_plus_deviceinstallation_devid', 'and modalitytype!=''US'' and dep_id=___dep_id___ and inst_removed=false', -1, 'v_bquaad_deviceinspection', 'true', false, 'device_inspection'); INSERT INTO public.quaadpoint_tag (id, procedure_needed, documents_needed, "scope", additional_param, "period", scope2, where_notagid, isglobalscope, document_scope) VALUES(11, '3', 1, 'v_device_plus_deviceinstallation_devid', 'and modalitytype!=''US'' and dep_id=___dep_id___ and inst_removed=false', -1, '', 'false', false, 'device'); INSERT INTO public.quaadpoint_tag (id, procedure_needed, documents_needed, "scope", additional_param, "period", scope2, where_notagid, isglobalscope, document_scope) VALUES(12, '3', 1, 'v_device_plus_deviceinstallation_devid', 'and modalitytype=''RI'' and dep_id=___dep_id___ and (removeddate is null or removeddate > to_date(''___start_date___'',''YYYY-MM-DD HH24:MI:SS''))', -1, '', 'false', false, 'device'); INSERT INTO public.quaadpoint_tag (id, procedure_needed, documents_needed, "scope", additional_param, "period", scope2, where_notagid, isglobalscope, document_scope) VALUES(13, '3', 1, 'v_device_plus_deviceinstallation_devid', 'and (modalitytype=''CT'' OR modalitytype=''MR'' OR modalitytype=''PET'' OR modalitytype=''PET-CT'' OR modalitytype=''PET-IRM'' OR modalitytype=''SPECT-CT'' OR modalitytype=''IRM'') and dep_id=___dep_id___ and (removeddate is null or removeddate > to_date(''___start_date___'',''YYYY-MM-DD HH24:MI:SS''))', -1, '', 'false', false, 'device'); INSERT INTO public.quaadpoint_tag (id, procedure_needed, documents_needed, "scope", additional_param, "period", scope2, where_notagid, isglobalscope, document_scope) VALUES(14, '3', 1, 'legaldocument', '', -1, '', 'false', true, 'legaldocument'); INSERT INTO public.quaadpoint_tag (id, procedure_needed, documents_needed, "scope", additional_param, "period", scope2, where_notagid, isglobalscope, document_scope) VALUES(15, '6', -1, 'department', 'and dep_id=___dep_id___ ', -1, '', 'false', false, 'department'); INSERT INTO public.quaadpoint_tag (id, procedure_needed, documents_needed, "scope", additional_param, "period", scope2, where_notagid, isglobalscope, document_scope) VALUES(16, '6', -1, 'department', 'and dep_id=___dep_id___ ', -1, '', 'false', false, 'department'); INSERT INTO public.quaadpoint_tag (id, procedure_needed, documents_needed, "scope", additional_param, "period", scope2, where_notagid, isglobalscope, document_scope) VALUES(17, '6', -1, 'department', 'and dep_id=___dep_id___ ', -1, '', 'false', false, 'department'); INSERT INTO public.quaadpoint_tag (id, procedure_needed, documents_needed, "scope", additional_param, "period", scope2, where_notagid, isglobalscope, document_scope) VALUES(18, '6', -1, 'department', 'and dep_id=___dep_id___ ', -1, '', 'false', false, 'department'); INSERT INTO public.quaadpoint_tag (id, procedure_needed, documents_needed, "scope", additional_param, "period", scope2, where_notagid, isglobalscope, document_scope) VALUES(19, '6', -1, 'department', 'and dep_id=___dep_id___ ', -1, '', 'false', false, 'department'); INSERT INTO public.quaadpoint_tag (id, procedure_needed, documents_needed, "scope", additional_param, "period", scope2, where_notagid, isglobalscope, document_scope) VALUES(20, '6', -1, 'department', 'and dep_id=___dep_id___ ', -1, '', 'false', false, 'department'); INSERT INTO public.quaadpoint_tag (id, procedure_needed, documents_needed, "scope", additional_param, "period", scope2, where_notagid, isglobalscope, document_scope) VALUES(21, '6', -1, 'department', 'and dep_id=___dep_id___ ', -1, '', 'false', false, 'department'); INSERT INTO public.quaadpoint_tag (id, procedure_needed, documents_needed, "scope", additional_param, "period", scope2, where_notagid, isglobalscope, document_scope) VALUES(22, '6', -1, 'department', 'and dep_id=___dep_id___ ', -1, '', 'false', false, 'department'); INSERT INTO public.quaadpoint_tag (id, procedure_needed, documents_needed, "scope", additional_param, "period", scope2, where_notagid, isglobalscope, document_scope) VALUES(23, '6', -1, 'department', 'and dep_id=___dep_id___ ', -1, '', 'false', false, 'department'); INSERT INTO public.quaadpoint_tag (id, procedure_needed, documents_needed, "scope", additional_param, "period", scope2, where_notagid, isglobalscope, document_scope) VALUES(24, '6', -1, 'department', 'and dep_id=___dep_id___ ', -1, '', 'false', false, 'department'); INSERT INTO public.quaadpoint_tag (id, procedure_needed, documents_needed, "scope", additional_param, "period", scope2, where_notagid, isglobalscope, document_scope) VALUES(25, '6', -1, 'department', 'and dep_id=___dep_id___ ', -1, '', 'false', false, 'department'); INSERT INTO public.quaadpoint_tag (id, procedure_needed, documents_needed, "scope", additional_param, "period", scope2, where_notagid, isglobalscope, document_scope) VALUES(26, '6', -1, 'department', 'and dep_id=___dep_id___ ', -1, '', 'false', false, 'department'); INSERT INTO public.quaadpoint_tag (id, procedure_needed, documents_needed, "scope", additional_param, "period", scope2, where_notagid, isglobalscope, document_scope) VALUES(27, '2', 1, 'staff_member', 'and id in (select staff_id from staff_job where dep_id=___dep_id___)', -1, 'staff_formation', 'false', false, 'staff_formation'); INSERT INTO public.quaadpoint_tag (id, procedure_needed, documents_needed, "scope", additional_param, "period", scope2, where_notagid, isglobalscope, document_scope) VALUES(28, '6', -1, 'staff_member', 'and id in (select staff_id from staff_job where dep_id=___dep_id___)', -1, '', 'false', false, 'staff_member'); INSERT INTO public.quaadpoint_tag (id, procedure_needed, documents_needed, "scope", additional_param, "period", scope2, where_notagid, isglobalscope, document_scope) VALUES(29, '2', 0, 'staff_member', 'and id in (select staff_id from staff_job where dep_id=___dep_id___)', -1, 'staff_formation', 'false', false, 'staff_formation'); INSERT INTO public.quaadpoint_tag (id, procedure_needed, documents_needed, "scope", additional_param, "period", scope2, where_notagid, isglobalscope, document_scope) VALUES(30, '2', 0, 'staff_member', 'and id in (select staff_id from staff_job where dep_id=___dep_id___)', -1, 'staff_formation', 'false', false, 'staff_formation'); INSERT INTO public.quaadpoint_tag (id, procedure_needed, documents_needed, "scope", additional_param, "period", scope2, where_notagid, isglobalscope, document_scope) VALUES(31, '4', -1, 'staff_member', 'and id in (select staff_id from staff_job where dep_id=___dep_id___)', -1, '', 'false', false, 'staff_member'); INSERT INTO public.quaadpoint_tag (id, procedure_needed, documents_needed, "scope", additional_param, "period", scope2, where_notagid, isglobalscope, document_scope) VALUES(32, '4', -1, 'staff_member', 'and id in (select staff_id from staff_job where dep_id=___dep_id___)', -1, '', 'false', false, 'staff_member'); INSERT INTO public.quaadpoint_tag (id, procedure_needed, documents_needed, "scope", additional_param, "period", scope2, where_notagid, isglobalscope, document_scope) VALUES(33, '4', -1, 'staff_member', 'and id in (select staff_id from staff_job where dep_id=___dep_id___)', -1, '', 'false', false, 'staff_member'); INSERT INTO public.quaadpoint_tag (id, procedure_needed, documents_needed, "scope", additional_param, "period", scope2, where_notagid, isglobalscope, document_scope) VALUES(34, '2', -1, 'staff_member', 'and id in (select staff_id from staff_job where dep_id=___dep_id___)', -1, '', 'false', false, 'staff_member'); INSERT INTO public.quaadpoint_tag (id, procedure_needed, documents_needed, "scope", additional_param, "period", scope2, where_notagid, isglobalscope, document_scope) VALUES(35, '6', -1, 'department', 'and dep_id=___dep_id___ ', -1, '', 'false', false, 'department'); INSERT INTO public.quaadpoint_tag (id, procedure_needed, documents_needed, "scope", additional_param, "period", scope2, where_notagid, isglobalscope, document_scope) VALUES(36, '6', -1, 'department', 'and dep_id=___dep_id___ ', -1, '', 'false', false, 'department'); INSERT INTO public.quaadpoint_tag (id, procedure_needed, documents_needed, "scope", additional_param, "period", scope2, where_notagid, isglobalscope, document_scope) VALUES(37, '6', -1, 'department', 'and dep_id=___dep_id___ ', -1, '', 'false', false, 'department'); INSERT INTO public.quaadpoint_tag (id, procedure_needed, documents_needed, "scope", additional_param, "period", scope2, where_notagid, isglobalscope, document_scope) VALUES(38, '6', -1, 'department', 'and dep_id=___dep_id___ ', -1, '', 'false', false, 'department'); INSERT INTO public.quaadpoint_tag (id, procedure_needed, documents_needed, "scope", additional_param, "period", scope2, where_notagid, isglobalscope, document_scope) VALUES(39, '6', -1, 'department', 'and dep_id=___dep_id___ ', -1, '', 'false', false, 'department'); INSERT INTO public.quaadpoint_tag (id, procedure_needed, documents_needed, "scope", additional_param, "period", scope2, where_notagid, isglobalscope, document_scope) VALUES(40, '7', -1, 'department', 'and dep_id=___dep_id___ ', -1, '', 'false', false, 'department'); INSERT INTO public.quaadpoint_tag (id, procedure_needed, documents_needed, "scope", additional_param, "period", scope2, where_notagid, isglobalscope, document_scope) VALUES(41, '7', -1, 'report', 'and dep_id=___dep_id___ ', -1, 'action', 'false', false, 'action'); INSERT INTO public.quaadpoint_tag (id, procedure_needed, documents_needed, "scope", additional_param, "period", scope2, where_notagid, isglobalscope, document_scope) VALUES(42, '1', -1, 'report', 'and dep_id=___dep_id___ ', -1, '', 'false', false, 'report'); INSERT INTO public.quaadpoint_tag (id, procedure_needed, documents_needed, "scope", additional_param, "period", scope2, where_notagid, isglobalscope, document_scope) VALUES(43, '1', -1, 'report', 'and dep_id=___dep_id___ ', -1, '', 'false', false, 'report'); INSERT INTO public.quaadpoint_tag (id, procedure_needed, documents_needed, "scope", additional_param, "period", scope2, where_notagid, isglobalscope, document_scope) VALUES(44, '1', -1, 'report', 'and dep_id=___dep_id___ ', -1, '', 'false', false, 'report'); INSERT INTO public.quaadpoint_tag (id, procedure_needed, documents_needed, "scope", additional_param, "period", scope2, where_notagid, isglobalscope, document_scope) VALUES(45, '4', -1, 'department', 'and dep_id=___dep_id___ ', -1, '', 'false', false, 'institution'); INSERT INTO public.quaadpoint_tag (id, procedure_needed, documents_needed, "scope", additional_param, "period", scope2, where_notagid, isglobalscope, document_scope) VALUES(46, '4', -1, 'department', 'and dep_id=___dep_id___ ', -1, '', 'false', false, 'institution'); INSERT INTO public.quaadpoint_tag (id, procedure_needed, documents_needed, "scope", additional_param, "period", scope2, where_notagid, isglobalscope, document_scope) VALUES(47, '4', -1, 'department', 'and dep_id=___dep_id___ ', -1, '', 'false', false, 'institution'); INSERT INTO public.quaadpoint_tag (id, procedure_needed, documents_needed, "scope", additional_param, "period", scope2, where_notagid, isglobalscope, document_scope) VALUES(48, '4', -1, 'department', 'and dep_id=___dep_id___ ', -1, '', 'false', false, 'institution'); INSERT INTO public.quaadpoint_tag (id, procedure_needed, documents_needed, "scope", additional_param, "period", scope2, where_notagid, isglobalscope, document_scope) VALUES(49, '4', -1, 'department', 'and dep_id=___dep_id___ ', -1, '', 'false', false, 'institution'); INSERT INTO public.quaadpoint_tag (id, procedure_needed, documents_needed, "scope", additional_param, "period", scope2, where_notagid, isglobalscope, document_scope) VALUES(50, '4', 1, 'afcnsend', 'and dep_id=___dep_id___ ', 12, '', 'true', false, 'afcnsend'); INSERT INTO public.quaadpoint_tag (id, procedure_needed, documents_needed, "scope", additional_param, "period", scope2, where_notagid, isglobalscope, document_scope) VALUES(51, '4', 0, 'department', 'and dep_id=___dep_id___ ', -1, '', 'false', false, 'department'); INSERT INTO public.quaadpoint_tag (id, procedure_needed, documents_needed, "scope", additional_param, "period", scope2, where_notagid, isglobalscope, document_scope) VALUES(52, '1', 0, 'department', 'and dep_id=___dep_id___ ', -1, '', 'false', false, 'department'); INSERT INTO public.quaadpoint_tag (id, procedure_needed, documents_needed, "scope", additional_param, "period", scope2, where_notagid, isglobalscope, document_scope) VALUES(53, '6', 1, 'examlist', 'and id in (select ext_id from tag_link tl where tag_id in (select tagdepid from v_taglink_instdep vti where dep_id=___dep_id___) and type=''examlist'') and removed=false', -1, '', 'true', false, 'examlist'); INSERT INTO public.quaadpoint_tag (id, procedure_needed, documents_needed, "scope", additional_param, "period", scope2, where_notagid, isglobalscope, document_scope) VALUES(54, '6', 0, 'department', 'and dep_id=___dep_id___', -1, '', 'false', false, 'department'); INSERT INTO public.quaadpoint_tag (id, procedure_needed, documents_needed, "scope", additional_param, "period", scope2, where_notagid, isglobalscope, document_scope) VALUES(55, '1', 1, 'v_device_plus_deviceinstallation_devid', 'and dep_id=___dep_id___ and (removeddate is null or removeddate > to_date(''___start_date___'',''YYYY-MM-DD HH24:MI:SS''))', -1, '', 'false', false, 'device_installation'); INSERT INTO public.quaadpoint_tag (id, procedure_needed, documents_needed, "scope", additional_param, "period", scope2, where_notagid, isglobalscope, document_scope) VALUES(56, '3', -1, 'v_device_plus_deviceinstallation_devid', 'and dep_id=___dep_id___ and (removeddate is null or removeddate > to_date(''___start_date___'',''YYYY-MM-DD HH24:MI:SS''))', -1, '', 'false', false, 'device_inspection'); INSERT INTO public.quaadpoint_tag (id, procedure_needed, documents_needed, "scope", additional_param, "period", scope2, where_notagid, isglobalscope, document_scope) VALUES(57, '3', -1, 'v_device_plus_deviceinstallation_devid', 'and dep_id=___dep_id___ and (removeddate is null or removeddate > to_date(''___start_date___'',''YYYY-MM-DD HH24:MI:SS''))', -1, '', 'false', false, 'device_maintenance'); INSERT INTO public.quaadpoint_tag (id, procedure_needed, documents_needed, "scope", additional_param, "period", scope2, where_notagid, isglobalscope, document_scope) VALUES(58, '4', 0, 'department', 'and dep_id=___dep_id___', -1, '', 'false', false, 'department'); INSERT INTO public.quaadpoint_tag (id, procedure_needed, documents_needed, "scope", additional_param, "period", scope2, where_notagid, isglobalscope, document_scope) VALUES(59, '1', -1, 'institution', '', -1, '', 'false', false, 'department'); INSERT INTO public.quaadpoint_tag (id, procedure_needed, documents_needed, "scope", additional_param, "period", scope2, where_notagid, isglobalscope, document_scope) VALUES(60, '2', -1, 'staff_member', 'and id in (select staff_id from staff_job where dep_id=___dep_id___)', -1, '', 'false', false, 'staff_member'); INSERT INTO public.quaadpoint_tag (id, procedure_needed, documents_needed, "scope", additional_param, "period", scope2, where_notagid, isglobalscope, document_scope) VALUES(61, '1', 1, 'institution', 'and institution.id=___ins_id___', -1, '', 'false', false, 'institution'); INSERT INTO public.quaadpoint_tag (id, procedure_needed, documents_needed, "scope", additional_param, "period", scope2, where_notagid, isglobalscope, document_scope) VALUES(62, '1', 1, 'department', 'and department.id=___dep_id___', -1, '', 'false', false, 'department'); INSERT INTO public.quaadpoint_tag (id, procedure_needed, documents_needed, "scope", additional_param, "period", scope2, where_notagid, isglobalscope, document_scope) VALUES(63, '1', 1, 'department', 'and department.id=___dep_id___', -1, '', 'false', false, 'department'); INSERT INTO public.quaadpoint_tag (id, procedure_needed, documents_needed, "scope", additional_param, "period", scope2, where_notagid, isglobalscope, document_scope) VALUES(64, '1', 1, 'department', 'and department.id=___dep_id___', -1, '', 'false', false, 'department'); INSERT INTO public.quaadpoint_tag (id, procedure_needed, documents_needed, "scope", additional_param, "period", scope2, where_notagid, isglobalscope, document_scope) VALUES(65, '1', 1, 'department', 'and department.id=___dep_id___', -1, '', 'false', false, 'department'); INSERT INTO public.quaadpoint_tag (id, procedure_needed, documents_needed, "scope", additional_param, "period", scope2, where_notagid, isglobalscope, document_scope) VALUES(66, '1', 1, 'department', 'and department.id=___dep_id___', 12, '', 'false', false, 'department'); INSERT INTO public.quaadpoint_tag (id, procedure_needed, documents_needed, "scope", additional_param, "period", scope2, where_notagid, isglobalscope, document_scope) VALUES(67, '1', 1, 'department', 'and department.id=___dep_id___', 12, '', 'false', false, 'department'); INSERT INTO public.quaadpoint_tag (id, procedure_needed, documents_needed, "scope", additional_param, "period", scope2, where_notagid, isglobalscope, document_scope) VALUES(68, '1', 0, 'department', 'and department.id=___dep_id___', -1, '', 'false', false, 'department'); INSERT INTO public.quaadpoint_tag (id, procedure_needed, documents_needed, "scope", additional_param, "period", scope2, where_notagid, isglobalscope, document_scope) VALUES(69, '1', 1, 'department', 'and department.id=___dep_id___', 12, '', 'false', false, 'department'); INSERT INTO public.quaadpoint_tag (id, procedure_needed, documents_needed, "scope", additional_param, "period", scope2, where_notagid, isglobalscope, document_scope) VALUES(70, '1', 0, 'department', 'and department.id=___dep_id___', -1, '', 'false', false, 'department'); INSERT INTO public.quaadpoint_tag (id, procedure_needed, documents_needed, "scope", additional_param, "period", scope2, where_notagid, isglobalscope, document_scope) VALUES(71, '1', 1, 'department', 'and department.id=___dep_id___', -1, '', 'false', false, 'department'); INSERT INTO public.quaadpoint_tag (id, procedure_needed, documents_needed, "scope", additional_param, "period", scope2, where_notagid, isglobalscope, document_scope) VALUES(72, '1', 1, 'department', 'and department.id=___dep_id___', -1, '', 'false', false, 'department'); INSERT INTO public.quaadpoint_tag (id, procedure_needed, documents_needed, "scope", additional_param, "period", scope2, where_notagid, isglobalscope, document_scope) VALUES(73, '1', 1, 'department', 'and department.id=___dep_id___', -1, '', 'false', false, 'department'); INSERT INTO public.quaadpoint_tag (id, procedure_needed, documents_needed, "scope", additional_param, "period", scope2, where_notagid, isglobalscope, document_scope) VALUES(74, '1', 0, 'department', 'and department.id=___dep_id___', -1, '', 'false', false, 'department'); INSERT INTO public.quaadpoint_tag (id, procedure_needed, documents_needed, "scope", additional_param, "period", scope2, where_notagid, isglobalscope, document_scope) VALUES(75, '1', 0, 'department', 'and department.id=___dep_id___', -1, '', 'false', false, 'department'); INSERT INTO public.quaadpoint_tag (id, procedure_needed, documents_needed, "scope", additional_param, "period", scope2, where_notagid, isglobalscope, document_scope) VALUES(76, '1', 0, 'department', 'and department.id=___dep_id___', -1, '', 'false', false, 'department'); INSERT INTO public.quaadpoint_tag (id, procedure_needed, documents_needed, "scope", additional_param, "period", scope2, where_notagid, isglobalscope, document_scope) VALUES(77, '1', 0, 'department', 'and department.id=___dep_id___', -1, '', 'false', false, 'department'); INSERT INTO public.quaadpoint_tag (id, procedure_needed, documents_needed, "scope", additional_param, "period", scope2, where_notagid, isglobalscope, document_scope) VALUES(78, '1', 0, 'department', 'and department.id=___dep_id___', -1, '', 'false', false, 'department'); INSERT INTO public.quaadpoint_tag (id, procedure_needed, documents_needed, "scope", additional_param, "period", scope2, where_notagid, isglobalscope, document_scope) VALUES(79, '1', 0, 'department', 'and department.id=___dep_id___', -1, '', 'false', false, 'department'); INSERT INTO public.quaadpoint_tag (id, procedure_needed, documents_needed, "scope", additional_param, "period", scope2, where_notagid, isglobalscope, document_scope) VALUES(80, '1', 0, 'department', 'and department.id=___dep_id___', -1, '', 'false', false, 'department'); INSERT INTO public.quaadpoint_tag (id, procedure_needed, documents_needed, "scope", additional_param, "period", scope2, where_notagid, isglobalscope, document_scope) VALUES(81, '1', 0, 'department', 'and department.id=___dep_id___', -1, '', 'false', false, 'department'); INSERT INTO public.quaadpoint_tag (id, procedure_needed, documents_needed, "scope", additional_param, "period", scope2, where_notagid, isglobalscope, document_scope) VALUES(82, '1', 0, 'department', 'and department.id=___dep_id___', -1, '', 'false', false, 'department'); INSERT INTO public.quaadpoint_tag (id, procedure_needed, documents_needed, "scope", additional_param, "period", scope2, where_notagid, isglobalscope, document_scope) VALUES(83, '1', 0, 'department', 'and department.id=___dep_id___', -1, '', 'false', false, 'institution'); INSERT INTO public.quaadpoint_tag (id, procedure_needed, documents_needed, "scope", additional_param, "period", scope2, where_notagid, isglobalscope, document_scope) VALUES(84, '1', 0, 'department', 'and department.id=___dep_id___', -1, '', 'false', false, 'institution'); INSERT INTO public.quaadpoint_tag (id, procedure_needed, documents_needed, "scope", additional_param, "period", scope2, where_notagid, isglobalscope, document_scope) VALUES(85, '1', 0, 'department', 'and department.id=___dep_id___', -1, '', 'false', false, 'institution'); INSERT INTO public.quaadpoint_tag (id, procedure_needed, documents_needed, "scope", additional_param, "period", scope2, where_notagid, isglobalscope, document_scope) VALUES(86, '1', 1, 'staff_member', 'and id in (select staff_id from staff_job where dep_id=___dep_id___)', -1, '', 'false', false, 'staff_member'); INSERT INTO public.quaadpoint_tag (id, procedure_needed, documents_needed, "scope", additional_param, "period", scope2, where_notagid, isglobalscope, document_scope) VALUES(87, '1', 1, 'staff_member', 'and id in (select staff_id from staff_job where dep_id=___dep_id___)', -1, 'staff_formation', 'false', false, 'staff_formation'); INSERT INTO public.quaadpoint_tag (id, procedure_needed, documents_needed, "scope", additional_param, "period", scope2, where_notagid, isglobalscope, document_scope) VALUES(88, '1', 1, 'staff_member', 'and id in (select staff_id from staff_job where dep_id=___dep_id___)', -1, '', 'false', false, 'staff_member'); INSERT INTO public.quaadpoint_tag (id, procedure_needed, documents_needed, "scope", additional_param, "period", scope2, where_notagid, isglobalscope, document_scope) VALUES(89, '1', 1, 'staff_member', 'and id in (select staff_id from staff_job where dep_id=___dep_id___)', -1, '', 'false', false, 'staff_member'); INSERT INTO public.quaadpoint_tag (id, procedure_needed, documents_needed, "scope", additional_param, "period", scope2, where_notagid, isglobalscope, document_scope) VALUES(90, '1', 0, 'staff_member', 'and id in (select staff_id from staff_job where dep_id=___dep_id___)', -1, '', 'false', false, 'staff_member'); INSERT INTO public.quaadpoint_tag (id, procedure_needed, documents_needed, "scope", additional_param, "period", scope2, where_notagid, isglobalscope, document_scope) VALUES(91, '1', 0, 'staff_member', 'and id in (select staff_id from staff_job where dep_id=___dep_id___)', -1, '', 'false', false, 'staff_member'); INSERT INTO public.quaadpoint_tag (id, procedure_needed, documents_needed, "scope", additional_param, "period", scope2, where_notagid, isglobalscope, document_scope) VALUES(92, '1', 0, 'staff_member', 'and id in (select staff_id from staff_job where dep_id=___dep_id___)', -1, '', 'false', false, 'staff_member'); INSERT INTO public.quaadpoint_tag (id, procedure_needed, documents_needed, "scope", additional_param, "period", scope2, where_notagid, isglobalscope, document_scope) VALUES(93, '1', 0, 'institution', 'and institution.id=___inst_id___', -1, '', 'false', false, 'institution'); INSERT INTO public.quaadpoint_tag (id, procedure_needed, documents_needed, "scope", additional_param, "period", scope2, where_notagid, isglobalscope, document_scope) VALUES(94, '1', 0, 'department', 'and department.id=___dep_id___', -1, '', 'false', false, 'department'); INSERT INTO public.quaadpoint_tag (id, procedure_needed, documents_needed, "scope", additional_param, "period", scope2, where_notagid, isglobalscope, document_scope) VALUES(95, '1', 1, 'department', 'and department.id=___dep_id___', -1, '', 'false', false, 'department'); INSERT INTO public.quaadpoint_tag (id, procedure_needed, documents_needed, "scope", additional_param, "period", scope2, where_notagid, isglobalscope, document_scope) VALUES(96, '1', 1, 'department', 'and department.id=___dep_id___', -1, '', 'false', false, 'department'); INSERT INTO public.quaadpoint_tag (id, procedure_needed, documents_needed, "scope", additional_param, "period", scope2, where_notagid, isglobalscope, document_scope) VALUES(97, '1', 1, 'department', 'and department.id=___dep_id___', -1, '', 'false', false, 'department'); INSERT INTO public.quaadpoint_tag (id, procedure_needed, documents_needed, "scope", additional_param, "period", scope2, where_notagid, isglobalscope, document_scope) VALUES(98, '1', 1, 'department', 'and department.id=___dep_id___', -1, '', 'false', false, 'department'); INSERT INTO public.quaadpoint_tag (id, procedure_needed, documents_needed, "scope", additional_param, "period", scope2, where_notagid, isglobalscope, document_scope) VALUES(99, '1', 1, 'department', 'and department.id=___dep_id___', -1, '', 'false', false, 'department'); INSERT INTO public.quaadpoint_tag (id, procedure_needed, documents_needed, "scope", additional_param, "period", scope2, where_notagid, isglobalscope, document_scope) VALUES(100, '1', 1, 'department', 'and department.id=___dep_id___', -1, '', 'false', false, 'department'); INSERT INTO public.quaadpoint_tag (id, procedure_needed, documents_needed, "scope", additional_param, "period", scope2, where_notagid, isglobalscope, document_scope) VALUES(101, '1', 0, 'department', 'and department.id=___dep_id___', -1, '', 'false', false, 'department'); INSERT INTO public.quaadpoint_tag (id, procedure_needed, documents_needed, "scope", additional_param, "period", scope2, where_notagid, isglobalscope, document_scope) VALUES(102, '1', 0, 'department', 'and department.id=___dep_id___', -1, '', 'false', false, 'department'); INSERT INTO public.quaadpoint_tag (id, procedure_needed, documents_needed, "scope", additional_param, "period", scope2, where_notagid, isglobalscope, document_scope) VALUES(103, '1', 0, 'department', 'and department.id=___dep_id___', -1, '', 'false', false, 'department'); INSERT INTO public.quaadpoint_tag (id, procedure_needed, documents_needed, "scope", additional_param, "period", scope2, where_notagid, isglobalscope, document_scope) VALUES(104, '1', 0, 'department', 'and department.id=___dep_id___', -1, '', 'false', false, 'department'); INSERT INTO public.quaadpoint_tag (id, procedure_needed, documents_needed, "scope", additional_param, "period", scope2, where_notagid, isglobalscope, document_scope) VALUES(105, '1', 0, 'department', 'and department.id=___dep_id___', -1, '', 'false', false, 'department'); INSERT INTO public.quaadpoint_tag (id, procedure_needed, documents_needed, "scope", additional_param, "period", scope2, where_notagid, isglobalscope, document_scope) VALUES(106, '4', 1, 'scope', '/bquaadril-config.php?standard_version=1', -1, 'scope2', 'false', false, 'institution'); INSERT INTO public.quaadpoint_tag (id, procedure_needed, documents_needed, "scope", additional_param, "period", scope2, where_notagid, isglobalscope, document_scope) VALUES(107, '1', 0, 'department', 'and department.id=___dep_id___', -1, '', 'false', false, 'department'); INSERT INTO public.quaadpoint_tag (id, procedure_needed, documents_needed, "scope", additional_param, "period", scope2, where_notagid, isglobalscope, document_scope) VALUES(108, '1', 0, 'department', 'and department.id=___dep_id___', -1, '', 'false', false, 'department'); INSERT INTO public.quaadpoint_tag (id, procedure_needed, documents_needed, "scope", additional_param, "period", scope2, where_notagid, isglobalscope, document_scope) VALUES(109, '1', 0, 'department', 'and department.id=___dep_id___', -1, '', 'false', false, 'department'); INSERT INTO public.quaadpoint_tag (id, procedure_needed, documents_needed, "scope", additional_param, "period", scope2, where_notagid, isglobalscope, document_scope) VALUES(110, '1', 0, 'department', 'and department.id=___dep_id___', -1, '', 'false', false, 'department'); INSERT INTO public.quaadpoint_tag (id, procedure_needed, documents_needed, "scope", additional_param, "period", scope2, where_notagid, isglobalscope, document_scope) VALUES(111, '1', 0, 'department', 'and department.id=___dep_id___', -1, '', 'false', false, 'department'); INSERT INTO public.quaadpoint_tag (id, procedure_needed, documents_needed, "scope", additional_param, "period", scope2, where_notagid, isglobalscope, document_scope) VALUES(112, '1', 0, 'department', 'and department.id=___dep_id___', -1, '', 'false', false, 'department'); INSERT INTO public.quaadpoint_tag (id, procedure_needed, documents_needed, "scope", additional_param, "period", scope2, where_notagid, isglobalscope, document_scope) VALUES(113, '1', 0, 'department', 'and department.id=___dep_id___', -1, '', 'false', false, 'department'); INSERT INTO public.quaadpoint_tag (id, procedure_needed, documents_needed, "scope", additional_param, "period", scope2, where_notagid, isglobalscope, document_scope) VALUES(114, '1', 0, 'department', 'and department.id=___dep_id___', -1, '', 'false', false, 'department'); INSERT INTO public.quaadpoint_tag (id, procedure_needed, documents_needed, "scope", additional_param, "period", scope2, where_notagid, isglobalscope, document_scope) VALUES(115, '1', 1, 'v_device_plus_deviceinstallation_devid', 'and modalitytype=''DEXA'' and dep_id=___dep_id___ and (removeddate is null or removeddate > to_date(''___start_date___'',''YYYY-MM-DD HH24:MI:SS''))', 12, '', 'false', false, 'device_inspection'); INSERT INTO public.quaadpoint_tag (id, procedure_needed, documents_needed, "scope", additional_param, "period", scope2, where_notagid, isglobalscope, document_scope) VALUES(116, '1', 0, 'department', 'and department.id=___dep_id___', -1, '', 'false', false, 'department'); INSERT INTO public.quaadpoint_tag (id, procedure_needed, documents_needed, "scope", additional_param, "period", scope2, where_notagid, isglobalscope, document_scope) VALUES(117, '1', 0, 'department', 'and department.id=___dep_id___', -1, '', 'false', false, 'department'); INSERT INTO public.quaadpoint_tag (id, procedure_needed, documents_needed, "scope", additional_param, "period", scope2, where_notagid, isglobalscope, document_scope) VALUES(118, '1', 0, 'department', 'and department.id=___dep_id___', -1, '', 'false', false, 'department'); INSERT INTO public.quaadpoint_tag (id, procedure_needed, documents_needed, "scope", additional_param, "period", scope2, where_notagid, isglobalscope, document_scope) VALUES(119, '1', 0, 'department', 'and department.id=___dep_id___', -1, '', 'false', false, 'department'); INSERT INTO public.quaadpoint_tag (id, procedure_needed, documents_needed, "scope", additional_param, "period", scope2, where_notagid, isglobalscope, document_scope) VALUES(120, '1', 0, 'department', 'and department.id=___dep_id___', -1, '', 'false', false, 'department'); INSERT INTO public.quaadpoint_tag (id, procedure_needed, documents_needed, "scope", additional_param, "period", scope2, where_notagid, isglobalscope, document_scope) VALUES(121, '1', 0, 'department', 'and department.id=___dep_id___', -1, '', 'false', false, 'department'); INSERT INTO public.quaadpoint_tag (id, procedure_needed, documents_needed, "scope", additional_param, "period", scope2, where_notagid, isglobalscope, document_scope) VALUES(122, '1', 0, 'department', 'and department.id=___dep_id___', -1, '', 'false', false, 'department'); INSERT INTO public.quaadpoint_tag (id, procedure_needed, documents_needed, "scope", additional_param, "period", scope2, where_notagid, isglobalscope, document_scope) VALUES(123, '1', 0, 'department', 'and department.id=___dep_id___', -1, '', 'false', false, 'department'); INSERT INTO public.quaadpoint_tag (id, procedure_needed, documents_needed, "scope", additional_param, "period", scope2, where_notagid, isglobalscope, document_scope) VALUES(124, '1', 0, 'department', 'and department.id=___dep_id___', -1, '', 'false', false, 'department'); INSERT INTO public.quaadpoint_tag (id, procedure_needed, documents_needed, "scope", additional_param, "period", scope2, where_notagid, isglobalscope, document_scope) VALUES(125, '1', 0, 'department', 'and department.id=___dep_id___', -1, '', 'false', false, 'department'); INSERT INTO public.quaadpoint_tag (id, procedure_needed, documents_needed, "scope", additional_param, "period", scope2, where_notagid, isglobalscope, document_scope) VALUES(126, '1', 0, 'department', 'and department.id=___dep_id___', -1, '', 'false', false, 'department'); INSERT INTO public.quaadpoint_tag (id, procedure_needed, documents_needed, "scope", additional_param, "period", scope2, where_notagid, isglobalscope, document_scope) VALUES(127, '1', 0, 'department', 'and department.id=___dep_id___', -1, '', 'false', false, 'department'); INSERT INTO public.quaadpoint_tag (id, procedure_needed, documents_needed, "scope", additional_param, "period", scope2, where_notagid, isglobalscope, document_scope) VALUES(128, '1', 0, 'department', 'and department.id=___dep_id___', -1, '', 'false', false, 'department'); INSERT INTO public.quaadpoint_tag (id, procedure_needed, documents_needed, "scope", additional_param, "period", scope2, where_notagid, isglobalscope, document_scope) VALUES(129, '1', 0, 'department', 'and department.id=___dep_id___', -1, '', 'false', false, 'department'); INSERT INTO public.quaadpoint_tag (id, procedure_needed, documents_needed, "scope", additional_param, "period", scope2, where_notagid, isglobalscope, document_scope) VALUES(130, '1', 0, 'department', 'and department.id=___dep_id___', -1, '', 'false', false, 'department'); INSERT INTO public.quaadpoint_tag (id, procedure_needed, documents_needed, "scope", additional_param, "period", scope2, where_notagid, isglobalscope, document_scope) VALUES(131, '1', 0, 'department', 'and department.id=___dep_id___', -1, '', 'false', false, 'department'); INSERT INTO public.quaadpoint_tag (id, procedure_needed, documents_needed, "scope", additional_param, "period", scope2, where_notagid, isglobalscope, document_scope) VALUES(132, '1', 0, 'department', 'and department.id=___dep_id___', -1, '', 'false', false, 'department'); INSERT INTO public.quaadpoint_tag (id, procedure_needed, documents_needed, "scope", additional_param, "period", scope2, where_notagid, isglobalscope, document_scope) VALUES(133, '1', 0, 'department', 'and department.id=___dep_id___', -1, '', 'false', false, 'department'); INSERT INTO public.quaadpoint_tag (id, procedure_needed, documents_needed, "scope", additional_param, "period", scope2, where_notagid, isglobalscope, document_scope) VALUES(134, '1', 0, 'department', 'and department.id=___dep_id___', -1, '', 'false', false, 'department'); INSERT INTO public.quaadpoint_tag (id, procedure_needed, documents_needed, "scope", additional_param, "period", scope2, where_notagid, isglobalscope, document_scope) VALUES(135, '1', 0, 'department', 'and department.id=___dep_id___', -1, '', 'false', false, 'department'); INSERT INTO public.quaadpoint_tag (id, procedure_needed, documents_needed, "scope", additional_param, "period", scope2, where_notagid, isglobalscope, document_scope) VALUES(136, '1', 0, 'department', 'and department.id=___dep_id___', -1, '', 'false', false, 'department'); INSERT INTO public.quaadpoint_tag (id, procedure_needed, documents_needed, "scope", additional_param, "period", scope2, where_notagid, isglobalscope, document_scope) VALUES(137, '1', 0, 'department', 'and department.id=___dep_id___', -1, '', 'false', false, 'department'); INSERT INTO public.quaadpoint_tag (id, procedure_needed, documents_needed, "scope", additional_param, "period", scope2, where_notagid, isglobalscope, document_scope) VALUES(138, '1', 0, 'department', 'and department.id=___dep_id___', -1, '', 'false', false, 'department'); INSERT INTO public.quaadpoint_tag (id, procedure_needed, documents_needed, "scope", additional_param, "period", scope2, where_notagid, isglobalscope, document_scope) VALUES(139, '1', 0, 'department', 'and department.id=___dep_id___', -1, '', 'false', false, 'department'); INSERT INTO public.quaadpoint_tag (id, procedure_needed, documents_needed, "scope", additional_param, "period", scope2, where_notagid, isglobalscope, document_scope) VALUES(140, '1', 0, 'department', 'and department.id=___dep_id___', -1, '', 'false', false, 'department'); INSERT INTO public.quaadpoint_tag (id, procedure_needed, documents_needed, "scope", additional_param, "period", scope2, where_notagid, isglobalscope, document_scope) VALUES(141, '1', 0, 'department', 'and department.id=___dep_id___', -1, '', 'false', false, 'department'); INSERT INTO public.quaadpoint_tag (id, procedure_needed, documents_needed, "scope", additional_param, "period", scope2, where_notagid, isglobalscope, document_scope) VALUES(142, '1', 1, 'examlist', 'and id in (select ext_id from tag_link tl where tag_id in (select tagdepid from v_taglink_instdep vti where dep_id=___dep_id___) and type=''examlist'') and removed=false', -1, '', 'false', false, 'examlist'); INSERT INTO public.quaadpoint_tag (id, procedure_needed, documents_needed, "scope", additional_param, "period", scope2, where_notagid, isglobalscope, document_scope) VALUES(143, '1', 1, 'examlist', 'and id in (select ext_id from tag_link tl where tag_id in (select tagdepid from v_taglink_instdep vti where dep_id=___dep_id___) and type=''examlist'') and removed=false', 36, '', 'false', false, 'examlist'); INSERT INTO public.quaadpoint_tag (id, procedure_needed, documents_needed, "scope", additional_param, "period", scope2, where_notagid, isglobalscope, document_scope) VALUES(144, '1', 1, 'department', 'and department.id=___dep_id___', -1, '', 'false', false, 'department'); INSERT INTO public.quaadpoint_tag (id, procedure_needed, documents_needed, "scope", additional_param, "period", scope2, where_notagid, isglobalscope, document_scope) VALUES(145, '1', 0, 'department', 'and department.id=___dep_id___', -1, '', 'false', false, 'department'); INSERT INTO public.quaadpoint_tag (id, procedure_needed, documents_needed, "scope", additional_param, "period", scope2, where_notagid, isglobalscope, document_scope) VALUES(146, '1', 0, 'department', 'and department.id=___dep_id___', -1, '', 'false', false, 'department'); INSERT INTO public.quaadpoint_tag (id, procedure_needed, documents_needed, "scope", additional_param, "period", scope2, where_notagid, isglobalscope, document_scope) VALUES(147, '1', 0, 'department', 'and department.id=___dep_id___', -1, '', 'false', false, 'department'); INSERT INTO public.quaadpoint_tag (id, procedure_needed, documents_needed, "scope", additional_param, "period", scope2, where_notagid, isglobalscope, document_scope) VALUES(148, '1', 0, 'department', 'and department.id=___dep_id___', -1, '', 'false', false, 'department'); INSERT INTO public.quaadpoint_tag (id, procedure_needed, documents_needed, "scope", additional_param, "period", scope2, where_notagid, isglobalscope, document_scope) VALUES(149, '1', 0, 'department', 'and department.id=___dep_id___', -1, '', 'false', false, 'department'); INSERT INTO public.quaadpoint_tag (id, procedure_needed, documents_needed, "scope", additional_param, "period", scope2, where_notagid, isglobalscope, document_scope) VALUES(150, '1', 0, 'department', 'and department.id=___dep_id___', -1, '', 'false', false, 'department'); INSERT INTO public.quaadpoint_tag (id, procedure_needed, documents_needed, "scope", additional_param, "period", scope2, where_notagid, isglobalscope, document_scope) VALUES(151, '1', 0, 'department', 'and department.id=___dep_id___', -1, '', 'false', false, 'department'); INSERT INTO public.quaadpoint_tag (id, procedure_needed, documents_needed, "scope", additional_param, "period", scope2, where_notagid, isglobalscope, document_scope) VALUES(152, '1', 0, 'department', 'and department.id=___dep_id___', -1, '', 'false', false, 'department'); INSERT INTO public.quaadpoint_tag (id, procedure_needed, documents_needed, "scope", additional_param, "period", scope2, where_notagid, isglobalscope, document_scope) VALUES(153, '1', 0, 'department', 'and department.id=___dep_id___', -1, '', 'false', false, 'department'); INSERT INTO public.quaadpoint_tag (id, procedure_needed, documents_needed, "scope", additional_param, "period", scope2, where_notagid, isglobalscope, document_scope) VALUES(154, '1', 0, 'department', 'and department.id=___dep_id___', -1, '', 'false', false, 'department'); INSERT INTO public.quaadpoint_tag (id, procedure_needed, documents_needed, "scope", additional_param, "period", scope2, where_notagid, isglobalscope, document_scope) VALUES(155, '1', 0, 'department', 'and department.id=___dep_id___', -1, '', 'false', false, 'department'); INSERT INTO public.quaadpoint_tag (id, procedure_needed, documents_needed, "scope", additional_param, "period", scope2, where_notagid, isglobalscope, document_scope) VALUES(156, '1', 0, 'department', 'and department.id=___dep_id___', -1, '', 'false', false, 'department'); INSERT INTO public.quaadpoint_tag (id, procedure_needed, documents_needed, "scope", additional_param, "period", scope2, where_notagid, isglobalscope, document_scope) VALUES(157, '1', 0, 'department', 'and department.id=___dep_id___', -1, '', 'false', false, 'department'); INSERT INTO public.quaadpoint_tag (id, procedure_needed, documents_needed, "scope", additional_param, "period", scope2, where_notagid, isglobalscope, document_scope) VALUES(158, '1', 0, 'department', 'and department.id=___dep_id___', -1, '', 'false', false, 'department'); INSERT INTO public.quaadpoint_tag (id, procedure_needed, documents_needed, "scope", additional_param, "period", scope2, where_notagid, isglobalscope, document_scope) VALUES(159, '1', 0, 'department', 'and department.id=___dep_id___', -1, '', 'false', false, 'department'); INSERT INTO public.quaadpoint_tag (id, procedure_needed, documents_needed, "scope", additional_param, "period", scope2, where_notagid, isglobalscope, document_scope) VALUES(160, '1', 0, 'department', 'and department.id=___dep_id___', -1, '', 'false', false, 'department'); INSERT INTO public.quaadpoint_tag (id, procedure_needed, documents_needed, "scope", additional_param, "period", scope2, where_notagid, isglobalscope, document_scope) VALUES(161, '1', 0, 'department', 'and department.id=___dep_id___', -1, '', 'false', false, 'department'); INSERT INTO public.quaadpoint_tag (id, procedure_needed, documents_needed, "scope", additional_param, "period", scope2, where_notagid, isglobalscope, document_scope) VALUES(162, '1', 0, 'department', 'and department.id=___dep_id___', -1, '', 'false', false, 'department'); INSERT INTO public.quaadpoint_tag (id, procedure_needed, documents_needed, "scope", additional_param, "period", scope2, where_notagid, isglobalscope, document_scope) VALUES(163, '1', 0, 'department', 'and department.id=___dep_id___', -1, '', 'false', false, 'department'); INSERT INTO public.quaadpoint_tag (id, procedure_needed, documents_needed, "scope", additional_param, "period", scope2, where_notagid, isglobalscope, document_scope) VALUES(164, '1', 0, 'department', 'and department.id=___dep_id___', -1, '', 'false', false, 'department'); INSERT INTO public.quaadpoint_tag (id, procedure_needed, documents_needed, "scope", additional_param, "period", scope2, where_notagid, isglobalscope, document_scope) VALUES(165, '1', 0, 'department', 'and department.id=___dep_id___', -1, '', 'false', false, 'department'); INSERT INTO public.quaadpoint_tag (id, procedure_needed, documents_needed, "scope", additional_param, "period", scope2, where_notagid, isglobalscope, document_scope) VALUES(166, '1', 0, 'department', 'and department.id=___dep_id___', -1, '', 'false', false, 'department'); INSERT INTO public.quaadpoint_tag (id, procedure_needed, documents_needed, "scope", additional_param, "period", scope2, where_notagid, isglobalscope, document_scope) VALUES(167, '1', 1, 'v_device_plus_deviceinstallation_devid', 'and modalitytype=''DEXA'' and dep_id=___dep_id___ and (removeddate is null or removeddate > to_date(''___start_date___'',''YYYY-MM-DD HH24:MI:SS''))', -1, '', 'false', false, 'device_installation'); INSERT INTO public.quaadpoint_tag (id, procedure_needed, documents_needed, "scope", additional_param, "period", scope2, where_notagid, isglobalscope, document_scope) VALUES(168, '1', 0, 'department', 'and department.id=___dep_id___', -1, '', 'false', false, 'department'); INSERT INTO public.quaadpoint_tag (id, procedure_needed, documents_needed, "scope", additional_param, "period", scope2, where_notagid, isglobalscope, document_scope) VALUES(169, '1', 0, 'department', 'and department.id=___dep_id___', -1, '', 'false', false, 'department'); INSERT INTO public.quaadpoint_tag (id, procedure_needed, documents_needed, "scope", additional_param, "period", scope2, where_notagid, isglobalscope, document_scope) VALUES(170, '1', 0, 'department', 'and department.id=___dep_id___', -1, '', 'false', false, 'department'); INSERT INTO public.quaadpoint_tag (id, procedure_needed, documents_needed, "scope", additional_param, "period", scope2, where_notagid, isglobalscope, document_scope) VALUES(171, '1', 0, 'department', 'and department.id=___dep_id___', -1, '', 'false', false, 'department'); INSERT INTO public.quaadpoint_tag (id, procedure_needed, documents_needed, "scope", additional_param, "period", scope2, where_notagid, isglobalscope, document_scope) VALUES(172, '1', 0, 'department', 'and department.id=___dep_id___', -1, '', 'false', false, 'department'); INSERT INTO public.quaadpoint_tag (id, procedure_needed, documents_needed, "scope", additional_param, "period", scope2, where_notagid, isglobalscope, document_scope) VALUES(173, '1', 0, 'department', 'and department.id=___dep_id___', -1, '', 'false', false, 'department'); INSERT INTO public.quaadpoint_tag (id, procedure_needed, documents_needed, "scope", additional_param, "period", scope2, where_notagid, isglobalscope, document_scope) VALUES(174, '1', 0, 'department', 'and department.id=___dep_id___', -1, '', 'false', false, 'department'); INSERT INTO public.quaadpoint_tag (id, procedure_needed, documents_needed, "scope", additional_param, "period", scope2, where_notagid, isglobalscope, document_scope) VALUES(175, '1', 0, 'department', 'and department.id=___dep_id___', -1, '', 'false', false, 'department'); INSERT INTO public.quaadpoint_tag (id, procedure_needed, documents_needed, "scope", additional_param, "period", scope2, where_notagid, isglobalscope, document_scope) VALUES(176, '1', 0, 'department', 'and department.id=___dep_id___', -1, '', 'false', false, 'department'); INSERT INTO public.quaadpoint_tag (id, procedure_needed, documents_needed, "scope", additional_param, "period", scope2, where_notagid, isglobalscope, document_scope) VALUES(177, '1', 0, 'department', 'and department.id=___dep_id___', -1, '', 'false', false, 'department'); INSERT INTO public.quaadpoint_tag (id, procedure_needed, documents_needed, "scope", additional_param, "period", scope2, where_notagid, isglobalscope, document_scope) VALUES(178, '1', 0, 'department', 'and department.id=___dep_id___', -1, '', 'false', false, 'department'); INSERT INTO public.quaadpoint_tag (id, procedure_needed, documents_needed, "scope", additional_param, "period", scope2, where_notagid, isglobalscope, document_scope) VALUES(179, '1', 0, 'department', 'and department.id=___dep_id___', -1, '', 'false', false, 'department'); INSERT INTO public.quaadpoint_tag (id, procedure_needed, documents_needed, "scope", additional_param, "period", scope2, where_notagid, isglobalscope, document_scope) VALUES(180, '1', 0, 'department', 'and department.id=___dep_id___', -1, '', 'false', false, 'department'); INSERT INTO public.quaadpoint_tag (id, procedure_needed, documents_needed, "scope", additional_param, "period", scope2, where_notagid, isglobalscope, document_scope) VALUES(181, '1', 0, 'department', 'and department.id=___dep_id___', -1, '', 'false', false, 'department'); INSERT INTO public.quaadpoint_tag (id, procedure_needed, documents_needed, "scope", additional_param, "period", scope2, where_notagid, isglobalscope, document_scope) VALUES(182, '1', 0, 'department', 'and department.id=___dep_id___', -1, '', 'false', false, 'department'); INSERT INTO public.quaadpoint_tag (id, procedure_needed, documents_needed, "scope", additional_param, "period", scope2, where_notagid, isglobalscope, document_scope) VALUES(183, '1', 0, 'department', 'and department.id=___dep_id___', -1, '', 'false', false, 'department'); INSERT INTO public.quaadpoint_tag (id, procedure_needed, documents_needed, "scope", additional_param, "period", scope2, where_notagid, isglobalscope, document_scope) VALUES(184, '1', 0, 'department', 'and department.id=___dep_id___', -1, '', 'false', false, 'department'); INSERT INTO public.quaadpoint_tag (id, procedure_needed, documents_needed, "scope", additional_param, "period", scope2, where_notagid, isglobalscope, document_scope) VALUES(185, '1', 0, 'department', 'and department.id=___dep_id___', -1, '', 'false', false, 'department'); INSERT INTO public.quaadpoint_tag (id, procedure_needed, documents_needed, "scope", additional_param, "period", scope2, where_notagid, isglobalscope, document_scope) VALUES(186, '1', 0, 'department', 'and department.id=___dep_id___', -1, '', 'false', false, 'department'); INSERT INTO public.quaadpoint_tag (id, procedure_needed, documents_needed, "scope", additional_param, "period", scope2, where_notagid, isglobalscope, document_scope) VALUES(187, '1', 0, 'department', 'and department.id=___dep_id___', -1, '', 'false', false, 'department'); INSERT INTO public.quaadpoint_tag (id, procedure_needed, documents_needed, "scope", additional_param, "period", scope2, where_notagid, isglobalscope, document_scope) VALUES(188, '1', 0, 'department', 'and department.id=___dep_id___', -1, '', 'false', false, 'department'); INSERT INTO public.quaadpoint_tag (id, procedure_needed, documents_needed, "scope", additional_param, "period", scope2, where_notagid, isglobalscope, document_scope) VALUES(189, '1', 0, 'department', 'and department.id=___dep_id___', -1, '', 'false', false, 'department'); INSERT INTO public.quaadpoint_tag (id, procedure_needed, documents_needed, "scope", additional_param, "period", scope2, where_notagid, isglobalscope, document_scope) VALUES(190, '1', 0, 'department', 'and department.id=___dep_id___', -1, '', 'false', false, 'department'); INSERT INTO public.quaadpoint_tag (id, procedure_needed, documents_needed, "scope", additional_param, "period", scope2, where_notagid, isglobalscope, document_scope) VALUES(191, '1', 0, 'department', 'and department.id=___dep_id___', -1, '', 'false', false, 'department'); INSERT INTO public.quaadpoint_tag (id, procedure_needed, documents_needed, "scope", additional_param, "period", scope2, where_notagid, isglobalscope, document_scope) VALUES(192, '1', 0, 'department', 'and department.id=___dep_id___', -1, '', 'false', false, 'department'); INSERT INTO public.quaadpoint_tag (id, procedure_needed, documents_needed, "scope", additional_param, "period", scope2, where_notagid, isglobalscope, document_scope) VALUES(193, '1', 1, 'v_device_plus_deviceinstallation_devid', 'and modalitytype=''DEXA'' and dep_id=___dep_id___ and (removeddate is null or removeddate > to_date(''___start_date___'',''YYYY-MM-DD HH24:MI:SS''))', 12, '', 'false', false, 'device_inspection'); INSERT INTO public.quaadpoint_tag (id, procedure_needed, documents_needed, "scope", additional_param, "period", scope2, where_notagid, isglobalscope, document_scope) VALUES(194, '1', 1, 'v_device_plus_deviceinstallation_devid', 'and modalitytype=''DEXA'' and dep_id=___dep_id___ and (removeddate is null or removeddate > to_date(''___start_date___'',''YYYY-MM-DD HH24:MI:SS''))', 12, '', 'false', false, 'device_inspection'); INSERT INTO public.quaadpoint_tag (id, procedure_needed, documents_needed, "scope", additional_param, "period", scope2, where_notagid, isglobalscope, document_scope) VALUES(195, '1', 1, 'v_device_plus_deviceinstallation_devid', 'and modalitytype=''DEXA'' and dep_id=___dep_id___ and (removeddate is null or removeddate > to_date(''___start_date___'',''YYYY-MM-DD HH24:MI:SS''))', 12, '', 'false', false, 'device_inspection'); INSERT INTO public.quaadpoint_tag (id, procedure_needed, documents_needed, "scope", additional_param, "period", scope2, where_notagid, isglobalscope, document_scope) VALUES(196, '1', 1, 'v_device_plus_deviceinstallation_devid', 'and modalitytype=''DEXA'' and dep_id=___dep_id___ and (removeddate is null or removeddate > to_date(''___start_date___'',''YYYY-MM-DD HH24:MI:SS''))', 12, '', 'false', false, 'device_inspection'); INSERT INTO public.quaadpoint_tag (id, procedure_needed, documents_needed, "scope", additional_param, "period", scope2, where_notagid, isglobalscope, document_scope) VALUES(197, '1', 1, 'v_device_plus_deviceinstallation_devid', 'and modalitytype=''DEXA'' and dep_id=___dep_id___ and (removeddate is null or removeddate > to_date(''___start_date___'',''YYYY-MM-DD HH24:MI:SS''))', 12, '', 'false', false, 'device_inspection'); INSERT INTO public.quaadpoint_tag (id, procedure_needed, documents_needed, "scope", additional_param, "period", scope2, where_notagid, isglobalscope, document_scope) VALUES(198, '1', 1, 'v_device_plus_deviceinstallation_devid', 'and modalitytype=''DEXA'' and dep_id=___dep_id___ and (removeddate is null or removeddate > to_date(''___start_date___'',''YYYY-MM-DD HH24:MI:SS''))', 12, '', 'false', false, 'device_inspection'); INSERT INTO public.quaadpoint_tag (id, procedure_needed, documents_needed, "scope", additional_param, "period", scope2, where_notagid, isglobalscope, document_scope) VALUES(199, '1', 1, 'v_device_plus_deviceinstallation_devid', 'and modalitytype=''DEXA'' and dep_id=___dep_id___ and (removeddate is null or removeddate > to_date(''___start_date___'',''YYYY-MM-DD HH24:MI:SS''))', 12, '', 'false', false, 'device_inspection'); INSERT INTO public.quaadpoint_tag (id, procedure_needed, documents_needed, "scope", additional_param, "period", scope2, where_notagid, isglobalscope, document_scope) VALUES(200, '1', 1, 'v_device_plus_deviceinstallation_devid', 'and modalitytype=''DEXA'' and dep_id=___dep_id___ and (removeddate is null or removeddate > to_date(''___start_date___'',''YYYY-MM-DD HH24:MI:SS''))', 12, '', 'false', false, 'device_inspection'); INSERT INTO public.quaadpoint_tag (id, procedure_needed, documents_needed, "scope", additional_param, "period", scope2, where_notagid, isglobalscope, document_scope) VALUES(201, '1', 1, 'v_device_plus_deviceinstallation_devid', 'and modalitytype=''DEXA'' and dep_id=___dep_id___ and (removeddate is null or removeddate > to_date(''___start_date___'',''YYYY-MM-DD HH24:MI:SS''))', 12, '', 'false', false, 'device_inspection'); INSERT INTO public.quaadpoint_tag (id, procedure_needed, documents_needed, "scope", additional_param, "period", scope2, where_notagid, isglobalscope, document_scope) VALUES(202, '1', 1, 'v_device_plus_deviceinstallation_devid', 'and modalitytype=''DEXA'' and dep_id=___dep_id___ and (removeddate is null or removeddate > to_date(''___start_date___'',''YYYY-MM-DD HH24:MI:SS''))', 12, '', 'false', false, 'device_inspection'); INSERT INTO public.quaadpoint_tag (id, procedure_needed, documents_needed, "scope", additional_param, "period", scope2, where_notagid, isglobalscope, document_scope) VALUES(203, '1', 1, 'v_device_plus_deviceinstallation_devid', 'and modalitytype=''DEXA'' and dep_id=___dep_id___ and (removeddate is null or removeddate > to_date(''___start_date___'',''YYYY-MM-DD HH24:MI:SS''))', 12, '', 'false', false, 'device_inspection'); INSERT INTO public.quaadpoint_tag (id, procedure_needed, documents_needed, "scope", additional_param, "period", scope2, where_notagid, isglobalscope, document_scope) VALUES(204, '1', 1, 'v_device_plus_deviceinstallation_devid', 'and modalitytype=''DEXA'' and dep_id=___dep_id___ and (removeddate is null or removeddate > to_date(''___start_date___'',''YYYY-MM-DD HH24:MI:SS''))', 12, '', 'false', false, 'device_inspection'); INSERT INTO public.quaadpoint_tag (id, procedure_needed, documents_needed, "scope", additional_param, "period", scope2, where_notagid, isglobalscope, document_scope) VALUES(205, '1', 1, 'v_device_plus_deviceinstallation_devid', 'and modalitytype=''DEXA'' and dep_id=___dep_id___ and (removeddate is null or removeddate > to_date(''___start_date___'',''YYYY-MM-DD HH24:MI:SS''))', 12, '', 'false', false, 'device_inspection'); INSERT INTO public.quaadpoint_tag (id, procedure_needed, documents_needed, "scope", additional_param, "period", scope2, where_notagid, isglobalscope, document_scope) VALUES(206, '1', 0, 'department', 'and department.id=___dep_id___', -1, '', 'false', false, 'department'); INSERT INTO public.quaadpoint_tag (id, procedure_needed, documents_needed, "scope", additional_param, "period", scope2, where_notagid, isglobalscope, document_scope) VALUES(207, '1', 0, 'department', 'and department.id=___dep_id___', -1, '', 'false', false, 'department'); INSERT INTO public.quaadpoint_tag (id, procedure_needed, documents_needed, "scope", additional_param, "period", scope2, where_notagid, isglobalscope, document_scope) VALUES(208, '1', 0, 'department', 'and department.id=___dep_id___', -1, '', 'false', false, 'department'); INSERT INTO public.quaadpoint_tag (id, procedure_needed, documents_needed, "scope", additional_param, "period", scope2, where_notagid, isglobalscope, document_scope) VALUES(209, '1', 0, 'department', 'and department.id=___dep_id___', -1, '', 'false', false, 'department'); INSERT INTO public.quaadpoint_tag (id, procedure_needed, documents_needed, "scope", additional_param, "period", scope2, where_notagid, isglobalscope, document_scope) VALUES(210, '1', 0, 'department', 'and department.id=___dep_id___', -1, '', 'false', false, 'department'); INSERT INTO public.quaadpoint_tag (id, procedure_needed, documents_needed, "scope", additional_param, "period", scope2, where_notagid, isglobalscope, document_scope) VALUES(211, '1', 0, 'department', 'and department.id=___dep_id___', -1, '', 'false', false, 'department'); INSERT INTO public.quaadpoint_tag (id, procedure_needed, documents_needed, "scope", additional_param, "period", scope2, where_notagid, isglobalscope, document_scope) VALUES(212, '1', 0, 'department', 'and department.id=___dep_id___', -1, '', 'false', false, 'department'); INSERT INTO public.quaadpoint_tag (id, procedure_needed, documents_needed, "scope", additional_param, "period", scope2, where_notagid, isglobalscope, document_scope) VALUES(213, '1', 0, 'department', 'and department.id=___dep_id___', -1, '', 'false', false, 'department'); INSERT INTO public.quaadpoint_tag (id, procedure_needed, documents_needed, "scope", additional_param, "period", scope2, where_notagid, isglobalscope, document_scope) VALUES(214, '1', 0, 'department', 'and department.id=___dep_id___', -1, '', 'false', false, 'department'); INSERT INTO public.quaadpoint_tag (id, procedure_needed, documents_needed, "scope", additional_param, "period", scope2, where_notagid, isglobalscope, document_scope) VALUES(215, '1', 0, 'department', 'and department.id=___dep_id___', -1, '', 'false', false, 'department'); INSERT INTO public.quaadpoint_tag (id, procedure_needed, documents_needed, "scope", additional_param, "period", scope2, where_notagid, isglobalscope, document_scope) VALUES(216, '1', 0, 'department', 'and department.id=___dep_id___', -1, '', 'false', false, 'department'); INSERT INTO public.quaadpoint_tag (id, procedure_needed, documents_needed, "scope", additional_param, "period", scope2, where_notagid, isglobalscope, document_scope) VALUES(217, '1', 0, 'department', 'and department.id=___dep_id___', -1, '', 'false', false, 'department'); INSERT INTO public.quaadpoint_tag (id, procedure_needed, documents_needed, "scope", additional_param, "period", scope2, where_notagid, isglobalscope, document_scope) VALUES(218, '1', 0, 'department', 'and department.id=___dep_id___', -1, '', 'false', false, 'department'); INSERT INTO public.quaadpoint_tag (id, procedure_needed, documents_needed, "scope", additional_param, "period", scope2, where_notagid, isglobalscope, document_scope) VALUES(219, '1', 0, 'department', 'and department.id=___dep_id___', -1, '', 'false', false, 'department'); INSERT INTO public.quaadpoint_tag (id, procedure_needed, documents_needed, "scope", additional_param, "period", scope2, where_notagid, isglobalscope, document_scope) VALUES(220, '1', 0, 'v_device_plus_deviceinstallation_devid', 'and modalitytype=''SOFT'' and dep_id=___dep_id___ and (removeddate is null or removeddate > to_date(''___start_date___'',''YYYY-MM-DD HH24:MI:SS''))', -1, '', 'false', false, 'device_installation'); INSERT INTO public.quaadpoint_tag (id, procedure_needed, documents_needed, "scope", additional_param, "period", scope2, where_notagid, isglobalscope, document_scope) VALUES(221, '1', 0, 'department', 'and department.id=___dep_id___', -1, '', 'false', false, 'department'); INSERT INTO public.quaadpoint_tag (id, procedure_needed, documents_needed, "scope", additional_param, "period", scope2, where_notagid, isglobalscope, document_scope) VALUES(222, '1', 0, 'department', 'and department.id=___dep_id___', -1, '', 'false', false, 'department'); INSERT INTO public.quaadpoint_tag (id, procedure_needed, documents_needed, "scope", additional_param, "period", scope2, where_notagid, isglobalscope, document_scope) VALUES(223, '1', 0, 'department', 'and department.id=___dep_id___', -1, '', 'false', false, 'department'); INSERT INTO public.quaadpoint_tag (id, procedure_needed, documents_needed, "scope", additional_param, "period", scope2, where_notagid, isglobalscope, document_scope) VALUES(224, '1', 0, 'department', 'and department.id=___dep_id___', -1, '', 'false', false, 'department'); INSERT INTO public.quaadpoint_tag (id, procedure_needed, documents_needed, "scope", additional_param, "period", scope2, where_notagid, isglobalscope, document_scope) VALUES(225, '1', 0, 'department', 'and department.id=___dep_id___', -1, '', 'false', false, 'department'); INSERT INTO public.quaadpoint_tag (id, procedure_needed, documents_needed, "scope", additional_param, "period", scope2, where_notagid, isglobalscope, document_scope) VALUES(226, '1', 0, 'department', 'and department.id=___dep_id___', -1, '', 'false', false, 'department'); INSERT INTO public.quaadpoint_tag (id, procedure_needed, documents_needed, "scope", additional_param, "period", scope2, where_notagid, isglobalscope, document_scope) VALUES(227, '1', 0, 'department', 'and department.id=___dep_id___', -1, '', 'false', false, 'department'); INSERT INTO public.quaadpoint_tag (id, procedure_needed, documents_needed, "scope", additional_param, "period", scope2, where_notagid, isglobalscope, document_scope) VALUES(228, '1', 0, 'department', 'and department.id=___dep_id___', -1, '', 'false', false, 'department'); INSERT INTO public.quaadpoint_tag (id, procedure_needed, documents_needed, "scope", additional_param, "period", scope2, where_notagid, isglobalscope, document_scope) VALUES(229, '1', 0, 'department', 'and department.id=___dep_id___', -1, '', 'false', false, 'department'); INSERT INTO public.quaadpoint_tag (id, procedure_needed, documents_needed, "scope", additional_param, "period", scope2, where_notagid, isglobalscope, document_scope) VALUES(230, '1', 0, 'department', 'and department.id=___dep_id___', -1, '', 'false', false, 'department'); INSERT INTO public.quaadpoint_tag (id, procedure_needed, documents_needed, "scope", additional_param, "period", scope2, where_notagid, isglobalscope, document_scope) VALUES(231, '1', 0, 'department', 'and department.id=___dep_id___', -1, '', 'false', false, 'department'); INSERT INTO public.quaadpoint_tag (id, procedure_needed, documents_needed, "scope", additional_param, "period", scope2, where_notagid, isglobalscope, document_scope) VALUES(232, '1', 0, 'department', 'and department.id=___dep_id___', -1, '', 'false', false, 'department'); INSERT INTO public.quaadpoint_tag (id, procedure_needed, documents_needed, "scope", additional_param, "period", scope2, where_notagid, isglobalscope, document_scope) VALUES(233, '1', 0, 'department', 'and department.id=___dep_id___', -1, '', 'false', false, 'department'); INSERT INTO public.quaadpoint_tag (id, procedure_needed, documents_needed, "scope", additional_param, "period", scope2, where_notagid, isglobalscope, document_scope) VALUES(234, '1', 0, 'department', 'and department.id=___dep_id___', -1, '', 'false', false, 'department'); INSERT INTO public.quaadpoint_tag (id, procedure_needed, documents_needed, "scope", additional_param, "period", scope2, where_notagid, isglobalscope, document_scope) VALUES(235, '1', 0, 'department', 'and department.id=___dep_id___', -1, '', 'false', false, 'department'); INSERT INTO public.quaadpoint_tag (id, procedure_needed, documents_needed, "scope", additional_param, "period", scope2, where_notagid, isglobalscope, document_scope) VALUES(236, '1', 0, 'department', 'and department.id=___dep_id___', -1, '', 'false', false, 'department'); INSERT INTO public.quaadpoint_tag (id, procedure_needed, documents_needed, "scope", additional_param, "period", scope2, where_notagid, isglobalscope, document_scope) VALUES(237, '1', 0, 'department', 'and department.id=___dep_id___', -1, '', 'false', false, 'department'); INSERT INTO public.quaadpoint_tag (id, procedure_needed, documents_needed, "scope", additional_param, "period", scope2, where_notagid, isglobalscope, document_scope) VALUES(238, '1', 0, 'department', 'and department.id=___dep_id___', -1, '', 'false', false, 'department'); INSERT INTO public.quaadpoint_tag (id, procedure_needed, documents_needed, "scope", additional_param, "period", scope2, where_notagid, isglobalscope, document_scope) VALUES(239, '1', 0, 'department', 'and department.id=___dep_id___', -1, '', 'false', false, 'department'); INSERT INTO public.quaadpoint_tag (id, procedure_needed, documents_needed, "scope", additional_param, "period", scope2, where_notagid, isglobalscope, document_scope) VALUES(240, '1', 0, 'department', 'and department.id=___dep_id___', -1, '', 'false', false, 'department'); INSERT INTO public.quaadpoint_tag (id, procedure_needed, documents_needed, "scope", additional_param, "period", scope2, where_notagid, isglobalscope, document_scope) VALUES(241, '1', 0, 'department', 'and department.id=___dep_id___', -1, '', 'false', false, 'department'); INSERT INTO public.quaadpoint_tag (id, procedure_needed, documents_needed, "scope", additional_param, "period", scope2, where_notagid, isglobalscope, document_scope) VALUES(242, '1', 0, 'department', 'and department.id=___dep_id___', -1, '', 'false', false, 'department'); INSERT INTO public.quaadpoint_tag (id, procedure_needed, documents_needed, "scope", additional_param, "period", scope2, where_notagid, isglobalscope, document_scope) VALUES(243, '1', 0, 'department', 'and department.id=___dep_id___', -1, '', 'false', false, 'department'); INSERT INTO public.quaadpoint_tag (id, procedure_needed, documents_needed, "scope", additional_param, "period", scope2, where_notagid, isglobalscope, document_scope) VALUES(244, '1', 0, 'department', 'and department.id=___dep_id___', -1, '', 'false', false, 'department'); INSERT INTO public.quaadpoint_tag (id, procedure_needed, documents_needed, "scope", additional_param, "period", scope2, where_notagid, isglobalscope, document_scope) VALUES(245, '1', 0, 'department', 'and department.id=___dep_id___', -1, '', 'false', false, 'department'); INSERT INTO public.quaadpoint_tag (id, procedure_needed, documents_needed, "scope", additional_param, "period", scope2, where_notagid, isglobalscope, document_scope) VALUES(246, '1', 0, 'department', 'and department.id=___dep_id___', -1, '', 'false', false, 'department'); INSERT INTO public.quaadpoint_tag (id, procedure_needed, documents_needed, "scope", additional_param, "period", scope2, where_notagid, isglobalscope, document_scope) VALUES(247, '1', 0, 'department', 'and department.id=___dep_id___', -1, '', 'false', false, 'department'); INSERT INTO public.quaadpoint_tag (id, procedure_needed, documents_needed, "scope", additional_param, "period", scope2, where_notagid, isglobalscope, document_scope) VALUES(248, '1', 0, 'department', 'and department.id=___dep_id___', -1, '', 'false', false, 'department'); INSERT INTO public.quaadpoint_tag (id, procedure_needed, documents_needed, "scope", additional_param, "period", scope2, where_notagid, isglobalscope, document_scope) VALUES(249, '1', 0, 'department', 'and department.id=___dep_id___', -1, '', 'false', false, 'department'); INSERT INTO public.quaadpoint_tag (id, procedure_needed, documents_needed, "scope", additional_param, "period", scope2, where_notagid, isglobalscope, document_scope) VALUES(250, '1', 0, 'department', 'and department.id=___dep_id___', -1, '', 'false', false, 'department'); INSERT INTO public.quaadpoint_tag (id, procedure_needed, documents_needed, "scope", additional_param, "period", scope2, where_notagid, isglobalscope, document_scope) VALUES(251, '1', 0, 'department', 'and department.id=___dep_id___', -1, '', 'false', false, 'department'); INSERT INTO public.quaadpoint_tag (id, procedure_needed, documents_needed, "scope", additional_param, "period", scope2, where_notagid, isglobalscope, document_scope) VALUES(252, '1', 0, 'department', 'and department.id=___dep_id___', -1, '', 'false', false, 'department'); INSERT INTO public.quaadpoint_tag (id, procedure_needed, documents_needed, "scope", additional_param, "period", scope2, where_notagid, isglobalscope, document_scope) VALUES(253, '1', 0, 'department', 'and department.id=___dep_id___', -1, '', 'false', false, 'department'); INSERT INTO public.quaadpoint_tag (id, procedure_needed, documents_needed, "scope", additional_param, "period", scope2, where_notagid, isglobalscope, document_scope) VALUES(254, '1', 1, 'staff_member', 'and id in (select staff_id from staff_job where dep_id=___dep_id___)', -1, 'staff_formation', 'false', false, 'staff_formation'); INSERT INTO public.quaadpoint_tag (id, procedure_needed, documents_needed, "scope", additional_param, "period", scope2, where_notagid, isglobalscope, document_scope) VALUES(255, '1', 1, 'staff_member', 'and id in (select staff_id from staff_job where dep_id=___dep_id___)', -1, 'staff_formation', 'false', false, 'staff_formation'); INSERT INTO public.quaadpoint_tag (id, procedure_needed, documents_needed, "scope", additional_param, "period", scope2, where_notagid, isglobalscope, document_scope) VALUES(256, '1', 1, 'v_device_plus_deviceinstallation_devid', 'and dep_id=___dep_id___ and (removeddate is null or removeddate > to_date(''___start_date___'',''YYYY-MM-DD HH24:MI:SS''))', -1, '', 'false', false, 'device_installation'); INSERT INTO public.quaadpoint_tag (id, procedure_needed, documents_needed, "scope", additional_param, "period", scope2, where_notagid, isglobalscope, document_scope) VALUES(257, '1', 0, 'department', 'and department.id=___dep_id___', -1, '', 'false', false, 'department'); INSERT INTO public.quaadpoint_tag (id, procedure_needed, documents_needed, "scope", additional_param, "period", scope2, where_notagid, isglobalscope, document_scope) VALUES(258, '1', 0, 'department', 'and department.id=___dep_id___', -1, '', 'false', false, 'department'); INSERT INTO public.quaadpoint_tag (id, procedure_needed, documents_needed, "scope", additional_param, "period", scope2, where_notagid, isglobalscope, document_scope) VALUES(259, '1', 1, 'department', 'and department.id=___dep_id___', -1, '', 'false', false, 'department'); INSERT INTO public.quaadpoint_tag (id, procedure_needed, documents_needed, "scope", additional_param, "period", scope2, where_notagid, isglobalscope, document_scope) VALUES(260, '1', 1, 'staff_member', 'and id in (select staff_id from staff_job where dep_id=___dep_id___)', -1, 'staff_formation', 'false', false, 'staff_formation'); INSERT INTO public.quaadpoint_tag (id, procedure_needed, documents_needed, "scope", additional_param, "period", scope2, where_notagid, isglobalscope, document_scope) VALUES(261, '1', 1, 'staff_member', 'and id in (select staff_id from staff_job where dep_id=___dep_id___)', -1, 'staff_formation', 'false', false, 'staff_formation'); INSERT INTO public.quaadpoint_tag (id, procedure_needed, documents_needed, "scope", additional_param, "period", scope2, where_notagid, isglobalscope, document_scope) VALUES(262, '1', 1, 'staff_member', 'and id in (select staff_id from staff_job where dep_id=___dep_id___)', -1, 'staff_formation', 'false', false, 'staff_formation'); INSERT INTO public.quaadpoint_tag (id, procedure_needed, documents_needed, "scope", additional_param, "period", scope2, where_notagid, isglobalscope, document_scope) VALUES(263, '1', 1, 'staff_member', 'and id in (select staff_id from staff_job where dep_id=___dep_id___)', -1, 'staff_formation', 'false', false, 'staff_formation'); INSERT INTO public.quaadpoint_tag (id, procedure_needed, documents_needed, "scope", additional_param, "period", scope2, where_notagid, isglobalscope, document_scope) VALUES(264, '1', 0, 'staff_member', 'and id in (select staff_id from staff_job where dep_id=___dep_id___)', -1, 'staff_formation', 'false', false, 'staff_formation'); INSERT INTO public.quaadpoint_tag (id, procedure_needed, documents_needed, "scope", additional_param, "period", scope2, where_notagid, isglobalscope, document_scope) VALUES(265, '1', 0, 'staff_member', 'and id in (select staff_id from staff_job where dep_id=___dep_id___)', -1, 'staff_formation', 'false', false, 'staff_formation'); INSERT INTO public.quaadpoint_tag (id, procedure_needed, documents_needed, "scope", additional_param, "period", scope2, where_notagid, isglobalscope, document_scope) VALUES(266, '1', 0, 'v_device_plus_deviceinstallation_devid', 'and dep_id=___dep_id___ and (removeddate is null or removeddate > to_date(''___start_date___'',''YYYY-MM-DD HH24:MI:SS''))', -1, '', 'false', false, 'device_installation'); INSERT INTO public.quaadpoint_tag (id, procedure_needed, documents_needed, "scope", additional_param, "period", scope2, where_notagid, isglobalscope, document_scope) VALUES(267, '1', 1, 'v_device_plus_deviceinstallation_devid', 'and dep_id=___dep_id___ and (removeddate is null or removeddate > to_date(''___start_date___'',''YYYY-MM-DD HH24:MI:SS''))', -1, '', 'false', false, 'device_installation'); INSERT INTO public.quaadpoint_tag (id, procedure_needed, documents_needed, "scope", additional_param, "period", scope2, where_notagid, isglobalscope, document_scope) VALUES(268, '1', 0, 'v_device_plus_deviceinstallation_devid', 'and dep_id=___dep_id___ and (removeddate is null or removeddate > to_date(''___start_date___'',''YYYY-MM-DD HH24:MI:SS''))', -1, '', 'false', false, 'device_installation'); INSERT INTO public.quaadpoint_tag (id, procedure_needed, documents_needed, "scope", additional_param, "period", scope2, where_notagid, isglobalscope, document_scope) VALUES(269, '1', 0, 'department', 'and department.id=___dep_id___', -1, '', 'false', false, 'department'); INSERT INTO public.quaadpoint_tag (id, procedure_needed, documents_needed, "scope", additional_param, "period", scope2, where_notagid, isglobalscope, document_scope) VALUES(270, '1', 0, 'department', 'and department.id=___dep_id___', -1, '', 'false', false, 'department'); INSERT INTO public.quaadpoint_tag (id, procedure_needed, documents_needed, "scope", additional_param, "period", scope2, where_notagid, isglobalscope, document_scope) VALUES(271, '1', 1, 'department', 'and department.id=___dep_id___', -1, '', 'false', false, 'department'); INSERT INTO public.quaadpoint_tag (id, procedure_needed, documents_needed, "scope", additional_param, "period", scope2, where_notagid, isglobalscope, document_scope) VALUES(272, '1', 1, 'v_device_plus_deviceinstallation_devid', 'and modalitytype=''SOFT'' and dep_id=___dep_id___ and (removeddate is null or removeddate > to_date(''___start_date___'',''YYYY-MM-DD HH24:MI:SS''))', -1, '', 'false', false, 'device_installation'); INSERT INTO public.quaadpoint_tag (id, procedure_needed, documents_needed, "scope", additional_param, "period", scope2, where_notagid, isglobalscope, document_scope) VALUES(273, '1', 0, 'department', 'and department.id=___dep_id___', -1, '', 'false', false, 'department'); INSERT INTO public.quaadpoint_tag (id, procedure_needed, documents_needed, "scope", additional_param, "period", scope2, where_notagid, isglobalscope, document_scope) VALUES(274, '1', 0, 'department', 'and department.id=___dep_id___', -1, '', 'false', false, 'department'); INSERT INTO public.quaadpoint_tag (id, procedure_needed, documents_needed, "scope", additional_param, "period", scope2, where_notagid, isglobalscope, document_scope) VALUES(275, '1', 0, 'department', 'and department.id=___dep_id___', -1, '', 'false', false, 'department'); INSERT INTO public.quaadpoint_tag (id, procedure_needed, documents_needed, "scope", additional_param, "period", scope2, where_notagid, isglobalscope, document_scope) VALUES(276, '1', 0, 'department', 'and department.id=___dep_id___', -1, '', 'false', false, 'department'); INSERT INTO public.quaadpoint_tag (id, procedure_needed, documents_needed, "scope", additional_param, "period", scope2, where_notagid, isglobalscope, document_scope) VALUES(277, '1', 0, 'department', 'and department.id=___dep_id___', -1, '', 'false', false, 'department'); INSERT INTO public.quaadpoint_tag (id, procedure_needed, documents_needed, "scope", additional_param, "period", scope2, where_notagid, isglobalscope, document_scope) VALUES(278, '1', 0, 'department', 'and department.id=___dep_id___', -1, '', 'false', false, 'department'); INSERT INTO public.quaadpoint_tag (id, procedure_needed, documents_needed, "scope", additional_param, "period", scope2, where_notagid, isglobalscope, document_scope) VALUES(279, '1', 0, 'department', 'and department.id=___dep_id___', -1, '', 'false', false, 'department'); INSERT INTO public.quaadpoint_tag (id, procedure_needed, documents_needed, "scope", additional_param, "period", scope2, where_notagid, isglobalscope, document_scope) VALUES(280, '1', 0, 'department', 'and department.id=___dep_id___', -1, '', 'false', false, 'department'); INSERT INTO public.quaadpoint_tag (id, procedure_needed, documents_needed, "scope", additional_param, "period", scope2, where_notagid, isglobalscope, document_scope) VALUES(281, '1', 0, 'department', 'and department.id=___dep_id___', -1, '', 'false', false, 'department'); INSERT INTO public.quaadpoint_tag (id, procedure_needed, documents_needed, "scope", additional_param, "period", scope2, where_notagid, isglobalscope, document_scope) VALUES(282, '1', 0, 'department', 'and department.id=___dep_id___', -1, '', 'false', false, 'department'); INSERT INTO public.quaadpoint_tag (id, procedure_needed, documents_needed, "scope", additional_param, "period", scope2, where_notagid, isglobalscope, document_scope) VALUES(283, '1', 0, 'department', 'and department.id=___dep_id___', -1, '', 'false', false, 'department'); INSERT INTO public.quaadpoint_tag (id, procedure_needed, documents_needed, "scope", additional_param, "period", scope2, where_notagid, isglobalscope, document_scope) VALUES(284, '1', 0, 'department', 'and department.id=___dep_id___', -1, '', 'false', false, 'department'); INSERT INTO public.quaadpoint_tag (id, procedure_needed, documents_needed, "scope", additional_param, "period", scope2, where_notagid, isglobalscope, document_scope) VALUES(285, '1', 0, 'department', 'and department.id=___dep_id___', -1, '', 'false', false, 'department'); INSERT INTO public.quaadpoint_tag (id, procedure_needed, documents_needed, "scope", additional_param, "period", scope2, where_notagid, isglobalscope, document_scope) VALUES(286, '1', 0, 'department', 'and department.id=___dep_id___', -1, '', 'false', false, 'department'); INSERT INTO public.quaadpoint_tag (id, procedure_needed, documents_needed, "scope", additional_param, "period", scope2, where_notagid, isglobalscope, document_scope) VALUES(287, '1', 0, 'department', 'and department.id=___dep_id___', -1, '', 'false', false, 'department'); INSERT INTO public.quaadpoint_tag (id, procedure_needed, documents_needed, "scope", additional_param, "period", scope2, where_notagid, isglobalscope, document_scope) VALUES(288, '1', 0, 'department', 'and department.id=___dep_id___', -1, '', 'false', false, 'department'); INSERT INTO public.quaadpoint_tag (id, procedure_needed, documents_needed, "scope", additional_param, "period", scope2, where_notagid, isglobalscope, document_scope) VALUES(289, '1', 0, 'department', 'and department.id=___dep_id___', -1, '', 'false', false, 'department'); INSERT INTO public.quaadpoint_tag (id, procedure_needed, documents_needed, "scope", additional_param, "period", scope2, where_notagid, isglobalscope, document_scope) VALUES(290, '1', 0, 'department', 'and department.id=___dep_id___', -1, '', 'false', false, 'department'); INSERT INTO public.quaadpoint_tag (id, procedure_needed, documents_needed, "scope", additional_param, "period", scope2, where_notagid, isglobalscope, document_scope) VALUES(291, '1', 0, 'department', 'and department.id=___dep_id___', -1, '', 'false', false, 'department'); INSERT INTO public.quaadpoint_tag (id, procedure_needed, documents_needed, "scope", additional_param, "period", scope2, where_notagid, isglobalscope, document_scope) VALUES(292, '1', 0, 'department', 'and department.id=___dep_id___', -1, '', 'false', false, 'department'); INSERT INTO public.quaadpoint_tag (id, procedure_needed, documents_needed, "scope", additional_param, "period", scope2, where_notagid, isglobalscope, document_scope) VALUES(293, '1', 0, 'department', 'and department.id=___dep_id___', -1, '', 'false', false, 'department'); INSERT INTO public.quaadpoint_tag (id, procedure_needed, documents_needed, "scope", additional_param, "period", scope2, where_notagid, isglobalscope, document_scope) VALUES(294, '1', 0, 'department', 'and department.id=___dep_id___', -1, '', 'false', false, 'department'); INSERT INTO public.quaadpoint_tag (id, procedure_needed, documents_needed, "scope", additional_param, "period", scope2, where_notagid, isglobalscope, document_scope) VALUES(295, '1', 0, 'department', 'and department.id=___dep_id___', -1, '', 'false', false, 'department');