From 7271d2ef9e197c42bb73b5562277ec905391678e Mon Sep 17 00:00:00 2001 From: Rogan Hamby Date: Thu, 15 Mar 2018 15:26:51 -0400 Subject: [PATCH] fixing some tag typos --- mig-xml/evergreen_full_system.xml | 110 ++++++++++++++++++------------------ 1 files changed, 55 insertions(+), 55 deletions(-) diff --git a/mig-xml/evergreen_full_system.xml b/mig-xml/evergreen_full_system.xml index 8ecc49f..6521a0b 100644 --- a/mig-xml/evergreen_full_system.xml +++ b/mig-xml/evergreen_full_system.xml @@ -3,7 +3,7 @@ circ_count - Circs + circs 0 Open Circulations Circulation Status.Count of Circs @@ -12,7 +12,7 @@ circ_by_orgunit - Circs + circs 0 Circulations by Org Unit Circulations Count.Org Unit @@ -21,7 +21,7 @@ circs_by_duration - Circs + circs 0 Circulations by Duration, Fine and Max Fine Count of Circs.Duration.Fine.Max Fine @@ -30,7 +30,7 @@ circs_by_usrgroup - Circs + circs 0 Circulations by Rules and Patron Group Count of Circs.Duration.Fine.Max Fine.User Group @@ -40,7 +40,7 @@ circs_by_circmod - Circs + circs 0 Circulations by Rules and Circulation Modifier Count of Circs.Duration.Fine.Max Fine.Circulation Modifier @@ -50,7 +50,7 @@ circs_by_orgunit - Circs + circs 0 Circulations by Rules and Org Unit Count of Circs.Duration.Fine.Max Fine.Library Branch @@ -59,7 +59,7 @@ non_cat_circs - Circs + circs 0 Non-Cataloged Circulation Circulations Count @@ -68,7 +68,7 @@ in_house - Circs + circs 0 In House Use In House Use Records @@ -77,7 +77,7 @@ circs_missing_rules - Circs + circs 0 Circs Missing Rules Count.Field Missing @@ -94,7 +94,7 @@ holds - Holds + holds 0 Holds Hold Type.Hold Count @@ -103,7 +103,7 @@ holds_bytype - Holds + holds 0 Holds By Type Hold Type.Hold Count @@ -112,7 +112,7 @@ transit_open_by_item_status - Holds + holds 0 Transit Copy Records and Status of Linked Items Count.Status @@ -121,7 +121,7 @@ transit_copies_by_status - Holds + holds 0 Status of Items with Count of Open In Transits Count.Status.Count of Open Transits @@ -130,7 +130,7 @@ hold_copies_by_status - Holds + holds 0 Captured Holds with Status of Items Count of Captured Hold.Status of Item @@ -142,7 +142,7 @@ asset.copy_count Count of Copies by Library - Assets + assets 0 Copy Count.Library SELECT COUNT(ac.id), aou.name FROM asset.copy ac JOIN actor.org_unit aou ON aou.id = ac.circ_lib GROUP BY 2 ORDER BY 2 @@ -151,7 +151,7 @@ asset.deleted_copies Deleted Copies - Assets + assets 0 Copy Count.Deleted SELECT COUNT(ac.id), ac.deleted::TEXT FROM asset.copy ac GROUP BY 2 @@ -160,7 +160,7 @@ asset.copies_by_status Copies by Status - Assets + assets 0 Copy Count.Status SELECT COUNT(ac.id), cs.name FROM asset.copy ac JOIN config.copy_status cs ON cs.id = ac.status GROUP BY 2 ORDER BY 2 @@ -169,7 +169,7 @@ asset.circ_mod_copies_count Copies by Circulation Modifier - Assets + assets 0 Copy Count.Circulation Modifier SELECT COUNT(ac.id), ac.circ_modifier FROM asset.copy ac GROUP BY 2 ORDER BY 2 @@ -178,7 +178,7 @@ asset.copy_notes Copy Notes - Assets + assets 0 Note Count.Public SELECT COUNT(acnote.id), acnote.pub::TEXT FROM asset.copy_note acnote GROUP BY 2 ORDER BY 2 @@ -187,7 +187,7 @@ asset.copy_notes Copy Notes - Assets + assets 0 Note Count.Public SELECT COUNT(acnote.id), acnote.pub::TEXT FROM asset.copy_note acnote GROUP BY 2 ORDER BY 2 @@ -196,7 +196,7 @@ asset.vols_by_lib Volumes by Library - Assets + assets 0 Volume Count.Library SELECT COUNT(acn.id), aou.name FROM asset.call_number acn JOIN actor.org_unit aou ON aou.id = acn.owning_lib GROUP BY 2 ORDER BY 2 @@ -205,7 +205,7 @@ asset.vols_by_lib Volumes by Library - Assets + assets 0 Volume Count.Library SELECT COUNT(acn.id), aou.name FROM asset.call_number acn JOIN actor.org_unit aou ON aou.id = acn.owning_lib GROUP BY 2 ORDER BY 2 @@ -214,7 +214,7 @@ asset.cops_by_loc_and_org Copies by Location - Assets + assets 0 Copy Count.Library.Circ Library SELECT COUNT(ac.id), acl.name, aou.name FROM asset.copy ac JOIN asset.copy_location acl ON acl.id = ac.location JOIN actor.org_unit aou ON aou.id = ac.circ_lib GROUP BY 2, 3 ORDER BY 2, 3 @@ -223,7 +223,7 @@ asset.barcode_lengths Barcode Lengths by Library - Assets + assets 0 Count of Barcode.Barcode Length.Library SELECT COUNT(ac.id), LENGTH(ac.barcode), aou.name FROM asset.copy ac JOIN actor.org_unit aou ON aou.id = ac.circ_lib GROUP BY 2, 3 ORDER BY 3, 2 @@ -232,7 +232,7 @@ asset.stat_cats Copy Statistical Categories - Assets + assets 0 Stat Cat Count.Library.Statistical Category SELECT COUNT(ac_sc.id), aou.name, ac_sc.name FROM asset.stat_cat ac_sc JOIN actor.org_unit aou ON aou.id = ac_sc.owner GROUP BY 2,3 ORDER BY 2,3 @@ -241,7 +241,7 @@ asset.stat_cats Copy Statistical Categories - Assets + assets 0 Stat Cat Count.Library.Statistical Category SELECT COUNT(ac_sc.id), aou.name, ac_sc.name FROM asset.stat_cat ac_sc JOIN actor.org_unit aou ON aou.id = ac_sc.owner GROUP BY 2,3 ORDER BY 2,3 @@ -250,7 +250,7 @@ asset.stat_cat_entries Copy Stat Cat User Entries - Assets + assets 0 Copy Stat Count.Library.Statistical Category SELECT COUNT(map.id), aou.name, ac_sc.name FROM asset.stat_cat_entry_copy_map map JOIN asset.stat_cat ac_sc ON ac_sc.id = map.stat_cat JOIN actor.org_unit aou ON aou.id = ac_sc.owner GROUP BY 2,3 ORDER BY 2,3 @@ -259,7 +259,7 @@ asset.stat_cat_entries Copy Stat Cat User Entries - Assets + assets 0 Copy Stat Count.Library.Statistical Category SELECT COUNT(map.id), aou.name, ac_sc.name FROM asset.stat_cat_entry_copy_map map JOIN asset.stat_cat ac_sc ON ac_sc.id = map.stat_cat JOIN actor.org_unit aou ON aou. @@ -269,7 +269,7 @@ id = ac_sc.owner GROUP BY 2,3 ORDER BY 2,3 asset.copy_tags Copy Tags - Assets + assets 0 Tag Count.Copy Tag Type.Copy Tag Label.Staff Note.Public SELECT COUNT(map.id), tag.tag_type, tag.label, tag.staff_note, tag.pub FROM asset.copy_tag tag JOIN asset.copy_tag_copy_map map ON map.tag = tag.id GROUP BY 2,3,4,5 ORDER BY 2,3 @@ -280,7 +280,7 @@ id = ac_sc.owner GROUP BY 2,3 ORDER BY 2,3 money.billing_voided Bills Voided And Not - Money + money 0 Count.Voided.Sum SELECT COUNT(a.id), a.voided::TEXT, SUM(a.amount) FROM money.billing a GROUP BY 2 ORDER BY 2 @@ -289,7 +289,7 @@ id = ac_sc.owner GROUP BY 2,3 ORDER BY 2,3 money.billing_voided Bills Voided And Not - Money + money 0 Count.Voided.Sum SELECT COUNT(a.id), a.voided::TEXT, SUM(a.amount) FROM money.billing a GROUP BY 2 ORDER BY 2, 3 @@ -298,7 +298,7 @@ id = ac_sc.owner GROUP BY 2,3 ORDER BY 2,3 money.billing_by_type Bills by Type - Money + money 0 Count.Billing Type SELECT COUNT(a.id), a.billing_type FROM money.billing a GROUP BY 2 ORDER BY 2 @@ -307,7 +307,7 @@ id = ac_sc.owner GROUP BY 2,3 ORDER BY 2,3 money.billing_by_type Bills by Type - Money + money 0 Count.Billing Type SELECT COUNT(a.id), a.billing_type FROM money.billing a GROUP BY 2 ORDER BY 2 @@ -316,7 +316,7 @@ id = ac_sc.owner GROUP BY 2,3 ORDER BY 2,3 money.cash_payment Cash Payments - Money + money 0 Count.Voided.Sum SELECT COUNT(a.id), a.voided::TEXT, SUM(a.amount) FROM money.cash_payment a GROUP BY 2 ORDER BY 2 @@ -325,7 +325,7 @@ id = ac_sc.owner GROUP BY 2,3 ORDER BY 2,3 money.cash_payment Cash Payments - Money + money 0 Count.Voided.Sum SELECT COUNT(a.id), a.voided::TEXT, SUM(a.amount) FROM money.cash_payment a GROUP BY 2 ORDER BY 2 @@ -334,7 +334,7 @@ id = ac_sc.owner GROUP BY 2,3 ORDER BY 2,3 money.check_payment Check Payments - Money + money 0 Count.Voided.Sum SELECT COUNT(a.id), a.voided::TEXT, SUM(a.amount) FROM money.check_payment a GROUP BY 2 ORDER BY 2 @@ -343,7 +343,7 @@ id = ac_sc.owner GROUP BY 2,3 ORDER BY 2,3 money.forgive_payment Forgive Payments - Money + money 0 Count.Voided.Sum SELECT COUNT(a.id), a.voided::TEXT, SUM(a.amount) FROM money.forgive_payment a GROUP BY 2 ORDER BY 2 @@ -353,7 +353,7 @@ id = ac_sc.owner GROUP BY 2,3 ORDER BY 2,3 bibswovolumes Bibliographic Records Without Volumes - Bibs + bibs 0 Count SELECT COUNT(id) FROM biblio.record_entry where id NOT IN (SELECT DISTINCT record FROM asset.call_number) AND deleted IS FALSE @@ -362,7 +362,7 @@ id = ac_sc.owner GROUP BY 2,3 ORDER BY 2,3 bibs_notes Bib Record Notes - Bibs + bibs 0 Count SELECT COUNT(b.id) FROM biblio.record_note b @@ -371,7 +371,7 @@ id = ac_sc.owner GROUP BY 2,3 ORDER BY 2,3 bibs_peers Peer Bib Copies - Bibs + bibs 0 Count SELECT COUNT(b.id) FROM biblio.peer_bib_copy_map b @@ -380,7 +380,7 @@ id = ac_sc.owner GROUP BY 2,3 ORDER BY 2,3 bibs_parts Monograph Parts - Bibs + bibs 0 Count SELECT COUNT(b.id) FROM biblio.monograph_part b @@ -391,7 +391,7 @@ id = ac_sc.owner GROUP BY 2,3 ORDER BY 2,3 usrsbyorg Patrons by Home Org - Actors + actors 0 Count.Library.Deleted SELECT COUNT(au.id), aou.name, au.deleted::TEXT FROM actor.usr au JOIN actor.org_unit aou ON aou.id = au.home_ou GROUP BY 2, 3 ORDER BY 2, 3 @@ -400,7 +400,7 @@ id = ac_sc.owner GROUP BY 2,3 ORDER BY 2,3 usrsbypgt Patrons by Permission Group - Actors + actors 0 Count.Permission Group SELECT COUNT(au.id), pgt.name FROM actor.usr au JOIN permission.grp_tree pgt ON pgt.id = au.profile GROUP BY 2 ORDER BY 2 @@ -409,7 +409,7 @@ id = ac_sc.owner GROUP BY 2,3 ORDER BY 2,3 active_usrs Patrons by Active Status - Actors + actors 0 Count of Users.Active SELECT COUNT(id), active::TEXT FROM actor.usr GROUP BY 2 @@ -418,7 +418,7 @@ id = ac_sc.owner GROUP BY 2,3 ORDER BY 2,3 active_usr_barcodes Patron Barcodes by Active Status - Actors + actors 0 Count of Barcodes.Active SELECT COUNT(id), active::TEXT FROM actor.card GROUP BY 2 @@ -427,7 +427,7 @@ id = ac_sc.owner GROUP BY 2,3 ORDER BY 2,3 usr_barcode_lengths Barcode Lengths by Library - Actors + actors 0 Count of Barcode.Barcode Length.Library SELECT COUNT(acard.id), LENGTH(acard.barcode), aou.name FROM actor.card acard JOIN actor.usr au ON au.id = acard.usr JOIN actor.org_unit aou ON aou.id = au.home_ou GROUP BY 2, 3 ORDER BY 3, 2 @@ -436,7 +436,7 @@ id = ac_sc.owner GROUP BY 2,3 ORDER BY 2,3 usr_barcode_patterns Common Barcode Starting Patterns - Actors + actors 0 Count of Barcodes (greater than 10).Left 60% of Characters SELECT COUNT(acard.id), LEFT(acard.barcode,(ROUND(LENGTH(acard.barcode)*.6))::INT) FROM actor.card acard GROUP BY 2 HAVING COUNT(acard.id) > 10 ORDER BY 2 @@ -445,7 +445,7 @@ id = ac_sc.owner GROUP BY 2,3 ORDER BY 2,3 usr_addressses_status Patron Addresses by Valid Status - Actors + actors 0 Count.Valid SELECT COUNT(aua.id), valid::TEXT FROM actor.usr_address aua GROUP BY 2 @@ -454,7 +454,7 @@ id = ac_sc.owner GROUP BY 2,3 ORDER BY 2,3 usr_addresses_pending Patron Addresses by Pending Status - Actors + actors 0 Count of Addresses.Pending SELECT COUNT(aua.id), pending::TEXT FROM actor.usr_address aua GROUP BY 2 @@ -463,7 +463,7 @@ id = ac_sc.owner GROUP BY 2,3 ORDER BY 2,3 usr_messages Patron Messages - Actors + actors 0 Count.Deleted SELECT COUNT(aum.id), deleted::TEXT FROM actor.usr_message aum GROUP BY 2 @@ -472,7 +472,7 @@ id = ac_sc.owner GROUP BY 2,3 ORDER BY 2,3 usr_notes Patron Notes - Actors + actors 0 Count.Public SELECT COUNT(aun.id), pub::TEXT FROM actor.usr_note aun GROUP BY 2 @@ -481,7 +481,7 @@ id = ac_sc.owner GROUP BY 2,3 ORDER BY 2,3 usr_stat_cats Patron Statistical Categories - Actors + actors 0 Stat Cat Count.Library.Statistical Category SELECT COUNT(au_sc.id), aou.name, au_sc.name FROM actor.stat_cat au_sc JOIN actor.org_unit aou ON aou.id = au_sc.owner GROUP BY 2, 3 ORDER BY 2, 3 @@ -490,7 +490,7 @@ id = ac_sc.owner GROUP BY 2,3 ORDER BY 2,3 usr_stat_cat_entries Patron Stat Cat User Entries - Actors + actors 0 Patron Stat Count.Library.Statistical Category SELECT COUNT(map.id), aou.name, au_sc.name FROM actor.stat_cat_entry_usr_map map JOIN actor.stat_cat au_sc ON au_sc.id = map.stat_cat JOIN actor.org_unit aou ON aou.id = au_sc.owner GROUP BY 2, 3 ORDER BY 2,3 @@ -500,7 +500,7 @@ id = ac_sc.owner GROUP BY 2,3 ORDER BY 2,3 fund_count 0 - Acq + acq Funds Number of Funds SELECT COUNT(id) FROM acq.fund; @@ -509,7 +509,7 @@ id = ac_sc.owner GROUP BY 2,3 ORDER BY 2,3 invoice_count 0 - Acq + acq Invoices Number of Funds SELECT COUNT(id) FROM acq.invoice; -- 1.7.2.5