Vendor |
[% target.provider.name %]
[% target.provider.addresses.0.street1 %]
[% target.provider.addresses.0.street2 %]
[% target.provider.addresses.0.city %]
[% target.provider.addresses.0.state %]
[% target.provider.addresses.0.country %]
[% target.provider.addresses.0.post_code %]
|
Ship to / Bill to |
[% target.ordering_agency.name %]
[% target.ordering_agency.billing_address.street1 %]
[% target.ordering_agency.billing_address.street2 %]
[% target.ordering_agency.billing_address.city %]
[% target.ordering_agency.billing_address.state %]
[% target.ordering_agency.billing_address.country %]
[% target.ordering_agency.billing_address.post_code %]
|
PO# | ISBN or Item # | Title | Quantity | Unit Price | Line Total | Delayed / Canceled | Notes |
---|---|---|---|---|---|---|---|
[% target.id %] | [% ident_value %] | [% PROCESS get_li_attr attr_name = 'title' %] | [% count %] | [% price %] | [% litotal %] | [% li.cancel_reason.label %] |
|
Subtotal | [% subtotal %] |
[% IF ent.phone %] Phone: [% ent.phone %]
[% END %]
[% IF ent.fax_phone %] Fax: [% ent.fax_phone %]
[% END %]
[% IF ent.url %] URL: [% ent.url %]
[% END %]
[% IF ent.email %] E-mail: [% ent.email %] [% END %]
[% blob.fund.code %] ([% blob.fund.year %]): | $[% blob.total %] |
---|
Branch | Barcode | Call Number | Fund | Shelving Location | Recd. | Notes | Delayed / Canceled |
---|---|---|---|---|---|---|---|
[% detail.owning_lib %] | [% IF copy.barcode %] | [% END %][% IF cn_label %][% cn_label %][% END %] | [% IF detail.fund %][% detail.fund.code %] ([% detail.fund.year %])[% END %] | [% copy.location.name %] | [% IF detail.recv_time %][% detail.recv_time %][% END %] | [% detail.note %] | [% detail.cancel_reason.label %] |
Title | Author | Shelving Location | Call Number | Barcode/Part | Patron |
---|---|---|---|---|---|
[% copy_data.title | truncate %] | [% copy_data.author | truncate %] | [% hold.current_copy.location.name %] | [% hold.current_copy.call_number.label %] | [% hold.current_copy.barcode %] [% FOR part IN hold.current_copy.parts %] [% part.part.label %] [% END %] | [% hold.usr.card.barcode %] |
Queue ID: [% target.0.queue.id %] Queue Name: [% target.0.queue.name %] Queue Type: [% target.0.queue.queue_type %] Complete? [% target.0.queue.complete %] [% FOR vqbr IN target %] =-=-= Title of work | [% helpers.get_queued_bib_attr('title',vqbr.attributes) %] Author of work | [% helpers.get_queued_bib_attr('author',vqbr.attributes) %] Language of work | [% helpers.get_queued_bib_attr('language',vqbr.attributes) %] Pagination | [% helpers.get_queued_bib_attr('pagination',vqbr.attributes) %] ISBN | [% helpers.get_queued_bib_attr('isbn',vqbr.attributes) %] ISSN | [% helpers.get_queued_bib_attr('issn',vqbr.attributes) %] Price | [% helpers.get_queued_bib_attr('price',vqbr.attributes) %] Accession Number | [% helpers.get_queued_bib_attr('rec_identifier',vqbr.attributes) %] TCN Value | [% helpers.get_queued_bib_attr('eg_tcn',vqbr.attributes) %] TCN Source | [% helpers.get_queued_bib_attr('eg_tcn_source',vqbr.attributes) %] Internal ID | [% helpers.get_queued_bib_attr('eg_identifier',vqbr.attributes) %] Publisher | [% helpers.get_queued_bib_attr('publisher',vqbr.attributes) %] Publication Date | [% helpers.get_queued_bib_attr('pubdate',vqbr.attributes) %] Edition | [% helpers.get_queued_bib_attr('edition',vqbr.attributes) %] Item Barcode | [% helpers.get_queued_bib_attr('item_barcode',vqbr.attributes) %] Import Error | [% vqbr.import_error %] Error Detail | [% vqbr.error_detail %] Match Count | [% vqbr.matches.size %] [% END %]$$ ) ; INSERT INTO action_trigger.environment ( event_def, path) VALUES ( 39, 'attributes') ,( 39, 'queue') ,( 39, 'matches') ; INSERT INTO action_trigger.event_definition ( id, active, owner, name, hook, validator, reactor, group_field, granularity, template ) VALUES ( 40, TRUE, 1, 'CSV Output for Queued Bib Records', 'vandelay.queued_bib_record.csv', 'NOOP_True', 'ProcessTemplate', 'queue.owner', 'print-on-demand', $$ [%- USE date -%] "Title of work","Author of work","Language of work","Pagination","ISBN","ISSN","Price","Accession Number","TCN Value","TCN Source","Internal ID","Publisher","Publication Date","Edition","Item Barcode","Import Error","Error Detail","Match Count" [% FOR vqbr IN target %]"[% helpers.get_queued_bib_attr('title',vqbr.attributes) | replace('"', '""') %]","[% helpers.get_queued_bib_attr('author',vqbr.attributes) | replace('"', '""') %]","[% helpers.get_queued_bib_attr('language',vqbr.attributes) | replace('"', '""') %]","[% helpers.get_queued_bib_attr('pagination',vqbr.attributes) | replace('"', '""') %]","[% helpers.get_queued_bib_attr('isbn',vqbr.attributes) | replace('"', '""') %]","[% helpers.get_queued_bib_attr('issn',vqbr.attributes) | replace('"', '""') %]","[% helpers.get_queued_bib_attr('price',vqbr.attributes) | replace('"', '""') %]","[% helpers.get_queued_bib_attr('rec_identifier',vqbr.attributes) | replace('"', '""') %]","[% helpers.get_queued_bib_attr('eg_tcn',vqbr.attributes) | replace('"', '""') %]","[% helpers.get_queued_bib_attr('eg_tcn_source',vqbr.attributes) | replace('"', '""') %]","[% helpers.get_queued_bib_attr('eg_identifier',vqbr.attributes) | replace('"', '""') %]","[% helpers.get_queued_bib_attr('publisher',vqbr.attributes) | replace('"', '""') %]","[% helpers.get_queued_bib_attr('pubdate',vqbr.attributes) | replace('"', '""') %]","[% helpers.get_queued_bib_attr('edition',vqbr.attributes) | replace('"', '""') %]","[% helpers.get_queued_bib_attr('item_barcode',vqbr.attributes) | replace('"', '""') %]","[% vqbr.import_error | replace('"', '""') %]","[% vqbr.error_detail | replace('"', '""') %]","[% vqbr.matches.size %]" [% END %] $$ ) ; INSERT INTO action_trigger.environment ( event_def, path) VALUES ( 40, 'attributes') ,( 40, 'queue') ,( 40, 'matches') ; INSERT INTO action_trigger.event_definition ( id, active, owner, name, hook, validator, reactor, group_field, granularity, template ) VALUES ( 41, TRUE, 1, 'Email Output for Queued Bib Records', 'vandelay.queued_bib_record.email', 'NOOP_True', 'SendEmail', 'queue.owner', NULL, $$ [%- USE date -%] [%- SET user = target.0.queue.owner -%] To: [%- params.recipient_email || user.email || 'root@localhost' %] From: [%- params.sender_email || default_sender %] Date: [%- date.format(date.now, '%a, %d %b %Y %T -0000', gmt => 1) %] Subject: Bibs from Import Queue Auto-Submitted: auto-generated Queue ID: [% target.0.queue.id %] Queue Name: [% target.0.queue.name %] Queue Type: [% target.0.queue.queue_type %] Complete? [% target.0.queue.complete %] [% FOR vqbr IN target %] =-=-= Title of work | [% helpers.get_queued_bib_attr('title',vqbr.attributes) %] Author of work | [% helpers.get_queued_bib_attr('author',vqbr.attributes) %] Language of work | [% helpers.get_queued_bib_attr('language',vqbr.attributes) %] Pagination | [% helpers.get_queued_bib_attr('pagination',vqbr.attributes) %] ISBN | [% helpers.get_queued_bib_attr('isbn',vqbr.attributes) %] ISSN | [% helpers.get_queued_bib_attr('issn',vqbr.attributes) %] Price | [% helpers.get_queued_bib_attr('price',vqbr.attributes) %] Accession Number | [% helpers.get_queued_bib_attr('rec_identifier',vqbr.attributes) %] TCN Value | [% helpers.get_queued_bib_attr('eg_tcn',vqbr.attributes) %] TCN Source | [% helpers.get_queued_bib_attr('eg_tcn_source',vqbr.attributes) %] Internal ID | [% helpers.get_queued_bib_attr('eg_identifier',vqbr.attributes) %] Publisher | [% helpers.get_queued_bib_attr('publisher',vqbr.attributes) %] Publication Date | [% helpers.get_queued_bib_attr('pubdate',vqbr.attributes) %] Edition | [% helpers.get_queued_bib_attr('edition',vqbr.attributes) %] Item Barcode | [% helpers.get_queued_bib_attr('item_barcode',vqbr.attributes) %] [% END %] $$ ) ; INSERT INTO action_trigger.environment ( event_def, path) VALUES ( 41, 'attributes') ,( 41, 'queue') ,( 41, 'queue.owner') ; INSERT INTO action_trigger.event_definition ( id, active, owner, name, hook, validator, reactor, group_field, granularity, template ) VALUES ( 42, TRUE, 1, 'Print Output for Queued Authority Records', 'vandelay.queued_auth_record.print', 'NOOP_True', 'ProcessTemplate', 'queue.owner', 'print-on-demand', $$ [%- USE date -%]
Queue ID: [% target.0.queue.id %] Queue Name: [% target.0.queue.name %] Queue Type: [% target.0.queue.queue_type %] Complete? [% target.0.queue.complete %] [% FOR vqar IN target %] =-=-= Record Identifier | [% helpers.get_queued_auth_attr('rec_identifier',vqar.attributes) %] [% END %]$$ ) ; INSERT INTO action_trigger.environment ( event_def, path) VALUES ( 42, 'attributes') ,( 42, 'queue') ; INSERT INTO action_trigger.event_definition ( id, active, owner, name, hook, validator, reactor, group_field, granularity, template ) VALUES ( 43, TRUE, 1, 'CSV Output for Queued Authority Records', 'vandelay.queued_auth_record.csv', 'NOOP_True', 'ProcessTemplate', 'queue.owner', 'print-on-demand', $$ [%- USE date -%] "Record Identifier" [% FOR vqar IN target %]"[% helpers.get_queued_auth_attr('rec_identifier',vqar.attributes) | replace('"', '""') %]" [% END %] $$ ) ; INSERT INTO action_trigger.environment ( event_def, path) VALUES ( 43, 'attributes') ,( 43, 'queue') ; INSERT INTO action_trigger.event_definition ( id, active, owner, name, hook, validator, reactor, group_field, granularity, template ) VALUES ( 44, TRUE, 1, 'Email Output for Queued Authority Records', 'vandelay.queued_auth_record.email', 'NOOP_True', 'SendEmail', 'queue.owner', NULL, $$ [%- USE date -%] [%- SET user = target.0.queue.owner -%] To: [%- params.recipient_email || user.email || 'root@localhost' %] From: [%- params.sender_email || default_sender %] Date: [%- date.format(date.now, '%a, %d %b %Y %T -0000', gmt => 1) %] Subject: Authorities from Import Queue Auto-Submitted: auto-generated Queue ID: [% target.0.queue.id %] Queue Name: [% target.0.queue.name %] Queue Type: [% target.0.queue.queue_type %] Complete? [% target.0.queue.complete %] [% FOR vqar IN target %] =-=-= Record Identifier | [% helpers.get_queued_auth_attr('rec_identifier',vqar.attributes) %] [% END %] $$ ) ; INSERT INTO action_trigger.environment ( event_def, path) VALUES ( 44, 'attributes') ,( 44, 'queue') ,( 44, 'queue.owner') ; INSERT INTO action_trigger.event_definition ( id, active, owner, name, hook, validator, reactor, group_field, granularity, template ) VALUES ( 45, TRUE, 1, 'Print Output for Import Items from Queued Bib Records', 'vandelay.import_items.print', 'NOOP_True', 'ProcessTemplate', 'record.queue.owner', 'print-on-demand', $$ [%- USE date -%]
Queue ID: [% target.0.record.queue.id %] Queue Name: [% target.0.record.queue.name %] Queue Type: [% target.0.record.queue.queue_type %] Complete? [% target.0.record.queue.complete %] [% FOR vii IN target %] =-=-= Import Item ID | [% vii.id %] Title of work | [% helpers.get_queued_bib_attr('title',vii.record.attributes) %] ISBN | [% helpers.get_queued_bib_attr('isbn',vii.record.attributes) %] Attribute Definition | [% vii.definition %] Import Error | [% vii.import_error %] Import Error Detail | [% vii.error_detail %] Owning Library | [% vii.owning_lib %] Circulating Library | [% vii.circ_lib %] Call Number | [% vii.call_number %] Copy Number | [% vii.copy_number %] Status | [% vii.status.name %] Shelving Location | [% vii.location.name %] Circulate | [% vii.circulate %] Deposit | [% vii.deposit %] Deposit Amount | [% vii.deposit_amount %] Reference | [% vii.ref %] Holdable | [% vii.holdable %] Price | [% vii.price %] Barcode | [% vii.barcode %] Circulation Modifier | [% vii.circ_modifier %] Circulate As MARC Type | [% vii.circ_as_type %] Alert Message | [% vii.alert_message %] Public Note | [% vii.pub_note %] Private Note | [% vii.priv_note %] OPAC Visible | [% vii.opac_visible %] [% END %]$$ ) ; INSERT INTO action_trigger.environment ( event_def, path) VALUES ( 45, 'record') ,( 45, 'record.attributes') ,( 45, 'record.queue') ,( 45, 'record.queue.owner') ; INSERT INTO action_trigger.event_definition ( id, active, owner, name, hook, validator, reactor, group_field, granularity, template ) VALUES ( 46, TRUE, 1, 'CSV Output for Import Items from Queued Bib Records', 'vandelay.import_items.csv', 'NOOP_True', 'ProcessTemplate', 'record.queue.owner', 'print-on-demand', $$ [%- USE date -%] "Import Item ID","Title of work","ISBN","Attribute Definition","Import Error","Import Error Detail","Owning Library","Circulating Library","Call Number","Copy Number","Status","Shelving Location","Circulate","Deposit","Deposit Amount","Reference","Holdable","Price","Barcode","Circulation Modifier","Circulate As MARC Type","Alert Message","Public Note","Private Note","OPAC Visible" [% FOR vii IN target %]"[% vii.id | replace('"', '""') %]","[% helpers.get_queued_bib_attr('title',vii.record.attributes) | replace('"', '""') %]","[% helpers.get_queued_bib_attr('isbn',vii.record.attributes) | replace('"', '""') %]","[% vii.definition | replace('"', '""') %]","[% vii.import_error | replace('"', '""') %]","[% vii.error_detail | replace('"', '""') %]","[% vii.owning_lib | replace('"', '""') %]","[% vii.circ_lib | replace('"', '""') %]","[% vii.call_number | replace('"', '""') %]","[% vii.copy_number | replace('"', '""') %]","[% vii.status.name | replace('"', '""') %]","[% vii.location.name | replace('"', '""') %]","[% vii.circulate | replace('"', '""') %]","[% vii.deposit | replace('"', '""') %]","[% vii.deposit_amount | replace('"', '""') %]","[% vii.ref | replace('"', '""') %]","[% vii.holdable | replace('"', '""') %]","[% vii.price | replace('"', '""') %]","[% vii.barcode | replace('"', '""') %]","[% vii.circ_modifier | replace('"', '""') %]","[% vii.circ_as_type | replace('"', '""') %]","[% vii.alert_message | replace('"', '""') %]","[% vii.pub_note | replace('"', '""') %]","[% vii.priv_note | replace('"', '""') %]","[% vii.opac_visible | replace('"', '""') %]" [% END %] $$ ) ; INSERT INTO action_trigger.environment ( event_def, path) VALUES ( 46, 'record') ,( 46, 'record.attributes') ,( 46, 'record.queue') ,( 46, 'record.queue.owner') ; INSERT INTO action_trigger.event_definition ( id, active, owner, name, hook, validator, reactor, group_field, granularity, template ) VALUES ( 47, TRUE, 1, 'Email Output for Import Items from Queued Bib Records', 'vandelay.import_items.email', 'NOOP_True', 'SendEmail', 'record.queue.owner', NULL, $$ [%- USE date -%] [%- SET user = target.0.record.queue.owner -%] To: [%- params.recipient_email || user.email || 'root@localhost' %] From: [%- params.sender_email || default_sender %] Date: [%- date.format(date.now, '%a, %d %b %Y %T -0000', gmt => 1) %] Subject: Import Items from Import Queue Auto-Submitted: auto-generated Queue ID: [% target.0.record.queue.id %] Queue Name: [% target.0.record.queue.name %] Queue Type: [% target.0.record.queue.queue_type %] Complete? [% target.0.record.queue.complete %] [% FOR vii IN target %] =-=-= Import Item ID | [% vii.id %] Title of work | [% helpers.get_queued_bib_attr('title',vii.record.attributes) %] ISBN | [% helpers.get_queued_bib_attr('isbn',vii.record.attributes) %] Attribute Definition | [% vii.definition %] Import Error | [% vii.import_error %] Import Error Detail | [% vii.error_detail %] Owning Library | [% vii.owning_lib %] Circulating Library | [% vii.circ_lib %] Call Number | [% vii.call_number %] Copy Number | [% vii.copy_number %] Status | [% vii.status.name %] Shelving Location | [% vii.location.name %] Circulate | [% vii.circulate %] Deposit | [% vii.deposit %] Deposit Amount | [% vii.deposit_amount %] Reference | [% vii.ref %] Holdable | [% vii.holdable %] Price | [% vii.price %] Barcode | [% vii.barcode %] Circulation Modifier | [% vii.circ_modifier %] Circulate As MARC Type | [% vii.circ_as_type %] Alert Message | [% vii.alert_message %] Public Note | [% vii.pub_note %] Private Note | [% vii.priv_note %] OPAC Visible | [% vii.opac_visible %] [% END %] $$ ) ; INSERT INTO action_trigger.environment ( event_def, path) VALUES ( 47, 'record') ,( 47, 'record.attributes') ,( 47, 'record.queue') ,( 47, 'record.queue.owner') ; INSERT INTO action_trigger.hook (key, core_type, description, passive) VALUES ( 'container.biblio_record_entry_bucket.csv', 'cbreb', oils_i18n_gettext( 'container.biblio_record_entry_bucket.csv', 'Produce a CSV file representing a book list', 'ath', 'description' ), FALSE ); INSERT INTO action_trigger.reactor (module, description) VALUES ( 'ContainerCSV', oils_i18n_gettext( 'ContainerCSV', 'Facilitates producing a CSV file representing a book list by introducing an "items" variable into the TT environment, sorted as dictated according to user params', 'atr', 'description' ) ); INSERT INTO action_trigger.event_definition ( id, active, owner, name, hook, reactor, validator, template ) VALUES ( 48, TRUE, 1, 'Book List CSV', 'container.biblio_record_entry_bucket.csv', 'ContainerCSV', 'NOOP_True', $$ [%- # target is the book list itself. The 'items' variable does not need to be in # the environment because a special reactor will take care of filling it in. FOR item IN items; bibxml = helpers.unapi_bre(item.target_biblio_record_entry, {flesh => '{mra}'}); title = ""; FOR part IN bibxml.findnodes('//*[@tag="245"]/*[@code="a" or @code="b"]'); title = title _ part.textContent; END; author = bibxml.findnodes('//*[@tag="100"]/*[@code="a"]').textContent; item_type = bibxml.findnodes('//*[local-name()="attributes"]/*[local-name()="field"][@name="item_type"]').getAttribute('coded-value'); pub_date = ""; FOR pdatum IN bibxml.findnodes('//*[@tag="260"]/*[@code="c"]'); IF pub_date ; pub_date = pub_date _ ", " _ pdatum.textContent; ELSE ; pub_date = pdatum.textContent; END; END; helpers.csv_datum(title) %],[% helpers.csv_datum(author) %],[% helpers.csv_datum(pub_date) %],[% helpers.csv_datum(item_type) %],[% FOR note IN item.notes; helpers.csv_datum(note.note); ","; END; "\n"; END -%] $$ ); SELECT SETVAL('authority.control_set_id_seq'::TEXT, 100); SELECT SETVAL('authority.control_set_authority_field_id_seq'::TEXT, 1000); SELECT SETVAL('authority.control_set_bib_field_id_seq'::TEXT, 1000); INSERT INTO authority.control_set (id, name, description) VALUES ( 1, oils_i18n_gettext('1','LoC','acs','name'), oils_i18n_gettext('1','Library of Congress standard authority record control semantics','acs','description') ); -- Entries that need to respect an NFI INSERT INTO authority.control_set_authority_field (id, control_set, main_entry, tag, sf_list, display_sf_list, name, nfi) VALUES (4, 1, NULL, '130', 'adfgklmnoprstvxyz', 'adfgklmnoprstvxyz', oils_i18n_gettext('4','Heading -- Uniform Title','acsaf','name'), '2'), (24, 1, 4, '530', 'adfgiklmnoprstvwxyz4', 'adfgiklmnoprstvxyz', oils_i18n_gettext('24','See Also From Tracing -- Uniform Title','acsaf','name'), '2'), (44, 1, 4, '730', 'adfghklmnoprstvwxyz25', 'adfghklmnoprstvxyz', oils_i18n_gettext('44','Established Heading Linking Entry -- Uniform Title','acsaf','name'), '2'), (64, 1, 4, '430', 'adfgiklmnoprstvwxyz4', 'adfgiklmnoprstvxyz', oils_i18n_gettext('64','See From Tracing -- Uniform Title','acsaf','name'), '2'); INSERT INTO authority.control_set_authority_field (id, control_set, main_entry, tag, sf_list, display_sf_list, name) VALUES -- Main entries (1, 1, NULL, '100', 'abcdfklmnopqrstvxyz', 'abcdefklmnopqrstvxyz', oils_i18n_gettext('1','Heading -- Personal Name','acsaf','name')), (2, 1, NULL, '110', 'abcdfgklmnoprstvxyz', 'abcdefgklmnoprstvxyz', oils_i18n_gettext('2','Heading -- Corporate Name','acsaf','name')), (3, 1, NULL, '111', 'acdefgklnpqstvxyz', 'acdefgklnpqstvxyz', oils_i18n_gettext('3','Heading -- Meeting Name','acsaf','name')), (5, 1, NULL, '150', 'abvxyz', 'abvxyz', oils_i18n_gettext('5','Heading -- Topical Term','acsaf','name')), (6, 1, NULL, '151', 'avxyz', 'avxyz', oils_i18n_gettext('6','Heading -- Geographic Name','acsaf','name')), (7, 1, NULL, '155', 'avxyz', 'avxyz', oils_i18n_gettext('7','Heading -- Genre/Form Term','acsaf','name')), (8, 1, NULL, '180', 'vxyz', 'vxyz', oils_i18n_gettext('8','Heading -- General Subdivision','acsaf','name')), (9, 1, NULL, '181', 'vxyz', 'vxyz', oils_i18n_gettext('9','Heading -- Geographic Subdivision','acsaf','name')), (10, 1, NULL, '182', 'vxyz', 'vxyz', oils_i18n_gettext('10','Heading -- Chronological Subdivision','acsaf','name')), (11, 1, NULL, '185', 'vxyz', 'vxyz', oils_i18n_gettext('11','Heading -- Form Subdivision','acsaf','name')), (12, 1, NULL, '148', 'avxyz', 'avxyz', oils_i18n_gettext('12','Heading -- Chronological Term','acsaf','name')), -- See Also From tracings (21, 1, 1, '500', 'abcdefiklmnopqrstvwxyz4', 'abcdefiklmnopqrstvxyz', oils_i18n_gettext('21','See Also From Tracing -- Personal Name','acsaf','name')), (22, 1, 2, '510', 'abcdefgiklmnoprstvwxyz4', 'abcdefgiklmnoprstvxyz', oils_i18n_gettext('22','See Also From Tracing -- Corporate Name','acsaf','name')), (23, 1, 3, '511', 'acdefgiklnpqstvwxyz4', 'acdefgiklnpqstvxyz', oils_i18n_gettext('23','See Also From Tracing -- Meeting Name','acsaf','name')), (25, 1, 5, '550', 'abivwxyz4', 'abivxyz', oils_i18n_gettext('25','See Also From Tracing -- Topical Term','acsaf','name')), (26, 1, 6, '551', 'aivwxyz4', 'aivxyz', oils_i18n_gettext('26','See Also From Tracing -- Geographic Name','acsaf','name')), (27, 1, 7, '555', 'aivwxyz4', 'aivxyz', oils_i18n_gettext('27','See Also From Tracing -- Genre/Form Term','acsaf','name')), (28, 1, 8, '580', 'ivwxyz4', 'ivxyz', oils_i18n_gettext('28','See Also From Tracing -- General Subdivision','acsaf','name')), (29, 1, 9, '581', 'ivwxyz4', 'ivxyz', oils_i18n_gettext('29','See Also From Tracing -- Geographic Subdivision','acsaf','name')), (30, 1, 10, '582', 'ivwxyz4', 'ivxyz', oils_i18n_gettext('30','See Also From Tracing -- Chronological Subdivision','acsaf','name')), (31, 1, 11, '585', 'ivwxyz4', 'ivxyz', oils_i18n_gettext('31','See Also From Tracing -- Form Subdivision','acsaf','name')), (32, 1, 12, '548', 'aivwxyz4', 'aivxyz', oils_i18n_gettext('32','See Also From Tracing -- Chronological Term','acsaf','name')), -- Linking entries (41, 1, 1, '700', 'abcdefghjklmnopqrstvwxyz25', 'abcdefghjklmnopqrstvxyz', oils_i18n_gettext('41','Established Heading Linking Entry -- Personal Name','acsaf','name')), (42, 1, 2, '710', 'abcdefghklmnoprstvwxyz25', 'abcdefghklmnoprstvxyz', oils_i18n_gettext('42','Established Heading Linking Entry -- Corporate Name','acsaf','name')), (43, 1, 3, '711', 'acdefghklnpqstvwxyz25', 'acdefghklnpqstvxyz', oils_i18n_gettext('43','Established Heading Linking Entry -- Meeting Name','acsaf','name')), (45, 1, 5, '750', 'abvwxyz25', 'abvxyz', oils_i18n_gettext('45','Established Heading Linking Entry -- Topical Term','acsaf','name')), (46, 1, 6, '751', 'avwxyz25', 'avxyz', oils_i18n_gettext('46','Established Heading Linking Entry -- Geographic Name','acsaf','name')), (47, 1, 7, '755', 'avwxyz25', 'avxyz', oils_i18n_gettext('47','Established Heading Linking Entry -- Genre/Form Term','acsaf','name')), (48, 1, 8, '780', 'vwxyz25', 'vxyz', oils_i18n_gettext('48','Subdivision Linking Entry -- General Subdivision','acsaf','name')), (49, 1, 9, '781', 'vwxyz25', 'vxyz', oils_i18n_gettext('49','Subdivision Linking Entry -- Geographic Subdivision','acsaf','name')), (50, 1, 10, '782', 'vwxyz25', 'vxyz', oils_i18n_gettext('50','Subdivision Linking Entry -- Chronological Subdivision','acsaf','name')), (51, 1, 11, '785', 'vwxyz25', 'vxyz', oils_i18n_gettext('51','Subdivision Linking Entry -- Form Subdivision','acsaf','name')), (52, 1, 12, '748', 'avwxyz25', 'avxyz', oils_i18n_gettext('52','Established Heading Linking Entry -- Chronological Term','acsaf','name')), -- See From tracings (61, 1, 1, '400', 'abcdefiklmnopqrstvwxyz4', 'abcdefiklmnopqrstvxyz', oils_i18n_gettext('61','See From Tracing -- Personal Name','acsaf','name')), (62, 1, 2, '410', 'abcdefgiklmnoprstvwxyz4', 'abcdefgiklmnoprstvxyz', oils_i18n_gettext('62','See From Tracing -- Corporate Name','acsaf','name')), (63, 1, 3, '411', 'acdefgiklnpqstvwxyz4', 'acdefgiklnpqstvxyz', oils_i18n_gettext('63','See From Tracing -- Meeting Name','acsaf','name')), (65, 1, 5, '450', 'abivwxyz4', 'abivxyz', oils_i18n_gettext('65','See From Tracing -- Topical Term','acsaf','name')), (66, 1, 6, '451', 'aivwxyz4', 'aivxyz', oils_i18n_gettext('66','See From Tracing -- Geographic Name','acsaf','name')), (67, 1, 7, '455', 'aivwxyz4', 'aivxyz', oils_i18n_gettext('67','See From Tracing -- Genre/Form Term','acsaf','name')), (68, 1, 8, '480', 'ivwxyz4', 'ivxyz', oils_i18n_gettext('68','See From Tracing -- General Subdivision','acsaf','name')), (69, 1, 9, '481', 'ivwxyz4', 'ivxyz', oils_i18n_gettext('69','See From Tracing -- Geographic Subdivision','acsaf','name')), (70, 1, 10, '482', 'ivwxyz4', 'ivxyz', oils_i18n_gettext('70','See From Tracing -- Chronological Subdivision','acsaf','name')), (71, 1, 11, '485', 'ivwxyz4', 'ivxyz', oils_i18n_gettext('71','See From Tracing -- Form Subdivision','acsaf','name')), (72, 1, 12, '448', 'aivwxyz4', 'aivxyz', oils_i18n_gettext('72','See From Tracing -- Chronological Term','acsaf','name')); -- No linking on 4xx fields for LOC UPDATE authority.control_set_authority_field SET linking_subfield = '0' WHERE tag LIKE ANY (ARRAY['5%','7%']); -- Set the default joiner for subject-ish authority fields UPDATE authority.control_set_authority_field SET joiner = ' -- ' WHERE tag LIKE ANY (ARRAY['_4_','_5_','_8_']); INSERT INTO authority.browse_axis (code,name,description,sorter) VALUES ('title',oils_i18n_gettext('title','Title','aba','name'),oils_i18n_gettext('title','Title axis','aba','description'),'titlesort'), ('author',oils_i18n_gettext('author','Author','aba','name'),oils_i18n_gettext('author','Author axis','aba','description'),'titlesort'), ('subject',oils_i18n_gettext('subject','Subject','aba','name'),oils_i18n_gettext('subject','Subject axis','aba','description'),'titlesort'), ('topic',oils_i18n_gettext('topic','Topic','aba','name'),oils_i18n_gettext('topic','Topic Subject axis','aba','description'),'titlesort'); INSERT INTO authority.browse_axis_authority_field_map (axis,field) VALUES ('author', 1 ), ('author', 2 ), ('author', 3 ), ('title', 4 ), ('topic', 5 ), ('subject', 5 ), ('subject', 6 ), ('subject', 7 ), ('subject', 12); INSERT INTO authority.control_set_bib_field (tag, authority_field) SELECT '100', id FROM authority.control_set_authority_field WHERE tag IN ('100') UNION SELECT '600', id FROM authority.control_set_authority_field WHERE tag IN ('100','180','181','182','185') UNION SELECT '700', id FROM authority.control_set_authority_field WHERE tag IN ('100') UNION SELECT '800', id FROM authority.control_set_authority_field WHERE tag IN ('100') UNION SELECT '110', id FROM authority.control_set_authority_field WHERE tag IN ('110') UNION SELECT '610', id FROM authority.control_set_authority_field WHERE tag IN ('110') UNION SELECT '710', id FROM authority.control_set_authority_field WHERE tag IN ('110') UNION SELECT '810', id FROM authority.control_set_authority_field WHERE tag IN ('110') UNION SELECT '111', id FROM authority.control_set_authority_field WHERE tag IN ('111') UNION SELECT '611', id FROM authority.control_set_authority_field WHERE tag IN ('111') UNION SELECT '711', id FROM authority.control_set_authority_field WHERE tag IN ('111') UNION SELECT '811', id FROM authority.control_set_authority_field WHERE tag IN ('111') UNION SELECT '130', id FROM authority.control_set_authority_field WHERE tag IN ('130') UNION SELECT '240', id FROM authority.control_set_authority_field WHERE tag IN ('130') UNION SELECT '630', id FROM authority.control_set_authority_field WHERE tag IN ('130') UNION SELECT '730', id FROM authority.control_set_authority_field WHERE tag IN ('130') UNION SELECT '830', id FROM authority.control_set_authority_field WHERE tag IN ('130') UNION SELECT '648', id FROM authority.control_set_authority_field WHERE tag IN ('148') UNION SELECT '650', id FROM authority.control_set_authority_field WHERE tag IN ('150','180','181','182','185') UNION SELECT '651', id FROM authority.control_set_authority_field WHERE tag IN ('151','180','181','182','185') UNION SELECT '655', id FROM authority.control_set_authority_field WHERE tag IN ('155','180','181','182','185') ; -- Map between authority controlled bib fields and stock indexing metabib fields INSERT INTO authority.control_set_bib_field_metabib_field_map (bib_field, metabib_field) SELECT DISTINCT b.id AS bib_field, m.id AS metabib_field FROM authority.control_set_bib_field b JOIN authority.control_set_authority_field a ON (b.authority_field = a.id), config.metabib_field m WHERE a.tag = '100' AND m.name = 'personal' UNION SELECT DISTINCT b.id AS bib_field, m.id AS metabib_field FROM authority.control_set_bib_field b JOIN authority.control_set_authority_field a ON (b.authority_field = a.id), config.metabib_field m WHERE a.tag = '110' AND m.name = 'corporate' UNION SELECT DISTINCT b.id AS bib_field, m.id AS metabib_field FROM authority.control_set_bib_field b JOIN authority.control_set_authority_field a ON (b.authority_field = a.id), config.metabib_field m WHERE a.tag = '111' AND m.name = 'conference' UNION SELECT DISTINCT b.id AS bib_field, m.id AS metabib_field FROM authority.control_set_bib_field b JOIN authority.control_set_authority_field a ON (b.authority_field = a.id), config.metabib_field m WHERE a.tag = '130' AND m.name = 'uniform' UNION SELECT DISTINCT b.id AS bib_field, m.id AS metabib_field FROM authority.control_set_bib_field b JOIN authority.control_set_authority_field a ON (b.authority_field = a.id), config.metabib_field m WHERE a.tag = '148' AND m.name = 'temporal_browse' UNION SELECT DISTINCT b.id AS bib_field, m.id AS metabib_field FROM authority.control_set_bib_field b JOIN authority.control_set_authority_field a ON (b.authority_field = a.id), config.metabib_field m WHERE a.tag = '150' AND m.name = 'topic_browse' UNION SELECT DISTINCT b.id AS bib_field, m.id AS metabib_field FROM authority.control_set_bib_field b JOIN authority.control_set_authority_field a ON (b.authority_field = a.id), config.metabib_field m WHERE a.tag = '151' AND m.name = 'geographic_browse' UNION SELECT DISTINCT b.id AS bib_field, m.id AS metabib_field FROM authority.control_set_bib_field b JOIN authority.control_set_authority_field a ON (b.authority_field = a.id), config.metabib_field m WHERE a.tag = '155' AND m.name = 'genre' -- Just in case... ; INSERT INTO action_trigger.hook ( key, core_type, description, passive ) VALUES ( 'reservation.available', 'bresv', 'A reservation is available for pickup', false ); INSERT INTO action_trigger.validator ( module, description ) VALUES ( 'ReservationIsAvailable', 'Checked that a reserved resource is available for checkout' ); INSERT INTO container.biblio_record_entry_bucket_type (code, label) VALUES ( 'vandelay_queue', oils_i18n_gettext('vandelay_queue', 'Vandelay Queue', 'cbrebt', 'label') ); INSERT INTO config.usr_setting_type (name,grp,opac_visible,label,description,datatype,fm_class) VALUES ( 'opac.default_sms_carrier', 'sms', TRUE, oils_i18n_gettext( 'opac.default_sms_carrier', 'Default SMS/Text Carrier', 'cust', 'label' ), oils_i18n_gettext( 'opac.default_sms_carrier', 'Default SMS/Text Carrier', 'cust', 'description' ), 'link', 'csc' ); INSERT INTO config.usr_setting_type (name,grp,opac_visible,label,description,datatype) VALUES ( 'opac.default_sms_notify', 'sms', TRUE, oils_i18n_gettext( 'opac.default_sms_notify', 'Default SMS/Text Number', 'cust', 'label' ), oils_i18n_gettext( 'opac.default_sms_notify', 'Default SMS/Text Number', 'cust', 'description' ), 'string' ); INSERT INTO config.usr_setting_type (name,grp,opac_visible,label,description,datatype) VALUES ( 'opac.default_phone', 'opac', TRUE, oils_i18n_gettext( 'opac.default_phone', 'Default Phone Number', 'cust', 'label' ), oils_i18n_gettext( 'opac.default_phone', 'Default Phone Number', 'cust', 'description' ), 'string' ); INSERT INTO config.usr_setting_type (name,grp,opac_visible,label,description,datatype) VALUES ( 'ui.grid_columns.circ.hold_pull_list', 'gui', FALSE, oils_i18n_gettext( 'ui.grid_columns.circ.hold_pull_list', 'Hold Pull List', 'cust', 'label' ), oils_i18n_gettext( 'ui.grid_columns.circ.hold_pull_list', 'Hold Pull List Saved Column Settings', 'cust', 'description' ), 'string' ), ( 'ui.grid_columns.actor.user.event_log', 'gui', FALSE, oils_i18n_gettext( 'ui.grid_columns.actor.user.event_log', 'User Event Log', 'cust', 'label' ), oils_i18n_gettext( 'ui.grid_columns.actor.user.event_log', 'User Event Log Saved Column Settings', 'cust', 'description' ), 'string' ), ( 'ui.grid_columns.conify.config.circ_matrix_matchpoint', 'gui', FALSE, oils_i18n_gettext( 'ui.grid_columns.conify.config.circ_matrix_matchpoint', 'Circulation Policy Configuration', 'cust', 'label' ), oils_i18n_gettext( 'ui.grid_columns.conify.config.circ_matrix_matchpoint', 'Circulation Policy Configuration Column Settings', 'cust', 'description' ), 'string' ) ; SELECT setval( 'config.sms_carrier_id_seq', 1000 ); INSERT INTO config.sms_carrier VALUES -- Testing ( 1, oils_i18n_gettext( 1, 'Local', 'csc', 'region' ), oils_i18n_gettext( 1, 'Test Carrier', 'csc', 'name' ), 'opensrf+$number@localhost', FALSE ), -- Canada & USA ( 2, oils_i18n_gettext( 2, 'Canada & USA', 'csc', 'region' ), oils_i18n_gettext( 2, 'Rogers Wireless', 'csc', 'name' ), '$number@pcs.rogers.com', TRUE ), ( 3, oils_i18n_gettext( 3, 'Canada & USA', 'csc', 'region' ), oils_i18n_gettext( 3, 'Rogers Wireless (Alternate)', 'csc', 'name' ), '1$number@mms.rogers.com', TRUE ), ( 4, oils_i18n_gettext( 4, 'Canada & USA', 'csc', 'region' ), oils_i18n_gettext( 4, 'Telus Mobility', 'csc', 'name' ), '$number@msg.telus.com', TRUE ), -- Canada ( 5, oils_i18n_gettext( 5, 'Canada', 'csc', 'region' ), oils_i18n_gettext( 5, 'Koodo Mobile', 'csc', 'name' ), '$number@msg.telus.com', TRUE ), ( 6, oils_i18n_gettext( 6, 'Canada', 'csc', 'region' ), oils_i18n_gettext( 6, 'Fido', 'csc', 'name' ), '$number@fido.ca', TRUE ), ( 7, oils_i18n_gettext( 7, 'Canada', 'csc', 'region' ), oils_i18n_gettext( 7, 'Bell Mobility & Solo Mobile', 'csc', 'name' ), '$number@txt.bell.ca', TRUE ), ( 8, oils_i18n_gettext( 8, 'Canada', 'csc', 'region' ), oils_i18n_gettext( 8, 'Bell Mobility & Solo Mobile (Alternate)', 'csc', 'name' ), '$number@txt.bellmobility.ca', TRUE ), ( 9, oils_i18n_gettext( 9, 'Canada', 'csc', 'region' ), oils_i18n_gettext( 9, 'Aliant', 'csc', 'name' ), '$number@sms.wirefree.informe.ca', TRUE ), ( 10, oils_i18n_gettext( 10, 'Canada', 'csc', 'region' ), oils_i18n_gettext( 10, 'PC Telecom', 'csc', 'name' ), '$number@mobiletxt.ca', TRUE ), ( 11, oils_i18n_gettext( 11, 'Canada', 'csc', 'region' ), oils_i18n_gettext( 11, 'SaskTel', 'csc', 'name' ), '$number@sms.sasktel.com', TRUE ), ( 12, oils_i18n_gettext( 12, 'Canada', 'csc', 'region' ), oils_i18n_gettext( 12, 'MTS Mobility', 'csc', 'name' ), '$number@text.mtsmobility.com', TRUE ), ( 13, oils_i18n_gettext( 13, 'Canada', 'csc', 'region' ), oils_i18n_gettext( 13, 'Virgin Mobile', 'csc', 'name' ), '$number@vmobile.ca', TRUE ), -- International ( 14, oils_i18n_gettext( 14, 'International', 'csc', 'region' ), oils_i18n_gettext( 14, 'Iridium', 'csc', 'name' ), '$number@msg.iridium.com', TRUE ), ( 15, oils_i18n_gettext( 15, 'International', 'csc', 'region' ), oils_i18n_gettext( 15, 'Globalstar', 'csc', 'name' ), '$number@msg.globalstarusa.com', TRUE ), ( 16, oils_i18n_gettext( 16, 'International', 'csc', 'region' ), oils_i18n_gettext( 16, 'Bulletin.net', 'csc', 'name' ), '$number@bulletinmessenger.net', -- International Formatted number TRUE ), ( 17, oils_i18n_gettext( 17, 'International', 'csc', 'region' ), oils_i18n_gettext( 17, 'Panacea Mobile', 'csc', 'name' ), '$number@api.panaceamobile.com', TRUE ), -- USA ( 18, oils_i18n_gettext( 18, 'USA', 'csc', 'region' ), oils_i18n_gettext( 18, 'C Beyond', 'csc', 'name' ), '$number@cbeyond.sprintpcs.com', TRUE ), ( 19, oils_i18n_gettext( 19, 'Alaska, USA', 'csc', 'region' ), oils_i18n_gettext( 19, 'General Communications, Inc.', 'csc', 'name' ), '$number@mobile.gci.net', TRUE ), ( 20, oils_i18n_gettext( 20, 'California, USA', 'csc', 'region' ), oils_i18n_gettext( 20, 'Golden State Cellular', 'csc', 'name' ), '$number@gscsms.com', TRUE ), ( 21, oils_i18n_gettext( 21, 'Cincinnati, Ohio, USA', 'csc', 'region' ), oils_i18n_gettext( 21, 'Cincinnati Bell', 'csc', 'name' ), '$number@gocbw.com', TRUE ), ( 22, oils_i18n_gettext( 22, 'Hawaii, USA', 'csc', 'region' ), oils_i18n_gettext( 22, 'Hawaiian Telcom Wireless', 'csc', 'name' ), '$number@hawaii.sprintpcs.com', TRUE ), ( 23, oils_i18n_gettext( 23, 'Midwest, USA', 'csc', 'region' ), oils_i18n_gettext( 23, 'i wireless (T-Mobile)', 'csc', 'name' ), '$number.iws@iwspcs.net', TRUE ), ( 24, oils_i18n_gettext( 24, 'USA', 'csc', 'region' ), oils_i18n_gettext( 24, 'i-wireless (Sprint PCS)', 'csc', 'name' ), '$number@iwirelesshometext.com', TRUE ), ( 25, oils_i18n_gettext( 25, 'USA', 'csc', 'region' ), oils_i18n_gettext( 25, 'MetroPCS', 'csc', 'name' ), '$number@mymetropcs.com', TRUE ), ( 26, oils_i18n_gettext( 26, 'USA', 'csc', 'region' ), oils_i18n_gettext( 26, 'Kajeet', 'csc', 'name' ), '$number@mobile.kajeet.net', TRUE ), ( 27, oils_i18n_gettext( 27, 'USA', 'csc', 'region' ), oils_i18n_gettext( 27, 'Element Mobile', 'csc', 'name' ), '$number@SMS.elementmobile.net', TRUE ), ( 28, oils_i18n_gettext( 28, 'USA', 'csc', 'region' ), oils_i18n_gettext( 28, 'Esendex', 'csc', 'name' ), '$number@echoemail.net', TRUE ), ( 29, oils_i18n_gettext( 29, 'USA', 'csc', 'region' ), oils_i18n_gettext( 29, 'Boost Mobile', 'csc', 'name' ), '$number@myboostmobile.com', TRUE ), ( 30, oils_i18n_gettext( 30, 'USA', 'csc', 'region' ), oils_i18n_gettext( 30, 'BellSouth', 'csc', 'name' ), '$number@bellsouth.com', TRUE ), ( 31, oils_i18n_gettext( 31, 'USA', 'csc', 'region' ), oils_i18n_gettext( 31, 'Bluegrass Cellular', 'csc', 'name' ), '$number@sms.bluecell.com', TRUE ), ( 32, oils_i18n_gettext( 32, 'USA', 'csc', 'region' ), oils_i18n_gettext( 32, 'AT&T Enterprise Paging', 'csc', 'name' ), '$number@page.att.net', TRUE ), ( 33, oils_i18n_gettext( 33, 'USA', 'csc', 'region' ), oils_i18n_gettext( 33, 'AT&T Mobility/Wireless', 'csc', 'name' ), '$number@txt.att.net', TRUE ), ( 34, oils_i18n_gettext( 34, 'USA', 'csc', 'region' ), oils_i18n_gettext( 34, 'AT&T Global Smart Messaging Suite', 'csc', 'name' ), '$number@sms.smartmessagingsuite.com', TRUE ), ( 35, oils_i18n_gettext( 35, 'USA', 'csc', 'region' ), oils_i18n_gettext( 35, 'Alltel (Allied Wireless)', 'csc', 'name' ), '$number@sms.alltelwireless.com', TRUE ), ( 36, oils_i18n_gettext( 36, 'USA', 'csc', 'region' ), oils_i18n_gettext( 36, 'Alaska Communications', 'csc', 'name' ), '$number@msg.acsalaska.com', TRUE ), ( 37, oils_i18n_gettext( 37, 'USA', 'csc', 'region' ), oils_i18n_gettext( 37, 'Ameritech', 'csc', 'name' ), '$number@paging.acswireless.com', TRUE ), ( 38, oils_i18n_gettext( 38, 'USA', 'csc', 'region' ), oils_i18n_gettext( 38, 'Cingular (GoPhone prepaid)', 'csc', 'name' ), '$number@cingulartext.com', TRUE ), ( 39, oils_i18n_gettext( 39, 'USA', 'csc', 'region' ), oils_i18n_gettext( 39, 'Cingular (Postpaid)', 'csc', 'name' ), '$number@cingular.com', TRUE ), ( 40, oils_i18n_gettext( 40, 'USA', 'csc', 'region' ), oils_i18n_gettext( 40, 'Cellular One (Dobson) / O2 / Orange', 'csc', 'name' ), '$number@mobile.celloneusa.com', TRUE ), ( 41, oils_i18n_gettext( 41, 'USA', 'csc', 'region' ), oils_i18n_gettext( 41, 'Cellular South', 'csc', 'name' ), '$number@csouth1.com', TRUE ), ( 42, oils_i18n_gettext( 42, 'USA', 'csc', 'region' ), oils_i18n_gettext( 42, 'Cellcom', 'csc', 'name' ), '$number@cellcom.quiktxt.com', TRUE ), ( 43, oils_i18n_gettext( 43, 'USA', 'csc', 'region' ), oils_i18n_gettext( 43, 'Chariton Valley Wireless', 'csc', 'name' ), '$number@sms.cvalley.net', TRUE ), ( 44, oils_i18n_gettext( 44, 'USA', 'csc', 'region' ), oils_i18n_gettext( 44, 'Cricket', 'csc', 'name' ), '$number@sms.mycricket.com', TRUE ), ( 45, oils_i18n_gettext( 45, 'USA', 'csc', 'region' ), oils_i18n_gettext( 45, 'Cleartalk Wireless', 'csc', 'name' ), '$number@sms.cleartalk.us', TRUE ), ( 46, oils_i18n_gettext( 46, 'USA', 'csc', 'region' ), oils_i18n_gettext( 46, 'Edge Wireless', 'csc', 'name' ), '$number@sms.edgewireless.com', TRUE ), ( 47, oils_i18n_gettext( 47, 'USA', 'csc', 'region' ), oils_i18n_gettext( 47, 'Syringa Wireless', 'csc', 'name' ), '$number@rinasms.com', TRUE ), ( 48, oils_i18n_gettext( 48, 'USA', 'csc', 'region' ), oils_i18n_gettext( 48, 'T-Mobile', 'csc', 'name' ), '$number@tmomail.net', TRUE ), ( 49, oils_i18n_gettext( 49, 'USA', 'csc', 'region' ), oils_i18n_gettext( 49, 'Straight Talk / PagePlus Cellular', 'csc', 'name' ), '$number@vtext.com', TRUE ), ( 50, oils_i18n_gettext( 50, 'USA', 'csc', 'region' ), oils_i18n_gettext( 50, 'South Central Communications', 'csc', 'name' ), '$number@rinasms.com', TRUE ), ( 51, oils_i18n_gettext( 51, 'USA', 'csc', 'region' ), oils_i18n_gettext( 51, 'Simple Mobile', 'csc', 'name' ), '$number@smtext.com', TRUE ), ( 52, oils_i18n_gettext( 52, 'USA', 'csc', 'region' ), oils_i18n_gettext( 52, 'Sprint (PCS)', 'csc', 'name' ), '$number@messaging.sprintpcs.com', TRUE ), ( 53, oils_i18n_gettext( 53, 'USA', 'csc', 'region' ), oils_i18n_gettext( 53, 'Nextel', 'csc', 'name' ), '$number@messaging.nextel.com', TRUE ), ( 54, oils_i18n_gettext( 54, 'USA', 'csc', 'region' ), oils_i18n_gettext( 54, 'Pioneer Cellular', 'csc', 'name' ), '$number@zsend.com', -- nine digit number TRUE ), ( 55, oils_i18n_gettext( 55, 'USA', 'csc', 'region' ), oils_i18n_gettext( 55, 'Qwest Wireless', 'csc', 'name' ), '$number@qwestmp.com', TRUE ), ( 56, oils_i18n_gettext( 56, 'USA', 'csc', 'region' ), oils_i18n_gettext( 56, 'US Cellular', 'csc', 'name' ), '$number@email.uscc.net', TRUE ), ( 57, oils_i18n_gettext( 57, 'USA', 'csc', 'region' ), oils_i18n_gettext( 57, 'Unicel', 'csc', 'name' ), '$number@utext.com', TRUE ), ( 58, oils_i18n_gettext( 58, 'USA', 'csc', 'region' ), oils_i18n_gettext( 58, 'Teleflip', 'csc', 'name' ), '$number@teleflip.com', TRUE ), ( 59, oils_i18n_gettext( 59, 'USA', 'csc', 'region' ), oils_i18n_gettext( 59, 'Virgin Mobile', 'csc', 'name' ), '$number@vmobl.com', TRUE ), ( 60, oils_i18n_gettext( 60, 'USA', 'csc', 'region' ), oils_i18n_gettext( 60, 'Verizon Wireless', 'csc', 'name' ), '$number@vtext.com', TRUE ), ( 61, oils_i18n_gettext( 61, 'USA', 'csc', 'region' ), oils_i18n_gettext( 61, 'USA Mobility', 'csc', 'name' ), '$number@usamobility.net', TRUE ), ( 62, oils_i18n_gettext( 62, 'USA', 'csc', 'region' ), oils_i18n_gettext( 62, 'Viaero', 'csc', 'name' ), '$number@viaerosms.com', TRUE ), ( 63, oils_i18n_gettext( 63, 'USA', 'csc', 'region' ), oils_i18n_gettext( 63, 'TracFone', 'csc', 'name' ), '$number@mmst5.tracfone.com', TRUE ), ( 64, oils_i18n_gettext( 64, 'USA', 'csc', 'region' ), oils_i18n_gettext( 64, 'Centennial Wireless', 'csc', 'name' ), '$number@cwemail.com', TRUE ), -- South Korea and USA ( 65, oils_i18n_gettext( 65, 'South Korea and USA', 'csc', 'region' ), oils_i18n_gettext( 65, 'Helio', 'csc', 'name' ), '$number@myhelio.com', TRUE ), -- Republic Wireless and Google Fi ( 66, oils_i18n_gettext( 66, 'USA', 'csc', 'region' ), oils_i18n_gettext( 66, 'Republic Wireless (must enable on device)', 'csc', 'name' ), '$number@text.republicwireless.com', TRUE ), ( 67, oils_i18n_gettext( 67, 'USA', 'csc', 'region' ), oils_i18n_gettext( 67, 'Google Fi', 'csc', 'name' ), '$number@msg.fi.google.com', TRUE ) ; INSERT INTO permission.grp_perm_map (grp, perm, depth, grantable) SELECT pgt.id, perm.id, aout.depth, TRUE FROM permission.grp_tree pgt, permission.perm_list perm, actor.org_unit_type aout WHERE pgt.name = 'Global Administrator' AND aout.name = 'Consortium' AND perm.code = 'ADMIN_SMS_CARRIER'; INSERT INTO action_trigger.reactor ( module, description ) VALUES ( 'SendSMS', 'Send an SMS text message based on a user-defined template' ); INSERT INTO action_trigger.event_definition ( active, owner, name, hook, validator, reactor, cleanup_success, delay, delay_field, group_field, template ) VALUES ( true, 1, -- admin 'Hold Ready for Pickup SMS Notification', 'hold.available', 'HoldIsAvailable', 'SendSMS', 'CreateHoldNotification', '00:30:00', 'shelf_time', 'sms_notify', '[%- USE date -%] [%- user = target.0.usr -%] From: [%- params.sender_email || default_sender %] Date: [%- date.format(date.now, ''%a, %d %b %Y %T -0000'', gmt => 1) %] To: [%- params.recipient_email || helpers.get_sms_gateway_email(target.0.sms_carrier,target.0.sms_notify) %] Subject: [% target.size %] hold(s) ready Auto-Submitted: auto-generated [% FOR hold IN target %][%- bibxml = helpers.xml_doc( hold.current_copy.call_number.record.marc ); title = ""; FOR part IN bibxml.findnodes(''//*[@tag="245"]/*[@code="a"]''); title = title _ part.textContent; END; author = bibxml.findnodes(''//*[@tag="100"]/*[@code="a"]'').textContent; %][% hold.usr.first_given_name %]:[% title %] @ [% hold.pickup_lib.name %] [% END %] ' ); INSERT INTO action_trigger.environment ( event_def, path ) VALUES ( currval('action_trigger.event_definition_id_seq'), 'current_copy.call_number.record.simple_record' ), ( currval('action_trigger.event_definition_id_seq'), 'usr' ), ( currval('action_trigger.event_definition_id_seq'), 'pickup_lib.billing_address' ); INSERT INTO action_trigger.event_params (event_def, param, value) VALUES (currval('action_trigger.event_definition_id_seq'), 'check_sms_notify', 1); INSERT INTO action_trigger.hook( key, core_type, description, passive ) VALUES ( 'acn.format.sms_text', 'acn', oils_i18n_gettext( 'acn.format.sms_text', 'A text message has been requested for a call number.', 'ath', 'description' ), FALSE ); INSERT INTO action_trigger.event_definition ( active, owner, name, hook, validator, reactor, template ) VALUES ( true, 1, -- admin 'SMS Call Number', 'acn.format.sms_text', 'NOOP_True', 'SendSMS', '[%- USE date -%] From: [%- params.sender_email || default_sender %] To: [%- params.recipient_email || helpers.get_sms_gateway_email(user_data.sms_carrier,user_data.sms_notify) %] Date: [%- date.format(date.now, ''%a, %d %b %Y %T -0000'', gmt => 1) %] Subject: Call Number Auto-Submitted: auto-generated [%- bibxml = helpers.xml_doc( target.record.marc ); title = ""; FOR part IN bibxml.findnodes(''//*[@tag="245"]/*[@code="a" or @code="b"]''); title = title _ part.textContent; END; author = bibxml.findnodes(''//*[@tag="100"]/*[@code="a"]'').textContent; %] Call Number: [% target.label %] Location: [% helpers.get_most_populous_location( target.id ).name %] Library: [% target.owning_lib.name %] [%- IF title %] Title: [% title %] [%- END %] [%- IF author %] Author: [% author %] [%- END %] ' ); INSERT INTO action_trigger.environment ( event_def, path ) VALUES ( currval('action_trigger.event_definition_id_seq'), 'record.simple_record' ), ( currval('action_trigger.event_definition_id_seq'), 'owning_lib.billing_address' ); INSERT INTO vandelay.merge_profile (id, owner, name, replace_spec, update_bib_source) VALUES (1, 1, oils_i18n_gettext(1, 'Match-Only Merge', 'vmp', 'name'), '901c', false); INSERT INTO vandelay.merge_profile (id, owner, name, preserve_spec, update_bib_source) VALUES (2, 1, oils_i18n_gettext(2, 'Full Overlay', 'vmp', 'name'), '901c', true); SELECT SETVAL('vandelay.merge_profile_id_seq'::TEXT, 100); -- 3 Day Courtesy Notice by SMS INSERT INTO action_trigger.event_definition (id, active, owner, name, hook, validator, reactor, delay, max_delay, delay_field, group_field, template) VALUES (54, FALSE, 1, '3 Day Courtesy Notice by SMS', 'checkout.due', 'CircIsOpen', 'SendSMS', '-3 days', '-2 days', 'due_date', 'usr', $$ [%- USE date -%] [%- user = target.0.usr -%] [%- homelib = user.home_ou -%] [%- sms_number = helpers.get_user_setting(user.id, 'opac.default_sms_notify') -%] [%- sms_carrier = helpers.get_user_setting(user.id, 'opac.default_sms_carrier') -%] From: [%- helpers.get_org_setting(homelib.id, 'org.bounced_emails') || homelib.email || params.sender_email || default_sender %] To: [%- helpers.get_sms_gateway_email(sms_carrier,sms_number) %] Subject: Library Materials Due Soon You have items due soon: [% FOR circ IN target %] [%- copy_details = helpers.get_copy_bib_basics(circ.target_copy.id) -%] [% copy_details.title FILTER ucfirst %] by [% copy_details.author FILTER ucfirst %] due on [% date.format(helpers.format_date(circ.due_date), '%m-%d-%Y') %] [% END %] $$); INSERT INTO action_trigger.environment (event_def, path) VALUES (54, 'circ_lib.billing_address'), (54, 'target_copy.call_number'), (54, 'usr'), (54, 'usr.home_ou'); -- user activity seed data -- INSERT INTO config.usr_activity_type (id, ewho, ewhat, ehow, egroup, label) VALUES -- authen/authz actions -- note: "opensrf" is the default ingress/ehow (1, NULL, 'login', 'opensrf', 'authen', oils_i18n_gettext(1 , 'Login via opensrf', 'cuat', 'label')) ,(2, NULL, 'login', 'srfsh', 'authen', oils_i18n_gettext(2 , 'Login via srfsh', 'cuat', 'label')) ,(3, NULL, 'login', 'gateway-v1', 'authen', oils_i18n_gettext(3 , 'Login via gateway-v1', 'cuat', 'label')) ,(4, NULL, 'login', 'translator-v1','authen', oils_i18n_gettext(4 , 'Login via translator-v1', 'cuat', 'label')) ,(5, NULL, 'login', 'xmlrpc', 'authen', oils_i18n_gettext(5 , 'Login via xmlrpc', 'cuat', 'label')) ,(6, NULL, 'login', 'remoteauth', 'authen', oils_i18n_gettext(6 , 'Login via remoteauth', 'cuat', 'label')) ,(7, NULL, 'login', 'sip2', 'authen', oils_i18n_gettext(7 , 'SIP2 Proxy Login', 'cuat', 'label')) ,(8, NULL, 'login', 'apache', 'authen', oils_i18n_gettext(8 , 'Login via Apache module', 'cuat', 'label')) ,(9, NULL, 'verify', 'opensrf', 'authz', oils_i18n_gettext(9 , 'Verification via opensrf', 'cuat', 'label')) ,(10, NULL, 'verify', 'srfsh', 'authz', oils_i18n_gettext(10, 'Verification via srfsh', 'cuat', 'label')) ,(11, NULL, 'verify', 'gateway-v1', 'authz', oils_i18n_gettext(11, 'Verification via gateway-v1', 'cuat', 'label')) ,(12, NULL, 'verify', 'translator-v1','authz', oils_i18n_gettext(12, 'Verification via translator-v1', 'cuat', 'label')) ,(13, NULL, 'verify', 'xmlrpc', 'authz', oils_i18n_gettext(13, 'Verification via xmlrpc', 'cuat', 'label')) ,(14, NULL, 'verify', 'remoteauth', 'authz', oils_i18n_gettext(14, 'Verification via remoteauth', 'cuat', 'label')) ,(15, NULL, 'verify', 'sip2', 'authz', oils_i18n_gettext(15, 'SIP2 User Verification', 'cuat', 'label')) -- authen/authz actions w/ known uses of "who" ,(16, 'opac', 'login', 'gateway-v1', 'authen', oils_i18n_gettext(16, 'OPAC Login (jspac)', 'cuat', 'label')) ,(17, 'opac', 'login', 'apache', 'authen', oils_i18n_gettext(17, 'OPAC Login (tpac)', 'cuat', 'label')) ,(18, 'staffclient', 'login', 'gateway-v1', 'authen', oils_i18n_gettext(18, 'Staff Client Login', 'cuat', 'label')) ,(19, 'selfcheck', 'login', 'translator-v1','authen', oils_i18n_gettext(19, 'Self-Check Proxy Login', 'cuat', 'label')) ,(20, 'ums', 'login', 'xmlrpc', 'authen', oils_i18n_gettext(20, 'Unique Mgt Login', 'cuat', 'label')) ,(21, 'authproxy', 'login', 'apache', 'authen', oils_i18n_gettext(21, 'Apache Auth Proxy Login', 'cuat', 'label')) ,(22, 'libraryelf', 'login', 'xmlrpc', 'authz', oils_i18n_gettext(22, 'LibraryElf Login', 'cuat', 'label')) ,(23, 'selfcheck', 'verify', 'translator-v1','authz', oils_i18n_gettext(23, 'Self-Check User Verification', 'cuat', 'label')) ,(24, 'ezproxy', 'verify', 'remoteauth', 'authz', oils_i18n_gettext(24, 'EZProxy Verification', 'cuat', 'label')) -- ... ; -- reserve the first 1000 slots SELECT SETVAL('config.usr_activity_type_id_seq'::TEXT, 1000); INSERT INTO config.org_unit_setting_type (name, label, description, grp, datatype) VALUES ( 'circ.fines.charge_when_closed', oils_i18n_gettext( 'circ.fines.charge_when_closed', 'Charge fines on overdue circulations when closed', 'coust', 'label' ), oils_i18n_gettext( 'circ.fines.charge_when_closed', 'Normally, fines are not charged when a library is closed. When set to True, fines will be charged during scheduled closings and normal weekly closed days.', 'coust', 'description' ), 'circ', 'bool' ); INSERT INTO config.org_unit_setting_type (name, label, description, grp, datatype) VALUES ( 'circ.patron.usr_activity_retrieve.max', oils_i18n_gettext( 'circ.patron.usr_activity_retrieve.max', 'Max user activity entries to retrieve (staff client)', 'coust', 'label' ), oils_i18n_gettext( 'circ.patron.usr_activity_retrieve.max', 'Sets the maxinum number of recent user activity entries to retrieve for display in the staff client. 0 means show none, -1 means show all. Default is 1.', 'coust', 'description' ), 'gui', 'integer' ); -- circ export csv export -- INSERT INTO action_trigger.hook (key, core_type, description, passive) VALUES ( 'circ.format.history.csv', 'auch', oils_i18n_gettext( 'circ.format.history.csv', 'Produce CSV of circulation history', 'ath', 'description' ), FALSE ); INSERT INTO action_trigger.event_definition ( active, owner, name, hook, reactor, validator, group_field, template) VALUES ( TRUE, 1, 'Circ History CSV', 'circ.format.history.csv', 'ProcessTemplate', 'NOOP_True', 'usr', $$ Title,Author,Call Number,Barcode,Format [%- FOR circ IN target; bibxml = helpers.unapi_bre(circ.target_copy.call_number.record, {flesh => '{mra}'}); title = ""; FOR part IN bibxml.findnodes('//*[@tag="245"]/*[@code="a" or @code="b"]'); title = title _ part.textContent; END; author = bibxml.findnodes('//*[@tag="100"]/*[@code="a"]').textContent; item_type = bibxml.findnodes('//*[local-name()="attributes"]/*[local-name()="field"][@name="item_type"]').getAttribute('coded-value') %] [%- helpers.csv_datum(title) -%], [%- helpers.csv_datum(author) -%], [%- helpers.csv_datum(circ.target_copy.call_number.label) -%], [%- helpers.csv_datum(circ.target_copy.barcode) -%], [%- helpers.csv_datum(item_type) %] [%- END -%] $$ ); INSERT INTO action_trigger.environment (event_def, path) VALUES ( currval('action_trigger.event_definition_id_seq'), 'target_copy.call_number' ); INSERT INTO actor.toolbar(id,org,label,layout) VALUES ( 1, 1, oils_i18n_gettext(1, 'circ', 'atb', 'label'), '["circ_checkout","circ_checkin","toolbarseparator.1","search_opac","copy_status","toolbarseparator.2","patron_search","patron_register","toolbarspacer.3","hotkeys_toggle"]' ), ( 2, 1, oils_i18n_gettext(2, 'cat', 'atb', 'label'), '["circ_checkin","toolbarseparator.1","search_opac","copy_status","toolbarseparator.2","create_marc","authority_manage","retrieve_last_record","toolbarspacer.3","hotkeys_toggle"]' ); INSERT INTO config.global_flag (name, enabled, label) VALUES ( 'opac.org_unit.non_inherited_visibility', FALSE, oils_i18n_gettext( 'opac.org_unit.non_inherited_visibility', 'Org Units Do Not Inherit Visibility', 'cgf', 'label' ) ); INSERT INTO config.org_unit_setting_type ( name, label, description, datatype, grp, update_perm ) VALUES ( 'ui.hide_copy_editor_fields', oils_i18n_gettext( 'ui.hide_copy_editor_fields', 'GUI: Hide these fields within the Item Attribute Editor', 'coust', 'label' ), oils_i18n_gettext( 'ui.hide_copy_editor_fields', 'This setting may be best maintained with the dedicated configuration' || ' interface within the Item Attribute Editor. However, here it' || ' shows up as comma separated list of field identifiers to hide.', 'coust', 'description' ), 'array', 'gui', 539 ); INSERT into config.org_unit_setting_type (name, grp, label, description, datatype) VALUES ( 'opac.patron.auto_overide_hold_events', 'opac', oils_i18n_gettext( 'opac.patron.auto_overide_hold_events', 'Auto-Override Permitted Hold Blocks (Patrons)', 'coust', 'label' ), oils_i18n_gettext( 'opac.patron.auto_overide_hold_events', 'When a patron places a hold that fails and the patron has the correct permission ' || 'to override the hold, automatically override the hold without presenting a message ' || 'to the patron and requiring that the patron make a decision to override', 'coust', 'description' ), 'bool' ); INSERT into config.org_unit_setting_type (name, grp, label, description, datatype) VALUES ( 'opac.patron.temporary_list_warn', 'opac', oils_i18n_gettext( 'opac.patron.temporary_list_warn', 'Warn patrons when adding to a temporary book list', 'coust', 'label' ), oils_i18n_gettext( 'opac.patron.temporary_list_warn', 'Present a warning dialog to the patron when a patron adds a book to a temporary book list.', 'coust', 'description' ), 'bool' ); INSERT INTO config.usr_setting_type (name,grp,opac_visible,label,description,datatype) VALUES ( 'opac.temporary_list_no_warn', 'opac', TRUE, oils_i18n_gettext( 'opac.temporary_list_no_warn', 'Opt out of warning when adding a book to a temporary book list', 'cust', 'label' ), oils_i18n_gettext( 'opac.temporary_list_no_warn', 'Opt out of warning when adding a book to a temporary book list', 'cust', 'description' ), 'bool' ); INSERT INTO config.usr_setting_type (name,grp,opac_visible,label,description,datatype) VALUES ( 'opac.default_list', 'opac', FALSE, oils_i18n_gettext( 'opac.default_list', 'Default list to use when adding to a list', 'cust', 'label' ), oils_i18n_gettext( 'opac.default_list', 'Default list to use when adding to a list', 'cust', 'description' ), 'integer' ); INSERT INTO config.org_unit_setting_type ( name, grp, label, description, datatype ) VALUES ( 'circ.staff.max_visible_event_age', 'circ', oils_i18n_gettext( 'circ.staff.max_visible_event_age', 'Maximum visible age of User Trigger Events in Staff Interfaces', 'coust', 'label' ), oils_i18n_gettext( 'circ.staff.max_visible_event_age', 'If this is unset, staff can view User Trigger Events regardless of age. When this is set to an interval, it represents the age of the oldest possible User Trigger Event that can be viewed.', 'coust', 'description' ), 'interval' ); -- kid's opac main search filter INSERT INTO actor.search_filter_group (owner, code, label) VALUES (1, 'kpac_main', oils_i18n_gettext(1,'Kid''s OPAC Search Filter','asfg','label')); INSERT INTO actor.search_query (id, label, query_text) VALUES (1, oils_i18n_gettext(1,'Children''s Materials','asq','label'), 'audience(a,b,c)'); INSERT INTO actor.search_query (id, label, query_text) VALUES (2, oils_i18n_gettext(2,'Young Adult Materials','asq','label'), 'audience(j,d)'); INSERT INTO actor.search_query (id, label, query_text) VALUES (3, oils_i18n_gettext(3,'General/Adult Materials','asq','label'), 'audience(e,f,g)'); INSERT INTO actor.search_filter_group_entry (grp, query, pos) VALUES ( (SELECT id FROM actor.search_filter_group WHERE code = 'kpac_main'), (SELECT id FROM actor.search_query WHERE label = 'Children''s Materials'), 0 ); INSERT INTO actor.search_filter_group_entry (grp, query, pos) VALUES ( (SELECT id FROM actor.search_filter_group WHERE code = 'kpac_main'), (SELECT id FROM actor.search_query WHERE label = 'Young Adult Materials'), 1 ); INSERT INTO actor.search_filter_group_entry (grp, query, pos) VALUES ( (SELECT id FROM actor.search_filter_group WHERE code = 'kpac_main'), (SELECT id FROM actor.search_query WHERE label = 'General/Adult Materials'), 2 ); INSERT into config.org_unit_setting_type (name, grp, label, description, datatype) VALUES ( 'acq.fund.allow_rollover_without_money', 'acq', oils_i18n_gettext( 'acq.fund.allow_rollover_without_money', 'Allow funds to be rolled over without bringing the money along', 'coust', 'label' ), oils_i18n_gettext( 'acq.fund.allow_rollover_without_money', 'Allow funds to be rolled over without bringing the money along. This makes money left in the old fund disappear, modeling its return to some outside entity.', 'coust', 'description' ), 'bool' ); INSERT INTO config.org_unit_setting_type (name, grp, label, description, datatype) VALUES ( 'circ.lost.xact_open_on_zero', 'finance', oils_i18n_gettext( 'circ.lost.xact_open_on_zero', 'Leave transaction open when lost balance equals zero', 'coust', 'label' ), oils_i18n_gettext( 'circ.lost.xact_open_on_zero', 'Leave transaction open when lost balance equals zero. This leaves the lost copy on the patron record when it is paid', 'coust', 'description' ), 'bool' ); INSERT INTO config.org_unit_setting_type (name, grp, label, description, datatype) VALUES ( 'circ.patron_expires_soon_warning', 'circ', oils_i18n_gettext( 'circ.patron_expires_soon_warning', 'Warn when patron account is about to expire', 'coust', 'label' ), oils_i18n_gettext( 'circ.patron_expires_soon_warning', 'Warn when patron account is about to expire. If set, the staff client displays a warning this many days before the expiry of a patron account. Value is in number of days, for example: 3 for 3 days.', 'coust', 'description' ), 'integer' ); INSERT INTO config.org_unit_setting_type ( name, label, grp, datatype ) VALUES ( 'circ.fines.truncate_to_max_fine', oils_i18n_gettext( 'circ.fines.truncate_to_max_fine', 'Truncate fines to max fine amount', 'coust', 'label' ), 'circ', 'bool' ); INSERT INTO config.settings_group (name, label) VALUES ( 'url_verify', oils_i18n_gettext( 'url_verify', 'URL Verify', 'csg', 'label' ) ); INSERT INTO config.org_unit_setting_type (name, grp, label, description, datatype, update_perm) VALUES ( 'url_verify.url_verification_delay', 'url_verify', oils_i18n_gettext( 'url_verify.url_verification_delay', 'Number of seconds to wait between URL test attempts.', 'coust', 'label' ), oils_i18n_gettext( 'url_verify.url_verification_delay', 'Throttling mechanism for batch URL verification runs. Each running process will wait this number of seconds after a URL test before performing the next.', 'coust', 'description' ), 'integer', 544 ); INSERT INTO config.org_unit_setting_type (name, grp, label, description, datatype, update_perm) VALUES ( 'url_verify.url_verification_max_redirects', 'url_verify', oils_i18n_gettext( 'url_verify.url_verification_max_redirects', 'Maximum redirect lookups', 'coust', 'label' ), oils_i18n_gettext( 'url_verify.url_verification_max_redirects', 'For URLs returning 3XX redirects, this is the maximum number of redirects we will follow before giving up.', 'coust', 'description' ), 'integer', 544 ); INSERT INTO config.org_unit_setting_type (name, grp, label, description, datatype, update_perm) VALUES ( 'url_verify.url_verification_max_wait', 'url_verify', oils_i18n_gettext( 'url_verify.url_verification_max_wait', 'Maximum wait time (in seconds) for a URL to lookup', 'coust', 'label' ), oils_i18n_gettext( 'url_verify.url_verification_max_wait', 'If we exceed the wait time, the URL is marked as a "timeout" and the system moves on to the next URL', 'coust', 'description' ), 'integer', 544 ); INSERT INTO config.filter_dialog_interface (key, description) VALUES ( 'url_verify', oils_i18n_gettext( 'url_verify', 'All Link Checker filter dialogs', 'cfdi', 'description' ) ); INSERT INTO config.usr_setting_type (name,grp,opac_visible,label,description,datatype) VALUES ( 'ui.grid_columns.url_verify.select_urls', 'gui', FALSE, oils_i18n_gettext( 'ui.grid_columns.url_verify.select_urls', 'Link Checker''s URL Selection interface''s saved columns', 'cust', 'label' ), oils_i18n_gettext( 'ui.grid_columns.url_verify.select_urls', 'Link Checker''s URL Selection interface''s saved columns', 'cust', 'description' ), 'string' ); INSERT INTO config.usr_setting_type (name,grp,opac_visible,label,description,datatype) VALUES ( 'ui.grid_columns.url_verify.review_attempt', 'gui', FALSE, oils_i18n_gettext( 'ui.grid_columns.url_verify.review_attempt', 'Link Checker''s Review Attempt interface''s saved columns', 'cust', 'label' ), oils_i18n_gettext( 'ui.grid_columns.url_verify.review_attempt', 'Link Checker''s Review Attempt interface''s saved columns', 'cust', 'description' ), 'string' ); INSERT INTO config.org_unit_setting_type (name, grp, label, description, datatype, update_perm) VALUES ( 'url_verify.verification_batch_size', 'url_verify', oils_i18n_gettext( 'url_verify.verification_batch_size', 'Number of URLs to test in parallel', 'coust', 'label' ), oils_i18n_gettext( 'url_verify.verification_batch_size', 'URLs are tested in batches. This number defines the size of each batch and it directly relates to the number of back-end processes performing URL verification.', 'coust', 'description' ), 'integer', 544 ); INSERT INTO config.org_unit_setting_type (name, label, description, grp, datatype, fm_class) VALUES ( 'acq.upload.default.create_po', oils_i18n_gettext( 'acq.upload.default.create_po', 'Upload Create PO', 'coust', 'label' ), oils_i18n_gettext( 'acq.upload.default.create_po', 'Create a purchase order by default during ACQ file upload', 'coust', 'description' ), 'acq', 'bool', NULL ), ( 'acq.upload.default.activate_po', oils_i18n_gettext( 'acq.upload.default.activate_po', 'Upload Activate PO', 'coust', 'label' ), oils_i18n_gettext( 'acq.upload.default.activate_po', 'Activate the purchase order by default during ACQ file upload', 'coust', 'description' ), 'acq', 'bool', NULL ), ( 'acq.upload.default.provider', oils_i18n_gettext( 'acq.upload.default.provider', 'Upload Default Provider', 'coust', 'label' ), oils_i18n_gettext( 'acq.upload.default.provider', 'Default provider to use during ACQ file upload', 'coust', 'description' ), 'acq', 'link', 'acqpro' ), ( 'acq.upload.default.vandelay.match_set', oils_i18n_gettext( 'acq.upload.default.vandelay.match_set', 'Upload Default Match Set', 'coust', 'label' ), oils_i18n_gettext( 'acq.upload.default.vandelay.match_set', 'Default match set to use during ACQ file upload', 'coust', 'description' ), 'acq', 'link', 'vms' ), ( 'acq.upload.default.vandelay.merge_profile', oils_i18n_gettext( 'acq.upload.default.vandelay.merge_profile', 'Upload Default Merge Profile', 'coust', 'label' ), oils_i18n_gettext( 'acq.upload.default.vandelay.merge_profile', 'Default merge profile to use during ACQ file upload', 'coust', 'description' ), 'acq', 'link', 'vmp' ), ( 'acq.upload.default.vandelay.import_non_matching', oils_i18n_gettext( 'acq.upload.default.vandelay.import_non_matching', 'Upload Import Non Matching by Default', 'coust', 'label' ), oils_i18n_gettext( 'acq.upload.default.vandelay.import_non_matching', 'Import non-matching records by default during ACQ file upload', 'coust', 'description' ), 'acq', 'bool', NULL ), ( 'acq.upload.default.vandelay.merge_on_exact', oils_i18n_gettext( 'acq.upload.default.vandelay.merge_on_exact', 'Upload Merge on Exact Match by Default', 'coust', 'label' ), oils_i18n_gettext( 'acq.upload.default.vandelay.merge_on_exact', 'Merge records on exact match by default during ACQ file upload', 'coust', 'description' ), 'acq', 'bool', NULL ), ( 'acq.upload.default.vandelay.merge_on_best', oils_i18n_gettext( 'acq.upload.default.vandelay.merge_on_best', 'Upload Merge on Best Match by Default', 'coust', 'label' ), oils_i18n_gettext( 'acq.upload.default.vandelay.merge_on_best', 'Merge records on best match by default during ACQ file upload', 'coust', 'description' ), 'acq', 'bool', NULL ), ( 'acq.upload.default.vandelay.merge_on_single', oils_i18n_gettext( 'acq.upload.default.vandelay.merge_on_single', 'Upload Merge on Single Match by Default', 'coust', 'label' ), oils_i18n_gettext( 'acq.upload.default.vandelay.merge_on_single', 'Merge records on single match by default during ACQ file upload', 'coust', 'description' ), 'acq', 'bool', NULL ), ( 'acq.upload.default.vandelay.quality_ratio', oils_i18n_gettext( 'acq.upload.default.vandelay.quality_ratio', 'Upload Default Min. Quality Ratio', 'coust', 'label' ), oils_i18n_gettext( 'acq.upload.default.vandelay.quality_ratio', 'Default minimum quality ratio used during ACQ file upload', 'coust', 'description' ), 'acq', 'integer', NULL ), ( 'acq.upload.default.vandelay.low_quality_fall_thru_profile', oils_i18n_gettext( 'acq.upload.default.vandelay.low_quality_fall_thru_profile', 'Upload Default Insufficient Quality Fall-Thru Profile', 'coust', 'label' ), oils_i18n_gettext( 'acq.upload.default.vandelay.low_quality_fall_thru_profile', 'Default low-quality fall through profile used during ACQ file upload', 'coust', 'description' ), 'acq', 'link', 'vmp' ), ( 'acq.upload.default.vandelay.load_item_for_imported', oils_i18n_gettext( 'acq.upload.default.vandelay.load_item_for_imported', 'Upload Load Items for Imported Records by Default', 'coust', 'label' ), oils_i18n_gettext( 'acq.upload.default.vandelay.load_item_for_imported', 'Load items for imported records by default during ACQ file upload', 'coust', 'description' ), 'acq', 'bool', NULL ); INSERT INTO config.ts_config_list(id, name) VALUES ('simple','Non-Stemmed Simple'), ('danish_nostop','Danish Stemmed'), ('dutch_nostop','Dutch Stemmed'), ('english_nostop','English Stemmed'), ('finnish_nostop','Finnish Stemmed'), ('french_nostop','French Stemmed'), ('german_nostop','German Stemmed'), ('hungarian_nostop','Hungarian Stemmed'), ('italian_nostop','Italian Stemmed'), ('norwegian_nostop','Norwegian Stemmed'), ('portuguese_nostop','Portuguese Stemmed'), ('romanian_nostop','Romanian Stemmed'), ('russian_nostop','Russian Stemmed'), ('spanish_nostop','Spanish Stemmed'), ('swedish_nostop','Swedish Stemmed'), ('turkish_nostop','Turkish Stemmed'); INSERT INTO config.metabib_class_ts_map(field_class, ts_config, index_weight, always) VALUES ('keyword','simple','A',true), ('keyword','english_nostop','C',true), ('title','simple','A',true), ('title','english_nostop','C',true), ('author','simple','A',true), ('author','english_nostop','C',true), ('series','simple','A',true), ('series','english_nostop','C',true), ('subject','simple','A',true), ('subject','english_nostop','C',true), ('identifier','simple','A',true); INSERT INTO config.metabib_field_ts_map (metabib_field, ts_config) VALUES (33, 'english_nostop'); INSERT INTO config.org_unit_setting_type ( name, label, description, datatype, fm_class, update_perm, grp ) VALUES ( 'circ.hold_capture_order', oils_i18n_gettext( 'circ.hold_capture_order', 'Best-hold selection sort order', 'coust', 'label' ), oils_i18n_gettext( 'circ.hold_capture_order', 'Defines the sort order of holds when selecting a hold to fill using a given copy at capture time', 'coust', 'description' ), 'link', 'cbho', 543, 'holds' ); INSERT INTO config.org_unit_setting_type ( name, label, description, datatype, update_perm, grp ) VALUES ( 'circ.hold_go_home_interval', oils_i18n_gettext( 'circ.hold_go_home_interval', 'Max foreign-circulation time', 'coust', 'label' ), oils_i18n_gettext( 'circ.hold_go_home_interval', 'Time a copy can spend circulating away from its circ lib before returning there to fill a hold (if one exists there)', 'coust', 'description' ), 'interval', 543, 'holds' ); INSERT INTO config.best_hold_order ( name, approx, pprox, aprox, priority, cut, depth, rtime ) VALUES ( 'Traditional', 1, 2, 3, 4, 5, 6, 7 ); INSERT INTO config.best_hold_order ( name, hprox, approx, pprox, aprox, priority, cut, depth, rtime ) VALUES ( 'Traditional with Holds-always-go-home', 1, 2, 3, 4, 5, 6, 7, 8 ); INSERT INTO config.best_hold_order ( name, htime, approx, pprox, aprox, priority, cut, depth, rtime ) VALUES ( 'Traditional with Holds-go-home', 1, 2, 3, 4, 5, 6, 7, 8 ); INSERT INTO config.best_hold_order ( name, priority, cut, rtime, depth, pprox, hprox, aprox, htime ) VALUES ( 'FIFO', 1, 2, 3, 4, 5, 6, 7, 8 ); INSERT INTO config.best_hold_order ( name, hprox, priority, cut, rtime, depth, pprox, aprox, htime ) VALUES ( 'FIFO with Holds-always-go-home', 1, 2, 3, 4, 5, 6, 7, 8 ); INSERT INTO config.best_hold_order ( name, htime, priority, cut, rtime, depth, pprox, aprox, hprox ) VALUES ( 'FIFO with Holds-go-home', 1, 2, 3, 4, 5, 6, 7, 8 ); INSERT INTO actor.org_unit_setting ( org_unit, name, value ) VALUES ( (SELECT id FROM actor.org_unit WHERE parent_ou IS NULL), 'circ.hold_go_home_interval', '"6 months"' ); INSERT INTO action_trigger.hook ( key, core_type, description, passive ) VALUES ( 'au.barred', 'au', 'A user was barred by staff', FALSE ); INSERT INTO action_trigger.hook ( key, core_type, description, passive ) VALUES ( 'au.unbarred', 'au', 'A user was un-barred by staff', FALSE ); INSERT INTO action_trigger.validator ( module, description ) VALUES ( 'PatronBarred', 'Tests if a patron is currently marked as barred' ); INSERT INTO action_trigger.validator ( module, description ) VALUES ( 'PatronNotBarred', 'Tests if a patron is currently not marked as barred' ); INSERT INTO config.org_unit_setting_type (name, label, description, grp, datatype) VALUES ( 'acq.fund.rollover_distrib_forms', oils_i18n_gettext( 'acq.fund.rollover_distrib_forms', 'Rollover Distribution Formulae Funds', 'coust', 'label' ), oils_i18n_gettext( 'acq.fund.rollover_distrib_forms', 'During fiscal rollover, update distribution formalae to use new funds', 'coust', 'description' ), 'acq', 'bool' ); INSERT INTO config.z3950_index_field_map (id, label, metabib_field, z3950_attr_type) VALUES (1, oils_i18n_gettext(1, 'Title', 'czifm', 'label'), 5, 'title'), (2, oils_i18n_gettext(2, 'Author', 'czifm', 'label'), 8, 'author'), (3, oils_i18n_gettext(3, 'ISBN', 'czifm', 'label'), 18, 'isbn'), (4, oils_i18n_gettext(4, 'ISSN', 'czifm', 'label'), 19, 'issn'), (5, oils_i18n_gettext(5, 'LCCN', 'czifm', 'label'), 30, 'lccn'); INSERT INTO config.z3950_index_field_map (id, label, record_attr, z3950_attr_type) VALUES (6, oils_i18n_gettext(6, 'Pubdate', 'czifm', 'label'),'pubdate', 'pubdate'), (7, oils_i18n_gettext(7, 'Item Type', 'czifm', 'label'),'item_type', 'item_type'); -- let's leave room for more stock mappings SELECT SETVAL('config.z3950_index_field_map_id_seq'::TEXT, 1000); INSERT INTO config.org_unit_setting_type (name, grp, label, description, datatype) VALUES ( 'cat.z3950.batch.max_parallel', 'cat', oils_i18n_gettext( 'cat.z3950.batch.max_parallel', 'Maximum Parallel Z39.50 Batch Searches', 'coust', 'label' ), oils_i18n_gettext( 'cat.z3950.batch.max_parallel', 'The maximum number of Z39.50 searches that can be in-flight at any given time when performing batch Z39.50 searches', 'coust', 'description' ), 'integer' ); INSERT INTO config.org_unit_setting_type (name, grp, label, description, datatype) VALUES ( 'cat.z3950.batch.max_results', 'cat', oils_i18n_gettext( 'cat.z3950.batch.max_results', 'Maximum Z39.50 Batch Search Results', 'coust', 'label' ), oils_i18n_gettext( 'cat.z3950.batch.max_results', 'The maximum number of search results to retrieve and queue for each record + Z39 source during batch Z39.50 searches', 'coust', 'description' ), 'integer' ); -- long overdue stuff... INSERT INTO config.org_unit_setting_type (name, grp, datatype, label, description) VALUES ( 'circ.longoverdue_immediately_available', 'circ', 'bool', oils_i18n_gettext( 'circ.longoverdue_immediately_available', 'Long-Overdue Items Usable on Checkin', 'coust', 'label' ), oils_i18n_gettext( 'circ.longoverdue_immediately_available', 'Long-overdue items are usable on checkin instead of going "home" first', 'coust', 'description' ) ), ( 'circ.longoverdue_materials_processing_fee', 'finance', 'currency', oils_i18n_gettext( 'circ.longoverdue_materials_processing_fee', 'Long-Overdue Materials Processing Fee', 'coust', 'label' ), oils_i18n_gettext( 'circ.longoverdue_materials_processing_fee', 'Long-Overdue Materials Processing Fee', 'coust', 'description' ) ), ( 'circ.max_accept_return_of_longoverdue', 'circ', 'interval', oils_i18n_gettext( 'circ.max_accept_return_of_longoverdue', 'Long-Overdue Max Return Interval', 'coust', 'label' ), oils_i18n_gettext( 'circ.max_accept_return_of_longoverdue', 'Long-overdue check-in processing (voiding fees, re-instating ' || 'overdues, etc.) will not take place for items that have been ' || 'overdue for (or have last activity older than) this amount of time', 'coust', 'description' ) ), ( 'circ.restore_overdue_on_longoverdue_return', 'circ', 'bool', oils_i18n_gettext( 'circ.restore_overdue_on_longoverdue_return', 'Restore Overdues on Long-Overdue Item Return', 'coust', 'label' ), oils_i18n_gettext( 'circ.restore_overdue_on_longoverdue_return', 'Restore Overdues on Long-Overdue Item Return', 'coust', 'description' ) ), ( 'circ.void_longoverdue_on_checkin', 'circ', 'bool', oils_i18n_gettext( 'circ.void_longoverdue_on_checkin', 'Void Long-Overdue Item Billing When Returned', 'coust', 'label' ), oils_i18n_gettext( 'circ.void_longoverdue_on_checkin', 'Void Long-Overdue Item Billing When Returned', 'coust', 'description' ) ), ( 'circ.void_longoverdue_proc_fee_on_checkin', 'circ', 'bool', oils_i18n_gettext( 'circ.void_longoverdue_proc_fee_on_checkin', 'Void Processing Fee on Long-Overdue Item Return', 'coust', 'label' ), oils_i18n_gettext( 'circ.void_longoverdue_proc_fee_on_checkin', 'Void Processing Fee on Long-Overdue Item Return', 'coust', 'description' ) ), ( 'circ.void_overdue_on_longoverdue', 'finance', 'bool', oils_i18n_gettext( 'circ.void_overdue_on_longoverdue', 'Void Overdue Fines When Items are Marked Long-Overdue', 'coust', 'label' ), oils_i18n_gettext( 'circ.void_overdue_on_longoverdue', 'Void Overdue Fines When Items are Marked Long-Overdue', 'coust', 'description' ) ), ( 'circ.longoverdue.xact_open_on_zero', 'finance', 'bool', oils_i18n_gettext( 'circ.longoverdue.xact_open_on_zero', 'Leave transaction open when long overdue balance equals zero', 'coust', 'label' ), oils_i18n_gettext( 'circ.longoverdue.xact_open_on_zero', 'Leave transaction open when long-overdue balance equals zero. ' || 'This leaves the long-overdue copy on the patron record when it is paid', 'coust', 'description' ) ), ( 'circ.longoverdue.use_last_activity_date_on_return', 'circ', 'bool', oils_i18n_gettext( 'circ.longoverdue.use_last_activity_date_on_return', 'Long-Overdue Check-In Interval Uses Last Activity Date', 'coust', 'label' ), oils_i18n_gettext( 'circ.longoverdue.use_last_activity_date_on_return', 'Use the long-overdue last-activity date instead of the due_date to ' || 'determine whether the item has been checked out too long to ' || 'perform long-overdue check-in processing. If set, the system ' || 'will first check the last payment time, followed by the last ' || 'billing time, followed by the due date. See also ' || 'circ.max_accept_return_of_longoverdue', 'coust', 'description' ) ); -- mark long-overdue reactor INSERT INTO action_trigger.reactor (module, description) VALUES ( 'MarkItemLongOverdue', oils_i18n_gettext( 'MarkItemLongOverdue', 'Marks a circulating item as long-overdue and applies configured ' || 'penalties. Also creates events for the longoverdue.auto hook', 'atreact', 'description' ) ); INSERT INTO action_trigger.validator (module, description) VALUES ( 'PatronNotInCollections', 'Event is valid if the linked patron is not in collections processing ' || 'at the context org unit' ); INSERT INTO action_trigger.event_definition (id, active, owner, name, hook, validator, reactor, delay, delay_field) VALUES ( 49, FALSE, 1, '6 Month Overdue Mark Long-Overdue', 'checkout.due', 'PatronNotInCollections', 'MarkItemLongOverdue', '6 months', 'due_date' ); INSERT INTO action_trigger.event_params (event_def, param, value) VALUES (49, 'editor', '''1'''); -- new longoverdue and longervdue.auto hook. INSERT INTO action_trigger.hook (key,core_type,description) VALUES ( 'longoverdue', 'circ', 'Circulating Item marked long-overdue' ); INSERT INTO action_trigger.hook (key,core_type,description) VALUES ( 'longoverdue.auto', 'circ', 'Circulating Item automatically marked long-overdue' ); -- sample longoverdue.auto notification reactor INSERT INTO action_trigger.event_definition (id, active, owner, name, hook, validator, reactor, group_field, template) VALUES ( 50, FALSE, 1, '6 Month Long Overdue Notice', 'longoverdue.auto', 'NOOP_True', 'SendEmail', 'usr', $$ [%- USE date -%] [%- user = target.0.usr -%] To: [%- params.recipient_email || user.email %] From: [%- params.sender_email || default_sender %] Date: [%- date.format(date.now, '%a, %d %b %Y %T -0000', gmt => 1) %] Subject: Overdue Items Marked Long Overdue Auto-Submitted: auto-generated Dear [% user.family_name %], [% user.first_given_name %] The following items are 6 months overdue and have been marked Long Overdue. [% FOR circ IN target %] [%- copy_details = helpers.get_copy_bib_basics(circ.target_copy.id) -%] Title: [% copy_details.title %], by [% copy_details.author %] Call Number: [% circ.target_copy.call_number.label %] Shelving Location: [% circ.target_copy.location.name %] Barcode: [% circ.target_copy.barcode %] Due: [% date.format(helpers.format_date(circ.due_date), '%Y-%m-%d') %] Item Cost: [% helpers.get_copy_price(circ.target_copy) %] Total Owed For Transaction: [% circ.billable_transaction.summary.balance_owed %] Library: [% circ.circ_lib.name %] [% END %] $$); -- ENV for above INSERT INTO action_trigger.environment (event_def, path) VALUES (50, 'target_copy.call_number'), (50, 'usr'), (50, 'billable_transaction.summary'), (50, 'circ_lib.billing_address'), (50, 'target_copy.location'); -- Auto-cancelled, no target INSERT INTO action_trigger.event_definition ( id, active, owner, name, hook, validator, reactor, delay, delay_field, group_field, message_usr_path, message_library_path, message_title, message_template ) VALUES ( 51, FALSE, 1, 'Hold Cancelled (No Target) User Message', 'hold_request.cancel.expire_no_target', 'HoldIsCancelled', 'NOOP_True', '30 minutes', 'cancel_time', 'usr', 'usr', 'usr.home_ou', 'Hold Request Cancelled', $$ [%- USE date -%] [%- user = target.0.usr -%] The following holds were cancelled because no items were found to fulfill them. [% FOR hold IN target %] Title: [% hold.bib_rec.bib_record.simple_record.title %] Author: [% hold.bib_rec.bib_record.simple_record.author %] Library: [% hold.pickup_lib.name %] Request Date: [% date.format(helpers.format_date(hold.request_time), '%Y-%m-%d') %] [% END %] $$); INSERT INTO action_trigger.environment (event_def, path) VALUES (51, 'usr'), (51, 'pickup_lib'), (51, 'bib_rec.bib_record.simple_record'); -- Cancelled by staff INSERT INTO action_trigger.event_definition ( id, active, owner, name, hook, validator, reactor, delay, delay_field, group_field, message_usr_path, message_library_path, message_title, message_template ) VALUES ( 52, FALSE, 1, 'Hold Cancelled (Staff) User Message', 'hold_request.cancel.staff', 'HoldIsCancelled', 'NOOP_True', '30 minutes', 'cancel_time', 'usr', 'usr', 'usr.home_ou', 'Hold Request Cancelled', $$ [%- USE date -%] [%- user = target.0.usr -%] The following holds were cancelled by a staff member. [% FOR hold IN target %] Title: [% hold.bib_rec.bib_record.simple_record.title %] Author: [% hold.bib_rec.bib_record.simple_record.author %] Library: [% hold.pickup_lib.name %] Request Date: [% date.format(helpers.format_date(hold.request_time), '%Y-%m-%d') %] Cancellation Note: [% hold.cancel_note %] [% END %] $$); INSERT INTO action_trigger.environment (event_def, path) VALUES (52, 'usr'), (52, 'pickup_lib'), (52, 'bib_rec.bib_record.simple_record'); -- Shelf expired INSERT INTO action_trigger.event_definition ( id, active, owner, name, hook, validator, reactor, delay, delay_field, group_field, message_usr_path, message_library_path, message_title, message_template ) VALUES ( 53, TRUE, 1, 'Hold Cancelled (Shelf-expired) User Message', 'hold_request.cancel.expire_holds_shelf', 'HoldIsCancelled', 'NOOP_True', '30 minutes', 'cancel_time', 'usr', 'usr', 'usr.home_ou', 'Hold Request Cancelled', $$ [%- USE date -%] [%- user = target.0.usr -%] The following holds were cancelled because they were never picked up. [% FOR hold IN target %] Title: [% hold.bib_rec.bib_record.simple_record.title %] Author: [% hold.bib_rec.bib_record.simple_record.author %] Library: [% hold.pickup_lib.name %] Request Date: [% date.format(helpers.format_date(hold.request_time), '%Y-%m-%d') %] Pickup By: [% date.format(helpers.format_date(hold.shelf_expire_time), '%Y-%m-%d') %] [% END %] $$); INSERT INTO action_trigger.environment (event_def, path) VALUES (53, 'usr'), (53, 'pickup_lib'), (53, 'bib_rec.bib_record.simple_record'); -- 30 Day Pre Expire A/T Notice - Notify customers before their account expires INSERT INTO action_trigger.hook (key, core_type, description, passive) VALUES ('au.expired', 'au', 'A user account has expired', 't'); INSERT INTO action_trigger.event_definition ( active, owner, name, hook, validator, reactor, delay, delay_field, max_delay, repeat_delay, template ) VALUES ( 'f', '1', '30 Day Account Expiration Courtesy Notice','au.expired', 'NOOP_True', 'SendEmail', '-30 days', 'expire_date', '-29 days', '30 days', $$ [%- USE date -%] [%- user = target -%] [%- lib = target.home_ou -%] To: [%- params.recipient_email || user.email %] From: [%- helpers.get_org_setting(target.home_ou.id, 'org.bounced_emails') || lib.email || params.sender_email || default_sender %] Date: [%- date.format(date.now, '%a, %d %b %Y %T -0000', gmt => 1) %] Reply-To: [%- helpers.get_org_setting(target.home_ou.id, 'org.bounced_emails') || lib.email || params.sender_email || default_sender %] Subject: Courtesy Notice - Library Account Expiration in 30 days Auto-Submitted: auto-generated Dear [% user.first_given_name %] [% user.family_name %], Our records indicate your library account is due to expire in 30 days. Please visit your local library at your convenience to renew your account in order to avoid a disruption in access to library service. Sincerely, [% lib.name %] Contact your library for more information: [% lib.name %] [%- SET addr = lib.mailing_address -%] [%- IF !addr -%] [%- SET addr = lib.billing_address -%] [%- END %] [% addr.street1 %] [% addr.street2 %] [% addr.city %], [% addr.state %] [% addr.post_code %] [% lib.phone %] $$); INSERT INTO action_trigger.environment (event_def, path) VALUES (currval('action_trigger.event_definition_id_seq'), 'home_ou.mailing_address'), (currval('action_trigger.event_definition_id_seq'), 'home_ou.billing_address'); --Start new patron welcome email notice/action ----------- --create hook for actor.usr.create_date INSERT INTO action_trigger.hook (key, core_type, description, passive) VALUES ('au.created', 'au', 'A user was created', 't'); --SQL to create event definition for new account creation notice --Inactive, owned by top of org tree by default. Modify to suit needs. INSERT INTO action_trigger.event_definition ( active, owner, name, hook, validator, reactor, delay, delay_field, max_delay, template ) VALUES ( 'f', '1', 'New User Created Welcome Notice', 'au.created', 'NOOP_True', 'SendEmail', '10 seconds', 'create_date', '1 day', $$ [%- USE date -%] [%- user = target -%] [%- lib = target.home_ou -%] To: [%- params.recipient_email || user.email %] From: [%- helpers.get_org_setting(target.home_ou.id, 'org.bounced_emails') || lib.email || params.sender_email || default_sender %] Date: [%- date.format(date.now, '%a, %d %b %Y %T -0000', gmt => 1) %] Reply-To: [%- helpers.get_org_setting(target.home_ou.id, 'org.bounced_emails') || lib.email || params.sender_email || default_sender %] Subject: New Library Account Sign-up - Welcome! Auto-Submitted: auto-generated Dear [% user.first_given_name %] [% user.family_name %], Thank you for signing up for an account with the [% lib.name %] on [% user.create_date.substr(0, 10) %]. This email is your confirmation that your account is set up and ready as well as testing to see that we have your correct email address. If you did not sign up for an account at the library and have received this email in error, please reply and let us know. You can access your account online at http://catalog/eg/opac/login. From that site you can search the catalog, request materials, renew materials, leave comments, leave suggestions for titles you would like the library to purchase and update your account information. Sincerely, [% lib.name %] Contact your library for more information: [% lib.name %] [%- SET addr = lib.mailing_address -%] [%- IF !addr -%] [%- SET addr = lib.billing_address -%] [%- END %] [% addr.street1 %] [% addr.street2 %] [% addr.city %], [% addr.state %] [% addr.post_code %] [% lib.phone %] [% lib.email %] $$); --insert environment values INSERT INTO action_trigger.environment (event_def, path) VALUES (CURRVAL('action_trigger.event_definition_id_seq'), 'home_ou.mailing_address'), (CURRVAL('action_trigger.event_definition_id_seq'), 'home_ou.billing_address'); -- End new patron welcome message notice ----------- -- OUS's for patron self-reg INSERT INTO config.org_unit_setting_type (name, grp, datatype, label, description) VALUES ( 'opac.allow_pending_user', 'opac', 'bool', oils_i18n_gettext( 'opac.allow_pending_user', 'Allow Patron Self-Registration', 'coust', 'label' ), oils_i18n_gettext( 'opac.allow_pending_user', 'Allow patrons to self-register, creating pending user accounts', 'coust', 'description' ) ), ( 'opac.pending_user_expire_interval', 'opac', 'interval', oils_i18n_gettext( 'opac.pending_user_expire_interval', 'Patron Self-Reg. Expire Interval', 'coust', 'label' ), oils_i18n_gettext( 'opac.pending_user_expire_interval', 'If set, this is the amount of time a pending user account will ' || 'be allowed to sit in the database. After this time, the pending ' || 'user information will be purged', 'coust', 'description' ) ), ( 'ui.patron.edit.aua.county.show', 'gui', 'bool', oils_i18n_gettext( 'ui.patron.edit.aua.county.show', 'Show county field on patron registration', 'coust', 'label' ), oils_i18n_gettext( 'ui.patron.edit.aua.county.show', 'The county field will be shown on the patron registration screen', 'coust', 'description' ) ); -- vandelay item import defaults INSERT INTO config.org_unit_setting_type (grp, name, label, description, datatype, fm_class) VALUES ( 'vandelay', 'vandelay.item.barcode.auto', oils_i18n_gettext( 'vandelay.item.barcode.auto', 'Vandelay Generate Default Barcodes', 'coust', 'label'), oils_i18n_gettext( 'vandelay.item.barcode.auto', 'Auto-generate deault item barcodes when no item barcode is present', 'coust', 'description'), 'bool', NULL ), ( 'vandelay', 'vandelay.item.barcode.prefix', oils_i18n_gettext( 'vandelay.item.barcode.prefix', 'Vandelay Default Barcode Prefix', 'coust', 'label'), oils_i18n_gettext( 'vandelay.item.barcode.prefix', 'Apply this prefix to any auto-generated item barcodes', 'coust', 'description'), 'string', NULL ), ( 'vandelay', 'vandelay.item.call_number.auto', oils_i18n_gettext( 'vandelay.item.call_number.auto', 'Vandelay Generate Default Call Numbers', 'coust', 'label'), oils_i18n_gettext( 'vandelay.item.call_number.auto', 'Auto-generate default item call numbers when no item call number is present', 'coust', 'description'), 'bool', NULL ), ( 'vandelay', 'vandelay.item.call_number.prefix', oils_i18n_gettext( 'vandelay.item.call_number.prefix', 'Vandelay Default Call Number Prefix', 'coust', 'label'), oils_i18n_gettext( 'vandelay.item.call_number.prefix', 'Apply this prefix to any auto-generated item call numbers', 'coust', 'description'), 'string', NULL ), ( 'vandelay', 'vandelay.item.copy_location.default', oils_i18n_gettext( 'vandelay.item.copy_location.default', 'Vandelay Default Copy Location', 'coust', 'label'), oils_i18n_gettext( 'vandelay.item.copy_location.default', 'Default copy location value for imported items', 'coust', 'description'), 'link', 'acpl' ), ( 'vandelay', 'vandelay.item.circ_modifier.default', oils_i18n_gettext( 'vandelay.item.circ_modifier.default', 'Vandelay Default Circulation Modifier', 'coust', 'label'), oils_i18n_gettext( 'vandelay.item.circ_modifier.default', 'Default circulation modifier value for imported items', 'coust', 'description'), 'link', 'ccm' ); INSERT into config.org_unit_setting_type (name, grp, label, description, datatype) VALUES ( 'opac.holds.org_unit_not_pickup_lib', 'opac', oils_i18n_gettext('opac.holds.org_unit_not_pickup_lib', 'OPAC: Org Unit is not a hold pickup library', 'coust', 'label'), oils_i18n_gettext('opac.holds.org_unit_not_pickup_lib', 'If set, this org unit will not be offered to the patron as an '|| 'option for a hold pickup location. This setting has no affect '|| 'on searching or hold targeting', 'coust', 'description'), 'bool' ); INSERT INTO config.standing_penalty (id, name, label, block_list, staff_alert) VALUES ( 35, 'PATRON_EXCEEDS_LONGOVERDUE_COUNT', oils_i18n_gettext( 35, 'Patron Exceeds Max Long-Overdue Threshold', 'csp', 'label' ), 'CIRC|FULFILL|HOLD|CAPTURE|RENEW', TRUE ); INSERT INTO config.org_unit_setting_type (name, grp, datatype, label, description) VALUES ( 'opac.self_register.timeout', 'opac', 'integer', oils_i18n_gettext( 'opac.self_register.timeout', 'Patron Self-Reg. Display Timeout', 'coust', 'label' ), oils_i18n_gettext( 'opac.self_register.timeout', 'Number of seconds to wait before reloading the patron self-'|| 'registration interface to clear sensitive data', 'coust', 'description' ) ); INSERT INTO config.org_unit_setting_type (name, grp, datatype, label, description) VALUES ( 'ui.circ.items_out.longoverdue', 'gui', 'integer', oils_i18n_gettext( 'ui.circ.items_out.longoverdue', 'Items Out Long-Overdue display setting', 'coust', 'label' ), oils_i18n_gettext( 'ui.circ.items_out.longoverdue', 'Value is a numeric code, describing which list the circulation '|| 'should appear while checked out and whether the circulation should '|| 'continue to appear in the bottom list, when checked in with '|| 'oustanding fines. '|| '1 = top list, bottom list. 2 = bottom list, bottom list. ' || '5 = top list, do not display. 6 = bottom list, do not display.', 'coust', 'description' ) ), ( 'ui.circ.items_out.lost', 'gui', 'integer', oils_i18n_gettext( 'ui.circ.items_out.lost', 'Items Out Lost display setting', 'coust', 'label' ), oils_i18n_gettext( 'ui.circ.items_out.lost', 'Value is a numeric code, describing which list the circulation '|| 'should appear while checked out and whether the circulation should '|| 'continue to appear in the bottom list, when checked in with '|| 'oustanding fines. '|| '1 = top list, bottom list. 2 = bottom list, bottom list. ' || '5 = top list, do not display. 6 = bottom list, do not display.', 'coust', 'description' ) ), ( 'ui.circ.items_out.claimsreturned', 'gui', 'integer', oils_i18n_gettext( 'ui.circ.items_out.claimsreturned', 'Items Out Claims Returned display setting', 'coust', 'label' ), oils_i18n_gettext( 'ui.circ.items_out.claimsreturned', 'Value is a numeric code, describing which list the circulation '|| 'should appear while checked out and whether the circulation should '|| 'continue to appear in the bottom list, when checked in with '|| 'oustanding fines. '|| '1 = top list, bottom list. 2 = bottom list, bottom list. ' || '5 = top list, do not display. 6 = bottom list, do not display.', 'coust', 'description' ) ); -- YAOUS patron credit disable INSERT INTO config.org_unit_setting_type (grp, name, datatype, label, description) VALUES ( 'finance', 'circ.disable_patron_credit', 'bool', oils_i18n_gettext( 'circ.disable_patron_credit', 'Disable Patron Credit', 'coust', 'label' ), oils_i18n_gettext( 'circ.disable_patron_credit', 'Do not allow patrons to accrue credit or pay fines/fees with accrued credit', 'coust', 'description' ) ); INSERT INTO config.floating_group(name) VALUES ('Everywhere'); INSERT INTO config.floating_group_member(floating_group, org_unit) VALUES (1, 1); INSERT INTO config.global_flag (name, label, value, enabled) VALUES ( 'opac.metarecord.holds.format_attr', oils_i18n_gettext( 'opac.metarecord.holds.format_attr', 'OPAC Metarecord Hold Formats Attribute', 'cgf', 'label' ), 'mr_hold_format', TRUE ); -- until we have a custom attribute for the selector, -- default to the icon_format attribute INSERT INTO config.global_flag (name, label, value, enabled) VALUES ( 'opac.format_selector.attr', oils_i18n_gettext( 'opac.format_selector.attr', 'OPAC Format Selector Attribute', 'cgf', 'label' ), 'search_format', TRUE ); INSERT INTO config.global_flag (name, value, label, enabled) VALUES ( 'search.max_facets_per_field', '1000', oils_i18n_gettext( 'search.max_facets_per_field', 'Search: maximum number of facet values to retrieve for each facet field', 'cgf', 'label' ), TRUE ); INSERT INTO config.org_unit_setting_type (name, grp, label, description, datatype) VALUES ('circ.void_lost_on_claimsreturned', 'circ', oils_i18n_gettext('circ.void_lost_on_claimsreturned', 'Void lost item billing when claims returned', 'coust', 'label'), oils_i18n_gettext('circ.void_lost_on_claimsreturned', 'Void lost item billing when claims returned', 'coust', 'description'), 'bool'), ('circ.void_lost_proc_fee_on_claimsreturned', 'circ', oils_i18n_gettext('circ.void_lost_proc_fee_on_claimsreturned', 'Void lost item processing fee when claims returned', 'coust', 'label'), oils_i18n_gettext('circ.void_lost_proc_fee_on_claimsreturned', 'Void lost item processing fee when claims returned', 'coust', 'description'), 'bool'); INSERT INTO config.org_unit_setting_type (name, grp, label, description, datatype) VALUES ('circ.void_longoverdue_on_claimsreturned', 'circ', oils_i18n_gettext('circ.void_longoverdue_on_claimsreturned', 'Void longoverdue item billing when claims returned', 'coust', 'label'), oils_i18n_gettext('circ.void_longoverdue_on_claimsreturned', 'Void long overdue item billing when claims returned', 'coust', 'description'), 'bool'), ('circ.void_longoverdue_proc_fee_on_claimsreturned', 'circ', oils_i18n_gettext('circ.void_longoverdue_proc_fee_on_claimsreturned', 'Void longoverdue item processing fee when claims returned', 'coust', 'label'), oils_i18n_gettext('circ.void_longoverdue_proc_fee_on_claimsreturned', 'Void long overdue item processing fee when claims returned', 'coust', 'description'), 'bool'); INSERT INTO config.org_unit_setting_type (name, grp, label, description, datatype) VALUES ('org.restrict_opt_to_depth', 'sec', oils_i18n_gettext('org.restrict_opt_to_depth', 'Restrict patron opt-in to home library and related orgs at specified depth', 'coust', 'label'), oils_i18n_gettext('org.restrict_opt_to_depth', 'Patrons at this library can only be opted-in at org units which are within the '|| 'library''s section of the org tree, at or below the depth specified by this setting. '|| 'They cannot be opted in at any other libraries.', 'coust', 'description'), 'integer'); INSERT INTO config.org_unit_setting_type ( name, grp, label, description, datatype ) VALUES ('circ.clear_hold_on_checkout', 'circ', oils_i18n_gettext('circ.clear_hold_on_checkout', 'Clear hold when other patron checks out item', 'coust', 'label'), oils_i18n_gettext('circ.clear_hold_on_checkout', 'Default to cancel the hold when patron A checks out item on hold for patron B.', 'coust', 'description'), 'bool'); INSERT INTO config.org_unit_setting_type ( name, grp, label, description, datatype ) VALUES ('circ.patron_search.diacritic_insensitive', 'circ', oils_i18n_gettext('circ.patron_search.diacritic_insensitive', 'Patron search diacritic insensitive', 'coust', 'label'), oils_i18n_gettext('circ.patron_search.diacritic_insensitive', 'Match patron last, first, and middle names irrespective of usage of diacritical marks or spaces. (e.g., Ines will match Inés; de la Cruz will match Delacruz)', 'coust', 'description'), 'bool'); INSERT INTO actor.org_unit_setting ( org_unit, name, value ) VALUES ( (SELECT id FROM actor.org_unit WHERE parent_ou IS NULL), 'circ.patron_search.diacritic_insensitive', 'true' ); INSERT INTO config.global_flag (name, enabled, label) VALUES ( 'ingest.disable_authority_auto_update_bib_meta', FALSE, oils_i18n_gettext( 'ingest.disable_authority_auto_update_bib_meta', 'Authority Automation: Disable automatic authority updates ' || 'from modifying bib record editor and edit_date', 'cgf', 'label' ) ); -- email checkout receipts INSERT INTO config.usr_setting_type ( name, opac_visible, label, description, datatype ) VALUES ( 'circ.send_email_checkout_receipts', TRUE, oils_i18n_gettext('circ.send_email_checkout_receipts', 'Email checkout receipts by default?', 'cust', 'label'), oils_i18n_gettext('circ.send_email_checkout_receipts', 'Email checkout receipts by default?', 'cust', 'description'), 'bool' ); INSERT INTO action_trigger.hook (key, core_type, description, passive) VALUES ( 'circ.checkout.batch_notify', 'circ', oils_i18n_gettext( 'circ.checkout.batch_notify', 'Notification of a group of circs', 'ath', 'description' ), FALSE ); INSERT INTO action_trigger.hook (key, core_type, description, passive) VALUES ( 'circ.checkout.batch_notify.session', 'circ', oils_i18n_gettext( 'circ.checkout.batch_notify.session', 'Notification of a group of circs at the end of a checkout session', 'ath', 'description' ), FALSE ); INSERT INTO action_trigger.event_definition ( active, owner, name, hook, validator, reactor, usr_field, opt_in_setting, group_field, template ) VALUES ( TRUE, 1, 'Email Checkout Receipt', 'circ.checkout.batch_notify.session', 'NOOP_True', 'SendEmail', 'usr', 'circ.send_email_checkout_receipts', 'usr', $$[%- USE date -%] [%- user = target.0.usr -%] To: [%- params.recipient_email || user.email %] From: [%- helpers.get_org_setting(target.0.circ_lib.id, 'org.bounced_emails') || params.sender_email || default_sender %] Subject: Checkout Receipt Auto-Submitted: auto-generated You checked out the following items: [% FOR circ IN target %] [%- copy_details = helpers.get_copy_bib_basics(circ.target_copy.id) -%] Title: [% copy_details.title %] Author: [% copy_details.author %] Call Number: [% circ.target_copy.call_number.label %] Barcode: [% circ.target_copy.barcode %] Due: [% date.format(helpers.format_date(circ.due_date), '%Y-%m-%d') %] Library: [% circ.circ_lib.name %] [% END %] $$); INSERT INTO action_trigger.environment ( event_def, path ) VALUES ( currval('action_trigger.event_definition_id_seq'), 'target_copy.call_number' ), ( currval('action_trigger.event_definition_id_seq'), 'target_copy.location' ), ( currval('action_trigger.event_definition_id_seq'), 'usr' ), ( currval('action_trigger.event_definition_id_seq'), 'circ_lib' ); INSERT INTO config.org_unit_setting_type (name, grp, label, description, datatype) VALUES ('circ.in_house_use.copy_alert', 'circ', oils_i18n_gettext('circ.in_house_use.copy_alert', 'Display copy alert for in-house-use', 'coust', 'label'), oils_i18n_gettext('circ.in_house_use.copy_alert', 'Display copy alert for in-house-use', 'coust', 'description'), 'bool'), ('circ.in_house_use.checkin_alert', 'circ', oils_i18n_gettext('circ.in_house_use.checkin_alert', 'Display copy location checkin alert for in-house-use', 'coust', 'label'), oils_i18n_gettext('circ.in_house_use.checkin_alert', 'Display copy location checkin alert for in-house-use', 'coust', 'description'), 'bool'); INSERT into config.org_unit_setting_type ( name ,grp ,label ,description ,datatype ) VALUES ( ---------------------------------------- 'webstaff.cat.label.font.family' ,'cat' ,oils_i18n_gettext( 'webstaff.cat.label.font.family' ,'Item Print Label Font Family' ,'coust' ,'label' ) ,oils_i18n_gettext( 'webstaff.cat.label.font.family' ,'Set the preferred font family for item print labels. You can specify a list of CSS fonts, separated by commas, in order of preference; the system will use the first font it finds with a matching name. For example, "Arial, Helvetica, serif"' ,'coust' ,'description' ) ,'string' ), ( ---------------------------------------- 'webstaff.cat.label.font.size' ,'cat' ,oils_i18n_gettext( 'webstaff.cat.label.font.size' ,'Item Print Label Font Size' ,'coust' ,'label' ) ,oils_i18n_gettext( 'webstaff.cat.label.font.size' ,'Set the default font size for item print labels. Please include a unit of measurement that is valid CSS. For example, "12pt" or "16px" or "1em"' ,'coust' ,'description' ) ,'string' ), ( ---------------------------------------- 'webstaff.cat.label.font.weight' ,'cat' ,oils_i18n_gettext( 'webstaff.cat.label.font.weight' ,'Item Print Label Font Weight' ,'coust' ,'label' ) ,oils_i18n_gettext( 'webstaff.cat.label.font.weight' ,'Set the default font weight for item print labels. Please use the CSS specification for values for font-weight. For example, "normal", "bold", "bolder", or "lighter"' ,'coust' ,'description' ) ,'string' ), ( ---------------------------------------- 'webstaff.cat.label.left_label.left_margin' ,'cat' ,oils_i18n_gettext( 'webstaff.cat.label.left_label.left_margin' ,'Item Print Label - Left Margin for Left Label' ,'coust' ,'label' ) ,oils_i18n_gettext( 'webstaff.cat.label.left_label.left_margin' ,'Set the default left margin for the leftmost item print Label. Please include a unit of measurement that is valid CSS. For example, "1in" or "2.5cm"' ,'coust' ,'description' ) ,'string' ), ( ---------------------------------------- 'webstaff.cat.label.right_label.left_margin' ,'cat' ,oils_i18n_gettext( 'webstaff.cat.label.right_label.left_margin' ,'Item Print Label - Left Margin for Right Label' ,'coust' ,'label' ) ,oils_i18n_gettext( 'webstaff.cat.label.right_label.left_margin' ,'Set the default left margin for the rightmost item print label (or in other words, the desired space between the two labels). Please include a unit of measurement that is valid CSS. For example, "1in" or "2.5cm"' ,'coust' ,'description' ) ,'string' ), ( ---------------------------------------- 'webstaff.cat.label.left_label.height' ,'cat' ,oils_i18n_gettext( 'webstaff.cat.label.left_label.height' ,'Item Print Label - Height for Left Label' ,'coust' ,'label' ) ,oils_i18n_gettext( 'webstaff.cat.label.left_label.height' ,'Set the default height for the leftmost item print label. Please include a unit of measurement that is valid CSS. For example, "1in" or "2.5cm"' ,'coust' ,'description' ) ,'string' ), ( ---------------------------------------- 'webstaff.cat.label.left_label.width' ,'cat' ,oils_i18n_gettext( 'webstaff.cat.label.left_label.width' ,'Item Print Label - Width for Left Label' ,'coust' ,'label' ) ,oils_i18n_gettext( 'webstaff.cat.label.left_label.width' ,'Set the default width for the leftmost item print label. Please include a unit of measurement that is valid CSS. For example, "1in" or "2.5cm"' ,'coust' ,'description' ) ,'string' ), ( ---------------------------------------- 'webstaff.cat.label.right_label.height' ,'cat' ,oils_i18n_gettext( 'webstaff.cat.label.right_label.height' ,'Item Print Label - Height for Right Label' ,'coust' ,'label' ) ,oils_i18n_gettext( 'webstaff.cat.label.right_label.height' ,'Set the default height for the rightmost item print label. Please include a unit of measurement that is valid CSS. For example, "1in" or "2.5cm"' ,'coust' ,'description' ) ,'string' ), ( ---------------------------------------- 'webstaff.cat.label.right_label.width' ,'cat' ,oils_i18n_gettext( 'webstaff.cat.label.right_label.width' ,'Item Print Label - Width for Right Label' ,'coust' ,'label' ) ,oils_i18n_gettext( 'webstaff.cat.label.right_label.width' ,'Set the default width for the rightmost item print label. Please include a unit of measurement that is valid CSS. For example, "1in" or "2.5cm"' ,'coust' ,'description' ) ,'string' ), ( 'webstaff.cat.label.inline_css' ,'cat' ,oils_i18n_gettext( 'webstaff.cat.label.inline_css' ,'Item Print Label - Inline CSS' ,'coust' ,'label' ) ,oils_i18n_gettext( 'webstaff.cat.label.inline_css' ,'This setting allows you to inject arbitrary CSS into the item print label template. For example, ".printlabel { text-transform: uppercase; }"' ,'coust' ,'description' ) ,'string' ), ( 'webstaff.cat.label.call_number_wrap_filter_height' ,'cat' ,oils_i18n_gettext( 'webstaff.cat.label.call_number_wrap_filter_height' ,'Item Print Label - Call Number Wrap Filter Height' ,'coust' ,'label' ) ,oils_i18n_gettext( 'webstaff.cat.label.call_number_wrap_filter_height' ,'This setting is used to set the default height (in number of lines) to use for call number wrapping in the left print label.' ,'coust' ,'description' ) ,'integer' ), ( 'webstaff.cat.label.call_number_wrap_filter_width' ,'cat' ,oils_i18n_gettext( 'webstaff.cat.label.call_number_wrap_filter_width' ,'Item Print Label - Call Number Wrap Filter Width' ,'coust' ,'label' ) ,oils_i18n_gettext( 'webstaff.cat.label.call_number_wrap_filter_width' ,'This setting is used to set the default width (in number of characters) to use for call number wrapping in the left print label.' ,'coust' ,'description' ) ,'integer' ); INSERT INTO config.global_flag (name, label, value, enabled) VALUES ( 'circ.holds.retarget_interval', oils_i18n_gettext( 'circ.holds.retarget_interval', 'Holds Retarget Interval', 'cgf', 'label' ), '24h', TRUE ); INSERT INTO config.global_flag (name, label, enabled) VALUES ( 'opac.show_related_headings_in_browse', oils_i18n_gettext( 'opac.show_related_headings_in_browse', 'Display related headings (see-also) in browse', 'cgf', 'label' ), TRUE ); INSERT INTO config.settings_group (name, label) VALUES ('ebook_api', oils_i18n_gettext('ebook_api', 'Ebook API Integration', 'csg', 'label')); INSERT INTO config.org_unit_setting_type (name, label, description, grp, datatype) VALUES ( 'ebook_api.overdrive.discovery_base_uri', oils_i18n_gettext( 'ebook_api.overdrive.discovery_base_uri', 'OverDrive Discovery API Base URI', 'coust', 'label' ), oils_i18n_gettext( 'ebook_api.overdrive.discovery_base_uri', 'Base URI for OverDrive Discovery API (defaults to https://api.overdrive.com/v1). Using HTTPS here is strongly encouraged.', 'coust', 'description' ), 'ebook_api', 'string' ),( 'ebook_api.overdrive.circulation_base_uri', oils_i18n_gettext( 'ebook_api.overdrive.circulation_base_uri', 'OverDrive Circulation API Base URI', 'coust', 'label' ), oils_i18n_gettext( 'ebook_api.overdrive.circulation_base_uri', 'Base URI for OverDrive Circulation API (defaults to https://patron.api.overdrive.com/v1). Using HTTPS here is strongly encouraged.', 'coust', 'description' ), 'ebook_api', 'string' ),( 'ebook_api.overdrive.account_id', oils_i18n_gettext( 'ebook_api.overdrive.account_id', 'OverDrive Account ID', 'coust', 'label' ), oils_i18n_gettext( 'ebook_api.overdrive.account_id', 'Account ID (a.k.a. Library ID) for this library, as assigned by OverDrive', 'coust', 'description' ), 'ebook_api', 'string' ),( 'ebook_api.overdrive.websiteid', oils_i18n_gettext( 'ebook_api.overdrive.websiteid', 'OverDrive Website ID', 'coust', 'label' ), oils_i18n_gettext( 'ebook_api.overdrive.websiteid', 'Website ID for this library, as assigned by OverDrive', 'coust', 'description' ), 'ebook_api', 'string' ),( 'ebook_api.overdrive.authorizationname', oils_i18n_gettext( 'ebook_api.overdrive.authorizationname', 'OverDrive Authorization Name', 'coust', 'label' ), oils_i18n_gettext( 'ebook_api.overdrive.authorizationname', 'Authorization name for this library, as assigned by OverDrive', 'coust', 'description' ), 'ebook_api', 'string' ),( 'ebook_api.overdrive.basic_token', oils_i18n_gettext( 'ebook_api.overdrive.basic_token', 'OverDrive Basic Token', 'coust', 'label' ), oils_i18n_gettext( 'ebook_api.overdrive.basic_token', 'Basic token for client authentication with OverDrive API (supplied by OverDrive)', 'coust', 'description' ), 'ebook_api', 'string' ),( 'ebook_api.overdrive.granted_auth_redirect_uri', oils_i18n_gettext( 'ebook_api.overdrive.granted_auth_redirect_uri', 'OverDrive Granted Authorization Redirect URI', 'coust', 'label' ), oils_i18n_gettext( 'ebook_api.overdrive.granted_auth_redirect_uri', 'URI provided to OverDrive for use with granted authorization', 'coust', 'description' ), 'ebook_api', 'string' ),( 'ebook_api.overdrive.password_required', oils_i18n_gettext( 'ebook_api.overdrive.password_required', 'OverDrive Password Required', 'coust', 'label' ), oils_i18n_gettext( 'ebook_api.overdrive.password_required', 'Does this library require a password when authenticating patrons with the OverDrive API?', 'coust', 'description' ), 'ebook_api', 'bool' ); INSERT INTO config.org_unit_setting_type (name, label, description, grp, datatype) VALUES ( 'ebook_api.oneclickdigital.base_uri', oils_i18n_gettext( 'ebook_api.oneclickdigital.base_uri', 'OneClickdigital Base URI', 'coust', 'label' ), oils_i18n_gettext( 'ebook_api.oneclickdigital.base_uri', 'Base URI for OneClickdigital API (defaults to https://api.oneclickdigital.com/v1). Using HTTPS here is strongly encouraged.', 'coust', 'description' ), 'ebook_api', 'string' ),( 'ebook_api.oneclickdigital.library_id', oils_i18n_gettext( 'ebook_api.oneclickdigital.library_id', 'OneClickdigital Library ID', 'coust', 'label' ), oils_i18n_gettext( 'ebook_api.oneclickdigital.library_id', 'Identifier assigned to this library by OneClickdigital', 'coust', 'description' ), 'ebook_api', 'string' ),( 'ebook_api.oneclickdigital.basic_token', oils_i18n_gettext( 'ebook_api.oneclickdigital.basic_token', 'OneClickdigital Basic Token', 'coust', 'label' ), oils_i18n_gettext( 'ebook_api.oneclickdigital.basic_token', 'Basic token for client authentication with OneClickdigital API (supplied by OneClickdigital)', 'coust', 'description' ), 'ebook_api', 'string' ); INSERT into config.org_unit_setting_type ( name ,grp ,label ,description ,datatype ) VALUES ( ---------------------------------------- 'webstaff.format.dates' ,'gui' ,oils_i18n_gettext( 'webstaff.format.dates' ,'Format Dates with this pattern' ,'coust' ,'label' ) ,oils_i18n_gettext( 'webstaff.format.dates' ,'Format Dates with this pattern (examples: "yyyy-MM-dd" for "2010-04-26", "MMM d, yyyy" for "Apr 26, 2010"). This will be used in areas where a date without a timestamp is sufficient, like Date of Birth.' ,'coust' ,'description' ) ,'string' ), ( ---------------------------------------- 'webstaff.format.date_and_time' ,'gui' ,oils_i18n_gettext( 'webstaff.format.date_and_time' ,'Format Date+Time with this pattern' ,'coust' ,'label' ) ,oils_i18n_gettext( 'webstaff.format.date_and_time' ,'Format Date+Time with this pattern (examples: "yy-MM-dd h:m:s.SSS a" for "16-04-05 2:07:20.666 PM", "yyyy-dd-MMM HH:mm" for "2016-05-Apr 14:07"). This will be used in areas of the client where a date with a timestamp is needed, like Checkout, Due Date, or Record Created.' ,'coust' ,'description' ) ,'string' ); INSERT INTO config.org_unit_setting_type (name, label, description, grp, datatype) VALUES ( 'opac.search.enable_bookplate_search', oils_i18n_gettext( 'opac.search.enable_bookplate_search', 'Enable Digital Bookplate Search', 'coust', 'label' ), oils_i18n_gettext( 'opac.search.enable_bookplate_search', 'If enabled, adds a "Digital Bookplate" option to the query type selectors in the public catalog for search on copy tags.', 'coust', 'description' ), 'opac', 'bool' ); INSERT INTO config.copy_tag_type (code, label, owner) VALUES ('bookplate', 'Digital Bookplate', 1); INSERT into config.org_unit_setting_type ( name, grp, label, description, datatype ) VALUES ( 'lib.timezone', 'lib', oils_i18n_gettext('lib.timezone', 'Library time zone', 'coust', 'label'), oils_i18n_gettext('lib.timezone', 'Define the time zone in which a library physically resides', 'coust', 'description'), 'string'); INSERT INTO config.org_unit_setting_type (name, label, description, grp, datatype) VALUES ( 'ui.staff.max_recent_patrons', oils_i18n_gettext( 'ui.staff.max_recent_patrons', 'Number of Retrievable Recent Patrons', 'coust', 'label' ), oils_i18n_gettext( 'ui.staff.max_recent_patrons', 'Number of most recently accessed patrons that can be re-retrieved ' || 'in the staff client. A value of 0 or less disables the feature. Defaults to 1.', 'coust', 'description' ), 'circ', 'integer' ); -- -- seed data for new-style copy alerts -- -- staff-usable alert types with no location awareness INSERT INTO config.copy_alert_type (id, scope_org, active, name, state, event, in_renew) VALUES (1, 1, TRUE, 'Normal checkout', 'NORMAL', 'CHECKOUT', FALSE); INSERT INTO config.copy_alert_type (id, scope_org, active, name, state, event, in_renew) VALUES (2, 1, TRUE, 'Normal checkin', 'NORMAL', 'CHECKIN', FALSE); INSERT INTO config.copy_alert_type (id, scope_org, active, name, state, event, in_renew) VALUES (3, 1, FALSE, 'Normal renewal', 'NORMAL', 'CHECKIN', TRUE); -- copy alerts upon checkin or renewal of exceptional copy statuses are active by -- default; users who are not yet using the web staff client for circulation may -- want to turn them off INSERT INTO config.copy_alert_type (id, scope_org, active, name, state, event) VALUES (4, 1, TRUE, 'Checkin of lost copy', 'LOST', 'CHECKIN'); INSERT INTO config.copy_alert_type (id, scope_org, active, name, state, event) VALUES (5, 1, TRUE, 'Checkin of missing copy', 'MISSING', 'CHECKIN'); INSERT INTO config.copy_alert_type (id, scope_org, active, name, state, event) VALUES (6, 1, TRUE, 'Checkin of lost-and-paid copy', 'LOST_AND_PAID', 'CHECKIN'); INSERT INTO config.copy_alert_type (id, scope_org, active, name, state, event) VALUES (7, 1, TRUE, 'Checkin of damaged copy', 'DAMAGED', 'CHECKIN'); INSERT INTO config.copy_alert_type (id, scope_org, active, name, state, event) VALUES (8, 1, TRUE, 'Checkin of claims-returned copy', 'CLAIMSRETURNED', 'CHECKIN'); INSERT INTO config.copy_alert_type (id, scope_org, active, name, state, event) VALUES (9, 1, TRUE, 'Checkin of long overdue copy', 'LONGOVERDUE', 'CHECKIN'); INSERT INTO config.copy_alert_type (id, scope_org, active, name, state, event) VALUES (10, 1, TRUE, 'Checkin of claims-never-checked-out copy', 'CLAIMSNEVERCHECKEDOUT', 'CHECKIN'); -- copy alerts upon checkout of exceptional copy statuses are active by -- default; users who are not yet using the web staff client for circulation may -- want to turn them off INSERT INTO config.copy_alert_type (id, scope_org, active, name, state, event) VALUES (11, 1, TRUE, 'Checkout of lost copy', 'LOST', 'CHECKOUT'); INSERT INTO config.copy_alert_type (id, scope_org, active, name, state, event) VALUES (12, 1, TRUE, 'Checkout of missing copy', 'MISSING', 'CHECKOUT'); INSERT INTO config.copy_alert_type (id, scope_org, active, name, state, event) VALUES (13, 1, TRUE, 'Checkout of lost-and-paid copy', 'LOST_AND_PAID', 'CHECKOUT'); INSERT INTO config.copy_alert_type (id, scope_org, active, name, state, event) VALUES (14, 1, TRUE, 'Checkout of damaged copy', 'DAMAGED', 'CHECKOUT'); INSERT INTO config.copy_alert_type (id, scope_org, active, name, state, event) VALUES (15, 1, TRUE, 'Checkout of claims-returned copy', 'CLAIMSRETURNED', 'CHECKOUT'); INSERT INTO config.copy_alert_type (id, scope_org, active, name, state, event) VALUES (16, 1, TRUE, 'Checkout of long overdue copy', 'LONGOVERDUE', 'CHECKOUT'); INSERT INTO config.copy_alert_type (id, scope_org, active, name, state, event) VALUES (17, 1, TRUE, 'Checkout of claims-never-checked-out copy', 'CLAIMSNEVERCHECKEDOUT', 'CHECKOUT'); -- staff-usable alert types based on location INSERT INTO config.copy_alert_type (id, scope_org, active, name, state, event, in_renew, at_circ) VALUES (18, 1, FALSE, 'Normal checkout at circ lib', 'NORMAL', 'CHECKOUT', FALSE, TRUE); INSERT INTO config.copy_alert_type (id, scope_org, active, name, state, event, in_renew, at_circ) VALUES (19, 1, FALSE, 'Normal checkin at circ lib', 'NORMAL', 'CHECKIN', FALSE, TRUE); INSERT INTO config.copy_alert_type (id, scope_org, active, name, state, event, in_renew, at_circ) VALUES (20, 1, FALSE, 'Normal renewal at circ lib', 'NORMAL', 'CHECKIN', TRUE, TRUE); INSERT INTO config.copy_alert_type (id, scope_org, active, name, state, event, in_renew, at_owning) VALUES (21, 1, FALSE, 'Normal checkout at owning lib', 'NORMAL', 'CHECKOUT', FALSE, TRUE); INSERT INTO config.copy_alert_type (id, scope_org, active, name, state, event, in_renew, at_owning) VALUES (22, 1, FALSE, 'Normal checkin at owning lib', 'NORMAL', 'CHECKIN', FALSE, TRUE); INSERT INTO config.copy_alert_type (id, scope_org, active, name, state, event, in_renew, at_owning) VALUES (23, 1, FALSE, 'Normal renewal at owning lib', 'NORMAL', 'CHECKIN', TRUE, TRUE); -- OU settings related to copy alerts INSERT INTO config.org_unit_setting_type (name, grp, label, description, datatype) VALUES ('circ.copy_alerts.forgive_fines_on_lost_checkin', 'circ', oils_i18n_gettext('circ.copy_alerts.forgive_fines_on_lost_checkin', 'Forgive fines when checking out a lost item and copy alert is suppressed?', 'coust', 'label'), oils_i18n_gettext('circ.copy_alerts.forgive_fines_on_lost_checkin', 'Controls whether fines are automatically forgiven when checking out an '|| 'item that has been marked as lost, and the corresponding copy alert has been '|| 'suppressed.', 'coust', 'description'), 'bool'); INSERT INTO config.org_unit_setting_type (name, grp, label, description, datatype) VALUES ('circ.copy_alerts.forgive_fines_on_long_overdue_checkin', 'circ', oils_i18n_gettext('circ.copy_alerts.forgive_fines_on_long_overdue_checkin', 'Forgive fines when checking out a long-overdue item and copy alert is suppressed?', 'coust', 'label'), oils_i18n_gettext('circ.copy_alerts.forgive_fines_on_long_overdue_checkin', 'Controls whether fines are automatically forgiven when checking out an '|| 'item that has been marked as long-overdue, and the corresponding copy alert has been '|| 'suppressed.', 'coust', 'description'), 'bool'); INSERT INTO acq.edi_attr (key, label) VALUES ('INCLUDE_PO_NAME', oils_i18n_gettext('INCLUDE_PO_NAME', 'Orders Include PO Name', 'aea', 'label')), ('INCLUDE_COPIES', oils_i18n_gettext('INCLUDE_COPIES', 'Orders Include Copy Data', 'aea', 'label')), ('INCLUDE_FUND', oils_i18n_gettext('INCLUDE_FUND', 'Orders Include Copy Funds', 'aea', 'label')), ('INCLUDE_CALL_NUMBER', oils_i18n_gettext('INCLUDE_CALL_NUMBER', 'Orders Include Copy Call Numbers', 'aea', 'label')), ('INCLUDE_ITEM_TYPE', oils_i18n_gettext('INCLUDE_ITEM_TYPE', 'Orders Include Copy Item Types', 'aea', 'label')), ('INCLUDE_ITEM_BARCODE', oils_i18n_gettext('INCLUDE_ITEM_BARCODE', 'Orders Include Copy Barcodes', 'aea', 'label')), ('INCLUDE_LOCATION', oils_i18n_gettext('INCLUDE_LOCATION', 'Orders Include Copy Locations', 'aea', 'label')), ('INCLUDE_COLLECTION_CODE', oils_i18n_gettext('INCLUDE_COLLECTION_CODE', 'Orders Include Copy Collection Codes', 'aea', 'label')), ('INCLUDE_OWNING_LIB', oils_i18n_gettext('INCLUDE_OWNING_LIB', 'Orders Include Copy Owning Library', 'aea', 'label')), ('USE_ID_FOR_OWNING_LIB', oils_i18n_gettext('USE_ID_FOR_OWNING_LIB', 'Emit Owning Library ID Rather Than Short Name. Takes effect only if INCLUDE_OWNING_LIB is in use', 'aea', 'label')), ('INCLUDE_QUANTITY', oils_i18n_gettext('INCLUDE_QUANTITY', 'Orders Include Copy Quantities', 'aea', 'label')), ('INCLUDE_COPY_ID', oils_i18n_gettext('INCLUDE_COPY_ID', 'Orders Include Copy IDs', 'aea', 'label')), ('BUYER_ID_INCLUDE_VENDCODE', oils_i18n_gettext('BUYER_ID_INCLUDE_VENDCODE', 'Buyer ID Qualifier Includes Vendcode', 'aea', 'label')), ('BUYER_ID_ONLY_VENDCODE', oils_i18n_gettext('BUYER_ID_ONLY_VENDCODE', 'Buyer ID Qualifier Only Contains Vendcode', 'aea', 'label')), ('INCLUDE_BIB_EDITION', oils_i18n_gettext('INCLUDE_BIB_EDITION', 'Order Lineitems Include Edition Info', 'aea', 'label')), ('INCLUDE_BIB_AUTHOR', oils_i18n_gettext('INCLUDE_BIB_AUTHOR', 'Order Lineitems Include Author Info', 'aea', 'label')), ('INCLUDE_BIB_PAGINATION', oils_i18n_gettext('INCLUDE_BIB_PAGINATION', 'Order Lineitems Include Pagination Info', 'aea', 'label')), ('COPY_SPEC_CODES', oils_i18n_gettext('COPY_SPEC_CODES', 'Order Lineitem Notes Include Copy Spec Codes', 'aea', 'label')), ('INCLUDE_EMPTY_IMD_VALUES', oils_i18n_gettext('INCLUDE_EMPTY_IMD_VALUES', 'Lineitem Title, Author, etc. Fields Are Present Even if Empty', 'aea', 'label')), ('INCLUDE_EMPTY_LI_NOTE', oils_i18n_gettext('INCLUDE_EMPTY_LI_NOTE', 'Order Lineitem Notes Always Present (Even if Empty)', 'aea', 'label')), ('INCLUDE_EMPTY_CALL_NUMBER', oils_i18n_gettext('INCLUDE_EMPTY_CALL_NUMBER', 'Order Copies Always Include Call Number (Even if Empty)', 'aea', 'label')), ('INCLUDE_EMPTY_ITEM_TYPE', oils_i18n_gettext('INCLUDE_EMPTY_ITEM_TYPE', 'Order Copies Always Include Item Type (Even if Empty)', 'aea', 'label')), ('INCLUDE_EMPTY_LOCATION', oils_i18n_gettext('INCLUDE_EMPTY_LOCATION', 'Order Copies Always Include Location (Even if Empty)', 'aea', 'label')), ('INCLUDE_EMPTY_COLLECTION_CODE', oils_i18n_gettext('INCLUDE_EMPTY_COLLECTION_CODE', 'Order Copies Always Include Collection Code (Even if Empty)', 'aea', 'label')), ('LINEITEM_IDENT_VENDOR_NUMBER', oils_i18n_gettext('LINEITEM_IDENT_VENDOR_NUMBER', 'Lineitem Identifier Fields (LIN/PIA) Use Vendor-Encoded ID Value When Available', 'aea', 'label')), ('LINEITEM_REF_ID_ONLY', oils_i18n_gettext('LINEITEM_REF_ID_ONLY', 'Lineitem Reference Field (RFF) Uses Lineitem ID Only', 'aea', 'label')) ; INSERT INTO acq.edi_attr_set (id, label) VALUES (1, 'Ingram Default'); INSERT INTO acq.edi_attr_set (id, label) VALUES (2, 'Baker & Taylor Default'); INSERT INTO acq.edi_attr_set (id, label) VALUES (3, 'Brodart Default'); INSERT INTO acq.edi_attr_set (id, label) VALUES (4, 'Midwest Tape Default'); INSERT INTO acq.edi_attr_set (id, label) VALUES (5, 'ULS Default'); INSERT INTO acq.edi_attr_set (id, label) VALUES (6, 'Recorded Books Default'); INSERT INTO acq.edi_attr_set (id, label) VALUES (7, 'Midwest Library Service'); -- carve out space for mucho defaults SELECT SETVAL('acq.edi_attr_set_id_seq'::TEXT, 1000); INSERT INTO acq.edi_attr_set_map (attr_set, attr) VALUES -- Ingram (1, 'INCLUDE_PO_NAME'), (1, 'INCLUDE_COPIES'), (1, 'INCLUDE_ITEM_TYPE'), (1, 'INCLUDE_COLLECTION_CODE'), (1, 'INCLUDE_OWNING_LIB'), (1, 'INCLUDE_QUANTITY'), (1, 'INCLUDE_BIB_PAGINATION'), -- B&T (2, 'INCLUDE_COPIES'), (2, 'INCLUDE_ITEM_TYPE'), (2, 'INCLUDE_COLLECTION_CODE'), (2, 'INCLUDE_CALL_NUMBER'), (2, 'INCLUDE_OWNING_LIB'), (2, 'INCLUDE_QUANTITY'), (2, 'INCLUDE_BIB_PAGINATION'), (2, 'BUYER_ID_INCLUDE_VENDCODE'), (2, 'INCLUDE_EMPTY_LI_NOTE'), (2, 'INCLUDE_EMPTY_CALL_NUMBER'), (2, 'INCLUDE_EMPTY_ITEM_TYPE'), (2, 'INCLUDE_EMPTY_COLLECTION_CODE'), (2, 'INCLUDE_EMPTY_LOCATION'), (2, 'LINEITEM_IDENT_VENDOR_NUMBER'), (2, 'LINEITEM_REF_ID_ONLY'), -- Brodart (3, 'INCLUDE_COPIES'), (3, 'INCLUDE_FUND'), (3, 'INCLUDE_ITEM_TYPE'), (3, 'INCLUDE_COLLECTION_CODE'), (3, 'INCLUDE_OWNING_LIB'), (3, 'INCLUDE_QUANTITY'), (3, 'INCLUDE_BIB_PAGINATION'), (3, 'COPY_SPEC_CODES'), -- Midwest (4, 'INCLUDE_COPIES'), (4, 'INCLUDE_FUND'), (4, 'INCLUDE_OWNING_LIB'), (4, 'INCLUDE_QUANTITY'), (4, 'INCLUDE_BIB_PAGINATION'), -- ULS (5, 'INCLUDE_COPIES'), (5, 'INCLUDE_ITEM_TYPE'), (5, 'INCLUDE_COLLECTION_CODE'), (5, 'INCLUDE_OWNING_LIB'), (5, 'INCLUDE_QUANTITY'), (5, 'INCLUDE_BIB_AUTHOR'), (5, 'INCLUDE_BIB_EDITION'), (5, 'INCLUDE_EMPTY_LI_NOTE'), -- Recorded Books (6, 'INCLUDE_COPIES'), (6, 'INCLUDE_ITEM_TYPE'), (6, 'INCLUDE_COLLECTION_CODE'), (6, 'INCLUDE_OWNING_LIB'), (6, 'INCLUDE_QUANTITY'), (6, 'INCLUDE_BIB_PAGINATION'), -- Midwest Library Service (7, 'INCLUDE_BIB_AUTHOR'), (7, 'INCLUDE_BIB_EDITION'), (7, 'BUYER_ID_ONLY_VENDCODE'), (7, 'INCLUDE_EMPTY_IMD_VALUES') ; INSERT INTO authority.thesaurus (code, short_code, name, control_set) VALUES ('n', 'n', oils_i18n_gettext('n','Not applicable','at','name'), 1), ('|', '|', oils_i18n_gettext('|','No attempt to code','at','name'), NULL), (' ', ' ', oils_i18n_gettext(' ','Alternate no attempt to code','at','name'), NULL); CREATE TEMP TABLE thesauri (code text, uri text, name text, xlate hstore); COPY thesauri (code, uri, name, xlate) FROM STDIN; migfg http://id.loc.gov/vocabulary/genreFormSchemes/migfg Moving image genre-form guide reveal http://id.loc.gov/vocabulary/genreFormSchemes/reveal REVEAL: fiction indexing and genre headings dct http://id.loc.gov/vocabulary/genreFormSchemes/dct Dublin Core list of resource types gmgpc http://id.loc.gov/vocabulary/genreFormSchemes/gmgpc Thesaurus for graphic materials: TGM II, Genre and physical characteristic terms rbgenr http://id.loc.gov/vocabulary/genreFormSchemes/rbgenr Genre terms: a thesaurus for use in rare book and special collections cataloguing sgp http://id.loc.gov/vocabulary/genreFormSchemes/sgp Svenska genrebeteckningar fr periodika "sv"=>"Svenska genrebeteckningar fr periodika" estc http://id.loc.gov/vocabulary/genreFormSchemes/estc Eighteenth century short title catalogue, the cataloguing rules. New ed. ftamc http://id.loc.gov/vocabulary/genreFormSchemes/ftamc Form terms for archival and manuscripts control alett http://id.loc.gov/vocabulary/genreFormSchemes/alett An alphabetical list of English text types gtlm http://id.loc.gov/vocabulary/genreFormSchemes/gtlm Genre terms for law materials: a thesaurus rbprov http://id.loc.gov/vocabulary/genreFormSchemes/rbprov Provenance evidence: a thesaurus for use in rare book and special collections cataloging rbbin http://id.loc.gov/vocabulary/genreFormSchemes/rbbin Binding terms: a thesaurus for use in rare book and special collections cataloguing fbg http://id.loc.gov/vocabulary/genreFormSchemes/fbg Films by genre /dd> isbdmedia http://id.loc.gov/vocabulary/genreFormSchemes/isbdmedia ISBD Area 0 [media] marccategory http://id.loc.gov/vocabulary/genreFormSchemes/marccategory MARC form category term list gnd-music http://id.loc.gov/vocabulary/genreFormSchemes/gnd-music Gemeinsame Normdatei: Musikalische Ausgabeform proysen http://id.loc.gov/vocabulary/genreFormSchemes/proysen Prøysen: emneord for Prøysen-bibliografien rdacarrier http://id.loc.gov/vocabulary/genreFormSchemes/rdacarrier Term and code list for RDA carrier types gnd http://id.loc.gov/vocabulary/genreFormSchemes/gnd Gemeinsame Normdatei cjh http://id.loc.gov/vocabulary/genreFormSchemes/cjh Center for Jewish History thesaurus rbpri http://id.loc.gov/vocabulary/genreFormSchemes/rbpri Printing & publishing evidence: a thesaurus for use in rare book and special collections cataloging fgtpcm http://id.loc.gov/vocabulary/genreFormSchemes/fgtpcm Form/genre terms for printed cartoon material rbpub http://id.loc.gov/vocabulary/genreFormSchemes/rbpub Printing and publishing evidence: a thesaurus for use in rare book and special collections cataloging gmd http://id.loc.gov/vocabulary/genreFormSchemes/gmd Anglo-American Cataloguing Rules general material designation rbpap http://id.loc.gov/vocabulary/genreFormSchemes/rbpap Paper terms: a thesaurus for use in rare book and special collections cataloging rdamedia http://id.loc.gov/vocabulary/genreFormSchemes/rdamedia Term and code list for RDA media types marcsmd http://id.loc.gov/vocabulary/genreFormSchemes/marcsmd MARC specific material form term list saogf http://id.loc.gov/vocabulary/genreFormSchemes/saogf Svenska ämnesord - Genre/Form "sv"=>"Svenska ämnesord - Genre/Form" lcgft http://id.loc.gov/vocabulary/genreFormSchemes/lcgft Library of Congress genre/form terms for library and archival materials muzeukv http://id.loc.gov/vocabulary/genreFormSchemes/muzeukv MuzeVideo UK DVD and UMD film genre classification mim http://id.loc.gov/vocabulary/genreFormSchemes/mim Moving image materials: genre terms nmc http://id.loc.gov/vocabulary/genreFormSchemes/nmc Revised nomenclature for museum cataloging: a revised and expanded version of Robert C. Chenhall's system for classifying man-made objects gnd-content http://id.loc.gov/vocabulary/genreFormSchemes/gnd-content Gemeinsame Normdatei: Beschreibung des Inhalts bgtchm http://id.loc.gov/vocabulary/genreFormSchemes/bgtchm Basic genre terms for cultural heritage materials gsafd http://id.loc.gov/vocabulary/genreFormSchemes/gsafd Guidelines on subject access to individual works of fiction, drama, etc marcform http://id.loc.gov/vocabulary/genreFormSchemes/marcform MARC form of item term list marcgt http://id.loc.gov/vocabulary/genreFormSchemes/marcgt MARC genre terms barngf http://id.loc.gov/vocabulary/genreFormSchemes/barngf Svenska ämnesord för barn - Genre/Form "sv"=>"Svenska ämnesord för barn - Genre/Form" ngl http://id.loc.gov/vocabulary/genreFormSchemes/ngl Newspaper genre list rvmgf http://id.loc.gov/vocabulary/genreFormSchemes/rvmgf Thésaurus des descripteurs de genre/forme de l'Université Laval "fr"=>"Thésaurus des descripteurs de genre/forme de l'Université Laval" tgfbne http://id.loc.gov/vocabulary/genreFormSchemes/tgfbne Términos de género/forma de la Biblioteca Nacional de España nbdbgf http://id.loc.gov/vocabulary/genreFormSchemes/nbdbgf NBD Biblion Genres Fictie rbtyp http://id.loc.gov/vocabulary/genreFormSchemes/rbtyp Type evidence: a thesaurus for use in rare book and special collections cataloging radfg http://id.loc.gov/vocabulary/genreFormSchemes/radfg Radio form / genre terms guide gnd-carrier http://id.loc.gov/vocabulary/genreFormSchemes/gnd-carrier Gemeinsame Normdatei: Datenträgertyp gatbeg http://id.loc.gov/vocabulary/genreFormSchemes/gatbeg Gattungsbegriffe "de"=>"Gattungsbegriffe" rdacontent http://id.loc.gov/vocabulary/genreFormSchemes/rdacontent Term and code list for RDA content types isbdcontent http://id.loc.gov/vocabulary/genreFormSchemes/isbdcontent ISBD Area 0 [content] nimafc http://id.loc.gov/vocabulary/genreFormSchemes/nimafc NIMA form codes amg http://id.loc.gov/vocabulary/genreFormSchemes/amg Audiovisual material glossary local http://id.loc.gov/vocabulary/subjectSchemes/local Locally assigned term taika http://id.loc.gov/vocabulary/subjectSchemes/taika Taideteollisuuden asiasanasto "fi"=>"Taideteollisuuden asiasanasto" nasat http://id.loc.gov/vocabulary/subjectSchemes/nasat NASA thesaurus rswkaf http://id.loc.gov/vocabulary/subjectSchemes/rswkaf Alternativform zum Hauptschlagwort "de"=>"Alternativform zum Hauptschlagwort" jhpk http://id.loc.gov/vocabulary/subjectSchemes/jhpk JÄzyk haseÅ przedmiotowych KABA "pl"=>"JÄzyk haseÅ przedmiotowych KABA" asrcrfcd http://id.loc.gov/vocabulary/subjectSchemes/asrcrfcd Australian Standard Research Classification: Research Fields, Courses and Disciplines (RFCD) classification bt http://id.loc.gov/vocabulary/subjectSchemes/bt Bioethics thesaurus lcstt http://id.loc.gov/vocabulary/subjectSchemes/lcstt List of Chinese subject terms netc http://id.loc.gov/vocabulary/subjectSchemes/netc National Emergency Training Center Thesaurus (NETC) aat http://id.loc.gov/vocabulary/subjectSchemes/aat Art & architecture thesaurus bet http://id.loc.gov/vocabulary/subjectSchemes/bet British education thesaurus ncjt http://id.loc.gov/vocabulary/subjectSchemes/ncjt National criminal justice thesaurus samisk http://id.loc.gov/vocabulary/subjectSchemes/samisk Sami bibliography "no"=>"Sámi bibliografia = Samisk bibliografi (Norge)" tips http://id.loc.gov/vocabulary/subjectSchemes/tips Tesauro ISOC de psicologÃa "es"=>"Tesauro ISOC de psicologÃa" ukslc http://id.loc.gov/vocabulary/subjectSchemes/ukslc UK Standard Library Categories tekord http://id.loc.gov/vocabulary/subjectSchemes/tekord TEK-ord : UBiTs emneordliste for arkitektur, realfag, og teknolog "no"=>"TEK-ord : UBiTs emneordliste for arkitektur, realfag, og teknolog" umitrist http://id.loc.gov/vocabulary/subjectSchemes/umitrist University of Michigan Transportation Research Institute structured thesaurus wgst http://id.loc.gov/vocabulary/subjectSchemes/wgst Washington GILS Subject Tree rasuqam http://id.loc.gov/vocabulary/subjectSchemes/rasuqam Répertoire d'autorités-sujet de l'UQAM "fr"=>"Répertoire d'autorités-sujet de l'UQAM" ntids http://id.loc.gov/vocabulary/subjectSchemes/ntids Norske tidsskrifter 1700-1820: emneord "no"=>"Norske tidsskrifter 1700-1820: emneord" kaa http://id.loc.gov/vocabulary/subjectSchemes/kaa Kasvatusalan asiasanasto "fi"=>"Kasvatusalan asiasanasto" yso http://id.loc.gov/vocabulary/subjectSchemes/yso YSO - Yleinen suomalainen ontologia "fi"=>"YSO - Yleinen suomalainen ontologia" gcipmedia http://id.loc.gov/vocabulary/subjectSchemes/gcipmedia GAMECIP - Computer Game Media Formats (GAMECIP (Game Metadata and Citation Project)) inspect http://id.loc.gov/vocabulary/subjectSchemes/inspect INSPEC thesaurus ordnok http://id.loc.gov/vocabulary/subjectSchemes/ordnok Ordnokkelen: tesaurus for kulturminnevern "no"=>"Ordnokkelen: tesaurus for kulturminnevern" helecon http://id.loc.gov/vocabulary/subjectSchemes/helecon Asiasanasto HELECON-tietikantoihin "fi"=>"Asiasanasto HELECON-tietikantoihin" dltlt http://id.loc.gov/vocabulary/subjectSchemes/dltlt Cuddon, J. A. A dictionary of literary terms and literary theory csapa http://id.loc.gov/vocabulary/subjectSchemes/csapa "Controlled vocabulary" in Pollution abstracts gtt http://id.loc.gov/vocabulary/subjectSchemes/gtt GOO-trefwoorden thesaurus "nl"=>"GOO-trefwoorden thesaurus" iescs http://id.loc.gov/vocabulary/subjectSchemes/iescs International energy subject categories and scope itrt http://id.loc.gov/vocabulary/subjectSchemes/itrt International Thesaurus of Refugee Terminology sanb http://id.loc.gov/vocabulary/subjectSchemes/sanb South African national bibliography authority file blmlsh http://id.loc.gov/vocabulary/subjectSchemes/blmlsh British Library - Map library subject headings bhb http://id.loc.gov/vocabulary/subjectSchemes/bhb Bibliography of the Hebrew Book csh http://id.loc.gov/vocabulary/subjectSchemes/csh Kapsner, Oliver Leonard. Catholic subject headings fire http://id.loc.gov/vocabulary/subjectSchemes/fire FireTalk, IFSI thesaurus jlabsh http://id.loc.gov/vocabulary/subjectSchemes/jlabsh Basic subject headings "ja"=>"Kihon kenmei hyômokuhyô" udc http://id.loc.gov/vocabulary/subjectSchemes/udc Universal decimal classification lcshac http://id.loc.gov/vocabulary/subjectSchemes/lcshac Children's subject headings in Library of Congress subject headings: supplementary vocabularies geonet http://id.loc.gov/vocabulary/subjectSchemes/geonet NGA GEOnet Names Server (GNS) humord http://id.loc.gov/vocabulary/subjectSchemes/humord HUMORD "no"=>"HUMORD" no-ubo-mr http://id.loc.gov/vocabulary/subjectSchemes/no-ubo-mr Menneskerettighets-tesaurus "no"=>"Menneskerettighets-tesaurus" sgce http://id.loc.gov/vocabulary/subjectSchemes/sgce COBISS.SI General List of subject headings (English subject headings) "sl"=>"SploÅ¡ni geslovnik COBISS.SI" kdm http://id.loc.gov/vocabulary/subjectSchemes/kdm Khung dê muc hê thông thông tin khoa hoc và ky thuât quôc gia "vi"=>"Khung dê muc hê thông thông tin khoa hoc và ky thuât quôc gia" thesoz http://id.loc.gov/vocabulary/subjectSchemes/thesoz Thesaurus for the Social Sciences asth http://id.loc.gov/vocabulary/subjectSchemes/asth Astronomy thesaurus muzeukc http://id.loc.gov/vocabulary/subjectSchemes/muzeukc MuzeMusic UK classical music classification norbok http://id.loc.gov/vocabulary/subjectSchemes/norbok Norbok: emneord i Norsk bokfortegnelse "no"=>"Norbok: emneord i Norsk bokfortegnelse" masa http://id.loc.gov/vocabulary/subjectSchemes/masa Museoalan asiasanasto "fi"=>"Museoalan asiasanasto" conorsi http://id.loc.gov/vocabulary/subjectSchemes/conorsi CONOR.SI (name authority file) (Maribor, Slovenia: Institut informacijskih znanosti (IZUM)) eurovocen http://id.loc.gov/vocabulary/subjectSchemes/eurovocen Eurovoc thesaurus (English) kto http://id.loc.gov/vocabulary/subjectSchemes/kto KTO - Kielitieteen ontologia "fi"=>"KTO - Kielitieteen ontologia" muzvukci http://id.loc.gov/vocabulary/subjectSchemes/muzvukci MuzeVideo UK contributor index kaunokki http://id.loc.gov/vocabulary/subjectSchemes/kaunokki Kaunokki: kaunokirjallisuuden asiasanasto "fi"=>"Kaunokki: kaunokirjallisuuden asiasanasto" maotao http://id.loc.gov/vocabulary/subjectSchemes/maotao MAO/TAO - Ontologi för museibranschen och Konstindustriella ontologin "fi"=>"MAO/TAO - Ontologi för museibranschen och Konstindustriella ontologin" psychit http://id.loc.gov/vocabulary/subjectSchemes/psychit Thesaurus of psychological index terms. tlsh http://id.loc.gov/vocabulary/subjectSchemes/tlsh Subject heading authority list csalsct http://id.loc.gov/vocabulary/subjectSchemes/csalsct CSA life sciences collection thesaurus ciesiniv http://id.loc.gov/vocabulary/subjectSchemes/ciesiniv CIESIN indexing vocabulary ebfem http://id.loc.gov/vocabulary/subjectSchemes/ebfem Encabezamientos bilingües de la Fundación Educativa Ana G. Mendez mero http://id.loc.gov/vocabulary/subjectSchemes/mero MERO - Merenkulkualan ontologia "fi"=>"MERO - Merenkulkualan ontologia" mmm http://id.loc.gov/vocabulary/subjectSchemes/mmm "Subject key" in Marxism and the mass media pascal http://id.loc.gov/vocabulary/subjectSchemes/pascal PASCAL database classification scheme "fr"=>"Base de donneés PASCAL: plan de classement" chirosh http://id.loc.gov/vocabulary/subjectSchemes/chirosh Chiropractic Subject Headings cilla http://id.loc.gov/vocabulary/subjectSchemes/cilla Cilla: specialtesaurus för musik "fi"=>"Cilla: specialtesaurus för musik" aiatsisl http://id.loc.gov/vocabulary/subjectSchemes/aiatsisl AIATSIS language thesaurus nskps http://id.loc.gov/vocabulary/subjectSchemes/nskps PriruÄnik za izradu predmetnog kataloga u Nacionalnoj i sveuÄiliÅ¡noj knjiÄnici u Zagrebu "hr"=>"PriruÄnik za izradu predmetnog kataloga u Nacionalnoj i sveuÄiliÅ¡noj knjiÄnici u Zagrebu" lctgm http://id.loc.gov/vocabulary/subjectSchemes/lctgm Thesaurus for graphic materials: TGM I, Subject terms muso http://id.loc.gov/vocabulary/subjectSchemes/muso MUSO - Ontologi för musik "fi"=>"MUSO - Ontologi för musik" blcpss http://id.loc.gov/vocabulary/subjectSchemes/blcpss COMPASS subject authority system fast http://id.loc.gov/vocabulary/subjectSchemes/fast Faceted application of subject terminology bisacmt http://id.loc.gov/vocabulary/subjectSchemes/bisacmt BISAC Merchandising Themes lapponica http://id.loc.gov/vocabulary/subjectSchemes/lapponica Lapponica "fi"=>"Lapponica" juho http://id.loc.gov/vocabulary/subjectSchemes/juho JUHO - Julkishallinnon ontologia "fi"=>"JUHO - Julkishallinnon ontologia" idas http://id.loc.gov/vocabulary/subjectSchemes/idas ID-Archivschlüssel "de"=>"ID-Archivschlüssel" tbjvp http://id.loc.gov/vocabulary/subjectSchemes/tbjvp Tesauro de la Biblioteca Dr. Jorge Villalobos Padilla, S.J. "es"=>"Tesauro de la Biblioteca Dr. Jorge Villalobos Padilla, S.J." test http://id.loc.gov/vocabulary/subjectSchemes/test Thesaurus of engineering and scientific terms finmesh http://id.loc.gov/vocabulary/subjectSchemes/finmesh FinMeSH "fi"=>"FinMeSH" kssbar http://id.loc.gov/vocabulary/subjectSchemes/kssbar Klassifikationssystem for svenska bibliotek. Ãmnesordregister. Alfabetisk del "sv"=>"Klassifikationssystem for svenska bibliotek. Ãmnesordregister. Alfabetisk del" kupu http://id.loc.gov/vocabulary/subjectSchemes/kupu Maori Wordnet "mi"=>"He puna kupu" rpe http://id.loc.gov/vocabulary/subjectSchemes/rpe Rubricator on economics "ru"=>"Rubrikator po ekonomike" dit http://id.loc.gov/vocabulary/subjectSchemes/dit Defense intelligence thesaurus she http://id.loc.gov/vocabulary/subjectSchemes/she SHE: subject headings for engineering idszbzna http://id.loc.gov/vocabulary/subjectSchemes/idszbzna Thesaurus IDS Nebis Zentralbibliothek Zürich, Nordamerika-Bibliothek "de"=>"Thesaurus IDS Nebis Zentralbibliothek Zürich, Nordamerika-Bibliothek" msc http://id.loc.gov/vocabulary/subjectSchemes/msc Mathematical subject classification muzeukn http://id.loc.gov/vocabulary/subjectSchemes/muzeukn MuzeMusic UK non-classical music classification ipsp http://id.loc.gov/vocabulary/subjectSchemes/ipsp Defense intelligence production schedule. sthus http://id.loc.gov/vocabulary/subjectSchemes/sthus Subject Taxonomy of the History of U.S. Foreign Relations poliscit http://id.loc.gov/vocabulary/subjectSchemes/poliscit Political science thesaurus II qtglit http://id.loc.gov/vocabulary/subjectSchemes/qtglit A queer thesaurus : an international thesaurus of gay and lesbian index terms unbist http://id.loc.gov/vocabulary/subjectSchemes/unbist UNBIS thesaurus gcipplatform http://id.loc.gov/vocabulary/subjectSchemes/gcipplatform GAMECIP - Computer Game Platforms (GAMECIP (Game Metadata and Citation Project)) puho http://id.loc.gov/vocabulary/subjectSchemes/puho PUHO - Puolustushallinnon ontologia "fi"=>"PUHO - Puolustushallinnon ontologia" thub http://id.loc.gov/vocabulary/subjectSchemes/thub Thesaurus de la Universitat de Barcelona "ca"=>"Thesaurus de la Universitat de Barcelona" ndlsh http://id.loc.gov/vocabulary/subjectSchemes/ndlsh National Diet Library list of subject headings "ja"=>"Koktsu Kokkai Toshokan kenmei hyômokuhyô" czenas http://id.loc.gov/vocabulary/subjectSchemes/czenas CZENAS thesaurus: a list of subject terms used in the National Library of the Czech Republic "cs"=>"Soubor vÄcných autorit Národnà knihovny ÄR" idszbzzh http://id.loc.gov/vocabulary/subjectSchemes/idszbzzh Thesaurus IDS Nebis Zentralbibliothek Zürich, Handschriftenabteilung "de"=>"Thesaurus IDS Nebis Zentralbibliothek Zürich, Handschriftenabteilung" unbisn http://id.loc.gov/vocabulary/subjectSchemes/unbisn UNBIS name authority list (New York, NY: Dag Hammarskjld Library, United Nations; : Chadwyck-Healey) rswk http://id.loc.gov/vocabulary/subjectSchemes/rswk Regeln für den Schlagwortkatalog "de"=>"Regeln für den Schlagwortkatalog" larpcal http://id.loc.gov/vocabulary/subjectSchemes/larpcal Lista de assuntos referente ao programa de cadastramento automatizado de livros da USP "pt"=>"Lista de assuntos referente ao programa de cadastramento automatizado de livros da USP" biccbmc http://id.loc.gov/vocabulary/subjectSchemes/biccbmc BIC Children's Books Marketing Classifications kulo http://id.loc.gov/vocabulary/subjectSchemes/kulo KULO - Kulttuurien tutkimuksen ontologia "fi"=>"KULO - Kulttuurien tutkimuksen ontologia" popinte http://id.loc.gov/vocabulary/subjectSchemes/popinte POPIN thesaurus: population multilingual thesaurus tisa http://id.loc.gov/vocabulary/subjectSchemes/tisa Villagrá Rubio, Angel. Tesauro ISOC de sociologÃa autores "es"=>"Villagrá Rubio, Angel. Tesauro ISOC de sociologÃa autores" atg http://id.loc.gov/vocabulary/subjectSchemes/atg Agricultural thesaurus and glossary eflch http://id.loc.gov/vocabulary/subjectSchemes/eflch E4Libraries Category Headings maaq http://id.loc.gov/vocabulary/subjectSchemes/maaq Madâkhil al-asmâ' al-'arabîyah al-qadîmah "ar"=>"Madâkhil al-asmâ' al-'arabîyah al-qadîmah" rvmgd http://id.loc.gov/vocabulary/subjectSchemes/rvmgd Thésaurus des descripteurs de groupes démographiques de l'Université Laval "fr"=>"Thésaurus des descripteurs de groupes démographiques de l'Université Laval" csahssa http://id.loc.gov/vocabulary/subjectSchemes/csahssa "Controlled vocabulary" in Health and safety science abstracts sigle http://id.loc.gov/vocabulary/subjectSchemes/sigle SIGLE manual, Part 2, Subject category list blnpn http://id.loc.gov/vocabulary/subjectSchemes/blnpn British Library newspaper place names asrctoa http://id.loc.gov/vocabulary/subjectSchemes/asrctoa Australian Standard Research Classification: Type of Activity (TOA) classification lcdgt http://id.loc.gov/vocabulary/subjectSchemes/lcdgt Library of Congress demographic group term and code List bokbas http://id.loc.gov/vocabulary/subjectSchemes/bokbas Bokbasen "no"=>"Bokbasen" gnis http://id.loc.gov/vocabulary/subjectSchemes/gnis Geographic Names Information System (GNIS) nbiemnfag http://id.loc.gov/vocabulary/subjectSchemes/nbiemnfag NBIs emneordsliste for faglitteratur "no"=>"NBIs emneordsliste for faglitteratur" nlgaf http://id.loc.gov/vocabulary/subjectSchemes/nlgaf Archeio KathierÅmenÅn EpikephalidÅn "el"=>"Archeio KathierÅmenÅn EpikephalidÅn" bhashe http://id.loc.gov/vocabulary/subjectSchemes/bhashe BHA, Bibliography of the history of art, subject headings/English tsht http://id.loc.gov/vocabulary/subjectSchemes/tsht Thesaurus of subject headings for television scbi http://id.loc.gov/vocabulary/subjectSchemes/scbi Soggettario per i cataloghi delle biblioteche italiane "it"=>"Soggettario per i cataloghi delle biblioteche italiane" valo http://id.loc.gov/vocabulary/subjectSchemes/valo VALO - Fotografiska ontologin "fi"=>"VALO - Fotografiska ontologin" wpicsh http://id.loc.gov/vocabulary/subjectSchemes/wpicsh WPIC Library thesaurus of subject headings aktp http://id.loc.gov/vocabulary/subjectSchemes/aktp AlphavÄtikos Katalogos ThematikÅn PerigrapheÅn "el"=>"AlphavÄtikos Katalogos ThematikÅn PerigrapheÅn" stw http://id.loc.gov/vocabulary/subjectSchemes/stw STW Thesaurus for Economics "de"=>"Standard-Thesaurus Wirtschaft" mesh http://id.loc.gov/vocabulary/subjectSchemes/mesh Medical subject headings ica http://id.loc.gov/vocabulary/subjectSchemes/ica Index of Christian art emnmus http://id.loc.gov/vocabulary/subjectSchemes/emnmus Emneord for musikkdokument i EDB-kataloger "no"=>"Emneord for musikkdokument i EDB-kataloger" sao http://id.loc.gov/vocabulary/subjectSchemes/sao Svenska ämnesord "sv"=>"Svenska ämnesord" sgc http://id.loc.gov/vocabulary/subjectSchemes/sgc COBISS.SI General List of subject headings (Slovenian subject headings) "sl"=>"SploÅ¡ni geslovnik COBISS.SI" bib1814 http://id.loc.gov/vocabulary/subjectSchemes/bib1814 1814-bibliografi: emneord for 1814-bibliografi "no"=>"1814-bibliografi: emneord for 1814-bibliografi" bjornson http://id.loc.gov/vocabulary/subjectSchemes/bjornson Bjornson: emneord for Bjornsonbibliografien "no"=>"Bjornson: emneord for Bjornsonbibliografien" liito http://id.loc.gov/vocabulary/subjectSchemes/liito LIITO - Liiketoimintaontologia "fi"=>"LIITO - Liiketoimintaontologia" apaist http://id.loc.gov/vocabulary/subjectSchemes/apaist APAIS thesaurus: a list of subject terms used in the Australian Public Affairs Information Service itglit http://id.loc.gov/vocabulary/subjectSchemes/itglit International thesaurus of gay and lesbian index terms (Chicago?: Thesaurus Committee, Gay and Lesbian Task Force, American Library Association) ntcsd http://id.loc.gov/vocabulary/subjectSchemes/ntcsd "National Translations Center secondary descriptors" in National Translation Center primary subject classification and secondary descriptor scisshl http://id.loc.gov/vocabulary/subjectSchemes/scisshl SCIS subject headings opms http://id.loc.gov/vocabulary/subjectSchemes/opms Opetusministeriön asiasanasto "fi"=>"Opetusministeriön asiasanasto" ttka http://id.loc.gov/vocabulary/subjectSchemes/ttka Teologisen tiedekunnan kirjaston asiasanasto "fi"=>"Teologisen tiedekunnan kirjaston asiasanasto" watrest http://id.loc.gov/vocabulary/subjectSchemes/watrest Thesaurus of water resources terms: a collection of water resources and related terms for use in indexing technical information ysa http://id.loc.gov/vocabulary/subjectSchemes/ysa Yleinen suomalainen asiasanasto "fi"=>"Yleinen suomalainen asiasanasto" kitu http://id.loc.gov/vocabulary/subjectSchemes/kitu Kirjallisuudentutkimuksen asiasanasto "fi"=>"Kirjallisuudentutkimuksen asiasanasto" sk http://id.loc.gov/vocabulary/subjectSchemes/sk 'Zhong guo gu ji shan ban shu zong mu' fen lei biao "zh"=>"'Zhong guo gu ji shan ban shu zong mu' fen lei biao" aiatsisp http://id.loc.gov/vocabulary/subjectSchemes/aiatsisp AIATSIS place thesaurus ram http://id.loc.gov/vocabulary/subjectSchemes/ram RAMEAU: répertoire d'authorité de matières encyclopédique unifié "fr"=>"RAMEAU: répertoire d'authorité de matières encyclopédique unifié" aedoml http://id.loc.gov/vocabulary/subjectSchemes/aedoml Listado de encabezamientos de materia de música "es"=>"Listado de encabezamientos de materia de música" ated http://id.loc.gov/vocabulary/subjectSchemes/ated Australian Thesaurus of Education Descriptors (ATED) cabt http://id.loc.gov/vocabulary/subjectSchemes/cabt CAB thesaurus (Slough [England]: Commonwealth Agricultural Bureaux) kassu http://id.loc.gov/vocabulary/subjectSchemes/kassu Kassu - Kasvien suomenkieliset nimet "fi"=>"Kassu - Kasvien suomenkieliset nimet" nbdbt http://id.loc.gov/vocabulary/subjectSchemes/nbdbt NBD Biblion Trefwoordenthesaurus "nl"=>"NBD Biblion Trefwoordenthesaurus" jhpb http://id.loc.gov/vocabulary/subjectSchemes/jhpb JÄzyk haseÅ przedmiotowych Biblioteki Narodowej "pl"=>"JÄzyk haseÅ przedmiotowych Biblioteki Narodowej" bidex http://id.loc.gov/vocabulary/subjectSchemes/bidex Bilindex: a bilingual Spanish-English subject heading list ccsa http://id.loc.gov/vocabulary/subjectSchemes/ccsa Catalogue collectif suisse des affiches "fr"=>"Catalogue collectif suisse des affiches" noraf http://id.loc.gov/vocabulary/subjectSchemes/noraf Norwegian Authority File kito http://id.loc.gov/vocabulary/subjectSchemes/kito KITO - Kirjallisuudentutkimuksen ontologia "fi"=>"KITO - Kirjallisuudentutkimuksen ontologia" tho http://id.loc.gov/vocabulary/subjectSchemes/tho Thesauros HellÄnikÅn Oron "el"=>"Thesauros HellÄnikÅn Oron" pmont http://id.loc.gov/vocabulary/subjectSchemes/pmont Powerhouse Museum Object Name Thesaurus ssg http://id.loc.gov/vocabulary/subjectSchemes/ssg SploÅ¡ni slovenski geslovnik "sl"=>"SploÅ¡ni slovenski geslovnik" huc http://id.loc.gov/vocabulary/subjectSchemes/huc U.S. Geological Survey water-supply paper 2294: hydrologic basins unit codes isis http://id.loc.gov/vocabulary/subjectSchemes/isis "Classification scheme" in Isis ibsen http://id.loc.gov/vocabulary/subjectSchemes/ibsen Ibsen: emneord for Den internasjonale Ibsen-bibliografien "no"=>"Ibsen: emneord for Den internasjonale Ibsen-bibliografien" lacnaf http://id.loc.gov/vocabulary/subjectSchemes/lacnaf Library and Archives Canada name authority file swemesh http://id.loc.gov/vocabulary/subjectSchemes/swemesh Swedish MeSH "sv"=>"Svenska MeSH" hamsun http://id.loc.gov/vocabulary/subjectSchemes/hamsun Hamsun: emneord for Hamsunbibliografien "no"=>"Hamsun: emneord for Hamsunbibliografien" qrma http://id.loc.gov/vocabulary/subjectSchemes/qrma List of Arabic subject headings "ar"=>"Qâ'imat ru'ûs al-mawdûât al-'Arabîyah" qrmak http://id.loc.gov/vocabulary/subjectSchemes/qrmak Qâ'imat ru'ûs al-mawdû'ât al-'Arabîyah al-qiyâsîyah al-maktabât wa-marâkaz al-ma'lûmât wa-qawâid al-bayânât "ar"=>"Qâ'imat ru'ûs al-mawdû'ât al-'Arabîyah al-qiyâsîyah al-maktabât wa-marâkaz al-ma'lûmât wa-qawâid al-bayânât" ceeus http://id.loc.gov/vocabulary/subjectSchemes/ceeus Counties and equivalent entities of the United States its possessions, and associated areas taxhs http://id.loc.gov/vocabulary/subjectSchemes/taxhs A taxonomy or human services: a conceptual framework with standardized terminology and definitions for the field noram http://id.loc.gov/vocabulary/subjectSchemes/noram Noram: emneord for Norsk-amerikansk samling "no"=>"Noram: emneord for Norsk-amerikansk samling" eurovocfr http://id.loc.gov/vocabulary/subjectSchemes/eurovocfr Eurovoc thesaurus (French) jurivoc http://id.loc.gov/vocabulary/subjectSchemes/jurivoc JURIVOC agrifors http://id.loc.gov/vocabulary/subjectSchemes/agrifors AGRIFOREST-sanasto "fi"=>"AGRIFOREST-sanasto" noubojur http://id.loc.gov/vocabulary/subjectSchemes/noubojur Thesaurus of Law "no"=>"Thesaurus of Law" pha http://id.loc.gov/vocabulary/subjectSchemes/pha Puolostushallinnon asiasanasto "fi"=>"Puolostushallinnon asiasanasto" ddcrit http://id.loc.gov/vocabulary/subjectSchemes/ddcrit DDC retrieval and indexing terminology; posting terms with hierarchy and KWOC mar http://id.loc.gov/vocabulary/subjectSchemes/mar Merenkulun asiasanasto "fi"=>"Merenkulun asiasanasto" sbt http://id.loc.gov/vocabulary/subjectSchemes/sbt Soggettario Sistema Bibliotecario Ticinese "it"=>"Soggettario Sistema Bibliotecario Ticinese" nzggn http://id.loc.gov/vocabulary/subjectSchemes/nzggn New Zealand gazetteer of official geographic names (New Zealand Geographic Board Ngā Pou Taunaha o Aotearoa (NZGB)) kta http://id.loc.gov/vocabulary/subjectSchemes/kta Kielitieteen asiasanasto "fi"=>"Kielitieteen asiasanasto" snt http://id.loc.gov/vocabulary/subjectSchemes/snt Sexual nomenclature : a thesaurus francis http://id.loc.gov/vocabulary/subjectSchemes/francis FRANCIS database classification scheme "fr"=>"Base de donneés FRANCIS: plan de classement" eurovocsl http://id.loc.gov/vocabulary/subjectSchemes/eurovocsl Eurovoc thesaurus "sl"=>"Eurovoc thesaurus" idszbzes http://id.loc.gov/vocabulary/subjectSchemes/idszbzes Thesaurus IDS Nebis Bibliothek Englisches Seminar der Universität Zürich "de"=>"Thesaurus IDS Nebis Bibliothek Englisches Seminar der Universität Zürich" nlmnaf http://id.loc.gov/vocabulary/subjectSchemes/nlmnaf National Library of Medicine name authority file rugeo http://id.loc.gov/vocabulary/subjectSchemes/rugeo Natsional'nyi normativnyi fail geograficheskikh nazvanii Rossiiskoi Federatsii "ru"=>"Natsional'nyi normativnyi fail geograficheskikh nazvanii Rossiiskoi Federatsii" sipri http://id.loc.gov/vocabulary/subjectSchemes/sipri SIPRI library thesaurus kkts http://id.loc.gov/vocabulary/subjectSchemes/kkts Katalogos KathierÅmenÅn TypÅn Syllogikou Katalogou Demosion Vivliothekon "el"=>"Katalogos KathierÅmenÅn TypÅn Syllogikou Katalogou Demosion Vivliothekon" tucua http://id.loc.gov/vocabulary/subjectSchemes/tucua Thesaurus for use in college and university archives pmbok http://id.loc.gov/vocabulary/subjectSchemes/pmbok Guide to the project management body of knowledge (PMBOK Guide) agrovoc http://id.loc.gov/vocabulary/subjectSchemes/agrovoc AGROVOC multilingual agricultural thesaurus nal http://id.loc.gov/vocabulary/subjectSchemes/nal National Agricultural Library subject headings lnmmbr http://id.loc.gov/vocabulary/subjectSchemes/lnmmbr Lietuvos nacionalines Martyno Mazvydo bibliotekos rubrikynas "lt"=>"Lietuvos nacionalines Martyno Mazvydo bibliotekos rubrikynas" vmj http://id.loc.gov/vocabulary/subjectSchemes/vmj Vedettes-matière jeunesse "fr"=>"Vedettes-matière jeunesse" ddcut http://id.loc.gov/vocabulary/subjectSchemes/ddcut Dewey Decimal Classification user terms eks http://id.loc.gov/vocabulary/subjectSchemes/eks Eduskunnan kirjaston asiasanasto "fi"=>"Eduskunnan kirjaston asiasanasto" wot http://id.loc.gov/vocabulary/subjectSchemes/wot A Women's thesaurus noubomn http://id.loc.gov/vocabulary/subjectSchemes/noubomn University of Oslo Library Thesaurus of Science "no"=>"University of Oslo Library Thesaurus of Science" idszbzzg http://id.loc.gov/vocabulary/subjectSchemes/idszbzzg Thesaurus IDS Nebis Zentralbibliothek Zürich, Graphische Sammlung "de"=>"Thesaurus IDS Nebis Zentralbibliothek Zürich, Graphische Sammlung" precis http://id.loc.gov/vocabulary/subjectSchemes/precis PRECIS: a manual of concept analysis and subject indexing cstud http://id.loc.gov/vocabulary/subjectSchemes/cstud Classificatieschema's Bibliotheek TU Delft "nl"=>"Classificatieschema's Bibliotheek TU Delft" nlgkk http://id.loc.gov/vocabulary/subjectSchemes/nlgkk Katalogos kathierÅmenÅn onomatÅn physikÅn prosÅpÅn "el"=>"Katalogos kathierÅmenÅn onomatÅn physikÅn prosÅpÅn" pmt http://id.loc.gov/vocabulary/subjectSchemes/pmt Project management terminology. Newtown Square, PA: Project Management Institute ericd http://id.loc.gov/vocabulary/subjectSchemes/ericd Thesaurus of ERIC descriptors rvm http://id.loc.gov/vocabulary/subjectSchemes/rvm Répertoire de vedettes-matière "fr"=>"Répertoire de vedettes-matière" sfit http://id.loc.gov/vocabulary/subjectSchemes/sfit Svenska filminstitutets tesaurus "sv"=>"Svenska filminstitutets tesaurus" trtsa http://id.loc.gov/vocabulary/subjectSchemes/trtsa Teatterin ja tanssin asiasanasto "fi"=>"Teatterin ja tanssin asiasanasto" ulan http://id.loc.gov/vocabulary/subjectSchemes/ulan Union list of artist names unescot http://id.loc.gov/vocabulary/subjectSchemes/unescot UNESCO thesaurus "fr"=>"Thésaurus de l'UNESCO","es"=>"Tesauro de la UNESCO" koko http://id.loc.gov/vocabulary/subjectSchemes/koko KOKO-ontologia "fi"=>"KOKO-ontologia" msh http://id.loc.gov/vocabulary/subjectSchemes/msh Trimboli, T., and Martyn S. Marianist subject headings trt http://id.loc.gov/vocabulary/subjectSchemes/trt Transportation resource thesaurus agrovocf http://id.loc.gov/vocabulary/subjectSchemes/agrovocf AGROVOC thésaurus agricole multilingue "fr"=>"AGROVOC thésaurus agricole multilingue" aucsh http://id.loc.gov/vocabulary/subjectSchemes/aucsh Arabic Union Catalog Subject Headings "ar"=>"Qâ'imat ru'ûs mawdû'ât al-fahras al-'Arabîyah al-mowahad" ddcri http://id.loc.gov/vocabulary/subjectSchemes/ddcri Dewey Decimal Classification Relative Index est http://id.loc.gov/vocabulary/subjectSchemes/est International energy: subject thesaurus (: International Energy Agency, Energy Technology Data Exchange) lua http://id.loc.gov/vocabulary/subjectSchemes/lua Liikunnan ja urheilun asiasanasto "fi"=>"Liikunnan ja urheilun asiasanasto" mipfesd http://id.loc.gov/vocabulary/subjectSchemes/mipfesd Macrothesaurus for information processing in the field of economic and social development rurkp http://id.loc.gov/vocabulary/subjectSchemes/rurkp Predmetnye rubriki Rossiiskoi knizhnoi palaty "ru"=>"Predmetnye rubriki Rossiiskoi knizhnoi palaty" albt http://id.loc.gov/vocabulary/subjectSchemes/albt Arbetslivsbibliotekets tesaurus "sv"=>"Arbetslivsbibliotekets tesaurus" fmesh http://id.loc.gov/vocabulary/subjectSchemes/fmesh Liste systématique et liste permutée des descripteurs français MeSH "fr"=>"Liste systématique et liste permutée des descripteurs français MeSH" bicssc http://id.loc.gov/vocabulary/subjectSchemes/bicssc BIC standard subject categories cctf http://id.loc.gov/vocabulary/subjectSchemes/cctf Carto-Canadiana thésaurus - Français "fr"=>"Carto-Canadiana thésaurus - Français" reo http://id.loc.gov/vocabulary/subjectSchemes/reo Māori Subject Headings thesaurus "mi"=>"Ngā Ūpoko Tukutuku" icpsr http://id.loc.gov/vocabulary/subjectSchemes/icpsr ICPSR controlled vocabulary system kao http://id.loc.gov/vocabulary/subjectSchemes/kao KVINNSAM ämnesordsregister "sv"=>"KVINNSAM ämnesordsregister" asrcseo http://id.loc.gov/vocabulary/subjectSchemes/asrcseo Australian Standard Research Classification: Socio-Economic Objective (SEO) classification georeft http://id.loc.gov/vocabulary/subjectSchemes/georeft GeoRef thesaurus cct http://id.loc.gov/vocabulary/subjectSchemes/cct Chinese Classified Thesaurus "zh"=>"Zhong guo fen lei zhu ti ci biao" dcs http://id.loc.gov/vocabulary/subjectSchemes/dcs Health Sciences Descriptors "es"=>"Descriptores en Ciencias de la Salud","pt"=>"Descritores em Ciências da Saúde" musa http://id.loc.gov/vocabulary/subjectSchemes/musa Musiikin asiasanasto: erikoissanasto "fi"=>"Musiikin asiasanasto: erikoissanasto" ntissc http://id.loc.gov/vocabulary/subjectSchemes/ntissc NTIS subject categories idszbz http://id.loc.gov/vocabulary/subjectSchemes/idszbz Thesaurus IDS Nebis Zentralbibliothek Zürich "de"=>"Thesaurus IDS Nebis Zentralbibliothek Zürich" tlka http://id.loc.gov/vocabulary/subjectSchemes/tlka Investigació, Procés Tècnicn kirjaston asiasanasto "fi"=>"Investigació, Procés Tècnicn kirjaston asiasanasto" usaidt http://id.loc.gov/vocabulary/subjectSchemes/usaidt USAID thesaurus: Keywords used to index documents included in the USAID Development Experience System. embne http://id.loc.gov/vocabulary/subjectSchemes/embne Encabezamientos de Materia de la Biblioteca Nacional de España "es"=>"Encabezamientos de Materia de la Biblioteca Nacional de España" vcaadu http://id.loc.gov/vocabulary/subjectSchemes/vcaadu Vocabulario controlado de arquitectura, arte, diseño y urbanismo "es"=>"Vocabulario controlado de arquitectura, arte, diseño y urbanismo" ntcpsc http://id.loc.gov/vocabulary/subjectSchemes/ntcpsc "National Translations Center primary subject classification" in National Translations Center primary subject classification and secondary descriptors quiding http://id.loc.gov/vocabulary/subjectSchemes/quiding Quiding, Nils Herman. Svenskt allmänt författningsregister för tiden frÃ¥n Ã¥r 1522 till och med Ã¥r 1862 "sv"=>"Quiding, Nils Herman. Svenskt allmänt författningsregister för tiden frÃ¥n Ã¥r 1522 till och med Ã¥r 1862" allars http://id.loc.gov/vocabulary/subjectSchemes/allars Allärs: allmän tesaurus pä svenska "fi"=>"Allärs: allmän tesaurus pä svenska" ogst http://id.loc.gov/vocabulary/subjectSchemes/ogst Oregon GILS Subject Tree (Oregon: Oregon State Library and Oregon Information Resource Management Division (IRMD)) bella http://id.loc.gov/vocabulary/subjectSchemes/bella Bella: specialtesaurus för skönlitteratur "fi"=>"Bella: specialtesaurus för skönlitteratur" bibalex http://id.loc.gov/vocabulary/subjectSchemes/bibalex Bibliotheca Alexandrina name and subject authority file pepp http://id.loc.gov/vocabulary/subjectSchemes/pepp The Princeton encyclopedia of poetry and poetics hkcan http://id.loc.gov/vocabulary/subjectSchemes/hkcan Hong Kong Chinese Authority File (Name) - HKCAN dissao http://id.loc.gov/vocabulary/subjectSchemes/dissao "Dissertation abstracts online" in Search tools: the guide to UNI/Data Courier Online ltcsh http://id.loc.gov/vocabulary/subjectSchemes/ltcsh Land Tenure Center Library list of subject headings mpirdes http://id.loc.gov/vocabulary/subjectSchemes/mpirdes Macrothesaurus para el procesamiento de la información relativa al desarrollo económico y social "es"=>"Macrothesaurus para el procesamiento de la información relativa al desarrollo económico y social" asft http://id.loc.gov/vocabulary/subjectSchemes/asft Aquatic sciences and fisheries thesaurus naf http://id.loc.gov/vocabulary/subjectSchemes/naf NACO authority file nimacsc http://id.loc.gov/vocabulary/subjectSchemes/nimacsc NIMA cartographic subject categories khib http://id.loc.gov/vocabulary/subjectSchemes/khib Emneord, KHiB Biblioteket "no"=>"Emneord, KHiB Biblioteket" cdcng http://id.loc.gov/vocabulary/subjectSchemes/cdcng Catalogage des documents cartographiques: forme et structure des vedettes noms géographiques - NF Z 44-081 "fr"=>"Catalogage des documents cartographiques: forme et structure des vedettes noms géographiques - NF Z 44-081" afset http://id.loc.gov/vocabulary/subjectSchemes/afset American Folklore Society Ethnographic Thesaurus erfemn http://id.loc.gov/vocabulary/subjectSchemes/erfemn Erfaringskompetanses emneord "no"=>"Erfaringskompetanses emneord" sbiao http://id.loc.gov/vocabulary/subjectSchemes/sbiao Svenska barnboksinstitutets ämnesordslista "sv"=>"Svenska barnboksinstitutets ämnesordslista" socio http://id.loc.gov/vocabulary/subjectSchemes/socio Sociological Abstracts Thesaurus bisacrt http://id.loc.gov/vocabulary/subjectSchemes/bisacrt BISAC Regional Themes eum http://id.loc.gov/vocabulary/subjectSchemes/eum Eesti uldine märksonastik "et"=>"Eesti uldine märksonastik" kula http://id.loc.gov/vocabulary/subjectSchemes/kula Kulttuurien tutkimuksen asiasanasto "fi"=>"Kulttuurien tutkimuksen asiasanasto" odlt http://id.loc.gov/vocabulary/subjectSchemes/odlt Baldick, C. The Oxford dictionary of literary terms rerovoc http://id.loc.gov/vocabulary/subjectSchemes/rerovoc Indexation matiéres RERO autoritès "fr"=>"Indexation matiéres RERO autoritès" tsr http://id.loc.gov/vocabulary/subjectSchemes/tsr TSR-ontologia "fi"=>"TSR-ontologia" czmesh http://id.loc.gov/vocabulary/subjectSchemes/czmesh Czech MeSH "cs"=>"Czech MeSH" dltt http://id.loc.gov/vocabulary/subjectSchemes/dltt Quinn, E. A dictionary of literary and thematic terms idsbb http://id.loc.gov/vocabulary/subjectSchemes/idsbb Thesaurus IDS Basel Bern "de"=>"Thesaurus IDS Basel Bern" inist http://id.loc.gov/vocabulary/subjectSchemes/inist INIS: thesaurus idszbzzk http://id.loc.gov/vocabulary/subjectSchemes/idszbzzk Thesaurus IDS Nebis Zentralbibliothek Zürich, Kartensammlung "de"=>"Thesaurus IDS Nebis Zentralbibliothek Zürich, Kartensammlung" tesa http://id.loc.gov/vocabulary/subjectSchemes/tesa Tesauro AgrÃcola "es"=>"Tesauro AgrÃcola" liv http://id.loc.gov/vocabulary/subjectSchemes/liv Legislative indexing vocabulary collett http://id.loc.gov/vocabulary/subjectSchemes/collett Collett-bibliografi: litteratur av og om Camilla Collett "no"=>"Collett-bibliografi: litteratur av og om Camilla Collett" nsbncf http://id.loc.gov/vocabulary/subjectSchemes/nsbncf Nuovo Soggettario "it"=>"Nuovo Soggettario" ipat http://id.loc.gov/vocabulary/subjectSchemes/ipat IPA thesaurus and frequency list skon http://id.loc.gov/vocabulary/subjectSchemes/skon Att indexera skönlitteratur: Ãmnesordslista, vuxenlitteratur "sv"=>"Att indexera skönlitteratur: Ãmnesordslista, vuxenlitteratur" renib http://id.loc.gov/vocabulary/subjectSchemes/renib Renib "es"=>"Renib" hrvmesh http://id.loc.gov/vocabulary/subjectSchemes/hrvmesh Croatian MeSH / Hrvatski MeSH "no"=>"Croatian MeSH / Hrvatski MeSH" swd http://id.loc.gov/vocabulary/subjectSchemes/swd Schlagwortnormdatei "de"=>"Schlagwortnormdatei" aass http://id.loc.gov/vocabulary/subjectSchemes/aass "Asian American Studies Library subject headings" in A Guide for establishing Asian American core collections cht http://id.loc.gov/vocabulary/subjectSchemes/cht Chicano thesaurus for indexing Chicano materials in Chicano periodical index galestne http://id.loc.gov/vocabulary/subjectSchemes/galestne Gale Group subject thesaurus and named entity vocabulary nlgsh http://id.loc.gov/vocabulary/subjectSchemes/nlgsh Katalogos HellÄnikÅn thematikÅn epikephalidÅn "el"=>"Katalogos HellÄnikÅn thematikÅn epikephalidÅn" hoidokki http://id.loc.gov/vocabulary/subjectSchemes/hoidokki Hoitotieteellinen asiasanasto vffyl http://id.loc.gov/vocabulary/subjectSchemes/vffyl Vocabulario de la Biblioteca Central de la FFyL "es"=>"Vocabulario de la Biblioteca Central de la FFyL" kubikat http://id.loc.gov/vocabulary/subjectSchemes/kubikat kubikat "de"=>"kubikat" waqaf http://id.loc.gov/vocabulary/subjectSchemes/waqaf Maknas Uloom Al Waqaf "ar"=>"Maknas Uloom Al Waqaf" hapi http://id.loc.gov/vocabulary/subjectSchemes/hapi HAPI thesaurus and name authority, 1970-2000 drama http://id.loc.gov/vocabulary/subjectSchemes/drama Drama: specialtesaurus för teater och dans sosa http://id.loc.gov/vocabulary/subjectSchemes/sosa Sociaalialan asiasanasto "fi"=>"Sociaalialan asiasanasto" ilpt http://id.loc.gov/vocabulary/subjectSchemes/ilpt Index to legal periodicals: thesaurus nicem http://id.loc.gov/vocabulary/subjectSchemes/nicem NICEM subject headings and classification system qlsp http://id.loc.gov/vocabulary/subjectSchemes/qlsp Queens Library Spanish language subject headings eet http://id.loc.gov/vocabulary/subjectSchemes/eet European education thesaurus nalnaf http://id.loc.gov/vocabulary/subjectSchemes/nalnaf National Agricultural Library name authority file eclas http://id.loc.gov/vocabulary/subjectSchemes/eclas ECLAS thesaurus agrovocs http://id.loc.gov/vocabulary/subjectSchemes/agrovocs AGROVOC tesauro agrÃcola multilingée "es"=>"AGROVOC tesauro agrÃcola multilingée" shbe http://id.loc.gov/vocabulary/subjectSchemes/shbe Subject headings in business and economics "sv"=>"Subject headings in business and economics" barn http://id.loc.gov/vocabulary/subjectSchemes/barn Svenska ämnesord för barn "sv"=>"Svenska ämnesord för barn" bhammf http://id.loc.gov/vocabulary/subjectSchemes/bhammf BHA, Bibliographie d'histoire de l'art, mots-matière/français "fr"=>"BHA, Bibliographie d'histoire de l'art, mots-matière/français" gccst http://id.loc.gov/vocabulary/subjectSchemes/gccst Government of Canada core subject thesaurus (Gatineau : Library and Archives Canada) fnhl http://id.loc.gov/vocabulary/subjectSchemes/fnhl First Nations House of Learning Subject Headings kauno http://id.loc.gov/vocabulary/subjectSchemes/kauno KAUNO - Kaunokki-ontologin "fi"=>"KAUNO - Kaunokki-ontologin" dtict http://id.loc.gov/vocabulary/subjectSchemes/dtict Defense Technical Information Center thesaurus mech http://id.loc.gov/vocabulary/subjectSchemes/mech Iskanje po zbirki MECH "sl"=>"Iskanje po zbirki MECH" jupo http://id.loc.gov/vocabulary/subjectSchemes/jupo JUPO - Julkisen hallinnon palveluontologia "fi"=>"JUPO - Julkisen hallinnon palveluontologia" ktpt http://id.loc.gov/vocabulary/subjectSchemes/ktpt Kirjasto- ja tietopalvelualan tesaurus "fi"=>"Kirjasto- ja tietopalvelualan tesaurus" aiatsiss http://id.loc.gov/vocabulary/subjectSchemes/aiatsiss AIATSIS subject Thesaurus lcac http://id.loc.gov/vocabulary/subjectSchemes/lcac Library of Congress Annotated Children's Cataloging Program subject headings lemac http://id.loc.gov/vocabulary/subjectSchemes/lemac Llista d'encapçalaments de matèria en català "ca"=>"Llista d'encapçalaments de matèria en català " lemb http://id.loc.gov/vocabulary/subjectSchemes/lemb Lista de encabezamientos de materia para bibliotecas "es"=>"Lista de encabezamientos de materia para bibliotecas" henn http://id.loc.gov/vocabulary/subjectSchemes/henn Hennepin County Library cumulative authority list mtirdes http://id.loc.gov/vocabulary/subjectSchemes/mtirdes Macrothésaurus pour le traitement de l'information relative au développement économique et social "fr"=>"Macrothésaurus pour le traitement de l'information relative au développement économique et social" cash http://id.loc.gov/vocabulary/subjectSchemes/cash Canadian subject headings nznb http://id.loc.gov/vocabulary/subjectSchemes/nznb New Zealand national bibliographic prvt http://id.loc.gov/vocabulary/subjectSchemes/prvt Patent- och registreringsverkets tesaurus "sv"=>"Patent- och registreringsverkets tesaurus" scgdst http://id.loc.gov/vocabulary/subjectSchemes/scgdst Subject categorization guide for defense science and technology gem http://id.loc.gov/vocabulary/subjectSchemes/gem GEM controlled vocabularies lcsh http://id.loc.gov/vocabulary/subjectSchemes/lcsh Library of Congress subject headings rero http://id.loc.gov/vocabulary/subjectSchemes/rero Indexation matires RERO "fr"=>"Indexation matires RERO" peri http://id.loc.gov/vocabulary/subjectSchemes/peri Perinnetieteiden asiasanasto "fi"=>"Perinnetieteiden asiasanasto" shsples http://id.loc.gov/vocabulary/subjectSchemes/shsples Encabezamientos de materia para bibliotecas escolares y públicas "es"=>"Encabezamientos de materia para bibliotecas escolares y públicas" slem http://id.loc.gov/vocabulary/subjectSchemes/slem Sears: lista de encabezamientos de materia "es"=>"Sears: lista de encabezamientos de materia" afo http://id.loc.gov/vocabulary/subjectSchemes/afo AFO - Viikin kampuskirjaston ontologia "fi"=>"AFO - Viikin kampuskirjaston ontologia" gst http://id.loc.gov/vocabulary/subjectSchemes/gst Gay studies thesaurus: a controlled vocabulary for indexing and accessing materials of relevance to gay culture, history, politics and psychology hlasstg http://id.loc.gov/vocabulary/subjectSchemes/hlasstg HLAS subject term glossary iest http://id.loc.gov/vocabulary/subjectSchemes/iest International energy: subject thesaurus pkk http://id.loc.gov/vocabulary/subjectSchemes/pkk Predmetnik za katoliÅ¡ke knjižnice "sl"=>"Predmetnik za katoliÅ¡ke knjižnice" atla http://id.loc.gov/vocabulary/subjectSchemes/atla Religion indexes: thesaurus scot http://id.loc.gov/vocabulary/subjectSchemes/scot Schools Online Thesaurus (ScOT) smda http://id.loc.gov/vocabulary/subjectSchemes/smda Smithsonian National Air and Space Museum Directory of Airplanes solstad http://id.loc.gov/vocabulary/subjectSchemes/solstad Solstad: emneord for Solstadbibliografien "no"=>"Solstad: emneord for Solstadbibliografien" abne http://id.loc.gov/vocabulary/subjectSchemes/abne Autoridades de la Biblioteca Nacional de España "es"=>"Autoridades de la Biblioteca Nacional de España" spines http://id.loc.gov/vocabulary/subjectSchemes/spines Tesauro SPINES: un vocabulario controlado y estructurado para el tratamiento de información sobre ciencia y tecnologÃa para el desarrollo "es"=>"Tesauro SPINES: un vocabulario controlado y estructurado para el tratamiento de información sobre ciencia y tecnologÃa para el desarrollo" ktta http://id.loc.gov/vocabulary/subjectSchemes/ktta Käsi - ja taideteollisuuden asiasanasto "fi"=>"Käsi - ja taideteollisuuden asiasanasto" ccte http://id.loc.gov/vocabulary/subjectSchemes/ccte Carto-Canadiana thesaurus - English pmcsg http://id.loc.gov/vocabulary/subjectSchemes/pmcsg Combined standards glossary bisacsh http://id.loc.gov/vocabulary/subjectSchemes/bisacsh BISAC Subject Headings fssh http://id.loc.gov/vocabulary/subjectSchemes/fssh FamilySearch Subject Headings (FamilySearch) tasmas http://id.loc.gov/vocabulary/subjectSchemes/tasmas Tesaurus de Asuntos Sociales del Ministerio de Asuntos Sociales de España "es"=>"Tesaurus de Asuntos Sociales del Ministerio de Asuntos Sociales de España" tero http://id.loc.gov/vocabulary/subjectSchemes/tero TERO - Terveyden ja hyvinvoinnin ontologia "fi"=>"TERO - Terveyden ja hyvinvoinnin ontologia" rma http://id.loc.gov/vocabulary/subjectSchemes/rma Ru'us al-mawdu'at al-'Arabiyah "ar"=>"Ru'us al-mawdu'at al-'Arabiyah" tgn http://id.loc.gov/vocabulary/subjectSchemes/tgn Getty thesaurus of geographic names tha http://id.loc.gov/vocabulary/subjectSchemes/tha Barcala de Moyano, Graciela G., Cristina Voena. Tesauro de Historia Argentina "es"=>"Barcala de Moyano, Graciela G., Cristina Voena. Tesauro de Historia Argentina" ttll http://id.loc.gov/vocabulary/subjectSchemes/ttll Roggau, Zunilda. Tell. Tesauro de lengua y literatura "es"=>"Roggau, Zunilda. Tell. Tesauro de lengua y literatura" sears http://id.loc.gov/vocabulary/subjectSchemes/sears Sears list of subject headings csht http://id.loc.gov/vocabulary/subjectSchemes/csht Chinese subject headings \. -- ' ...blah INSERT INTO authority.thesaurus (code, uri, name, control_set) SELECT code, uri, name, 1 FROM thesauri; UPDATE authority.thesaurus SET short_code = 'a' WHERE code = 'lcsh'; UPDATE authority.thesaurus SET short_code = 'b' WHERE code = 'lcshac'; UPDATE authority.thesaurus SET short_code = 'c' WHERE code = 'mesh'; UPDATE authority.thesaurus SET short_code = 'd' WHERE code = 'nal'; UPDATE authority.thesaurus SET short_code = 'k' WHERE code = 'cash'; UPDATE authority.thesaurus SET short_code = 'r' WHERE code = 'aat'; UPDATE authority.thesaurus SET short_code = 's' WHERE code = 'sears'; UPDATE authority.thesaurus SET short_code = 'v' WHERE code = 'rvm'; UPDATE authority.thesaurus SET short_code = 'z' WHERE short_code IS NULL; INSERT INTO config.i18n_core (fq_field, identity_value, translation, string ) SELECT 'at.name', t.code, xlate->key, xlate->value FROM thesauri t JOIN LATERAL each(t.xlate) AS xlate ON TRUE WHERE NOT EXISTS (SELECT id FROM config.i18n_core WHERE fq_field = 'at.name' AND identity_value = t.code AND translation = xlate->key) AND t.xlate IS NOT NULL AND t.name <> (xlate->value); INSERT INTO authority.heading_field(heading_type, heading_purpose, label, heading_xpath, component_xpath, type_xpath, thesaurus_xpath, thesaurus_override_xpath) VALUES ( 'topical_term', 'main', 'Main Topical Term', '/mads21:mads/mads21:authority', '//mads21:topic', NULL, '/mads21:mads/mads21:authority/mads21:topic[1]/@authority', NULL ) ,( 'topical_term', 'variant', 'Variant Topical Term', '/mads21:mads/mads21:variant', '//mads21:topic', '/mads21:variant/@type', '/mads21:mads/mads21:authority/mads21:topic[1]/@authority', '//mads21:topic[1]/@authority') ,( 'topical_term', 'related', 'Related Topical Term', '/mads21:mads/mads21:related', '//mads21:topic', '/mads21:related/@type', '/mads21:mads/mads21:authority/mads21:topic[1]/@authority', '//mads21:topic[1]/@authority') ,( 'personal_name', 'main', 'Main Personal Name', '/mads21:mads/mads21:authority', '//mads21:name[@type="personal"]', NULL, NULL, NULL ) ,( 'personal_name', 'variant', 'Variant Personal Name', '/mads21:mads/mads21:variant', '//mads21:name[@type="personal"]', NULL, NULL, NULL ) ,( 'personal_name', 'related', 'Related Personal Name', '/mads21:mads/mads21:related', '//mads21:name[@type="personal"]', '/mads21:related/@type', NULL, NULL ) ,( 'corporate_name', 'main', 'Main Corporate name', '/mads21:mads/mads21:authority', '//mads21:name[@type="corporate"]', NULL, NULL, NULL ) ,( 'corporate_name', 'variant', 'Variant Corporate Name', '/mads21:mads/mads21:variant', '//mads21:name[@type="corporate"]', NULL, NULL, NULL ) ,( 'corporate_name', 'related', 'Related Corporate Name', '/mads21:mads/mads21:related', '//mads21:name[@type="corporate"]', '/mads21:related/@type', NULL, NULL ) ,( 'meeting_name', 'main', 'Main Meeting name', '/mads21:mads/mads21:authority', '//mads21:name[@type="conference"]', NULL, NULL, NULL ) ,( 'meeting_name', 'variant', 'Variant Meeting Name', '/mads21:mads/mads21:variant', '//mads21:name[@type="conference"]', NULL, NULL, NULL ) ,( 'meeting_name', 'related', 'Related Meeting Name', '/mads21:mads/mads21:related', '//mads21:name[@type="meeting"]', '/mads21:related/@type', NULL, NULL ) ,( 'geographic_name', 'main', 'Main Geographic Term', '/mads21:mads/mads21:authority', '//mads21:geographic', NULL, '/mads21:mads/mads21:authority/mads21:geographic[1]/@authority', NULL ) ,( 'geographic_name', 'variant', 'Variant Geographic Term', '/mads21:mads/mads21:variant', '//mads21:geographic', '/mads21:variant/@type', '/mads21:mads/mads21:authority/mads21:geographic[1]/@authority', '//mads21:geographic[1]/@authority') ,( 'geographic_name', 'related', 'Related Geographic Term', '/mads21:mads/mads21:related', '//mads21:geographic', '/mads21:related/@type', '/mads21:mads/mads21:authority/mads21:geographic[1]/@authority', '//mads21:geographic[1]/@authority') ,( 'genre_form_term', 'main', 'Main Genre/Form Term', '/mads21:mads/mads21:authority', '//mads21:genre', NULL, '/mads21:mads/mads21:authority/mads21:genre[1]/@authority', NULL ) ,( 'genre_form_term', 'variant', 'Variant Genre/Form Term', '/mads21:mads/mads21:variant', '//mads21:genre', '/mads21:variant/@type', '/mads21:mads/mads21:authority/mads21:genre[1]/@authority', '//mads21:genre[1]/@authority') ,( 'genre_form_term', 'related', 'Related Genre/Form Term', '/mads21:mads/mads21:related', '//mads21:genre', '/mads21:related/@type', '/mads21:mads/mads21:authority/mads21:genre[1]/@authority', '//mads21:genre[1]/@authority') ,( 'chronological_term', 'main', 'Main Chronological Term', '/mads21:mads/mads21:authority', '//mads21:temporal', NULL, '/mads21:mads/mads21:authority/mads21:temporal[1]/@authority', NULL ) ,( 'chronological_term', 'variant', 'Variant Chronological Term', '/mads21:mads/mads21:variant', '//mads21:temporal', '/mads21:variant/@type', '/mads21:mads/mads21:authority/mads21:temporal[1]/@authority', '//mads21:temporal[1]/@authority') ,( 'chronological_term', 'related', 'Related Chronological Term', '/mads21:mads/mads21:related', '//mads21:temporal', '/mads21:related/@type', '/mads21:mads/mads21:authority/mads21:temporal[1]/@authority', '//mads21:temporal[1]/@authority') ,( 'uniform_title', 'main', 'Main Uniform Title', '/mads21:mads/mads21:authority', '//mads21:title', NULL, '/mads21:mads/mads21:authority/mads21:title[1]/@authority', NULL ) ,( 'uniform_title', 'variant', 'Variant Uniform Title', '/mads21:mads/mads21:variant', '//mads21:title', '/mads21:variant/@type', '/mads21:mads/mads21:authority/mads21:title[1]/@authority', '//mads21:title[1]/@authority') ,( 'uniform_title', 'related', 'Related Uniform Title', '/mads21:mads/mads21:related', '//mads21:title', '/mads21:related/@type', '/mads21:mads/mads21:authority/mads21:title[1]/@authority', '//mads21:title[1]/@authority') ; -- NACO normalize all the things INSERT INTO authority.heading_field_norm_map (field, norm, pos) SELECT id, 1, 0 FROM authority.heading_field; UPDATE authority.control_set_authority_field acsaf SET heading_field = ahf.id FROM authority.heading_field ahf WHERE tag = '100' AND control_set = 1 AND ahf.heading_purpose = 'main' AND ahf.heading_type = 'personal_name'; UPDATE authority.control_set_authority_field acsaf SET heading_field = ahf.id FROM authority.heading_field ahf WHERE tag = '400' AND control_set = 1 AND ahf.heading_purpose = 'variant' AND ahf.heading_type = 'personal_name'; UPDATE authority.control_set_authority_field acsaf SET heading_field = ahf.id FROM authority.heading_field ahf WHERE tag = '500' AND control_set = 1 AND ahf.heading_purpose = 'related' AND ahf.heading_type = 'personal_name'; UPDATE authority.control_set_authority_field acsaf SET heading_field = ahf.id FROM authority.heading_field ahf WHERE tag = '110' AND control_set = 1 AND ahf.heading_purpose = 'main' AND ahf.heading_type = 'corporate_name'; UPDATE authority.control_set_authority_field acsaf SET heading_field = ahf.id FROM authority.heading_field ahf WHERE tag = '410' AND control_set = 1 AND ahf.heading_purpose = 'variant' AND ahf.heading_type = 'corporate_name'; UPDATE authority.control_set_authority_field acsaf SET heading_field = ahf.id FROM authority.heading_field ahf WHERE tag = '510' AND control_set = 1 AND ahf.heading_purpose = 'related' AND ahf.heading_type = 'corporate_name'; UPDATE authority.control_set_authority_field acsaf SET heading_field = ahf.id FROM authority.heading_field ahf WHERE tag = '111' AND control_set = 1 AND ahf.heading_purpose = 'main' AND ahf.heading_type = 'meeting_name'; UPDATE authority.control_set_authority_field acsaf SET heading_field = ahf.id FROM authority.heading_field ahf WHERE tag = '411' AND control_set = 1 AND ahf.heading_purpose = 'variant' AND ahf.heading_type = 'meeting_name'; UPDATE authority.control_set_authority_field acsaf SET heading_field = ahf.id FROM authority.heading_field ahf WHERE tag = '511' AND control_set = 1 AND ahf.heading_purpose = 'related' AND ahf.heading_type = 'meeting_name'; UPDATE authority.control_set_authority_field acsaf SET heading_field = ahf.id FROM authority.heading_field ahf WHERE tag = '130' AND control_set = 1 AND ahf.heading_purpose = 'main' AND ahf.heading_type = 'uniform_title'; UPDATE authority.control_set_authority_field acsaf SET heading_field = ahf.id FROM authority.heading_field ahf WHERE tag = '430' AND control_set = 1 AND ahf.heading_purpose = 'variant' AND ahf.heading_type = 'uniform_title'; UPDATE authority.control_set_authority_field acsaf SET heading_field = ahf.id FROM authority.heading_field ahf WHERE tag = '530' AND control_set = 1 AND ahf.heading_purpose = 'related' AND ahf.heading_type = 'uniform_title'; UPDATE authority.control_set_authority_field acsaf SET heading_field = ahf.id FROM authority.heading_field ahf WHERE tag = '150' AND control_set = 1 AND ahf.heading_purpose = 'main' AND ahf.heading_type = 'topical_term'; UPDATE authority.control_set_authority_field acsaf SET heading_field = ahf.id FROM authority.heading_field ahf WHERE tag = '450' AND control_set = 1 AND ahf.heading_purpose = 'variant' AND ahf.heading_type = 'topical_term'; UPDATE authority.control_set_authority_field acsaf SET heading_field = ahf.id FROM authority.heading_field ahf WHERE tag = '550' AND control_set = 1 AND ahf.heading_purpose = 'related' AND ahf.heading_type = 'topical_term'; UPDATE authority.control_set_authority_field acsaf SET heading_field = ahf.id FROM authority.heading_field ahf WHERE tag = '151' AND control_set = 1 AND ahf.heading_purpose = 'main' AND ahf.heading_type = 'geographic_name'; UPDATE authority.control_set_authority_field acsaf SET heading_field = ahf.id FROM authority.heading_field ahf WHERE tag = '451' AND control_set = 1 AND ahf.heading_purpose = 'variant' AND ahf.heading_type = 'geographic_name'; UPDATE authority.control_set_authority_field acsaf SET heading_field = ahf.id FROM authority.heading_field ahf WHERE tag = '551' AND control_set = 1 AND ahf.heading_purpose = 'related' AND ahf.heading_type = 'geographic_name'; UPDATE authority.control_set_authority_field acsaf SET heading_field = ahf.id FROM authority.heading_field ahf WHERE tag = '155' AND control_set = 1 AND ahf.heading_purpose = 'main' AND ahf.heading_type = 'genre_form_term'; UPDATE authority.control_set_authority_field acsaf SET heading_field = ahf.id FROM authority.heading_field ahf WHERE tag = '455' AND control_set = 1 AND ahf.heading_purpose = 'variant' AND ahf.heading_type = 'genre_form_term'; UPDATE authority.control_set_authority_field acsaf SET heading_field = ahf.id FROM authority.heading_field ahf WHERE tag = '555' AND control_set = 1 AND ahf.heading_purpose = 'related' AND ahf.heading_type = 'genre_form_term'; INSERT INTO config.workstation_setting_type (name, grp, datatype, label) VALUES ( 'eg.circ.checkin.no_precat_alert', 'circ', 'bool', oils_i18n_gettext( 'eg.circ.checkin.no_precat_alert', 'Checkin: Ignore Precataloged Items', 'cwst', 'label' ) ), ( 'eg.circ.checkin.noop', 'circ', 'bool', oils_i18n_gettext( 'eg.circ.checkin.noop', 'Checkin: Suppress Holds and Transits', 'cwst', 'label' ) ), ( 'eg.circ.checkin.void_overdues', 'circ', 'bool', oils_i18n_gettext( 'eg.circ.checkin.void_overdues', 'Checkin: Amnesty Mode', 'cwst', 'label' ) ), ( 'eg.circ.checkin.auto_print_holds_transits', 'circ', 'bool', oils_i18n_gettext( 'eg.circ.checkin.auto_print_holds_transits', 'Checkin: Auto-Print Holds and Transits', 'cwst', 'label' ) ), ( 'eg.circ.checkin.clear_expired', 'circ', 'bool', oils_i18n_gettext( 'eg.circ.checkin.clear_expired', 'Checkin: Clear Holds Shelf', 'cwst', 'label' ) ), ( 'eg.circ.checkin.retarget_holds', 'circ', 'bool', oils_i18n_gettext( 'eg.circ.checkin.retarget_holds', 'Checkin: Retarget Local Holds', 'cwst', 'label' ) ), ( 'eg.circ.checkin.retarget_holds_all', 'circ', 'bool', oils_i18n_gettext( 'eg.circ.checkin.retarget_holds_all', 'Checkin: Retarget All Statuses', 'cwst', 'label' ) ), ( 'eg.circ.checkin.hold_as_transit', 'circ', 'bool', oils_i18n_gettext( 'eg.circ.checkin.hold_as_transit', 'Checkin: Capture Local Holds as Transits', 'cwst', 'label' ) ), ( 'eg.circ.checkin.manual_float', 'circ', 'bool', oils_i18n_gettext( 'eg.circ.checkin.manual_float', 'Checkin: Manual Floating Active', 'cwst', 'label' ) ), ( 'eg.circ.checkin.do_inventory_update', 'circ', 'bool', oils_i18n_gettext ( 'eg.circ.checkin.do_inventory_update', 'Checkin: Update Inventory', 'cwst', 'label' ) ), ( 'eg.circ.patron.summary.collapse', 'circ', 'bool', oils_i18n_gettext( 'eg.circ.patron.summary.collapse', 'Collaps Patron Summary Display', 'cwst', 'label' ) ), ( 'circ.bills.receiptonpay', 'circ', 'bool', oils_i18n_gettext( 'circ.bills.receiptonpay', 'Print Receipt On Payment', 'cwst', 'label' ) ), ( 'circ.renew.strict_barcode', 'circ', 'bool', oils_i18n_gettext( 'circ.renew.strict_barcode', 'Renew: Strict Barcode', 'cwst', 'label' ) ), ( 'circ.checkin.strict_barcode', 'circ', 'bool', oils_i18n_gettext( 'circ.checkin.strict_barcode', 'Checkin: Strict Barcode', 'cwst', 'label' ) ), ( 'circ.checkout.strict_barcode', 'circ', 'bool', oils_i18n_gettext( 'circ.checkout.strict_barcode', 'Checkout: Strict Barcode', 'cwst', 'label' ) ), ( 'cat.holdings_show_copies', 'cat', 'bool', oils_i18n_gettext( 'cat.holdings_show_copies', 'Holdings View Show Copies', 'cwst', 'label' ) ), ( 'cat.holdings_show_empty', 'cat', 'bool', oils_i18n_gettext( 'cat.holdings_show_empty', 'Holdings View Show Empty Volumes', 'cwst', 'label' ) ), ( 'cat.holdings_show_empty_org', 'cat', 'bool', oils_i18n_gettext( 'cat.holdings_show_empty_org', 'Holdings View Show Empty Orgs', 'cwst', 'label' ) ), ( 'cat.holdings_show_vols', 'cat', 'bool', oils_i18n_gettext( 'cat.holdings_show_vols', 'Holdings View Show Volumes', 'cwst', 'label' ) ), ( 'cat.copy.defaults', 'cat', 'object', oils_i18n_gettext( 'cat.copy.defaults', 'Copy Edit Default Values', 'cwst', 'label' ) ), ( 'cat.printlabels.default_template', 'cat', 'string', oils_i18n_gettext( 'cat.printlabels.default_template', 'Print Label Default Template', 'cwst', 'label' ) ), ( 'cat.printlabels.templates', 'cat', 'object', oils_i18n_gettext( 'cat.printlabels.templates', 'Print Label Templates', 'cwst', 'label' ) ), ( 'eg.circ.patron.search.include_inactive', 'circ', 'bool', oils_i18n_gettext( 'eg.circ.patron.search.include_inactive', 'Patron Search Include Inactive', 'cwst', 'label' ) ), ( 'eg.circ.patron.search.show_extras', 'circ', 'bool', oils_i18n_gettext( 'eg.circ.patron.search.show_extras', 'Patron Search Show Extra Search Options', 'cwst', 'label' ) ), ( 'eg.grid.circ.checkin.checkin', 'gui', 'object', oils_i18n_gettext( 'eg.grid.circ.checkin.checkin', 'Grid Config: circ.checkin.checkin', 'cwst', 'label' ) ), ( 'eg.grid.circ.checkin.capture', 'gui', 'object', oils_i18n_gettext( 'eg.grid.circ.checkin.capture', 'Grid Config: circ.checkin.capture', 'cwst', 'label' ) ), ( 'eg.grid.admin.server.config.copy_tag_type', 'gui', 'object', oils_i18n_gettext( 'eg.grid.admin.server.config.copy_tag_type', 'Grid Config: admin.server.config.copy_tag_type', 'cwst', 'label' ) ), ( 'eg.grid.admin.server.config.metabib_field_virtual_map.grid', 'gui', 'object', oils_i18n_gettext( 'eg.grid.admin.server.config.metabib_field_virtual_map.grid', 'Grid Config: admin.server.config.metabib_field_virtual_map.grid', 'cwst', 'label' ) ), ( 'eg.grid.admin.server.config.metabib_field.grid', 'gui', 'object', oils_i18n_gettext( 'eg.grid.admin.server.config.metabib_field.grid', 'Grid Config: admin.server.config.metabib_field.grid', 'cwst', 'label' ) ), ( 'eg.grid.admin.server.config.marc_field', 'gui', 'object', oils_i18n_gettext( 'eg.grid.admin.server.config.marc_field', 'Grid Config: admin.server.config.marc_field', 'cwst', 'label' ) ), ( 'eg.grid.admin.server.asset.copy_tag', 'gui', 'object', oils_i18n_gettext( 'eg.grid.admin.server.asset.copy_tag', 'Grid Config: admin.server.asset.copy_tag', 'cwst', 'label' ) ), ( 'eg.grid.admin.local.circ.neg_balance_users', 'gui', 'object', oils_i18n_gettext( 'eg.grid.admin.local.circ.neg_balance_users', 'Grid Config: admin.local.circ.neg_balance_users', 'cwst', 'label' ) ), ( 'eg.grid.admin.local.rating.badge', 'gui', 'object', oils_i18n_gettext( 'eg.grid.admin.local.rating.badge', 'Grid Config: admin.local.rating.badge', 'cwst', 'label' ) ), ( 'eg.grid.admin.workstation.work_log', 'gui', 'object', oils_i18n_gettext( 'eg.grid.admin.workstation.work_log', 'Grid Config: admin.workstation.work_log', 'cwst', 'label' ) ), ( 'eg.grid.admin.workstation.patron_log', 'gui', 'object', oils_i18n_gettext( 'eg.grid.admin.workstation.patron_log', 'Grid Config: admin.workstation.patron_log', 'cwst', 'label' ) ), ( 'eg.grid.admin.serials.pattern_template', 'gui', 'object', oils_i18n_gettext( 'eg.grid.admin.serials.pattern_template', 'Grid Config: admin.serials.pattern_template', 'cwst', 'label' ) ), ( 'eg.grid.serials.copy_templates', 'gui', 'object', oils_i18n_gettext( 'eg.grid.serials.copy_templates', 'Grid Config: serials.copy_templates', 'cwst', 'label' ) ), ( 'eg.grid.cat.record_overlay.holdings', 'gui', 'object', oils_i18n_gettext( 'eg.grid.cat.record_overlay.holdings', 'Grid Config: cat.record_overlay.holdings', 'cwst', 'label' ) ), ( 'eg.grid.cat.bucket.record.search', 'gui', 'object', oils_i18n_gettext( 'eg.grid.cat.bucket.record.search', 'Grid Config: cat.bucket.record.search', 'cwst', 'label' ) ), ( 'eg.grid.cat.bucket.record.view', 'gui', 'object', oils_i18n_gettext( 'eg.grid.cat.bucket.record.view', 'Grid Config: cat.bucket.record.view', 'cwst', 'label' ) ), ( 'eg.grid.cat.bucket.record.pending', 'gui', 'object', oils_i18n_gettext( 'eg.grid.cat.bucket.record.pending', 'Grid Config: cat.bucket.record.pending', 'cwst', 'label' ) ), ( 'eg.grid.cat.bucket.copy.view', 'gui', 'object', oils_i18n_gettext( 'eg.grid.cat.bucket.copy.view', 'Grid Config: cat.bucket.copy.view', 'cwst', 'label' ) ), ( 'eg.grid.cat.bucket.copy.pending', 'gui', 'object', oils_i18n_gettext( 'eg.grid.cat.bucket.copy.pending', 'Grid Config: cat.bucket.copy.pending', 'cwst', 'label' ) ), ( 'eg.grid.cat.items', 'gui', 'object', oils_i18n_gettext( 'eg.grid.cat.items', 'Grid Config: cat.items', 'cwst', 'label' ) ), ( 'eg.grid.cat.volcopy.copies', 'gui', 'object', oils_i18n_gettext( 'eg.grid.cat.volcopy.copies', 'Grid Config: cat.volcopy.copies', 'cwst', 'label' ) ), ( 'eg.grid.cat.volcopy.copies.complete', 'gui', 'object', oils_i18n_gettext( 'eg.grid.cat.volcopy.copies.complete', 'Grid Config: cat.volcopy.copies.complete', 'cwst', 'label' ) ), ( 'eg.grid.cat.peer_bibs', 'gui', 'object', oils_i18n_gettext( 'eg.grid.cat.peer_bibs', 'Grid Config: cat.peer_bibs', 'cwst', 'label' ) ), ( 'eg.grid.cat.catalog.wide_holds', 'gui', 'object', oils_i18n_gettext( 'eg.grid.cat.catalog.wide_holds', 'Grid Config: cat.catalog.wide_holds', 'cwst', 'label' ) ), ( 'eg.grid.cat.holdings', 'gui', 'object', oils_i18n_gettext( 'eg.grid.cat.holdings', 'Grid Config: cat.holdings', 'cwst', 'label' ) ), ( 'eg.grid.cat.z3950_results', 'gui', 'object', oils_i18n_gettext( 'eg.grid.cat.z3950_results', 'Grid Config: cat.z3950_results', 'cwst', 'label' ) ), ( 'eg.grid.circ.wide_holds.shelf', 'gui', 'object', oils_i18n_gettext( 'eg.grid.circ.wide_holds.shelf', 'Grid Config: circ.wide_holds.shelf', 'cwst', 'label' ) ), ( 'eg.grid.circ.holds.pull', 'gui', 'object', oils_i18n_gettext( 'eg.grid.circ.holds.pull', 'Grid Config: circ.holds.pull', 'cwst', 'label' ) ), ( 'eg.grid.circ.in_house_use', 'gui', 'object', oils_i18n_gettext( 'eg.grid.circ.in_house_use', 'Grid Config: circ.in_house_use', 'cwst', 'label' ) ), ( 'eg.grid.circ.renew', 'gui', 'object', oils_i18n_gettext( 'eg.grid.circ.renew', 'Grid Config: circ.renew', 'cwst', 'label' ) ), ( 'eg.grid.circ.transits.list', 'gui', 'object', oils_i18n_gettext( 'eg.grid.circ.transits.list', 'Grid Config: circ.transits.list', 'cwst', 'label' ) ), ( 'eg.grid.circ.patron.holds', 'gui', 'object', oils_i18n_gettext( 'eg.grid.circ.patron.holds', 'Grid Config: circ.patron.holds', 'cwst', 'label' ) ), ( 'eg.grid.circ.pending_patrons.list', 'gui', 'object', oils_i18n_gettext( 'eg.grid.circ.pending_patrons.list', 'Grid Config: circ.pending_patrons.list', 'cwst', 'label' ) ), ( 'eg.grid.circ.patron.items_out.noncat', 'gui', 'object', oils_i18n_gettext( 'eg.grid.circ.patron.items_out.noncat', 'Grid Config: circ.patron.items_out.noncat', 'cwst', 'label' ) ), ( 'eg.grid.circ.patron.items_out', 'gui', 'object', oils_i18n_gettext( 'eg.grid.circ.patron.items_out', 'Grid Config: circ.patron.items_out', 'cwst', 'label' ) ), ( 'eg.grid.circ.patron.billhistory_payments', 'gui', 'object', oils_i18n_gettext( 'eg.grid.circ.patron.billhistory_payments', 'Grid Config: circ.patron.billhistory_payments', 'cwst', 'label' ) ), ( 'eg.grid.user.bucket.view', 'gui', 'object', oils_i18n_gettext( 'eg.grid.user.bucket.view', 'Grid Config: user.bucket.view', 'cwst', 'label' ) ), ( 'eg.grid.user.bucket.pending', 'gui', 'object', oils_i18n_gettext( 'eg.grid.user.bucket.pending', 'Grid Config: user.bucket.pending', 'cwst', 'label' ) ), ( 'eg.grid.circ.patron.staff_messages', 'gui', 'object', oils_i18n_gettext( 'eg.grid.circ.patron.staff_messages', 'Grid Config: circ.patron.staff_messages', 'cwst', 'label' ) ), ( 'eg.grid.circ.patron.archived_messages', 'gui', 'object', oils_i18n_gettext( 'eg.grid.circ.patron.archived_messages', 'Grid Config: circ.patron.archived_messages', 'cwst', 'label' ) ), ( 'eg.grid.circ.patron.bills', 'gui', 'object', oils_i18n_gettext( 'eg.grid.circ.patron.bills', 'Grid Config: circ.patron.bills', 'cwst', 'label' ) ), ( 'eg.grid.circ.patron.checkout', 'gui', 'object', oils_i18n_gettext( 'eg.grid.circ.patron.checkout', 'Grid Config: circ.patron.checkout', 'cwst', 'label' ) ), ( 'eg.grid.serials.mfhd_grid', 'gui', 'object', oils_i18n_gettext( 'eg.grid.serials.mfhd_grid', 'Grid Config: serials.mfhd_grid', 'cwst', 'label' ) ), ( 'eg.grid.serials.view_item_grid', 'gui', 'object', oils_i18n_gettext( 'eg.grid.serials.view_item_grid', 'Grid Config: serials.view_item_grid', 'cwst', 'label' ) ), ( 'eg.grid.serials.dist_stream_grid', 'gui', 'object', oils_i18n_gettext( 'eg.grid.serials.dist_stream_grid', 'Grid Config: serials.dist_stream_grid', 'cwst', 'label' ) ), ( 'eg.grid.circ.patron.search', 'gui', 'object', oils_i18n_gettext( 'eg.grid.circ.patron.search', 'Grid Config: circ.patron.search', 'cwst', 'label' ) ), ( 'eg.cat.record.summary.collapse', 'gui', 'bool', oils_i18n_gettext( 'eg.cat.record.summary.collapse', 'Collapse Bib Record Summary', 'cwst', 'label' ) ), ( 'cat.marcedit.flateditor', 'gui', 'bool', oils_i18n_gettext( 'cat.marcedit.flateditor', 'Use Flat MARC Editor', 'cwst', 'label' ) ), ( 'cat.marcedit.stack_subfields', 'gui', 'bool', oils_i18n_gettext( 'cat.marcedit.stack_subfields', 'MARC Editor Stack Subfields', 'cwst', 'label' ) ), ( 'eg.offline.print_receipt', 'gui', 'bool', oils_i18n_gettext( 'eg.offline.print_receipt', 'Offline Print Receipt', 'cwst', 'label' ) ), ( 'eg.offline.strict_barcode', 'gui', 'bool', oils_i18n_gettext( 'eg.offline.strict_barcode', 'Offline Use Strict Barcode', 'cwst', 'label' ) ), ( 'cat.default_bib_marc_template', 'gui', 'string', oils_i18n_gettext( 'cat.default_bib_marc_template', 'Default MARC Template', 'cwst', 'label' ) ), ( 'eg.audio.disable', 'gui', 'bool', oils_i18n_gettext( 'eg.audio.disable', 'Disable Staff Client Notification Audio', 'cwst', 'label' ) ), ( 'eg.search.adv_pane', 'gui', 'string', oils_i18n_gettext( 'eg.search.adv_pane', 'Catalog Advanced Search Default Pane', 'cwst', 'label' ) ), ( 'eg.print.template_context.bills_current', 'gui', 'string', oils_i18n_gettext( 'eg.print.template_context.bills_current', 'Print Template Context: bills_current', 'cwst', 'label' ) ), ( 'eg.print.template.bills_current', 'gui', 'string', oils_i18n_gettext( 'eg.print.template.bills_current', 'Print Template: bills_current', 'cwst', 'label' ) ), ( 'eg.print.template_context.bills_historical', 'gui', 'string', oils_i18n_gettext( 'eg.print.template_context.bills_historical', 'Print Template Context: bills_historical', 'cwst', 'label' ) ), ( 'eg.print.template.bills_historical', 'gui', 'string', oils_i18n_gettext( 'eg.print.template.bills_historical', 'Print Template: bills_historical', 'cwst', 'label' ) ), ( 'eg.print.template_context.bill_payment', 'gui', 'string', oils_i18n_gettext( 'eg.print.template_context.bill_payment', 'Print Template Context: bill_payment', 'cwst', 'label' ) ), ( 'eg.print.template.bill_payment', 'gui', 'string', oils_i18n_gettext( 'eg.print.template.bill_payment', 'Print Template: bill_payment', 'cwst', 'label' ) ), ( 'eg.print.template_context.checkin', 'gui', 'string', oils_i18n_gettext( 'eg.print.template_context.checkin', 'Print Template Context: checkin', 'cwst', 'label' ) ), ( 'eg.print.template.checkin', 'gui', 'string', oils_i18n_gettext( 'eg.print.template.checkin', 'Print Template: checkin', 'cwst', 'label' ) ), ( 'eg.print.template_context.checkout', 'gui', 'string', oils_i18n_gettext( 'eg.print.template_context.checkout', 'Print Template Context: checkout', 'cwst', 'label' ) ), ( 'eg.print.template.checkout', 'gui', 'string', oils_i18n_gettext( 'eg.print.template.checkout', 'Print Template: checkout', 'cwst', 'label' ) ), ( 'eg.print.template_context.hold_transit_slip', 'gui', 'string', oils_i18n_gettext( 'eg.print.template_context.hold_transit_slip', 'Print Template Context: hold_transit_slip', 'cwst', 'label' ) ), ( 'eg.print.template.hold_transit_slip', 'gui', 'string', oils_i18n_gettext( 'eg.print.template.hold_transit_slip', 'Print Template: hold_transit_slip', 'cwst', 'label' ) ), ( 'eg.print.template_context.hold_shelf_slip', 'gui', 'string', oils_i18n_gettext( 'eg.print.template_context.hold_shelf_slip', 'Print Template Context: hold_shelf_slip', 'cwst', 'label' ) ), ( 'eg.print.template.hold_shelf_slip', 'gui', 'string', oils_i18n_gettext( 'eg.print.template.hold_shelf_slip', 'Print Template: hold_shelf_slip', 'cwst', 'label' ) ), ( 'eg.print.template_context.holds_for_bib', 'gui', 'string', oils_i18n_gettext( 'eg.print.template_context.holds_for_bib', 'Print Template Context: holds_for_bib', 'cwst', 'label' ) ), ( 'eg.print.template.holds_for_bib', 'gui', 'string', oils_i18n_gettext( 'eg.print.template.holds_for_bib', 'Print Template: holds_for_bib', 'cwst', 'label' ) ), ( 'eg.print.template_context.holds_for_patron', 'gui', 'string', oils_i18n_gettext( 'eg.print.template_context.holds_for_patron', 'Print Template Context: holds_for_patron', 'cwst', 'label' ) ), ( 'eg.print.template.holds_for_patron', 'gui', 'string', oils_i18n_gettext( 'eg.print.template.holds_for_patron', 'Print Template: holds_for_patron', 'cwst', 'label' ) ), ( 'eg.print.template_context.hold_pull_list', 'gui', 'string', oils_i18n_gettext( 'eg.print.template_context.hold_pull_list', 'Print Template Context: hold_pull_list', 'cwst', 'label' ) ), ( 'eg.print.template.hold_pull_list', 'gui', 'string', oils_i18n_gettext( 'eg.print.template.hold_pull_list', 'Print Template: hold_pull_list', 'cwst', 'label' ) ), ( 'eg.print.template_context.hold_shelf_list', 'gui', 'string', oils_i18n_gettext( 'eg.print.template_context.hold_shelf_list', 'Print Template Context: hold_shelf_list', 'cwst', 'label' ) ), ( 'eg.print.template.hold_shelf_list', 'gui', 'string', oils_i18n_gettext( 'eg.print.template.hold_shelf_list', 'Print Template: hold_shelf_list', 'cwst', 'label' ) ), ( 'eg.print.template_context.in_house_use_list', 'gui', 'string', oils_i18n_gettext( 'eg.print.template_context.in_house_use_list', 'Print Template Context: in_house_use_list', 'cwst', 'label' ) ), ( 'eg.print.template.in_house_use_list', 'gui', 'string', oils_i18n_gettext( 'eg.print.template.in_house_use_list', 'Print Template: in_house_use_list', 'cwst', 'label' ) ), ( 'eg.print.template_context.item_status', 'gui', 'string', oils_i18n_gettext( 'eg.print.template_context.item_status', 'Print Template Context: item_status', 'cwst', 'label' ) ), ( 'eg.print.template.item_status', 'gui', 'string', oils_i18n_gettext( 'eg.print.template.item_status', 'Print Template: item_status', 'cwst', 'label' ) ), ( 'eg.print.template_context.items_out', 'gui', 'string', oils_i18n_gettext( 'eg.print.template_context.items_out', 'Print Template Context: items_out', 'cwst', 'label' ) ), ( 'eg.print.template.items_out', 'gui', 'string', oils_i18n_gettext( 'eg.print.template.items_out', 'Print Template: items_out', 'cwst', 'label' ) ), ( 'eg.print.template_context.patron_address', 'gui', 'string', oils_i18n_gettext( 'eg.print.template_context.patron_address', 'Print Template Context: patron_address', 'cwst', 'label' ) ), ( 'eg.print.template.patron_address', 'gui', 'string', oils_i18n_gettext( 'eg.print.template.patron_address', 'Print Template: patron_address', 'cwst', 'label' ) ), ( 'eg.print.template_context.patron_data', 'gui', 'string', oils_i18n_gettext( 'eg.print.template_context.patron_data', 'Print Template Context: patron_data', 'cwst', 'label' ) ), ( 'eg.print.template.patron_data', 'gui', 'string', oils_i18n_gettext( 'eg.print.template.patron_data', 'Print Template: patron_data', 'cwst', 'label' ) ), ( 'eg.print.template_context.patron_note', 'gui', 'string', oils_i18n_gettext( 'eg.print.template_context.patron_note', 'Print Template Context: patron_note', 'cwst', 'label' ) ), ( 'eg.print.template.patron_note', 'gui', 'string', oils_i18n_gettext( 'eg.print.template.patron_note', 'Print Template: patron_note', 'cwst', 'label' ) ), ( 'eg.print.template_context.renew', 'gui', 'string', oils_i18n_gettext( 'eg.print.template_context.renew', 'Print Template Context: renew', 'cwst', 'label' ) ), ( 'eg.print.template.renew', 'gui', 'string', oils_i18n_gettext( 'eg.print.template.renew', 'Print Template: renew', 'cwst', 'label' ) ), ( 'eg.print.template_context.transit_list', 'gui', 'string', oils_i18n_gettext( 'eg.print.template_context.transit_list', 'Print Template Context: transit_list', 'cwst', 'label' ) ), ( 'eg.print.template.transit_list', 'gui', 'string', oils_i18n_gettext( 'eg.print.template.transit_list', 'Print Template: transit_list', 'cwst', 'label' ) ), ( 'eg.print.template_context.transit_slip', 'gui', 'string', oils_i18n_gettext( 'eg.print.template_context.transit_slip', 'Print Template Context: transit_slip', 'cwst', 'label' ) ), ( 'eg.print.template.transit_slip', 'gui', 'string', oils_i18n_gettext( 'eg.print.template.transit_slip', 'Print Template: transit_slip', 'cwst', 'label' ) ), ( 'eg.print.template_context.offline_checkout', 'gui', 'string', oils_i18n_gettext( 'eg.print.template_context.offline_checkout', 'Print Template Context: offline_checkout', 'cwst', 'label' ) ), ( 'eg.print.template.offline_checkout', 'gui', 'string', oils_i18n_gettext( 'eg.print.template.offline_checkout', 'Print Template: offline_checkout', 'cwst', 'label' ) ), ( 'eg.print.template_context.offline_renew', 'gui', 'string', oils_i18n_gettext( 'eg.print.template_context.offline_renew', 'Print Template Context: offline_renew', 'cwst', 'label' ) ), ( 'eg.print.template.offline_renew', 'gui', 'string', oils_i18n_gettext( 'eg.print.template.offline_renew', 'Print Template: offline_renew', 'cwst', 'label' ) ), ( 'eg.print.template_context.offline_checkin', 'gui', 'string', oils_i18n_gettext( 'eg.print.template_context.offline_checkin', 'Print Template Context: offline_checkin', 'cwst', 'label' ) ), ( 'eg.print.template.offline_checkin', 'gui', 'string', oils_i18n_gettext( 'eg.print.template.offline_checkin', 'Print Template: offline_checkin', 'cwst', 'label' ) ), ( 'eg.print.template_context.offline_in_house_use', 'gui', 'string', oils_i18n_gettext( 'eg.print.template_context.offline_in_house_use', 'Print Template Context: offline_in_house_use', 'cwst', 'label' ) ), ( 'eg.print.template.offline_in_house_use', 'gui', 'string', oils_i18n_gettext( 'eg.print.template.offline_in_house_use', 'Print Template: offline_in_house_use', 'cwst', 'label' ) ), ( 'eg.serials.stream_names', 'gui', 'array', oils_i18n_gettext( 'eg.serials.stream_names', 'Serials Local Stream Names', 'cwst', 'label' ) ), ( 'eg.serials.items.do_print_routing_lists', 'gui', 'bool', oils_i18n_gettext( 'eg.serials.items.do_print_routing_lists', 'Serials Print Routing Lists', 'cwst', 'label' ) ), ( 'eg.serials.items.receive_and_barcode', 'gui', 'bool', oils_i18n_gettext( 'eg.serials.items.receive_and_barcode', 'Serials Barcode On Receive', 'cwst', 'label' ) ); -- More values with fm_class'es INSERT INTO config.workstation_setting_type (name, grp, datatype, fm_class, label) VALUES ( 'eg.search.search_lib', 'gui', 'link', 'aou', oils_i18n_gettext( 'eg.search.search_lib', 'Staff Catalog Default Search Library', 'cwst', 'label' ) ), ( 'eg.search.pref_lib', 'gui', 'link', 'aou', oils_i18n_gettext( 'eg.search.pref_lib', 'Staff Catalog Preferred Library', 'cwst', 'label' ) ); INSERT into config.workstation_setting_type (name, grp, datatype, label) VALUES ( 'eg.grid.admin.acq.cancel_reason', 'gui', 'object', oils_i18n_gettext ( 'eg.grid.admin.acq.cancel_reason', 'Grid Config: admin.acq.cancel_reason', 'cwst', 'label' ) ), ( 'eg.grid.admin.acq.claim_event_type', 'gui', 'object', oils_i18n_gettext ( 'eg.grid.admin.acq.claim_event_type', 'Grid Config: admin.acq.claim_event_type', 'cwst', 'label' ) ), ( 'eg.grid.admin.acq.claim_policy', 'gui', 'object', oils_i18n_gettext ( 'eg.grid.admin.acq.claim_policy', 'Grid Config: admin.acq.claim_policy', 'cwst', 'label' ) ), ( 'eg.grid.admin.acq.claim_policy_action', 'gui', 'object', oils_i18n_gettext ( 'eg.grid.admin.acq.claim_policy_action', 'Grid Config: admin.acq.claim_policy_action', 'cwst', 'label' ) ), ( 'eg.grid.admin.acq.claim_type', 'gui', 'object', oils_i18n_gettext ( 'eg.grid.admin.acq.claim_type', 'Grid Config: admin.acq.claim_type', 'cwst', 'label' ) ), ( 'eg.grid.admin.acq.currency_type', 'gui', 'object', oils_i18n_gettext ( 'eg.grid.admin.acq.currency_type', 'Grid Config: admin.acq.currency_type', 'cwst', 'label' ) ), ( 'eg.grid.admin.acq.edi_account', 'gui', 'object', oils_i18n_gettext ( 'eg.grid.admin.acq.edi_account', 'Grid Config: admin.acq.edi_account', 'cwst', 'label' ) ), ( 'eg.grid.admin.acq.edi_message', 'gui', 'object', oils_i18n_gettext ( 'eg.grid.admin.acq.edi_message', 'Grid Config: admin.acq.edi_message', 'cwst', 'label' ) ), ( 'eg.grid.admin.acq.exchange_rate', 'gui', 'object', oils_i18n_gettext ( 'eg.grid.admin.acq.exchange_rate', 'Grid Config: admin.acq.exchange_rate', 'cwst', 'label' ) ), ( 'eg.grid.admin.acq.fund_tag', 'gui', 'object', oils_i18n_gettext ( 'eg.grid.admin.acq.fund_tag', 'Grid Config: admin.acq.fund_tag', 'cwst', 'label' ) ), ( 'eg.grid.admin.acq.invoice_item_type', 'gui', 'object', oils_i18n_gettext ( 'eg.grid.admin.acq.invoice_item_type', 'Grid Config: admin.acq.invoice_item_type', 'cwst', 'label' ) ), ( 'eg.grid.admin.acq.invoice_payment_method', 'gui', 'object', oils_i18n_gettext ( 'eg.grid.admin.acq.invoice_payment_method', 'Grid Config: admin.acq.invoice_payment_method', 'cwst', 'label' ) ), ( 'eg.grid.admin.acq.lineitem_alert_text', 'gui', 'object', oils_i18n_gettext ( 'eg.grid.admin.acq.lineitem_alert_text', 'Grid Config: admin.acq.lineitem_alert_text', 'cwst', 'label' ) ), ( 'eg.grid.admin.acq.lineitem_marc_attr_definition', 'gui', 'object', oils_i18n_gettext ( 'eg.grid.admin.acq.lineitem_marc_attr_definition', 'Grid Config: admin.acq.lineitem_marc_attr_definition', 'cwst', 'label' ) ); INSERT into config.org_unit_setting_type (name, label, description, datatype) VALUES ( 'ui.patron.edit.au.guardian.show', oils_i18n_gettext( 'ui.patron.edit.au.guardian.show', 'GUI: Show guardian field on patron registration', 'coust', 'label' ), oils_i18n_gettext( 'ui.patron.edit.au.guardian.show', 'The guardian field will be shown on the patron registration screen. Showing a field makes it appear with required fields even when not required. If the field is required this setting is ignored.', 'coust', 'description' ), 'bool' ), ( 'ui.patron.edit.au.guardian.suggest', oils_i18n_gettext( 'ui.patron.edit.au.guardian.suggest', 'GUI: Suggest guardian field on patron registration', 'coust', 'label' ), oils_i18n_gettext( 'ui.patron.edit.au.guardian.suggest', 'The guardian field will be suggested on the patron registration screen. Suggesting a field makes it appear when suggested fields are shown. If the field is shown or required this setting is ignored.', 'coust', 'description'), 'bool' ), ( 'ui.patron.edit.guardian_required_for_juv', oils_i18n_gettext( 'ui.patron.edit.guardian_required_for_juv', 'GUI: Juvenile account requires parent/guardian', 'coust', 'label' ), oils_i18n_gettext( 'ui.patron.edit.guardian_required_for_juv', 'Require a value for the parent/guardian field in the patron editor for patrons marked as juvenile', 'coust', 'description'), 'bool' ); INSERT into config.workstation_setting_type (name, grp, datatype, label) VALUES ( 'eg.grid.admin.booking.resource', 'gui', 'object', oils_i18n_gettext ( 'eg.grid.admin.booking.resource', 'Grid Config: admin.booking.resource', 'cwst', 'label' ) ), ( 'eg.grid.admin.booking.resource_attr', 'gui', 'object', oils_i18n_gettext ( 'eg.grid.admin.booking.resource_attr', 'Grid Config: admin.booking.resource_attr', 'cwst', 'label' ) ), ( 'eg.grid.admin.booking.resource_attr_map', 'gui', 'object', oils_i18n_gettext ( 'eg.grid.admin.booking.resource_attr_map', 'Grid Config: admin.booking.resource_attr_map', 'cwst', 'label' ) ), ( 'eg.grid.admin.booking.resource_attr_value', 'gui', 'object', oils_i18n_gettext ( 'eg.grid.admin.booking.resource_attr_value', 'Grid Config: admin.booking.resource_attr_value', 'cwst', 'label' ) ), ( 'eg.grid.admin.booking.resource_type', 'gui', 'object', oils_i18n_gettext ( 'eg.grid.admin.booking.resource_type', 'Grid Config: admin.booking.resource_type', 'cwst', 'label' ) );