X-Git-Url: http://git.equinoxoli.org/?p=migration-tools.git;a=blobdiff_plain;f=mig-xml%2Fevergreen_staged_report.xml;h=b246603d86e7d89cf60dc2d988f31c3e87759571;hp=31fca03796f1ed30a3db9e5bd77e19d8ba2b2003;hb=6ddea01a5729d7d83209d4490245c5fbde64ac80;hpb=91f3fc3c89d088788f7064bc06764ff83a40e607

diff --git a/mig-xml/evergreen_staged_report.xml b/mig-xml/evergreen_staged_report.xml
index 31fca03..b246603 100644
--- a/mig-xml/evergreen_staged_report.xml
+++ b/mig-xml/evergreen_staged_report.xml
@@ -968,6 +968,18 @@ id = ac_sc.owner GROUP BY 2,3 ORDER BY 2,3</query>
         <query>SELECT COUNT(map.id), aou.name, au_sc.name FROM actor_stat_cat_entry_usr_map map JOIN actor_stat_cat au_sc ON au_sc.id = map.stat_cat JOIN actor.org_unit aou ON aou.id = au_sc.owner GROUP BY 2, 3 ORDER BY 2,3</query>
     </report>
 
+    <report>
+        <name>usr_thresholds</name>
+        <report_title>Patron Thresholds</report_title>
+        <tag>actors</tag>
+        <iteration>0</iteration>
+        <heading>Pateron Group.Org Unit.Penalty.Threshold</heading>
+        <query>SELECT pgt.name, aou.shortname, sp.name, p.threshold FROM permission_grp_penalty_threshold p 
+                JOIN actor.org_unit aou ON aou.id = p.org_unit JOIN permission.grp_tree pgt ON pgt.id = p.grp JOIN config.standing_penalty sp ON sp.id = p.penalty
+                ORDER BY 2, 1, 3</query>
+    </report>
+
+
     <!-- ACQUISITIONS REPORTS -->
     <report>
         <name>fund_count</name>
@@ -1012,7 +1024,63 @@ id = ac_sc.owner GROUP BY 2,3 ORDER BY 2,3</query>
         <iteration>0</iteration>
         <report_title>Migrated Serial MFHDs</report_title>
         <heading>Number of MFHDs</heading>
-        <query>SELECT COUNT(id) FROM seriarecord_entry</query>
+        <query>SELECT COUNT(id) FROM serial_record_entry</query>
+    </report>
+
+    <!-- DEDUPE REPORTS -->
+
+    <asset>
+        <name>dedupe_explain</name>
+        <tag>dedupe</tag>
+        <file>dedupe_process.asciidoc</file> 
+    </asset>
+
+    <report>
+        <name>dedupe_bib_groups</name>
+        <tag>dedupe</tag>
+        <iteration>0</iteration>
+        <report_title>Scoring and Bib Record Groups</report_title>
+        <heading>Count.Bib REcord Groups</heading>
+        <query>SELECT COUNT(id), 'Total Bibs Being Evaluated' FROM biblio.record_entry WHERE deleted IS FALSE AND id IN (SELECT eg::BIGINT FROM bib_id_map)
+          UNION ALL SELECT (COUNT(DISTINCT incoming_bib)), 'Incoming Bibs With Matches Found' FROM bib_matches
+          UNION ALL SELECT (COUNT(bre.id) - (SELECT COUNT(DISTINCT incoming_bib) FROM bib_matches)), 'Incoming Bibs With No Match' 
+                FROM biblio.record_entry bre WHERE bre.deleted IS FALSE AND bre.id IN (SELECT eg::BIGINT FROM bib_id_map)
+          UNION ALL SELECT COUNT(DISTINCT incoming_bib), 'Incoming Bibs Being Merged into Incumbent' FROM bib_matches WHERE incumbent_bib_score &gt;= incoming_bib_score
+          UNION ALL SELECT COUNT(id), 'Incumbent Bibs With Higher Scores to Incoming' FROM bib_matches WHERE incumbent_bib_score &gt; incoming_bib_score
+          UNION ALL SELECT COUNT(id), 'Incumbent Bibs With Equal Scores to Incoming' FROM bib_matches WHERE incumbent_bib_score = incoming_bib_score
+          UNION ALL SELECT COUNT(id), 'Incumbent Bibs  With Lower Scores to Incoming' FROM bib_matches WHERE incumbent_bib_score &lt; incoming_bib_score
+          ;</query>
+    </report>
+
+    <report>
+        <name>dedupe_format_count</name>
+        <tag>dedupe</tag>
+        <iteration>0</iteration>
+        <report_title>Count of Items Matching By Format</report_title>
+        <heading>Count.Format(s)</heading>
+        <query>SELECT COUNT(id), search_formats FROM bib_matches GROUP BY 2 ORDER BY 2;</query>
+    </report>
+    
+    <report>
+        <name>dedupe_score_ranges</name>
+        <tag>dedupe</tag>
+        <iteration>0</iteration>
+        <report_title>Count of Items Matching By Format</report_title>
+        <heading>Lowest Record Score.Largest Record Score.Record Set</heading>
+        <query>SELECT MIN(incumbent_bib_score), MAX(incumbent_bib_score), 'Incumbent Records' FROM bib_matches 
+            UNION ALL SELECT MIN(incoming_bib_score), MAX(incoming_bib_score), 'Incoming Records' FROM bib_matches ;
+        </query>
+    </report>
+    
+    
+    <report>
+        <name>dedupe_sample_set</name>
+        <tag>dedupe</tag>
+        <iteration>0</iteration>
+        <report_title>Sample of 20 Matching Dedupe Record Sets</report_title>
+        <heading>Bib Being Merged Into.Bib Being Merged</heading>
+        <query>SELECT incumbent_bib, incoming_bib FROM bib_matches WHERE incumbent_bib_score &gt;= incoming_bib_score LIMIT 20 ;
+        </query>
     </report>
 
 </reports_file>