From f2c19308c36af103c2a6f92380a2dd6c1f262be9 Mon Sep 17 00:00:00 2001 From: Rogan Hamby Date: Tue, 20 Mar 2018 15:30:16 -0400 Subject: [PATCH] removing unneeded file --- mig-xml/resource_mate.xml | 211 --------------------------------------------- 1 files changed, 0 insertions(+), 211 deletions(-) delete mode 100644 mig-xml/resource_mate.xml diff --git a/mig-xml/resource_mate.xml b/mig-xml/resource_mate.xml deleted file mode 100644 index e58e572..0000000 --- a/mig-xml/resource_mate.xml +++ /dev/null @@ -1,211 +0,0 @@ - - - - - - - rm_load_circ_count - circs - 0 - Circulations in Extract - Count of Circs.Status - SELECT COUNT(id), l_is_checked_out FROM 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 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 asset_copy_legacy GROUP BY 2 ORDER BY 2 - - - - rm_load_asset_by_category - Count of Copies in Extract by Category - assets - 0 - Count.Category - SELECT COUNT(*), l_category FROM asset_copy_legacy GROUP BY 2 ORDER BY 2 - - - - rm_load_asset_by_status - Count of Copies in Extract by Status - assets - 0 - Count.Status - SELECT COUNT(*), l_status FROM 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 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 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 fines WHERE multi_au IS TRUE ORDER BY 2, 1 - - - - - - - - rm_load_bibs_loaded - Bibs Successfully Staged - bibs - 0 - Count - SELECT COUNT(eg) FROM bib_id_map - - - - - - rm_actor_address_summary - Patrons Address Components - actors - 0 - Count.Address Component - SELECT COUNT(id), 'Address 1' FROM actor_usr_legacy WHERE LENGTH(l_address_1) > 1 - UNION ALL SELECT COUNT(id), 'Address 2' FROM actor_usr_legacy WHERE LENGTH(l_address_2) > 1 - UNION ALL SELECT COUNT(id), 'City' FROM actor_usr_legacy WHERE LENGTH(l_city) > 1 - UNION ALL SELECT COUNT(id), 'State' FROM actor_usr_legacy WHERE LENGTH(l_state) > 1 - UNION ALL SELECT COUNT(id), 'County' FROM actor_usr_legacy WHERE LENGTH(l_country) > 1 - UNION ALL SELECT COUNT(id), 'Zip Code' FROM 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 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 actor_usr_legacy GROUP BY 2 ORDER BY 2; - - - - - rm_actor_birthdates - Patrons with Birthdates - actors - 0 - Count - SELECT COUNT(id) FROM 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 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 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 actor_usr_legacy WHERE LENGTH(l_e_mail) > 1 - UNION ALL SELECT COUNT(id), 'Phone (home)' FROM actor_usr_legacy WHERE LENGTH(l_phone_home) > 1 - UNION ALL SELECT COUNT(id), 'Phone (work)' FROM actor_usr_legacy WHERE LENGTH(l_phone_work) > 1 - UNION ALL SELECT COUNT(id), 'Phone (cell)' FROM 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 actor_usr_legacy WHERE LENGTH(l_comments) > 1 - UNION ALL SELECT NULL, l_comments FROM 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 actor_usr_legacy WHERE LENGTH(l_circulation_note) > 1 - UNION ALL SELECT NULL, l_circulation_note FROM actor_usr_legacy WHERE LENGTH(l_circulation_note) > 1 LIMIT 10 - - - - -- 1.7.2.5