3 SELECT evergreen.upgrade_deps_block_check('1117', :eg_version);
5 INSERT INTO permission.perm_list (id, code, description) VALUES
6 (608, 'APPLY_WORKSTATION_SETTING',
7 oils_i18n_gettext(608, 'APPLY_WORKSTATION_SETTING', 'ppl', 'description'));
9 INSERT INTO config.workstation_setting_type (name, grp, datatype, label)
11 'eg.circ.checkin.no_precat_alert', 'circ', 'bool',
13 'eg.circ.checkin.no_precat_alert',
14 'Checkin: Ignore Precataloged Items',
18 'eg.circ.checkin.noop', 'circ', 'bool',
20 'eg.circ.checkin.noop',
21 'Checkin: Suppress Holds and Transits',
25 'eg.circ.checkin.void_overdues', 'circ', 'bool',
27 'eg.circ.checkin.void_overdues',
28 'Checkin: Amnesty Mode',
32 'eg.circ.checkin.auto_print_holds_transits', 'circ', 'bool',
34 'eg.circ.checkin.auto_print_holds_transits',
35 'Checkin: Auto-Print Holds and Transits',
39 'eg.circ.checkin.clear_expired', 'circ', 'bool',
41 'eg.circ.checkin.clear_expired',
42 'Checkin: Clear Holds Shelf',
46 'eg.circ.checkin.retarget_holds', 'circ', 'bool',
48 'eg.circ.checkin.retarget_holds',
49 'Checkin: Retarget Local Holds',
53 'eg.circ.checkin.retarget_holds_all', 'circ', 'bool',
55 'eg.circ.checkin.retarget_holds_all',
56 'Checkin: Retarget All Statuses',
60 'eg.circ.checkin.hold_as_transit', 'circ', 'bool',
62 'eg.circ.checkin.hold_as_transit',
63 'Checkin: Capture Local Holds as Transits',
67 'eg.circ.checkin.manual_float', 'circ', 'bool',
69 'eg.circ.checkin.manual_float',
70 'Checkin: Manual Floating Active',
74 'eg.circ.patron.summary.collapse', 'circ', 'bool',
76 'eg.circ.patron.summary.collapse',
77 'Collaps Patron Summary Display',
81 'circ.bills.receiptonpay', 'circ', 'bool',
83 'circ.bills.receiptonpay',
84 'Print Receipt On Payment',
88 'circ.renew.strict_barcode', 'circ', 'bool',
90 'circ.renew.strict_barcode',
91 'Renew: Strict Barcode',
95 'circ.checkin.strict_barcode', 'circ', 'bool',
97 'circ.checkin.strict_barcode',
98 'Checkin: Strict Barcode',
102 'circ.checkout.strict_barcode', 'circ', 'bool',
104 'circ.checkout.strict_barcode',
105 'Checkout: Strict Barcode',
109 'cat.holdings_show_copies', 'cat', 'bool',
111 'cat.holdings_show_copies',
112 'Holdings View Show Copies',
116 'cat.holdings_show_empty', 'cat', 'bool',
118 'cat.holdings_show_empty',
119 'Holdings View Show Empty Volumes',
123 'cat.holdings_show_empty_org', 'cat', 'bool',
125 'cat.holdings_show_empty_org',
126 'Holdings View Show Empty Orgs',
130 'cat.holdings_show_vols', 'cat', 'bool',
132 'cat.holdings_show_vols',
133 'Holdings View Show Volumes',
137 'cat.copy.defaults', 'cat', 'object',
140 'Copy Edit Default Values',
144 'cat.printlabels.default_template', 'cat', 'string',
146 'cat.printlabels.default_template',
147 'Print Label Default Template',
151 'cat.printlabels.templates', 'cat', 'object',
153 'cat.printlabels.templates',
154 'Print Label Templates',
158 'eg.circ.patron.search.include_inactive', 'circ', 'bool',
160 'eg.circ.patron.search.include_inactive',
161 'Patron Search Include Inactive',
165 'eg.circ.patron.search.show_extras', 'circ', 'bool',
167 'eg.circ.patron.search.show_extras',
168 'Patron Search Show Extra Search Options',
172 'eg.grid.circ.checkin.checkin', 'gui', 'object',
174 'eg.grid.circ.checkin.checkin',
175 'Grid Config: circ.checkin.checkin',
179 'eg.grid.circ.checkin.capture', 'gui', 'object',
181 'eg.grid.circ.checkin.capture',
182 'Grid Config: circ.checkin.capture',
186 'eg.grid.admin.server.config.copy_tag_type', 'gui', 'object',
188 'eg.grid.admin.server.config.copy_tag_type',
189 'Grid Config: admin.server.config.copy_tag_type',
193 'eg.grid.admin.server.config.metabib_field_virtual_map.grid', 'gui', 'object',
195 'eg.grid.admin.server.config.metabib_field_virtual_map.grid',
196 'Grid Config: admin.server.config.metabib_field_virtual_map.grid',
200 'eg.grid.admin.server.config.metabib_field.grid', 'gui', 'object',
202 'eg.grid.admin.server.config.metabib_field.grid',
203 'Grid Config: admin.server.config.metabib_field.grid',
207 'eg.grid.admin.server.config.marc_field', 'gui', 'object',
209 'eg.grid.admin.server.config.marc_field',
210 'Grid Config: admin.server.config.marc_field',
214 'eg.grid.admin.server.asset.copy_tag', 'gui', 'object',
216 'eg.grid.admin.server.asset.copy_tag',
217 'Grid Config: admin.server.asset.copy_tag',
221 'eg.grid.admin.local.circ.neg_balance_users', 'gui', 'object',
223 'eg.grid.admin.local.circ.neg_balance_users',
224 'Grid Config: admin.local.circ.neg_balance_users',
228 'eg.grid.admin.local.rating.badge', 'gui', 'object',
230 'eg.grid.admin.local.rating.badge',
231 'Grid Config: admin.local.rating.badge',
235 'eg.grid.admin.workstation.work_log', 'gui', 'object',
237 'eg.grid.admin.workstation.work_log',
238 'Grid Config: admin.workstation.work_log',
242 'eg.grid.admin.workstation.patron_log', 'gui', 'object',
244 'eg.grid.admin.workstation.patron_log',
245 'Grid Config: admin.workstation.patron_log',
249 'eg.grid.admin.serials.pattern_template', 'gui', 'object',
251 'eg.grid.admin.serials.pattern_template',
252 'Grid Config: admin.serials.pattern_template',
256 'eg.grid.serials.copy_templates', 'gui', 'object',
258 'eg.grid.serials.copy_templates',
259 'Grid Config: serials.copy_templates',
263 'eg.grid.cat.record_overlay.holdings', 'gui', 'object',
265 'eg.grid.cat.record_overlay.holdings',
266 'Grid Config: cat.record_overlay.holdings',
270 'eg.grid.cat.bucket.record.search', 'gui', 'object',
272 'eg.grid.cat.bucket.record.search',
273 'Grid Config: cat.bucket.record.search',
277 'eg.grid.cat.bucket.record.view', 'gui', 'object',
279 'eg.grid.cat.bucket.record.view',
280 'Grid Config: cat.bucket.record.view',
284 'eg.grid.cat.bucket.record.pending', 'gui', 'object',
286 'eg.grid.cat.bucket.record.pending',
287 'Grid Config: cat.bucket.record.pending',
291 'eg.grid.cat.bucket.copy.view', 'gui', 'object',
293 'eg.grid.cat.bucket.copy.view',
294 'Grid Config: cat.bucket.copy.view',
298 'eg.grid.cat.bucket.copy.pending', 'gui', 'object',
300 'eg.grid.cat.bucket.copy.pending',
301 'Grid Config: cat.bucket.copy.pending',
305 'eg.grid.cat.items', 'gui', 'object',
308 'Grid Config: cat.items',
312 'eg.grid.cat.volcopy.copies', 'gui', 'object',
314 'eg.grid.cat.volcopy.copies',
315 'Grid Config: cat.volcopy.copies',
319 'eg.grid.cat.volcopy.copies.complete', 'gui', 'object',
321 'eg.grid.cat.volcopy.copies.complete',
322 'Grid Config: cat.volcopy.copies.complete',
326 'eg.grid.cat.peer_bibs', 'gui', 'object',
328 'eg.grid.cat.peer_bibs',
329 'Grid Config: cat.peer_bibs',
333 'eg.grid.cat.catalog.holds', 'gui', 'object',
335 'eg.grid.cat.catalog.holds',
336 'Grid Config: cat.catalog.holds',
340 'eg.grid.cat.holdings', 'gui', 'object',
342 'eg.grid.cat.holdings',
343 'Grid Config: cat.holdings',
347 'eg.grid.cat.z3950_results', 'gui', 'object',
349 'eg.grid.cat.z3950_results',
350 'Grid Config: cat.z3950_results',
354 'eg.grid.circ.holds.shelf', 'gui', 'object',
356 'eg.grid.circ.holds.shelf',
357 'Grid Config: circ.holds.shelf',
361 'eg.grid.circ.holds.pull', 'gui', 'object',
363 'eg.grid.circ.holds.pull',
364 'Grid Config: circ.holds.pull',
368 'eg.grid.circ.in_house_use', 'gui', 'object',
370 'eg.grid.circ.in_house_use',
371 'Grid Config: circ.in_house_use',
375 'eg.grid.circ.renew', 'gui', 'object',
377 'eg.grid.circ.renew',
378 'Grid Config: circ.renew',
382 'eg.grid.circ.transits.list', 'gui', 'object',
384 'eg.grid.circ.transits.list',
385 'Grid Config: circ.transits.list',
389 'eg.grid.circ.patron.holds', 'gui', 'object',
391 'eg.grid.circ.patron.holds',
392 'Grid Config: circ.patron.holds',
396 'eg.grid.circ.pending_patrons.list', 'gui', 'object',
398 'eg.grid.circ.pending_patrons.list',
399 'Grid Config: circ.pending_patrons.list',
403 'eg.grid.circ.patron.items_out.noncat', 'gui', 'object',
405 'eg.grid.circ.patron.items_out.noncat',
406 'Grid Config: circ.patron.items_out.noncat',
410 'eg.grid.circ.patron.items_out', 'gui', 'object',
412 'eg.grid.circ.patron.items_out',
413 'Grid Config: circ.patron.items_out',
417 'eg.grid.circ.patron.billhistory_payments', 'gui', 'object',
419 'eg.grid.circ.patron.billhistory_payments',
420 'Grid Config: circ.patron.billhistory_payments',
424 'eg.grid.user.bucket.view', 'gui', 'object',
426 'eg.grid.user.bucket.view',
427 'Grid Config: user.bucket.view',
431 'eg.grid.user.bucket.pending', 'gui', 'object',
433 'eg.grid.user.bucket.pending',
434 'Grid Config: user.bucket.pending',
438 'eg.grid.circ.patron.staff_messages', 'gui', 'object',
440 'eg.grid.circ.patron.staff_messages',
441 'Grid Config: circ.patron.staff_messages',
445 'eg.grid.circ.patron.archived_messages', 'gui', 'object',
447 'eg.grid.circ.patron.archived_messages',
448 'Grid Config: circ.patron.archived_messages',
452 'eg.grid.circ.patron.bills', 'gui', 'object',
454 'eg.grid.circ.patron.bills',
455 'Grid Config: circ.patron.bills',
459 'eg.grid.circ.patron.checkout', 'gui', 'object',
461 'eg.grid.circ.patron.checkout',
462 'Grid Config: circ.patron.checkout',
466 'eg.grid.serials.mfhd_grid', 'gui', 'object',
468 'eg.grid.serials.mfhd_grid',
469 'Grid Config: serials.mfhd_grid',
473 'eg.grid.serials.view_item_grid', 'gui', 'object',
475 'eg.grid.serials.view_item_grid',
476 'Grid Config: serials.view_item_grid',
480 'eg.grid.serials.dist_stream_grid', 'gui', 'object',
482 'eg.grid.serials.dist_stream_grid',
483 'Grid Config: serials.dist_stream_grid',
487 'eg.grid.circ.patron.search', 'gui', 'object',
489 'eg.grid.circ.patron.search',
490 'Grid Config: circ.patron.search',
494 'eg.cat.record.summary.collapse', 'gui', 'bool',
496 'eg.cat.record.summary.collapse',
497 'Collapse Bib Record Summary',
501 'cat.marcedit.flateditor', 'gui', 'bool',
503 'cat.marcedit.flateditor',
504 'Use Flat MARC Editor',
508 'cat.marcedit.stack_subfields', 'gui', 'bool',
510 'cat.marcedit.stack_subfields',
511 'MARC Editor Stack Subfields',
515 'eg.offline.print_receipt', 'gui', 'bool',
517 'eg.offline.print_receipt',
518 'Offline Print Receipt',
522 'eg.offline.strict_barcode', 'gui', 'bool',
524 'eg.offline.strict_barcode',
525 'Offline Use Strict Barcode',
529 'cat.default_bib_marc_template', 'gui', 'string',
531 'cat.default_bib_marc_template',
532 'Default MARC Template',
536 'eg.audio.disable', 'gui', 'bool',
539 'Disable Staff Client Notification Audio',
543 'eg.search.adv_pane', 'gui', 'string',
545 'eg.search.adv_pane',
546 'Catalog Advanced Search Default Pane',
550 'eg.print.template_context.bills_current', 'gui', 'string',
552 'eg.print.template_context.bills_current',
553 'Print Template Context: bills_current',
557 'eg.print.template.bills_current', 'gui', 'string',
559 'eg.print.template.bills_current',
560 'Print Template: bills_current',
564 'eg.print.template_context.bills_historical', 'gui', 'string',
566 'eg.print.template_context.bills_historical',
567 'Print Template Context: bills_historical',
571 'eg.print.template.bills_historical', 'gui', 'string',
573 'eg.print.template.bills_historical',
574 'Print Template: bills_historical',
578 'eg.print.template_context.bill_payment', 'gui', 'string',
580 'eg.print.template_context.bill_payment',
581 'Print Template Context: bill_payment',
585 'eg.print.template.bill_payment', 'gui', 'string',
587 'eg.print.template.bill_payment',
588 'Print Template: bill_payment',
592 'eg.print.template_context.checkin', 'gui', 'string',
594 'eg.print.template_context.checkin',
595 'Print Template Context: checkin',
599 'eg.print.template.checkin', 'gui', 'string',
601 'eg.print.template.checkin',
602 'Print Template: checkin',
606 'eg.print.template_context.checkout', 'gui', 'string',
608 'eg.print.template_context.checkout',
609 'Print Template Context: checkout',
613 'eg.print.template.checkout', 'gui', 'string',
615 'eg.print.template.checkout',
616 'Print Template: checkout',
620 'eg.print.template_context.hold_transit_slip', 'gui', 'string',
622 'eg.print.template_context.hold_transit_slip',
623 'Print Template Context: hold_transit_slip',
627 'eg.print.template.hold_transit_slip', 'gui', 'string',
629 'eg.print.template.hold_transit_slip',
630 'Print Template: hold_transit_slip',
634 'eg.print.template_context.hold_shelf_slip', 'gui', 'string',
636 'eg.print.template_context.hold_shelf_slip',
637 'Print Template Context: hold_shelf_slip',
641 'eg.print.template.hold_shelf_slip', 'gui', 'string',
643 'eg.print.template.hold_shelf_slip',
644 'Print Template: hold_shelf_slip',
648 'eg.print.template_context.holds_for_bib', 'gui', 'string',
650 'eg.print.template_context.holds_for_bib',
651 'Print Template Context: holds_for_bib',
655 'eg.print.template.holds_for_bib', 'gui', 'string',
657 'eg.print.template.holds_for_bib',
658 'Print Template: holds_for_bib',
662 'eg.print.template_context.holds_for_patron', 'gui', 'string',
664 'eg.print.template_context.holds_for_patron',
665 'Print Template Context: holds_for_patron',
669 'eg.print.template.holds_for_patron', 'gui', 'string',
671 'eg.print.template.holds_for_patron',
672 'Print Template: holds_for_patron',
676 'eg.print.template_context.hold_pull_list', 'gui', 'string',
678 'eg.print.template_context.hold_pull_list',
679 'Print Template Context: hold_pull_list',
683 'eg.print.template.hold_pull_list', 'gui', 'string',
685 'eg.print.template.hold_pull_list',
686 'Print Template: hold_pull_list',
690 'eg.print.template_context.hold_shelf_list', 'gui', 'string',
692 'eg.print.template_context.hold_shelf_list',
693 'Print Template Context: hold_shelf_list',
697 'eg.print.template.hold_shelf_list', 'gui', 'string',
699 'eg.print.template.hold_shelf_list',
700 'Print Template: hold_shelf_list',
704 'eg.print.template_context.in_house_use_list', 'gui', 'string',
706 'eg.print.template_context.in_house_use_list',
707 'Print Template Context: in_house_use_list',
711 'eg.print.template.in_house_use_list', 'gui', 'string',
713 'eg.print.template.in_house_use_list',
714 'Print Template: in_house_use_list',
718 'eg.print.template_context.item_status', 'gui', 'string',
720 'eg.print.template_context.item_status',
721 'Print Template Context: item_status',
725 'eg.print.template.item_status', 'gui', 'string',
727 'eg.print.template.item_status',
728 'Print Template: item_status',
732 'eg.print.template_context.items_out', 'gui', 'string',
734 'eg.print.template_context.items_out',
735 'Print Template Context: items_out',
739 'eg.print.template.items_out', 'gui', 'string',
741 'eg.print.template.items_out',
742 'Print Template: items_out',
746 'eg.print.template_context.patron_address', 'gui', 'string',
748 'eg.print.template_context.patron_address',
749 'Print Template Context: patron_address',
753 'eg.print.template.patron_address', 'gui', 'string',
755 'eg.print.template.patron_address',
756 'Print Template: patron_address',
760 'eg.print.template_context.patron_data', 'gui', 'string',
762 'eg.print.template_context.patron_data',
763 'Print Template Context: patron_data',
767 'eg.print.template.patron_data', 'gui', 'string',
769 'eg.print.template.patron_data',
770 'Print Template: patron_data',
774 'eg.print.template_context.patron_note', 'gui', 'string',
776 'eg.print.template_context.patron_note',
777 'Print Template Context: patron_note',
781 'eg.print.template.patron_note', 'gui', 'string',
783 'eg.print.template.patron_note',
784 'Print Template: patron_note',
788 'eg.print.template_context.renew', 'gui', 'string',
790 'eg.print.template_context.renew',
791 'Print Template Context: renew',
795 'eg.print.template.renew', 'gui', 'string',
797 'eg.print.template.renew',
798 'Print Template: renew',
802 'eg.print.template_context.transit_list', 'gui', 'string',
804 'eg.print.template_context.transit_list',
805 'Print Template Context: transit_list',
809 'eg.print.template.transit_list', 'gui', 'string',
811 'eg.print.template.transit_list',
812 'Print Template: transit_list',
816 'eg.print.template_context.transit_slip', 'gui', 'string',
818 'eg.print.template_context.transit_slip',
819 'Print Template Context: transit_slip',
823 'eg.print.template.transit_slip', 'gui', 'string',
825 'eg.print.template.transit_slip',
826 'Print Template: transit_slip',
830 'eg.print.template_context.offline_checkout', 'gui', 'string',
832 'eg.print.template_context.offline_checkout',
833 'Print Template Context: offline_checkout',
837 'eg.print.template.offline_checkout', 'gui', 'string',
839 'eg.print.template.offline_checkout',
840 'Print Template: offline_checkout',
844 'eg.print.template_context.offline_renew', 'gui', 'string',
846 'eg.print.template_context.offline_renew',
847 'Print Template Context: offline_renew',
851 'eg.print.template.offline_renew', 'gui', 'string',
853 'eg.print.template.offline_renew',
854 'Print Template: offline_renew',
858 'eg.print.template_context.offline_checkin', 'gui', 'string',
860 'eg.print.template_context.offline_checkin',
861 'Print Template Context: offline_checkin',
865 'eg.print.template.offline_checkin', 'gui', 'string',
867 'eg.print.template.offline_checkin',
868 'Print Template: offline_checkin',
872 'eg.print.template_context.offline_in_house_use', 'gui', 'string',
874 'eg.print.template_context.offline_in_house_use',
875 'Print Template Context: offline_in_house_use',
879 'eg.print.template.offline_in_house_use', 'gui', 'string',
881 'eg.print.template.offline_in_house_use',
882 'Print Template: offline_in_house_use',
886 'eg.serials.stream_names', 'gui', 'array',
888 'eg.serials.stream_names',
889 'Serials Local Stream Names',
893 'eg.serials.items.do_print_routing_lists', 'gui', 'bool',
895 'eg.serials.items.do_print_routing_lists',
896 'Serials Print Routing Lists',
900 'eg.serials.items.receive_and_barcode', 'gui', 'bool',
902 'eg.serials.items.receive_and_barcode',
903 'Serials Barcode On Receive',
909 -- More values with fm_class'es
910 INSERT INTO config.workstation_setting_type (name, grp, datatype, fm_class, label)
912 'eg.search.search_lib', 'gui', 'link', 'aou',
914 'eg.search.search_lib',
915 'Staff Catalog Default Search Library',
919 'eg.search.pref_lib', 'gui', 'link', 'aou',
921 'eg.search.pref_lib',
922 'Staff Catalog Preferred Library',