From 404fba950704f6ed408e0018435d9036c2b8cf80 Mon Sep 17 00:00:00 2001
From: Rogan Hamby <rhamby@esilibrary.com>
Date: Tue, 6 Mar 2018 09:28:20 -0500
Subject: [PATCH] added thresholds report for test load reports

---
 mig-xml/evergreen_staged_report.xml |   12 ++++++++++++
 1 files changed, 12 insertions(+), 0 deletions(-)

diff --git a/mig-xml/evergreen_staged_report.xml b/mig-xml/evergreen_staged_report.xml
index 31fca03..3cc0c12 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>
-- 
1.7.2.5