X-Git-Url: http://git.equinoxoli.org/?p=migration-tools.git;a=blobdiff_plain;f=mig-xml%2Fmapping_reports.xml;fp=mig-xml%2Fmapping_reports.xml;h=55c12be29688dc18c23ac5eedb6bd3f4e694a500;hp=4c3362a17c4c04fbb0107a7d4a51bd193fd1125a;hb=f454a378e032ddd7d145498e606095ec441a0e40;hpb=fd86b98c39c0e8c9b74517579497b867fae13c37

diff --git a/mig-xml/mapping_reports.xml b/mig-xml/mapping_reports.xml
index 4c3362a..55c12be 100644
--- a/mig-xml/mapping_reports.xml
+++ b/mig-xml/mapping_reports.xml
@@ -513,7 +513,16 @@
         <heading>Count of Migratable Passwords / PINs</heading>
         <query>SELECT COUNT(pin) FROM borrower_csv_clean WHERE LENGTH(pin) > 1;</query>
     </report>
-    
+   
+    <report>
+        <name>hz_blocks</name>
+        <report_title>Borrower Blocks</report_title>
+        <tag>horizon2</tag>
+        <iteration>0</iteration>
+        <heading>Count of Entries.Block Description</heading>
+        <query>SELECT COUNT(*), b.descr FROM burb_csv_clean a JOIN block_csv_clean b ON a.block = b.block GROUP BY 2;</query>
+    </report>
+ 
     <report>
         <name>hz_borrowernotesample</name>
         <report_title>Borrower Note Field Samples</report_title>