adding tlc mappings for when run from reports

[migration-tools.git] / mig-xml / excel_mapping_reports.xml

diff --git a/mig-xml/excel_mapping_reports.xml b/mig-xml/excel_mapping_reports.xml
index 4a84698..219fc66 100644 (file)
--- a/mig-xml/excel_mapping_reports.xml
+++ b/mig-xml/excel_mapping_reports.xml
@@ -697,5 +697,51 @@
         </query>
     </report>
 
+<!-- tlc reports -->
+
+    <report>
+        <name>tlc_reports_load_asset_holdings_codes</name>
+        <report_title>Holdings Codes</report_title>
+        <tag>tlc_reports</tag>
+        <iteration>0</iteration>
+        <heading>Count.Library.Holdings Codes.Evergreen Circulation Modifier.Evergreen Shelving Locatione</heading>
+        <query>SELECT COUNT(id), x_source, l_holdingscode FROM asset_copy_legacy GROUP BY 2, 3 ORDER BY 2, 3</query>
+    </report>
+
+    <report>
+        <name>tlc_reports_load_usrs_bygroup</name>
+        <report_title>Patrons by Agency Type</report_title>
+        <tag>tlc_reports</tag>
+        <iteration>0</iteration>
+        <heading>Count.Library.Permission Group.Evergreen Permission Group</heading>
+        <query>SELECT COUNT(id), l_location, l_borrower_type FROM actor_usr_legacy GROUP BY 2, 3 ORDER BY 2, 3</query>
+    </report>
+
+    <report>
+        <name>tlc_reports_load_usr_balance</name>
+        <report_title>Count and Sum of Balances</report_title>
+        <tag>tlc_reports</tag>
+        <iteration>0</iteration>
+        <heading>Count.SUM.Migrate?</heading>
+        <query>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</query>
+    </report>
+
+    <report>
+        <name>tlc_reports_users_blocked</name>
+        <report_title>Count of Blocked Patrons</report_title>
+        <tag>tlc_reports</tag>
+        <iteration>0</iteration>
+        <heading>Count.Blocked.Migrate?</heading>
+        <query>SELECT COUNT(id), l_blocked FROM actor_usr_address_legacy GROUP BY 2</query>
+    </report>
+
+    <report>
+        <name>tlc_reports_load_usr_addresses_phones</name>
+        <report_title>Patron Phones</report_title>
+        <tag>tlc_reports</tag>
+        <iteration>0</iteration>
+        <heading>Count.Phone Type.Phone Type</heading>
+        <query>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</query>
+    </report>
 
 </reports_file>