X-Git-Url: http://git.equinoxoli.org/?p=migration-tools.git;a=blobdiff_plain;f=mig-xml%2Fevergreen_staged_report.xml;h=2e2b3d64a76cc9155b94e51b5f0c115f0a29a214;hp=31fca03796f1ed30a3db9e5bd77e19d8ba2b2003;hb=d29fd55ce9396b284b65a65260296a86b47a92b5;hpb=91f3fc3c89d088788f7064bc06764ff83a40e607
diff --git a/mig-xml/evergreen_staged_report.xml b/mig-xml/evergreen_staged_report.xml
index 31fca03..2e2b3d6 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
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
+
+ usr_thresholds
+ Patron Thresholds
+ actors
+ 0
+ Pateron Group.Org Unit.Penalty.Threshold
+ 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
+
+
+
fund_count
@@ -1012,7 +1024,58 @@ id = ac_sc.owner GROUP BY 2,3 ORDER BY 2,3
0
Migrated Serial MFHDs
Number of MFHDs
- SELECT COUNT(id) FROM seriarecord_entry
+ SELECT COUNT(id) FROM serial_record_entry
+
+
+
+
+
+ dedupe_explain
+ dedupe
+ dedupe_process.asciidoc
+
+
+
+ dedupe_format_count
+ dedupe
+ 0
+ Count of Items Matching By Format
+ Count.Format(s)
+ SELECT COUNT(id), search_formats FROM bib_matches GROUP BY 2 ORDER BY 2;
+
+
+
+ dedupe_scores
+ dedupe
+ 0
+ Scoring Values in Matches
+ Count.Scoring Information
+ SELECT COUNT(id), 'Incumbent Records With Higher Scores to Incoming' FROM bib_matches WHERE incumbent_bib_score > incoming_bib_score
+ UNION ALL SELECT COUNT(id), 'Incumbent Records With Equal Scores to Incoming' FROM bib_matches WHERE incumbent_bib_score = incoming_bib_score
+ UNION ALL SELECT COUNT(id), 'Incumbent Records With Lower Scores to Incoming' FROM bib_matches WHERE incumbent_bib_score < incoming_bib_score
+ ;
+
+
+
+ dedupe_score_ranges
+ dedupe
+ 0
+ Count of Items Matching By Format
+ Lowest Record Score.Largest Record Score.Record Set
+ 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 ;
+
+
+
+
+
+ dedupe_sample_set
+ dedupe
+ 0
+ Sample of 20 Matching Dedupe Record Sets
+ Bib Being Merged Into.Bib Being Merged
+ SELECT incumbent_bib, incoming_bib FROM bib_matches WHERE incumbent_bib_score >= incoming_bib_score LIMIT 20 ;
+