From 337680650a86c2fb1c5d5bddfb4053a56fb9964b Mon Sep 17 00:00:00 2001 From: Rogan Hamby Date: Tue, 27 Feb 2018 11:34:46 -0500 Subject: [PATCH] adding load report file for resource mate --- mig-xml/resource_mate.xml | 211 +++++++++++++++++++++++++++++++++++++++++++++ 1 files changed, 211 insertions(+), 0 deletions(-) create mode 100644 mig-xml/resource_mate.xml diff --git a/mig-xml/resource_mate.xml b/mig-xml/resource_mate.xml new file mode 100644 index 0000000..d79091c --- /dev/null +++ b/mig-xml/resource_mate.xml @@ -0,0 +1,211 @@ + + + + + + + rm_load_circ_count + circs + 0 + Circulations in Extract + Count of Circs.Status + SELECT COUNT(id), l_is_checked_out FROM MIGSCHEMA.asset_copy_legacy GROUP BY 2 + + + + + + + + rm_load_asset_by_resource_type + Count of Copies in Extract by Resource Type + assets + 0 + Count.Resource Type + SELECT COUNT(*), l_resource_type FROM MIGSCHEMA.asset_copy_legacy GROUP BY 2 ORDER BY 2 + + + + rm_load_asset_by_location + Count of Copies in Extract by Location + assets + 0 + Count.Location + SELECT COUNT(*), l_location FROM MIGSCHEMA.asset_copy_legacy GROUP BY 2 ORDER BY 2 + + + + rm_load_asset_by_category + Count of Copies in Extract by Category + assets + 0 + Count.Location + SELECT COUNT(*), l_location FROM MIGSCHEMA.asset_copy_legacy GROUP BY 2 ORDER BY 2 + + + + rm_load_asset_by_status + Count of Copies in Extract by Status + assets + 0 + Count.Location + SELECT COUNT(*), l_status FROM MIGSCHEMA.asset_copy_legacy GROUP BY 2 ORDER BY 2 + + + + + + + + rm_accounts_with_fines + Count of Accounts with a Grocery Bill to Migrate + money + 0 + Count + SELECT COUNT(*) FROM MIGSCHEMA.fines + + + + rm_fine_w_no_account + Fines with No Matching Account + money + 0 + First Name.Last Name.Fine Amount + SELECT first_given_name, family_name, amount FROM MIGSCHEMA.fines WHERE au_id IS NULL ORDER BY 2, 1 + + + + rm_fine_w_multi_matching + Fines with Multiple Matching Accounts + money + 0 + First Name.Last Name.Fine Amount + SELECT first_given_name, family_name, amount FROM MIGSCHEMA.fines WHERE multi_au IS TRUE ORDER BY 2, 1 + + + + + + + + rm_load_bibs_loaded + Bibs Successfully Staged + bibs + 0 + Count + SELECT COUNT(eg) FROM MIGSCHEMA.bib_id_map + + + + + + rm_actor_address_summary + Patrons Address Components + actors + 0 + Count.Address Component + SELECT COUNT(id), 'Address 1' FROM MIGSCHEMA.actor_usr_legacy WHERE LENGTH(l_address_1) > 1 + UNION ALL SELECT COUNT(id), 'Address 2' FROM MIGSCHEMA.actor_usr_legacy WHERE LENGTH(l_address_2) > 1 + UNION ALL SELECT COUNT(id), 'City' FROM MIGSCHEMA.actor_usr_legacy WHERE LENGTH(l_city) > 1 + UNION ALL SELECT COUNT(id), 'State' FROM MIGSCHEMA.actor_usr_legacy WHERE LENGTH(l_state) > 1 + UNION ALL SELECT COUNT(id), 'County' FROM MIGSCHEMA.actor_usr_legacy WHERE LENGTH(l_country) > 1 + UNION ALL SELECT COUNT(id), 'Zip Code' FROM MIGSCHEMA.actor_usr_legacy WHERE LENGTH(l_zip_code) > 1 + + + + + rm_actor_expirations + Patrons by Year of Expiration + actors + 0 + Count.Expiration Year + SELECT COUNT(id), RIGHT(BTRIM(l_membership_expiry),4) FROM MIGSCHEMA.actor_usr_legacy GROUP BY 2 ORDER BY 2; + + + + + rm_actor_barcodes + Patrons by Barcode Length + actors + 0 + Count.Barcode Length + SELECT COUNT(id), LENGTH(l_barcode) FROM MIGSCHEMA.actor_usr_legacy GROUP BY 2 ORDER BY 2; + + + + + rm_actor_birthdates + Patrons with Birthdates + actors + 0 + Count + SELECT COUNT(id) FROM MIGSCHEMA.actor_usr_legacy WHERE LENGTH(l_birthdate) > 1; + + + + + rm_actor_groups + Patrons by User Groups + actors + 0 + Count.Group + SELECT COUNT(id), l_user_group FROM MIGSCHEMA.actor_usr_legacy GROUP BY 2 ORDER BY 2; + + + + + rm_actor_access + Patrons by Access Field + actors + 0 + Count.Access + SELECT COUNT(id), l_access_if_applicable FROM MIGSCHEMA.actor_usr_legacy GROUP BY 2 ORDER BY 2; + + + + + rm_actor_contact_summary + Patrons Contact Fields + actors + 0 + Count.Address Component + SELECT COUNT(id), 'email' FROM MIGSCHEMA.actor_usr_legacy WHERE LENGTH(l_e_mail) > 1 + UNION ALL SELECT COUNT(id), 'Phone (home)' FROM MIGSCHEMA.actor_usr_legacy WHERE LENGTH(l_phone_home) > 1 + UNION ALL SELECT COUNT(id), 'Phone (work)' FROM MIGSCHEMA.actor_usr_legacy WHERE LENGTH(l_phone_work) > 1 + UNION ALL SELECT COUNT(id), 'Phone (cell)' FROM MIGSCHEMA.actor_usr_legacy WHERE LENGTH(l_phone_cell) > 1 + + + + + rm_actor_comments + Patrons Comments Count and Sample + actors + 0 + Count.Sample + SELECT COUNT(id), 'All Comments' FROM MIGSCHEMA.actor_usr_legacy WHERE LENGTH(l_comments) > 1 + UNION ALL SELECT NULL, l_comments FROM MIGSCHEMA.actor_usr_legacy WHERE LENGTH(l_comments) > 1 LIMIT 10 + + + + + rm_actor_circulation_note + Patrons Circulation Notes Count and Sample + actors + 0 + Count.Sample + SELECT COUNT(id), 'All Notes' FROM MIGSCHEMA.actor_usr_legacy WHERE LENGTH(l_circulation_note) > 1 + UNION ALL SELECT NULL, l_circulation_note FROM MIGSCHEMA.actor_usr_legacy WHERE LENGTH(l_circulation_note) > 1 LIMIT 10 + + + + -- 1.7.2.5