X-Git-Url: http://git.equinoxoli.org/?p=migration-tools.git;a=blobdiff_plain;f=mig-xml%2Fexcel_mapping_reports.xml;h=219fc66a1f699d13a60e347945fb2f224714f64b;hp=4a84698afa534a3d98cea71da87f96704b9eb79a;hb=6c65de3aa51fec4db1324dc4f6149ef54936ade8;hpb=223a95e8f9bb82bb83a3de68ece7c0729d0c229c
diff --git a/mig-xml/excel_mapping_reports.xml b/mig-xml/excel_mapping_reports.xml
index 4a84698..219fc66 100644
--- a/mig-xml/excel_mapping_reports.xml
+++ b/mig-xml/excel_mapping_reports.xml
@@ -697,5 +697,51 @@
+
+
+
+ tlc_reports_load_asset_holdings_codes
+ Holdings Codes
+ tlc_reports
+ 0
+ Count.Library.Holdings Codes.Evergreen Circulation Modifier.Evergreen Shelving Locatione
+ SELECT COUNT(id), x_source, l_holdingscode FROM asset_copy_legacy GROUP BY 2, 3 ORDER BY 2, 3
+
+
+
+ tlc_reports_load_usrs_bygroup
+ Patrons by Agency Type
+ tlc_reports
+ 0
+ Count.Library.Permission Group.Evergreen Permission Group
+ SELECT COUNT(id), l_location, l_borrower_type FROM actor_usr_legacy GROUP BY 2, 3 ORDER BY 2, 3
+
+
+
+ tlc_reports_load_usr_balance
+ Count and Sum of Balances
+ tlc_reports
+ 0
+ Count.SUM.Migrate?
+ SELECT COUNT(id), SUM(l_current_fine_balance::NUMERIC(6,2)) FROM actor_usr_address_legacy WHERE l_current_fine_balance != '0' AND l_current_fine_balance IS NOT NULL
+
+
+
+ tlc_reports_users_blocked
+ Count of Blocked Patrons
+ tlc_reports
+ 0
+ Count.Blocked.Migrate?
+ SELECT COUNT(id), l_blocked FROM actor_usr_address_legacy GROUP BY 2
+
+
+
+ tlc_reports_load_usr_addresses_phones
+ Patron Phones
+ tlc_reports
+ 0
+ Count.Phone Type.Phone Type
+ SELECT COUNT(id), 'Phone 1' FROM actor_usr_address_legacy WHERE l_phone_1 IS NOT NULL GROUP BY 2 UNION ALL SELECT COUNT(id), 'Phone 2' FROM actor_usr_address_legacy WHERE l_phone_2 IS NOT NULL GROUP BY 2
+