moving horizong by sql to its own tag

diff --git a/mig-xml/excel_mapping_reports.xml b/mig-xml/excel_mapping_reports.xml
index 6c8dc73..c9636e5 100644 (file)
--- a/mig-xml/excel_mapping_reports.xml
+++ b/mig-xml/excel_mapping_reports.xml
@@ -475,7 +475,8 @@
         <note>These need to be mapped to Evergreen phone types.</note>
     </report>
 
-<!-- horizon -->
+<!-- horizon tag = from a sirsi supplied extract -->
+<!-- horizon2 tag = from direct database tables -->
 
     <report>
         <name>hz_borrowersbybtypes</name>
@@ -489,8 +490,8 @@
     <report>
         <name>hz_borrowersbybtypes</name>
         <report_title>Borrowers by Borrower Types</report_title>
-        <tag>horizon</tag>
-        <iteration>1</iteration>
+        <tag>horizon2</tag>
+        <iteration>0</iteration>
         <heading>Count.Borrower Type.Description</heading>
         <query>SELECT COUNT(*), a.btype, b.descr FROM borrower_csv_clean a JOIN btype_csv_clean b ON b.btype = a.btype  GROUP BY 2, 3 ORDER BY 2;</query>
     </report>
@@ -507,8 +508,8 @@
     <report>
         <name>hz_borrowerpincount</name>
         <report_title>Borrower PINs Count</report_title>
-        <tag>horizon</tag>
-        <iteration>1</iteration>
+        <tag>horizon2</tag>
+        <iteration>0</iteration>
         <heading>Count of Migratable Passwords / PINs</heading>
         <query>SELECT COUNT(pin) FROM borrower_csv_clean WHERE LENGTH(pin) > 1;</query>
     </report>
@@ -525,8 +526,8 @@
     <report>
         <name>hz_borrowernotesample</name>
         <report_title>Borrower Note Field Samples</report_title>
-        <tag>horizon</tag>
-        <iteration>1</iteration>
+        <tag>horizon2</tag>
+        <iteration>0</iteration>
         <heading>Sample of Migratable Notes</heading>
         <query>SELECT borrower_note FROM borrower_csv_clean WHERE LENGTH(borrower_note) > 1 LIMIT 20;</query>
     </report>
@@ -543,8 +544,8 @@
     <report>
         <name>hz_borrowernotescount</name>
         <report_title>Counnt of Migratable Borrower Notes</report_title>
-        <tag>horizon</tag>
-        <iteration>1</iteration>
+        <tag>horizon2</tag>
+        <iteration>0</iteration>
         <heading>Count</heading>
         <query>SELECT COUNT(borrower_note) FROM borrower_csv_clean WHERE LENGTH(borrower_note) > 1;</query>
     </report>
@@ -586,8 +587,8 @@
     <report>
         <name>hz_phones</name>
         <report_title>Borrower Phones</report_title>
-        <tag>horizon</tag>
-        <iteration>1</iteration>
+        <tag>horizon2</tag>
+        <iteration>0</iteration>
         <heading>Count.Borrower Phone Position</heading>
         <query>
         SELECT COUNT(*), '0' FROM borrower_phone_csv_clean WHERE ord = '0'
@@ -617,8 +618,8 @@
     <report>
         <name>hz_bstats</name>
         <report_title>Borrower B-Stats</report_title>
-        <tag>horizon</tag>
-        <iteration>1</iteration>
+        <tag>horizon2</tag>
+        <iteration>0</iteration>
         <heading>Count.B-Stat.Description</heading>
         <query>SELECT COUNT(*), a.bstat, b.descr FROM borrower_bstat_csv_clean a JOIN bstat_csv_clean b ON b.bstat = a.bstat GROUP BY 2, 3;
         </query>
@@ -636,8 +637,8 @@
        <report>    
            <name>hz_copybycollection</name>
         <report_title>Copies by Collection</report_title>
-        <tag>horizon</tag>
-        <iteration>1</iteration>
+        <tag>horizon2</tag>
+        <iteration>0</iteration>
         <heading>Count.Collection.Description.PAC Description</heading>
         <query>SELECT COUNT(*), a.collection, c.descr, c.pac_descr FROM item_csv_clean a JOIN collection_csv_clean c ON c.collection = a.collection GROUP BY 2, 3, 4 ORDER BY 2, 3, 4;</query>
     </report>
@@ -654,8 +655,8 @@
     <report>
         <name>hz_itemsbyitype</name>
         <report_title>Items by IType</report_title>
-        <tag>horizon</tag>
-        <iteration>1</iteration>
+        <tag>horizon2</tag>
+        <iteration>0</iteration>
         <heading>Count.Item Type (itype).Description</heading>
         <query>SELECT COUNT(*), a.itype, b.descr FROM item_csv_clean a JOIN itype_csv_clean b ON b.itype = a.itype  GROUP BY 2, 3 ORDER BY 2;</query>
     </report>
@@ -672,8 +673,8 @@
     <report>
         <name>hz_internalnotescount</name>
         <report_title>Internal/Check In Item Notes</report_title>
-        <tag>horizon</tag>
-        <iteration>1</iteration>
+        <tag>horizon2</tag>
+        <iteration>0</iteration>
         <heading>Count</heading>
         <query>SELECT COUNT(cki_notes) FROM item_csv_clean WHERE LENGTH(cki_notes) > 1;</query>
     </report>
@@ -690,8 +691,8 @@
     <report>
         <name>hz_internalnotesample</name>
         <report_title>Internal/Check In Item Notes Sample</report_title>
-        <tag>horizon</tag>
-        <iteration>1</iteration>
+        <tag>horizon2</tag>
+        <iteration>0</iteration>
         <heading>Count</heading>
         <query>SELECT cki_notes FROM item_csv_clean WHERE LENGTH(cki_notes) > 1 LIMIT 20;</query>
     </report>