X-Git-Url: http://git.equinoxoli.org/?p=migration-tools.git;a=blobdiff_plain;f=mig-xml%2Fevergreen_full_system.xml;h=e972f6a9e1ce2df755c3b826cca9f91773d0b78c;hp=23cabe12edbbc5eab169abe7ea98ff3fe58491b0;hb=49c84ca86a91a97007c975eff40d50890cc46fbb;hpb=f6cd03484681b48b38b7d26d9e0afbfd108a7a90
diff --git a/mig-xml/evergreen_full_system.xml b/mig-xml/evergreen_full_system.xml
index 23cabe1..e972f6a 100644
--- a/mig-xml/evergreen_full_system.xml
+++ b/mig-xml/evergreen_full_system.xml
@@ -23,9 +23,9 @@
circs_by_duration
circs
0
- Circulations by Duration, Fine and Max Fine
+ Circulations by Duration, Fine and Max Fine Rules
Count of Circs.Duration.Fine.Max Fine
- SELECT COUNT(id), duration, recurring_fine, max_fine FROM action.circulation GROUP BY 2, 3, 4 ORDER BY 2, 3, 4
+ SELECT COUNT(id), duration_rule, recurring_fine_rule, max_fine_rule FROM action.circulation GROUP BY 2, 3, 4 ORDER BY 2, 3, 4
@@ -34,7 +34,7 @@
0
Circulations by Rules and Patron Group
Count of Circs.Duration.Fine.Max Fine.User Group
- SELECT COUNT(acirc.id), acirc.duration, acirc.recurring_fine, acirc.max_fine, pgt.name FROM action.circulation acirc JOIN actor.usr au ON au.id = acirc.usr JOIN permission.grp_tree pgt ON pgt.id = au.profile
+ SELECT COUNT(acirc.id), acirc.duration_rule, acirc.recurring_fine_rule, acirc.max_fine_rule, pgt.name FROM action.circulation acirc JOIN actor.usr au ON au.id = acirc.usr JOIN permission.grp_tree pgt ON pgt.id = au.profile
GROUP BY 2, 3, 4, 5 ORDER BY 2, 3, 4, 5
@@ -44,7 +44,7 @@
0
Circulations by Rules and Circulation Modifier
Count of Circs.Duration.Fine.Max Fine.Circulation Modifier
- SELECT COUNT(acirc.id), acirc.duration, acirc.recurring_fine, acirc.max_fine, ac.circ_modifier FROM action.circulation acirc JOIN asset.copy ac ON ac.id = acirc.target_copy
+ SELECT COUNT(acirc.id), acirc.duration_rule, acirc.recurring_fine_rule, acirc.max_fine_rule, ac.circ_modifier FROM action.circulation acirc JOIN asset.copy ac ON ac.id = acirc.target_copy
GROUP BY 2, 3, 4, 5 ORDER BY 2, 3, 4, 5
@@ -54,7 +54,7 @@
0
Circulations by Rules and Org Unit
Count of Circs.Duration.Fine.Max Fine.Library Branch
- SELECT COUNT(acirc.id), acirc.duration, acirc.recurring_fine, acirc.max_fine, aou.name FROM action.circulation acirc JOIN actor.org_unit aou ON aou.id = acirc.circ_lib GROUP BY 2, 3, 4, 5 ORDER BY 2, 3, 4, 5
+ SELECT COUNT(acirc.id), acirc.duration_rule, acirc.recurring_fine_rule, acirc.max_fine_rule, aou.name FROM action.circulation acirc JOIN actor.org_unit aou ON aou.id = acirc.circ_lib GROUP BY 2, 3, 4, 5 ORDER BY 2, 3, 4, 5